tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pid <>
Subject Re: how to refresh connection pool before it gets completely busy
Date Thu, 03 Feb 2011 11:28:59 GMT
On 02/02/2011 06:53, Rhonny David wrote:
> Dear All,
> We are facing connection pool busy problem in tomcat 6.0.29. Till we finalize 
> our investigation, we need connection pool to be refreshed before all 
> connections get busy. Say for example if we have connection pool size 60, then 
> it should get refresh when 15 connections get busy. We know that we cannot 
> define connection pool should refresh after X connections get busy but we can at 
> least define the timeout for an abandoned connections. We have tried this using 
> the removeAbandonedTimeout property, but still its behaviour is that it 
> refreshes the pool when all connections get busy. Following is the entry of our 
> context.xml file:
> <Resource factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" 
> auth="Application" removeAbandoned="true" logAbandoned="true" 
> removeAbandonedTimeout="120" validationQuery="select 1" 
> driverClassName="net.sourceforge.jtds.jdbc.Driver" maxActive="60" maxIdle="20" 
> maxWait="10000" name="DB_Pool" type="javax.sql.DataSource"  
> url="jdbc:jtds:sqlserver://" />
> Can anyone help how we can achieve this , that connection pool refreshes before 
> all connections get busy?

Does your application have a connection leak?


View raw message