All docs This doc

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.


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:

Code Block
INFO LogMediator text = ** Looking up from the Database ** ...
INFO LogMediator text = Company ID - c1 ...
INFO LogMediator text = Stock price - 183.3635460215262