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.

   1. Create a .sql file using Notepad.

   2. Save the file in a folder location.

      

   3. Choose Type — SQL File.

      

   4. Click Browse to select the saved .sql file.

      

      The selected file is displayed as shown in the Figure.

      

   5. Click Discover Parameters to view types for the parameters.

   6. Click Discover Resultset to discover the Resultset types.

      

   7. Click Next.

   8. Enter JNDI Name.

   9. 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 demonstration, see http://wiki.open-esb.java.net/Wiki.jsp?page=BuildSampleProjectSQLFileDatabaseWSDL.