項目使用c3p0資料庫連接配接池,之前都連接配接的mysql5.7左右版本,自己本地安裝了mysql最新版本,連接配接時一直報錯
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could notacquire a resource from its primary factory or source.
想起之前自己寫的demo項目連接配接本地mysql時需要換成mysql-connector-java-8.0.11.jar中的
com.mysql.cj.jdbc.Driver
新版驅動,更改maven配置
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>
發現還是同樣的報錯。查找問題,c3p0的包也要更新
<dependency>
<!-- 這裡跟舊版配置不同。不改,引用c3p0包會爆紅,找不到-->
<!--<groupId>c3p0</groupId>-->
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
問題解決!