configurationdatabase

This configuration is optional.

  • Documentation

  • YAML Format

  • XML Format

Fill relevant inputs (blue boxes) and click the blue bars on the left to copy XML configuration snippets.
<configurationDatabaseConfiguration
<database
<driverName
>
required
string

Fully qualified name of the JDBC driver class

</driverName>
<jdbcURL
>
required
string

JDBC URL of the database

</jdbcURL>
<schemaName
>
optional
string

The name of the database schema

</schemaName>
<user
>
required
string

The database user on whose behalf the connection is being made

</user>
<password
>
required
string

Password of the database user, see Secrets in Configuration for information on password encoding modes.

</password>
<minimumIdleConnectionCount
>
optional
int

Minimum number of idle connections in the connection pool.

This setting can be used to reduce the number of connections that Cadenza keeps open for this connection pool.

Default: connectionPoolSize.

</minimumIdleConnectionCount>
<connectionPoolSize
>
optional
int

Maximum number of total connections of the connection pool (idle and active).

Monitoring the available connections helps to find a good value for this parameter (see Database Connection Pools).

Default: 10

</connectionPoolSize>
<connectionIdleTimeout
>
optional
int

DEPRECATED: 'connectionIdleTimeout' has been deprecated and should be removed. Due to improvements in connection pooling, Cadenza works with fixed-size connection pools, so the 'connectionIdleTimeout' setting no longer has any effect. A future Cadenza version may fail to start if the configuration is still present.

</connectionIdleTimeout>
<properties
<property
xsd:string
name
required
=
string
description
optional
=
string
>
optionalmax. unbounded
</property>
>
optional
</properties>
>
required
</database>
>
required

Login credentials and additional connection settings for the configuration database. Warning: This setting must only be configured if no system database is configured.

</configurationDatabaseConfiguration>
This is a generated sample file with fake data and all the possible options shown, refer to the Documentation tab for what combinations are valid and what is required or not. 
cadenzaconfig:
  settings:
    configurationdatabase:
      database:
        driverName: "text"
        jdbcURL: "text"
        schemaName: "text"
        user: "text"
        password: "text"
        minimumIdleConnectionCount: 15
        connectionPoolSize: 15
        connectionIdleTimeout: 15
        properties:
        - name: "text"
          description: "text"
          value: "text"
        - name: "text"
          description: "text"
          value: "text"

Filename: configurationdatabase-config.xml

This is a generated sample file with fake data and all the possible options shown, refer to the Documentation tab for what combinations are valid and what is required or not. 
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<configurationDatabaseConfiguration>
  <database>
    <driverName>text</driverName>
    <jdbcURL>text</jdbcURL>
    <schemaName>text</schemaName>
    <user>text</user>
    <password>text</password>
    <minimumIdleConnectionCount>15</minimumIdleConnectionCount>
    <connectionPoolSize>15</connectionPoolSize>
    <connectionIdleTimeout>15</connectionIdleTimeout>
    <properties>
      <property name="text" description="text">text</property>
      <property name="text" description="text">text</property>
    </properties>
  </database>
</configurationDatabaseConfiguration>