Use a validationQuery when creating your connection pools. This can be
defined where you define your resource.
<parameter>
<name>validationQuery</name>
<value>select 1</value>
</parameter>
On Fri, 18 Jun 2004, Tim Freeman wrote:
> Date: Fri, 18 Jun 2004 14:57:01 -0700
> From: Tim Freeman <[EMAIL PROTECTED]>
> Reply-To: Tomcat Users List <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: How to recover from a database server restart when using
> connection pools?
>
>
> I am using database connection pooling and I would like my Tomcat
> server to be able to cope gracefully with the database server being
> stopped and restarting. This creates a confusing situation because
> the connections in the pool all become invalid in that case.
>
> Is there a standard way to deal with this? Googling around didn't
> turn up anything, but it's surely a common situation. I must have
> searched for the wrong keywords.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
