API tools faq
paste
Guest User

Untitled

a guest
Feb 17th, 2018
129
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.13 KB | None | 0 0
raw download clone embed print report
  1. package warmlight.base.entities;
  2. import java.util.HashSet;
  3. import java.util.Set;
  4.  
  5. import javax.persistence.CascadeType;
  6. import javax.persistence.Column;
  7. import javax.persistence.Entity;
  8. import javax.persistence.FetchType;
  9. import javax.persistence.Id;
  10. import javax.persistence.OneToMany;
  11. import javax.persistence.Table;
  12.  
  13. @Entity
  14. @Table(name="category")
  15. public class CategoryEntity {
  16.  
  17. @Id
  18. private int id;
  19. @Column(unique=true, nullable = false)
  20. private String name;
  21. private String description;
  22. @Column(name = "shown", nullable = false)
  23. private boolean shown;
  24. @OneToMany (mappedBy="category", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
  25. private Set<ItemEntity> items = new HashSet<>();
  26. @OneToMany (mappedBy="category", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
  27. private Set<GroupEntity> groups = new HashSet<>();
  28. }
  29.  
  30. package warmlight.base.entities;
  31. import java.util.HashSet;
  32. import java.util.Set;
  33.  
  34. import javax.persistence.CascadeType;
  35. import javax.persistence.Column;
  36. import javax.persistence.Entity;
  37. import javax.persistence.FetchType;
  38. import javax.persistence.GeneratedValue;
  39. import javax.persistence.GenerationType;
  40. import javax.persistence.Id;
  41. import javax.persistence.JoinColumn;
  42. import javax.persistence.ManyToOne;
  43. import javax.persistence.OneToMany;
  44. import javax.persistence.Table;
  45.  
  46. @Entity
  47. @Table(name = "group") //тут ошибка "Table "group" cannot be resolved."
  48. public class GroupEntity {
  49.  
  50. @Id
  51. @GeneratedValue(strategy = GenerationType.IDENTITY)
  52. private int id;
  53. @Column(unique = true, nullable = false)
  54. private String name;
  55. private String description;
  56. @Column(name = "shown", nullable = false)
  57. private boolean shown;
  58. @ManyToOne(fetch = FetchType.LAZY, cascade = CascadeType.ALL)
  59. @JoinColumn(name = "category_id", nullable = false)
  60. private CategoryEntity category;
  61. @OneToMany(mappedBy = "group", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
  62. private Set<ItemEntity> items = new HashSet<>();
  63. }
  64.  
  65. package warmlight.base.entities;
  66. import javax.persistence.CascadeType;
  67. import javax.persistence.Column;
  68. import javax.persistence.Entity;
  69. import javax.persistence.FetchType;
  70. import javax.persistence.ForeignKey;
  71. import javax.persistence.GeneratedValue;
  72. import javax.persistence.GenerationType;
  73. import javax.persistence.Id;
  74. import javax.persistence.JoinColumn;
  75. import javax.persistence.ManyToOne;
  76. import javax.persistence.OneToOne;
  77. import javax.persistence.Table;
  78.  
  79. @Entity
  80. @Table(name="item")
  81. public class ItemEntity {
  82. @Id @GeneratedValue(strategy=GenerationType.IDENTITY)
  83. private long id;
  84. @Column(nullable = false)
  85. private String name;
  86. @OneToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
  87. private ImageEntity image;
  88. @Column(nullable = false)
  89. private double price;
  90. private String description;
  91. @Column(nullable = false)
  92. private int quantity;
  93. @ManyToOne (fetch=FetchType.LAZY, cascade = CascadeType.ALL)
  94. @JoinColumn(name="category_id", nullable = false, foreignKey=@ForeignKey(name = "FK_CATEGORY"))
  95. private CategoryEntity category;
  96. @ManyToOne (fetch=FetchType.LAZY, cascade = CascadeType.ALL)
  97. @JoinColumn(name="group_id", foreignKey=@ForeignKey(name = "FK_GROUP"))
  98. private GroupEntity group;
  99. @Column(name = "shown", nullable = false)
  100. private boolean shown;
  101. @Column(name = "top", nullable = false)
  102. private boolean top = false;
  103. }
  104.  
  105. package warmlight.base.entities;
  106. import javax.persistence.Column;
  107. import javax.persistence.Entity;
  108. import javax.persistence.GeneratedValue;
  109. import javax.persistence.GenerationType;
  110. import javax.persistence.Id;
  111. import javax.persistence.Table;
  112.  
  113. @Entity
  114. @Table(name = "image")
  115. public class ImageEntity {
  116.  
  117. @Id
  118. @GeneratedValue(strategy = GenerationType.IDENTITY)
  119. private int id;
  120. @Column(columnDefinition = "LONGBLOB")
  121. private byte[] content;
  122. }
  123.  
  124. фев 17, 2018 5:33:56 PM javafx.fxml.FXMLLoader$ValueElement processValue
  125. WARNING: Loading FXML document with JavaFX API of version 9.0.1 by JavaFX runtime of version 8.0.161
  126. фев 17, 2018 5:33:57 PM org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
  127. INFO: HHH000204: Processing PersistenceUnitInfo [
  128. name: warmlight_PU
  129. ...]
  130. фев 17, 2018 5:33:57 PM org.hibernate.Version logVersion
  131. INFO: HHH000412: Hibernate Core {5.2.12.Final}
  132. фев 17, 2018 5:33:57 PM org.hibernate.cfg.Environment <clinit>
  133. INFO: HHH000206: hibernate.properties not found
  134. фев 17, 2018 5:33:57 PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
  135. INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
  136. фев 17, 2018 5:33:58 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
  137. WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
  138. фев 17, 2018 5:33:58 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  139. INFO: HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/warmlight]
  140. фев 17, 2018 5:33:58 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  141. INFO: HHH10001001: Connection properties: {user=root, password=****}
  142. фев 17, 2018 5:33:58 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  143. INFO: HHH10001003: Autocommit mode: false
  144. фев 17, 2018 5:33:58 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
  145. INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
  146. Sat Feb 17 17:34:00 MSK 2018 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.
  147. фев 17, 2018 5:34:00 PM org.hibernate.dialect.Dialect <init>
  148. INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
  149. фев 17, 2018 5:34:03 PM org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl getIsolatedConnection
  150. INFO: HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@27810fc4] 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.
  151. Hibernate: create table category (id integer not null, description varchar(255), name varchar(255) not null, shown bit not null, primary key (id)) engine=InnoDB
  152. Hibernate: create table group (id integer not null auto_increment, description varchar(255), name varchar(255) not null, shown bit not null, category_id integer not null, primary key (id)) engine=InnoDB
  153. фев 17, 2018 5:34:04 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  154. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  155. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  156. at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
  157. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
  158. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
  159. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:277)
  160. at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71)
  161. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207)
  162. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
  163. at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
  164. at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
  165. at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:313)
  166. at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:452)
  167. at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:889)
  168. at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  169. at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  170. at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  171. at warmlight.base.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:15)
  172. at warmlight.base.gui_controllers.WarmlightController.initialize(WarmlightController.java:30)
  173. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  174. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  175. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  176. at java.lang.reflect.Method.invoke(Method.java:498)
  177. at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:71)
  178. at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
  179. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  180. at java.lang.reflect.Method.invoke(Method.java:498)
  181. at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:275)
  182. at javafx.fxml.FXMLLoader.loadImpl(FXMLLoader.java:2566)
  183. at javafx.fxml.FXMLLoader.loadImpl(FXMLLoader.java:2441)
  184. at javafx.fxml.FXMLLoader.load(FXMLLoader.java:2409)
  185. at warmlight.base.Launcher.initRootLayout(Launcher.java:54)
  186. at warmlight.base.Launcher.start(Launcher.java:40)
  187. at com.sun.javafx.application.LauncherImpl.lambda$launchApplication1$161(LauncherImpl.java:863)
  188. at com.sun.javafx.application.PlatformImpl.lambda$runAndWait$174(PlatformImpl.java:326)
  189. at com.sun.javafx.application.PlatformImpl.lambda$null$172(PlatformImpl.java:295)
  190. at java.security.AccessController.doPrivileged(Native Method)
  191. at com.sun.javafx.application.PlatformImpl.lambda$runLater$173(PlatformImpl.java:294)
  192. at com.sun.glass.ui.InvokeLaterDispatcher$Future.run(InvokeLaterDispatcher.java:95)
  193. at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
  194. at com.sun.glass.ui.win.WinApplication.lambda$null$147(WinApplication.java:177)
  195. at java.lang.Thread.run(Thread.java:748)
  196. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group (id integer not null auto_increment, description varchar(255), name varcha' at line 1
  197. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  198. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  199. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  200. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  201. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  202. at com.mysql.jdbc.Util.getInstance(Util.java:408)
  203. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
  204. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
  205. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
  206. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  207. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  208. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2480)
  209. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2438)
  210. at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
  211. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
  212. at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
  213. ... 39 more
  214.  
  215. Hibernate: create table image (id integer not null auto_increment, content LONGBLOB, primary key (id)) engine=InnoDB
  216. Hibernate: create table item (id bigint not null auto_increment, description varchar(255), name varchar(255) not null, price double precision not null, quantity integer not null, shown bit not null, top bit not null, category_id integer not null, group_id integer, image_id integer, primary key (id)) engine=InnoDB
  217. Hibernate: alter table category drop index UK_46ccwnsi9409t36lurvtyljak
  218. Hibernate: alter table category add constraint UK_46ccwnsi9409t36lurvtyljak unique (name)
  219. Hibernate: alter table group drop index UK_oy92ak6u4rmbq75jgb14npht7
  220. Hibernate: alter table group add constraint UK_oy92ak6u4rmbq75jgb14npht7 unique (name)
  221. Hibernate: alter table group add constraint FKss91b60wq0pd6m4dcslwws9b0 foreign key (category_id) references category (id)
  222. фев 17, 2018 5:34:05 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  223. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  224. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  225. at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
  226. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
  227. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
  228. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
  229. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
  230. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
  231. at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
  232. at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
  233. at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:313)
  234. at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:452)
  235. at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:889)
  236. at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  237. at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  238. at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  239. at warmlight.base.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:15)
  240. at warmlight.base.gui_controllers.WarmlightController.initialize(WarmlightController.java:30)
  241. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  242. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  243. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  244. at java.lang.reflect.Method.invoke(Method.java:498)
  245. at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:71)
  246. at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
  247. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  248. at java.lang.reflect.Method.invoke(Method.java:498)
  249. at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:275)
  250. at javafx.fxml.FXMLLoader.loadImpl(FXMLLoader.java:2566)
  251. at javafx.fxml.FXMLLoader.loadImpl(FXMLLoader.java:2441)
  252. at javafx.fxml.FXMLLoader.load(FXMLLoader.java:2409)
  253. at warmlight.base.Launcher.initRootLayout(Launcher.java:54)
  254. at warmlight.base.Launcher.start(Launcher.java:40)
  255. at com.sun.javafx.application.LauncherImpl.lambda$launchApplication1$161(LauncherImpl.java:863)
  256. at com.sun.javafx.application.PlatformImpl.lambda$runAndWait$174(PlatformImpl.java:326)
  257. at com.sun.javafx.application.PlatformImpl.lambda$null$172(PlatformImpl.java:295)
  258. at java.security.AccessController.doPrivileged(Native Method)
  259. at com.sun.javafx.application.PlatformImpl.lambda$runLater$173(PlatformImpl.java:294)
  260. at com.sun.glass.ui.InvokeLaterDispatcher$Future.run(InvokeLaterDispatcher.java:95)
  261. at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
  262. at com.sun.glass.ui.win.WinApplication.lambda$null$147(WinApplication.java:177)
  263. at java.lang.Thread.run(Thread.java:748)
  264. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group add constraint FKss91b60wq0pd6m4dcslwws9b0 foreign key (category_id) refer' at line 1
  265. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  266. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  267. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  268. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  269. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  270. at com.mysql.jdbc.Util.getInstance(Util.java:408)
  271. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
  272. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
  273. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
  274. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  275. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  276. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2480)
  277. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2438)
  278. at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
  279. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
  280. at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
  281. ... 38 more
  282.  
  283. Hibernate: alter table item add constraint FK_CATEGORY foreign key (category_id) references category (id)
  284. Hibernate: alter table item add constraint FK_GROUP foreign key (group_id) references group (id)
  285. фев 17, 2018 5:34:06 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
  286. WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
  287. org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
  288. at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
  289. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
  290. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
  291. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
  292. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
  293. at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
  294. at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
  295. at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
  296. at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:313)
  297. at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:452)
  298. at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:889)
  299. at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  300. at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  301. at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  302. at warmlight.base.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:15)
  303. at warmlight.base.gui_controllers.WarmlightController.initialize(WarmlightController.java:30)
  304. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  305. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  306. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  307. at java.lang.reflect.Method.invoke(Method.java:498)
  308. at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:71)
  309. at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
  310. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  311. at java.lang.reflect.Method.invoke(Method.java:498)
  312. at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:275)
  313. at javafx.fxml.FXMLLoader.loadImpl(FXMLLoader.java:2566)
  314. at javafx.fxml.FXMLLoader.loadImpl(FXMLLoader.java:2441)
  315. at javafx.fxml.FXMLLoader.load(FXMLLoader.java:2409)
  316. at warmlight.base.Launcher.initRootLayout(Launcher.java:54)
  317. at warmlight.base.Launcher.start(Launcher.java:40)
  318. at com.sun.javafx.application.LauncherImpl.lambda$launchApplication1$161(LauncherImpl.java:863)
  319. at com.sun.javafx.application.PlatformImpl.lambda$runAndWait$174(PlatformImpl.java:326)
  320. at com.sun.javafx.application.PlatformImpl.lambda$null$172(PlatformImpl.java:295)
  321. at java.security.AccessController.doPrivileged(Native Method)
  322. at com.sun.javafx.application.PlatformImpl.lambda$runLater$173(PlatformImpl.java:294)
  323. at com.sun.glass.ui.InvokeLaterDispatcher$Future.run(InvokeLaterDispatcher.java:95)
  324. at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
  325. at com.sun.glass.ui.win.WinApplication.lambda$null$147(WinApplication.java:177)
  326. at java.lang.Thread.run(Thread.java:748)
  327. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group (id)' at line 1
  328. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  329. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  330. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  331. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  332. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  333. at com.mysql.jdbc.Util.getInstance(Util.java:408)
  334. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
  335. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
  336. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
  337. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  338. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  339. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2480)
  340. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2438)
  341. at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
  342. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
  343. at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
  344. ... 38 more
  345.  
  346. Hibernate: alter table item add constraint FKmkoehmp4aiorswoj9pa4giv0k foreign key (image_id) references image (id)
  347. фев 17, 2018 5:34:08 PM org.hibernate.hql.internal.QueryTranslatorFactoryInitiator initiateService
  348. INFO: HHH000397: Using ASTQueryTranslatorFactory
  349. Hibernate: select itementity0_.id as id1_3_, itementity0_.category_id as category8_3_, itementity0_.description as descript2_3_, itementity0_.group_id as group_id9_3_, itementity0_.image_id as image_i10_3_, itementity0_.name as name3_3_, itementity0_.price as price4_3_, itementity0_.quantity as quantity5_3_, itementity0_.shown as shown6_3_, itementity0_.top as top7_3_ from item itementity0_
  350.  
  351. <persistence xmlns="http://java.sun.com/xml/ns/persistence"
  352. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  353. xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
  354. http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
  355. version="2.0">
  356. <persistence-unit name="warmlight_PU" transaction-type="RESOURCE_LOCAL">
  357. <class>warmlight.base.entities.CategoryEntity</class>
  358. <class>warmlight.base.entities.GroupEntity</class>
  359. <class>warmlight.base.entities.ImageEntity</class>
  360. <class>warmlight.base.entities.ItemEntity</class>
  361. <properties>
  362. <property name="hibernate.hbm2ddl.auto" value="update" />
  363. <property name="hibernate.show_sql" value="true" />
  364. <property name="hibernate.format_sql" value="false" />
  365. <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect"/>
  366. <property name="hibernate.connection.driver_class" value = "com.mysql.jdbc.Driver"/>
  367. <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"></property>
  368. <property name="javax.persistence.jdbc.user" value="root"></property>
  369. <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/warmlight"></property>
  370. <property name="javax.persistence.jdbc.password" value="root"></property>
  371. </properties>
  372. </persistence-unit>
  373. </persistence>
Add Comment
Please, Sign In to add comment
Public Pastes
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!