topic Pass hibernateSessionFactory to Activiti engine configs in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/pass-hibernatesessionfactory-to-activiti-engine-configs/m-p/153383#M107967 <HTML><HEAD></HEAD><BODY><STRONG>Problem disclosure</STRONG><BR /><SPAN>I've read that to achieve common transaction for Hibernate and Activiti I should pass </SPAN><EM>HibernateTransactionManager</EM><SPAN> to </SPAN><EM>ProcessEngineConfiguration</EM><SPAN> bean. </SPAN><BR /><BR /><SPAN>When I doing so, I can check </SPAN><STRONG><EM>in debuger</EM></STRONG><SPAN> in </SPAN><EM>ProcessEngineImpl</EM><SPAN> constructor:</SPAN><BR /><PRE class="language-java line-numbers"><CODE>((SpringProcessEngineConfiguration) processEngineConfiguration).getTransactionManager() = org.springframework.orm.hibernate4.HibernateTransactionManager<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><STRONG>But</STRONG><SPAN> </SPAN><BR /><PRE class="language-java line-numbers"><CODE>processEngineConfiguration.getCustomSessionFactories() = null<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><PRE class="language-java line-numbers"><CODE>processEngineConfiguration.getSessionFactories() = java.util.HashMap size = 27<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>27 session factories, all from </SPAN><EM>org.activiti.engine.impl</EM><SPAN> package </SPAN><STRONG><EM>with no mean of custom hibernate sessionFactory</EM></STRONG><BR /><BR /><BR /><STRONG>What a statement:</STRONG><BR /><STRONG><EM>I suggest that problem with common transaction for Hibernate and Activiti lies in that fact that processEngineConfiguration.getSessionFactories() doesn't contain org.springframework.orm.hibernate4.LocalSessionFactoryBean</EM></STRONG><BR /><BR /><STRONG>Question</STRONG><BR /><SPAN>How can I set hibernate's sessionFactory into processEngineConfigurations. I hope I can do it in xml.</SPAN><BR /><BR /><STRONG>My configs</STRONG><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;?xml version="1.0" encoding="UTF-8"?&gt;<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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmlns:context="<A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A>" xmlns:tx="<A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A>"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xsi:schemaLocation="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A><BR /><A href="http://www.springframework.org/schema/beans/spring-beans-3.2.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans/spring-beans-3.2.xsd</A><BR /><A href="http://www.springframework.org/schema/context" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context</A><BR /><A href="http://www.springframework.org/schema/context/spring-context-3.2.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/context/spring-context-3.2.xsd</A><BR /><A href="http://www.springframework.org/schema/tx" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx</A> <A href="http://www.springframework.org/schema/tx/spring-tx.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/tx/spring-tx.xsd</A>"&gt;<BR /><BR />&nbsp;&nbsp;&nbsp; &lt;tx:annotation-driven&nbsp; transaction-manager="transactionManager"/&gt;<BR /><BR />&nbsp;&nbsp;&nbsp; &lt;!– Configuration –&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;context:property-placeholder location="classpath*:*.properties" /&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;!– Annotation based configuration –&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;context:annotation-config /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;context:component-scan base-package="name.krestjaninoff" /&gt; <BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; &lt;!– Data –&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="driverClassName" value="org.postgresql.Driver"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="url" value="jdbc:postgresql://localhost:5432/activiti-transaction-demo"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="username" value="postgres"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="password" value="password"/&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;!–<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Activiti <BR />&nbsp;&nbsp;&nbsp;–&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="databaseType" value="postgres" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="dataSource" ref="dataSource" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="transactionManager" ref="transactionManager" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!–&lt;property name="sessionFactories"&nbsp; !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!–&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="transactionsExternallyManaged" value="true"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!–&lt;property name="databaseSchemaUpdate" value="create" /&gt;–&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="databaseSchemaUpdate" value="true"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="history" value="full" /&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*:/process/*.bpmn20.xml" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="processEngineConfiguration" ref="processEngineConfiguration" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="repositoryService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getRepositoryService" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="runtimeService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getRuntimeService" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="taskService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getTaskService" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="historyService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getHistoryService" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;bean id="managementService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;factory-method="getManagementService" /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;bean id="identityService" factory-bean="processEngine"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; factory-method="getIdentityService" /&gt;<BR /><BR />&nbsp;&nbsp;&nbsp; &lt;!–<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hibernate<BR />&nbsp;&nbsp;&nbsp; –&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean" scope="singleton"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="dataSource" ref="dataSource"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="packagesToScan"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;name.krestjaninoff.activiti.hello.db&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="hibernateProperties"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;props&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;prop key="hibernate.show_sql"&gt;true&lt;/prop&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;prop key="hibernate.dialect"&gt;org.hibernate.dialect.PostgreSQL82Dialect&lt;/prop&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!–&lt;prop key="hibernate.hbm2ddl.auto"&gt;create&lt;/prop&gt;–&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/props&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/bean&gt;<BR /><BR />&nbsp;&nbsp;&nbsp; &lt;bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager" scope="singleton"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="sessionFactory"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ref local="sessionFactory" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="dataSource"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ref local="dataSource" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</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 /></BODY></HTML> Fri, 27 Sep 2013 08:44:47 GMT fritz128 2013-09-27T08:44:47Z Pass hibernateSessionFactory to Activiti engine configs https://connect.hyland.com/t5/alfresco-archive/pass-hibernatesessionfactory-to-activiti-engine-configs/m-p/153383#M107967 Problem disclosureI've read that to achieve common transaction for Hibernate and Activiti I should pass HibernateTransactionManager to ProcessEngineConfiguration bean. When I doing so, I can check in debuger in ProcessEngineImpl constructor<IMG id="smileysad" class="emoticon emoticon-smileysad" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" />(SpringProcessEngineConfiguration) processEngineConfigurat Fri, 27 Sep 2013 08:44:47 GMT https://connect.hyland.com/t5/alfresco-archive/pass-hibernatesessionfactory-to-activiti-engine-configs/m-p/153383#M107967 fritz128 2013-09-27T08:44:47Z Re: Pass hibernateSessionFactory to Activiti engine configs https://connect.hyland.com/t5/alfresco-archive/pass-hibernatesessionfactory-to-activiti-engine-configs/m-p/153384#M107968 <HTML><HEAD></HEAD><BODY><SPAN>No mean of answer my own question. I make more investigations about what happens when I save variable to Activiti context:</SPAN><BR /><SPAN>Simplified stacktrace of variable saving:</SPAN><BR /><SPAN>1 execution.setVariable("clientEntity", clientEntity)</SPAN><BR /><SPAN> 2 VariabcleScopeImpl.setVariable</SPAN><BR /><SPAN>3. VariabcleScopeImpl.createVariableLocal</SPAN><BR /><SPAN>4. VariabcleScopeImpl.createVariableInstance</SPAN><BR /><SPAN>5. VariableInstanceEntity.createAndInsert</SPAN><BR /><SPAN>And in </SPAN><EM>createAndInsert</EM><SPAN> method we ask DbSqlSession to make transaction.</SPAN><BR /><STRONG>Context.getCommandContext().getDbSqlSession() returns org.activiti.engine.impl.db.DbSqlSession instead of hibernate session</STRONG><BR /><BR /><SPAN>Moreover even after &lt;java&gt;Context.getCommandContext().getDbSqlSession().rollback()&lt;/java&gt; rollbacked changes are persisted after a wait state&nbsp; </SPAN></BODY></HTML> Fri, 27 Sep 2013 11:01:37 GMT https://connect.hyland.com/t5/alfresco-archive/pass-hibernatesessionfactory-to-activiti-engine-configs/m-p/153384#M107968 fritz128 2013-09-27T11:01:37Z