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
