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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
