在使用mybatis连接mysql时报错
myBatis连接MySQL报异常:com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
在确保数据库服务正确打开并连接下
- 确保下载的mysql版本和maven导入的版本一致
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.13</version> *这里是版本号*
</dependency>
2.如果异常中包含乱码即 以下情况
Cause By:The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone
则需要在数据库配置中的url加入时区即可解决
<property name="url" value="jdbc:mysql://localhost:3306/数据库名?serverTimezone=Asia/Shanghai"/>