configurationdatabase

This configuration is required when using the plugins:

  • AccessManager

  • Location_Finder

  • Workbook

  • 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

The password for the database user

</password>
<connectionPoolSize
>
optional
int

Size of the database connection pool

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

Configuration for the Configuration Database.

</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"
        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>
    <connectionPoolSize>15</connectionPoolSize>
    <connectionIdleTimeout>15</connectionIdleTimeout>
    <properties>
      <property name="text" description="text">text</property>
      <property name="text" description="text">text</property>
    </properties>
  </database>
</configurationDatabaseConfiguration>