I want to separate Camunda tables to a different schema called camunda but even if I gave the schema-name and table-prefix, it still put all the tables under the public schema.
Here’s my application.yml;
spring:
datasource:
hikari:
pool-name: CAMUNDA-HIKARI-POOL
idle-timeout: 3000
maximum-pool-size: 10
minimum-idle: 30
username: ${X_DB_USER:xxxx}
password: ${X_DB_PASSWORD:yyyy}
connection-timeout: 2000
connection-test-query: select 1
transaction-isolation: TRANSACTION_READ_COMMITTED
driver-class-name: org.postgresql.Driver
url: jdbc:postgresql://${X_DB_URL:localhost:5433/x-table?autoReconnect=true}
jpa:
show-sql: false
properties:
hibernate:
dialect: org.hibernate.dialect.PostgreSQLDialect
hibernate:
ddl-auto: update
open-in-view: false
database-platform: org.hibernate.dialect.PostgreSQLDialect
camunda.bpm:
admin-user:
id: xxxx
password: yyyy
metrics:
db-reporter-activate: false
history-level: full
database:
schema-update: create-drop
schema-name: camunda
table-prefix: camunda.
What should I do more to let Camunda tables be under the camunda schema?