tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Filip Hanik - Dev Lists <devli...@hanik.com>
Subject Re: how to refresh connection pool before it gets completely busy
Date Mon, 07 Feb 2011 18:35:14 GMT
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


Mime
View raw message