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
要调整一下数据库连接池参数:
<property name="acquireRetryAttempts"> <value>30</value> #尝试30次 </property> <property name="acquireRetryDelay"> <value>100</value> #每100ms尝试一次 </property> <property name="breakAfterAcquireFailure"> <value>false</value> </property>
|