连接MySQL： Connections could not be acquired from the underlying database

最新推荐文章于 2022-09-14 11:38:10 发布

dong0023

最新推荐文章于 2022-09-14 11:38:10 发布

阅读量342

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/dong0023/article/details/118466673

版权

博客内容讲述了在SSM项目中遇到连接MySQL8.0数据库失败的问题，错误信息显示无法从底层数据库获取连接。问题根源在于项目使用的mysql-connector-java版本过低，与数据库版本不匹配。解决方案是将mysql-connector-java的依赖升级到8.0.16版本，从而解决了数据库连接问题。

摘要由CSDN通过智能技术生成

项目场景：

ssm项目连接mysql 8.0 报错：Connections could not be acquired from the underlying database!

问题描述：

### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
### The error may exist in file [F:\i_code\bobssm\target\classes\mapper\BookMapper.xml]
### The error may involve com.bob.dao.BookDao.queryById
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

原因分析：

发现项目里引用的mysql-connector-java 版本还是5.1.37，但是所用的mysql是8.0版本的

解决方案：

使用8.0版本的 mysql-connector

		<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.16</version>
            <scope>runtime</scope>
        </dependency>