cancel
Showing results for 
Search instead for 
Did you mean: 

Common DB for activiti-app and activiti-rest?

avirankatz
Champ on-the-rise
Champ on-the-rise

Hi,

I'm relatively new to activiti. For the past few days I've been reading parts of the user guide (mostly the REST API part) and researched the different web apps that come with activiti 6 (activiti-app, activiti-rest, activiti-admin). I noticed that activiti-app and activiti-rest work with different databases.

How can I set them to read and write from/to the same database? Preferably PostgreSQL that runs on an Ubuntu VM.

Your help is highly appreciated,

Aviran

1 ACCEPTED ANSWER

daisuke-yoshimo
Star Collaborator
Star Collaborator

You can configure DB setting by editing the following properties file.

  • activiti-6.0.0/wars/activiti-app/WEB-INF/classes/META-INF/activiti-app/activiti-app.properties
  • activiti-6.0.0/wars/activiti-rest/WEB-INF/classes/db.properties

View answer in original post

12 REPLIES 12

upliu
Champ in-the-making
Champ in-the-making

hello, i copied webapps\activiti-app\WEB-INF\lib\mysql-connector-java-5.1.30.jar to webapps\activiti-rest\WEB-INF\lib\ 

I also copied webapps\activiti-app\WEB-INF\lib\mysql-connector-java-5.1.30.jar to tomcat\lib.

It show me "  java.lang.ClassNotFoundException: com.mysql.jdbc.Driver  ".

Can u help me? thanks

daisuke-yoshimo
Star Collaborator
Star Collaborator

Do you use H2 Database? If so, this error is may be specification of H2 database, according to the following link.

Concurrency issues with H2 file mode · Issue #748 · spark-jobserver/spark-jobserver · GitHub 

Could you use real database like Postgresql?

You're right, I was using H2. After switching to PostgreSQL everything works as expected.

Getting started

Explore our Alfresco products with the links below. Use labels to filter content by product module.