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

矫情吗；* 2021-11-11 04:46 178阅读 0赞

今天在用SpringBoot（v2.1.6.RELEASE）+MyBatis+MySQL搭建项目开发环境的时候启动项目发现报了一个很奇怪的错，报错内容如下：

Fri May 17 14:55:39 CST 2019
    There was an unexpected error (type=Internal Server Error, status=500).
    nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLSyntaxErrorException: Identifier name 'netsafe&useunicode=true&characterencoding=utf-8&allowmultiqueries=true&usessl=false' is too long ### The error may exist in com/infosec/netsafess/mapper/UserMapper.java (best guess) ### The error may involve com.infosec.netsafess.mapper.UserMapper.getAllUser ### The error occurred while executing a query ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLSyntaxErrorException: Identifier name 'netsafe&useunicode=true&characterencoding=utf-8&allowmultiqueries=true&usessl=false' is too long
    org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
    ### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLSyntaxErrorException: Identifier name 'netsafe&useunicode=true&characterencoding=utf-8&allowmultiqueries=true&usessl=false' is too long
    ### The error may exist in com/infosec/netsafess/mapper/UserMapper.java (best guess)
    ### The error may involve com.infosec.netsafess.mapper.UserMapper.getAllUser
    ### The error occurred while executing a query
    ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLSyntaxErrorException: Identifier name 'netsafe&useunicode=true&characterencoding=utf-8&allowmultiqueries=true&usessl=false' is too long
    	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
    	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
    	at com.sun.proxy.$Proxy60.selectList(Unknown Source)
    	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
    	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
    	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
    	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)
    	at com.sun.proxy.$Proxy64.getAllUser(Unknown Source)
    	at com.infosec.netsafess.service.impl.UserServiceImpl.getAllUser(UserServiceImpl.java:19)
    	at com.infosec.netsafess.controller.HelloController.getAllUser(HelloController.java:25)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

启动springboot项目，然后访问数据库，报You must configure either the server or JDBC driver (via the serverTimezone conf）的错误，原因

因为安装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不会存在时区的问题。

加上这个  ?serverTimezone=UTC

spring.datasource.url=jdbc:mysql://localhost:3306/exam?serverTimezone=UTC

如![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2lpaWlpaWxpa2FuZ3NodWFp_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2lpaWlpaWxpa2FuZ3NodWFp_size_16_color_FFFFFF_t_70]: /images/20211109/e2389e8b2f5d4af5a95b54616748df20.png

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 configuration property)

相关 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)

相关 The web application [/] registered the JDBC driver [com.oracle.jdbc.Driver] 错误解决

相关 The driver is automatically registered via the SPI and manual loading of the

相关 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...