错误问题描述 :
HTTP Status 500 – Internal Server Error
Type Exception Report
Message Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException:Connections could not be acquired from the underlying database!
解决方法:
1、修改resources中的jdbc.properties文件
#数据库驱动
jdbc.driver=com.mysql.cj.jdbc.Driver
#数据库地址
jdbc.url=jdbc:mysql://127.0.0.1:3306/purchase?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC&useSSL=false
注意:
时区:serverTimezone=UTC
ssl:useSSL=false
2、修改pom.xml文件
<!-- 数据库 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
<scope>runtime</scope>
</dependency>
在更换完pom.xml文件后一定要重新加载一下,不然新修改的东西无法生效
此处我的MySQL版本是8.0.11,记得修改为你自己的版本;
查看MySQL版本:
这错误花了我好长时间,最终通过还是被我们解决了!
在失败的路上不断前进,如是而已