topic Activiti Spring Transaction Problem in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-spring-transaction-problem/m-p/194830#M147960 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm new on Activiti and I'm studying it to evaluate it for my company.</SPAN><BR /><BR /><SPAN>I'm trying a simple demo with Spring MVC and I'm interested in managing transactions between activiti and my business logic.</SPAN><BR /><BR /><SPAN>The problem is that the transactional methods don't get rolled back when something (the activiti complete task or the insert into my dao) throws exception.</SPAN><BR /><BR /><SPAN>This is my applicationContext.xml:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;bean id="dataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="driverClass" value="com.mysql.jdbc.Driver" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="url" value="jdbc:mysql://localhost:3306/activiti" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="username" value="root" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="password" value="password" /&gt;<BR />&nbsp; &lt;/bean&gt;<BR /><BR />&nbsp; &lt;bean id="transactionManager" 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 />&lt;bean id="processEngineConfiguration"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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="transactionManager" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseSchemaUpdate" value="true" /&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="deploymentResources" value="classpath*:/demoprocess.bpmn20.xml" /&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR />&lt;bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean"&gt;<BR />&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="processEngineConfiguration" ref="processEngineConfiguration" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR />&lt;tx:annotation-driven transaction-manager="transactionManager" /&gt;<BR />&nbsp; <BR />&nbsp; &lt;bean id="repositoryService" factory-bean="processEngine" factory-method="getRepositoryService" /&gt;<BR />&nbsp; &lt;bean id="runtimeService" factory-bean="processEngine" factory-method="getRuntimeService" /&gt;<BR />&nbsp; &lt;bean id="taskService" factory-bean="processEngine" factory-method="getTaskService" /&gt;<BR />&nbsp; &lt;bean id="historyService" factory-bean="processEngine" factory-method="getHistoryService" /&gt;<BR />&nbsp; &lt;bean id="managementService" factory-bean="processEngine" factory-method="getManagementService" /&gt;<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></CODE></PRE><BR /><SPAN>This is my Service:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />@Service<BR />public class BOProcess {<BR /><BR />&nbsp;&nbsp;&nbsp;@Autowired<BR />&nbsp;&nbsp;&nbsp;private RuntimeService runtimeService;<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;@Autowired<BR />&nbsp;&nbsp;&nbsp;private TaskService taskService;<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;@Autowired<BR />&nbsp;&nbsp;&nbsp;private DAOMyTab daoMyTab;<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;protected final static Logger logger = Logger.getLogger(BOProcess.class);<BR /><BR />&nbsp;&nbsp;&nbsp;@Transactional<BR />&nbsp;&nbsp;&nbsp;public void start(){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;logger.info("Entering start method….");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessInstance pi = runtimeService.startProcessInstanceByKey("activitiDemo");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;logger.info("Started Process instance id: " + pi.getProcessInstanceId());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;daoMyTab.insert("PROCESS INSTANCE ID STARTED: " + pi.getProcessInstanceId());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;logger.info("Finish");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;<BR /><BR />&nbsp;&nbsp;&nbsp;@Transactional<BR />&nbsp;&nbsp;&nbsp;public void completeTask(String taskId){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;logger.info("Entering completeTask method….");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;logger.info("TASK ID: " + taskId);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;taskService.complete(taskId);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;daoMyTab.insert(taskId);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;logger.info("Finish");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;}&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></CODE></PRE><BR /><SPAN>And the Repository:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />@Repository<BR />public class DAOMyTab {<BR /><BR />&nbsp;&nbsp;&nbsp;@Autowired<BR />&nbsp;&nbsp;&nbsp;private DataSource dataSource;<BR /><BR />&nbsp;&nbsp;&nbsp;public void insert(String value){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String query = "insert into activiti.mytab(valore) values('" + value + "')";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;jdbcTemplate.update(query);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;}<BR />&nbsp;&nbsp;&nbsp;<BR />public void insertError(String value) throws Exception{<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw new Exception("ERRORE");&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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></CODE></PRE><BR /><SPAN>Thanks for your help.</SPAN><BR /></BODY></HTML> Sat, 31 Jan 2015 13:55:36 GMT innuendo80 2015-01-31T13:55:36Z Activiti Spring Transaction Problem https://connect.hyland.com/t5/alfresco-archive/activiti-spring-transaction-problem/m-p/194830#M147960 Hi,I'm new on Activiti and I'm studying it to evaluate it for my company.I'm trying a simple demo with Spring MVC and I'm interested in managing transactions between activiti and my business logic.The problem is that the transactional methods don't get rolled back when something (the activiti comple Sat, 31 Jan 2015 13:55:36 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-spring-transaction-problem/m-p/194830#M147960 innuendo80 2015-01-31T13:55:36Z Re: Activiti Spring Transaction Problem https://connect.hyland.com/t5/alfresco-archive/activiti-spring-transaction-problem/m-p/194831#M147961 <HTML><HEAD></HEAD><BODY><SPAN>I tried your config, but it works here perfectly: I'm getting </SPAN><BR /><BR /><SPAN>Started Process instance id: 7504</SPAN><BR /><SPAN>Exception in thread "main" org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [insert into activiti.mytab(valore) values …</SPAN><BR /><BR /><BR /><SPAN>And when I check ACT_RU_EXECUTION, no rows are found, so the rollback is working as it should.</SPAN></BODY></HTML> Tue, 10 Feb 2015 12:50:29 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-spring-transaction-problem/m-p/194831#M147961 jbarrez 2015-02-10T12:50:29Z