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.1About 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.
JDBC/ODBC eWay Adapter User’s Guide | 69 | Sun Microsystems, Inc. |
