I am new to hibernate and c3p0. I'm having an issue with a client's site. About 12:00 am their database does a backup and all the hibernate connections time out. The next morning when the client tries to connect the database, the application crashes because their are no connections left.
Here is some of logging from the server
2009-Aug-18 08:08:39:828 com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinAll():297 DEBUG - checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 0; checked out: 0; num connections: 0; num keys: 0 2009-Aug-18 08:08:39:828 com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.acquireResource():217 DEBUG - com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager@108e246.acquireResource() returning. 2009-Aug-18 08:08:39:828 com.mchange.v2.resourcepool.BasicResourcePool.trace():1644 DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@108e25d [managed: 10, unused: 10, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@fb438e)
I am unsure how to solve this problem. Please help.
|