You must configure either the server or JDBC driver (via the serverTimezone configuration property)

川长思鸟来 2023-10-08 11:24 34阅读 0赞

## 错误提示 ##

Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: 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.
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
    	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
    	at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
    	at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2121)
    	at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2145)
    	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1310)
    	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:967)
    	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826)
    	... 75 more

## 原因 ##

*  因为安装mysql的时候时区设置的不正确 mysql默认的是美国的时区，而我们中国大陆要比他们迟8小时，采用+8:00格式
 *  使用的数据库是MySQL，在SpringBoot2.1在你没有指定MySQL驱动版本的情况下它自动依赖的驱动是8.0.12很高的版本，这是由于数据库和系统时区差异所造成的，在jdbc连接的url后面加上`serverTimezone=GMT`即可解决问题，如果需要使用gmt+8时区，需要写成GMT%2B8，否则会被解析为空。
 *  再一个解决办法就是使用低版本的MySQL jdbc驱动，5.1.28不会存在时区的问题。

## 解决办法 ##

*  在配置db.url 路径后面加`serverTimezone=GMT`即可

db.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8

You must configure either the server or JDBC driver (via the serverTimezone configuration property)

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 You must configure either the server or JDBC driver (via the serverTimezone configuration property)

相关 git ------ fatal: No configured push destination. Either specify the URL from the command-line or co

相关 MYSQL You must configure either the server or JDBC driver (via the serverTimezone configuration prop

相关 You must configure either the server or JDBC driver(via the ‘serverTimezone‘ configuration property)

相关 configure: error: you must configure in a separate build directory

相关 You must configure either the server or JDBC driver (via the serverTimezone configuration property)

相关 You must configure either the server or JDBC driver (via the serverTimezone configuration property)

相关 You must configure either the server or JDBC driver (via the serverTimezone conf

相关 You must configure either the server or JDBC driver (via the serverTimezone conf)

相关 Ubuntu Nginx ./configure: error: the HTTP gzip module requires the zlib library. You can either...