Connection in Hibernate

inoel131081 · **Joined:** Sun Dec 21, 2003 9:18 pm **Posts:** 21

Hi ,

I am develping a webapplication with hibernate. And my resin keep throwing me this error :

[04:55:35.254] Closing dangling connections. All connections must have a close(
) in a finally block.
[04:55:35.264] java.lang.IllegalStateException: Connection com.caucho.sql.Manage
dConnectionImpl@878c4c was not closed. Connections must have a close() in a fina
lly block.
[04:55:35.264] at com.caucho.jca.UserTransactionImpl.abortTransaction(UserTrans
actionImpl.java:244)
[04:55:35.264] at com.caucho.jca.UserTransactionProxy.abortTransaction(UserTran
sactionProxy.java:175)
[04:55:35.264] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFil
terChain.java:191)
[04:55:35.264] at com.caucho.server.dispatch.ServletInvocation.service(ServletI
nvocation.java:221)
[04:55:35.264] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.
java:253)
[04:55:35.264] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:3
05)
[04:55:35.264] at com.caucho.util.ThreadPool.run(ThreadPool.java:273)
[04:55:35.264] at java.lang.Thread.run(Thread.java:534).

I am sure that I have closed open session in hibernate. So I was wondering if there a good way to check whether there are still unclosed connection in hibernate.

emmanuel · **Posted:** Sat Jan 31, 2004 7:57 am

debug log level should show you that

gpani · **Posted:** Sun Mar 28, 2004 9:18 pm

inoel131081 wrote:

I am sure that I have closed open session in hibernate. So I was wondering if there a good way to check whether there are still unclosed connection in hibernate.

If you are using Resin connection pooling, you can turn on SQL logging in your resin.conf file and see which process may be closing a connection leak.