Mybatis的serverTimezone时区出现问题

最新推荐文章于 2024-08-18 20:00:38 发布

Weirdchun

最新推荐文章于 2024-08-18 20:00:38 发布

阅读量2.7k

点赞数 1

分类专栏： error # Mybatis 文章标签： mybatis mysql bug jdbc

本文链接：https://blog.csdn.net/qq_42567023/article/details/104958771

版权

error 同时被 2 个专栏收录

3 篇文章 0 订阅

订阅专栏

Mybatis

3 篇文章 0 订阅

订阅专栏

错误信息

我们可以定位错误信息The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is，
则说明了是serverTimezone时区的问题

org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: 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.
### The error may exist in com/chun/dao/UserMapper.xml
### The error may involve com.chun.dao.UserMapper.getUserList
### The error occurred while executing a query
### Cause: java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time

出现原因

因为MySQL版本号是8.0以上，需要设置serverTimezone，useSSL等参数

解决

在mybatis-config.xml文件中的property name="url"在后面添加

&amp;serverTimezone=Asia/Shanghai"  //注意Shanghai是开头大写
或者
&amp;serverTimezone=GMT%2B8

 <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=Asia/Shanghai"/>