JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Java CAPS Database Binding Component Tutorial     Java CAPS Documentation
Oracle Technology Network
Library
PDF
Print View
Feedback
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

Creating the Composite Application Project

Add the JBI module to the BPEL Module project before deploying the Composite Application. Deploying the project makes the service assembly available to the application server, thus allowing its service units to run.

To Create the Composite Application Project

  1. Choose File —> New Project from the main menu.

    This opens the New Project wizard.

  2. Select the SOA node from the Categories list.
  3. Select the Composite Application node from the Projects list.
  4. Click Next.
    image:Composite Application
  5. In the Project Name field, enter DBBCSampleCompositeApp.
    image:Enter Project Name
  6. Click Finish.

    The Projects window now contains a project node for a Composite Application project called DBBCSampleCompositeApp.


    image:Composite Application Node
  7. Right-click either the Composite Application Project node or expand the node and select JBI Modules.
  8. Select Add JBI Module.
    image:Add JBI Module
  9. Select the BpelModuleSample Project. Click Add Project JAR Files.

    The Project JAR Files is build/SEDeployment.jar.


    image:Add Project JAR Files

    The BpelModuleSample.jar file is added into the project.


    image:JAR File Added
  10. Click Save All.
    image:JBI Component

    A detailed illustration is as shown on the deployed JBI Components.

    1. Expand IDE, open the Services window, expand the GlassFish V2 node, and expand the JBI node.
    2. Right-click sun-database-binding and click Start.

      Note - If you do not see the JBI node, you need to start the Application Server by choosing Start from the pop-up menu of the GlassFish V2 node.


    image:JBI Components
  11. Right-click the DBBCSampleCompositeApp Composite Application project node and select Clean and Build.
    image:Clean and Build

    The CASA Editor displays the build of DBBCSampleCompositeApp.


    image:Build Successful

    A message is displayed in the Output window:

    BUILD SUCCESSFUL (total time: 2 seconds)
  12. Click Save All.
Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices
Previous Next