Sun Microsystems JDBC/ODBC Adapter Stored Procedure, Creating the Collaboration Definitions Java

Contents

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

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