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.
