Sun Microsystems JDBC/ODBC Adapter manual Create the Collaboration Business Rules

Chapter 6	Section 6.5
Implementing the JDBC/ODBC eWay Sample Projects	Building and Deploying the prjJDBC_JCD Sample Project

4For Step 3 of the wizard, from the Select OTDs selection window, double-click prjJDBC_JCD > otdALL > otdJDBC. The otdJDBC OTD is added to the Selected OTDs field.

5Click the Up One Level button twice to return to the Repository. Double-click Sun SeeBeyond > eWays > File > FileClient. The Selected OTDs field now lists the FileClient OTD.

6Click Finish. The Collaboration Editor with the new jcdPsUpdate Collaboration appears in the right pane of the Enterprise Designer.

6.5.5Create the Collaboration Business Rules

The next step in the sample is to create the Business Rules of the Collaboration using the Collaboration Editor.

Creating the jcdDelete Business Rules

The jcdDelete Collaboration implements the Input Web Service Operation to read the TriggerDelete.in file and then delete a record. The Collaboration also writes a message to JCD_Delete_output0.dat to confirm a deleted record.

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 deleted from the database when the TriggerDelete.in file is empty.

The jcdDelete Collaboration contains the Business Rules displayed in Figure 31.

Figure 31 jcdDelete Business Rules

Creating the jcdInsert Business Rules

The jcdInsert Collaboration implements the Input Web Service Operation to read the TriggerInsert.in. file. It then unmarshals data from the input data into the otdInputDTD_DBEmployees OTD, calls the otdJDBC OTD, and inserts records into the database via a For Loop. The Collaboration also writes a message to JCD_Insert_output0.dat to confirm an inserted record.

The jcdInsert Collaboration contains the Business Rules displayed in Figure 32.

JDBC/ODBC eWay Adapter User’s Guide 81 Sun Microsystems, Inc.