JDBC/ODBC Adapter User's Guide

JDBC/ODBC eWay Adapter User’s Guide 69 Sun Microsystems, Inc.
Chapter 6
Implementing the JDBC/ODBC eWay
Sample Projects
This chapter provides an introduction to the JDBC eWay components, and information
on how these components are created and implemented in a Sun Java Composite
Application Platform Suite Project. Sample Projects are designed to provide an
overview of the basic functionality of the JDBC eWay by identifying how information is
passed between eGate and supported external databases.
It is assumed that you understand the basics of creating a Project using the Enterprise
Designer. For more information on creating an eGate Project, see the eGate Tutorial and
the eGate Integrator User’s Guide.
What’s in This Chapter
 About the JDBC eWay Sample Projects on page 69
 Running the Sample Projects on page 72
 Running the SQL Script on page 73
 Importing a Sample Project on page 73
 Building and Deploying the prjJDBC_JCD Sample Project on page 74
 Building and Deploying the prjJDBC_BPEL Sample Project on page 95
6.1 About the JDBC eWay Sample Projects
The JDBC eWay JDBC_eWay_Sample.zip file contains two sample Projects that
provide basic instruction on using JDBC operations in the Java Collaboration Definition
(JCD), or the Business Process Excecution Language (BPEL) Projects.
The prjJDBC_JCD sample Project uses input files to pass data into Collaborations.
There are four Collaborations that demonstrate the Insert, Update, and Table Select
operations, and two Collaboration to demonstrate Prepared Statements (Select and
Update). Results are written out to an output file.
The prjJDBC_BPEL sample Project uses input files to pass data into business process.
There are four business processes that demonstrate the Insert, Update, Delete, and
Select operations. Results are written out to an output file.