userpreferences

This configuration is required when using the plugin Cadenza.

  • 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
<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
xs:string
encrypted
optional
=
boolean
>
required

Password of the database user. By default, the password should be Cadenza encoded, you can set the encrypted attribute to false for a plaintext password.

</password>
<connectionPoolSize
>
optional
int

Number of connections the connection pool may create to the database

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
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:
          encrypted: true
          value: "text"
        connectionPoolSize: 15
        connectionIdleTimeout: 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 encrypted="true">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>
</userPreferencesConfiguration>