Database Connections

    In order to define the database back-end used for the application the following sections have to be overridden in the registry.properties file. This file can be placed in an arbitrary folder, that has to be referenced by the REGISTRYCXN_HOME environment variable.

    The core registry database configuration is defined by the following block. Most of the parameters are very straightforward to modify. The validation query has to be adjusted to the database type: "SELECT 1" in case of MySQL, while "SELECT 1 FROM DUAL" in case of Oracle. Core database configuration

    
    #APP DB SETTINGS
    RegDBType=MySQL
    #RegDBType=Oracle
    RegDBDriver=com.mysql.jdbc.Driver
    #RegDBDriver=oracle.jdbc.driver.OracleDriver
    RegDBUrl=jdbc:mysql://127.0.0.1:3306/regsys?autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8
    #RegDBUrl=jdbc:oracle:thin:@10.0.0.30:1521:orcl
    RegDBUser=regsys
    RegDBPass=regsys
    RegDBMaxActive=30
    RegDBValidationQuery=SELECT 1
    #RegDBValidationQuery=SELECT 1 FROM DUAL

    An example implementation of a downstream consumer database is provided that uses a very similar database schema. The connection information for that schema can be described with the following parameters, the same way as the core database connectivity. Example downstream database configuration

    
    #Downstream DB SETTINGS
    RegDSDBType=MySQL
    #RegDSDBType=Oracle
    RegDSDBDriver=com.mysql.jdbc.Driver
    #RegDSDBDriver=oracle.jdbc.driver.OracleDriver
    RegDSDBUrl=jdbc:mysql://127.0.0.1:3306/downstream?autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8
    #RegDSDBUrl=jdbc:oracle:thin:@10.0.0.30:1521:orcl
    RegDSDBUser=downstream
    RegDSDBPass=downstream
    #RegDSDBPass=regsys
    RegDSDBMaxActive=30
    RegDSDBValidationQuery=SELECT 1
    #RegDBValidationQuery=SELECT 1 FROM DUAL