The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. You mu...

最新推荐文章于 2022-11-23 14:59:39 发布
最新推荐文章于 2022-11-23 14:59:39 发布
阅读量935 收藏 3
点赞数 1
文章标签： 数据库 java
原文链接：http://www.cnblogs.com/qingmuchuanqi48/p/11617324.html
版权 
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.
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.17.jar:8.0.17]
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.17.jar:8.0.17]
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.17.jar:8.0.17]
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.17.jar:8.0.17]
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.17.jar:8.0.17]
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76) ~[mysql-connector-java-8.0.17.jar:8.0.17]
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:827) ~[mysql-connector-java-8.0.17.jar:8.0.17]
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447) ~[mysql-connector-java-8.0.17.jar:8.0.17]
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237) ~[mysql-connector-java-8.0.17.jar:8.0.17]
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) ~[mysql-connector-java-8.0.17.jar:8.0.17]
    at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136) ~[HikariCP-3.2.0.jar:na]
    at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369) ~[HikariCP-3.2.0.jar:na]
    at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) ~[HikariCP-3.2.0.jar:na]
    at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) [HikariCP-3.2.0.jar:na]
    at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) [HikariCP-3.2.0.jar:na]
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) [HikariCP-3.2.0.jar:na]
    at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-3.2.0.jar:na]
    at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:94) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:179) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:119) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:904) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:935) [hibernate-core-5.3.11.Final.jar:5.3.11.Final]
    at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:57) [spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) [spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:390) [spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:377) [spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) [spring-orm-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1837) [spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1774) [spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) [spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515) [spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) [spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) [spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) [spring-beans-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1105) ~[spring-context-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) ~[spring-context-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) ~[spring-context-5.1.9.RELEASE.jar:5.1.9.RELEASE]
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) ~[spring-boot-2.1.8.RELEASE.jar:2.1.8.RELEASE]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:744) ~[spring-boot-2.1.8.RELEASE.jar:2.1.8.RELEASE]
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:391) ~[spring-boot-2.1.8.RELEASE.jar:2.1.8.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:312) ~[spring-boot-2.1.8.RELEASE.jar:2.1.8.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) ~[spring-boot-2.1.8.RELEASE.jar:2.1.8.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1204) ~[spring-boot-2.1.8.RELEASE.jar:2.1.8.RELEASE]
    at com.qingmu.seller.SellerApplication.main(SellerApplication.java:10) ~[classes/:na]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
    at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) ~[spring-boot-devtools-2.1.8.RELEASE.jar:2.1.8.RELEASE]
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException:

根据报错我们知道这是时间报错，没有指定明确的时区，是因为新版的mysql会询问是否SSL连接，返回一个Boolean值，我们需要手动指定true或者false。所以再次更改配置文件中的 url 满足其要求即可

 "jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8&amp;serverTimezone=UTC&amp;useSSL=false"

 

转载于:https://www.cnblogs.com/qingmuchuanqi48/p/11617324.html

