JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Java CAPS Adapter for SQL Server Tutorials     Java CAPS Documentation
search filter icon
search icon

Document Information

Java CAPS Adapter for SQL Server Tutorials

About the Adapter for SQL Server Sample Projects

Sample Input Trigger Files and Output Files

Sample Project Data

Operations Used in the SQL Server Sample Projects

About the Java CAPS Business Process Manager Project

Associating Business Process Manager Operators

Deploying JCD- Based Operations in the Business Process Manager

About the Java Collaboration Definition Sample Project

Importing the Sample Projects

To Import the Sample Project

Running the SQL Script

Creating the Java Collaboration Definition Project for the Java CAPS Adapter for SQL Server

Creating a New Project

Create a Project

Creating the OTDs

Create the SQL Server Database OTD

Create the Inbound and Outbound DTD OTDs

Creating the Collaboration Definitions (Java)

Create the jcdDelete Collaboration Definition

Using the Java Collaboration Editor to Create Business Rules

Creating the Business Rules for the jcdDelete Collaboration

Create the jcdDelete Collaboration Business Rules

jcdDelete Collaboration Java Code

Creating the Business Rules for the jcdInsert Collaboration

Create the jcdInsert Collaboration Business Rules

jcdInsert Collaboration Java Code

Creating the Business Rules for the jcdPsSelect Collaboration

Using the Collaboration Editor's Java Source Editor

Create the jcdPsSelect Collaboration Business Rules

Creating the Business Rules for the jcdTableSelect Collaboration

Create the jcdTableSelect Collaboration Business Rules

jcdTableSelect Collaboration Java Code

Creating the Business Rules for the jcdUpdate Collaboration

Create the jcdUpdate Collaboration Business Rules

jcdUpdate Collaboration Java Code

Next Steps

Creating the Connectivity Maps

Adding Connectivity Maps to a Project

Add the Connectivity Maps to the Project

Populating and Binding the Connectivity Maps Using the Connectivity Map Generator

Populate the Connectivity Maps Using the Connectivity Map Generator.

Creating an Environment

Create the Environment

Configuring the Adapter Properties

Configuring the Connectivity Map Properties

Configure the Connectivity Map Properties

File1 Inbound Adapter Properties

File2 Outbound Adapter Properties

SQL1 Outbound Adapter Properties

Configuring the Environment Properties

Configure the Environment Properties

File Adapter Environment Properties

SQL Server Adapter Environment Properties

What's the Next Step?

Creating the Deployment Profile

Create the Deployment Profile

Building and Deploying the Project

Building the Project

Build the Project

Deploying the Project from NetBeans

Deploy the Project

Running the Project

Run the Project

Creating the BPEL-Based Project for the Adapter for SQL Server

Creating the Business Processes

Create the bpDelete Business Process

Create the bpInsert Business Process

Create the bpPsSelect Business Process

Create the bpTableSelect Business Process

Create the bpUpdate Business Process

Using Business Process Designer to Create Business Rules

Creating the bpDelete Business Rules

Create the bpDelete Business Rules

Creating the bpInsert Business Rules

Create the bpInsert Business Rules

Creating the bpPsSelect Business Rules

Create the bpPsSelect Business Rules

Creating the bpTableSelect Business Rules

Create the bpTableSelect Business Rules

Creating the bpUpdate Business Rules

Create the bpUpdate Business Rules

Creating the Business Processes

The business process flow contains all the BPEL elements that make up a business process.

This section walks you through creating the project's five business processes:

