Advertisement
Guest User

Error

a guest
Dec 15th, 2019
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 4.97 KB | None | 0 0
  1. ERROR: Violation of PRIMARY KEY constraint 'PK_dim_rpt_mat_dte_ints'. Cannot insert duplicate key in object 'dp.dim_rpt_mat_dte_ints'. The duplicate key value is (20000002, 1020036073, 00002, 2019-12-11).
  2. Dec 15, 2019 5:38:07 PM org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl release
  3. INFO: HHH000010: On release of batch it still contained JDBC statements
  4. javax.persistence.RollbackException: Error while committing the transaction
  5.     at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:87)
  6.     at th.in.oneauthen.object.DAO.Dim_rpt_mat_dte_ints_DAO.updateIntr(Dim_rpt_mat_dte_ints_DAO.java:68)
  7.     at th.in.oneauthen.testDAO.main(testDAO.java:23)
  8. Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
  9.     at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
  10.     at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
  11.     at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:68)
  12.     ... 2 more
  13. Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
  14.     at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
  15.     at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  16.     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
  17.     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
  18.     at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
  19.     at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
  20.     at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3082)
  21.     at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2961)
  22.     at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3341)
  23.     at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:145)
  24.     at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:582)
  25.     at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:456)
  26.     at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
  27.     at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
  28.     at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)
  29.     at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:465)
  30.     at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2963)
  31.     at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2339)
  32.     at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485)
  33.     at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147)
  34.     at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
  35.     at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
  36.     at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65)
  37.     at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:61)
  38.     ... 2 more
  39. Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK_dim_rpt_mat_dte_ints'. Cannot insert duplicate key in object 'dp.dim_rpt_mat_dte_ints'. The duplicate key value is (20000002, 1020036073, 00002, 2019-12-11).
  40.     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
  41.     at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
  42.     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
  43.     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
  44.     at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
  45.     at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
  46.     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
  47.     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
  48.     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)
  49.     at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
  50.     ... 21 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement