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
