配置mybitis连接mysql的时候出现了bug,显示日志如下:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
看了半天原因是配置的jdbc连接驱动版本过低造成的,我们更换一下pom.xml的连接驱动的版本为高版本就可以了
<!-- Mybatis和数据库 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<!-- MySql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.13</version>
</dependency>
同时我们更换application.yml里面的配置驱动
com.mysql.jdbc.Driver更换新驱动为com.mysql.cj.jdbc.Driver
spring:
datasource:
username: root
password: 123456
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC&autoReconnect=true&failOverReadOnly=false
driver-class-name: com.mysql.cj.jdbc.Driver
更换完毕后重启项目测试接口
正常返回数据
完毕!