Page Comparison

The WSO2 Governance Registry has been tested to work with various relational database management systems including,

• H2 (Embedded and Server)
• Apache Derby (Embedded and Server)
• MS SQL Server
• MySQL
• Oracle
• OpenEdge
• PostgreSQL
• IBM DB2

The [CARBON$GREG_HOME]/repository/conf/registry.xml refers to a database configuration defines at [CARBON$GREG_HOME]/repository/conf/datasources/master-datasources.xml as given below.

...

The server administrator can define the type of database to be used, along with the JDBC connection URL to connect to the database and a compatible driver via the database configuration parameters in the [CARBON$GREG_HOME]/repository/conf/datasources/master-datasources.xml as given below.

...

• url - The URL of the database.

• username - The name of the database user.

• password - The password of the database user.
• driverClassName - The fully qualified Java class name of the JDBC driver to be used.
• maxActive - The maximum number of active connections that can be allocated from this pool at the same time, or negative for no limit.
• maxWait - The maximum number of milliseconds that the pool will wait (when there are no available connections) for a connection to be returned before throwing an exception, or <= 0 to wait indefinitely.
• minIdle - The minimum number of active connections that can remain idle in the pool, without extra ones being created, or 0 to create none.

...

• validationQuery - This is used to validate the DB connection to test whether its healthy (For example, SELECT 1 or SELECT 1 FROM DUAL in Oracle).
• testOnBorrow - The indication of whether objects will be validated before being borrowed from the pool.
• validationInterval - The specified time interval for validations to run.

Therefor all the database configurations should be defined in the master-datasources.xml . The database configurations that are needed to be define inside the user-mgt.xml should also be pointed to the configurations defined in the master-datasources.xml. You can find the database configurations for the different databases here.

...