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

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