解决C3P0又出現一個問題，如下的Exception:

最新推荐文章于 2021-02-16 07:25:40 发布

原创最新推荐文章于 2021-02-16 07:25:40 发布 · 5.4k 阅读

2 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#exception #c3p0 #nested #jdbc #google

SSH学习专栏收录该内容

9 篇文章

订阅专栏

本文介绍了一个关于C3P0连接池出现的问题及其解决方案。问题表现为无法为事务打开JDBC连接，并引发了ResourcePoolException。通过调整配置属性如acquireRetryAttempts、acquireRetryDelay及breakAfterAcquireFailure等参数，可以有效避免资源池关闭或损坏导致的应用异常。

C3P0又出現一個問題，如下的Exception:

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool
Caused by:
java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool

經Google大神裁示，應該再加以下的property，特別是false的部份。

<property name="acquireRetryAttempts">
    <value>30</value>
</property>
<property name="acquireRetryDelay">
    <value>100</value>
</property>
<property name="breakAfterAcquireFailure">
    <value>false</value>
</property>