Database Connection Pooling with Tomcat
Subject:   Easier said than done: connection pooling
Date:   2006-10-08 16:53:44
From:   jpower
Response to: More pools for Tomcat

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 finally block:
fnally {


1 to 2 of 2
1 to 2 of 2