c3p0运行一会儿就报错！

Question

2011-5-11 16:28:15 com.mchange.v2.resourcepool.BasicResourcePool removeResource
INFO: A checked-out resource is overdue, and will be destroyed: com.mchange.v2.c3p0.impl.NewPooledConnection@153f5e2
2011-5-11 16:28:15 com.mchange.v2.resourcepool.BasicResourcePool removeResource
INFO: Logging the stack trace by which the overdue resource was checked-out.
java.lang.Exception: DEBUG ONLY: Overdue resource check-out stack trace.
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:543)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:681)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:608)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
-------------------------------------
以下配置文件
c3p0.minPoolSize=3
c3p0.maxPoolSize=50

c3p0.testConnectionOnCheckout=true
#c3p0.testConnectionOnCheckin=true

#c3p0.checkoutTimeout=2000
#c3p0.idleConnectionTestPeriod=5
c3p0.maxConnectionAge=10
#c3p0.maxIdleTime=2
#c3p0.maxIdleTimeExcessConnections=1
#c3p0.propertyCycle=1
#c3p0.numHelperThreads=10
c3p0.unreturnedConnectionTimeout=15
c3p0.debugUnreturnedConnectionStackTraces=true
c3p0.maxStatements=50
c3p0.maxStatementsPerConnection=5

 

 

我检查过,好像没有连接没被关掉...

Answer 1

我觉得是应该是你的maxIdleTime设置时间太短了，刚刚idle还没被relace的connection，checkout的时候结果超时了

Answer 2

报错不至于吧？应该是网站超慢，关闭session

Answer 3

连接没关掉这不属于连接池的事哦，是应用代码的问题吧