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

Chapter 6 Section 6.5
Implementing the JDBC/ODBC eWay Sample Projects Building and Deploying the prjJDBC_JCD Sample Project
JDBC/ODBC eWay Adapter User’s Guide 81 Sun Microsystems, Inc.
4 For 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.
5 Click 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.
6 Click Finish. The Collaboration Editor with the new jcdPsUpdate Collaboration
appears in the right pane of the Enterprise Designer.
6.5.5
Create 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.