topic Transaction will not role back with Annotation @Transaction in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/transaction-will-not-role-back-with-annotation-transaction/m-p/133721#M93912 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>this my first post and i'm currently working in transaction with spring and activiti <img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /> </SPAN><BR /><SPAN>I have the Problem, that the Transaction will not role back, after there occurs an exception in the function, i witch i start the processinstance. But, if the Exception is in one of the ServicesTasks, the role back willl be successful.</SPAN><BR /><BR /><SPAN>my Processmodel is:</SPAN><BR /><SPAN>startevent -&gt; ServiceTask -&gt; ServiceTask -&gt; userTask -&gt; ServiceTask -&gt; Endevent</SPAN><BR /><BR /><SPAN>i start the Program by loading a Spring Bean:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />ApplicationContext context = new ClassPathXmlApplicationContext("classpath:main/TransactionExample-context.xml");<BR />BeanFactory factory = context;<BR />StartSpringExample springExample = (StartSpringExample) factory.getBean("StartSpringExample");<BR />springExample.testingTransaction();<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>SpringBean:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />@Service<BR />public class StartSpringExample {<BR />&nbsp;&nbsp;&nbsp; // Will be injected by spring<BR />&nbsp;&nbsp;&nbsp; // Activiti Services and the ProcessEngine<BR />&nbsp;&nbsp;&nbsp; ProcessEngine processEngine;<BR />&nbsp;&nbsp;&nbsp; RepositoryService repositoryService;<BR />&nbsp;&nbsp;&nbsp; RuntimeService runtimeService;<BR /><BR />&nbsp;&nbsp;&nbsp; @Autowired<BR />&nbsp;&nbsp;&nbsp; public void setProcessEngine(ProcessEngine processEngine) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.processEngine = processEngine;<BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp; @Autowired<BR />&nbsp;&nbsp;&nbsp; public void setRepositoryService(RepositoryService repositoryService) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.repositoryService = repositoryService;<BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp; @Autowired<BR />&nbsp;&nbsp;&nbsp; public void setRuntimeService(RuntimeService runtimeService) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.runtimeService = runtimeService;<BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; public void testingTransaction() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; repositoryService<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .createDeployment()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .addInputStream("Transaction.bpmn20.xml",<BR />&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; new FileInputStream(new File("src/main/resources/diagrams/Transaction.bpmn20.xml")))<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .deploy();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (FileNotFoundException e) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e.printStackTrace();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; start(false);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; start(true);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (Exception e) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Should role back!!<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Only one instance should be exists<BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; @Transactional<BR />&nbsp;&nbsp;&nbsp; private void start(boolean b) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Map&lt;String, Object&gt; variables = new HashMap&lt;String, Object&gt;();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variables.put("employeeName", "testUser");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // running instance, till arriving the usertask<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProcessInstance startProcessInstanceByKey = runtimeService.startProcessInstanceByKey("Transaction",variables);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (b) throw new UnsupportedOperationException(startProcessInstanceByKey.getId().toString());<BR />&nbsp;&nbsp;&nbsp; }<BR />}<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>‍</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><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>So, in the function "start" occurs an exception, but the current instance will not role back. </SPAN><BR /><SPAN>My expected result I have written as a comment in the code.</SPAN><BR /><BR /><SPAN>for further information my TransactionExample-context.xml:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR /><BR />&lt;beans xmlns="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A>"<BR />&nbsp; xmlns:context="<A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A>"<BR />&nbsp; xmlns:tx="<A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A>" xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>"<BR />&nbsp; xsi:schemaLocation="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A>&nbsp;&nbsp; <A href="http://www.springframework.org/schema/beans/spring-beans.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans/spring-beans.xsd</A><BR />&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; <A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A> <A href="http://www.springframework.org/schema/context/spring-context-2.5.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context/spring-context-2.5.xsd</A><BR />&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; <A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="http://www.springframework.org/schema/tx/spring-tx-3.0.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx/spring-tx-3.0.xsd</A>"&gt;<BR /><BR />&nbsp; &lt;bean id="dataSource"<BR />&nbsp;&nbsp;&nbsp; class="org.springframework.jdbc.datasource.SimpleDriverDataSource"&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="driverClass" value="org.h2.Driver" /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="url" value="jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000" /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="username" value="sa" /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="password" value="" /&gt;<BR />&nbsp; &lt;/bean&gt;<BR /><BR />&nbsp; &lt;bean id="transactionManager"<BR />&nbsp;&nbsp;&nbsp; class="org.springframework.jdbc.datasource.DataSourceTransactionManager"&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="dataSource" ref="dataSource" /&gt;<BR />&nbsp; &lt;/bean&gt;<BR /><BR />&nbsp; &lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="dataSource" ref="dataSource" /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="transactionManager" ref="transactionManager" /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="databaseSchemaUpdate" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="jobExecutorActivate" value="false" /&gt;<BR />&nbsp; &lt;/bean&gt;<BR /><BR />&nbsp; &lt;bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean"&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="processEngineConfiguration" ref="processEngineConfiguration" /&gt;<BR />&nbsp; &lt;/bean&gt;<BR /><BR />&nbsp; &lt;bean id="repositoryService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp; factory-method="getRepositoryService" /&gt;<BR />&nbsp; &lt;bean id="runtimeService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp; factory-method="getRuntimeService" /&gt;<BR />&nbsp; &lt;bean id="taskService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp; factory-method="getTaskService" /&gt;<BR />&nbsp; &lt;bean id="historyService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp; factory-method="getHistoryService" /&gt;<BR />&nbsp; &lt;bean id="managementService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp; factory-method="getManagementService" /&gt;<BR /><BR />&nbsp; &lt;tx:annotation-driven transaction-manager="transactionManager" /&gt;<BR /><BR />&nbsp; &lt;bean id="StartSpringExample" class="main.StartSpringExample"&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="repositoryService" ref="repositoryService" /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="runtimeService" ref="runtimeService" /&gt;<BR />&lt;property name="processEngine" ref="processEngine" /&gt;<BR /><BR />&nbsp; &lt;/bean&gt;<BR />&lt;/beans&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>‍</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><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Thanks in advance.</SPAN><BR /><SPAN>Lars</SPAN></BODY></HTML> Tue, 12 Feb 2013 10:44:12 GMT larswillrich 2013-02-12T10:44:12Z Transaction will not role back with Annotation @Transaction https://connect.hyland.com/t5/alfresco-archive/transaction-will-not-role-back-with-annotation-transaction/m-p/133721#M93912 Hi,this my first post and i'm currently working in transaction with spring and activiti <IMG id="smileywink" class="emoticon emoticon-smileywink" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /> I have the Problem, that the Transaction will not role back, after there occurs an exception in the function, i witch i start the processinstance. But, if the Exception is in one of the ServicesTasks, the role Tue, 12 Feb 2013 10:44:12 GMT https://connect.hyland.com/t5/alfresco-archive/transaction-will-not-role-back-with-annotation-transaction/m-p/133721#M93912 larswillrich 2013-02-12T10:44:12Z Re: Transaction will not role back with Annotation @Transaction https://connect.hyland.com/t5/alfresco-archive/transaction-will-not-role-back-with-annotation-transaction/m-p/133722#M93913 <HTML><HEAD></HEAD><BODY><CODE><BR />&nbsp;&nbsp; @Transactional<BR />&nbsp;&nbsp;&nbsp; private void start(boolean b) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Map&lt;String, Object&gt; variables = new HashMap&lt;String, Object&gt;();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variables.put("employeeName", "testUser");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // running instance, till arriving the usertask<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProcessInstance startProcessInstanceByKey = runtimeService.startProcessInstanceByKey("Transaction",variables);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (b) throw new UnsupportedOperationException(startProcessInstanceByKey.getId().toString());<BR />&nbsp;&nbsp;&nbsp; }<BR /></CODE><BR /><SPAN>Not sure if private methods with @transactional are "intercepted" by default…</SPAN></BODY></HTML> Tue, 12 Feb 2013 15:36:02 GMT https://connect.hyland.com/t5/alfresco-archive/transaction-will-not-role-back-with-annotation-transaction/m-p/133722#M93913 frederikherema1 2013-02-12T15:36:02Z Re: Transaction will not role back with Annotation @Transaction https://connect.hyland.com/t5/alfresco-archive/transaction-will-not-role-back-with-annotation-transaction/m-p/133723#M93914 <HTML><HEAD></HEAD><BODY><SPAN>yes… thanks <img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" />. that was an error on the one hand, the other is, that the transaction method is not allowed invoke from the same bean. (without AOP)</SPAN><BR /><BR /><SPAN>regards, lars</SPAN></BODY></HTML> Fri, 15 Feb 2013 08:28:31 GMT https://connect.hyland.com/t5/alfresco-archive/transaction-will-not-role-back-with-annotation-transaction/m-p/133723#M93914 larswillrich 2013-02-15T08:28:31Z Re: Transaction will not role back with Annotation @Transaction https://connect.hyland.com/t5/alfresco-archive/transaction-will-not-role-back-with-annotation-transaction/m-p/133724#M93915 <HTML><HEAD></HEAD><BODY><SPAN>So did it work out okay, without the private-method?</SPAN></BODY></HTML> Fri, 15 Feb 2013 13:04:27 GMT https://connect.hyland.com/t5/alfresco-archive/transaction-will-not-role-back-with-annotation-transaction/m-p/133724#M93915 frederikherema1 2013-02-15T13:04:27Z Re: Transaction will not role back with Annotation @Transaction https://connect.hyland.com/t5/alfresco-archive/transaction-will-not-role-back-with-annotation-transaction/m-p/133725#M93916 <HTML><HEAD></HEAD><BODY><SPAN>yes, everthing is fine. The method has to be public.</SPAN><BR /><BR /><SPAN>it is also described therein:</SPAN><BR /><BR /><A href="http://stackoverflow.com/questions/4396284/does-spring-transactional-attribute-work-on-a-private-method" rel="nofollow noopener noreferrer">http://stackoverflow.com/questions/4396284/does-spring-transactional-attribute-work-on-a-private-method</A><BR /><BR /><SPAN>best regards</SPAN><BR /><SPAN>lars</SPAN></BODY></HTML> Sun, 17 Feb 2013 11:02:11 GMT https://connect.hyland.com/t5/alfresco-archive/transaction-will-not-role-back-with-annotation-transaction/m-p/133725#M93916 larswillrich 2013-02-17T11:02:11Z