Repository List

Cadenza requires at least one database repository in order to function. This is an internally managed database schema that Cadenza uses to store information about the contents you and your users have configured in Cadenza.

The configuration file is called repositoryList.xml and should be inside the same configuration folder where you store your plugin list and other configuration files.

Configuring a Database Repository

<?xml version="1.0" encoding="UTF-8"?>
<repositoryList>
  <databaseRepository name="repository1" printName="Repository 1">
    <driverName>oracle.jdbc.OracleDriver</driverName>
    <jdbcURL>jdbc:oracle:thin:@//example.oracle.server:1521/my_repositoryDB</jdbcURL>
    <user>USER</user>
    <password encrypted="true">the_disy_encoded_password</password>
    <connectionPoolSize>10</connectionPoolSize>
  </databaseRepository>
</repositoryList>

The following applies:

<databaseRepository>: This is the element that introduces a new database repository. At least one is required but you can also have more.
- name: Unique ID of the repository
- printName: Name of the repository as it should be displayed on the user interface
<driverName>: Name of the JDBC driver used. Environment variable, system properties and Cadenza variable can be used.
<jdbcURL>: JDBC URL of the database. Environment variable, system properties and Cadenza variable can be used. The JDBC URL can optionally be parameterized, for example with a schema.
<userName>: Database user to be used to establish the database connection. Environment variable, system properties and Cadenza variable can be used.
<password>: Password of the database user. Environment variable, system properties and Cadenza variable can be used.
- encrypted: Specifies whether the password is encrypted (default value is true). (Learn how to encode passwords for Cadenza)
<connectionPoolSize> (optional): Number of connections that the connection pool may generate to the database (default value is 10). Monitoring the available connections helps finding a good value for this parameter. Variables like $SYSTEM{CONNECTION_POOL_SIZE} can be used.
<properties> (optional): Database-specific connection parameters, for example for the secure database connection with Oracle Advanced Security (OAS). Environment variable, system properties and Cadenza variable can be used.