connection.close()

[sysuser1]

I obtained a java.sql.Connection object from a DataSource object. When I try to close the connection object I receive this warning and the jsp page from which causes this close call hangs.

Database in use is Oracle.

2003-07-29 09:51:56,595 WARN [org.jboss.resource.adapter.jdbc.WrappedConnection] Closing a statement you left open, please do your own housekeeping

Any ideas?

TIA

[juhalindfors]

Does it help if you close the statement before you close the connection?

-- Juha

[sysuser1]

No idea. The connection is passed on to another api that actually does the statement thing and that is out of my control.

[darranl]

Which JBoss version are you using?

[frito]

Perhaps it could help to toggle the spec-compliant flag in your transaction-service.xml .

Greetings,
Frito

[jefferykim]

no, I tried to set it as true, it does not help. Any other idea? Or is there any patch for download?

thanks

[darranl]

Which JBoss version are you using?

[sbahal]

I have the similar problem. I use DB2/AS-400 on JBoss- 3.0.7.
I have a BMP. If I call a method in my EJB this methos gets its own Connection. But if this method calls a 2nd method that gets its own Connection and then if the 2nd method tries to close() the Connection- I get this error '... trying to return a unkown connection to JBoss... blah blah blah ...... try to close your own connection.....blah blah blah.
But if I pass the Connection (as obtained in the 1st method) to the 2nd method (so it does not have to get its own)- all works well.
Is this some kind of known behavior?
Thanks
Sanjay

[darranl]

I had the same issue with JBoss 3.0.7, from what I can remember it was raised as a bug on sf.net and fixed for 3.0.8.