JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Java CAPS Adapter for Oracle Tutorials     Java CAPS Documentation
Oracle Technology Network
Library
PDF
Print View
Feedback
search filter icon
search icon

Document Information

Oracle Java CAPS Adapter for Oracle Tutorials

About the Oracle Java CAPS Adapter for Oracle Sample Projects

Sample Input Trigger Files and Output Files

Sample Project Data

Operations Used in the Oracle Sample Projects

About the Oracle 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 Non-JBI Based Sample Projects

To Import a Non-JBI Based Sample Project

Running the SQL Script

Creating the Java Collaboration Definition-Based Project for the Oracle Java CAPS Adapter for Oracle

Creating a New Project

Create a Project

Creating the OTDs

Create the Oracle 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

Oracle1 Outbound Adapter Properties

Configuring the Environment Properties

Configure the Environment Properties

File Adapter Environment Properties

Oracle 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 Oracle Java CAPS Adapter for Oracle

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

Configuring the Adapter Properties

The Oracle sample Project contains several Adapters, each represented in the Connectivity Maps as a node between an External Application and a Service. The Adapters facilitate the communication and movement of data between external applications and the Oracle Java CAPS Enterprise Service Bus system. These Adapters must be configured for your system.

Adapter properties must be configured in both the Connectivity Maps and the Environment.

Configuring the Connectivity Map Properties

Connectivity Map properties are configured from each of the Connectivity Maps. These properties are specific to each of the configured Adapters, unlike the Environment properties which contain common properties for each Adapter type.

Configure the Connectivity Map Properties

  1. Open a Connectivity Map, and double-click the adapter to open the Properties Editor to that adapter's property sheet. For example, open the cmDelete Connectivity Map and double-click the inbound File Adapter (the node between the File1 External Application and the cmDelete_jcdDelete1 service).

    The Properties Editor open to the selected Adapter's property sheet.

  2. From the Properties Editor, edit the values of the appropriate properties for your system.
  3. Once you are done editing the property values for that Adapter, click OK to save the current properties.
  4. Repeat this procedure to edit all of your Connectivity Map properties.

File1 Inbound Adapter Properties

Enter the following values for the File1 Adapters.

Connectivity Map
Property Name
Required Value
cmDelete
Input file name
TriggerDelete.in
cmInsert
Input file name
TriggerBpInsert.in
cmPsSelect
Input file name
TriggerPsSelect.in
cmTableSelect
Input file name
TriggerTableSelect.in
cmUpdate
Input file name
TriggerUpdate.in

File2 Outbound Adapter Properties

Enter the following values for the outbound File2 Adapters.

Connectivity Map
Property Name
Required Value
cmDelete
Output file name
JCD_Delete_output%d.dat (for JCD Sample)
BPEL_Delete_output%d.dat (for BPEL Sample)
cmInsert
Output file name
JCD_Insert_output%d.dat (for JCD Sample)
BPEL_Insert_output%d.dat (for BPEL Sample)
cmPsSelect
Output file name
JCD_PsSelect_output%d.dat (JCD Sample)
BPEL_PsSelect_output%d.dat (for BPEL Sample)
cmTableSelect
Output file name
JCD_TableSelect_output%d.dat.in (for JCD Sample)
BPEL_TableSelect_output%d.dat.in (for BPEL Sample)
cmUpdate
Output file name
JCD_Update_output%d.dat (for JCD Sample)
BPEL_Update_output%d.dat (for BPEL Sample)

Oracle1 Outbound Adapter Properties

When you double-click the Oracle1 Outbound Adapter, the Adapter Connections dialog box appears. Choose an Adapter connection for your project (for this sample select Outbound Oracle Adapter). When the Properties Editor for the Oracle1 Outbound Adapter opens, click OK to save the default settings.

Configuring the Environment Properties

Environment properties are configured from the Services tree of the NetBeans IDE Services window.

Configure the Environment Properties

  1. From the Services tree in the NetBeans IDE Services window, expand the CAPS Environments -> envOracleProj nodes
  2. Double-click an Adapter to open the Properties Editor to the Adapter's Environment properties sheet.
  3. Edit the property values for your system. Once you are done, click OK to save the current properties.
  4. Repeat this procedure to edit all of your Environment properties.

File Adapter Environment Properties

Enter the following values for the File Adapters.

Section
Property Name
Required Value
Configuration -> Inbound File Adapter -> Parameter Settings
Directory
Enter the directory that contains the input files (trigger files included in the sample Project).

Trigger files:

  • TriggerDelete.in.~in

  • TriggerInsert.in.~in

  • TriggerPsSelect.in.~in

  • TriggerTableSelect.in.~in

  • TriggerUpdate.in.~in
Configuration -> Outbound File Adapter -> Parameter Settings
Directory
Enter the directory where output files are written.

For the JCD sample Project, the output files are:

  • JCD_Delete_output0.dat

  • JCD_Insert_output0.dat

  • JCD_PsSelect_output0.dat

  • JCD_TableSelect_output0.dat

  • JCD_Update_output0.dat

For the BPEL sample Project, the output files are:

  • BPEL_Delete_output0.dat

  • BPEL_Insert_output0.dat

  • BPEL_PsSelect_output0.da

  • BPEL_TableSelect_output0.dat

  • BPEL_Update_output0.dat

Oracle Adapter Environment Properties

Enter the following values for the outbound Oracle Adapters.

Section
Property Name
Required Value
Configuration -> Outbound Oracle Adapter -> JDBC Connector settings.
ServerName
Enter the host name of the database server being used.
DatabaseName
Enter the name of the particular database that is being used on the server.
User
Enter the user account name for the database.
Password
Enter the user account password for the database.

What's the Next Step?

For your next step, see Creating the Deployment Profile.

Copyright © 2008, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices
Previous Next