topic Transaction problems in Alfresco Archive

Transaction problems

backslash — Mon, 12 Nov 2012 21:44:23 GMT

Hello, I am developing a platform based on activiti engine (5.10). The database is MSSQL Servier 2008 and I am using Spring and JPA (Hibernate provider).My application was running fine for few days. But today something happened with the connection to database and I suspect there was a big rollback,

Re: Transaction problems

meyerd — Tue, 13 Nov 2012 09:24:49 GMT

Hmm. sounds strange. Really difficult to say anything from what you are writing. Do you have any additional information?

Re: Transaction problems

backslash — Tue, 13 Nov 2012 09:37:45 GMT

Hi,
thank you for response. I might have one more piece of information, but dont know if it will help. I have been using the same "entityManagerFactory" and "transactionManager" in the application for normal persistance of objects. After the database problem, entities stored this way were in the database and the data stored through activiti (process instances, …) was not there.

What about the "jpaHandleTransaction" and "jpaCloseEntityManager", could these two be the cause of problems in my setup?

Re: Transaction problems

meyerd — Tue, 13 Nov 2012 10:01:18 GMT

Hi backslash,

sounds like the transaction integration between activiti and your entity manager is not setup correctly. Are you using Spring? Do you have different datasources for activiti and the JPA entity manager?

Re: Transaction problems

backslash — Tue, 13 Nov 2012 10:06:24 GMT

Yes, I am using spring 3.1.0.RELEASE and hibernate 3.6.10.Final. The datasource is the same.

Re: Transaction problems

frederikherema1 — Fri, 16 Nov 2012 10:25:34 GMT


    <property name="jpaHandleTransaction" value="true" />
      <property name="jpaCloseEntityManager" value="true" />

Read the user guide trough, for the use of these properties. If the transaction is externally managed (which in your case, use true), the handleTransaction should be false and close as well, otherwise, activiti JPA-integration will close connection/transaction prematurely…

Re: Transaction problems

backslash — Wed, 21 Nov 2012 08:58:05 GMT

Thank you for advice. Do you think this could case the data-loss? It is really strange, becuase entities stored directly by me were in DB and only data in activiti tables werent there.

Re: Transaction problems

frederikherema1 — Wed, 21 Nov 2012 09:10:18 GMT

Yes, it could cause the data-loss, since transaction was not correctly shared between your entities and activiti

Re: Transaction problems

neville_sequeir — Thu, 12 Sep 2013 20:37:30 GMT

Hi backslash,

Did you achieve success in using JpaTransactionManager for Activiti? I am having the same issue, except I use jTDS JDBC driver and I do not see any exception. But Activiti data is not being saved to database. I have created another topic with some additional information about my observations about transactions - both using org.springframework.orm.jpa.JpaTransactionManager and org.springframework.jdbc.datasource.DataSourceTransactionManager. The new topic is at - http://forums.activiti.org/content/spring-jpatransactionmanager-not-saving-activiti-entities-db

It will be great if you can share some details.