Estou usando C3P0 com Hibernate e sempre que o C3P0, vai finalizar uma conexão do Pool,
ele lança a seguinte exception:
java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:491)
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:191)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE
Meu hibernate.cfg.xml está assim:
<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="c3p0.timeout">5000</property>
<property name="show_sql">false</property>
<property name="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property>
<property name="current_session_context_class">thread</property>
Meu c3p0.properties está assim:
c3p0.initialPoolSize=1
c3p0.minPoolSize=1
c3p0.maxPoolSize=5
c3p0.maxIdleTime=180
c3p0.maxStatements=0
c3p0.maxStatementsPerConnection=10
c3p0.acquireIncrement=1
c3p0.idleConnectionTestPeriod=60
c3p0.checkoutTimeout=5000
c3p0.acquireRetryDelay=1000
c3p0.acquireRetryAttempts=1
c3p0.breakAfterAcquireFailure=false
c3p0.maxIdleTimeExcessConnections=30
c3p0.numHelperThreads=3
c3p0.debugUnreturnedConnectionStackTraces=false
c3p0.unreturnedConnectionTimeout=0
Desde já agradeço galera.