Versions Compared

Old Version 1

changes.mady.by.user Former user

Saved on

compared with

New Version 2

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Download the latest version of DB2 Express-C (http://www-01.ibm.com/software/data/db2/express/download.html) and install it on your computer.

Info
titleTip

For instructions on installing DB2 Express-C, refer to

http://www.ibm.com/developerworks/wikis/display/db2/free+book-+getting+started+with+db2+express-c.

...

1. Edit the default database configuration defined in the  master-datasources.xml  file located at  $CARBON$PRODUCT_HOME/repository/conf/datasources  directory as below. Both the database configurations in  registry.xml  and  user-mgt.xml  refer this data source.

Note
Info
title

You have to replace these settings with your custom values.

...

  • 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.
Tip
Info
title

Default port for db2 instance is 50000.

...

Copy the DB2 jdbc Drivers ( db2jcc.jar and db2jcc_license_c0u.jar) from $DB2_HOME\SQLLIB\java to $CARBON_HOME/repository/components/lib directory.

Tip
Info
title

$DB2_HOME refers to the installation directory of DB2 Express C and $CARBON_HOME refers to the directory where you run the WSO2 Carbon instance.

...

Database tables can be created manually by executing the following script in DB2 Express C command editor.

Code Block
$CARBON$PRODUCT_HOME/dbscripts/db2.sql

Using start-up Parameters

Database tables can be created when starting WSO2 BPS for the first time using the startup parameters as follows.

  • For Windows:

    Code Block
    $CARBON$PRODUCT_HOME/bin/wso2server.bat -Dsetup

  • For Linux:

    Code Block
    $CARBON$PRODUCT_HOME/bin/wso2server.sh -Dsetup

...