Create the bpDelete Business Process

  1. From the Projects window, right-click your new project and select New -> Business Process from the shortcut menu.

    The Business Process Designer opens and BusinessProcess1 is added to the Project tree.

  2. Rename BusinessProcess1 to bpDelete.
  3. From the Projects window, expand CAPS Components Library -> Adapters -> File -> FileClient.
  4. Select and drag the FileClient.receive activity from the project tree to the Business Process Designer canvas.
  5. As in the previous step, drag the FileClient.write activity from the CAPS Components Library -> Adapters -> File -> FileClient directory to the Business Process Designer canvas, and then drag another FileClient.write activity to the canvas, so you have two FileClient.write activities in your BPEL process.
  6. From the Projects window, expand prjSQLServer_BPEL -> otdALL -> otdSQLServer. Select and drag the otdSQLServer.Db_employeeDelete activity from the project tree to the Business Process Designer canvas.
  7. Connect the activities in the bpDelete BPEL canvas by dragging your cursor from the output node of one activity to the input node of the next activity, as follows:
    • Start -> FileClient.receive

    • FileClient.receive -> FileClient.write

    • FileClient.write -> otdSQLServer.db_employeeDelete

    • otdSQLServer.Db_employeeDelete -> FileClient.write

    • FileClient.write -> End


    image:Image shows the dbDelete BPEL Process before the business rules have been added.
  8. Click Save All to save the latest changes to your project.

Create the bpInsert Business Process

  1. From the Projects window, right-click your new project, point to New, and then select Business Process.
  2. Rename your new business process to bpInsert.
  3. From the Projects window, expand CAPS Components Library -> Adapters -> File -> FileClient.
  4. Select and drag the FileClient.receive activity from the project tree to the Business Process Designer canvas.
  5. As in the previous step, drag the FileClient.write activity from the CAPS Components Library -> Adapters -> File -> FileClient directory to the Business Process Designer canvas, and then drag another FileClient.write activity to the canvas, so you have two FileClient.write activities in your BPEL process.
  6. From the Projects window, expand prjSQLServer_BPEL -> otdALL -> otdInputDTD_DB_employee. Select and drag the unmarshal activity from the project tree to the Business Process Designer canvas.
  7. Connect the following activities:
    • Start -> FileClient.receive

    • FileClient.receive -> FileClient.write

    • FileClient.write -> otdInputDTD_DB_employee.unmarshal

  8. Create the Insert Scope with a While statement.
    1. From the Business Process Designer toolbar, select a Scope element and drag it to the canvas. Double-click the Scope element to expand the element.
    2. Rename the Scope element to Insert.
    3. From the Business Process Designer toolbar, select a While element and drag it into the expanded Scope element box on the canvas. Double-click the While element to expand the element.
    4. From the Projects window, expand prjSQLServer_BPEL -> otdALL -> otdSQLServer. Select and drag the otdSQLServer.DB_EMPLOYEEInsert activity from the project tree into the expanded While element box on the Business Process Designer canvas.
    5. Connect the following elements:
      • otdInputDTD_DB_employee.unmarshal -> Scope element input node

      • Scope element input node -> While element input node

      • While element input node -> otdSQLServer.DB_EMPLOYEEInsert

      • otdSQLServer.DB_EMPLOYEEInsert -> While element output node

      • While element output node -> Scope element output node

      • Scope element output node -> FileClient.write

      • FileClient.write -> End


    image:Image shows the bpInsert business process from the Business Process Designer.
  9. Click Save All to save the latest changes to your project.

