Here is the latest status:
I have a Spring Boot 3.2 application in which I want to use Camunda 7.2. I have disabled Camunda’s automatic table generation and instead downloaded the SQL files provided by Camunda and used them in my Spring Boot project (a description can be found here Process engine database auto-creation disabling).
In the application.yaml I use the following parameters
camunda:
bpm:
database:
type: h2
schema-name: camunda
table-prefix: camunda.
schema-update: false
I am using H2 and have placed both H2 SQL files “identity_7.21.0.sql” and “engine_7.21.0.sql” in the src/main/resources. This contains the corresponding CREATE TABLE statements. These scripts are also executed when the Spring Boot application is started (this can be seen in the Eclipse/STS console), e.g.
DefaultSqlScriptExecutor CREATE TABLE IF NOT EXISTS ACT_ID_USER (
ID_ varchar(64),
REV_ integer,
FIRST_ varchar(255),
LAST_ varchar(255),
EMAIL_ varchar(255),
PWD_ varchar(255),
SALT_ varchar(255),
LOCK_EXP_TIME_ timestamp,
ATTEMPTS_ integer,
PICTURE_ID_ varchar(64),
primary key (ID_)
)
However, the following message appears at some point:
org.camunda.bpm.engine.context ENGINE-16004 Exception while closing command context: ENGINE-03056 Tables are missing for the following components: [
engine
Engine history
Identity
case.engine
decision.engine
]
There was already a thread about this in the forum (sh Tables are missing for the following components: [ identity ]) but unfortunately no solution/answer.
Do I have to download and execute any other SQL files apart from the ones mentioned above? Or do I have to make any other configuration settings?