JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Java CAPS Database Binding Component Tutorial     Java CAPS Documentation
search filter icon
search icon

Document Information

Using the Database Binding Component

Tutorial Plan

Database Binding Component Project in a Nutshell

Starting the GlassFish V2 Application Server

To Start the GlassFish V2 Application Server From NetBeans IDE

Creating a BPEL Module Project For Table Type Operations

To Create a BPEL Module Project

Connecting to a MySQL Database

To Connect to a MySQL Database

Starting the GlassFish Admin Console

To Start the Admin Console

Setting Up Database Access

Integrating a JDBC Driver

To Integrate a JDBC Driver

Creating a JDBC Connection Pool

To Create a JDBC Connection Pool

To Create a JDBC Resource

Creating a WSDL Document For Type : DATABASE

To Create a WSDL Document : dbWSDL

To Select the Database Connection

To Edit the SQL Code

Source View

Creating a WSDL Document For Type SOAP

To Create a WSDL Document : SOAPWSDL

Creating a BPEL Process

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

Validating BPEL

To Invoke Explicit Validation

Design View : Notifications

The Design View

Creating the Composite Application Project

To Create the Composite Application Project

Deploying and Testing the Composite Application

To Deploy the Composite Application

To Test the Composite Application

Debug the Test Case

To Debug the Test Case

Creating a BPEL Module Process Using Prepared Statements

Creating a BPEL Module Project Using Procedures

Creating a BPEL Module Project Using SQL File

Deploying and Testing the Composite Application

In this section, you deploy the Composite Application project and then test the deployed application. Start the GlassFish Application Server before deploying the project. See Starting the GlassFish V2 Application Server.

To Deploy the Composite Application

Troubleshooting

  1. Select the project node in the Projects window.

    For example, DBBCSampleCompositeApp

  2. Right-click and choose Deploy.
    image:Deploy Successful

    After successful deployment of the project the following message appears in the Output window:

    BUILD SUCCESSFUL (total time: 18 seconds)

To Test the Composite Application

  1. Click Test.
  2. Right-click and select New Test Case.
  3. Enter the Test Case Name.
  4. Click Next.
  5. Select the WSDL Document.
    1. Select the following:

      For example, SOAPWSDL.wsdl from BpelModuleSample : Process Files.


      Note - One WSDL document must be selected.



      image:Select WSDL Document
    2. Click Next.
    3. Select the following:

      SOAPWSDLOperation from SOAPWSDLPort (Binding=”SOAPWSDLBinding”)


      Note - One operation to text must be selected.



      image:Select SOAP WSDL
  6. Click Finish.

    The Source Code is as shown.


    image:Test Case Source Code
  7. Enter the string values.

    For example:

    • NAME — Nano Apple

    • CUSTOMER_ID — 3


    image:Enter Values

    When you enter the string values in the Input.xml window, the output console displays Retrieve.xml. This window displays the location to save the data.

  8. Right-click the Test Case and click Run.

    A confirmation box to overwrite the Output is displayed. Click Yes to overwrite.


    image:Overwrite Empty Output

    The Output is as shown in the illustration.


    image:Final Output Console

Debug the Test Case

You can debug the test case.

To Debug the Test Case