You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by sojin <so...@gmail.com> on 2011/04/09 17:56:29 UTC

How to retry database connection with Tomcat 7 jdbc pool ?

How to configure Tomcat 7 jdbc pool to retry database connection if the DB
goes restarted ? 
With default configurations on alternatives like apache dbcp or bonecp, the
connection gets automatically re-connected when DB back in life. But not
with the Tomcat jdbc with all default configuration. Any help?


-- 
View this message in context: http://old.nabble.com/How-to-retry-database-connection-with-Tomcat-7-jdbc-pool---tp31359736p31359736.html
Sent from the Tomcat - User mailing list archive at Nabble.com.


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


Re: How to retry database connection with Tomcat 7 jdbc pool ?

Posted by sojin <so...@gmail.com>.

Got it, 

testOnBorrow="true" 
validationQuery="select 1" 
validationInterval="10000"

did the trick.


sojin wrote:
> 
> How to configure Tomcat 7 jdbc pool to retry database connection if the DB
> goes restarted ? 
> With default configurations on alternatives like apache dbcp or bonecp,
> the connection gets automatically re-connected when DB back in life. But
> not with the Tomcat jdbc with all default configuration. Any help?
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/How-to-retry-database-connection-with-Tomcat-7-jdbc-pool---tp31359736p31367275.html
Sent from the Tomcat - User mailing list archive at Nabble.com.


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