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