db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Vandahl ...@apache.org>
Subject Re: blocking in connection pool
Date Tue, 13 Apr 2010 19:39:07 GMT
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-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message