Guest User

Untitled

a guest
Aug 13th, 2018
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.33 KB | None | 0 0
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0"
  3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  5. <modelVersion>4.0.0</modelVersion>
  6.  
  7. <groupId>group</groupId>
  8. <artifactId>artifact</artifactId>
  9. <version>1.0-SNAPSHOT</version>
  10.  
  11. <dependencies>
  12.  
  13. <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
  14. <dependency>
  15. <groupId>mysql</groupId>
  16. <artifactId>mysql-connector-java</artifactId>
  17. <version>8.0.12</version>
  18. </dependency>
  19.  
  20. <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
  21. <dependency>
  22. <groupId>org.hibernate</groupId>
  23. <artifactId>hibernate-core</artifactId>
  24. <version>5.3.4.Final</version>
  25. </dependency>
  26.  
  27.  
  28. </dependencies>
  29.  
  30. </project>
  31.  
  32. <?xml version="1.0" encoding="UTF-8"?>
  33. <persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence"
  34. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  35. xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
  36. http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
  37. <persistence-unit name="org.hibernate.tutorial.jpa">
  38.  
  39. <properties>
  40. <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
  41. <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/PersonManager"/>
  42. <property name="hibernate.connection.autocommit" value="false"/>
  43. <property name="hibernate.connection.username" value="root"/>
  44. <property name="hibernate.connection.password" value="12345"/>
  45. <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/>
  46. <property name="hibernate.connection.CharSet" value="utf8"/>
  47. <property name="hibernate.connection.characterEncoding" value="utf8"/>
  48. <property name="hibernate.connection.useUnicode" value="true"/>
  49. <property name="hibernate.show_sql" value="true"/>
  50. <property name="hibernate.hbm2ddl.auto" value="update"/>
  51. <!-- use encache provider-->
  52. <!--<property name="hibernate.cache.region.factory_class"-->
  53. <!--value="org.hibernate.cache.ehcache.EhCacheRegionFactory"/>-->
  54. <!--<property name="hibernate.javax.cache.provider" value="org.ehcache.jsr107.EhcacheCachingProvider"/>-->
  55. <!--<!&ndash;use second level cache&ndash;>-->
  56. <!--<property name="hibernate.cache.use_second_level_cache" value="true"/>-->
  57. <!--<!&ndash;use 3rd level cache&ndash;>-->
  58. <!--<property name="hibernate.cache.use_query_cache" value="true"/>-->
  59. </properties>
  60. </persistence-unit>
  61. </persistence>
  62.  
  63. import javax.persistence.*;
  64.  
  65. @Entity
  66. @Table(name = "Students")
  67. public class Student {
  68.  
  69. @Id
  70. @Column(name = "id")
  71. @GeneratedValue(generator = "incrementor")
  72. private int id;
  73.  
  74. @Column(name = "name")
  75. private String name;
  76.  
  77. @Column(name = "clas")
  78. private String clas;
  79.  
  80. // Setters
  81.  
  82. public void setId(int id) {
  83. this.id = id;
  84. }
  85.  
  86. public void setName(String name) {
  87. this.name = name;
  88. }
  89.  
  90. public void setClas(String clas) {
  91. this.clas = clas;
  92. }
  93.  
  94.  
  95. // Getters
  96.  
  97. public int getId() {
  98. return id;
  99. }
  100.  
  101. public String getName() {
  102. return name;
  103. }
  104.  
  105. public String getClas() {
  106. return clas;
  107. }
  108. }
  109.  
  110. import javax.persistence.EntityManager;
  111. import javax.persistence.EntityManagerFactory;
  112. import javax.persistence.Persistence;
  113.  
  114. public class Main {
  115.  
  116. public static void main(String... main) {
  117. // Тут возникает эксепшн!
  118. EntityManagerFactory entityManagerFactory = Persistence.createEntityManagerFactory("org.hibernate.tutorial.jpa");
  119.  
  120. EntityManager entityManager = entityManagerFactory.createEntityManager();
  121.  
  122. Student student = new Student();
  123. student.setId(3); // В бд уже есть 2 записи
  124. student.setName("Albert");
  125. student.setClas("11-X");
  126.  
  127. entityManager.persist(student);
  128. entityManager.getTransaction().commit();
  129.  
  130. entityManagerFactory.close();
  131. }
  132. }
  133.  
  134. Exception in thread "main" org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  135. at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:275)
  136. at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237)
  137. at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
  138. at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152)
  139. at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286)
  140. at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243)
  141. at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
  142. at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:179)
  143. at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:119)
  144. at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:904)
  145. at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:935)
  146. at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
  147. at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
  148. at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:54)
  149. at Main.main(Main.java:8)
  150. Caused by: org.hibernate.exception.GenericJDBCException: Error calling Driver#connect
  151. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
  152. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
  153. at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException(BasicConnectionCreator.java:118)
  154. at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:41)
  155. at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:58)
  156. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections.addConnections(DriverManagerConnectionProviderImpl.java:363)
  157. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections.<init>(DriverManagerConnectionProviderImpl.java:282)
  158. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections.<init>(DriverManagerConnectionProviderImpl.java:260)
  159. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections$Builder.build(DriverManagerConnectionProviderImpl.java:401)
  160. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildPool(DriverManagerConnectionProviderImpl.java:112)
  161. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:75)
  162. at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:100)
  163. at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:246)
  164. at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
  165. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:145)
  166. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)
  167. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
  168. at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:94)
  169. at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
  170. ... 14 more
  171. Caused by: java.sql.SQLException: The server time zone value 'MSK' 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.
  172. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
  173. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  174. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  175. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  176. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  177. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
  178. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:832)
  179. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
  180. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
  181. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
  182. at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:38)
  183. ... 29 more
  184. Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'MSK' 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.
  185. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  186. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  187. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  188. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  189. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  190. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
  191. at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:128)
  192. at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2236)
  193. at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2260)
  194. at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1314)
  195. at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:963)
  196. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822)
  197. ... 33 more
  198.  
  199. Process finished with exit code 1
  200.  
  201. <property name="hibernate.jdbc.time_zone" value="MSK"/>
Add Comment
Please, Sign In to add comment