This sample demonstrates how to perform a simple database read operation database using the DBLookup mediator.
In this sample, when a message arrives at the DBLookup mediator, it opens a connection to the database and executes the SQL query. The SQL query uses the
? character for attributes that are specified at runtime, and the parameters define how to calculate the value of those attributes.Here, the DBLookup mediator is used to extract the id of the company from the company database using the symbol that is evaluated using an XPath against the SOAP envelope, and the id base switching is done by a Switch mediator.
- Set up the Apache Derby database. For information on how to set up the Derby database, see Setting up Derby.
- For a list of general prerequisites, see Prerequisites to Start the ESB Samples.