Sun Microsystems JDBC/ODBC Adapter manual Jdbc eWay Database Operations JCD

Chapter 5	Section 5.2
Using JDBC/ODBC Operations	JDBC eWay Database Operations (JCD)

Table 13 JDBC.ODBC Operations (Continued)

eInsight Operations	Activity Input	Activity Output
SelectMultiple	number of rows	Returns the number of rows
	where() clause (optional)	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.

5.2JDBC 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

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