現(xiàn)象

com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@79207381 – timeout at awaitAvailable()

解決

1、驅(qū)動(dòng)配置有誤

driver=com.mysql.jdbc.Driver

2、數(shù)據(jù)庫(kù)連接地址有誤

url=jdbc:mysql://localhost:3306/test?3useUnicode=true&characterEncoding=utf8

配置應(yīng)該加上時(shí)區(qū)

jdbc.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai

3、賬號(hào)密碼有誤

4、數(shù)據(jù)庫(kù)未啟動(dòng)或無(wú)權(quán)訪問(wèn)

5、項(xiàng)目未引入對(duì)應(yīng)的驅(qū)動(dòng)jar包

6、mysql root沒(méi)有遠(yuǎn)程訪問(wèn)的權(quán)限

進(jìn)入mysql數(shù)據(jù)庫(kù)

grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option; flush privileges;

7、jdbc驅(qū)動(dòng)要放到j(luò)re里面

---

轉(zhuǎn)載注明出處：www.meidanlong.com 😃

總結(jié)

以上是生活随笔為你收集整理的c3p0连接mysql异常的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。