Hello everyone,
I am having a continuous problem with a connection pool namely at one point or another it runs out of connections.
Initially I had the pool initiated from within my own code but after reading one of the articles in
java ranch journal I set it up at the container and also changed my code to close the connections as soon as they are not needed.
I am still having problems even thought I have adjusted upward all parameters, maxActive is 800 and maxIdle is 35 to try to keep as many connections as need available but I am still having issues. I am using
Tomcat 4.0 the pool is configured as a JNDI resource at the container level and is for MySQL.
Here is the message:
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:103)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
I was wondering if you may have some ideas, namely at this point I am looking for a way to monitor the number of connections over time so that I can put this behaveour in context with the traffic on the site, that is if you do not have a better idea.
Thank you.
george