服务器时区值“AEST”无法识别或代表多个时区 [英] The server time zone value 'AEST' is unrecognized or represents more than one time zone

问题描述

我试图设置一个简单的hibernate应用程序，当我运行它时，我得到一个堆栈跟踪充满了错误。

我在我的下列maven依赖项 pom.xml file：

 <依赖关系> 
< groupId> org.hibernate< / groupId> 
< artifactId> hibernate-core< / artifactId> 
< version> 5.2.0.Final< / version> 
< /依赖关系> 
<！ -  http://mvnrepository.com/artifact/mysql/mysql-connector-java  - > 
< dependency> 
< groupId> mysql< / groupId> 
< artifactId> mysql-connector-java< / artifactId> 
< version> 6.0.2< / version> 
< /依赖关系> 
  

我在本地运行的mysql版本是：

  5.7.9，用于osx10.11（x86_64）
  

我正在运行，看起来像一个非常简单的方法，但仍然出现错误：

  // create session factory 
 SessionFactory factory = new Configuration（）
 .configure（hibernate.cfg.xml）
 .addAnnotatedClass（Model.class）
 .buildSessionFactory（）; 
 
 //创建会话
会话会话= factory.getCurrentSession（）; 
 
 Model newModel = new Model（....，...，...）; 
 
 //开始一笔交易
 session.beginTransaction（）; 
 
 //保存学生对象
 System.out.println（保存模型...）; 
 session.save（newModel）; 
  

执行上述操作后，我得到一个很长的堆栈跟踪... System.out.println不打印任何...因此，连接似乎没有连接。

 信息：HHH000115：Hibernate连接池大小：1（分钟= 1）
 Thu Jun 09 17:36:28美国东部时间2016年WARN：建议不建立服务器身份验证的SSL连接。根据MySQL 5.5.45+，5.6.26+和5.7.6+的要求，如果未设置显式选项，则必须默认建立SSL连接。为了符合不使用SSL的现有应用程序，verifyServerCertificate属性设置为'false'。您需要通过设置useSSL = false显式禁用SSL，或者设置useSSL = true并为服务器证书验证提供信任库。 
线程main中的异常org.hibernate.service.spi.ServiceException：无法创建请求的服务[org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] 
 org.hibernate.service .internal.AbstractServiceRegistryImpl.createService（AbstractServiceRegistryImpl.java:244）
 at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（AbstractServiceRegistryImpl.java:208）
 at org.hibernate.service.internal.AbstractServiceRegistryImpl .getService（AbstractServiceRegistryImpl.java:189）
位于org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure（JdbcServicesImpl.java:51）
位于org.hibernate.boot.registry.internal.StandardServiceRegistryImpl .configureService（StandardServiceRegistryImpl.java:94）
 at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（AbstractServiceRegistryImpl.java:217）
 at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl .java：189）
 at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes（MetadataBuildingProcess.java:352）
 at org.hibernate.boot.model.process.spi.MetadataBuildingProcess .complete（MetadataBuildingProcess.java:111）
位于org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build（MetadataBuildingProcess.java:83）
位于org.hibernate.boot.internal.MetadataBuilderImpl .build（MetadataBuilderImpl.java:418）
位于org.hibernate.boot.internal.MetadataBuilderImpl.build（MetadataBuilderImpl.java:87）
位于org.hibernate.cfg.Configuration.buildSessionFactory（Configuration.java ：691）
 at org.hibernate.cfg.Configuration.buildSessionFactory（Configuration.java:723）
 at com.parkingapi.tests.Test.main（Test.java:17）
引起通过：org.hibernate.exception.JDBCConnectionException：错误调用驱动程序＃连接
在org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator $ 1 $ 1.convert（BasicConnectionCreator.java:10 5）
在org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException（BasicConnectionCreator.java:123）
在org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection（ DriverConnectionCreator.java:41）
在org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection（BasicConnectionCreator.java:58）
在org.hibernate.engine.jdbc.connections.internal。 PooledConnections.addConnections（PooledConnections.java:106）
在org.hibernate.engine.jdbc.connections.internal.PooledConnections。< init>（PooledConnections.java:40）
在org.hibernate.engine .jdbc.connections.internal.PooledConnections。< init>（PooledConnections.java:19）
 at org.hibernate.engine.jdbc.connections.internal.PooledConnections $ Builder.build（PooledConnections.java:138）
