can't auto connect

[huangqingqing]

In jboss4.03 ; I config the datasource with msql-ds.xml ;but if the mssql server disconnect ; jboss can't auto connect the mssql server I must start up the jboss server again . why and how can i do ? thank:)

[huangqingqing]

sorry , I use the jboss4.02 not jboss4.03

[weston.price]

You will want to take a look at:

http://wiki.jboss.org/wiki/Wiki.jsp?page=WhatHappensToJBossIfIRestartTheDatabase

Of course, you will want to configure the ValidConnectionChecker (or new-sql or valid-connection sql) appropriately.

[huangqingqing]

ok,thank :)

[mura]

Hi, thanks for your suggestion to use ValidConnectionChecker interface or <check-valid-connection-sql> element in *.ds.xml.

But there is a significant performance degradation in our application after using either of these approaches.

Do we have any other alternative approach to handle this situation?

Thanks.

[weston.price]

JBoss 4.0.5 introduces 'background' or asynchronous validation checking. This will be in the final release, however, there is nothing stopping you from checking out the 4.0.5 latest code and using it today. Explanation of how to use it are on the Wiki.