topic Re: Activiti+Spring+Hibernate: common transaction manager in Alfresco Archive

Activiti+Spring+Hibernate: common transaction manager

jolo_ — Thu, 22 Aug 2013 09:49:01 GMT

I try to use common transaction manager for Activiti and Hibernate, but seems Activiti reject Hibernate transaction manager. What the problem: 1. Save variable to Activiti process2. Rollback hibernate transaction3. Suspend Activiti process[Expected Result]: variable is not saved to Activiti's DB[Ac

Re: Activiti+Spring+Hibernate: common transaction manager

trademak — Thu, 22 Aug 2013 13:18:32 GMT

I don't see something wrong immediately. How did you implement the transaction start, commit and rollback logic. Please share more details about your Java code.

Best regards,

Re: Activiti+Spring+Hibernate: common transaction manager

jolo_ — Thu, 22 Aug 2013 14:08:22 GMT

Wrong is the fact that Activiti save to DB changes that were rolled back. I implement transaction start/commit/rollback exactly as in http://forums.activiti.org/comment/12292#comment-12292 in reply #7

Can we rollback Activiti changes without throwing exception? How?

Re: Activiti+Spring+Hibernate: common transaction manager

trademak — Fri, 23 Aug 2013 09:12:32 GMT

It's clear that you experience issues with the rollback, but I really need more code of what you're exactly doing. There must be some problem there because rollback functionality is standard Activiti behavior and we do a lot of testing to ensure it's correct behavior.

Best regards,

Re: Activiti+Spring+Hibernate: common transaction manager

jolo_ — Fri, 23 Aug 2013 09:55:29 GMT

You can clone my demo from https://github.com/JOLO-/activiti-hibernate-spring-transaction-demo.git (branch master, last commit)
To launch it you need to have PostgreSQL db
What happens in my demo:
1. I pass HibernateTransactionManager to Activiti, and use the same database for each
2. That in my service tasks (CreateClientService to be precise) I save custom entity (Client) via Hibernate & save this variable to process context (via execution.setVariable).
3. Rollback Transaction

[Result]: Client entity isn't saved to custom db, but it present in Activiti's tables

Re: Activiti+Spring+Hibernate: common transaction manager

jolo_ — Fri, 23 Aug 2013 18:12:54 GMT

Can you tell me why common transaction manager doesn't work in my demo?

Re: Activiti+Spring+Hibernate: common transaction manager

jbarrez — Tue, 03 Sep 2013 09:52:32 GMT

Because of this code:

<code>
public Engine() {
        applicationContext = new ClassPathXmlApplicationContext("applicationContext.xml");
        hibernateSessionFactory = (SessionFactory) applicationContext.getBean("sessionFactory");
    }
</code>

You create a NEW application context. a NEW transaction manager. a NEW session factory.

And you expect this to work with the transaction manager you passed in Activiti?

Re: Activiti+Spring+Hibernate: common transaction manager

binuraj_xp — Wed, 03 Feb 2016 09:39:27 GMT

Hi,

I just imported the source from https://github.com/JOLO-/activiti-hibernate-spring-transaction-demo and it works fine.
Then I changed the transactionmanager datasourse to cassandra. That is I have two datasources posgres and cassandra.
postgress is for activiti process engine configuration and cassandra is for my database transactions.
So I changed the configurations will be,

<bean id="cassandraDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
         <property name="driverClassName" value="org.apache.cassandra.cql.jdbc.CassandraDriver" />
         <property name="url" value="jdbc:cassandra://localhost:9160/gscp" />
    </bean>

<bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager" scope="singleton">
        <property name="sessionFactory">
            <ref local="sessionFactory" />
        </property>
        <property name="dataSource">
            <ref local="cassandraDataSource" />
        </property>
    </bean>

I am facing some problems when configure the sessionFactory of cassandra. What will be the dialect hiberanate property for cassandra.

<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean" scope="singleton">
        <property name="dataSource" ref="cassandraDataSource"/>
        <property name="packagesToScan">
            <list>
                <value>name.krestjaninoff.activiti.hello.db</value>
            </list>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.dialect">org.hibernate.dialect.PostgreSQL82Dialect</prop><!–org.hibernate.dialect.MySQLDialect –>
                <!–<prop key="hibernate.hbm2ddl.auto">create</prop>–>
            </props>
        </property>
    </bean>

So please help to configure the session factory for cassandra.

Re: Activiti+Spring+Hibernate: common transaction manager

jbarrez — Fri, 05 Feb 2016 14:21:13 GMT

I'm not sure if anyone has tried that already - how compatible is Cassandra with regular SQL?

Rewriting the DbSqlSession to be cassandra compliant is quite a bit of work :s