JDBC/ODBC Adapter User's Guide

JDBC/ODBC eWay Adapter User’s Guide 57 Sun Microsytems, Inc.
Chapter 5
Using JDBC/ODBC Operations
Database operations in the JDBC eWay are used to access the JDBC database. Database
operations are either accessed through Activities in BPEL, or through methods called
from a JCD Collaboration.
What’s in This Chapter
 JDBC eWay Database Operations (BPEL) on page 57
 JDBC eWay Database Operations (JCD) on page 59
5.1 JDBC eWay Database Operations (BPEL)
Within a BPEL business process, the JDBC eWay uses BPEL Activities to perform basic
outbound database operations, including:
 Insert
 Update
 Delete
 SelectOne
 SelectMultiple
 SelectAll
In addition to these outbound operations, the JDBC eWay also employs the inbound
Activity ReceiveOne within a Prepared Statement OTD.
The ability to perform any of the above methods using a table OTD may not be possible
with all third-party drivers. You have to use a Prepared Statement to perform such an
operation. Check with the respective driver’s vendor for further information. This
feature is known as Updatable ResultSet.
5.1.1 Activity Input and Output
The Sun SeeBeyond Enterprise Designer – Business Rules Designer includes Input and
Output columns to map and transform data between Activities displayed on the
Business Process Canvas.