
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. |