SpringMVC整合中jdbc连接报错

最新推荐文章于 2023-04-05 20:16:41 发布

躺平的阿甘

最新推荐文章于 2023-04-05 20:16:41 发布

阅读量361

点赞数

分类专栏：学习中遇到的错误文章标签： java mysql 数据库

本文链接：https://blog.csdn.net/weixin_43657553/article/details/120354773

版权

在SpringMVC项目中整合MySQL8.0时遇到连接错误，已确认database.properties文件正确，数据库驱动和连接池版本匹配，Artifacts添加了相关依赖，spring-dao配置及引用路径无误。尝试过多种网上解决方案无效。最终通过显式设置数据库连接池属性成功连接。

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

# 错误信息：

### 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 com/dao/BookMapper.xml
### The error may involve com.dao.BookMapper.queryAllBook
### 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!
	java.sql.SQLException: Access denied for user 'Charles'@'localhost' (using password: YES)
		at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
		at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
		at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.jav