Hibernate c3p0 connection pool not timing out idle connections?

Make sure that c3p0 really is starting by examine the log. I, for some reason, had two versions of hibernate (hibernate-core3.3.1. Jar and hibernate-3.2.6GA.

Jar) on my classpath. I also used hibernate annotatations version 3.4.0GA which is not compatible with 3.2.x. (dont know if that had something to do with the original problem).

After removal of one of the hibernate jar's (cant remember which I deleted, probably hibernate-3.2.6GA. Jar) c3p0 finally started and I got rid of the annoying com.mysql.jdbc.exceptions. Jdbc4.

CommunicationsException that happend efter 8h inactivity.

We are using 2.6 with 3.4.0GA and we don't have any noticeable exceptions (do the issues only come up when dealing with c3p0 after 8 hours or would we notice otherwise). We are seeing C3P0 being configured and used in our logs (once I turned logging on with c3p0. Properties) e.g."INFO Initializing c3p0 pool... com.mchange.

V2. C3p0. PoolBackedDataSource ... idleConnectionTestPeriod -> 20, , maxIdleTime -> 60... " – Dougnukem Sep 3 '09 at 19:32 try upgrade hibernate to 3.3. X, the above combination is not supported by hibernate.

(or downgrade hibernate annotation) – Schildmeijer Sep 4 '09 at 12:05 tried anything? Any luck yet? – Schildmeijer Sep 6 '09 at 8:19 1 ok, interesting.

As far as I can see the only thing you added was hibernate.connection. Provider_class=org.hibernate.connection. C3P0ConnectionProvi?

Der? – Schildmeijer Sep 25 '09 at 6:18 1 I know I'm lat on this question but this could be useful to people looking for answers : it seems that this provider_class parameter was added in 3.2 and is now required, but not very much documented. See agileapproach.

Com/blog-entry/… – Pierre Henry Oct 22 '10 at 9:31.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.