Re: how to refresh connection pool before it gets completely busy
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: maxWait="1" 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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: how to refresh connection pool before it gets completely busy
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: > > > auth="Application" removeAbandoned="true" logAbandoned="true" > removeAbandonedTimeout="120" validationQuery="select 1" > driverClassName="net.sourceforge.jtds.jdbc.Driver" maxActive="60" > maxIdle="20" > maxWait="1" 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? Does your application have a connection leak? p 0x62590808.asc Description: application/pgp-keys signature.asc Description: OpenPGP digital signature
Re: how to refresh connection pool before it gets completely busy
2011/2/1 Rhonny David : > http://commons.apache.org/dbcp/mail-lists.html http://commons.apache.org/dbcp/configuration.html Best regards, Konstantin Kolinko - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: how to refresh connection pool before it gets completely busy
Hi Rhonny, Can anyone help how we can achieve this , that connection pool refreshes before all connections get busy? You might want to check jdbc-pool, which sovles some of the problems with dbcp: http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html Regards, Ognjen - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
how to refresh connection pool before it gets completely busy
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: Can anyone help how we can achieve this , that connection pool refreshes before all connections get busy? Regards, David
how to refresh connection pool before it gets completely busy
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: Can anyone help how we can achieve this , that connection pool refreshes before all connections get busy? Regards, David