Sun Microsystems JDBC/ODBC Adapter manual JDBC.ODBC Operations

Models: JDBC/ODBC Adapter

1 133
Download 133 pages 48.36 Kb
Page 58
Image 58

Chapter 5

Section 5.1

Using JDBC/ODBC Operations

JDBC eWay Database Operations (BPEL)

Figure 28 displays the business rules between the FileClient.write and otdJDBC.Db_employeeDelete Activities. In this example, the whereClause appears on the Input side.

Figure 28 Input and Output Between Activities

The following table lists the expected Input and Output of each database operation Activity.

Table 13 JDBC.ODBC Operations

eInsight Operations

Activity Input

Activity Output

 

 

 

SelectAll

where() clause (optional)

Returns all rows that fit the

 

 

condition of the where()

 

 

clause.

 

 

 

JDBC/ODBC eWay Adapter User’s Guide

58

Sun Microsytems, Inc.

Page 58
Image 58
Sun Microsystems JDBC/ODBC Adapter manual JDBC.ODBC Operations, EInsight Operations Activity Input Activity Output