Sun Microsystems JDBC/ODBC Adapter

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