topic Re: transaction synchronization in Alfresco Archive

transaction synchronization

elsarfhem — Fri, 18 Nov 2011 12:07:17 GMT

Hi,I'm not able to synchronize transtacion among jpa-spring-activity.In my test case I tried to delete a process AND a JPA entity related to the process. The process was deleted also if the method throw an exception! @Transactionalpublic void transactionalMethod(){runtimeService.deleteProcessInstanc

Re: transaction synchronization

meyerd — Fri, 18 Nov 2011 12:17:36 GMT

In order to help you, I would need to see your activiti configuration / application context.

Basically this works if you configure it right and use the same datasource for activiti and JPA.
If you want to use different data-sources you need JTA.

Re: transaction synchronization

elsarfhem — Fri, 18 Nov 2011 14:47:49 GMT

what do you mean? I attached my configuration… I stripped the unnecessary part (like spring security). Is this not enough?
I'm using only one datasource fetched through spring jndi call.
Am I missing something?

I can attached further details about persistence.xml



<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0"
 xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
 <persistence-unit name="ControlloQualitaPU" transaction-type="RESOURCE_LOCAL">
  <provider>org.hibernate.ejb.HibernatePersistence</provider>
  <non-jta-data-source>java:jdbc/cqds</non-jta-data-source>
  <properties>
   <property name="hibernate.dialect" value="org.hibernate.dialect.DB2Dialect" />
   <property name="hibernate.hbm2ddl.auto" value="update" />
   <property name="hibernate.archive.autodetection" value="class, hbm" />
   <property name="hibernate.show_sql" value="true" />
   <property name="hibernate.query.substitutions" value="true 1, false 0" />
  </properties>
 </persistence-unit>
</persistence>

Re: transaction synchronization

meyerd — Mon, 21 Nov 2011 11:43:20 GMT

Hmm… not sure how I could miss that huge XML snippet

As I said, basically this works in a single resource context if you make sure that your JPA and activiti work happens in the same JDBC connection.

Unless someone else can see what's wrong with this, could you assemble a simple testcase and attach it to this thread?
And add information on you environment, app server, version etc?

Re: transaction synchronization

elsarfhem — Mon, 05 Dec 2011 11:47:40 GMT

sorry, at the moment I have no time to make a simple test case… I have to release my project… Delivery is really near.

could it depends on these parameters?


<property name="jpaHandleTransaction" value="true" />     <!– yet tested with false –>
<property name="jpaCloseEntityManager" value="true" />   <!– yet tested with false –>

What should supposed to be the correct settings with JSF/Spring/JPA? Both false?