Sun Microsystems JDBC/ODBC Adapter Jdbc eWay Database Operations Bpel, Activity Input and Output

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.1JDBC 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.1Activity 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.

JDBC/ODBC eWay Adapter User’s Guide 57 Sun Microsytems, Inc.