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<[email protected]> wrote: > >>> ------- Original Message ------- >>> From: AD <[email protected]> >>> To: Tomcat Users List <[email protected]> >>> 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: [email protected] For additional commands, e-mail: [email protected]
