Re: Dbcp // Validation query timeout

2007-05-13 Thread Greg Hawkes
Hi Adam, Funny you should ask... I have recently been wondering that exact same thing. In my case, a very, very slow validation query (approx 1.7 hours!) was causing Tomcat to crash. All 150 Tomcat worker threads were eventually consumed, waiting for DBCP to return a connection. Now, I have

Re: Dbcp // Validation query timeout

2007-05-13 Thread Phil Steitz
On 5/11/07, Tworkiewicz, Adam [EMAIL PROTECTED] wrote: Hi, We use dbcp for connection pooling in our application that talks to Oracle 10g RAC (2 nodes). Our dbcp config is attached below. We are seeing undesired behaviour when we test db failover. Since we use load balancing connections in the

Re: Dbcp // Validation query timeout

2007-05-13 Thread Phil Steitz
On 5/11/07, Greg Hawkes [EMAIL PROTECTED] wrote: Hi Adam, Funny you should ask... I have recently been wondering that exact same thing. In my case, a very, very slow validation query (approx 1.7 hours!) was causing Tomcat to crash. All 150 Tomcat worker threads were eventually consumed, waiting

Dbcp // Validation query timeout

2007-05-11 Thread Tworkiewicz, Adam
Hi, We use dbcp for connection pooling in our application that talks to Oracle 10g RAC (2 nodes). Our dbcp config is attached below. We are seeing undesired behaviour when we test db failover. Since we use load balancing connections in the pool point to both db servers. When we shutdown one of