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.
