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]

Reply via email to