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