Contents
JDBC/ODBC eWay Adapter User’s Guide
5
Sun Microsystems, Inc.
The Table
60
The Query (Select) Operation
60
The Insert Operation
61
The Update Operation
62
The Delete Operation
63
The Stored Procedure
63
Executing Stored Procedures
64
Manipulating the ResultSet and Update Count Returned by Stored Procedure
65
Prepared Statement
67
Batch Operations
67
Chapter 6
Implementing the JDBC/ODBC eWay Sample Projects
69
About the JDBC eWay Sample Projects
69
Sample Project Data
71
Operations Used in the JDBC Sample Projects
71
Assigning Operations in JCD
71
Assigning Operations in BPEL
71
About the eInsight Engine and eGate Components
72
Sample Projects Drivers
72
Running the Sample Projects
72
Running the SQL Script
73
Importing a Sample Project
73
Building and Deploying the prjJDBC_JCD Sample Project
74
Creating a Project
75
Creating the OTDs
75
Creating a Connectivity Map
76
Populating the Connectivity Map
77
Creating the Collaboration Definitions (Java)
78
jcdDelete Collaboration
78
jcdInsert Collaboration
79
jcdPsSelect Collaboration
79
jcdTableSelect Collaboration
80
jcdPsUpdate Collaboration
80
Create the Collaboration Business Rules
81
Creating the jcdDelete Business Rules
81
Creating the jcdInsert Business Rules
81
Creating the jcdPsSelect Business Rules
83
Creating the jcdTableSelect Business Rules
85
Creating the jcdUpdate Business Rules
87
Binding the eWay Components
87
Creating an Environment
88
Configuring the eWays
89
Configuring the eWay Properties
90
Configuring the Environment Explorer Properties
91
Configuring the Integration Server
92
Creating the Deployment Profile
92
Creating and Starting the Domain
93
