my dog learned polymorphism*
The moose likes Servlets and the fly likes importance of closing the connection object Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "importance of closing the connection object" Watch "importance of closing the connection object" New topic
Author

importance of closing the connection object

lusha tak
Ranch Hand

Joined: Dec 30, 2000
Posts: 185
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

Joined: Dec 30, 2000
Posts: 185
Please have a look at the above stated problem of mine...
thanks
Lusha
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: importance of closing the connection object
 
Similar Threads
how will i receive my certificate????
thread safety issue.......
conversion from decimal to hex/octal
took 6 months to start & 1 month to finish!!!
problem with result set,if multiple users access the application