Page History

Introduction

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.

Prerequisites

• 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