Hi,

I am using Hibernate with mysql database in my stand alone program.
I am getting connections problem with my c3p0 connection pool.
My program getting connection from pool but not giving back connection to pool.The maximum connections size given is 150 after getting 147 connections the sever is giving "too many connection" exception and program hangs. I enabled c3p0 log, below are log entries.

[23/01/14 15:12:44:304 IST] impl.C3P0PooledConnectionPool[Method:finerLoggingTestPooledConnection,Line:315] DEBUG Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@47db5ae] on CHECKOUT.
[23/01/14 15:12:44:306 IST] impl.C3P0PooledConnectionPool[Method:finerLoggingTestPooledConnection,Line:319] DEBUG Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@47db5ae] on CHECKOUT has SUCCEEDED.
[23/01/14 15:12:44:307 IST] resourcepool.BasicResourcePool[Method:trace,Line:1644] DEBUG trace com.mchange.v2.resourcepool.BasicResourcePool@690a6013 [managed: 48, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f0f9b31)
[23/01/14 15:12:44:309 IST] resourcepool.BasicResourcePool[Method:trace,Line:1644] DEBUG trace com.mchange.v2.resourcepool.BasicResourcePool@690a6013 [managed: 48, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@f0f9b31)


Please help me thanks in advance.

Regards,
Bhanu