Hi guys,

I'm using Hibernate version 3.1.2+c3p0 0.9.0.4 with MySQL 5.18 nt. I've created a wrapper class to encapsulate a Session Factory in the context scope of a webapp. It all works fine, sessions are produced just as easy, but then, A FEW HOURS later, it all dies silently.

I've checked timeouts everywhere. The timeouts of the database are set to 8hrs, but the SessionFactory becomes unusable before that time and not so quickly for us to catch it in error. In the Hibernate config it's set to 0.

All the code is between sessionFactory.openSession() and session.close(), and session.close() is in a finally clause, so it's mandatory, it's not exhausting sessions.

Any clues?

Many thanks,
Wellington