<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Getting "Could not execute JDBC batch update" while running process in JBPM 5.1 with persistence
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/uvijayreddy657">uvijayreddy657</a> in <i>jBPM Development</i> - <a href="http://community.jboss.org/message/622394#622394">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>We have created all the required mapping tables as per the JPA entity classes. When we are running the process, it tries to insert the process instance data into the database and at that time we are facing below issue. Please see below for the error,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".</p><p>SLF4J: Defaulting to no-operation (NOP) logger implementation</p><p><span>SLF4J: See </span><a class="jive-link-external-small" href="http://www.slf4j.org/codes.html#StaticLoggerBinder" target="_blank">http://www.slf4j.org/codes.html#StaticLoggerBinder</a><span> for further details.</span></p><p>org.hibernate.ejb.EntityManagerImpl@fbf51d</p><p>1</p><p>In Human Task Handler.... <span> :) </span></p><p>Completed</p><p>Hibernate: select hibernate_sequence.nextval from dual</p><p>Hibernate: select user_.id from OrganizationalEntity user_ where user_.id=?</p><p>Hibernate: select hibernate_sequence.nextval from dual</p><p>Hibernate: select hibernate_sequence.nextval from dual</p><p>Hibernate: select hibernate_sequence.nextval from dual</p><p>Hibernate: select hibernate_sequence.nextval from dual</p><p>Hibernate: insert into Task (allowedToDelegate, taskInitiator_id, priority, activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType, documentContentId, documentType, expirationTime, faultAccessType, faultContentId, faultName, faultType, outputAccessType, outputContentId, outputType, parentId, previousStatus, processInstanceId, skipable, status, workItemId, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</p><p>Hibernate: insert into I18NText (language, text, id) values (?, ?, ?)</p><p>Hibernate: insert into I18NText (language, text, id) values (?, ?, ?)</p><p>Hibernate: insert into I18NText (language, text, id) values (?, ?, ?)</p><p>Hibernate: insert into Content (content, id) values (?, ?)</p><p><span style="font-size: 12pt; color: #008000;">Hibernate: update Task set allowedToDelegate=?, taskInitiator_id=?, priority=?, activationTime=?, actualOwner_id=?, createdBy_id=?, createdOn=?, documentAccessType=?, documentContentId=?, documentType=?, expirationTime=?, faultAccessType=?, faultContentId=?, faultName=?, faultType=?, outputAccessType=?, outputContentId=?, outputType=?, parentId=?, previousStatus=?, processInstanceId=?, skipable=?, status=?, workItemId=? where id=?</span></p><p><span style="font-size: 12pt; color: #008000;"><br/></span></p><p><span style="color: #ff0000;">javax.persistence.RollbackException: Error while committing the transaction</span></p><p><span style="color: #ff0000;">    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:93)</span></p><p><span style="color: #ff0000;">    at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:820)</span></p><p><span style="color: #ff0000;">    at org.jbpm.task.service.TaskServiceSession.addTask(TaskServiceSession.java:134)</span></p><p><span style="color: #ff0000;">    at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:109)</span></p><p><span style="color: #ff0000;">    at org.jbpm.task.service.mina.MinaTaskServerHandler.messageReceived(MinaTaskServerHandler.java:41)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:713)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:793)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:375)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:229)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:793)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.filter.logging.LoggingFilter.messageReceived(LoggingFilter.java:176)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:793)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:638)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:598)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:587)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollingIoProcessor.java:61)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:969)</span></p><p><span style="color: #ff0000;">    at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)</span></p><p><span style="color: #ff0000;">    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)</span></p><p><span style="color: #ff0000;">    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)</span></p><p><span style="color: #ff0000;">    at java.lang.Thread.run(Thread.java:619)</span></p><p><span style="color: #ff0000;">Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update</span></p><p><span style="color: #ff0000;">    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214)</span></p><p><span style="color: #ff0000;">    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147)</span></p><p><span style="color: #ff0000;">    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:81)</span></p><p><span style="color: #ff0000;">    ... 29 more</span></p><p><span style="color: #ff0000;">Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update</span></p><p><span style="color: #ff0000;">    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)</span></p><p><span style="color: #ff0000;">    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)</span></p><p><span style="color: #ff0000;">    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)</span></p><p><span style="color: #ff0000;">    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)</span></p><p><span style="color: #ff0000;">    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)</span></p><p><span style="color: #ff0000;">    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)</span></p><p><span style="color: #ff0000;">    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)</span></p><p><span style="color: #ff0000;">    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)</span></p><p><span style="color: #ff0000;">    at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)</span></p><p><span style="color: #ff0000;">    at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)</span></p><p><span style="color: #ff0000;">    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:76)</span></p><p><span style="color: #ff0000;">    ... 29 more</span></p><p><span style="color: #ff0000;">Caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (SDS_OWNR.FK27A9A56CE1EF3A) violated - parent key not found</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #ff0000;">    at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)</span></p><p><span style="color: #ff0000;">    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10720)</span></p><p><span style="color: #ff0000;">    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)</span></p><p><span style="color: #ff0000;">    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)</span></p><p><span style="color: #ff0000;">    ... 37 more</span></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/622394#622394">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM Development at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2035">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>