Chandra - The question is better suited for an Oracle group. However, I happen to know the solution - since I do it all here. On your Oracle server, add the following line your sqlnet.ora file: SQLNET.EXPIRE_TIME= 10 Then restart your oracle databases. Jeff
-----Original Message----- From: chandra ganta [mailto:chandrasekhar...@gmail.com] Sent: Tuesday, August 25, 2009 10:56 PM To: users@tomcat.apache.org Subject: Db connection issue due to firewall Hello, 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 testOnBorrow testOnReturn testWhileIdle timeBetweenEvictionRunsMillis numTestsPerEvictionRun minEvictableIdleTimeMillis But that does not solve the problem Could you please give me some advices about the way I have to configure this to get it working ? Best Regards, Chandra ******************************* NOTICE ********************************* This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (call us collect at 512-343-9100) and immediately delete this message and all its attachments. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
