tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: Db connection issue due to firewall
Date Wed, 26 Aug 2009 19:45:56 GMT
-----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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message