0 Replies Latest reply on Oct 30, 2002 12:14 PM by Tim Bauer

    Connection handle is not currently associated with a Managed

    Tim Bauer Novice

      Environment:

      jboss 3.0.3
      mysql 3.23.51
      mm.mysql-2.0.14-bin.jar
      Mac OS X with jdk 1.3.1

      Keeps loosing the connection(?) with our without me doing an explicit close....

      Using a session bean that does direct SQL to the datasource by getting connection from the EJB container. Runs fine for a while but then I eventually get this error:

      07:33:00,231 ERROR [STDERR] An error has happened: SELECT COUNT(*) FROM ShiftRequests where shift_id=119
      07:33:00,231 ERROR [STDERR] java.sql.SQLException: Connection handle is not currently associated with a ManagedConnection
      07:33:00,233 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalConnection.checkStatus(LocalConnection.java:774)
      07:33:00,234 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalConnection.prepareStatement(LocalConnection.java:188)
      07:33:00,234 ERROR [STDERR] at com.icshealth.ejb.session.ICSRegSQLFinderUtilsEJB.getShiftRequestCount(Unknown Source)