nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Activiti with Hibernate

cookie-exploit

Hello guys,

is it possible to use Activiti with hibernate instead of mybatis? And if it is possible, what I have to do to make it work?

Greetz cookie-exploit

Find more posts tagged with

Comments

frederikherema1

You'll have to replace the whole internals of activiti for this (alls sessions/managers and their factories), so it's possible but I guess it will take a *very* long time to do, possibly having to change a few bits here and there in the layers above. So my advice would be: don't do it

What's the use-case for using hibernate?

ronald_van_kuij

Probably some 'architect' or 'it manager' requires it.

cookie-exploit

First of all, thanks for replies.

The case is that we actually use hibernate and jbpm in our project and we not really want to use a lot of different frameworks, so it's would be nice to use hibernate.
Now I had to talk with my project leader that it would be a long way to use activiti with hibernate and that he should think about to use myBatis.

Another Question: What was the intention to use for activiti myBatis instead of hibernate? Are there any benefits of myBatis over hibernate?

EDIT: I forgot another important point, we actually use a single hibernate session for our persistence and jbpm persistence. That's a big problem, because we need this features.

bernd_ruecker

Hi.

You could still use the datasource in MyBatis, so technically there is no real disadvantage. The reason basically was:
- Hibernate is LGPL, we want to have only ASL license dependencies -> Hibernate not possible
- JPA would have been possible, BUT
- MyBatis turned out to be much more flexible. we can do a lot of tweaking and tuning behind the scenes. See for example http://www.jorambarrez.be/blog/2012/06/28/the-activiti-performance-showdown/, some of the improvements we did would not have been easily possible with JPA. Or take https://app.camunda.com/confluence/display/foxUserGuide/fox+cockpit, where we can click together sophisticated queries, we actually tried this with JPA, but MyBatis turned out to be waaaay easier. Last but not least Hibernate even caused some trouble with DB2-XA drivers, stuff you can easily fix on the MyBatis level, so I am pretty happy with myBatis at this moment.
- And since we do not have a typical business application with a lot of entities, the pain of writing XML mappings is not that big.

Does this explain MyBatis? Till now that was never a showstopper in the projects.

Cheers
Bernd

nandoztx

I am having the same problem that you, about the session of Hiberate.
I need to use a single Hibernate session, and with activiti, i am not able to do this.

cookie-exploit

I have solved the problem for our needs.

Now Activiti uses the HibernateTransactionManager and with that we can make a full rollback! Its not important that Activiti uses MyBatis, because after a small research about MyBatis I found out that MyBatis support the HibernateTransactionManager.

ApplicationCotext:

<br><!&ndash; DataSource Definition &ndash;><br><bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"><br> <property name="driverClassName" value="com.mysql.jdbc.Driver" /><br> <property name="url" value="jdbc:mysql://localhost:3306/activiti"/><br> <property name="username" value="root" /><br> <property name="password" value="root" /><br> <property name="poolPreparedStatements" value="true" /><br> <property name="maxActive" value="50" /><br> <property name="maxIdle" value="10" /><br></bean><br><br><!&ndash; Session Factory Definition &ndash;><br><bean id="sessionFactory"<br> class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"><br> <property name="dataSource"><br>&nbsp; <ref bean="dataSource" /><br> </property><br> &hellip;<br></bean><br><br><br><!&ndash; Hibernate Transaction Manager Definition &ndash;><br><bean id="transactionManager"<br> class="org.springframework.orm.hibernate3.HibernateTransactionManager"><br> <property name="sessionFactory"><br>&nbsp; <ref local="sessionFactory" /><br> </property><br> <property name="dataSource"><br>&nbsp; <ref local="dataSource" /><br> </property><br></bean><br><br><!&ndash; Process Engine Definition &ndash;><br><bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"><br> <property name="dataSource" ref="dataSource" /><br> <property name="transactionManager" ref="transactionManager" /><br> <property name="databaseSchemaUpdate" value="true" /><br> <property name="jobExecutorActivate" value="false" /><br></bean><br>

Methods for start and commit a transation (all Transactions done after startTransaction are commit after call commit Transaction):

<br>protected TransactionStatus startTransaction() {<br> PlatformTransactionManager manager = getTransactionManager();<br> DefaultTransactionDefinition d = new DefaultTransactionDefinition();<br> d.setPropagationBehavior(DefaultTransactionDefinition.PROPAGATION_REQUIRES_NEW);<br><br> transaction = manager.getTransaction(d);<br><br> return transaction;<br>}<br><br>protected void commit(TransactionStatus transaction) {<br> PlatformTransactionManager manager = getTransactionManager();<br> manager.commit(transaction);<br>}<br><br>protected void rollback(TransactionStatus transaction) {<br> PlatformTransactionManager manager = getTransactionManager();<br> manager.rollback(transaction);<br>}<br><br>private PlatformTransactionManager getTransactionManager() {<br><br> return (PlatformTransactionManager) this.appContext<br>&nbsp;&nbsp; .getBean("transactionManager");<br>}<br>

I hope this helps anyone who have a problem to integrate activiti in a hibernate environment.

P.S.: I think it would be great if this method (or something like that) is also found in the activiti doucumentation, because lots of projects currently using hibernate for persitences and in the activit documentation doesn't exist a guide to integrate activiti in an hibernate environment.

nandoztx

Hi cookie-exploit,

I have no idea where to put these implementations commit and rollback.
Could be a little more specific?

Thanks.

cookie-exploit

You could think about a class which offers these implementations and all of your beans for extends these class.
Then if you call a specific Method in the bean e.g. bean.save() which call commit() after do some stuff or bean.onError() if an error occurs an the it call rollback().

