tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thomas <ma...@apache.org>
Subject Re: Db connection issue due to firewall
Date Wed, 26 Aug 2009 18:44:43 GMT
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.

Mark


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message