Re: DBCP and Firewall timeouts

2009-07-10 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 AD, On 7/7/2009 11:47 AM, AD wrote: unfortunately still not working. One thing that i noticed, when i clear my browser cookies, everything works fine again. One of the things we do is use cookie persistence to send a user to the same tomcat

Re: DBCP and Firewall timeouts

2009-07-07 Thread AD
unfortunately still not working. One thing that i noticed, when i clear my browser cookies, everything works fine again. One of the things we do is use cookie persistence to send a user to the same tomcat server (we need this for file uploads,etc). Is there anything in the session cookie that

Re: DBCP and Firewall timeouts

2009-07-07 Thread David Smith
Do you hold on to your connections in code or do you close them when done with each request? If you hold on to them, they can still timeout with or without a validationQuery set. --David AD wrote: unfortunately still not working. One thing that i noticed, when i clear my browser cookies,

Re: DBCP and Firewall timeouts

2009-07-07 Thread AD
we are using Jruby / Rails / Tomcat. I think what may be happening is that rails has its own connection pool in front of DBCP which could be causing the issue here, not sure yet. AD On Tue, Jul 7, 2009 at 12:20 PM, David Smithd...@cornell.edu wrote: Do you hold on to your connections in code

RE: DBCP and Firewall timeouts

2009-07-07 Thread Martin Gainty
and Firewall timeouts From: straightfl...@gmail.com To: users@tomcat.apache.org we are using Jruby / Rails / Tomcat. I think what may be happening is that rails has its own connection pool in front of DBCP which could be causing the issue here, not sure yet. AD On Tue, Jul 7, 2009 at 12:20

Re: DBCP and Firewall timeouts

2009-07-02 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David, On 7/1/2009 5:01 PM, David Smith wrote: Christopher Schultz wrote: David, On 7/1/2009 10:49 AM, David Smith wrote: It would and the performance hit is minimal if you use the ping syntax in your validation query. I believe it looks like

Re: DBCP and Firewall timeouts

2009-07-01 Thread Mark Thomas
--- Original Message --- From: AD straightfl...@gmail.com To: Tomcat Users List users@tomcat.apache.org Sent: 01/07/09, 04:37:26 Subject: DBCP and Firewall timeouts Is there a recommended config of ensuring the connection pool connections either get cleanly terminated

Re: DBCP and Firewall timeouts

2009-07-01 Thread AD
and Firewall timeouts  Is there a recommended config of ensuring the connection pool connections either get cleanly terminated or are sanity checked for proper connectivity?  We are using JRuby/Tomcat/Rails and are seeing a lot of timeouts after inactivity in the app. Use a validation query

Re: DBCP and Firewall timeouts

2009-07-01 Thread David Smith
Thomasma...@apache.org wrote: --- Original Message --- From: AD straightfl...@gmail.com To: Tomcat Users List users@tomcat.apache.org Sent: 01/07/09, 04:37:26 Subject: DBCP and Firewall timeouts Is there a recommended config of ensuring the connection pool connections either get

Re: DBCP and Firewall timeouts

2009-07-01 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David, On 7/1/2009 10:49 AM, David Smith wrote: It would and the performance hit is minimal if you use the ping syntax in your validation query. I believe it looks like this: validationQuery=/* ping */ SELECT 1 Note that both the PING is only

Re: DBCP and Firewall timeouts

2009-07-01 Thread David Smith
Christopher Schultz wrote: David, On 7/1/2009 10:49 AM, David Smith wrote: It would and the performance hit is minimal if you use the ping syntax in your validation query. I believe it looks like this: validationQuery=/* ping */ SELECT 1 Note that both the PING is only applicable for

DBCP and Firewall timeouts

2009-06-30 Thread AD
Hello, We have a tomcat 5.5 server and a mysql 5.1 database sitting between a firewall. The firewall times out connections after 60 minutes. We tried setting the minEvictableIdleTimeMillis to be 30 minutes but we are still seeing these timeouts. Is there a recommended config of ensuring the