Sun Microsystems eWay JDBC/ODBC Adapter User Manual

Page 66

Chapter 5

Section 5.2

Using JDBC/ODBC Operations

JDBC eWay Database Operations (JCD)

JDBC/ODBC eWay Adapter User’s Guide

Sun Microsytems, Inc.

Collaboration usability for a stored procedure ResultSet

The Column data of the ResultSets can be dragged-and-dropped from their nodes to
the Business Rules. Below is a code snippet that can be generated by the Collaboration
Editor:

while (getSPIn().getSpS_multi().resultsAvailable())
{
if (getSPIn().getSpS_multi().getUpdateCount() > 0)
{
System.err.println("Updated
"+getSPIn().getSpS_multi().getUpdateCount()+" rows");
}

if (getSPIn().getSpS_multi().getNormRS().available())
{
while (getSPIn().getSpS_multi().getNormRS().next())
{
System.err.println("Customer Id =
"+getSPIn().getSpS_multi().getNormRS().getCustomerId());
System.err.println("Customer Name =
"+getSPIn().getSpS_multi().getNormRS().getCustomerName());
System.err.println();
}
System.err.println("===");
}
else if (getSPIn().getSpS_multi().getDbEmployee().available())
{
while (getSPIn().getSpS_multi().getDbEmployee().next())
{
System.err.println("EMPNO =
"+getSPIn().getSpS_multi().getDbEmployee().getEMPNO());
System.err.println("ENAME =
"+getSPIn().getSpS_multi().getDbEmployee().getENAME());
System.err.println("JOB =
"+getSPIn().getSpS_multi().getDbEmployee().getJOB());
System.err.println("MGR =
"+getSPIn().getSpS_multi().getDbEmployee().getMGR());
System.err.println("HIREDATE =
"+getSPIn().getSpS_multi().getDbEmployee().getHIREDATE());
System.err.println("SAL =
"+getSPIn().getSpS_multi().getDbEmployee().getSAL());
System.err.println("COMM =
"+getSPIn().getSpS_multi().getDbEmployee().getCOMM());
System.err.println("DEPTNO =
"+getSPIn().getSpS_multi().getDbEmployee().getDEPTNO());
System.err.println();
}
System.err.println("===");
}
}

Note: resultsAvailable()

and available() cannot be indiscriminately called because each

time they move ResultSet pointers to the appropriate locations.

After calling "resultsAvailable()", the next result (if available) can be either a ResultSet
or an UpdateCount if the default "enableResultSetsAndUpdateCount()" was used.

Because of limitations imposed by some DBMSs, it is recommended that for maximum
portability, all of the results in a ResultSet object should be retrieved before OUT