Versions Compared

Old Version 2

changes.mady.by.user Technische Redaktion

Saved on

compared with

New Version Current

changes.mady.by.user Technische Redaktion

Saved on

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
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
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


...