java.sql.SQLException: The server time zone value ' is unrecognized or represents more than one time

最新推荐文章于 2024-10-04 20:39:44 发布
最新推荐文章于 2024-10-04 20:39:44 发布
阅读量303 收藏
点赞数
分类专栏： 报错 提示 文章标签： springBoot  数据库中查出时间数据比实际时间晚八个小时
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44019721/article/details/97793766
版权
本文解决了SpringBoot启动时报错的问题，错误源于时区设置不正确。通过在application.properties文件中数据库连接URL后添加&serverTimezone=UTC，成功解决了java.sql.SQLException异常。
摘要由CSDN通过智能技术生成

记录一下问题:
SpringBoot 启动就报错:

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.

这个原因是:时差

直接从数据库查询就不会

(貌似64位系统的就会这样子)

在配置文件application.propties
数据库连接
spring.datasource.url=
最后添加
&serverTimezone=UTC
在这里插入图片描述

完美解决~

Debezium报错处理系列之九十五：The server time zone value ‘?‘ is unrecognized or represents more than one time
zhengzaifeidelushang的博客
10-19 191
Debezium报错处理系列之九十五：Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value '?й???׼ʱ?' is unrecognized or represents more than one time zone.
异常：java.sql.SQLException: The server time zone value ‘?й???????’ is unrecognized or represents more
12-14
异常错误：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. 出现
java.sql.SQLException: The server time zone value ** is unrecognized or represents more
梦想导航
05-21 269
java连接MySQL数据库时异常： 我们在做各种项目时经常会用java连接数据库，而连接数据库的过程中往往会出现很多类似的代码异常 问题描述： 我在用druid（阿里巴巴一个开源的数据库连接池）连接数据库时产生如下异常 原因分析和解决方案： 主要原因有两种 驱动架包需要升级了（对一些老的项目）升级后的mysqljar包需要修改驱动 将com.mysql.jdbc.Driver 改成com.mysql.cj.jdbc.Driver (架包在8以上的) 需要修改连接url添加如下选项（其中最重要的是se
Spring Boot配置数据库MySQL8.x版本连接的serverTimezone时区问题
最新发布
u013526643的专栏
10-04 559
Spring Boot配置数据库MySQL连接
java.sql.SQLException: The server time zone value is unrecognized or represents more than
weixin_43064412的博客
06-22 207
解决方案： 在数据库连接url上添加serverTimezone=UTC 原因：SpringBoot整合MySQL的依赖包版本过高,在高版本的MySQL依赖中数据库和系统时区差异所造成的。
mysql错误：java.sql.SQLException: The server time zone value ‘XXXX‘ is unrecognized or represents...
长安过客君的博客
02-04 414
错误信息 java web 项目，控制台server异常信息如下 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
java.sql.SQLException: The server time zone value ‘�й���׼ʱ��‘ is unrecognized or represents more tha
闲言
02-24 4555
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 i
JDBC报错：The server time zone value is unrecognized or represents more than one time zone 已解决
weixin_46122692的博客
11-03 1509
一、详细报错信息 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 zo
springboot启动报错 Cause:java.sql.SQLException: The server time zone value ‘Öйú±ê׼ʱ¼ä‘ is unrecognize
weixin_45577058的博客
08-27 707
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userMapper' defined in file [D:\学习课程\S4\s4_谷粒在线教育项目\day01_进行mybatis_plus的进阶学习\code\mybatis-plus-demo\target\classes\com\liujie\mybatisplus\mapper\UserMapper.cl
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
06-28
回答1：</h3><br/>这是一个数据库连接错误，错误信息为“java.sql.sqlexception: the server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. you must configure ...
The server time zone value '?й???????' is unrecognized or represents more than one time zone. You mu
媛猿
04-14 4964
原创博主的地址：http://blog.csdn.net/oppo5630/article/details/52162783解决数据库连接 报错：The server time zone value '?й???????' is unrecognized or represents more than one time zone. You must configure either the ser...
java.sql.SQLException:The server time zone value '' is unrecognized or represents more than one time
zhouym_的博客
08-20 634
在spring boot项目中运行启动类报如下错误： 2019-08-20 11:34:03.614 ERROR 7596 --- [reate-800456240] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://localhost:3306/vhr?useU...
java.sql.SQLException: The server time zone value ¼Ê±¼ä' is unrecognized or repr...
梓鸿
04-13 345
java.sql.SQLException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or repr 在数据库连接配置文件中加入以下： 解决办法为在application文件中添加serverTimezone=UTC spring.da...
连接mysql报错java.sql.SQLException: The server time zone value is unrecognized or represe
圆园源的糕圆
05-25 478
java.sql.SQLException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents morethan one time zone. 原因：MySql安装默认设置为美国时区 解决方法： jdbc.driverClassName=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC&.
MySql数据库时区异常，java.sql.SQLException: The server time zone value '?й???׼ʱ?' is unrecognized or repr...
weixin_30647065的博客
03-20 273
JDBC访问MySql异常 Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:### Error querying database. Cause: java.sql.SQLException: The server time zone value '?й???׼ʱ?' is u...
java.sql.SQLException: The server time zone value is unrecognized or represents more than one time
aLinxi的博客
06-02 735
文章目录01 | 出现的问题02 | 异常原因03 | 解决办法 01 | 出现的问题 在springboot项目集成mysql时，连接出现了问题，报出下列的时区错误。 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
mysql java.sql.SQLException: The server time zone value '?й???????' is unrecognized or represents mo...
a77687789的博客
06-24 168
转载： https://blog.csdn.net/oppo5630/article/details/52162783 解决mysql 数据库连接 报错： The server time zone value '?й???????' is unrecognized or represents more than one time zone. You must configur...
异常：java.sql.SQLException: The server time zone value ?????? is unrecognized or represents more
Arthur_Holmes的博客
06-12 620
软件开发，为了满足开发的需要，jar包版本的更新或bug的修复，会造成 版本不兼容，出现新问题，程序员就是为解决问题出现的，一句话就是我们爱折腾，乐此不彼。 异常错误：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 (v.
新版mysql8.0出现的问题
qq_40764966的博客
07-24 741
Exception in thread “main” 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...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值