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

最新推荐文章于 2024-08-26 09:30:00 发布

jife123

最新推荐文章于 2024-08-26 09:30:00 发布

阅读量5.2k

点赞数

分类专栏： SSH学习文章标签： exception c3p0 nested jdbc google

本文链接：https://blog.csdn.net/jife123/article/details/4359757

版权

SSH学习专栏收录该内容

9 篇文章 0 订阅

订阅专栏

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>