JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Using Database Operations with Oracle Java CAPS Database Adapters     Java CAPS Documentation
search filter icon
search icon

Document Information

1.  Using Database Operations

Using DB2 Operations

DB2 Database Operations (BPEL)

Activity Input and Output

DB2 Database Operations (JCD)

The Table

The Stored Procedure

Executing Stored Procedures

Manipulating the ResultSet and Update Count Returned by Stored Procedure

Collaboration Usability for a Stored Procedure ResultSet

Prepared Statement

Batch Operations

Using DB2 Connect Operations

DB2 Connect Adapter Database Operations (BPEL)

Activity Input and Output

DB2 Connect Adapter Database Operations (JCD)

The Table

Prepared Statement

The Insert Operation

The Update Operation

The Stored Procedure

Executing Stored Procedures

Manipulating the ResultSet and Update Count Returned by Stored Procedure

Collaboration Usability for a Stored Procedure ResultSet

Prepared Statement

Batch Operations

Using JDBC/ODBC Operations

JDBC Adapter Database Operations (BPEL)

Activity Input and Output

JDBC Adapter Database Operations (JCD)

The Table

The Stored Procedure

Executing Stored Procedures

Manipulating the ResultSet and Update Count Returned by Stored Procedure

Collaboration Usability for a Stored Procedure ResultSet

Prepared Statement

Batch Operations

Using Oracle Operations

Oracle Adapter Database Operations (BPEL)

Activity Input and Output

Oracle Adapter Outbound XA Support for BPEL

Oracle Adapter Database Operations (JCD)

The Table

The Stored Procedure

Executing Stored Procedures

Manipulating the ResultSet and Update Count Returned by Stored Procedure

Collaboration Usability for a Stored Procedure ResultSet

Oracle Table Data Types

Long RAW for Prepared Statements and Stored Procedure Support

Using CLOBs with the Oracle Adapter

Using SQL Server Operations

SQL Server Adapter Database Operations (BPEL)

Activity Input and Output

SQL Server Adapter Database Operations (JCD)

The Table

The Stored Procedure

Executing Stored Procedures

Manipulating the ResultSet and Update Count Returned by Stored Procedure

Prepared Statement

Batch Operations

Result Sets

Using Sybase Operations

Sybase Adapter Database Operations (BPEL)

Activity Input and Output

Sybase Adapter Database Operations (JCD)

The Table

To Perform a Query Operation on a Table

To Perform an Insert Operation on a Table

To Perform an Update Operation on a Table

To Perform a Delete Operation on a Table

The Stored Procedure

Executing Stored Procedures

Manipulating the ResultSet and Update Count Returned by Stored Procedure

Collaboration Usability for a Stored Procedure ResultSet

Prepared Statement

Batch Operations

Using VSAM Operations

VSAM Adapter Database Operations (BPEL)

Activity Input and Output

VSAM Adapter Database Operations (JCD)

The Table

Prepared Statement

Batch Operations

Using Sybase Operations

The database operations used in the Sybase Adapter are used to access the Sybase database. Database operations are either accessed through activities in BPEL, or through methods called from a JCD Collaboration.

Sybase Adapter Database Operations (BPEL)

The Sybase Adapter uses a number of operations to query the Sybase database. Within a BPEL business process, the Sybase Adapter uses BPEL activities to perform basic outbound database operations, including:

In addition to these outbound operations, the Sybase Adapter also employs the inbound activity ReceiveOne within a Prepared Statement OTD.

Activity Input and Output

The Java CAPS Business Rules Designer includes Input and Output columns to map and transform data between activities displayed on the Business Process Canvas. Figure 1-7 displays the business rules between the FileClient.write and otdSybase.Db_employeeDelete activities. In this example, the whereClause attribute appears on the Input side.

Figure 1-7 Input and Output Between Activities

image:InputOutputActivity-Sybase

The following table lists the expected Input and Output of each database operation activity.

Table 1-6 Sybase Operations

BPM Operations
Activity Input
Activity Output
SelectAll
where() clause (optional)
Returns all rows that fit the condition of the where() clause.
SelectMultiple
number of rows

wherels() clause (optional)

Returns the number of rows specified that fit the condition of the where() clause, and the number of rows to be returned.

For example: If the number of rows that meet the condition are 5 and the number of available rows are 10, then only 5 rows will be returned.

Alternately, if the number of rows that meet the condition are 20, but if the number of available rows are 10, then only 10 rows are returned.

SelectOne
where() clause (optional)
Returns the first row that fits the condition of the where() clause.
Insert
definition of new item to be inserted
Returns status.
Update
where() clause
Returns status.
Delete
where() clause
Returns status.