引入LIB下
mysql-connector-java-8.0.21.jar
mchange-commons-java-0.2.15.jar
c3p0-0.9.5.2.jar
問題：
MYSQL5.7升級后8.0.21版本后，剛開始運行沒問題，到一定時間（約1天）c3p0連接失敗，幾天了分析不到原因了，提示如下
小弟沒分了，少了點，感謝
04-Oct-2020 18:20:53.308 WARNING [pool-96-thread-1] com.mchange.v2.resourcepool.BasicResourcePool. com.mchange.v2.resourcepool.BasicResourcePool@31270a -- an attempt to checkout a resource was interrupted, and the pool is still live: some other thread must have interrupted the Thread attempting checkout!
java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1465)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
at com.Web.common.ConnectionFactory.getConnection(ConnectionFactory.java:71)
at Public.Dm.ProcExec_open(Dm.java:149)
at Servlet.TopSft_WeiXin.doPost_(TopSft_WeiXin.java:140)
at Servlet.TopSft_WeiXin$1.call(TopSft_WeiXin.java:56)
at Servlet.TopSft_WeiXin$1.call(TopSft_WeiXin.java:1)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:74)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:694)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
at com.Web.common.ConnectionFactory.getConnection(ConnectionFactory.java:71)
at Public.Dm.ProcExec_open(Dm.java:149)
at Servlet.TopSft_WeiXin.doPost_(TopSft_WeiXin.java:140)
at Servlet.TopSft_WeiXin$1.call(TopSft_WeiXin.java:56)
at Servlet.TopSft_WeiXin$1.call(TopSft_WeiXin.java:1)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1465)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
uj5u.com熱心網友回復：
包驅動升級，c什么的也升級轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/155568.html
標籤：Web 開發
下一篇：P1013 進制位