Page Comparison

Follow the instructions below to set up a remote H2 database.

...

...

...

Preparing the remote H2 DB

...

3. Run the H2 database server with the following commands.

• For Linux:

$ ./h2.sh

• For Windows:

$ h2.bat

The script will start the database engine and bring up a pop-up window with a "Start Browser" button. The "Start Browser" button will open a web browser containing a client application, which you can connect to a database. H2 will automatically create a database if a database does not exist by the name you provide in the "JDBC URL" text box.

...

Setup Configuration Files

1. Open the  Edit the default database configuration defined in the master-datasources.xml file located at $GREG_HOME/repository/conf/registry.xml file, where GREG_HOME is the installation directory datasources directory of the deployed registry distribution.

Image Removed

2. Edit the registry.xml file as below:

Image Removedinstance as below. Both the database configurations in registry.xml and user-mgt.xml refer this data source.

Image Added

<currentDBConfig>h2-db</currentDBConfig>    <datasources>
       <datasource>
            <name>WSO2_CARBON_DB</name>
            <description>The datasource used for registry and user manager</description>
            <jndiConfig>
                <name>jdbc/WSO2CarbonDB</name>
            </jndiConfig>
            <dbConfig<definition nametype="h2-db">RDBMS">
                <configuration>
                    <url>jdbc:h2:tcp://localhost/~/registryDB;create=true</url>
                    <userName>regadmin</userName>
                    <password>regadmin</password>
               <driverName>org     <driverClassName>org.h2.Driver</driverName>driverClassName>
                    <maxActive>80</maxActive>
                    <maxWait>60000</maxWait>
                    <minIdle>5</minIdle>
                    <testOnBorrow>true</testOnBorrow>
                    <validationQuery>SELECT 1</validationQuery>
                    <validationInterval>30000</validationInterval>
                </configuration>
            </dbConfig>definition>
        </datasource>

The database configuration options

• url - The URL of the database.
• userName - The name of the database user.
• password - The password of the database user.
• driverName 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.

3. Open the $GREG_HOME/repository/conf/user-mgt.xml file.

Image Removed

4. Edit the user-mgt.xml file as below:

Image Removed

...

• .

...

...

Setup Drivers

...

1. The first time you start the registry, run it with the -Dsetup option. It will create the H2 database with all the underlying tables.

• For Linux:

sh wso2server.sh -Dsetup

Image RemovedImage Added

• For Windows:

wso2server.bat -Dsetup

Manual Table Creation using scripts

...

2. After setting up the registry DB tables, start the server with the following commands.

• For Linux:

sh wso2server.sh

Image Removed 

• For Windows:

wso2server.bat