Entering content frame

Function documentation sqlj.runtime.ResultSetIterator Locate the document in its SAP Library structure

sqlj.runtime.ResultSetIterator extends ResultSetIterator

Interface implemented by all result set iterators declared by SQLJ. The interface itself may be used as a fetch target in an untyped SELECT.

Constants

public static final int ASENSITIVE

Constant indicating that the sensitivity of a result set iterator is unknown. Result set iterators in Open SQL / SQLJ are always ASENSITIVE.

public static final int INSENSITIVE

Constant indicating that the result set iterator does not reflect changes made by others. Scrollable result set iterators are not supported in Open SQL / SQLJ.

public static final int SENSITIVE

Constant indicating that the result set iterator does not reflect changes made by others. Scrollable result set iterators are not supported in Open SQL / SQLJ.

public static final int FETCH_FORWARD

Constant indicating that the result set iterator is read in forward direction. In Open SQL / SQLJ, result set iterators are always read in forward direction.

public static final int FETCH_REVERSE

Constant indicating that the result set iterator is read in reverse direction. Open SQL / SQLJ does not support scrollable result sets.

public static final int FETCH_UNKNOWN

Constant indicating that the fetch direction of a result set is unknown. In Open SQL / SQLJ, result set iterators are always read in forward direction.

Methods

public void clearWarnings () throws SQLException

After this call, getWarnings() returns null until a new warning is reported for this iterator.

public void close () throws SQLException

Closes the iterator object, releasing any underlying resources. It is recommended that iterators be explicitly closed as soon as they are no longer needed, to allow the immediate release of resources that are no longer needed.

synchronized public int getFetchSize () throws SQLException

Retrieves the number of rows that is the current fetch size for this iterator object. If this iterator object has not set a fetch size by calling the setFetchSize() method, then the value 0 is returned.

public ResultSet getResultSet () throws SQLException

Returns the JDBC ResultSet object associated with this iterator. The produced JDBC ResultSet object must have normal JDBC functionality, as defined in the JDBC specification (in particular, SQL NULL values fetched with JDBC column access methods will not raise an SQLNullException). This method is provided to facilitate interoperability with JDBC.

Once the JDBC ResultSet object has been produced, all operations to fetch data should be done through the JDBC ResultSet object.

synchronized public int getRow () throws SQLException

Retrieves the current row number. The first row is number 1, the second is number 2, and so on. If there is no current row the method returns 0.

synchronized public int getSensitivity () throws SQLException

This method always returns ASENSITIVE. Open SQL / SQLJ does not support scrollable result sets.

public SQLWarning getWarnings () throws SQLException

The first warning reported by calls on this iterator is returned. Subsequent iterator warnings will be chained to this SQLWarning. The warning chain is automatically cleared each time the iterator object is advanced to the next row. This warning chain only covers warnings caused by iterator methods. Any warning caused by statement execution (such as fetching OUT parameters) will be chained on the ExecutionContext object. If there are no warnings nullis returned.

public boolean isClosed () throws SQLException

Returns true, if the result set has been closed; false, otherwise. If this method has returned true, the behaviour of any other method of the result set iterator is undefined.

public boolean next () throws SQLException

Advances the iterator to the next row. At the beginning, the iterator is positioned before the first row. A FETCH … INTO statement performs an implicit invocation of next() on the iterator passed. If there was a next row in the iterator, then true is returned; false, otherwise.

synchronized public void setFetchSize (int rows) throws SQLException

Gives the SQLJ runtime a hint as to the number of rows that should be fetched when more rows are needed from this iterator object. If the value specified is zero, then the Open SQL runtime will automatically choose a suitable fetch size.

 

Leaving content frame