在org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildPool（DriverManagerConnectio nProviderImpl.java:110）
在org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure（DriverManagerConnectionProviderImpl.java:74）
位于org.hibernate.boot.registry.internal.StandardServiceRegistryImpl。 （ServiceServiceRegistryImpl.java:94）
位于org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（AbstractServiceRegistryImpl.java:217）
位于org.hibernate.service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl。 java：189）
位于org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess（JdbcEnvironmentInitiator.java:145）
位于org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator。启动服务（JdbcEnvironmentInitiator.java:66）
位于org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService（JdbcEnvironmentInitiator.java:35）
位于org.hibernate.boot.registry.internal。 StandardSe rviceRegistryImpl.initiateService（StandardServiceRegistryImpl.java:88）
 at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService（AbstractServiceRegistryImpl.java:234）
 ... 14 more 
原因是：java .sql.SQLException：服务器时区值'AEST'无法识别或代表多个时区。如果要利用时区支持，则必须配置服务器或JDBC驱动程序（通过serverTimezone配置属性）以使用更具体的时区值。 
 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException（SQLError.java:695）
 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException（SQLError.java:663） 
 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException（SQLError.java:653）
 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException（SQLError.java:638） 
 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException（SQLError.java:606）
 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException（SQLError.java:624） 
 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException（SQLError.java:620）
 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException（SQLExceptionsMapping.java:68） 
 at com.mysql.cj.jdbc.ConnectionImpl.createNewIO（ConnectionImpl.java:1683）
 at com.mysql.cj.jdbc.ConnectionImpl。< init>（ConnectionImpl.java:656）
在com.mysql.cj.jdbc.ConnectionImpl.getInstance（ConnectionImpl.java:349）
在com.mysql.cj。 jdbc.NonRegisteringDriver.connect（NonRegisteringDriver.java:221）
 at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection（DriverConnectionCreator.java:38）
 ... 29 more 
导致：com.mysql.cj.core.exceptions.InvalidConnectionAttributeException：服务器时区值'AEST'无法识别或表示多个时区。如果要利用时区支持，则必须配置服务器或JDBC驱动程序（通过serverTimezone配置属性）以使用更具体的时区值。 
 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:408）
 at com.mysql.cj.core.exceptions.ExceptionFactory.createException（ExceptionFactory.java:54） 
 at com.mysql.cj.core.exceptions.ExceptionFactory.createException（ExceptionFactory.java:73）
 at com.mysql.cj.jdbc.util.TimeUtil.getCanonicalTimezone（TimeUtil.java:118） 
 at com.mysql.cj.mysqla.MysqlaSession.configureTimezone（MysqlaSession.java:308）
 at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer（ConnectionImpl.java:2474）
 at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly（ConnectionImpl.java:1817）
 at com.mysql.cj.jdbc.ConnectionImpl.createNewIO（Connectio nImpl.java:1673）
 ... 33 more 
  

我专注于此错误在这里：

服务器时区值'AEST'无法识别，或者比一个时区多
。如果您想利用时区支持，则必须配置服务器或JDBC
驱动程序（通过serverTimezone配置属性）以使用更多
特定时区值。

我不确定如何修复它？

编辑：

打印出Timezone（System.out.println（TimeZone.getDefault（））;）将打印以下详细信息：

sun.util.calendar.ZoneInfo [ID = 澳大利亚/墨尔本，偏移= 36000000，dstSavings = 3600000，useDaylight =真，过渡= 142，lastRule = java.util.SimpleTimeZone中[ID =澳大利亚/墨尔本，偏移= 36000000 ，dstSavings = 3600000，useDaylight =真，startYear = 0，STARTMODE = 3，startMonth = 9，朝九特派= 1，startDayOfWeek = 1，开始时间= 7200000，startTimeMode = 1，endMode = 3，endMonth = 3，endday指定= 1，一个endDayOfWeek = 1，endTime = 7200000，endTimeMode = 1]]

编辑：

