Ux3BLKM9

1mag 08, 2016 6:29:50 PM org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
2INFO: HHH000204: Processing PersistenceUnitInfo [
3	name: commerce-unit
4	...]
5mag 08, 2016 6:29:50 PM org.hibernate.Version logVersion
6INFO: HHH000412: Hibernate Core {5.1.0.Final}
7mag 08, 2016 6:29:50 PM org.hibernate.cfg.Environment <clinit>
8INFO: HHH000206: hibernate.properties not found
9mag 08, 2016 6:29:50 PM org.hibernate.cfg.Environment buildBytecodeProvider
10INFO: HHH000021: Bytecode provider name : javassist
11mag 08, 2016 6:29:50 PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
12INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
13mag 08, 2016 6:29:50 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
14WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
15mag 08, 2016 6:29:50 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
16INFO: HHH10001005: using driver [org.postgresql.Driver] at URL [jdbc:postgresql://localhost/commerce]
17mag 08, 2016 6:29:50 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
18INFO: HHH10001001: Connection properties: {user=postgres, password=****}
19mag 08, 2016 6:29:50 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
20INFO: HHH10001003: Autocommit mode: false
21mag 08, 2016 6:29:50 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
22INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
23mag 08, 2016 6:29:50 PM org.hibernate.dialect.Dialect <init>
24INFO: HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect
25mag 08, 2016 6:29:50 PM org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl useContextualLobCreation
26INFO: HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
27mag 08, 2016 6:29:50 PM org.hibernate.type.BasicTypeRegistry register
28INFO: HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@524d6d96
29Hibernate: 
30    alter table Customer 
31        drop constraint FKfok4ytcqy7lovuiilldbebpd9
32Hibernate: 
33    alter table order_line 
34        drop constraint FKn2kcjpsik53mvru6nfqlu6ejn
35Hibernate: 
36    alter table order_line 
37        drop constraint FK2aqxln75q7fo8yvewbbws5mx9
38Hibernate: 
39    alter table orders 
40        drop constraint FKlxvrjb6oyfjjffp0vvusn22uy
41Hibernate: 
42    alter table Provider 
43        drop constraint FKt9vbbwgnd3e4di9f8lcgtc43k
44Hibernate: 
45    alter table Provider_Product 
46        drop constraint FKfgpx34j94m2ialpk9eprimjdd
47Hibernate: 
48    alter table Provider_Product 
49        drop constraint FKf4ah0t40tl5x9ddllwv3pmemh
50Hibernate: 
51    drop table if exists Address cascade
52Hibernate: 
53    drop table if exists Customer cascade
54Hibernate: 
55    drop table if exists order_line cascade
56Hibernate: 
57    drop table if exists orders cascade
58Hibernate: 
59    drop table if exists Product cascade
60Hibernate: 
61    drop table if exists Provider cascade
62Hibernate: 
63    drop table if exists Provider_Product cascade
64Hibernate: 
65    drop sequence hibernate_sequence
66Hibernate: create sequence hibernate_sequence start 1 increment 1
67Hibernate: 
68    create table Address (
69        id int8 not null,
70        city varchar(255) not null,
71        country varchar(255) not null,
72        state varchar(255) not null,
73        street varchar(255) not null,
74        zipCode varchar(255) not null,
75        primary key (id)
76    )
77Hibernate: 
78    create table Customer (
79        id int8 not null,
80        creationTime timestamp,
81        dateOfBirth date,
82        email varchar(255),
83        firstname varchar(255) not null,
84        lastname varchar(255) not null,
85        phoneNumber varchar(255) not null,
86        address_id int8,
87        primary key (id)
88    )
89Hibernate: 
90    create table order_line (
91        id int8 not null,
92        quantity int4 not null,
93        unitPrice float4 not null,
94        product_id int8,
95        orders_id int8,
96        primary key (id)
97    )
98Hibernate: 
99    create table orders (
100        id int8 not null,
101        creationTime timestamp not null,
102        customer_id int8,
103        primary key (id)
104    )
105Hibernate: 
106    create table Product (
107        id int8 not null,
108        code varchar(255) not null,
109        description varchar(2000),
110        name varchar(255) not null,
111        price float4,
112        primary key (id)
113    )
114Hibernate: 
115    create table Provider (
116        id int8 not null,
117        email varchar(255),
118        name varchar(255) not null,
119        phoneNumber varchar(255) not null,
120        vatin varchar(255),
121        address_id int8,
122        primary key (id)
123    )
124Hibernate: 
125    create table Provider_Product (
126        providers_id int8 not null,
127        products_id int8 not null
128    )
129Hibernate: 
130    alter table Customer 
131        add constraint FKfok4ytcqy7lovuiilldbebpd9 
132        foreign key (address_id) 
133        references Address
134Hibernate: 
135    alter table order_line 
136        add constraint FKn2kcjpsik53mvru6nfqlu6ejn 
137        foreign key (product_id) 
138        references Product
139Hibernate: 
140    alter table order_line 
141        add constraint FK2aqxln75q7fo8yvewbbws5mx9 
142        foreign key (orders_id) 
143        references orders
144Hibernate: 
145    alter table orders 
146        add constraint FKlxvrjb6oyfjjffp0vvusn22uy 
147        foreign key (customer_id) 
148        references Customer
149Hibernate: 
150    alter table Provider 
151        add constraint FKt9vbbwgnd3e4di9f8lcgtc43k 
152        foreign key (address_id) 
153        references Address
154Hibernate: 
155    alter table Provider_Product 
156        add constraint FKfgpx34j94m2ialpk9eprimjdd 
157        foreign key (products_id) 
158        references Product
159Hibernate: 
160    alter table Provider_Product 
161        add constraint FKf4ah0t40tl5x9ddllwv3pmemh 
162        foreign key (providers_id) 
163        references Provider
164mag 08, 2016 6:29:51 PM org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources
165INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@62ea3440'
166mag 08, 2016 6:29:51 PM org.hibernate.hql.internal.QueryTranslatorFactoryInitiator initiateService
167INFO: HHH000397: Using ASTQueryTranslatorFactory
168Hibernate: 
169    select
170        nextval ('hibernate_sequence')
171Hibernate: 
172    select
173        nextval ('hibernate_sequence')
174Hibernate: 
175    select
176        nextval ('hibernate_sequence')
177Hibernate: 
178    select
179        nextval ('hibernate_sequence')
180Hibernate: 
181    select
182        nextval ('hibernate_sequence')
183Hibernate: 
184    insert 
185    into
186        Address
187        (city, country, state, street, zipCode, id) 
188    values
189        (?, ?, ?, ?, ?, ?)
190Hibernate: 
191    insert 
192    into
193        Customer
194        (address_id, creationTime, dateOfBirth, email, firstname, lastname, phoneNumber, id) 
195    values
196        (?, ?, ?, ?, ?, ?, ?, ?)
197Hibernate: 
198    insert 
199    into
200        orders
201        (creationTime, customer_id, id) 
202    values
203        (?, ?, ?)
204Hibernate: 
205    insert 
206    into
207        orders
208        (creationTime, customer_id, id) 
209    values
210        (?, ?, ?)
211Hibernate: 
212    insert 
213    into
214        orders
215        (creationTime, customer_id, id) 
216    values
217        (?, ?, ?)
218mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl stop
219INFO: HHH10001008: Cleaning up connection pool [jdbc:postgresql://localhost/commerce]
220mag 08, 2016 6:29:51 PM org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
221INFO: HHH000204: Processing PersistenceUnitInfo [
222	name: commerce-unit
223	...]
224mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
225WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
226mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
227INFO: HHH10001005: using driver [org.postgresql.Driver] at URL [jdbc:postgresql://localhost/commerce]
228mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
229INFO: HHH10001001: Connection properties: {user=postgres, password=****}
230mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
231INFO: HHH10001003: Autocommit mode: false
232mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
233INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
234mag 08, 2016 6:29:51 PM org.hibernate.dialect.Dialect <init>
235INFO: HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect
236mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl useContextualLobCreation
237INFO: HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
238mag 08, 2016 6:29:51 PM org.hibernate.type.BasicTypeRegistry register
239INFO: HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@524d6d96
240Hibernate: 
241    alter table Customer 
242        drop constraint FKfok4ytcqy7lovuiilldbebpd9
243Hibernate: 
244    alter table order_line 
245        drop constraint FKn2kcjpsik53mvru6nfqlu6ejn
246Hibernate: 
247    alter table order_line 
248        drop constraint FK2aqxln75q7fo8yvewbbws5mx9
249Hibernate: 
250    alter table orders 
251        drop constraint FKlxvrjb6oyfjjffp0vvusn22uy
252Hibernate: 
253    alter table Provider 
254        drop constraint FKt9vbbwgnd3e4di9f8lcgtc43k
255Hibernate: 
256    alter table Provider_Product 
257        drop constraint FKfgpx34j94m2ialpk9eprimjdd
258Hibernate: 
259    alter table Provider_Product 
260        drop constraint FKf4ah0t40tl5x9ddllwv3pmemh
261Hibernate: 
262    drop table if exists Address cascade
263Hibernate: 
264    drop table if exists Customer cascade
265Hibernate: 
266    drop table if exists order_line cascade
267Hibernate: 
268    drop table if exists orders cascade
269Hibernate: 
270    drop table if exists Product cascade
271Hibernate: 
272    drop table if exists Provider cascade
273Hibernate: 
274    drop table if exists Provider_Product cascade
275Hibernate: 
276    drop sequence hibernate_sequence
277Hibernate: create sequence hibernate_sequence start 1 increment 1
278Hibernate: 
279    create table Address (
280        id int8 not null,
281        city varchar(255) not null,
282        country varchar(255) not null,
283        state varchar(255) not null,
284        street varchar(255) not null,
285        zipCode varchar(255) not null,
286        primary key (id)
287    )
288Hibernate: 
289    create table Customer (
290        id int8 not null,
291        creationTime timestamp,
292        dateOfBirth date,
293        email varchar(255),
294        firstname varchar(255) not null,
295        lastname varchar(255) not null,
296        phoneNumber varchar(255) not null,
297        address_id int8,
298        primary key (id)
299    )
300Hibernate: 
301    create table order_line (
302        id int8 not null,
303        quantity int4 not null,
304        unitPrice float4 not null,
305        product_id int8,
306        orders_id int8,
307        primary key (id)
308    )
309Hibernate: 
310    create table orders (
311        id int8 not null,
312        creationTime timestamp not null,
313        customer_id int8,
314        primary key (id)
315    )
316Hibernate: 
317    create table Product (
318        id int8 not null,
319        code varchar(255) not null,
320        description varchar(2000),
321        name varchar(255) not null,
322        price float4,
323        primary key (id)
324    )
325Hibernate: 
326    create table Provider (
327        id int8 not null,
328        email varchar(255),
329        name varchar(255) not null,
330        phoneNumber varchar(255) not null,
331        vatin varchar(255),
332        address_id int8,
333        primary key (id)
334    )
335Hibernate: 
336    create table Provider_Product (
337        providers_id int8 not null,
338        products_id int8 not null
339    )
340Hibernate: 
341    alter table Customer 
342        add constraint FKfok4ytcqy7lovuiilldbebpd9 
343        foreign key (address_id) 
344        references Address
345Hibernate: 
346    alter table order_line 
347        add constraint FKn2kcjpsik53mvru6nfqlu6ejn 
348        foreign key (product_id) 
349        references Product
350Hibernate: 
351    alter table order_line 
352        add constraint FK2aqxln75q7fo8yvewbbws5mx9 
353        foreign key (orders_id) 
354        references orders
355Hibernate: 
356    alter table orders 
357        add constraint FKlxvrjb6oyfjjffp0vvusn22uy 
358        foreign key (customer_id) 
359        references Customer
360Hibernate: 
361    alter table Provider 
362        add constraint FKt9vbbwgnd3e4di9f8lcgtc43k 
363        foreign key (address_id) 
364        references Address
365Hibernate: 
366    alter table Provider_Product 
367        add constraint FKfgpx34j94m2ialpk9eprimjdd 
368        foreign key (products_id) 
369        references Product
370Hibernate: 
371    alter table Provider_Product 
372        add constraint FKf4ah0t40tl5x9ddllwv3pmemh 
373        foreign key (providers_id) 
374        references Provider
375mag 08, 2016 6:29:51 PM org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources
376INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@62ea3440'
377mag 08, 2016 6:29:51 PM org.hibernate.hql.internal.QueryTranslatorFactoryInitiator initiateService
378INFO: HHH000397: Using ASTQueryTranslatorFactory
379Unable to delete Customer [id=1, firstname=Alessandro, lastname=Giannetti, email=ale.giannetti@hotmail.it, phoneNumber=32412421, creationTime=null, dateOfBirth=null]: there are references to it.
380mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl stop
381INFO: HHH10001008: Cleaning up connection pool [jdbc:postgresql://localhost/commerce]