Jboss can not reconnect by itself when database server is shutdown and restart.

(Last modified: 24Feb2006)

This document (10100551) is provided subject to the disclaimer at the end of this document.

symptom

fact

JBoss Application Server 4.0.1

JBoss Application Server 4.0.2

JBoss Application Server 4.0.3

fix

Include the "check-valid-connection-sql" entry in the datasource definition in your deploy folder, /JBossInstallFolder/Server/DeployFolder/deploy (example: C:\Jboss\server\default\deploy)
<check-valid-connection-sql >SELECT 1 </check-valid-connection-sql >

Your datasource connection should look something like this:
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
   <local-tx-datasource>
      <jndi-name>jbossdb</jndi-name>
      <connection-url>jdbc:mysql://mysqlserver:63306/jbossdb</connection-url>
      <driver-class>com.mysql.jdbc.Driver</driver-class>
      <user-name>root</user-name>
      <password>password</password>
| <check-valid-connection-sql >SELECT 1 </check-valid-connection-sql >
   </local-tx-data source>
</datasources>

document

Document Title:	Jboss can not reconnect by itself when database server is shutdown and restart.
Document ID:	10100551
Solution ID:	NOVL105238
Creation Date:	23Feb2006
Modified Date:	24Feb2006
Novell Product Class:	exteNd

disclaimer

The Origin of this information may be internal or external to Novell. Novell makes all reasonable efforts to verify this information. However, the information provided in this document is for your information only. Novell makes no explicit or implied claims to the validity of this information.
Any trademarks referenced in this document are the property of their respective owners. Consult your product manuals for complete trademark information.