could not passivate

[sdoer]

I'm using hsqldb 1.7.1 and it works fine so far. However, if jboss tries to passivate my ejb - I get:

"javax.ejb.EJBException: Could not passivate; causedByException is: org.jboss.resource.adapter.jdbc.local.LocalConnection ...."

Because of "....jdbc.local.LocalConnection" I assume the problem is caused by the jdbc-datasource. Any ideas or suggestions?

[davidjencks]

Don't hold a reference to a connection, get it each time you need to use it and close it when you are done.

[sdoer]

Well, I found the problem. I've always closed the connection, but of course there was still a reference left. Now I close the connection AND set it to null.