0 Replies Latest reply on Nov 14, 2005 12:31 PM by madeonmoon

    Behind the scenes of check-valid-connection-sql

    madeonmoon

      Hello All,

      If I use <check-valid-connection-sql> config param in my-ds.xml to check for stale pool connections, the call to the database gets blocked for 5000 milliseconds due to a default setting of <blocking-timeout-millis>. Given that the database is down and the pool connection is stale, what exactly happens within this 5 seconds of being blocked? Are there reconnection attempts?

      Thanks a lot
      James