Camunda create tables scripts

Camunda 7 Topics Discussion & Questions
1

Hi Team i am using the camunda in my project. Planning the deploy the code in production. SO i need to prepare the camunda tables scripts.
How to generate the scripts from spring boot project (applicatio.yml)
I tried below way but its not showing create scripts.

spring:

application:
name: application
jpa:
show-sql: true

2

@Madhav_Kesava_Reddy If you want to the tables, indexes, etc need to be auto created during application startup, then you need to set these properties in application.yml.

camunda:
  bpm:
    database:
      schema-update: true

If you want to create the schema manually, then refer the scripts from this link:

https://docs.camunda.org/manual/7.15/update/minor/

https://docs.camunda.org/manual/7.15/update/minor/714-to-715/#database-updates

https://docs.camunda.org/manual/7.15/update/patch-level/#database-patches

https://app.camunda.com/nexus/service/rest/repository/browse/public/org/camunda/bpm/distro/camunda-sql-scripts/7.15.0/

3

@aravindhrs Still not generation scripts while running the server.

4

For postgres db you need to create empty schema :

CREATE SCHEMA [IF NOT EXISTS] schema_name;

and provide to data source like below in application.yml:

spring:
  application:
    name: camundaworkflow
    
  profiles:
    active: local  
    
  jpa:
    database-platform: org.hibernate.dialect.PostgreSQL9Dialect
    
  datasource:
    type: com.zaxxer.hikari.HikariDataSource
    url: jdbc:postgresql://localhost:5432/camundaworkflow
    username: postgres
    password: postgres
    
    hikari:
      jdbc-url: jdbc:postgresql://localhost:5432/camundaworkflow
      username: postgres
      password: p@stgre$8292
      driver-class-name: org.postgresql.Driver
      pool-name: CAMUNDA-HIKARI-POOL
      idle-timeout: 3000
      minimum-idle: 30
      maximum-pool-size: 10
      connection-timeout: 2000
      connection-test-query: select 1
      transaction-isolation: TRANSACTION_READ_COMMITTED
5

It doesn’t output the scripts unless if you enabled logging.

6

Can you share logback xml and application yml files If you have

7

After few changes in local system showing like …How to get org/camunda/bpm/engine/db/create/activiti.postgres.create.engine.sql files

2021-07-25 09:17:00.465 INFO [cdups-shark-process,] 9000 — [ main] org.camunda.bpm.engine.persistence : ENGINE-03016 Performing database operation ‘create’ on component ‘engine’ with resource ‘org/camunda/bpm/engine/db/create/activiti.postgres.create.engine.sql’

8

Hi @Madhav_Kesava_Reddy,

you can download them from here as a zip file:

Please check the create folder in the archive.

Hope this helps, Ingo