commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravi116 <ravi.varan...@countrywide.com>
Subject Re: DBCP connection pool problem
Date Tue, 29 May 2007 16:44:13 GMT

Niall,

I am encountering a similar issue with DB2. Running our appln inside of
Tomcat/Spring JDBC. Niall - Did u resolve/find out more abt the issue ? Any
help is appreciated.


Ravi


Niall Gallagher-3 wrote:
> 
> Hi All,
> 
> I am using the latest commons DBCP library (1.2.1) as our connection 
> pooling solution for an Oracle DB. However I am encountering a strange 
> issue where under certain conditions DBCP seems to open an excessive 
> amount of connections to the DB. We are not sure exactly what is causing 
> the problem but we suspect that it is the Evictor task within the 
> commons-pool library.
> 
> When the issue occurs the TNS listener logs for Oracle show an massive 
> growth in the number of connections being attempted. For instance here 
> is the activity over a couple of minutes.
> 
> 03-JAN-2007, 16:48, db1, 192.168.1.35, 52858
> 03-JAN-2007, 16:49, db1, 192.168.1.35, 61696
> 03-JAN-2007, 16:50, db1, 192.168.1.35, 61107
> 03-JAN-2007, 16:51, db1, 192.168.1.35, 61475
> 03-JAN-2007, 16:52, db1, 192.168.1.35, 61446
> 
> On average about 60,000 connections a minute. We are quite certain this 
> is caused by DBCP as this is the only means of accessing DB connections 
> within our applications and we log before and after the 
> DataSource.getConnection method (our logs show no repetitive log 
> statements).  Has anyone seen such an issue before? Any help on this 
> would be greatly appreciated.
> 
> Thanks,
> Niall
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/DBCP-connection-pool-problem-tf3039220.html#a10857802
Sent from the Commons - User mailing list archive at Nabble.com.


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


Mime
View raw message