springboot+mybatis+mysql 出现的简单500错误问题

最新推荐文章于 2023-04-07 09:13:55 发布

DarkKinghtZ

最新推荐文章于 2023-04-07 09:13:55 发布

阅读量907

点赞数

文章标签： springboot mybatis mysql

本文链接：https://blog.csdn.net/DarkKinghtZ/article/details/89879310

版权

当SpringBoot、Mybatis和MySQL集成时遇到500错误，具体表现为时区识别异常。错误信息指出服务器时区值'ÖÐ¹ú±ê×¼Ê±¼ä'未被识别，需要在配置文件中修改JDBC连接字符串，添加&serverTimezone=GMT或UTC参数来指定特定时区。此外，添加?useUnicode=true&characterEncoding=utf-8可解决中文乱码问题。

摘要由CSDN通过智能技术生成

页面报500的时区错误，详情如下：

2019-03-21 17:49:20.591 ERROR 5088 --- [nio-8080-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is 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.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 file [D:\springboot-mybatis-demo\target\classes\mapping\UserInfoMapper.xml] ### The error may involve com.ocean.dao.UserInf