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<ma...@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 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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