<br>public class MyBean() extends BaseAction{<br> private MyObject pojo;<br> private MyService service;<br> private RuntimeService runtimeService;<br> …<br> <br> public void doSomeStuff() {<br>&nbsp; pojo.setText("demo");<br>&nbsp; pojo.setValue(42);<br>&nbsp; <br>&nbsp; save(); // Or just call the save from your GUI for example<br> }<br> <br> <br> public void save() {<br>&nbsp; try {<br>&nbsp;&nbsp; service.save(pojo);<br>&nbsp;&nbsp; runtimeService.setVariable(pInst.getId(), "pojoid", pojo.getId());<br>&nbsp; <br>&nbsp;&nbsp; commit();<br>&nbsp; }<br>&nbsp; catch(Exception e) {<br>&nbsp;&nbsp; onError(e);<br>&nbsp; }<br> }<br> <br> <br> public void onError(Exception e) {<br>&nbsp; // do some stuff<br>&nbsp; <br>&nbsp; rollback();<br> }<br> …<br>}<br>

I hope you now understand how to use this methods, otherwise ask!

Greets cookie-exploit

nandoztx

Thanks for you reply, but i don't understand yet =/
I don't use spring like that, so i use:

applicationContext.xml:

<br><bean id="dataSource"<br>&nbsp;&nbsp;&nbsp; class="com.mchange.v2.c3p0.ComboPooledDataSource"><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="driverClass" value="${database.driver}" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="jdbcUrl" value="${database.url}" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="user" value="${database.username}" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="password" value="${database.password}" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="initialPoolSize" value="3" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="minPoolSize" value="1" /><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <property name="maxPoolSize" value="17" /><br>&nbsp; </bean><br>&hellip;<br><tx:annotation-driven transaction-manager="transactionManager" mode="aspectj"/><br>&hellip;<br><bean id="transactionManager"<br>&nbsp;&nbsp;&nbsp; class="org.springframework.orm.hibernate3.HibernateTransactionManager"><br>&nbsp;&nbsp;&nbsp; <property name="dataSource" ref="dataSource" /><br>&nbsp;&nbsp;&nbsp; <property name="sessionFactory" ref="sessionFactory" /><br>&nbsp; </bean><br>&hellip;<br><bean<br>&nbsp;&nbsp;&nbsp; class="org.springframework.transaction.aspectj.AnnotationTransactionAspect"<br>&nbsp;&nbsp;&nbsp; factory-method="aspectOf"><br>&nbsp;&nbsp;&nbsp; <property name="transactionManager"><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <ref local="transactionManager" /><br>&nbsp;&nbsp;&nbsp; </property><br>&nbsp; </bean><br>&hellip;<br> <bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"><br>&nbsp;&nbsp;&nbsp; <property name="databaseType" value="postgres" /><br>&nbsp;&nbsp;&nbsp; <property name="dataSource" ref="dataSource" /><br>&nbsp;&nbsp;&nbsp; <property name="transactionManager" ref="transactionManager" /><br>&hellip;<br>

and to open a transaction so i use:

&nbsp;&nbsp; @Override<br> @Transactional<br> public ProcessInstance startWorkflowProcess(String processDefinitionId, Map<String, Object> variables, String currentUser){<br>&nbsp; log.debug("Starting new process with the id: "+processDefinitionId+" and the variables are :"+variables);<br>&nbsp; identityService.setAuthenticatedUserId(currentUser);<br>&nbsp; ProcessInstance processInstance = runtimeService.startProcessInstanceById(processDefinitionId, variables);<br>&nbsp; identityService.setAuthenticatedUserId(null);<br>&nbsp; <br>&nbsp; return processInstance;<br> }<br>

The only thing that i use to manage my transactions is this:

import org.hibernate.Session;<br>import org.hibernate.SessionFactory;<br>import org.springframework.beans.factory.annotation.Autowired;<br><br>public class JPASessionFactory {<br><br> @Autowired<br> private SessionFactory sessionFactory;<br><br> public Session getCurrentSession() {<br>&nbsp; return sessionFactory.getCurrentSession();<br> }<br><br> public SessionFactory getSessionFactory() {<br>&nbsp; return sessionFactory;<br> }<br>}

Thank you!

cookie-exploit

It's important to know, what you want to do in a single Transaction. Because with my Method you start a Transaction with my Method and then all database manipulation will done in proxy objects, so that the real manipulation is done if you said commit.

You can think about using a transaction whenever you edit something. I use conversations to manage my transactions, but as a simple example you can start a new session for every "bean" you show, that is what I did with the conversations.

Examples:

1. You have an address book and then say to edit an contact. If you done this you create a new Transaction for the showed edit dialog and call commit if you save and rollback if you cancel the dialog or an error in the saving method occur.

2. You have an content management system and want to edit a file. If you start to edit something related to the file, you start an new transaction. Then you save the edited things, start the approve process, that the current state ist the "review" state. After that is done you can call commit to commit the changes you done with your objects and the activiti engine does with their objects. Remember that you had to call the save methods of your services to save your own objects, before you call commit.

I hope this examples helps you a bit!

Greets cookie-exploit

nandoztx

Thanks for your patience!

The problem I have with the transaction is as follows: within a servieTask I'm doing a query with hibernate.

public void execute(DelegateExecution execution) throws Exception {<br>&nbsp; <br>&nbsp; Version version = versionService.findDistributionVersion("Test");<br>&nbsp; System.err.println(version);<br>&nbsp;&nbsp;&nbsp; }

and when I stress test with multiple simultaneous threads, I have a connection deadlock, because I do a query (using hibernate), it opens a new DB transaction and don't use the transaction that was already opened by Activiti.

It's possible I do this?

Thanks!