userpreferences

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.
<userPreferencesConfiguration
>
required

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

<database
<driverName
>
required
string

Name of the JDBC driver used

</driverName>
<jdbcURL
>
required
string

JDBC URL of the database Syntax: For Oracle: jdbc:oracle:thin:@servername:port:sid (and also the other common syntaxes supported by Oracle) For PostgreSQL: jdbc:postgresql://servername:port/instance

</jdbcURL>
<user
>
required
string

Database user to be used to establish the database connection

</user>
<password
>
required
string

Password of the database user, usually expected to be encoded with the Cadenza password encoder (see also Secrets in Configuration).

</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>
<properties
<property
xs:string
name
required
=
string
description
optional
=
string
>
optionalmax. unbounded
</property>
>
optional
</properties>
>
required
</database>
</userPreferencesConfiguration>
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:
    userpreferences:
      database:
        driverName: "text"
        jdbcURL: "text"
        user: "text"
        password: "text"
        minimumIdleConnectionCount: 15
        connectionPoolSize: 15
        properties:
        - name: "text"
          description: "text"
          value: "text"
        - name: "text"
          description: "text"
          value: "text"

Filename: userpreferences-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"?>
<userPreferencesConfiguration>
  <database>
    <driverName>text</driverName>
    <jdbcURL>text</jdbcURL>
    <user>text</user>
    <password>text</password>
    <minimumIdleConnectionCount>15</minimumIdleConnectionCount>
    <connectionPoolSize>15</connectionPoolSize>
    <properties>
      <property name="text" description="text">text</property>
      <property name="text" description="text">text</property>
    </properties>
  </database>
</userPreferencesConfiguration>