WebSphere Message Broker, Version 8.0.0.7
Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS
See information about the latest product version
See information about the latest product version
Selecting data from a table
To map an output element from a database table, use the Graphical Data Mapping editor to retrieve the relevant rows from the database and then populate the output elements with values from the database.
Before you start:
You must complete
the following tasks:
- Create a graphical data map by using the Graphical Data Mapping editor. For information, see Creating graphical data maps.
Next:
- If you want exceptions that are returned from the database server when the SQL operation is run to be handled by the map, instead of having such exceptions stop the map and being reported, you can add a Failure transform into the transform group; see Handling database exceptions in a graphical data map.
- Set up a JDBC connection to the database that you want to access; see Enabling JDBC connections to the databases.