New to Java

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBCP - Cannot get a connection, pool exhausted

807597Mar 17 2005 — edited Mar 19 2007

Hi everyone,

I am using the Apache Jakarta Project - Database Connection Pool ( DBCP ) with my Tomcat 5.0.

I have set the maxActive parameter value to 4 and maxIdle parameter value to 2.

I received - Cannot get a connection, pool exhausted, Caused by: java.util.NoSuchElementException: Timeout waiting for idle object.

It does not happen all the time, just happened about 20 times during 2 hours time at that particular day.

I checked against my data in my database, the insert and update statements still can run as expected, meaning data was not lost, data was being inserted and updated to the database.

I have increased the maxActive parameter value to 6. I have also added in indexing to my database table's field.

Does anyone of you have any ideas or opinion on the issue that I am facing?

Thank you very much

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2007

Added on Mar 17 2005

14 comments

2,650 views