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)