Sun Microsystems JDBC/ODBC Adapter manual Sample Project Data, Assigning Operations in JCD

Chapter 6	Section 6.1
Implementing the JDBC/ODBC eWay Sample Projects	About the JDBC eWay Sample Projects

ƒBPEL_TableSelect_output().dat

6.1.1Sample Project Data

Data used for the sample Projects are contained within a table called db_employee. The table has the following columns:

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

6.1.2Operations 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:

1Create a Collaboration that contains an OTD using JDBC.

2Right-click the OTD listed in your Collaboration and then select Select Method to Call from the shortcut menu.

3Browse 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:

1Select the desired receive or write operation under the eWay in the Enterprise Explorer.

2Drag 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.

JDBC/ODBC eWay Adapter User’s Guide 71 Sun Microsystems, Inc.