||Database Connection Pooling with Tomcat|
|Subject:||Easier said than done: connection pooling|
Response to: Easier said than done: connection pooling
I specified maxActive=100 and maxIdle=20 for my webapp. But as the app runs, the connections just ramped up. After a while, even if no one was using the app, I saw ~ 30 idle connections there, much bigger than the value of maxIdle. Unless I shutdown Tomcat, the number doesn't get smaller. This is giving me huge headache since I know the app is going to blow up as user keeps using it.
I take special care in closing connections in the finally block:
if (con != null) con.close;
However, I didn't try to close PreparedStatement in finally block because I assume if I close the connection, PreparedStatement will be automaticall closed.