tomcat hangs when connetion pooling used

2008-03-16 Thread Mahesh Viraktamath
Hi, I am using connection pooling for all the database transactions. I am using the following: MySql: 5.0.22 tomcat : 5.5.X Now the problem is when I run the application, it can't get the connnection from the connection pool. I tried everything like dumping all the waiting threads, killing all

Re: tomcat hangs when connetion pooling used

2008-03-16 Thread ib solution
hai, is there any an error page that you can share ?, i am using Mysql 5.0.22 and tomcat 5.5.17 and i am always get a connection -- Salam, Andy Susanto,S.Kom == for better search http://www.slashmysearch.com/earn/id/24828 HP : 081513039998

Re: tomcat hangs when connetion pooling used

2008-03-16 Thread Mahesh Viraktamath
Thats the problem. It doesn't get any error page, it just hangs at the point of getting connection. Can you explain your contex and the datasource resource configuration? On 3/16/08, ib solution [EMAIL PROTECTED] wrote: hai, is there any an error page that you can share ?, i am using Mysql

Re: tomcat hangs when connetion pooling used

2008-03-16 Thread Martin Gainty
or SQL and pls include stacktraces/log infoHTHMartin - Original Message - From: Mahesh Viraktamath [EMAIL PROTECTED] To: users@tomcat.apache.org Sent: Sunday, March 16, 2008 4:54 AM Subject: tomcat hangs when connetion pooling used Hi, I am using connection pooling for all the database

Re: tomcat hangs when connetion pooling used

2008-03-16 Thread Cattapan
Probably you are not closing connections somewhere and the maxWait property of DBCP is not set. The default is to wait indefinitely. So the tomcat is not hang, it's just waiting for a connection, but all of them are used at the moment and it keeps waiting. I believe that if you set a maxWait