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 PostgreSQL or MySQL, while "SELECT 1 FROM DUAL" in case of Oracle.

Example core database configuration

MySQL example

#APP DB SETTINGS
RegDBType=MySQL
RegDBDriver=com.mysql.jdbc.Driver
RegDBUrl=jdbc:mysql://127.0.0.1:3306/regsys?autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8
RegDBUser=regsys
RegDBPass=regsys
RegDBMaxActive=30
RegDBValidationQuery=SELECT 1

PostgreSQL example

#APP DB SETTINGS
RegDBType=PostgreSQL
RegDBDriver=org.postgresql.Driver
RegDBUrl=jdbc:postgresql://127.0.0.1:5432/regsys
RegDBUser=regsys
RegDBPass=regsys
RegDBMaxActive=30
RegDBValidationQuery=SELECT 1

Oracle example

#APP DB SETTINGS
RegDBType=Oracle
RegDBDriver=oracle.jdbc.driver.OracleDriver
RegDBUrl=jdbc:oracle:thin:@10.0.0.30:1521:orcl
RegDBUser=regsys
RegDBPass=regsys
RegDBMaxActive=30
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

MySQL example

#Downstream DB SETTINGS
RegDSDBType=MySQL
RegDSDBDriver=com.mysql.jdbc.Driver
RegDSDBUrl=jdbc:mysql://127.0.0.1:3306/downstream?autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8
RegDSDBUser=downstream
RegDSDBPass=downstream
RegDSDBMaxActive=30
RegDSDBValidationQuery=SELECT 1

PostgreSQL example

#Downstream DB SETTINGS
RegDSDBType=PostgreSQL
RegDSDBDriver=org.postgresql.Driver
RegDSDBUrl=jdbc:postgresql://127.0.0.1:5432/downstream
RegDSDBUser=downstream
RegDSDBPass=downstream
RegDSDBMaxActive=30
RegDSDBValidationQuery=SELECT 1

Oracle example

#Downstream DB SETTINGS
RegDSDBType=Oracle
RegDSDBDriver=oracle.jdbc.driver.OracleDriver
RegDSDBUrl=jdbc:oracle:thin:@10.0.0.30:1521:orcl
RegDSDBUser=downstream
RegDSDBPass=downstream
RegDSDBMaxActive=30
RegDBValidationQuery=SELECT 1 FROM DUAL