Sun Microsystems eWay JDBC/ODBC Adapter - Manual (Page 104)

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 104 Sun Microsystems, Inc.
3 Configure 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:
1 Configure the business rule between the FileClient.receive and FileCleint.write
Activities, as seen in Figure 54.