Whenever you want to do JDBC on your own in EJBs
your procedure should usually be like that...
1. Get the Datasource from JNDI (not sure if can be cached like Remote EJBs)
2. Get a Connection from the Datasource
3. Create whatever Statements (Prepared or not) you need and execute them.
4. Close all Statements with .close()
5. !!!!! Close the Connection with .close()
If you dont close the connection you get those messages.
use a try/catch/finally block when you are working on connections and close all statements and connecitons in the finally block.
You can turn off the housekeeping by setting
"SpecCompliant" to true in transation-service.xml.
That would get ride off the messages, but you still need to review your code to add those missing close
statements as mention aboved.