beautypg.com

Configuring the bpeldelete modeling elements – Sun Microsystems eWay JDBC/ODBC Adapter User Manual

Page 102

background image

Chapter 6

Section 6.6

Implementing the JDBC/ODBC eWay Sample Projects

Building and Deploying the prjJDBC_BPEL Sample Project

JDBC/ODBC eWay Adapter User’s Guide

102

Sun Microsystems, Inc.

Figure 47 bpelUpdate Business Rule # 2

3

Configure the business rule between otdJDBC.DB_EMPLOYEEUpdate and the
FileClient.write

Activity, as seen in Figure 48.

Figure 48 bpelUpdate Business Rule # 3

Configuring the bpelDelete Modeling Elements

The bpelDelete business process describes how to delete a record in the JDBC database
using the Business Process Designer.

Once you have connected the modeling elements together, begin adding the business
processes necessary to facilitate the Delete operation. See Figure 49 for an illustration of
how all the modeling elements appear when connected.

Note:

The where clause in the business rule reads the trigger value as a placeholder for
input. This permits you to modify the query to select a specific record. Also note that
all records are selected from the database when the TriggerDelete.in file is empty.