Sun-microsystems eWay JDBC/ODBC Adapter Manual de usuario descargar pdf (Pagina 66)

Chapter 5 Section 5.2

Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD)

JDBC/ODBC eWay Adapter User’s Guide 66 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

1 2 ... 61 62 63 64 65 66 67 68 69 70 71 ... 132 133

Comentarios a estos manuales

Sin comentarios

Sun-microsystems eWay JDBC/ODBC Adapter Manual de usuario Pagina 66

Comentarios a estos manuales

Relacionado con productos y manuales para Hardware Sun-microsystems eWay JDBC/ODBC Adapter