Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

importance of closing the connection object

 
lusha tak
Ranch Hand
Posts: 185
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all!
is it true that not closing connection,statement & resultset objects in my servlets & jsp pages can be a reason for slow performance.if yes, please explain why???
secondly, if i use these statements in my jsp/servlets ,sometimes i get errors such as resultset is already closed etc..(my application is hosted on tomcat server)
and please also explain the reason for getting "file not found(404)" error in case such as...

whereas this code runs fine..


[This message has been edited by lusha tak (edited September 24, 2001).]
[This message has been edited by lusha tak (edited September 24, 2001).]
 
lusha tak
Ranch Hand
Posts: 185
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please have a look at the above stated problem of mine...
thanks
Lusha
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic