Activiti Explorer + Spring + JPA

fergomez — Fri, 06 Dec 2013 08:42:17 GMT

Hello,I'm a new user of Activiti and I've been trying to use my Activiti application that uses JPA in the Activiti Explorer. I've tried a lot of different configurations and I don't manage to make it work in the Explorer, but it works perfectly fine if I run a regular unit-test. My guess is that I'm

Re: Activiti Explorer + Spring + JPA

fergomez — Fri, 06 Dec 2013 09:08:48 GMT

One fix to my previous post. When I write:
<property name="hibernate.connection.url" value="jdbc:h2:tcp://localhost/~/test2;DB_CLOSE_ON_EXIT=FALSE" />
On jpa-persistence.xml it actually is "test", not "test2". It's the same configuration than the db.properties of the explorer.

Re: Activiti Explorer + Spring + JPA

frederikherema1 — Fri, 06 Dec 2013 09:46:18 GMT

Do you see any stacktraces in the tomcat-console/logs? You get a blank page (not a 500 or 404 response)?

Re: Activiti Explorer + Spring + JPA

fergomez — Fri, 06 Dec 2013 13:38:21 GMT

Hello, Frederik,

What I get is a 404 response:

127.0.0.1 - - [06/Dec/2013:14:36:36 +0100] "GET /activiti-explorer/ HTTP/1.1" 404 -

Re: Activiti Explorer + Spring + JPA

fergomez — Mon, 09 Dec 2013 08:31:39 GMT

I was just guessing… Do I need to change something in the activiti-rest application?

Has anyone tried to recreate this example?

Thanks again.

EDIT: Obviously, I already had my DB configuration changed to the same one working with the explorer.

Re: Activiti Explorer + Spring + JPA

frederikherema1 — Tue, 10 Dec 2013 12:31:37 GMT

If you get a 404 on the /activiti-explorer/, this means that the web app wasn't deployed correctly. Can you check the server logs (in case of tomcat, catalona.out and localhost.log) to see if an exception was thrown during deployment of the WAR on server-boot?

Re: Activiti Explorer + Spring + JPA

fergomez — Tue, 10 Dec 2013 13:05:18 GMT

Thanks! I'm new with tomcat too so I didn't know about the existence of these useful logs. At least, that's a progress and I can work on it. I already see on catalina.out that there's something wrong, so I'll update this later in case I found the solution (for anyone else wondering) or in case I get another problem.

Kind regards.

Re: Activiti Explorer + Spring + JPA

mgiebler — Fri, 10 Jan 2014 23:42:52 GMT

There really needs to be a working example of how to integrate Activiti Explorer with JPA using Spring. Being able to integrate JPA with Activiti in a unit test is great and one of the reasons I’m looking at Activiti as our BPM solution, but the real world use of this will be a centralized location for all workflows in Activiti Explorer as our end users are not going to be executing unit tests to run their workflow process. I’ve been looking for several weeks for a good working example and this post is the closest I could find, but it still looks like it is not complete and not working. If someone could complete this example – complete with configuration file to integrate both JPA into Activiti Explorer that would be very much appreciated.
Here is what I have tried so far along with notes of the results. Hopefully one of these attempts are close and someone can point me in the right direction in getting it right.

First Attempt.
I used the code from fergomez on this post with this modification – I want to get this workflow to run in a more real world environment, that is with other workflows that are running, so I un-commented the demoDataGenerator been so that demo data will be generated. This first attempt was on an empty database on MySQL. (only thing run on mysql was ‘CREATE SCHEMA `activiti` ;’) After starting up the server, I got key violation errors. The pertinent part of the stack trace is here. I have a copy of the full stack trace if needed.

Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`activiti`.`act_id_membership`, CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `act_id_user` (`ID_`))
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148)
… 49 more
Jan 10, 2014 8:42:40 PM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext

Attempt number 2
Before running my second attempt, I started the server using the original configuration files in order to get the demo database generated. Once that was in place I re-tried with everything set up as in my first attempt. Basically using fergomez’s configuration.

After startup, things initially looked promising because I saw the tables for this process (Inventory and Asset) get generated in the database. I was able to login as Kermit. I tried one of the demo processes (vacation request) and it appeared to start correctly but it didn’t seem to persist into the database. There are no errors in the stack trace. Next I tried to deploy the process definition. The deployment did not persist into the database and I was not able to start the process as it was not available to me in Activiti Explorer. There are no errors in the stack trace.

