Advertisement
Guest User

Untitled

a guest
May 8th, 2016
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.87 KB | None | 0 0
  1. mag 08, 2016 6:29:50 PM org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
  2. INFO: HHH000204: Processing PersistenceUnitInfo [
  3. name: commerce-unit
  4. ...]
  5. mag 08, 2016 6:29:50 PM org.hibernate.Version logVersion
  6. INFO: HHH000412: Hibernate Core {5.1.0.Final}
  7. mag 08, 2016 6:29:50 PM org.hibernate.cfg.Environment <clinit>
  8. INFO: HHH000206: hibernate.properties not found
  9. mag 08, 2016 6:29:50 PM org.hibernate.cfg.Environment buildBytecodeProvider
  10. INFO: HHH000021: Bytecode provider name : javassist
  11. mag 08, 2016 6:29:50 PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
  12. INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
  13. mag 08, 2016 6:29:50 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
  14. WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
  15. mag 08, 2016 6:29:50 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  16. INFO: HHH10001005: using driver [org.postgresql.Driver] at URL [jdbc:postgresql://localhost/commerce]
  17. mag 08, 2016 6:29:50 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  18. INFO: HHH10001001: Connection properties: {user=postgres, password=****}
  19. mag 08, 2016 6:29:50 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  20. INFO: HHH10001003: Autocommit mode: false
  21. mag 08, 2016 6:29:50 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
  22. INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
  23. mag 08, 2016 6:29:50 PM org.hibernate.dialect.Dialect <init>
  24. INFO: HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect
  25. mag 08, 2016 6:29:50 PM org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl useContextualLobCreation
  26. INFO: HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
  27. mag 08, 2016 6:29:50 PM org.hibernate.type.BasicTypeRegistry register
  28. INFO: HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@524d6d96
  29. Hibernate:
  30. alter table Customer
  31. drop constraint FKfok4ytcqy7lovuiilldbebpd9
  32. Hibernate:
  33. alter table order_line
  34. drop constraint FKn2kcjpsik53mvru6nfqlu6ejn
  35. Hibernate:
  36. alter table order_line
  37. drop constraint FK2aqxln75q7fo8yvewbbws5mx9
  38. Hibernate:
  39. alter table orders
  40. drop constraint FKlxvrjb6oyfjjffp0vvusn22uy
  41. Hibernate:
  42. alter table Provider
  43. drop constraint FKt9vbbwgnd3e4di9f8lcgtc43k
  44. Hibernate:
  45. alter table Provider_Product
  46. drop constraint FKfgpx34j94m2ialpk9eprimjdd
  47. Hibernate:
  48. alter table Provider_Product
  49. drop constraint FKf4ah0t40tl5x9ddllwv3pmemh
  50. Hibernate:
  51. drop table if exists Address cascade
  52. Hibernate:
  53. drop table if exists Customer cascade
  54. Hibernate:
  55. drop table if exists order_line cascade
  56. Hibernate:
  57. drop table if exists orders cascade
  58. Hibernate:
  59. drop table if exists Product cascade
  60. Hibernate:
  61. drop table if exists Provider cascade
  62. Hibernate:
  63. drop table if exists Provider_Product cascade
  64. Hibernate:
  65. drop sequence hibernate_sequence
  66. Hibernate: create sequence hibernate_sequence start 1 increment 1
  67. Hibernate:
  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. )
  77. Hibernate:
  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. )
  89. Hibernate:
  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. )
  98. Hibernate:
  99. create table orders (
  100. id int8 not null,
  101. creationTime timestamp not null,
  102. customer_id int8,
  103. primary key (id)
  104. )
  105. Hibernate:
  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. )
  114. Hibernate:
  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. )
  124. Hibernate:
  125. create table Provider_Product (
  126. providers_id int8 not null,
  127. products_id int8 not null
  128. )
  129. Hibernate:
  130. alter table Customer
  131. add constraint FKfok4ytcqy7lovuiilldbebpd9
  132. foreign key (address_id)
  133. references Address
  134. Hibernate:
  135. alter table order_line
  136. add constraint FKn2kcjpsik53mvru6nfqlu6ejn
  137. foreign key (product_id)
  138. references Product
  139. Hibernate:
  140. alter table order_line
  141. add constraint FK2aqxln75q7fo8yvewbbws5mx9
  142. foreign key (orders_id)
  143. references orders
  144. Hibernate:
  145. alter table orders
  146. add constraint FKlxvrjb6oyfjjffp0vvusn22uy
  147. foreign key (customer_id)
  148. references Customer
  149. Hibernate:
  150. alter table Provider
  151. add constraint FKt9vbbwgnd3e4di9f8lcgtc43k
  152. foreign key (address_id)
  153. references Address
  154. Hibernate:
  155. alter table Provider_Product
  156. add constraint FKfgpx34j94m2ialpk9eprimjdd
  157. foreign key (products_id)
  158. references Product
  159. Hibernate:
  160. alter table Provider_Product
  161. add constraint FKf4ah0t40tl5x9ddllwv3pmemh
  162. foreign key (providers_id)
  163. references Provider
  164. mag 08, 2016 6:29:51 PM org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources
  165. INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@62ea3440'
  166. mag 08, 2016 6:29:51 PM org.hibernate.hql.internal.QueryTranslatorFactoryInitiator initiateService
  167. INFO: HHH000397: Using ASTQueryTranslatorFactory
  168. Hibernate:
  169. select
  170. nextval ('hibernate_sequence')
  171. Hibernate:
  172. select
  173. nextval ('hibernate_sequence')
  174. Hibernate:
  175. select
  176. nextval ('hibernate_sequence')
  177. Hibernate:
  178. select
  179. nextval ('hibernate_sequence')
  180. Hibernate:
  181. select
  182. nextval ('hibernate_sequence')
  183. Hibernate:
  184. insert
  185. into
  186. Address
  187. (city, country, state, street, zipCode, id)
  188. values
  189. (?, ?, ?, ?, ?, ?)
  190. Hibernate:
  191. insert
  192. into
  193. Customer
  194. (address_id, creationTime, dateOfBirth, email, firstname, lastname, phoneNumber, id)
  195. values
  196. (?, ?, ?, ?, ?, ?, ?, ?)
  197. Hibernate:
  198. insert
  199. into
  200. orders
  201. (creationTime, customer_id, id)
  202. values
  203. (?, ?, ?)
  204. Hibernate:
  205. insert
  206. into
  207. orders
  208. (creationTime, customer_id, id)
  209. values
  210. (?, ?, ?)
  211. Hibernate:
  212. insert
  213. into
  214. orders
  215. (creationTime, customer_id, id)
  216. values
  217. (?, ?, ?)
  218. mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl stop
  219. INFO: HHH10001008: Cleaning up connection pool [jdbc:postgresql://localhost/commerce]
  220. mag 08, 2016 6:29:51 PM org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
  221. INFO: HHH000204: Processing PersistenceUnitInfo [
  222. name: commerce-unit
  223. ...]
  224. mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
  225. WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
  226. mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  227. INFO: HHH10001005: using driver [org.postgresql.Driver] at URL [jdbc:postgresql://localhost/commerce]
  228. mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  229. INFO: HHH10001001: Connection properties: {user=postgres, password=****}
  230. mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  231. INFO: HHH10001003: Autocommit mode: false
  232. mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
  233. INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
  234. mag 08, 2016 6:29:51 PM org.hibernate.dialect.Dialect <init>
  235. INFO: HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect
  236. mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl useContextualLobCreation
  237. INFO: HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
  238. mag 08, 2016 6:29:51 PM org.hibernate.type.BasicTypeRegistry register
  239. INFO: HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@524d6d96
  240. Hibernate:
  241. alter table Customer
  242. drop constraint FKfok4ytcqy7lovuiilldbebpd9
  243. Hibernate:
  244. alter table order_line
  245. drop constraint FKn2kcjpsik53mvru6nfqlu6ejn
  246. Hibernate:
  247. alter table order_line
  248. drop constraint FK2aqxln75q7fo8yvewbbws5mx9
  249. Hibernate:
  250. alter table orders
  251. drop constraint FKlxvrjb6oyfjjffp0vvusn22uy
  252. Hibernate:
  253. alter table Provider
  254. drop constraint FKt9vbbwgnd3e4di9f8lcgtc43k
  255. Hibernate:
  256. alter table Provider_Product
  257. drop constraint FKfgpx34j94m2ialpk9eprimjdd
  258. Hibernate:
  259. alter table Provider_Product
  260. drop constraint FKf4ah0t40tl5x9ddllwv3pmemh
  261. Hibernate:
  262. drop table if exists Address cascade
  263. Hibernate:
  264. drop table if exists Customer cascade
  265. Hibernate:
  266. drop table if exists order_line cascade
  267. Hibernate:
  268. drop table if exists orders cascade
  269. Hibernate:
  270. drop table if exists Product cascade
  271. Hibernate:
  272. drop table if exists Provider cascade
  273. Hibernate:
  274. drop table if exists Provider_Product cascade
  275. Hibernate:
  276. drop sequence hibernate_sequence
  277. Hibernate: create sequence hibernate_sequence start 1 increment 1
  278. Hibernate:
  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. )
  288. Hibernate:
  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. )
  300. Hibernate:
  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. )
  309. Hibernate:
  310. create table orders (
  311. id int8 not null,
  312. creationTime timestamp not null,
  313. customer_id int8,
  314. primary key (id)
  315. )
  316. Hibernate:
  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. )
  325. Hibernate:
  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. )
  335. Hibernate:
  336. create table Provider_Product (
  337. providers_id int8 not null,
  338. products_id int8 not null
  339. )
  340. Hibernate:
  341. alter table Customer
  342. add constraint FKfok4ytcqy7lovuiilldbebpd9
  343. foreign key (address_id)
  344. references Address
  345. Hibernate:
  346. alter table order_line
  347. add constraint FKn2kcjpsik53mvru6nfqlu6ejn
  348. foreign key (product_id)
  349. references Product
  350. Hibernate:
  351. alter table order_line
  352. add constraint FK2aqxln75q7fo8yvewbbws5mx9
  353. foreign key (orders_id)
  354. references orders
  355. Hibernate:
  356. alter table orders
  357. add constraint FKlxvrjb6oyfjjffp0vvusn22uy
  358. foreign key (customer_id)
  359. references Customer
  360. Hibernate:
  361. alter table Provider
  362. add constraint FKt9vbbwgnd3e4di9f8lcgtc43k
  363. foreign key (address_id)
  364. references Address
  365. Hibernate:
  366. alter table Provider_Product
  367. add constraint FKfgpx34j94m2ialpk9eprimjdd
  368. foreign key (products_id)
  369. references Product
  370. Hibernate:
  371. alter table Provider_Product
  372. add constraint FKf4ah0t40tl5x9ddllwv3pmemh
  373. foreign key (providers_id)
  374. references Provider
  375. mag 08, 2016 6:29:51 PM org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources
  376. INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@62ea3440'
  377. mag 08, 2016 6:29:51 PM org.hibernate.hql.internal.QueryTranslatorFactoryInitiator initiateService
  378. INFO: HHH000397: Using ASTQueryTranslatorFactory
  379. Unable 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.
  380. mag 08, 2016 6:29:51 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl stop
  381. INFO: HHH10001008: Cleaning up connection pool [jdbc:postgresql://localhost/commerce]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement