Possible to set autoCommit = true

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

agiledevpro

Hi,

I am wondering if there is a way to set auto commit = true in Activiti, I've tried adding
property name="defaultAutoCommit" value="true" in my activiti.cfg.xml file but this does not seem to have an effect.

the apache ibatis JdbcTransaction class is still setting autoCommit = false.

The reason why I want to have autoCommit = true is because I'm using cassandra as my database which do not support having auto commit = false.

Thanks in advance!

Regards

pmsevestre

Are you using trying Activiti with Cassandra as its main database ? Maybe you have good reasons to do so, but I can´t think of any.

Anyway, I suppose you´re using a JDBC driver for Cassandra. If you _really_, _really_ want to do so, you can achieve that by writing your own JDBC adapter that delegates most of its methods to the original Cassandra driver, but implements a fake setAutoCommit method.

If you want to be fancy, the same goal can be achieved by using AOP.

BTW, did I mention that I think this is a bad idea ? No ? Well, I´ll do it again: don´t do this.

That said, what you CAN do is use Cassandra as a store for historical data produced by your processes. Use listeners or explicit system tasks that pick relevant process instance data (eg: customer Id, product, task, assgnee, etc) and write to a given column family. You can then use a MapReduce tool in order to aggregate this information and publish in a nice dashboard that will make your business users very happy.

BTW: I´ve used this approach in one of my customers. In that particular case, I´ve used WSO2´s BAM (an open source product). This package comes with an embedded Cassandra and Hive components, making it a very good companion for any Activiti-based project.