Page Comparison

Page Properties

hidden	true
id	DONE

Product Version
Report Note
Assignee

Resources & Remarks

Modification History

Name	Date	Product Version	Action
Antje Oelschlägel	13 SEP 2021	2021 Winter	page created
Agnieszka	23 NOV 2022	2022 Winter	rLANG

spring.jpa.properties.hilbernate.dialect

Defines the dialect of the SQL statements generated by a service.

For connecting CockroachDB Version 20.1 or older, this parameter needs to be set to org.hibernate.dialect.PostgreSQL94Dialect due to compatiblity issues with the default dialect.

For connecting any of the other supported databases, the parameter can be omitted.

omitted

spring.datasource.hikari.maximumPoolSize

Number of connections to the databases used by REGISTRY and AUDIT service.

10

Excerpt
Configuration file containing database connection parameters used by the AUDIT, REGISTRY, RENDITION-REPOSITORY and COMMANDER services.

...

Parameter Description Default Value

spring.datasource.hikari.maximumPoolSize

Integer number of connections to the database per service (AUDIT, REGISTRY, RENDITION-REPOSITORY). The value can be overwritten for each service by configuring the paramenter spring.datasource.hikari.custom.maximum-pool-size, e.g., in its <serviceName>-prod.yml configuration file.

Note: For the COMMANDER service, the service-specific configuration parameter is predefined to 2 database connections as default. Thus, its database connections are not affected by the value of spring.datasource.hikari.maximumPoolSize in the application-dbs.yml configuration parameter.
>> commander-prod.yml

10

storage

Section of individual database configurations.

databases

List of database definitions with the following required parameters:

datasource – Reference on a configuration in storage.datasources.
predicate – SPEL statement specifying the condition under which the database should be used. As of version 2022 Winter, the condition can only reference the system:tenant property of DMS objects.
default – Boolean value that specifies whether the database should be used as default database (true) or not (false).
Note: Exactly one database has to be the default database.

For each database action requested for a DMS object, the list of databases is read from the top. The first database for which the predicate is evaluated to true is used. If no predicate is true, the default database is used.

Note

title	Note

If you apply changes to the configuration of a running system, ensure that existing tenants are directed to their previous database.

Code Block
defaultdb: datasource: defaultds predicate: 'spel:false' default: true

datasources

List of database configurations with the following required parameters:

url
user
password
driver-class-name

Note: All database configurations have to use the same driver (driver-class-name).

Code Block
defaultds: url: jdbc:postgresql://postgresql.infrastructure:5432/${DBNAME} username: yuuvis_${NAMESPACE} password: ${DBPWD} driver-class-name: org.postgresql.Driver

...

Code Block

title	Example application-dbs.yml
linenumbers	true

storage:
    databases:
        defaultdb:
            datasource: defaultds
            predicate: 'spel:false'
            default: true
        database2:
            datasource: db2source
            predicate: "spel:properties['system:tenant']['value']=='tenant2'"
            default: false
    datasources:
        defaultds:
            url: 'jdbc:postgresql://abc/def'
            username: yuuvis-postgresql
            password: changeme123
            driver-class-name: 'org.postgresql.Driver'
        db2source:
            url: 'jdbc:sqlserverpostgresql://ghi/jkl'
            username: yuuvis-sqlserverpostgresql
            password: changeme456changeme123
            driver-class-name: 'comorg.microsoft.sqlserver.jdbc.SQLServerDriverpostgresql.Driver'

Versions Compared

Old Version 1

New Version Current

Key