<所以我看着被标记的问题，并试图改变我的连接字符串bu它仍然抛出相同的堆栈跟踪。以下是我的新连接网址。正如你所看到的，我将serverTimezone更改为打印的 Timezone.getDefault（）

  JDBC的：mysql：//本地主机：3306 / parking_hib useLegacyDatetimeCode = FALSE; serverTimezone =澳大利亚/墨尔本; useSSL = FALSE; 
  

解决方案

原来 6.x 不兼容，转移到 5.1.39 修正它。

I'm trying to setup a simple hibernate application, when I run it I get a stack trace full of errors.

I have the following maven dependencies in my pom.xml file:

<dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-core</artifactId>
        <version>5.2.0.Final</version>
    </dependency>
    <!-- http://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>6.0.2</version>
    </dependency>

And the mysql version I'm running locally is:

5.7.9, for osx10.11 (x86_64)

I'm running, what seems, a very simple method, and still getting errors:

// create session factory
SessionFactory factory = new Configuration()
            .configure("hibernate.cfg.xml")
            .addAnnotatedClass(Model.class)
            .buildSessionFactory();

// create session
Session session = factory.getCurrentSession();

Model newModel = new Model("....", "...", "...");

// start a transaction
session.beginTransaction();

// save the student object
System.out.println("Saving the model...");
session.save(newModel);

After the above is executed, I get a long stack trace...The System.out.println doesn't print either...So the connection just doesn't seem to be connecting.

INFO: HHH000115: Hibernate connection pool size: 1 (min=1)
Thu Jun 09 17:36:28 EST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Exception in thread "main" org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:244)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:208)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:189)
    at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51)
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:217)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:189)
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352)
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111)
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83)
    at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:418)
    at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:87)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:691)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:723)
    at com.parkingapi.tests.Test.main(Test.java:17)
Caused by: org.hibernate.exception.JDBCConnectionException: Error calling Driver#connect
    at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator$1$1.convert(BasicConnectionCreator.java:105)
    at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException(BasicConnectionCreator.java:123)
    at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:41)
    at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:58)
    at org.hibernate.engine.jdbc.connections.internal.PooledConnections.addConnections(PooledConnections.java:106)
    at org.hibernate.engine.jdbc.connections.internal.PooledConnections.<init>(PooledConnections.java:40)
    at org.hibernate.engine.jdbc.connections.internal.PooledConnections.<init>(PooledConnections.java:19)
    at org.hibernate.engine.jdbc.connections.internal.PooledConnections$Builder.build(PooledConnections.java:138)
    at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildPool(DriverManagerConnectionProviderImpl.java:110)
    at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:74)
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:217)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:189)
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:145)
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:234)
    ... 14 more
Caused by: java.sql.SQLException: The server time zone value 'AEST' 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:695)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:663)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:653)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:638)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:606)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:624)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:620)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:68)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1683)
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:656)
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:349)
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:221)
    at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:38)
    ... 29 more
Caused by: com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: The server time zone value 'AEST' 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:408)
    at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)
    at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
    at com.mysql.cj.jdbc.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:118)
    at com.mysql.cj.mysqla.MysqlaSession.configureTimezone(MysqlaSession.java:308)
    at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:2474)
    at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1817)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1673)
    ... 33 more

I'm focused on this error here:

The server time zone value 'AEST' 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.

I'm unsure how I fix it?

Edit:

Printing out the Timezone (System.out.println(TimeZone.getDefault());) prints the following details:

sun.util.calendar.ZoneInfo[id="Australia/Melbourne",offset=36000000,dstSavings=3600000,useDaylight=true,transitions=142,lastRule=java.util.SimpleTimeZone[id=Australia/Melbourne,offset=36000000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=9,startDay=1,startDayOfWeek=1,startTime=7200000,startTimeMode=1,endMode=3,endMonth=3,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=1]]

Edit:

So I looked at the question which was flagged, and tried to change my connection string, but it's still throwing the same stack trace. Below is my new connection url. As you can see I changed the serverTimezone to that of the printed Timezone.getDefault()

jdbc:mysql://localhost:3306/parking_hib?useLegacyDatetimeCode=false;serverTimezone=Australia/Melbourne;useSSL=false;

解决方案

Turns out 6.x wasn't compatible, moving to 5.1.39 fixed it.

这篇关于服务器时区值“AEST”无法识别或代表多个时区的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！