Setting up the database

You need a database with three tables and an ODBC definition to run the WBI JDBC Adapter Migration sample. To access the database the broker must be configured with a user identifier and password.

The schema of the database tables.

In the sample environment the three database tables contain information about Customers, Addresses and Invoices. Foreign Keys are defined so that a Customer row references an Address row, and an Invoice row references a Customer row. Triggers are defined so that a change to any of the tables is stored in the IBM_EVENTS table.

Set up the database tables

Complete the following tasks to set up the database tables:

  1. Create the database

    Follow the instructions that are relevant to your database manager:


  2. Create the tables within the database: Setting up the database tables by using SQL Scripts

Set up the database environment for the broker

Complete the following tasks to setup the database environment for the broker:

  1. Create an ODBC definition for the DBINPUT database with DBINPUT as the data source name (DSN).

    For instructions, see Enabling ODBC connections to the databases in the WebSphere Message Broker documentation.

  2. Specify the user identifier and password that are associated with the data source name DBINPUT.

    Use the mqsisetdbparms command to specify a user identifier and password that the broker can use with the DBINPUT data source. This user identifier must be the same user identifier that you used when you created the database in the previous step. The user identifier determines the database schema name, and the broker must use the same user identifier when accessing the table. For example, if your user identifier is USERID, the fully-qualified name of the CUSTOMER table name is USERID.CUSTOMER.

    1. Open a command console window in which you can run WebSphere Message Broker commands. Enter the following command to specify the user identifier and password:
      mqsisetdbparms MB8BROKER -n DBINPUT -u <user ID> -p <password>
    2. Enter the following command to reload the execution group:
      mqsireload MB8BROKER -e AdapterMigration

Back to sample home