Chapter 6

Section 6.6

Implementing the JDBC/ODBC eWay Sample Projects

Building and Deploying the prjJDBC_BPEL Sample Project

3Configure the business rule between the otdJDBC.DB_EMPLOYEEDelete Activity and the FileClient.write Activity, as seen in Figure 52.

Figure 52 bpelDelete Business Rule # 3

Configuring the bpelTableSelect Modeling Elements

The bpelTableSelect business process is describes how to select all records 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 SelectAll operation. See Figure 53 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 TriggerTableSelect.in file is empty.

Note: Review the eInsight Business Process Manager User’s Guide for a more detailed description of the steps required to connect and add business rules to a modeling elements in a business process.

Figure 53 bpelTableSelect Business Process

Steps required to configure the bpelTableSelect business process:

1Configure the business rule between the FileClient.receive and FileCleint.write Activities, as seen in Figure 54.

JDBC/ODBC eWay Adapter User’s Guide

104

Sun Microsystems, Inc.

Page 104
Image 104
Sun Microsystems JDBC/ODBC Adapter Configuring the bpelTableSelect Modeling Elements, BpelTableSelect Business Process