I changed the handler to AsyncMinaHTWorkItemHandler and now I am getting more detailed logging. This is the log on the server when a process is started. And indeed it looks like it is only inserting 2 rows in the I18NText table:
[java] Task service started correctly!
[java] Task service running ...
[java] Hibernate: select user0_.id as id6_0_ from OrganizationalEntity user0_ where user0_.id=? and user0_.DTYPE='User'
[java] Hibernate: select user0_.id as id6_0_ from OrganizationalEntity user0_ where user0_.id=? and user0_.DTYPE='User'
[java] Hibernate: select hibernate_sequence.nextval from dual
[java] Hibernate: select user_.id from OrganizationalEntity user_ where user_.id=?
[java] Hibernate: select I18NTEXT_ID_SEQ.nextval from dual
[java] Hibernate: select I18NTEXT_ID_SEQ.nextval from dual
[java] Hibernate: select CONTENT_ID_SEQ.nextval from dual
[java] Hibernate: insert into Task (archived, allowedToDelegate, taskInitiator_id, priority, activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType, documentContentId, docume
ntType, expirationTime, faultAccessType, faultContentId, faultName, faultType, outputAccessType, outputContentId, outputType, parentId, previousStatus, processId, processInstanceId, processSessionId,
skipable, status, workItemId, OPTLOCK, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[java] Hibernate: insert into I18NText (language, text, id) values (?, ?, ?)
[java] Hibernate: insert into I18NText (language, text, id) values (?, ?, ?)
[java] 52125 29/06 16:46:40,984[NioProcessor-2] ERROR hibernate.util.JDBCExceptionReporter.logExceptions - ORA-00001: unique constraint (JBPM_BOM_USR.SYS_C0020033) violated
[java]
[java] 52125 29/06 16:46:40,984[NioProcessor-2] ERROR hibernate.util.JDBCExceptionReporter.logExceptions - ORA-00001: unique constraint (JBPM_BOM_USR.SYS_C0020033) violated
[java]
[java] 52125 29/06 16:46:40,984[NioProcessor-2] ERROR event.def.AbstractFlushingEventListener.performExecutions - Could not synchronize database state with session
[java] org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
[java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
[java] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
[java] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
[java] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
[java] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
[java] at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
[java] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2242)
[java] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678)
[java] at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
[java] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
[java] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
[java] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
[java] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
[java] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
[java] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
[java] at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)
[java] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
[java] at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
[java] at org.jbpm.task.service.persistence.TaskLocalTransactionManager.commit(TaskLocalTransactionManager.java:55)
[java] at org.jbpm.task.service.persistence.TaskPersistenceManager.endTransaction(TaskPersistenceManager.java:86)
[java] at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:982)
[java] at org.jbpm.task.service.TaskServiceSession.addTask(TaskServiceSession.java:186)
[java] at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:144)
[java] at org.jbpm.task.service.mina.MinaTaskServerHandler.messageReceived(MinaTaskServerHandler.java:41)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
[java] at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427)
[java] at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
[java] at org.apache.mina.filter.logging.LoggingFilter.messageReceived(LoggingFilter.java:177)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)
[java] at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
[java] at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)
[java] at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:692)
[java] at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:645)
[java] at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:634)
[java] at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollingIoProcessor.java:66)
[java] at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1078)
[java] at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
[java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[java] at java.lang.Thread.run(Thread.java:662)
[java] Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (JBPM_BOM_USR.SYS_C0020033) violated