I'm using JBoss 3.0.6 and hsqldb 1.7.1. A few minutes after using the ejb I always get a "could not passivate": javax.ejb.EJBException: Could not passivate; CausedByException is: org.jboss.resource.adapter.jdbc.local.LocalConnection ... Because of the "..LocalConnection-exception" I assumed a problem with the connection/datasource/database and commented out all lines of code but creation/closing of the connection/datasource. The error occured again, although I always close (or at least try to close) the connection in the ejbPassivate()! Any ideas, perhaps a property-problem within the hsqldb-service.xml??
Joined: May 20, 2003
Well, I found the problem. I've always closed the connection, but there was still a reference left. Now I close the connection and set it to null.