Caused by: java.sql.SQLException: The server time zone value '�й��׼ʱ��' is unrecognized or represen

转载于 2018-11-13 16:56:45 发布 · 2.8k 阅读

文章标签：

本文详细介绍了在使用boot+mybatis框架时遇到的关于MySQL时区配置问题，当服务器时区设置为‘�й��׼ʱ��’时，会触发java.sql.SQLException异常。文章提供了具体的解决方案，通过在spring.datasource.url中添加特定参数，如useJDBCCompliantTimezoneShift、useLegacyDatetimeCode和serverTimezone等，以确保应用程序能够正确识别和处理时区。

boot +mybatis

Caused by: 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.

解决办法

spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC