[JBOSS] DB-Connection validation

[F. Lorenz]

Hi!


My JBoss 3.0.2 is making transactions via CMP with a DB2.
From timt to time the DB is switched into a suspendmode with an
external tool. Thereby JBoss loses the connection to the DB. The next
query then fails due to the invalid connection.

How to configure the JBoss to validate the connection and, if necessary,
to open a new one before starting a sql-query?

Regards
Frank

 

[Arnaud Berger]

Hi,

I think that this :

<valid-connection-sql>SELECT 1 FROM yourTable</valid-connection-sql>

can be used in the datasource element of the XML.

Regards,

Arnaud