RE: Tomcat 5.5.9 data source and DB restart issue

[Stojan Sljivic - GDS]

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: users@tomcat.apache.org
> 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]