topic Re: How to configure Activiti Explorer and REST to use the same database in Alfresco Archive

How to configure Activiti Explorer and REST to use the same database

ardamose123 — Fri, 24 May 2013 18:23:25 GMT

I have fresh installations of activiti-explorer and activiti-rest running in a local Tomcat server. Both have exactly the same db.properties configuration (the original H2 database). However, any change I apply using Activiti Explorer is not reflected in the REST API (using curl), nor the other way

Re: How to configure Activiti Explorer and REST to use the same database

slehman — Sun, 26 May 2013 04:04:40 GMT

I ran into the same thing - I thought it would work since it looked like it was using H2 in a mode that allowed multiple connections from a single process.

Running H2 in server mode did the trick though.

To run in server mode, locate the jar and issue a command like:

Update the JDBC urls in the db.properties files for both web apps.

Re: How to configure Activiti Explorer and REST to use the same database

jbarrez — Tue, 28 May 2013 09:54:42 GMT

@slehman: exactly the way it should be!

Re: How to configure Activiti Explorer and REST to use the same database

jcoveron — Fri, 06 Jun 2014 11:22:24 GMT

Greetings.

I am trying to do the same thing but with a MySQL database.
Both my db.properties file for the activiti-explorer and activiti-rest look like this:

db=mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/activiti
jdbc.username={mysql user}
jdbc.password={mysql password}

Any chance you could provide a guide on how to configure them to see the same MySQL database.

Sorry for the trouble and thanks in advance.

Re: How to configure Activiti Explorer and REST to use the same database

jbarrez — Tue, 17 Jun 2014 09:55:07 GMT

That should pretty much be it - but it seems its not working for you? Do you have any exceptions?

Re: How to configure Activiti Explorer and REST to use the same database

jcoveron — Mon, 07 Jul 2014 07:27:38 GMT

Hi
Thanks for the reply. The configuration is working, I just wanted to make sure I understood correctly as am new at Activiti.
Once again, thanks for the kind help.
Regards

Re: How to configure Activiti Explorer and REST to use the same database

feroz1 — Mon, 12 Jan 2015 19:34:23 GMT

Hi,
I’ve created a sample process(with just 2 user tasks in sequence) and deployed through REST and all the REST API calls work fine. When I deploy the activiti explorer war along with the REST(both pointing to same DB), I could see the process and the tasks in the explorer. However, if I the restart the server, it’s not persisting the state of the process instance. For example, if I complete task1 and restart the server, it doesn’t show that instance nor task2 anymore. However, it works fine with just the rest.

Can someone please let me know if I missed configuring something?

Thanks!

Feroz.

Re: How to configure Activiti Explorer and REST to use the same database

martin_grofcik — Tue, 13 Jan 2015 11:22:24 GMT

Hi Feroz,

By default activity is configured in memory DB.
If you want to persist state, configure another data source to store the data.
Regards
Martin

Re: How to configure Activiti Explorer and REST to use the same database

feroz1 — Tue, 13 Jan 2015 14:47:24 GMT

Hi Martin, I did configure to point both rest and explorer to point to mysql database.

Re: How to configure Activiti Explorer and REST to use the same database

jbarrez — Fri, 16 Jan 2015 12:08:13 GMT

So when you shut down the server, you should have an entry in your ACT_RU_TASK. Is that the case?

Re: How to configure Activiti Explorer and REST to use the same database

tunglk — Thu, 17 Dec 2015 04:05:55 GMT

Hi all,

I have a problem with config database for activiti-rest:
my db.properties:
db=h2
jdbc.driver=org.h2.Driver
#jdbc.url=jdbc:h2:mem:activiti;DB_CLOSE_DELAY=-1
jdbc.url=jdbc:h2:tcp://localhost/~/activiti
jdbc.username=sa
jdbc.password=

but when i start tomcat, activiti-rest can't start.
stdout of tomcat:
10:59:37,088 [localhost-startStop-1] WARN org.springframework.web.context.support.AnnotationConfigWebApplicationContext - Exception encountered during context initialization - cancelling refresh attempt
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'demoDataConfiguration': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected org.activiti.engine.IdentityService org.activiti.rest.conf.DemoDataConfiguration.identityService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'identityService' defined in class path resource [org/activiti/rest/conf/ActivitiEngineConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.activiti.engine.IdentityService]: Factory method 'identityService' threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine' defined in class path resource [org/activiti/rest/conf/ActivitiEngineConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.activiti.engine.ProcessEngine]: Factory method 'processEngine' threw exception; nested exception is java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngineFactoryBean': FactoryBean threw exception on object creation; nested exception is org.activiti.engine.ActivitiException: Could not update Activiti database schema: unknown version from database: '5.20.0.0'
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:334)

Someone can help me?

Re: How to configure Activiti Explorer and REST to use the same database

jbarrez — Fri, 18 Dec 2015 14:18:38 GMT

The exception says you have 5.20.0.0 as version. Are you running a snapshot version?

Re: How to configure Activiti Explorer and REST to use the same database

tunglk — Mon, 21 Dec 2015 01:10:36 GMT

I'm using 5.19.0 version in: http://activiti.org/download.html

Re: How to configure Activiti Explorer and REST to use the same database

vasile_dirla — Mon, 21 Dec 2015 09:30:53 GMT

@tunglk, maybe you used the same database with the snapshoot version and now you are trying to execute 5.19.0 on the same database ? (without cleaning it before)

What's happening if you use a fresh new database ?

Re: How to configure Activiti Explorer and REST to use the same database

tunglk — Tue, 22 Dec 2015 01:44:57 GMT

@vasile.dirla Thank you so much. I resolved it