3 Replies Latest reply on Mar 1, 2012 1:49 AM by Mahi M

    org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

    Mahi M Newbie

      Hi Prashanth

       

       

       

      I am getting the below exception whenever i proceed with my application in JBPM 5.2.

       

      Please do share some information to get out of it.

       

       

       

      org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

       

          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)

       

          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

       

          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)

       

          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

       

          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

       

          at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)

       

          at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)

       

          at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)

       

          at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)

       

          at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)

       

          at bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:478)

       

          at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:193)

       

          at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:120)

       

          at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:179)

       

          at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:348)

       

          at org.drools.command.impl.CommandBasedStatefulKnowledgeSession$1.completeWorkItem(CommandBasedStatefulKnowledgeSession.java:150)

       

          at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

       

          at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)

       

      Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (DM154.SYS_C0044325) violated

       

       

          at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:498)

       

          at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12432)

       

          at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)

       

          at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)

       

          at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)

       

          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)

       

          ... 17 more

       

      Feb 23, 2012 6:42:21 PM org.drools.persistence.jta.JtaTransactionManager commit

       

      WARNING: Unable to commit transaction

       

      javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

       

          at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)

       

          at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:513)

       

          at bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:478)

       

          at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:193)

       

          at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:120)

       

          at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:179)

       

          at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:348)

       

          at org.drools.command.impl.CommandBasedStatefulKnowledgeSession$1.completeWorkItem(CommandBasedStatefulKnowledgeSession.java:150)

       

       

          at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

       

          at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)

       

      Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

       

          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)

       

          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

       

          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)

       

          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

       

          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

       

          at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)

       

          at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)

       

          at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)

       

          at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)

       

          at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)

       

          ... 10 more

       

      Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (DM154.SYS_C0044325) violated

       

       

       

          at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:498)

       

          at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12432)

       

          at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)

       

          at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)

       

          at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)

       

          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)

       

          ... 17 more

       

      Feb 23, 2012 6:42:21 PM org.drools.persistence.SingleSessionCommandService rollbackTransaction

       

      SEVERE: Could not commit session

       

      java.lang.RuntimeException: Unable to commit transaction

       

          at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:182)

       

          at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:348)

       

          at org.drools.command.impl.CommandBasedStatefulKnowledgeSession$1.completeWorkItem(CommandBasedStatefulKnowledgeSession.java:150)

        

          at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

       

          at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)

       

      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

       

          at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)

       

          at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:513)

       

          at bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:478)

       

          at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:193)

       

          at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:120)

       

          at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:179)

       

          ... 6 more

       

      Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

       

          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)

       

          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

       

          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)

       

          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

       

          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

       

          at org.hiber

       

       

       

       

       

      Thanks