2 Replies Latest reply on Apr 29, 2004 11:03 AM by saleti

    Connection handle has been closed and is unusable issue

    saleti Newbie

      I am using Jboss 3.2.1 and i sometimes get java.sql.SQLException: Connection handle has been closed and is unusable.
      Our firewall is setup to close connection to database that are idle for an hour.
      Does including <check-valid-connection-sql> option in ds.xml going to solve the problem i have. I already have "<exception-sorter-class-name>" set in my ds.xml.

      Thanks,
      - Sushma.