[c3p0-users] Exceptions while trying to close a PooledConnection

[Christian P. <cm...@cs...>]

Hi,

I am using c3p0 in conjunction with Hibernate on an Informix database 
and I get an Exception if I do not use the
application for a while. It appears c3p0 has a problem closing a 
connection.
Any idea what could cause this problem? I am using c3p0-0.9.1-pre11.jar, 
the latest version.

Thanks.
Christian

2007-01-17 15:46:27,453 
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] INFO  
impl.NewPooledConnection - [c3p0] Exceptions occurred while trying to 
close a PooledConnection's resources normally.
2007-01-17 15:46:27,500 
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] INFO  
impl.NewPooledConnection - [c3p0] NewPooledConnection close 
Exception.java.sql.SQLException: System or internal error 
com.informix.asf.IfxASFException
        at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:430)
        at com.informix.jdbc.IfxSqliConnect.close(IfxSqliConnect.java:1337)
        at 
com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:474)
        at 
com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:191)
        at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:431)
        at 
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:928)
        at 
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
2007-01-17 15:46:27,500 
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] WARN  
resourcepool.BasicResourcePool - Failed to destroy resource: 
com.mchange.v2.c3p0.impl.NewPooledConnection@14af469
java.sql.SQLException: Some resources failed to close properly while 
closing com.mchange.v2.c3p0.impl.NewPooledConnection@14af469
        at 
com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:496)
        at 
com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:191)
        at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:431)
        at 
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:928)
        at 
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)


I configured it as described in
the Hibernate documentation as follows:
hibernate.c3p0.max_size 10
hibernate.c3p0.min_size 2
hibernate.c3p0.timeout 5000
hibernate.c3p0.max_statements 100
hibernate.c3p0.idle_test_period 3000
hibernate.c3p0.acquire_increment 2
hibernate.c3p0.validate false


-- 
------------------------------------------------------------------------
Christian Pich, Ph.D.
University of Oregon
Zebrafish Information Network
Email: cm...@cs...
Web: http://www.zfin.org
------------------------------------------------------------------------