JDBC/ODBC Adapter User's Guide

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 71 Sun Microsystems, Inc.
 BPEL_TableSelect_output().dat
6.1.1 Sample Project Data
Data used for the sample Projects are contained within a table called db_employee. The
table has the following columns:
6.1.2 Operations Used in the JDBC Sample Projects
The following database operations are used in both the JCD and BPEL sample projects:
 Insert
 Update
 Delete
 Select
Assigning Operations in JCD
Database operations are listed as methods in the JCD. Perform the following steps to
access these methods:
1 Create a Collaboration that contains an OTD using JDBC.
2 Right-click the OTD listed in your Collaboration and then select Select Method to
Call from the shortcut menu.
3 Browse to and select a method to call.
Assigning Operations in BPEL
You can associate an eInsight Business Process Activity with the eWay, both during the
system design phase and during runtime. To make this association:
1 Select the desired receive or write operation under the eWay in the Enterprise
Explorer.
2 Drag the operation onto the eInsight Business Process canvas.
The operation automatically changes to an Activity with an icon identifying the
component that is the basis for the Activity.
Table 14 Sample Project Data - db_employee Table
Column Name Data Type Data Length
emp_no INTEGER 10
last_name VARCHAR 30
first_name VARCHAR 30
rate FLOAT 15
last_update TIMESTAMP 19