I have deployed camunda with spring boot application pointing to oracle database (user-a) and it is running fine without any issues. But when am trying to deploy another instance on the same database with different user (user-b), it is not successful. Am getting below error. Actually it is not at all creating scripts on user-b, but it tries to fetch the data from table.
@nikola.koevski - Yes, that’s correct. Engine1 starts and running fine. While starting up of Engine2, it is not actually trying to create tables. Instead it is trying to fetch the tables. Since the tables were not available it is throwing error on Engine2. When i manually created the tables in Engine2, it runs fine.
Summarizing it: you can’t create multiple process engines in one spring boot application. I have tried to achieve this in many ways. Schema will get created only for the process engine which get bootstraped first