今天在本机报项目时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> |

本文解决了一个关于C3P0连接池在关闭连接时出现的异常问题,并提供了一种有效的配置修改方案。
7018

被折叠的 条评论
为什么被折叠?



