topic Activiti flushes and commits read only Spring transaction in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-flushes-and-commits-read-only-spring-transaction/m-p/145278#M101513 <HTML><HEAD></HEAD><BODY><SPAN>We use a long running conversation as proposed in 'Java Persistence with Hibernate' chapter 11.2.3 'Extending a Session for a conversation'. During a conversation the flush mode of the Hibernate session is set to FlushMode.MANUAL so changes to the session are not persisted to the database.</SPAN><BR /><BR /><SPAN>However activiti (v5.10) seems to flush the hibernate session when reading a variable.</SPAN><BR /><BR /><SPAN>We get the following error when using activiti (v5.10), which is caused because the changes are flushed when they shouldn't (the transient instance will be persisted later on and then the flush will work right). The flush is caused by Activiti:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />org.activiti.engine.ActivitiException: Error while flushing EntityManager, illegal state<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.variable.EntityManagerSessionImpl.flush(EntityManagerSessionImpl.java:56)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:157)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:109)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.RuntimeServiceImpl.getVariable(RuntimeServiceImpl.java:103)<BR />&nbsp;&nbsp;&nbsp;at org.company.service.workflow.WorkflowManagerImpl.getProcessVariable(WorkflowManagerImpl.java:1240)<BR />…..<BR />&nbsp;&nbsp;&nbsp;… 118 more<BR />Caused by: org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: org.company.model.DocumentVersion<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>with the following call from our Spring service bean:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp; @Autowired<BR />&nbsp;&nbsp;&nbsp; private RuntimeService actRuntimeService = null;<BR /><BR />&nbsp;&nbsp;&nbsp; @Transactional(readOnly = true)<BR />&nbsp;&nbsp;&nbsp; public Object getProcessVariable(String executionId, String variableName)<BR />&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return actRuntimeService.getVariable(executionId, variableName);<BR />&nbsp;&nbsp;&nbsp; }<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>To us it seems the code in CommandContext is wrong, as it flushes the EntityManager even if it is set to FlushMode.MANUAL and the transaction is readOnly.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp; protected void flushSessions() {<BR />&nbsp;&nbsp;&nbsp; for (Session session : sessions.values()) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; session.flush();<BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp; }<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>As an additional info to the problem: If we read a Task variable instead of a Process variable everything works fine:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp; @Transactional(readOnly = true)<BR />&nbsp;&nbsp;&nbsp; public Object getTaskVariable(String taskId, String variableName)<BR />&nbsp;&nbsp;&nbsp; {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return actTaskService.getVariableLocal(taskId, variableName);<BR />&nbsp;&nbsp;&nbsp; }<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Is there a way to use Activiti in the context of a long running conversation without this problem?</SPAN></BODY></HTML> Tue, 18 Dec 2012 14:02:05 GMT mdond 2012-12-18T14:02:05Z Activiti flushes and commits read only Spring transaction https://connect.hyland.com/t5/alfresco-archive/activiti-flushes-and-commits-read-only-spring-transaction/m-p/145278#M101513 We use a long running conversation as proposed in 'Java Persistence with Hibernate' chapter 11.2.3 'Extending a Session for a conversation'. During a conversation the flush mode of the Hibernate session is set to FlushMode.MANUAL so changes to the session are not persisted to the database.However ac Tue, 18 Dec 2012 14:02:05 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-flushes-and-commits-read-only-spring-transaction/m-p/145278#M101513 mdond 2012-12-18T14:02:05Z Re: Activiti flushes and commits read only Spring transaction https://connect.hyland.com/t5/alfresco-archive/activiti-flushes-and-commits-read-only-spring-transaction/m-p/145279#M101514 <HTML><HEAD></HEAD><BODY><SPAN>No, the jpa integration was not created with that in mind.</SPAN><BR /><SPAN>That being said, it could be enhanced to cover this use case: the way forward is to create a jira issue for it so we can follow up.</SPAN></BODY></HTML> Tue, 18 Dec 2012 16:51:38 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-flushes-and-commits-read-only-spring-transaction/m-p/145279#M101514 jbarrez 2012-12-18T16:51:38Z