当前位置: 代码迷 >> 综合 >> 报错: java.sql.SQLException: The server time zone value '?й?' is unrecognized or represents more ...
  详细解决方案

报错: java.sql.SQLException: The server time zone value '?й?' is unrecognized or represents more ...

热度:56   发布时间:2024-01-20 21:35:57.0

学习mybatis

刚解决了第一个问题,再上一个博客,现在又来了第二个问题啦

### 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.

这就是时区错误。原因是因为MySql服务采用的是国际标准时间,与内地相差8个小时,所以需要在连接MySql服务在原来的连接基础上加上serverTimezone=UTC

 <property name="url" value="jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;allowMultiQueries=true"/> 

 mybatis是我的数据库名,这样改完就好啦