Hello,
I have a question concerning connection pooling in
Tomcat 6. When you close a connection and it is returned to the pool, is it supposed to stay there indefinitely? Is there a timeout that will kill the connection if it is not reused after a few hours?
After running a query, I make sure to close the statement, result set, and connection in a finally statement. However, if I access the database server (SQL Server) I can see the connection still sitting there after over 24 hours. It is "sleeping," but it is still there. My DBA is concerned because our old
Java server, JRun, would kill these sleeping connections after a couple of hours of inactivity.
Restarting Tomcat removes all sleeping connections.
Thanks,
Dave