topic [6.0] Replace H2 with a standalone mysql server in activiti-app and activiti-rest in Alfresco Forum

[6.0] Replace H2 with a standalone mysql server in activiti-app and activiti-rest

maximechicois — Thu, 07 Jun 2018 08:04:53 GMT

Hello, I am currently trying the activiti-app and activiti-rest applications and tried to replace the in-memory H2 database with a mysql server because the 2 applications did not point on the same database. However, when I try to change this configuration, Tomcat returns me a 404 for the associated

Re: [6.0] Replace H2 with a standalone mysql server in activiti-app and activiti-rest

bassam_al-saror — Thu, 07 Jun 2018 12:47:12 GMT

I noticed that you are not using the correct Dialect for MySQL.

#hibernate.dialect=org.hibernate.dialect.H2Dialect
hibernate.dialect=org.hibernate.dialect.MySQLDialect

Seems that form engine tables were not created

Caused by: org.activiti.form.engine.ActivitiFormException: Error initialising form data schema

Are you using an existing schema or letting Activiti create the tables?

Re: [6.0] Replace H2 with a standalone mysql server in activiti-app and activiti-rest

maximechicois — Fri, 08 Jun 2018 07:07:16 GMT

Hello, thanks for your response.

Yes, I let Activiti create the tables. I only created a user that has access to the activiti database and linked its credentials in the activiti-app.properties file.

I replaced the H2 configuration with MySQL for Hibernate as you pointed me and re-executed tomcat and now, the databases are correctly linked !

In the db.properties from activiti-rest, there wasn't any definition of Hibernate for H2 in the demo. Should I add the same MySQL configuration as for activiti-app ?

Re: [6.0] Replace H2 with a standalone mysql server in activiti-app and activiti-rest

bassam_al-saror — Fri, 08 Jun 2018 09:20:55 GMT

No that's not needed for activiti-rest since it doesn't use Hibernate. Is all working fine now?