What do you mean by "refresh"?
best
Filip
On 2/1/2011 11:53 PM, 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://10.22.4.30/XYZ" />
>
>
> Can anyone help how we can achieve this , that connection pool refreshes before
> all connections get busy?
>
> Regards,
> David
>
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1204 / Virus Database: 1435/3417 - Release Date: 02/01/11
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
|