API tools faq
paste
Advertisement
mellowdeep

exeptions persis

mellowdeep
Oct 29th, 2016
255
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 36.53 KB | None | 0 0
raw download clone embed print report
  1. Oct 28, 2016 9:22:03 PM org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
  2. INFO: HHH000204: Processing PersistenceUnitInfo [
  3.     name: soft_uni
  4.     ...]
  5. Oct 28, 2016 9:22:03 PM org.hibernate.Version logVersion
  6. INFO: HHH000412: Hibernate Core {5.2.2.Final}
  7. Oct 28, 2016 9:22:03 PM org.hibernate.cfg.Environment <clinit>
  8. INFO: HHH000206: hibernate.properties not found
  9. Oct 28, 2016 9:22:03 PM org.hibernate.cfg.Environment buildBytecodeProvider
  10. INFO: HHH000021: Bytecode provider name : javassist
  11. Oct 28, 2016 9:22:03 PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
  12. INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
  13. Oct 28, 2016 9:22:04 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
  14. WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
  15. Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
  16. Oct 28, 2016 9:22:04 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  17. INFO: HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost/soft_uni]
  18. Oct 28, 2016 9:22:04 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  19. INFO: HHH10001001: Connection properties: {user=root, password=****}
  20. Oct 28, 2016 9:22:04 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  21. INFO: HHH10001003: Autocommit mode: false
  22. Oct 28, 2016 9:22:04 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
  23. INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
  24. Fri Oct 28 21:22:04 EEST 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.
  25. Oct 28, 2016 9:22:04 PM org.hibernate.dialect.Dialect <init>
  26. INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect
  27. Hibernate: alter table soft_uni.addresses drop foreign key FKerxjso85moxthd5pitjsakyb7
  28. Oct 28, 2016 9:22:04 PM org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection
  29. INFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@163b39] for (non-JTA) DDL execution was not in auto-commit mode; the Connection 'local transaction' will be committed and the Connection will be set into auto-commit mode.
  30. Hibernate: alter table soft_uni.departments drop foreign key FK56q3esufky8u69xbmo4n63c4r
  31. Hibernate: alter table soft_uni.employees drop foreign key FKkvaekcr8qinc0oo3kxwxgtyt9
  32. Hibernate: alter table soft_uni.employees drop foreign key FKgy4qe3dnqrm3ktd76sxp7n4c2
  33. Hibernate: alter table soft_uni.employees drop foreign key FKi4365uo9af35g7jtbc2rteukt
  34. Hibernate: alter table soft_uni.employees_projects drop foreign key FKc9x9r7nbtwnx24vcrfxym9cyy
  35. Oct 28, 2016 9:22:05 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  36. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  37. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  38.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:62)
  39.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString(SchemaDropperImpl.java:374)
  40.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings(SchemaDropperImpl.java:359)
  41.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.applyConstraintDropping(SchemaDropperImpl.java:331)
  42.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.dropFromMetadata(SchemaDropperImpl.java:230)
  43.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.performDrop(SchemaDropperImpl.java:154)
  44.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:126)
  45.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:112)
  46.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:137)
  47.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
  48.     at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:307)
  49.     at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:490)
  50.     at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:878)
  51.     at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  52.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  53.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  54.     at Demo.main(Demo.java:12)
  55. Caused by: java.sql.SQLSyntaxErrorException: Can't DROP 'FKc9x9r7nbtwnx24vcrfxym9cyy'; check that column/key exists
  56.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:560)
  57.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
  58.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
  59.     at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
  60.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2011)
  61.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1964)
  62.     at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
  63.     at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
  64.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:49)
  65.     ... 16 more
  66.  
  67. Hibernate: alter table soft_uni.employees_projects drop foreign key FKbslohhow39ayel1dc6cdus5sc
  68. Hibernate: drop table if exists soft_uni.addresses
  69. Oct 28, 2016 9:22:05 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  70. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  71. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  72.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:62)
  73.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString(SchemaDropperImpl.java:374)
  74.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings(SchemaDropperImpl.java:359)
  75.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.dropFromMetadata(SchemaDropperImpl.java:241)
  76.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.performDrop(SchemaDropperImpl.java:154)
  77.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:126)
  78.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:112)
  79.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:137)
  80.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
  81.     at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:307)
  82.     at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:490)
  83.     at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:878)
  84.     at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  85.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  86.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  87.     at Demo.main(Demo.java:12)
  88. Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails
  89.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:557)
  90.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
  91.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
  92.     at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
  93.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2011)
  94.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1964)
  95.     at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
  96.     at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
  97.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:49)
  98.     ... 15 more
  99.  
  100. Hibernate: drop table if exists soft_uni.departments
  101. Hibernate: drop table if exists soft_uni.employees
  102. Oct 28, 2016 9:22:05 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  103. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  104. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  105.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:62)
  106.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString(SchemaDropperImpl.java:374)
  107.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings(SchemaDropperImpl.java:359)
  108.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.dropFromMetadata(SchemaDropperImpl.java:241)
  109.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.performDrop(SchemaDropperImpl.java:154)
  110.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:126)
  111.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:112)
  112.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:137)
  113.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
  114.     at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:307)
  115.     at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:490)
  116.     at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:878)
  117.     at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  118.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  119.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  120.     at Demo.main(Demo.java:12)
  121. Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails
  122.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:557)
  123.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
  124.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
  125.     at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
  126.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2011)
  127.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1964)
  128.     at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
  129.     at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
  130.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:49)
  131.     ... 15 more
  132.  
  133. Oct 28, 2016 9:22:05 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  134. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  135. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  136.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:62)
  137.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString(SchemaDropperImpl.java:374)
  138.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings(SchemaDropperImpl.java:359)
  139.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.dropFromMetadata(SchemaDropperImpl.java:241)
  140.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.performDrop(SchemaDropperImpl.java:154)
  141.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:126)
  142.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:112)
  143.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:137)
  144.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
  145.     at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:307)
  146.     at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:490)
  147.     at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:878)
  148.     at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  149.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  150.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  151.     at Demo.main(Demo.java:12)
  152. Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails
  153.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:557)
  154.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
  155.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
  156.     at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
  157.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2011)
  158.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1964)
  159.     at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
  160.     at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
  161.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:49)
  162.     ... 15 more
  163.  
  164. Hibernate: drop table if exists soft_uni.employees_projects
  165. Hibernate: drop table if exists soft_uni.projects
  166. Hibernate: drop table if exists soft_uni.towns
  167. Oct 28, 2016 9:22:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  168. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  169. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  170.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:62)
  171.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString(SchemaDropperImpl.java:374)
  172.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings(SchemaDropperImpl.java:359)
  173.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.dropFromMetadata(SchemaDropperImpl.java:241)
  174.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.performDrop(SchemaDropperImpl.java:154)
  175.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:126)
  176.     at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:112)
  177.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:137)
  178.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
  179.     at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:307)
  180.     at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:490)
  181.     at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:878)
  182.     at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  183.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  184.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  185.     at Demo.main(Demo.java:12)
  186. Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails
  187.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:557)
  188.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
  189.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
  190.     at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
  191.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2011)
  192.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1964)
  193.     at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
  194.     at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
  195.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:49)
  196.     ... 15 more
  197.  
  198. Hibernate: create table soft_uni.addresses (address_id integer not null auto_increment, address_text varchar(100) not null, town_id integer, primary key (address_id))
  199. Oct 28, 2016 9:22:06 PM org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection
  200. INFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@c80397] for (non-JTA) DDL execution was not in auto-commit mode; the Connection 'local transaction' will be committed and the Connection will be set into auto-commit mode.
  201. Oct 28, 2016 9:22:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  202. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  203. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  204.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:62)
  205.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:438)
  206.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:423)
  207.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:314)
  208.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:165)
  209.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:134)
  210.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:120)
  211.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:148)
  212.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
  213.     at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:307)
  214.     at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:490)
  215.     at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:878)
  216.     at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  217.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  218.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  219.     at Demo.main(Demo.java:12)
  220. Caused by: java.sql.SQLSyntaxErrorException: Table 'addresses' already exists
  221.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:560)
  222.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
  223.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
  224.     at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
  225.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2011)
  226.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1964)
  227.     at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
  228.     at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
  229.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:49)
  230.     ... 15 more
  231.  
  232. Hibernate: create table soft_uni.departments (department_id integer not null auto_increment, name varchar(50) not null, manager_id integer not null, primary key (department_id))
  233. Oct 28, 2016 9:22:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  234. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  235. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  236.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:62)
  237.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:438)
  238.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:423)
  239.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:314)
  240.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:165)
  241.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:134)
  242.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:120)
  243.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:148)
  244.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
  245.     at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:307)
  246.     at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:490)
  247.     at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:878)
  248.     at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  249.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  250.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  251.     at Demo.main(Demo.java:12)
  252. Caused by: java.sql.SQLSyntaxErrorException: Table 'departments' already exists
  253.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:560)
  254.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
  255.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
  256.     at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
  257.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2011)
  258.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1964)
  259.     at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
  260.     at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
  261.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:49)
  262.     ... 15 more
  263.  
  264. Hibernate: create table soft_uni.employees (employee_id integer not null auto_increment, first_name varchar(50) not null, hire_date datetime not null, job_title varchar(50) not null, last_name varchar(50) not null, middle_name varchar(50), salary decimal(19,2) not null, address_id integer, department_id integer not null, manager_id integer, primary key (employee_id))
  265. Oct 28, 2016 9:22:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  266. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  267. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  268.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:62)
  269.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:438)
  270.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:423)
  271.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:314)
  272.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:165)
  273.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:134)
  274.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:120)
  275.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:148)
  276.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
  277.     at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:307)
  278.     at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:490)
  279.     at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:878)
  280.     at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  281.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  282.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  283.     at Demo.main(Demo.java:12)
  284. Caused by: java.sql.SQLSyntaxErrorException: Table 'employees' already exists
  285.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:560)
  286.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
  287.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
  288.     at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
  289.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2011)
  290.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1964)
  291.     at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
  292.     at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
  293.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:49)
  294.     ... 15 more
  295.  
  296. Hibernate: create table soft_uni.employees_projects (employee_id integer not null, project_id integer not null, primary key (employee_id, project_id))
  297. Hibernate: create table soft_uni.projects (project_id integer not null auto_increment, description varchar(65535), end_date datetime, name varchar(50) not null, start_date datetime not null, primary key (project_id))
  298. Oct 28, 2016 9:22:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  299. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  300. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  301.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:62)
  302.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:438)
  303.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:423)
  304.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:314)
  305.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:165)
  306.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:134)
  307.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:120)
  308.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:148)
  309.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
  310.     at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:307)
  311.     at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:490)
  312.     at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:878)
  313.     at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  314.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  315.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  316.     at Demo.main(Demo.java:12)
  317. Caused by: java.sql.SQLSyntaxErrorException: Column length too big for column 'description' (max = 21845); use BLOB or TEXT instead
  318.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:560)
  319.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
  320.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
  321.     at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
  322.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2011)
  323.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1964)
  324.     at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
  325.     at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
  326.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:49)
  327.     ... 15 more
  328.  
  329. Hibernate: create table soft_uni.towns (town_id integer not null auto_increment, name varchar(50) not null, primary key (town_id))
  330. Oct 28, 2016 9:22:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  331. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  332. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  333.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:62)
  334.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:438)
  335.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:423)
  336.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:314)
  337.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:165)
  338.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:134)
  339.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:120)
  340.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:148)
  341.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
  342.     at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:307)
  343.     at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:490)
  344.     at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:878)
  345.     at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  346.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  347.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  348.     at Demo.main(Demo.java:12)
  349. Caused by: java.sql.SQLSyntaxErrorException: Table 'towns' already exists
  350.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:560)
  351.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
  352.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
  353.     at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
  354.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2011)
  355.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1964)
  356.     at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
  357.     at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
  358.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:49)
  359.     ... 15 more
  360.  
  361. Hibernate: alter table soft_uni.addresses add constraint FKerxjso85moxthd5pitjsakyb7 foreign key (town_id) references soft_uni.towns (town_id)
  362. Hibernate: alter table soft_uni.departments add constraint FK56q3esufky8u69xbmo4n63c4r foreign key (manager_id) references soft_uni.employees (employee_id)
  363. Hibernate: alter table soft_uni.employees add constraint FKkvaekcr8qinc0oo3kxwxgtyt9 foreign key (address_id) references soft_uni.addresses (address_id)
  364. Hibernate: alter table soft_uni.employees add constraint FKgy4qe3dnqrm3ktd76sxp7n4c2 foreign key (department_id) references soft_uni.departments (department_id)
  365. Hibernate: alter table soft_uni.employees add constraint FKi4365uo9af35g7jtbc2rteukt foreign key (manager_id) references soft_uni.employees (employee_id)
  366. Hibernate: alter table soft_uni.employees_projects add constraint FKc9x9r7nbtwnx24vcrfxym9cyy foreign key (project_id) references soft_uni.projects (project_id)
  367. Oct 28, 2016 9:22:11 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  368. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  369. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  370.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:62)
  371.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:438)
  372.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlStrings(SchemaCreatorImpl.java:423)
  373.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:374)
  374.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:165)
  375.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:134)
  376.     at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:120)
  377.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:148)
  378.     at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
  379.     at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:307)
  380.     at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:490)
  381.     at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:878)
  382.     at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  383.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  384.     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  385.     at Demo.main(Demo.java:12)
  386. Caused by: java.sql.SQLException: Cannot add foreign key constraint
  387.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:569)
  388.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
  389.     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
  390.     at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
  391.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2011)
  392.     at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1964)
  393.     at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891)
  394.     at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795)
  395.     at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:49)
  396.     ... 15 more
  397.  
  398. Hibernate: alter table soft_uni.employees_projects add constraint FKbslohhow39ayel1dc6cdus5sc foreign key (employee_id) references soft_uni.employees (employee_id)
  399. Oct 28, 2016 9:22:12 PM org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources
  400. INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@ebfd03'
  401. Hibernate: insert into soft_uni.towns (name) values (?)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!