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:

Insert
Update
Delete
SelectOne
SelectMultiple
SelectAll

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

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.

Skip Navigation Links
Exit Print View
	Using Database Operations with Oracle Java CAPS Database Adapters Java CAPS Documentation