I have two databases in my localhost mysql server: db1, db2 (both are empty)
I started up my application with the following
jdbcUrl=jdbc:mysql://localhost:3306/db1 and the application started up and all the Camunda tables were created properly.
I then shut down the application and tried running it with the second db:
jdbcUrl=jdbc:mysql://localhost:3306/db2 and received the following error:
Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'db2.ACT_GE_PROPERTY' doesn't exist ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Property.xml ### The error may involve org.camunda.bpm.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLSyntaxErrorException: Table 'db2.ACT_GE_PROPERTY' doesn't exist
I searched for similar issues and saw some comments on how Camunda was unable to create tables on a different schema.
I then deleted the Camunda tables from db1 and tried again to run the application on db2 and then indeed the application started up successfully and the Camunda tables were created on db2.
- Is it correct to say that Camunda does not support the creation of tables if the tables already exist in another db on the same server?
- If #1 is correct, then is there a way to work around this, like a setting perhaps which can always force the creation of the tables.