Creating a BPEL Module Project Using SQL File

This is the script that contains the data definition statements for the MySQL database. The file filter for the file open dialog window defaults to *.sql so you should only be able to view files with the .sql extension.

For procedure, see the following links:

1    Creating a WSDL Document For Type DATABASE.
       a    Create a .sql file using Notepad.
       b    Save the file in a folder location.

       c    Choose Type — SQL File.

       d    Click Browse to select the saved .sql file.

The selected file is displayed as shown in the Figure.

       e    Click Discover Parameters to view types for the parameters.
        f    Click Discover Resultset to discover the Resultset types.

       g    Click Next.
       h    Enter JNDI Name.
        i    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.

Watch a Demo

See Also
Type : Table

• Tutorial Overview
  
• Tutorial Requirement
  
• Tutorial Plan
  
• Downloading GlassFish ESB Installer
  
• Downloading and Installing the JAR Files and the NBM Files
  
• Database Binding Component Project in a Nutshell
  
• Starting the GlassFish V2 Application Server
  
• Creating a BPEL Module Project For Table Type Operations
  
• Connecting to a MySQL Database
  
• Working With Administration Console
  
• Setting Up Database Access
  
• Creating a WSDL Document For Type DATABASE
  
• Creating a WSDL Document For Type SOAP
  
• Creating a BPEL Process
  
• Validating BPEL
  
• Design View - Notifications
  
• Creating the Composite Application Project
  
• Deploying and Testing the Composite Application
  

Return to Using the Database Binding Component

This page (revision-9) was last changed on 25-Dec-08 11:31 AM, -0800 by PRABHAMS.
This page was created on 05-Dec-08 09:46 AM, -0800 by PRABHAMS.

More info...