API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 20th, 2019
115
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.12 KB | None | 0 0
raw download clone embed print report
  1. @Entity
  2. @Table(name = "TB_PROJECT")
  3. public class Project implements Serializable {
  4.  
  5. private static final long serialVersionUID = 1L;
  6.  
  7. @Id
  8. @GeneratedValue(strategy = GenerationType.SEQUENCE)
  9. @Column(name ="PROJECT_ID", unique = true, nullable = false)
  10. private int projectID;
  11.  
  12. @Column(name = "NAME", unique = false, nullable = false)
  13. private String name;
  14.  
  15. @Column(name = "CLIENT", unique = false, nullable = false)
  16. private String client;
  17.  
  18. @OneToMany(fetch = FetchType.EAGER, cascade = CascadeType.ALL)
  19. @JoinTable(name="PROJECT_REPORTS", joinColumns= {@JoinColumn(name="PROJECT_ID", referencedColumnName="PROJECT_ID")}
  20. , inverseJoinColumns= {@JoinColumn(name="REPORT_ID", referencedColumnName="REPORT_ID")})
  21. private List<Report> reportList = new ArrayList<Report>();
  22.  
  23. @Entity
  24. @Table(name = "TB_REPORT", uniqueConstraints = {
  25. @UniqueConstraint(columnNames = "REPORT_ID") })
  26. public class Report implements Serializable{
  27.  
  28. private static final long serialVersionUID = 1L;
  29.  
  30. @Id
  31. @GeneratedValue(strategy = GenerationType.SEQUENCE)
  32. @Column(name ="REPORT_ID", unique = true, nullable = false)
  33. private int reportID;
  34.  
  35. @Column(name = "NAME", unique = false, nullable = false)
  36. private String name;
  37.  
  38. @Column(name ="AMOUNT_COMPONENTS")
  39. private int amountComponents;
  40.  
  41. @Column(name ="AMOUT_ACCEPTED")
  42. private int amountAccepted;
  43.  
  44. @Column(name = "AMOUNT_REJECTED")
  45. private int amountRejected;
  46.  
  47. @Column(name = "AMOUNT_DRAFT")
  48. private int amountUnderDevelopment;
  49.  
  50. @Column(name = "AMOUNT_REVIEW")
  51. private int amountUnderReview;
  52.  
  53. @Column(name = "TODELETE")
  54. private Boolean toDelete = false;
  55.  
  56. @Override
  57. public void updatePersistentProject(Project project) {
  58. try {
  59. Session session = HibernateUtil.getSessionFactory().openSession();
  60. session.beginTransaction();
  61. session.saveOrUpdate(project);
  62. session.getTransaction().commit();
  63. session.close();
  64. } catch (HibernateException | IOException e) {
  65. // TODO Auto-generated catch block
  66. e.printStackTrace();
  67. }
  68. }
  69.  
  70. Hibernate: select nextval ('hibernate_sequence')
  71. Hibernate: insert into TB_REPORT (REPORT_ID, AMOUT_ACCEPTED, AMOUNT_COMPONENTS, AMOUNT_REJECTED, AMOUNT_DRAFT, AMOUNT_REVIEW, NAME, TODELETE) values (?, ?, ?, ?, ?, ?, ?, ?)
  72. Hibernate: update TB_PROJECT set CLIENT = ?, NAME = ?, TO_DELETE = ? where PROJECT_ID=?
  73. Hibernate: update TB_REPORT set AMOUT_ACCEPTED = ?, AMOUNT_COMPONENTS = ?, AMOUNT_REJECTED = ?, AMOUNT_DRAFT = ?, AMOUNT_REVIEW = ?, NAME = ?, TODELETE = ? where REPORT_ID=?
  74. Hibernate: update TB_REPORT set AMOUT_ACCEPTED = ?, AMOUNT_COMPONENTS = ?, AMOUNT_REJECTED = ?, AMOUNT_DRAFT = ?, AMOUNT_REVIEW = ?, NAME = ?, TODELETE = ? where REPORT_ID=?
  75. Hibernate: delete PROJECT_REPORTS where PROJECT_ID=?
  76.  
  77. Juli 20, 2019 10:07:40 VORM. org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
  78. WARN: SQL Error: 0, SQLState: 42601
  79. Juli 20, 2019 10:07:40 VORM. org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
  80. ERROR: FEHLER: Syntaxfehler bei »PROJECT_REPORTS«
  81. Position: 8
  82. Juli 20, 2019 10:07:40 VORM. org.hibernate.internal.ExceptionMapperStandardImpl mapManagedFlushFailure
  83. ERROR: HHH000346: Error during managed flush [org.hibernate.exception.SQLGrammarException: JDBC exception executing SQL [delete PROJECT_REPORTS where PROJECT_ID=?]]
  84. Juli 20, 2019 10:07:40 VORM. org.apache.catalina.core.StandardWrapperValve invoke
  85. SEVERE: Servlet.service() for servlet [ReportServlet] in context with path [/project] threw exception
  86. javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: JDBC exception executing SQL [delete PROJECT_REPORTS where PROJECT_ID=?]
  87. at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
  88. at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
  89. at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
  90. at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1436)
  91. at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:487)
  92. at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2786)
  93. at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:1932)
  94. at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:456)
  95. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178)
  96. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39)
  97. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:272)
  98. at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:104)
  99. at dao.ProjectDAOImpl.updatePersistentProject(ProjectDAOImpl.java:70)
  100. at logic.ReportImpl.createReport(ReportImpl.java:39)
  101. at gui.ReportServlet.createReport(ReportServlet.java:223)
  102. at gui.ReportServlet.doGet(ReportServlet.java:64)
  103. at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
  104. at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  105. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  106. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  107. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  108. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  109. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  110. at gui.LoginFilter.doFilter(LoginFilter.java:77)
  111. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  112. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  113. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  114. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  115. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
  116. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  117. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  118. at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
  119. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  120. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  121. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
  122. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  123. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
  124. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  125. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  126. at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
  127. at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
  128. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  129. at java.base/java.lang.Thread.run(Thread.java:835)
  130. Caused by: org.hibernate.exception.SQLGrammarException: JDBC exception executing SQL [delete PROJECT_REPORTS where PROJECT_ID=?]
  131. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
  132. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  133. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
  134. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
  135. at org.hibernate.sql.exec.internal.JdbcMutationExecutorImpl.execute(JdbcMutationExecutorImpl.java:77)
  136. at org.hibernate.sql.exec.internal.JdbcMutationExecutorImpl.execute(JdbcMutationExecutorImpl.java:95)
  137. at org.hibernate.sql.exec.internal.JdbcMutationExecutorImpl.execute(JdbcMutationExecutorImpl.java:125)
  138. at org.hibernate.metamodel.model.domain.internal.collection.JoinTableRemovalExecutor.execute(JoinTableRemovalExecutor.java:123)
  139. at org.hibernate.metamodel.model.domain.spi.AbstractPersistentCollectionDescriptor.remove(AbstractPersistentCollectionDescriptor.java:1245)
  140. at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:78)
  141. at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:602)
  142. at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:474)
  143. at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:358)
  144. at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
  145. at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1430)
  146. ... 39 more
  147. Caused by: org.postgresql.util.PSQLException: FEHLER: Syntaxfehler bei »PROJECT_REPORTS«
  148. Position: 8
  149. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2468)
  150. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2211)
  151. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:309)
  152. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:446)
  153. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:370)
  154. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:149)
  155. at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:124)
  156. at org.hibernate.sql.exec.internal.JdbcMutationExecutorImpl.execute(JdbcMutationExecutorImpl.java:68)
  157. ... 49 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!