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 Martin Gainty
message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Tue, 7 Jul 2009 12:31

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 Smith wrote: > Do you hold on to your connections in code or do you close t

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, ev

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 wo

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

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 ap

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

Re: DBCP and Firewall timeouts

2009-07-01 Thread David Smith
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" -David AD wrote: > would that simply be the testOnBorrow ? Is there a perf hit for this ? > > > > On Wed, Jul 1, 2009 at 4:00 AM,

Re: DBCP and Firewall timeouts

2009-07-01 Thread AD
would that simply be the testOnBorrow ? Is there a perf hit for this ? On Wed, Jul 1, 2009 at 4:00 AM, Mark Thomas wrote: >> --- Original Message --- >> From: AD >> To: Tomcat Users List >> Sent: 01/07/09, 04:37:26 >> Subject: DBCP and Firewall timeouts >> >>  Is there a recommended c

Re: DBCP and Firewall timeouts

2009-07-01 Thread Mark Thomas
> --- Original Message --- > From: AD > To: Tomcat Users List > 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 or are sanity checked for > proper connectivity?