|Table of Contents|
This sample demonstrates demonstrates how you can use the dblookup mediator and dbreport mediator DBLookup Mediator and DBReport Mediator to execute database stored procedures. Here the the dblookup mediator and dbreport mediator are used to access the database with statements that call a stored procedure in MySQL.
- MySQL database installed and configured. For instructions on setting up the MySQL database, see Setting up the MySQL database.
- For a list of general prerequisites, see Prerequisites to Start the ESB Samples.
Building the sample
The XML configuration for this sample is as follows:
When the client is run, you will see that the ESB invokes the two stored procedures as and that the response is mediated back to the client.
If you analyze analyze the debug log output on the ESB console, you will see the following output:
INFO LogMediator text = ** Looking up from the Database ** ... INFO LogMediator text = Company ID - c1 ... INFO LogMediator text = Stock price - 183.3635460215262