topic Independently commiting transactions in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/independently-commiting-transactions/m-p/218378#M171508 <HTML><HEAD></HEAD><BODY><SPAN>I have an all-service-task(ST) workflow with a waitTask to force activiti to perists data( and to avoid stack overflows).&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><BR /><SPAN>ST1 –&gt; ST2 –&gt; ST3 –&gt; ST4 –&gt; WaitTask –&gt; Exclusive Gateway –&gt; (if TRUE –&gt; End,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else –&gt; Point back to ST2)</SPAN><BR /><SPAN>Each of my service tasks are complex; as they persists several hundred records into database. </SPAN><BR /><SPAN>The problem is, the data is not committed until the process hits waitTask.&nbsp; Though I am not sharing the same transaction manager.&nbsp;&nbsp; </SPAN><BR /><SPAN>How can I make the transactions created by Activiti and by my service task commit independent. </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="transactionManager" ref="transactionManagerActiviti" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseSchemaUpdate" value="false" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jobExecutorActivate" value="false" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="asyncExecutorEnabled" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="asyncExecutorActivate" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!–&nbsp; Need to Validate this –&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="deploymentResources" value="classpath*:processes/activiti/*bpmn20.xml" /&gt;<BR />&lt;/bean&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&lt;bean id="transactionManagerActiviti"&nbsp;&nbsp;&nbsp;class="org.springframework.jdbc.datasource.DataSourceTransactionManager"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="datasourceForOracle"/&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="globalRollbackOnParticipationFailure" value="false"&gt;&lt;/property&gt;<BR />&lt;/bean&gt;<BR />&lt;!– Transaction Manager used by service tasks–&gt;<BR /><BR />&lt;bean id="transactionManager"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="org.springframework.jdbc.datasource.DataSourceTransactionManager"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="datasourceForOracle"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;ref bean="$cashavailDataSource{cashavail.dataSourceBeanName}" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&lt;/bean&gt;<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Invocation:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />ProcessInstance pi = runtimeService.startProcessInstanceByKey("customProcess",processContextMap);<BR />Execution execution = null;<BR />while ((execution = runtimeService.createExecutionQuery().processInstanceId(pi.getId()).activityId("waitStateReceiveTask")<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.singleResult()) != null) {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;runtimeService.signal(execution.getId());<BR />}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Thu, 25 Feb 2016 10:51:03 GMT gul 2016-02-25T10:51:03Z Independently commiting transactions https://connect.hyland.com/t5/alfresco-archive/independently-commiting-transactions/m-p/218378#M171508 I have an all-service-task(ST) workflow with a waitTask to force activiti to perists data( and to avoid stack overflows).&nbsp;&nbsp;&nbsp;&nbsp; ST1 –&gt; ST2 –&gt; ST3 –&gt; ST4 –&gt; WaitTask –&gt; Exclusive Gateway –&gt; (if TRUE –&gt; End,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else –&gt; Point back to ST2)E Thu, 25 Feb 2016 10:51:03 GMT https://connect.hyland.com/t5/alfresco-archive/independently-commiting-transactions/m-p/218378#M171508 gul 2016-02-25T10:51:03Z Re: Independently commiting transactions https://connect.hyland.com/t5/alfresco-archive/independently-commiting-transactions/m-p/218379#M171509 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>use </SPAN><A href="http://activiti.org/userguide/index.html#bpmnTransactionSubprocess" rel="nofollow noopener noreferrer">http://activiti.org/userguide/index.html#bpmnTransactionSubprocess</A><BR /><SPAN>or make task asynchronous - it forces transaction start.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Martin</SPAN></BODY></HTML> Thu, 25 Feb 2016 21:08:34 GMT https://connect.hyland.com/t5/alfresco-archive/independently-commiting-transactions/m-p/218379#M171509 martin_grofcik 2016-02-25T21:08:34Z