Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire...

Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@1483de4 -- timeout at awaitAvailable()

 

把spring-dao.xml中

<property name="maxPoolSize" value="30"/>
改成

<property name="maxPoolSize" value="40"/>
运行正常，不抛出异常
再重新改回

<property name="maxPoolSize" value="30"/>
运行正常，没有异常

有可能是多运行几次，就不会有异常了？不能解决

解决办法
将url加上autoReconnect=true&rewriteBatchedStatements=TRUE

jdbc.url=jdbc:mysql://127.0.0.1:3306/seckill?useUnicode=true&characterEncoding=utf8&autoReconnect=true&rewriteBatchedStatements=TRUE

转载于:https://www.cnblogs.com/songsongblue/p/10039139.html