SpringBoot|SpringBoot 学习过程遇到的问题

java.sql.SQLException: The server time zone value xxx

  1. mysql默认的时区和本地时区不一致导致的
  2. 有多个时区,运行时需要指定一个时区
解决方案:
方案一:修改mysql默认时区
1.查询系统支持当前的时区设置: mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.12| +-----------+ 1 row in set (0.00 sec) mysql> show variables like '%time_zone%'; +------------------+--------+ | Variable_name| Value| +------------------+--------+ | system_time_zone | CST| | time_zone| SYSTEM | +------------------+--------+ 2 rows in set (0.00 sec) 2.修改时区设置: 方法1:写入到配置文件需要重启mysql实例: [mysqld] default-time-zone=timezone 修改为 default-time-zone = '+8:00' 方法2:在线修改和查看: mysql> set time_zone='+8:00'; Query OK, 0 rows affected (0.00 sec) mysql> show variables like '%time_zone%'; +------------------+--------+ | Variable_name| Value| +------------------+--------+ | system_time_zone | CST| | time_zone| +08:00 | +------------------+--------+ 2 rows in set (0.01 sec) --通过now() 查看: mysql> show variables like '%time_zone%'; +------------------+--------+ | Variable_name| Value| +------------------+--------+ | system_time_zone | CST| | time_zone| +08:00 | +------------------+--------+ 2 rows in set (0.01 sec) mysql> select now(); +---------------------+ | now()| +---------------------+ | 2018-08-28 16:08:38 | +---------------------+ 1 row in set (0.00 sec) mysql> set time_zone='+0:00'; Query OK, 0 rows affected (0.00 sec) mysql> show variables like '%time_zone%'; +------------------+--------+ | Variable_name| Value| +------------------+--------+ | system_time_zone | CST| | time_zone| +00:00 | +------------------+--------+ 2 rows in set (0.01 sec) mysql> select now(); +---------------------+ | now()| +---------------------+ | 2018-08-28 08:09:12 | +---------------------+ 1 row in set (0.00 sec) --自MySQL 8.0 GA版本开始支持将参数写入并且持久化: mysql> set persist time_zone='+0:00'; --针对application 可以设置: jdbc:mysql://localhost:3306/database?useUnicode=true&characterEncoding=UTF-8&useOldAliasMetadataBehavior=true&autoReconnect=true&serverTimezone=UTC --结论: mysql> set time_zone='+8:00'; 和time_zone='system'是等同的,默认为系统时间。

方案二:连接mysql时指定时区为UTC
jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC

Failed to load property source from location ‘classpath:/application.yml’
  1. yml的语法格式有误
application.yml: spring: datasource: driver-class-name: com.mysql.jdbc.Driver username: root password: 123456 url: jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8 datasource: type: com.alibaba.druid.pool.DruidDataSource

解决方法:修改后的application.yml:
spring: datasource: driver-class-name: com.mysql.jdbc.Driver username: root password: 123456 url: jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8 type: com.alibaba.druid.pool.DruidDataSource

PS:校验yml语法
注:注意缩进
  1. 其他问题
spring: datasource: url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8 username: root password: 123456 servlet: multipart: max-file-size: 5MB # 限制文件上传的大小 从配置文件中可以看出语法并无问题。

解决办法:
  1. File–>Settings–>File Encodings
这三个地方设置成UTF-8格式。重启启动项目。
  1. 如第一步并未解决问题,则可以用终极杀招(本人就是加了中文注释)。
删除application.yml文件中所有中文注释
spring-boot-starter-thymeleaf版本问题 spring boot默认thymeleaf版本是2.1.1
修改为:3.0.11.RELEASE就OK啦!
3.0.11.RELEASE 2.1.1 org.springframework.boot spring-boot-starter-thymeleaf

【SpringBoot|SpringBoot 学习过程遇到的问题】参考:
https://my.oschina.net/u/3740271/blog/3028874;
https://blog.csdn.net/vkingnew/article/details/82149726 ;
https://blog.csdn.net/qq_37495786/article/details/82505737;