Hi,
I found the solution:
Use the validationQuery attribute data source definition.
For MSSQL it would be something like this:
<Resource name="jdbc/blah"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://xxx.xxx.xxx.xxx:1433;DatabaseName=blah"
username="blah"
password="blah"
maxActive="10"
maxIdle="10"
maxWait="-1"
validationQuery="select 1" />
Regards,
Stojan Sljivic
> -----Original Message-----
> From: Stojan Sljivic - GDS [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 22, 2006 10:43
> To: [email protected]
> Subject: Tomcat 5.5.9 data source and DB restart issue
>
>
> Hi,
>
> I have a problem with Tomcat 5.5.9 data source:
> When the database (MSSQL in this case) is restarted, data
> source throws the exception.
>
> I have to restart the Tomcat in order to fix this issue.
>
> Can anyone help me with this? Is this a regular behavior or a bug?
>
> Regards,
> Stojan Sljivic
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
