So, I upgraded to DBCP 1.3 and Commons Pool 1.5 (essentially the latest) and there was an enormous performance increase. (with a decreased number of required connections).
I'm thinking there were some thread contention issues in DBCP/Pool that got resolved. I looked through a bug list, which mentions a number of synchronization related items but couldn't find anything specific that was related. I'll also look into the abandoned pool issue. I saw a note about that in the DBCP docs Thanks, WILL On Tue, Apr 13, 2010 at 12:39 PM, Thomas Vandahl <t...@apache.org> wrote: > On 12.04.10 23:56, Will Glass-Husain wrote: > > I can see that the DBCP connection pool is blocking. With 150 users I > have > > dozens of threads blocked as follows: > [...] > > Any suggestions? > > DBCP supports the abandoned-pool feature which can be configured to > remove objects not returned to the pool after a certain amount of time. > See if that helps. If it does, I'd do a thorough search for free- > floating connections in your code (no finally clause). > > BTW, with 150 users in a normal usage pattern I'd expect the connection > usage to be around 20 maximum. What do your users do? > > Bye, Thomas. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org > For additional commands, e-mail: torque-user-h...@db.apache.org > >