The Multichannel application sample supports DB2 or Derby database. If you did not previously configure any database connection, create and configure a database connection for running the Multichannel application sample. The procedure for creating and configuring a Derby database connection is taken as an example.
To create and configure a Derby database connection
1 Copy the derby folder that contains derby program files to the root installation directory of WebSphere Application Server.
The default installation directory for is DRIVE\Programmefiles\IBM\WebSphere\AppServer.
2 In the Data Source Explorer view, right-click the blank space and click New.
3 In the New Connection window, select Derby from the Database manager list.
4 Select Derby 10.2 – Derby Client JDBC Driver Default from the JDBC driver list.
5 Click the triangle icon on the right side of the JDBC driver list.
6 In the Edit Jar List window, if the derbyclient.jar file is not in the list or the path of the file is not correct, add or edit the path for the derbyclient.jar file.
The derbyclient.jar file is in the DRIVE\Programmefiles\IBM\WebSphere\AppServer\derby\lib\ directory.
7 Click OK.
8 In the New Connection window, set Port number to 1527 and configure the other settings according to your requirements.
9 Click Finish. The Derby database connection is displayed under the Database Connections node.
After completing this task
Configure the WebSphere Application Server deployment environment.