Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Page Properties
hiddentrue
idDONE

Product Version
Report Note
Assignee

Resources & Remarks

Modification History

NameDateProduct VersionAction
Antje Oelschlägel13 SEP 20212021 Winterpage created
Agnieszka23 NOV 20222022 WinterrLANG





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.

...

ParameterDescriptionDefault Value
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
titleNote

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


...