Running the DatabaseInput Node sample

You can run the DatabaseInput message flow to perform the following actions:

  1. Make a change to an application table.
  2. Discover the change in IBM Integration Bus and propagate the changed data as a message.
  3. Convert the change into a plain XML message in the XMLNSC domain.

If you encounter any problems when you run the sample, see Resolving problems when running samples in the IBM Integration Bus documentation.

To run the DatabaseInput message flow:

  1. In the Integration Development perspective, select the Data Project Explorer view in the lower-left pane of the toolkit panel (if this is not present, open the Window menu, found on the toolbar at the top of the toolkit panel, select Show View and select Data Project Explorer)
  2. Under SQL Scripts, right-click dbinput_insert_row.sql and select Run SQL.
  3. Select an existing JDBC connection or create a new one, following the on-screen instructions.
  4. Click Finish to add a row to the table.
  5. In the Application Development view, expand the DatabaseInput sample project, the Flow Tests, and (Default Node Schema) folders and open the DatabaseInput Retrieve Message.mbtest Flow Test.
  6. Click Get Message to read a message from the DBINPUTSAMPLE.OUTPUT queue.
  7. Verify that the message retrieved contains a customer structure.

If you want to re-run the DatabaseUpdatesComplete sample, you must modify the SQL file to add a different row, to avoid violating table constraints:

  1. In the Data perspective, expand the DatabaseInput Data Design project and, under SQL Scripts, right-click dbinput_insert_row.sql and select Open With and SQL File Editor.
  2. Modify some of the VALUES parameters.
  3. Save it and re-run using the previous instructions.

Back to sample home