Running the DatabaseInput Node sample
You can run the DatabaseInput message flow to perform the following
actions:
- Make a change to an application table.
- Discover the change in IBM Integration Bus and propagate the
changed data as a message.
- 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:
- 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)
- Under SQL Scripts, right-click
dbinput_insert_row.sql
and select Run SQL.
- Select an existing JDBC connection or create a new one, following the
on-screen instructions.
- Click Finish to add a row to the
table.
- 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.
- Click Get Message to read a
message from the DBINPUTSAMPLE.OUTPUT queue.
- 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:
- 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.
- Modify some of the VALUES parameters.
- Save it and re-run using the previous instructions.
Back to sample home