How to commit DB changes before a call activity?

andregs — Thu, 08 Sep 2011 20:19:05 GMT

Hi,Suppose I have a process like this:[attachment=1]ss1.png[/attachment]I have a method in a stateless session bean to start the process, like this:@TransactionAttribute(REQUIRED)public void startProcess(JpaEntity entity) { entityManager.persist(entity); Map<String, Object> variables = new

Re: How to commit DB changes before a call activity?

ronald_van_kuij — Thu, 08 Sep 2011 22:18:55 GMT

Wow… Such a long post and if you searched a little you might have found async continuatons and 'ACT-126'. That is what you need

Re: How to commit DB changes before a call activity?

andregs — Fri, 09 Sep 2011 12:35:36 GMT

Thank you! That's really what I need. So I have to wait for the next version of Activiti, right? Meanwhile, I'm trying to do the commit via receive task + timeout, because it's better than my previous blank user task approach. However, this exception is thrown:

BOM: INSERT INTO MYTABLE (FIELDS) VALUES (?)
 bind => [8 parameters bound]

GRAVE: Error while closing command context
org.activiti.engine.ActivitiOptimisticLockingException: TimerEntity[13328] was updated by another transaction concurrently
 at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:425)
 at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:338)
 at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:147)
 at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:103)
 at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)
 at org.activiti.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:59)
 at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
 at org.activiti.engine.impl.jobexecutor.JobAcquisitionThread.run(JobAcquisitionThread.java:63)

GRAVE: exception during job acquisition: TimerEntity[13328] was updated by another transaction concurrently
org.activiti.engine.ActivitiOptimisticLockingException: TimerEntity[13328] was updated by another transaction concurrently
 at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:425)
 at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:338)
 at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:147)
 at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:103)
 at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)
 at org.activiti.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:59)
 at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
 at org.activiti.engine.impl.jobexecutor.JobAcquisitionThread.run(JobAcquisitionThread.java:63)

GRAVE: exception during timer execution
org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.activiti.engine.ActivitiException: unknown variable type name jpa-entity
### The error may involve org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId-Inline
### The error occurred while setting parameters
### Cause: org.activiti.engine.ActivitiException: unknown variable type name jpa-entity
 at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
 at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:77)
 at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:69)
 at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:172)
 at org.activiti.engine.impl.persistence.entity.VariableInstanceManager.findVariableInstancesByExecutionId(VariableInstanceManager.java:47)
 at org.activiti.engine.impl.persistence.entity.ExecutionEntity.loadVariableInstances(ExecutionEntity.java:876)
 at org.activiti.engine.impl.persistence.entity.VariableScopeImpl.ensureVariableInstancesInitialized(VariableScopeImpl.java:57)
 at org.activiti.engine.impl.persistence.entity.VariableScopeImpl.getVariable(VariableScopeImpl.java:90)
 at org.activiti.engine.impl.persistence.entity.VariableScopeImpl.getVariable(VariableScopeImpl.java:97)
 at org.activiti.engine.impl.bpmn.behavior.CallActivityBehavior.execute(CallActivityBehavior.java:67)

The same happens when I try to delete cascade my deployment on Activiti Probe: org.activiti.engine.ActivitiException: unknown variable type name jpa-entity

I'm sorry about my long post. I did my best to make myself clear.

Could you help me again? I'm using Activiti 5.6 and I'm going to try 5.7 latter.

Re: How to commit DB changes before a call activity?

ronald_van_kuij — Fri, 09 Sep 2011 13:21:13 GMT

hahha… your initial post was very clear, but if you had searched a little, you probably would not have had to write it 🙂

Regarding your second question, it is always better not to use the same topic since that can be confusing. And there have been posts with kind of the same issue, so please search a little first and use a new topic afterwards

Re: How to commit DB changes before a call activity?

andregs — Fri, 09 Sep 2011 17:25:24 GMT

Thank you, Ronald. I have created a new topic: http://forums.activiti.org/en/viewtopic.php?f=6&t=2373

topic How to commit DB changes before a call activity? in Alfresco Archive

How to commit DB changes before a call activity?

Re: How to commit DB changes before a call activity?

Re: How to commit DB changes before a call activity?

Re: How to commit DB changes before a call activity?

Re: How to commit DB changes before a call activity?