topic Unable to use hibernate transaction in SpringProcessEngineConfiguration? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/unable-to-use-hibernate-transaction-in/m-p/216369#M169499 <HTML><HEAD></HEAD><BODY><SPAN>Hello everybody,</SPAN><BR /><SPAN> I am trying to configure same transaction manager(HibernateTransactionManager)&nbsp; for Activiti and my database operations.</SPAN><BR /><SPAN>My goal is whenever exception arises in either Activiti operation or my database operation both transaction should be rolled back.</SPAN><BR /><SPAN>With the configuration from document I've configured single transaction manager for both but however when I rollback the transaction only my database transaction gets rolled back and Activiti database transaction is not getting rolled back. Posting my code below any kind of inputs will be appreciated. </SPAN><BR /><SPAN>Note : I am using c3p0 for datasource and HibernateTransactionManager for transaction manager.</SPAN><BR /><BR /><STRONG><BR />Spring configuration XML<BR /></STRONG><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="driverClass" value="oracle.jdbc.OracleDriver" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jdbcUrl" value="jdbc:oracle:thin:@localhost:1521:xe" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="user" value="activiti" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="password" value="activiti" /&gt;<BR />&lt;/bean&gt;<BR /><BR />&lt;bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;ref bean="dataSource" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="mappingResources"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;list&gt;&nbsp;&nbsp;&nbsp;&lt;value&gt;MyEntity.hbm.xml&lt;/value&gt; &lt;/list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;<BR />&lt;/bean&gt;<BR /><BR />&lt;bean id="hibernateTransactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="sessionFactory" ref ="sessionFactory" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource" /&gt;<BR />&lt;/bean&gt;<BR />&nbsp;&nbsp;&nbsp;<BR />&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseType" value="oracle" /&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="hibernateTransactionManager" /&gt; –&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="transactionsExternallyManaged"&nbsp; value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseSchemaUpdate" value="none" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="bulkInsertEnabled" value="false"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="history" value="audit" /&gt;<BR />&lt;/bean&gt;<BR />&nbsp;&nbsp;&nbsp;<BR />&lt;bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean"&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;property name="processEngineConfiguration" ref="processEngineConfiguration" /&gt;<BR />&lt;/bean&gt;&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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</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 /><BR /><STRONG><BR />Java code for performing operations..<BR /></STRONG><BR /><BR /><SPAN>[java]</SPAN><BR /><SPAN>public class MyTestClass{</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Autowired</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Qualifier("sessionFactory")</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;private SessionFactory sessionFactory;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Autowired</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Qualifier("processEngine")</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;private ProcessEngine processEngine = null;</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;public void testRollback(HttpServletRequest request, HttpServletResponse response) {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;org.hibernate.Session currentSession = null;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;try {&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;currentSession = sessionFactory.openSession();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;currentSession.setFlushMode(FlushMode.MANUAL);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;currentSession.beginTransaction();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Saving my database object</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MyEntity entity = new MyEntity("My new db record");</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;currentSession.save(entity)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Deploying Workflow </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZipInputStream inputStream&nbsp; = new ZipInputStream(Input stream path of zip……..);</SPAN><BR /><SPAN>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RepositoryService repositoryService = processEngine.getRepositoryService();</SPAN><BR /><SPAN>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Deployment deployment = repositoryService.createDeployment()</SPAN><BR /><SPAN>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .name(version)</SPAN><BR /><SPAN>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .addZipInputStream(inputStream)</SPAN><BR /><SPAN>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .deploy();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Exception thrown</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw new Exception();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;currentSession.flush(); </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;currentSession.getTransaction().commit();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} catch (Exception ex) {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (currentSession.getTransaction().isActive()) {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;currentSession.getTransaction().rollback();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;}</SPAN><BR /><SPAN>}</SPAN><BR /><SPAN>[/java]</SPAN><BR /><BR /><SPAN>In above example MyEntity gets rolled back but Activiti does not roll back deployment of Workflow.</SPAN></BODY></HTML> Wed, 27 Apr 2016 10:06:04 GMT prathameshj 2016-04-27T10:06:04Z Unable to use hibernate transaction in SpringProcessEngineConfiguration? https://connect.hyland.com/t5/alfresco-archive/unable-to-use-hibernate-transaction-in/m-p/216369#M169499 Hello everybody, I am trying to configure same transaction manager(HibernateTransactionManager)&nbsp; for Activiti and my database operations.My goal is whenever exception arises in either Activiti operation or my database operation both transaction should be rolled back.With the configuration from docum Wed, 27 Apr 2016 10:06:04 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-use-hibernate-transaction-in/m-p/216369#M169499 prathameshj 2016-04-27T10:06:04Z Re: Unable to use hibernate transaction in SpringProcessEngineConfiguration? https://connect.hyland.com/t5/alfresco-archive/unable-to-use-hibernate-transaction-in/m-p/216370#M169500 <HTML><HEAD></HEAD><BODY><SPAN>No, this won't work: you're starting your transactions manually in hibernate and are not using the transaction manager.</SPAN><BR /><SPAN>Activiti and Hibernate work together on the transactionmanager level … not on the hibernate level.</SPAN></BODY></HTML> Tue, 03 May 2016 11:50:47 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-use-hibernate-transaction-in/m-p/216370#M169500 jbarrez 2016-05-03T11:50:47Z