tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Smith <d...@cornell.edu>
Subject Re: DBCP and Firewall timeouts
Date Wed, 01 Jul 2009 14:49:42 GMT
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, Mark Thomas<markt@apache.org> wrote:
>   
>>> ------- Original Message -------
>>> From: AD <straightflush@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 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 on borrow.
>>
>> Mark
>>
>>
>>     


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message