Version

    Chapter 14. System Database Configuration

    Embedded Apache Derby
    MySQL
    Creating Database
    CloverDX Server Setup
    DB2
    Creating Database
    CloverDX Server Setup
    DB2 on AS/400
    Oracle
    Creating Database
    CloverDX Server Setup
    Microsoft SQL Server
    Creating Database
    CloverDX Server Setup
    PostgreSQL
    Creating Database
    CloverDX Server Setup
    JNDI Configuration and Encryption
    JNDI DB Datasource
    JNDI Datasource Troubleshooting
    Encrypted JNDI

    The CloverDX Server license, as well as user's information, event listeners and other services, are saved in a database. For stability and performance reasons, the default Apache Derby database is not supported for production environment; therefore, you should choose one of the supported DB systems.

    [Important]Important

    Since CloverDX Server stores important data in a database, you should create a system database and set up a working connection before you activate the Server with license and configure it.

    For details on how to set up a connection to an external system database, see the list of examples below. The examples contain details on creating databases in DB systems supported by CloverDX Server and configuring a working connection between the database and the Server.

    It is possible to specify common JDBC DB connection properties (see below) or a JNDI location of DB Datasource.

    Clustered Deployment

    In a Clustered deployment, at least one node in the Cluster must have a DB connection configured. Other nodes may have their own direct connection (to the same DB), or may use another node as a proxy for persistent operations; however, the scheduler is active only on nodes with a direct connection. For more information about the feature, see Part VII, “Cluster”.

    Setting up a CloverDX Server's System Database

    1. Create a database

      • Choose one of the supported database systems and create a database dedicated to CloverDX Server. Add a user/role for Clover and grant it required rights/privileges.

    2. Configure common JDBC connection properties

      • Some JDBC connection properties are common for all supported database systems. If you use a properties file for configuration, specify these properties:

    3. Add a JDBC 4 compliant driver on the classpath.

      • As the last step, add a JDBC 4 compliant driver on the classpath. A JDBC Driver which doesn't meet JDBC 4 won't work properly.

    Below is a list of examples of individual database systems configurations.

    Examples of Database Configurations

    For officially supported versions of particular database systems, see Database servers.