beautypg.com

Sun Microsystems eWay JDBC/ODBC Adapter User Manual

Page 70

background image

Chapter 6

Section 6.1

Implementing the JDBC/ODBC eWay Sample Projects

About the JDBC eWay Sample Projects

JDBC/ODBC eWay Adapter User’s Guide

70

Sun Microsystems, Inc.

Figure 29 Database project flow

Both the prjJDBC_JCD and prjJDBC_BPEL sample Projects demonstrate how to:

ƒ

Select employee records from a database using a prepared statement.

ƒ

Select employee records from the db_employee table.

ƒ

Insert employee records into the db_employee table.

ƒ

Update an employee record in the db_employee table.

ƒ

Delete an employee record from the db_employee table.

In addition to the sample Projects, the JDBC510_SAMPLE_projects.zip file also
includes seven sample input trigger files and nine sample output files, as follows:

Sample input files

ƒ

TriggerInsert.in.~in (for JCE projects only)

ƒ

TriggerBpPsInsert.in.~in (for BPEL projects only)

ƒ

TriggerDelete.in.~in

ƒ

TriggerPsUpdate.in.~in (for JCE projects only)

ƒ

TriggerBpUpdate.in.~in (for BPEL projects only)

ƒ

TriggerPsSelect.in.~in (for JCE projects only)

ƒ

TriggerTableSelect.in.~in

Sample output JCD files

ƒ

JCE_Insert_output().dat

ƒ

JCE_Delete_output().dat

ƒ

JCE_PsUpdate_output().dat

ƒ

JCE_PsSelect_output().dat

ƒ

JCE_TableSelect_output().dat

Sample output BPEL files

ƒ

BPEL_PsInsert_output().dat

ƒ

BPEL_Delete_output().dat

ƒ

BPEL_Update_output().dat