Create the bpPsSelect Business Process

  1. From the Projects window, right-click your new project, point to New, and then select Business Process from the shortcut menu.
  2. Rename your new business process to bpPsSelect.
  3. Add the following activities to the bpPsSelect Business Process canvas.
    • FileClient.Receive (CAPS Components Library -> Adapters -> File -> FileClient)

    • FileClient.Write

    • FileClient.Write

    • Select_psPSSelectAll (prjSQLServer_BPEL -> otdALL -> otdSQLServer)

  4. Connect the following activities:
    • Start -> FileClient.receive

    • FileClient.receive -> FileClient.write

    • FileClient.write -> otdSQLServer.Select_psPSSelectAll

  5. Create the Decision.
    1. From the Business Process Designer toolbar, select a Branching Activity -> Decision element and drag it to the canvas.

      This adds a Decision and Decision.end element to the canvas.

    2. From the Business Process Designer toolbar, select a Scope element and drag it to the canvas. Double-click the Scope element to expand the element.
    3. Rename the Scope element to Records found.
    4. From the Projects window, expand prjSQLServer_BPEL -> otdALL -> otdInputDTD_DB_employee. Select and drag the marshal activity from the project tree into the expanded Records found element box on the Business Process Designer canvas.
    5. From the Projects window, select and drag the FileClient.write activity from the project tree into the expanded Records found element box on the Business Process Designer canvas.
    6. Connect the following elements:
      • otdSQLServer.Select_psPSSelectAll -> Decision element input node

      • Decision element -> Records found input node

      • Records element input node -> otdInputDTD_DB_employee.marshal

      • otdInputDTD_DB_employee.marshal -> FileClient.write

      • FileClient.write -> Records found element output node

      • Records found element output node -> Decision.end

    7. From the Business Process Designer toolbar, select another Scope element and drag it to the canvas. Double-click the Scope element to expand the element.
    8. Rename the Scope element to No Record.
    9. From the Projects window, select and drag the FileClient.write activity from the project tree into the expanded No Record element box on the Business Process Designer canvas.
    10. Connect the following elements:
      • otdSQLServer.Select_psPSSelectAll -> Decision element input node

      • Decision element -> No Record input node

      • No Record input node -> FileClient.write

      • FileClient.write -> No Record element output node

      • No Record element output node -> Decision.end

  6. Connect the following elements:
    • Decision.end -> FileClient.write

    • FileClient.write -> End


    image:Image shows the bpPsSelect business process from the Business Process Designer.

Create the bpTableSelect Business Process

  1. From the Projects window, right-click your new project, point to New, and then select Business Process.
  2. Rename your new business process to bpTableSelect.
  3. Add the following activities to the bpTableSelect Business Process canvas.
    • FileClient.Receive (CAPS Components Library -> Adapters -> File -> FileClient)

    • FileClient.Write

    • FileClient.Write

    • FileClient.Write

    • DB_EMPLOYEESelectAll (prjSQLServer_BPEL -> otdALL -> otdSQLServer)

    • marshal (prjSQLServer_BPEL -> otdALL -> otdInputDTD_DB_employee)

  4. Connect the following activities:
    • Start -> FileClient.receive

    • FileClient.receive -> FileClient.write

    • FileClient.write -> otdSQLServer.DB_EMPLOYEESelectAll

    • otdSQLServer.DB_EMPLOYEESelectAll -> otdInputDTD_DB_employee.marshal

    • otdInputDTD_DB_employee.marshal -> FileClient.write

    • FileClient.write -> FileClient.write

    • FileClient.write -> End


    image:Image shows the bpTableSelect Business Process from the Business Process Designer.

Create the bpUpdate Business Process

  1. From the Projects window, right-click your new project, point to New, and then select Business Process from the shortcut menu.
  2. Rename your new business process to bpUpdate.
  3. Add the following activities to the bpTableSelect Business Process canvas.
    • FileClient.Receive (CAPS Components Library -> Adapters -> File -> FileClient)

    • FileClient.Write

    • FileClient.Write

    • DB_EMPLOYEEUpdate (prjSQLServer_BPEL -> otdALL -> otdSQLServer)

  4. Connect the following activities:
    • Start -> FileClient.receive

    • FileClient.receive -> FileClient.write

    • FileClient.write -> otdSQLServer.DB_EMPLOYEEUpdate

    • otdSQLServer.DB_EMPLOYEEUpdate -> FileClient.write

    • FileClient.write -> End


    image:Image shows the bpTableSelect business process from the Business Process Designer.
  5. Save your project.

Next Steps

For your next step, see Using Business Process Designer to Create Business Rules.