0 Replies Latest reply on Dec 16, 2003 8:43 AM by Michael Arnett

    check-valid-connection-sql fails to reconnect when database

    Michael Arnett Newbie

      Hi All,
      I am using JBoss 3.2.1 with MS SQL Server. I am using the MS JDBC drivers. Basically, if I stop the database and restart it I expect the Connection Pool for the database to reconnect when possible. However, what I am seeing is that if the datasource includes a check-valid-connection-sql element, then this does not work. However, it does seem to work fine without the check-valid-connection-sql element. That is the database connections reconnect whenever the database becomes available.

      Here is an excerpt from mssql-ds.xml
      <valid-connection-sql>select count (*) from aConnectionTestTable</valid-connection-sql>