idle « Connection « JPA Q&A

1. Hibernate c3p0 connection pool not timing out idle connections

We have a java server connecting to a MySQL 5 database usingHibernate as our persistence layer which is using c3p0 for DB connection pooling. I've tried following the c3p0 and hibernate documentation:

2. Idle connections - don't these ever go away

Beginner Joined: Thu May 28, 2009 10:25 am Posts: 21 Recently, I noticed that my PostGreSQL / Hibernate / C3P0 / JBoss / EJB framework hangs on to connections even after work is complete. Further more, when using C3P0, after cleanup (set to a small time interval) , the connection count still remains above the minimum pool size. Over time, the ...

3. db connection won't reopen after being idle for a day

After my tomcat server has been running successfully for a day I get the below stacktrace. All the forums I've read say that the solution is just to configure c3p0, but I thought I had. i.e. This is my hibernate.cfg.xml file: com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/togetherdining user pass org.hibernate.dialect.HSQLDialect