Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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).
- Dec 15, 2019 5:38:07 PM org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl release
- INFO: HHH000010: On release of batch it still contained JDBC statements
- javax.persistence.RollbackException: Error while committing the transaction
- at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:87)
- at th.in.oneauthen.object.DAO.Dim_rpt_mat_dte_ints_DAO.updateIntr(Dim_rpt_mat_dte_ints_DAO.java:68)
- at th.in.oneauthen.testDAO.main(testDAO.java:23)
- Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
- at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
- at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
- at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:68)
- ... 2 more
- Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
- at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
- at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
- at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
- at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
- at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
- at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
- at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3082)
- at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2961)
- at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3341)
- at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:145)
- at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:582)
- at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:456)
- at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
- at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
- at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)
- at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:465)
- at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2963)
- at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2339)
- at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485)
- at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147)
- at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
- at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
- at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65)
- at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:61)
- ... 2 more
- 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).
- at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
- at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
- at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
- at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
- at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
- at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
- at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
- at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
- at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)
- at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
- ... 21 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement