Using the Database Binding Component

Creating a BPEL Module Project Using Procedures

A Procedure represents a database stored procedure. Fields correspond to the arguments of a stored procedure while methods are the operations that you can apply. It allows you to execute a stored procedure.


Note –

Select a Procedure from the list and add the stored procedure to the Selected Stored Procedures console.


    For procedure, see the following links:

  1. Creating a WSDL Document For Type : DATABASE

    1. Select Type — Procedures

      Procedures Statement
    2. Click Next.

    3. Select the URL from the drop-down list.

    4. Select a Stored Procedure and click Add to move the selected Stored Procedure to the Selected Stored Procedure panel.

      Select Procedure
    5. Click Next.

    6. Enter JNDI Name.

    7. Click Finish.

  2. Creating a WSDL Document For Type SOAP

  3. Creating a BPEL Process.

  4. Validating BPEL.

  5. Design View : Notifications.

  6. Creating the Composite Application Project.

  7. Deploying and Testing the Composite Application.

For a demo, see http://wiki.open-esb.java.net/Wiki.jsp?page=DatabaseComponentStoredProcedure.