Hello,
I have a question about database connections. Should I or shouldn't I close
all resultsets, statements after I've used them ? I've read that it's very
important to do this because it may slow down your server if you don't close
them and let the GC handle it (or timeout). But if I do this, close all my
resultsets and statements, the server slow down and eventually hangs. If I
don't it runs fine most of the time and just slows down one in hundredth of
the times it did before.
I recently changed from JDBC-ODBC bridge to another driver and then it works
smoother but it still hangs from time to time.
Could someone give me some hints about the following things:
- When should I close my resultsets, statements and connections in
comparrison to commit (I use auto commit off) and each other ?
- Would a connection pool servlet solve this problem ? I've read that
connection pooling is buildt in in JDBC 2.0.
- What about thread safetyness and databases ?
Thanks for any help !
Daniel Ronnqvist
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