weixin_38168838
关注
解决SpringDataJPA报错：org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null w
01-21
问题描述 用SpringBoot + Spring Data JPA操作数据库 项目启动的时候 报了一个错 SpringBoot的版本是2.2.6.RELEASE org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.cla
WebLogic 上部署Spring应用遇到的一些问题的解决
wanjing 的专栏
03-04 1万+
问题1： Spring 使用 Hibernate 4.3.8 Final， 部署到WebLogic 12c 之后报错： Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instanti
Error starting Tomcat context. Exception
weixin_51486676的博客
04-18 8526
Error starting Tomcat context. Exception: org.springframework.beans.factory.UnsatisfiedDependencyException. Message: Error creating bean with name ‘myWebSecurityConfig’: Unsatisfied dependency expressed through field ‘userService’; nested exception is org.
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springfr
热门推荐
Angela_L的博客
05-25 5万+
今天写springboot的项目时报错： Error starting ApplicationContext. To display the auto-configuration report re-run your application with 'debug' enabled. 2019-05-25 10:55:33.996 ERROR 2748 --- [ main] ...
Spring Boot+Mybatis配置双数据源&整合Activiti工作流报错整理
zmh15927652085的博客
09-29 4088
Spring Boot+Mybatis配置双数据源&整合Activiti工作流报错整理
异常：java.sql.SQLException: The server time zone value ‘?й???????’ is unrecognized or represents more
12-14
’ is unrecognized or represents more than one time zone”。这个错误表明服务器时区的值无法识别或者它代表了多个时区，这通常是由于数据库服务器与JDBC驱动之间的时间区域设置不匹配所导致的。 首先，我们需要...
解决IDEA错误 Cause: java.sql.SQLException: The server time zone value的问题
08-18
标题中的问题“Cause: java.sql.SQLException: The server time zone value”是Java开发者在使用IDEA（IntelliJ IDEA）进行数据库连接时常见的错误提示。这个错误通常发生在尝试连接到MySQL等SQL数据库时，由于...
俄语船舶词汇1000词.pdf
06-30
- **Главный двигатель – ГД**（主机）是推动船舶前进的主要发动机。 - **Мощность**（功率）通常用马力（Лошадиная сила）来衡量。 - **Винт гребной**...
：tiger：用于优化SVG文件的Node.js工具-Node.js开发
05-27
русскийSVGO SVG Optimizer是基于Nodejs的工具，用于优化SVG矢量图形文件。 为什么？ SVG文件，尤其是从各种编辑器导出的文件，通常包含很多冗余，并且使用英语| русскийSVGO SVG Optimizer是基于...
Huawei Firmware Finder_3.3.20.1
04-20
и распаковкой. Возможности PC версии: Поиск прошивок для различных устройств Huawei Скачивание прошивок при пом...
SpringBoot实战教程：SpringBoot企业级线上商城项目讲解
09-27
当前课程中商城项目的实战源码是我发布在 GitHub 上的开源项目 newbee-mall （新蜂商城），目前已有 9900 多个 Star，本课程是一个 Spring Boot 技术栈的实战类课程，课程共分为 3 大部分，前面两个部分为基础环境准备和相关概念介绍，第三个部分是 Spring Boot 商城项目功能的讲解，让大家实际操作并实践上手一个大型的线上商城项目，并学习到一定的开发经验以及其中的开发技巧。商城项目所涉及的功能结构图整理如下： 作者寄语本课程录制于2019年，距今已有一段时间。期间，Spring Boot技术栈也有一些版本升级，比如Spring Boot 2.7.x发版、Spring Boot 3.x版本正式版本。对于这些情况，笔者会在本课程实战项目的开源仓库中创建不同的代码分支，保持实战项目的源码更新，保证读者朋友们不会学习过气的知识点。新蜂商城的优化和迭代工作不会停止，不仅仅是功能的优化，在技术栈上也会不断的增加，截止2023年，新蜂商城已经发布了 7 个重要的版本，版本记录及开发计划如下图所示。 课程特色 对新手开发者十分友好，无需复杂的操作步骤，仅需 2 秒就可以启动这个完整的商城项目最终的实战项目是一个企业级别的 Spring Boot 大型项目，对于各个阶段的 Java 开发者都是极佳的选择实践项目页面美观且实用，交互效果完美教程详细开发教程详细完整、文档资源齐全代码+讲解+演示网站全方位保证，向 Hello World 教程说拜拜技术栈新颖且知识点丰富，学习后可以提升大家对于知识的理解和掌握，可以进一步提升你的市场竞争力 课程预览 以下为商城项目的页面和功能展示，分别为：商城首页 1商城首页 2购物车订单结算订单列表支付页面后台管理系统登录页商品管理商品编辑
Error starting Tomcat context. Exception: org.springframework.beans.factory.UnsatisfiedDependencyExc
weixin_41785349的博客
11-23 8098
按照错误 找到这个地方 也就是出现这个错误的原因就是@Value(“${jeecg.path.webapp}”)没法找到里面的值 而这个值是去配置文件里面找的.所以出现这个问题的根本原因就是。
Error starting Tomcat context. Exception: org.springframework.beans.factory.BeanCreationException. M
DuanZeting的博客
12-20 1万+
Error starting Tomcat context. Exception: org.springframework.beans.factory.BeanCreationException. Message: Error creating bean with name 'servletEndpointRegistrar' defined in class path resource 报错原因是: 是缺少jdbc依赖. 1.检查 pom 是否有 jdbc依赖(mysql,...数据库的依赖) 如..
spring-test问题
啦卡的博客
11-22 954
java.lang.IllegalStateException: Could not load CacheAwareContextLoaderDelegate [class org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate] at org.springframework.test.con...
连接池报错：Failed to instantiate [org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter]
u013905744的专栏
05-10 3736
场景： search服务junit测试跑不起来，代码啥也没改过 排查： ... Failed to instantiate [org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter] ... dataSource or dataSourceClassName or jdbcUrl is required org.springframework.boot.jdbc.DataSourceBuilder#build private static
坑---- Error starting Tomcat context. Exception:org.springframework.beans.factory.BeanCreationExcepti
qq_44188658的博客
08-23 8197
项目启动时报错，tomcat停止。 报错信息： [ost-startStop-1] o.s.b.web.embedded.tomcat.TomcatStarter : Error starting Tomcat context. Exception: org.springframework.beans.factory.BeanCreationException. Message: Error creating bean with name 'servletEndpointRegistrar' defi
错误：org.springframework.beans.BeanInstantiationException: Failed to instantiate
young_man2的博客
06-30 1万+
org.springframework.beans.BeanInstantiationException: Failed to instantiate
The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone.
最新发布
05-26
useUnicode=true&characterEncoding=utf8&serverTimezone=UTC ``` 其中，serverTimezone 参数设置为数据库实际使用的时区。如果您的时区不是 UTC，则需要将其替换为正确的时区。另外，确保您的应用程序和数据库...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值