0 Replies Latest reply on Jun 23, 2004 4:25 PM by pescador_bob

    Connection handle has been closed and is unusable

    pescador_bob Newbie

      Recently We moved our application to DB2 and Jboss 3.2.3 from MS SQL. Since then I have begun to receive the following error consistently in the same place:

      Caused by: java.sql.SQLException: Connection handle has been closed and is unusable
       at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:771)
       at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:756)
       at org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:136)
       at com.marketron.common.persistence.Record.read(Record.java:87)
       ... 101 more

      I've seen several proposed solutions from Google, such as:

      <check-valid-connection-sql>select * from ar_setup_general</check-valid-connection-sql>

      But when I put in these changes I still receive the exception. Anybody have any ideas on this?