IDEA搭建spring boot一系列报错解决

最新推荐文章于 2023-02-01 17:27:56 发布

原创最新推荐文章于 2023-02-01 17:27:56 发布

· 483 阅读

0 ·

版权

文章标签：

#java #mysql #spring boot #intellij idea #jdbc

JAVA 专栏收录该内容

5 篇文章

订阅专栏

最近新建一个Spring Boot项目使用maven的install一启动就报错Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.22.2:test (default-test) on project demo: There are test failures.
在这里插入图片描述
下面有两句提示，打开百度翻译

点击对应的报告结果

打开报告文件，这里报错原因大概是dataSource未配置

在SpringBoot对应的application.properties配置#Mysql的链接

再次进行maven的install操作，抛出了下面错误信息

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
2020-06-09 09:07:13.838  INFO 13932 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
2020-06-09 09:07:13.870  INFO 13932 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2020-06-09 09:07:13.880  WARN 13932 --- [           main] com.zaxxer.hikari.util.DriverDataSource  : Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2020-06-09 09:07:15.215 ERROR 13932 --- [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.

java.sql.SQLException: The server time zone value '?й???????' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support.

从上面错误信息可以看出com.mysql.cj.jdbc.Driver是mysql驱动包为8.0才有的，找到maven对应的jar包，果然是8.0，这时修改一下mysql配置
在这里插入图片描述
把com.mysql.jdbc.Driver修改成com.mysql.cj.jdbc.Driver

然后上面还有一个sql异常java.sql.SQLException: The server time zone value ‘?й???’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the ‘serverTimezone’ configuration property) to use a more specifc time zone value if you want to utilize time zone support.
这里修改mysql对应的时区即可解决,以下为最终配置

#MYSQL连接配置
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/fio1?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root