tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rhonny David <rhonnyda...@yahoo.com>
Subject how to refresh connection pool before it gets completely busy
Date Wed, 02 Feb 2011 06:53:20 GMT
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://10.22.4.30/XYZ" />


Can anyone help how we can achieve this , that connection pool refreshes before 
all connections get busy?

Regards,
David



      
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message