Attempt 3
Doing some more research, I found the following post:
http://forums.activiti.org/content/spring-transaction-support
This post suggests using the TransactionAwareDataSourceProxy. It also suggests that if you are going to use this, you will also need to continue to use the DataSourceTransactionManager for the transactionManager bean to work with the underlying Datasource.

To try and make this work, I added the following bean:

<blockcode>
<bean id="activitiDataSource"
class="org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy">
<property name="targetDataSource" ref="dataSource">
</bean>
</blockcode>

Then in the processEngineConfiguration I used activitiDataSource for the dataSource property:

<blockcode>
<property name="dataSource" ref="activitiDataSource" />
</blockcode>

I also changed the transactionManagerBean back to org.springframework.jdbc.datasource.DataSourceTransactionManager.

I’m now able to start a process and it will persist into the database. I can also successfully deploy the InventoryCreation process.
Starting an InventoryCreation process resulted in a nullPointerException when trying to access the entityManager in InventoryService. Here is the important part of the error:

Caused by: java.lang.NullPointerException
at org.inventory.InventoryService.createInventory(InventoryService.java:15)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.activiti.engine.impl.javax.el.BeanELResolver.invoke(BeanELResolver.java:479)

Attempt 4
This time I tried to inject an entityManager into the inventoryService bean. To do this, I first added setter and getter methods to InventoryService

<blockcode>
public void setEntityManager(EntityManager entityManager) {
this.entityManager = entityManager;
}
</blockcode>

I then created a sharedEntityManagerBean.
<blockcode>
<bean id="fssSharedEntityManager" class="org.springframework.orm.jpa.support.SharedEntityManagerBean">
<property name="entityManagerFactory" ref="entityManagerFactory"/>
</bean>
</blockcode>
And finally injected into the inventoryService bean:
<blockcode>
<bean id="inventoryService" class="org.inventory.InventoryService" >
<property name="entityManager" ref="fssSharedEntityManager" />
</bean>
</blockcode>

Here are the important parts to the error I get when calling entityManger.persist in the InventoryService:
Caused by: org.activiti.engine.ActivitiException: Cannot flush EntityManager, an active transaction is required
at org.activiti.engine.impl.variable.EntityManagerSessionImpl.flush(EntityManagerSessionImpl.java:58)
at org.activiti.engine.impl.variable.JPAEntityVariableType.setValue(JPAEntityVariableType.java:63)
at org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.setValue(VariableInstanceEntity.java:176)

.
.
.

Caused by: javax.persistence.TransactionRequiredException: no transaction is in progress
at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:793)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:365)
at $Proxy410.flush(Unknown Source)
at org.activiti.engine.impl.variable.EntityManagerSessionImpl.flush(EntityManagerSessionImpl.java:54)

Don't know what else to try.

Re: Activiti Explorer + Spring + JPA

mgiebler — Tue, 14 Jan 2014 23:09:42 GMT

OK, I got this to work in Activiti-explorer thanks to this posting http://forums.activiti.org/content/spring-jpatransactionmanager-not-saving-activiti-entities-db. Basically I have the same setup as in Attempt 4 in my previous post and the key to making it all work is to use this entityManagerFactory bean
<blockcode>
<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <property name="persistenceUnitName" value="inventoryPersistence"/>
    <property name="jpaVendorAdapter">
      <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
        <property name="databasePlatform" value="org.hibernate.dialect.HSQLDialect" />
      </bean>
    </property>
</bean>
</blockcode>

Re: Activiti Explorer + Spring + JPA

fergomez — Mon, 27 Jan 2014 08:56:44 GMT

Hello again,

Mgiebler, would you post your whole working configuration? I've changed a lot the project, so I started from scratch again, but I'm still not able to make it work. Thanks in advance.

Kind regards.

topic Re: Activiti Explorer + Spring + JPA in Alfresco Archive

Activiti Explorer + Spring + JPA

Re: Activiti Explorer + Spring + JPA

Re: Activiti Explorer + Spring + JPA

Re: Activiti Explorer + Spring + JPA

Re: Activiti Explorer + Spring + JPA

Re: Activiti Explorer + Spring + JPA

Re: Activiti Explorer + Spring + JPA

Re: Activiti Explorer + Spring + JPA

Re: Activiti Explorer + Spring + JPA

Re: Activiti Explorer + Spring + JPA