Sun Microsystems eWay JDBC/ODBC Adapter - Manual (Page 59)

Chapter 5 Section 5.2
Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD)
JDBC/ODBC eWay Adapter User’s Guide 59 Sun Microsytems, Inc.
5.2
JDBC eWay Database Operations (JCD)
The same database operations are also used in the JCD, but appear as methods to call
from the Collaboration.
Tables, Views, and Stored Procedures are manipulated through OTDs. Methods to call
include:
ƒ insert()
ƒ insertRow()
ƒ update(String sWhere )
ƒ updateRow()
ƒ delete(String sWhere )
ƒ deleteRow()
ƒ select(String where )
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
SelectMultiple number of rows
where() clause (optional) Returns the number of rows
specified that fit the condition
of the where() clause, and the
number of rows to be
returned.
For example: If the number of
rows that meet the condition
are 5 and the number of
available rows are 10, then
only 5 rows will be returned.
Alternately, if the number of
rows that meet the condition
are 20, but if the number of
available rows are 10, then
only 10 rows are returned.
SelectOne where() clause (optional) Returns the first row that fits
the condition of the where()
clause.
Insert definition of new item to be inserted Returns status.
Update where() clause Returns status.
Delete where() clause Returns status.
Table 13 JDBC.ODBC Operations (Continued)
eInsight Operations Activity Input Activity Output