...
1. Edit the default database configuration defined in the master-datasources.xml file located at $GREG_HOME/repository/conf/datasources directory of the deployed registry instance as below. Both the database configurations in registry.xml and user-mgt.xml refer this data source.
| Info | ||
|---|---|---|
| ||
Replace the following settings with your own custom values: |
| Code Block |
|---|
<datasource>
<name>WSO2_CARBON_DB</name>
<description>The datasource used for registry and user manager</description>
<jndiConfig>
<name>jdbc/WSO2CarbonDB</name>
</jndiConfig>
<definition type="RDBMS">
<configuration>
<url>jdbc:derby://localhost:1527/db;create=true</url>
<userName>regadmin</userName>
<password>regadmin</password>
<driverClassName>org.apache.derby.jdbc.ClientDriver</driverClassName>
<maxActive>80</maxActive>
<maxWait>60000</maxWait>
<minIdle>5</minIdle>
<testOnBorrow>true</testOnBorrow>
<validationQuery>SELECT<validationQuery>values 1</validationQuery>
<validationInterval>30000</validationInterval>
</configuration>
</definition>
</datasource>
|
...
- url - The URL of the database.
- userName username - The name of the database user.
- password - The password of the database user.
- driverClassName - The class name of the database driver.
- 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.
| Info | ||
|---|---|---|
| ||
In contrast to the embedded registry, in the remote registry, you will set the database driver name (the |
...
Setup Drivers
Place Copy derby.jar, derbyclient.jar and derbynet.jar in the from $DERBY_HOME/lib in to $GREG_HOME/repository/components/extensions directory (to the class path of the WSO2 Governance Registry web application).
...
Create Database
...