Connection handle has been closed and is unusable

[lee_yuki2000]

Hi,
I am using Jboss 3.2.1 and i have this problem sometimes java.sql.SQLException: Connection handle has been closed and is unusable. Does anyone know what's the problem? Thank you in advance

[adrian.brock]

Sounds like you are trying to use a connection after you or jboss closed it.
If JBoss closed it you will see a warning on the console.

Regards,
Adrian

[nivek]

I have the same problem. I posted the issue previously, but did not get any responses.

http://www.jboss.org/index.html?module=bb&op=viewtopic&t=45648

[leonardobarros]

I have the same problem, My problem was in one part of the code I didn´t close the connection.
I put finally in mine methodos to close the connection and the problem was solved.

Regards
Leonardo Barros. - Brazil

[lee_yuki2000]

Hi,
Thanks for your reply. Now i am using jboss-3.2.3. I still get the error even though i've closed the connection in finally statement. I have a few sql statements in a method and it seems like jboss closed the connection before the all the queries are being executed. Anyone know why? Pls help. Thanks alot

[sctom123]

I have meet the same problem.I have solve it.
before encounter this problem. you probley(?) see a exception "a connection for you. Please close them yourself" in your jboss's server log.
I see a forum in "http://www.jboss.org/index.html?module=bb&op=viewtopic&t=58143&start=0&postdays=postDays&postorder=postOrder&highlight=highlight",
and "http://www.jboss.org/wiki/Wiki.jsp?page=WhatDoesTheMessageDoYourOwnHousekeepingMean"