I could make this work with 'validationQuery' parameter. Thanks
-----Original Message----- From: Mark Thomas [mailto:[EMAIL PROTECTED] Sent: Thursday, January 18, 2007 7:08 PM To: Tomcat Users List Subject: Re: Tomcat / DBCP / Oracle / Reconnect Krishna Paparaju wrote: > I am trying to find is there anyway Tomcat can be configured to > reconnect back to DB once it is up. I know autoReconnect flag works for > mySQL. Is there any equivalent in Oracle/thin driver? You could use testOnBorrow="true" and a validationQuery to achieve this. Check the docs for DBCP for details on how to configure this. Mark --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]