business-process-managementcamunda

Camunda spring boot starter : create database in schema not working


I have used the camunda spring boot startup project (1.3.0) to spin up my camunda engine with the rest api.

In my application.yml I am trying to get camunda to create the database objects for me in a certain schema.

The settings below create the db objects...

camunda.bpm:
  database:
   schema-update: create-drop
   type: postgres  
   table-prefix: my_schema.
spring.datasource:
  url: "jdbc:postgresql://localhost:5432/mydb"
  username: myuser
  password: myuser
  driverClassName: org.postgresql.Driver

The problem though is that the tables get created in the public schema. What I want to do is add a table-prefix equal to "my_schema."

Am I using this setting incorrectly or is there something I am missing?

thanks


Solution

  • Use

    camunda:
      bpm:
        admin-user:
          id: ${CM_ADMIN_USR:admin}
          password: ${CM_ADMIN_PWD:admin}
        database:
          schema-update: false
          schema-name: camunda
          table-prefix: camunda.
    

    Refer :

    https://github.com/camunda/camunda-docs-manual/blob/master/content/user-guide/spring-boot-integration/configuration.md

    enter image description here