今天在本机报项目时c3p0抛出如下错误:
1 2 3 4 5 6 7 8 9 10 11 | NewPooledConnection - closed by a client. java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:566) at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyRe source(C3P0PooledConnectionPool.java:470) at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:96 4) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.ja va:547) C3P0PooledConnectionPool - Successfully destroyed PooledConnection: com.mchange.v2.c3p0.impl.NewPool |
经过网上搜索,得出如下解决方案:在配置中增加
1 | <property name="preferredTestQuery"><value>SELECT 1</value></property> |
去掉:
1 | <property name="automaticTestTable"><value>c3p0_test</value></property> |