The WSO2 Governance Registry has been tested to work with various relational database management systems including,
...
| Code Block |
|---|
<datasource>
<name>WSO2_CARBON_DB</name>
<description>...</description>
<jndiConfig>
<name>jdbc/WSO2CarbonDB</name>
</jndiConfig>
<definition type="RDBMS">
<configuration>
<url>jdbc:h2:repository/database/WSO2CARBON_DB;DB_CLOSE_ON_EXIT=FALSE</url>
<username>wso2carbon</username>
<password>wso2carbon</password>
<driverClassName>org.h2.Driver</driverClassName>
<maxActive>50</maxActive>
<maxWait>60000</maxWait>
<testOnBorrow>true</testOnBorrow>
<validationQuery>SELECT 1</validationQuery>
<validationInterval>30000</validationInterval>
</configuration>
</definition>
</datasource> |
| Info | ||
|---|---|---|
| ||
The JDBC URL of the registry database is used in construction of cache keys. The cache keys are case sensitive, and therefore, you might run into caching issues if you do not consider the case. |
Mandatory Configuration Elements
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 1orSELECT 1 FROM DUALin 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.
...