DBCP getConnection hangs

[Chandri Krishnan <ch...@gmail.com>]

Hi all,

I have code that closely mirrors ManualPoolingDataSourceExample.java
that creates a connection pool and returns a connection from it. This
is in a web application running on Tomcat 5.5.7, JDK 1.5.0_09, DBCP
1.2.1 and Oracle 9i. The dataSource.getConnection sometimes takes upto
10 minutes to return a connection. Once getConnection returns, the
query runs normally and returns the correct data. This happens all the
time for the first request after a long interval (say 2 hours).

This application is in a test environment and gets very less traffic
(perhaps 10 requests in a day), so abandoned connections is not a
problem. In any case, I have maxActive=20, removeAbandoned=true and
logAbandoned=true as connection properties. Can anyone suggest how to
troubleshoot this? Thanks in advance.

FYI, I had to write the connection pool code myself, instead of
setting it up as a Resource in Tomcat, since this code needs to be
shared with a stand alone application.

Regards,
Chandri

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org