Camunda Tables under schema name

Camunda 7 Topics Discussion & Questions
1

Hello,
We have created all the camunda oracle tables under a schema XYZ with the help of DBA,
but when starting the application pointing to the schema XYZ, it is throwing error asking for access to create the tables.

We have configuration setup in bpm_platform.xml file:

<?xml version="1.0" encoding="UTF-8"?>
<bpm-platform xmlns="http://www.camunda.org/schema/1.0/BpmPlatform"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.camunda.org/schema/1.0/BpmPlatform http://www.camunda.org/schema/1.0/BpmPlatform ">
   <properties>
      <property name="history">audit</property>
      <property name="databaseSchemaUpdate">true</property>
      <property name="authorizationEnabled">true</property>
      <property name="jobExecutorDeploymentAware">true</property>
	  <property name="databaseTablePrefix">XYZ</property>
    </properties> 
</bpm-platform>

Please advise some solution for this issue.

2

This property is indented to be used in multi-tenent setup where you have multiple schemes i the same database that all use the engine.
Is this what you’re trying to do?

3

Hi @Niall ,

Yes we have multiple schemas were we have different application tables, the Camunda tables are created under XYZ schema by DBA admin.
we are trying to bring up the Camunda engine in tomcat container by pointing the particular schema in the database instance by above configuration.
Even though the tables are created under this schema…, while bringing up the engine it is asking for create table access.
Please advise what we need to do ,for pointing the engine to the tables which was already created under the XYZ schema.

4

Hi @Asvitha,

if the tables are created manually, you can set

<property name="databaseSchemaUpdate">false</property>

to prevent the creation.

Usually it is not an issue, if you have the setting like you have and the tables already exist. I assume that your jdbc url didn’t match to the database. A stacktrace would help to find the root cause.

Hope this helps, Ingo

5

Hi @Asvitha,

another point I observed in your setup: The value of databaseTablePrefix is directly attached to the table name: camunda-bpm-platform/Execution.xml at master · camunda/camunda-bpm-platform · GitHub

Maybe you have append a . to your prefix: XYZ.

Hope this helps, Ingo

6

Hi @Ingo_Richtsmeier ,

With above both changes , Camunda engine gets started with out any issue.
Thank you for you help!!!