-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Mark,
On 8/26/2009 2:44 PM, Mark Thomas wrote: > Christopher Schultz wrote: >> Chandra, >> >> On 8/25/2009 11:56 PM, chandra ganta wrote: >>> We use a db datasource for one of our applications. >>> The issue is that there is a firewall between tomcat server 5.5 & db server >>> (ORACLE 9i), that cuts pool connections after 1 hour of ideal time. >> >>> We've tried several configuration using : >>> validationQuery >> >> This should be all that is required. Can you post your whole configuration? > > You'd need testOnBorrow as well but those two together should fix it - > assuming > the app doesn't hang on to connections for more than an hour without using > them. testOnBorrow is true by default, no? - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkqVkPMACgkQ9CaO5/Lv0PBMDACbBEMj3wTo7keVczYydIPnenHy YH0AoJJ+HJWjhTgzBEyC6WWCBMXVY23h =gsay -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
