Page Comparison

...

Setup Configuration File

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 give the following:

...

.xml and user-mgt.xml refer this data source.

Image Added

        <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="mssql-dbRDBMS">
                <configuration>
                    <url>jdbc:jtds:sqlserver://10.100.3.251:1433/wso2greg</url>
                   	<url>jdbc:jtds:sqlserver://SERVER_NAME:PORT/DB_NAME</url>
	 <username>regadmin</username>
               <userName>USER_NAME</userName> 	    <password>PASSWORD<<password>regadmin</password>
	
                    <driverName>net<driverClassName>net.sourceforge.jtds.jdbc.Driver</driverName>driverClassName>
                    <maxActive>80</maxActive>
                    <maxWait>60000</maxWait>
                    <minIdle>5</minIdle>
         </dbConfig>

2. Edit $GREG_HOME/repository/conf/user-mgt.xml and give the following:

<Configuration>           <testOnBorrow>true</testOnBorrow>
 ...         <Property name="url">jdbc:jtds:sqlserver://SERVER_NAME:PORT/DB_NAME</Property>         <Property name="userName">USER_NAME</Property><validationQuery>SELECT 1</validationQuery>
         <Property name="password">PASSWORD</Property>         <Property name="driverName">net.sourceforge.jtds.jdbc.Driver</Property> <validationInterval>30000</validationInterval>
        <Property name="maxActive">50</Property>       </configuration>
 <Property name="maxWait">60000</Property>         <Property name="minIdle">5</Property> </definition>
        </Configuration>
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.
• 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.

...

...

Create Database Tables

Database tables can be created either manually by running scripts or automatically by using start-up parameters.

...

Linux users should use $GREG_HOME/bin/wso2server.sh -Dsetup.

Image Added