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

最新推荐文章于 2021-02-28 12:30:09 发布

最新推荐文章于 2021-02-28 12:30:09 发布 · 187 阅读

文章标签：

#java

本文介绍了一个关于C3P0连接池的问题及解决方案，主要针对出现无法创建事务和资源池关闭或损坏的情况。通过调整配置参数，如重试次数、延迟时间和失败后的处理方式，有效解决了这一问题。

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>