WaXPg0gQ

1Oct 28, 2016 9:22:03 PM org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
2INFO: HHH000204: Processing PersistenceUnitInfo [
3	name: soft_uni
4	...]
5Oct 28, 2016 9:22:03 PM org.hibernate.Version logVersion
6INFO: HHH000412: Hibernate Core {5.2.2.Final}
7Oct 28, 2016 9:22:03 PM org.hibernate.cfg.Environment <clinit>
8INFO: HHH000206: hibernate.properties not found
9Oct 28, 2016 9:22:03 PM org.hibernate.cfg.Environment buildBytecodeProvider
10INFO: HHH000021: Bytecode provider name : javassist
11Oct 28, 2016 9:22:03 PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
12INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
13Oct 28, 2016 9:22:04 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
14WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
15Loading 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.
16Oct 28, 2016 9:22:04 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
17INFO: HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost/soft_uni]
18Oct 28, 2016 9:22:04 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
19INFO: HHH10001001: Connection properties: {user=root, password=****}
20Oct 28, 2016 9:22:04 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
21INFO: HHH10001003: Autocommit mode: false
22Oct 28, 2016 9:22:04 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
23INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
24Fri 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.
25Oct 28, 2016 9:22:04 PM org.hibernate.dialect.Dialect <init>
26INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect
27Hibernate: alter table soft_uni.addresses drop foreign key FKerxjso85moxthd5pitjsakyb7
28Oct 28, 2016 9:22:04 PM org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection
29INFO: 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.
30Hibernate: alter table soft_uni.departments drop foreign key FK56q3esufky8u69xbmo4n63c4r
31Hibernate: alter table soft_uni.employees drop foreign key FKkvaekcr8qinc0oo3kxwxgtyt9
32Hibernate: alter table soft_uni.employees drop foreign key FKgy4qe3dnqrm3ktd76sxp7n4c2
33Hibernate: alter table soft_uni.employees drop foreign key FKi4365uo9af35g7jtbc2rteukt
34Hibernate: alter table soft_uni.employees_projects drop foreign key FKc9x9r7nbtwnx24vcrfxym9cyy
35Oct 28, 2016 9:22:05 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
36WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
37org.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)
55Caused 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
67Hibernate: alter table soft_uni.employees_projects drop foreign key FKbslohhow39ayel1dc6cdus5sc
68Hibernate: drop table if exists soft_uni.addresses
69Oct 28, 2016 9:22:05 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
70WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
71org.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)
88Caused 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
100Hibernate: drop table if exists soft_uni.departments
101Hibernate: drop table if exists soft_uni.employees
102Oct 28, 2016 9:22:05 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
103WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
104org.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)
121Caused 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
133Oct 28, 2016 9:22:05 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
134WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
135org.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)
152Caused 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
164Hibernate: drop table if exists soft_uni.employees_projects
165Hibernate: drop table if exists soft_uni.projects
166Hibernate: drop table if exists soft_uni.towns
167Oct 28, 2016 9:22:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
168WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
169org.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)
186Caused 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
198Hibernate: 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))
199Oct 28, 2016 9:22:06 PM org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection
200INFO: 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.
201Oct 28, 2016 9:22:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
202WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
203org.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)
220Caused 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
232Hibernate: 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))
233Oct 28, 2016 9:22:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
234WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
235org.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)
252Caused 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
264Hibernate: 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))
265Oct 28, 2016 9:22:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
266WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
267org.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)
284Caused 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
296Hibernate: create table soft_uni.employees_projects (employee_id integer not null, project_id integer not null, primary key (employee_id, project_id))
297Hibernate: 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))
298Oct 28, 2016 9:22:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
299WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
300org.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)
317Caused 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
329Hibernate: create table soft_uni.towns (town_id integer not null auto_increment, name varchar(50) not null, primary key (town_id))
330Oct 28, 2016 9:22:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
331WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
332org.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)
349Caused 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
361Hibernate: alter table soft_uni.addresses add constraint FKerxjso85moxthd5pitjsakyb7 foreign key (town_id) references soft_uni.towns (town_id)
362Hibernate: alter table soft_uni.departments add constraint FK56q3esufky8u69xbmo4n63c4r foreign key (manager_id) references soft_uni.employees (employee_id)
363Hibernate: alter table soft_uni.employees add constraint FKkvaekcr8qinc0oo3kxwxgtyt9 foreign key (address_id) references soft_uni.addresses (address_id)
364Hibernate: alter table soft_uni.employees add constraint FKgy4qe3dnqrm3ktd76sxp7n4c2 foreign key (department_id) references soft_uni.departments (department_id)
365Hibernate: alter table soft_uni.employees add constraint FKi4365uo9af35g7jtbc2rteukt foreign key (manager_id) references soft_uni.employees (employee_id)
366Hibernate: alter table soft_uni.employees_projects add constraint FKc9x9r7nbtwnx24vcrfxym9cyy foreign key (project_id) references soft_uni.projects (project_id)
367Oct 28, 2016 9:22:11 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
368WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
369org.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)
386Caused 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
398Hibernate: alter table soft_uni.employees_projects add constraint FKbslohhow39ayel1dc6cdus5sc foreign key (employee_id) references soft_uni.employees (employee_id)
399Oct 28, 2016 9:22:12 PM org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources
400INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@ebfd03'
401Hibernate: insert into soft_uni.towns (name) values (?)