Using the Database Binding Component

In this tutorial, you will create a SOA project. First add a WSDL Document to the project and use the Partner View of the WSDL Editor to add the Partner Link type. You will then create a Composite Application project and use the Composite Application (Service Assembly) Editor to modify the project configuration.

For more information about working with the NetBeans IDE, see the http://www.netbeans.org page on the NetBeans web site.

What You Need to Know

These topics provide information you need to know before using the Database Binding Component.

• Tutorial Overview
  
• Tutorial Requirement
  
• Tutorial Plan
  
• 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
  
• Creating a BPEL Module Process Using Prepared Statements
  
• Creating a BPEL Module Project Using Procedures
  
• Creating a BPEL Module Project Using SQL File
  

What You Need to Do

The topics listed here provides information about Understanding the Database Binding Component (BC). The Database BC provides a comprehensive solution for configuring and connecting to databases that support JDBC from within a JBI environment.

These topics provide instructions to complete a Database Binding Component sample Project. It also helps to test the Binding Component on the system and demonstrate how it is implemented.

• To Install the JAR Files in Database Binding Component
  
• To Install the NBM Files in Database Binding Component.
  
• To Start the GlassFish V2 Application Server From NetBeans IDE.
  
• To Create a BPEL Module Project.
  
• To Connect to a MySQL Database.
  
• To Start Administration Console.
  
• To Integrate a JDBC Driver.
  
• To Create a JDBC Connection Pool.
  
• To Create a JDBC Resource.
  
• To Create a WSDL Document : dbWSDL.
  
• To Select the Database Connection.
  
• To Edit the SQL.
  
• To Create a WSDL Document : SOAPWSDL.
  
• To Create a BPEL Process
  
• To Add a Partner Link
  
• To Add a Web Service and Basic Activities.
  
• To Edit Web Service : Receive1.
  
• To Edit the Web Service : Invoke1.
  
• To Edit the Web Service : Reply1.
  
• To Edit the Basic Activities : Assign1.
  
• To Edit the Basic Activities : Assign2.
  
• To Invoke Explicit Validation.
  
• To Create the Composite Application Project.
  
• To Deploy the Composite Application.
  
• To Test the Composite Application.
  
• To Debug the Test Case.
  

Click me
Working With the Database Binding Component
This document provides information about the Database Binding Component.

Watch Video

• Checking the Flight Details Using Tables in Database Binding Component
• Demonstrating a Poll Scenario Using Prepared Statements in Database Binding Component
• Build a Sample Project Using Stored Procedure Database WSDL
• Build a Sample Project Using a SQL File for Database WSDL

Project ZIP Files

• Sample ZIP Project File on CheckFlight Details
• Sample ZIP Project File on Poll Scenario
• Sample ZIP Project File on Stored Procedure 1
• Sample ZIP Project File on Stored Procedure 2

Return to GlassFish ESB Documentation Home

This page (revision-36) was last changed on 24-Mar-09 11:45 AM, -0700 by rjacobus.
This page was created on 06-Nov-08 10:08 AM, -0800 by SWeber.

More info...