Database

CIB seven Modeler persists BPMN and DMN diagrams in a relational database. The database schema is managed by the parent application (e.g. cibseven-bpm-run) — the webclient only connects to it.

The modeler shares one persistence unit with every other part of the webclient that stores data, so the settings below decide where that data goes as a whole. To put those tables in a database of their own, see Database.

Datasource

Configure the JDBC connection in application.yaml or your override file (e.g. cibseven-webclient.yaml):

spring:
  datasource:
    url: jdbc:postgresql://localhost:5432/modeler
    username: modeler_user
    password: modeler_pass
Property Description
spring.datasource.url JDBC URL of the target database
spring.datasource.username Database username
spring.datasource.password Database password

Supported databases include PostgreSQL, MySQL/MariaDB, Oracle, Microsoft SQL Server, IBM DB2, and H2 (for development). The JDBC driver for each is bundled in cibseven-webclient-core.

JPA / Hibernate

spring:
  jpa:
    hibernate:
      ddl-auto: none
Property Description
spring.jpa.hibernate.ddl-auto Schema management strategy — keep none so Hibernate never modifies the schema

Schema creation is the parent's responsibility

The webclient sets ddl-auto: none by default. The database schema must exist before the webclient starts. Use the SQL scripts provided by the parent application (e.g. cibseven-bpm-run) to create the schema on first deployment.

On this Page: