0 Replies Latest reply on Sep 9, 2004 4:15 PM by sudhir

    check-valid-connection-sql

    sudhir Newbie

      The admin doc says.
      "A SQL statement that should be run on a connection before it is returned from the pool to test its validity. This allows for the dection of stale pool connections. An example statement could be “select count(*) from x "
      Does this mean that this sql is executed every time i call the datasource.getConnection (say in a session bean). This sounds like an ineffecient way to achieve transparent failover. The exception sorter misses out on one transaction. Is there a better way of achieving transparent failover. Theoretically it should be possible to re execute the sql with another connection. Is it possible to do this with jboss.
      I have searched the forum and google and cant find any information about this. Any help will be appreciated