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@...> wrote:
>
>>> ------- Original Message -------
>>> From: AD <
straightflush@...>
>>> To: Tomcat Users List <
users@...>
>>> 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@...
For additional commands, e-mail:
users-help@...
