All Packages This Package Previous Next
By partitioning new methods into a different namespace, it is possible for a JDBC driver to implement both the JDBC ResultSet interface and this interface, allowing more efficient runtime performance in both the dynamic and static case.
The following tables describe the differences between the methods of the JDBC ResultSet interface and the methods of this interface.
next() | |
close() | |
getBytes(int) | |
getCursorName() | |
getDate(int) | |
getTime(int) | |
getTimestamp(int) | |
getString(int) | |
getWarnings() | |
clearWarnings() | |
findColumn() |
Method Removed | Replacement Method |
---|---|
getMetaData() | |
getBoolean(int)
getBoolean(String) |
getBooleanNoNull(int) |
getByte(int)
getByte(String) |
getByteNoNull(int) |
getShort(int)
getShort(String) |
getShortNoNull(int) |
getInt(int)
getInt(String) |
getIntNoNull(int) |
getLong(int)
getLong(String) |
getLongNoNull(int) |
getFloat(int)
getFloat(String) |
getFloatNoNull(int) |
getDouble(int)
getDouble(String) |
getDoubleNoNull(int) |
getObject(int)
getObject(String) |
getObject(int, Class) |
wasNull(int) | getBooleanWrapper(int)
getByteWrapper(int) getShortWrapper(int) getIntWrapper(int) getLongWrapper(int) getFloatWrapper(int) getDoubleWrapper(int) |
getBigDecimal(int,int)
getBigDecimal(String,int) |
getBigDecimal(int) |
getAsciiStream(int)
getAsciiStream(String) |
getAsciiStreamWrapper(int) |
getBinaryStream(int)
getBinaryStream(String) |
getBinaryStreamWrapper(int) |
getUnicodeStream(int)
getUnicodeStream(String) |
getUnicodeStreamWrapper(int) |
getString(String) | |
getBytes(String) | |
getDate(String) | |
getTime(String) | |
getTimestamp(String) |
getJDBCResultSet() | |
isValidRow() | |
getColumnCount() | |
isClosed() |
Additional notes:
findColumn
method is used to find and
cache the appropriate index before any getXXX calls are made.
public abstract ResultSet getJDBCResultSet() throws SQLException
Notes:
next
method invocation on the iterator. Once the
result set has been produced, all operations to fetch data should be
through the result set.
public abstract boolean next() throws SQLException
If an input stream from the previous row is open, it is implicitly closed.
public abstract String getCursorName() throws SQLException
In SQL, a result table is retrieved through a cursor that is named. The current row of a result can be updated or deleted using a positioned update/delete statement that references the cursor name.
JDBC drivers support this SQL feature by providing the name of the SQL cursor used by a ResultSet. The current row of a ResultSet is also the current row of this SQL cursor. This method is provided for interoperability with JDBC-based implementations.
Note: If positioned update is not supported a SQLException is thrown
Note: This method is called only if the profile entry for the statement which produced this result set has a role with value POSITIONED.
public abstract int findColumn(String columnName) throws SQLException
Note: This method is called iff the profile entry for the statement which produced this result set has a result set type with value NAMED_RESULT.
public abstract String getString(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=java.lang.String. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract byte[] getBytes(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=[byte. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract Date getDate(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=java.sql.Date. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract Time getTime(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=java.sql.Time. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract Timestamp getTimestamp(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=java.sql.Timestamp. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract Boolean getBooleanWrapper(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=java.lang.Boolean. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract Byte getByteWrapper(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=java.lang.Byte. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract Short getShortWrapper(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=java.lang.Short. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract Integer getIntWrapper(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=java.lang.Integer. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract Long getLongWrapper(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=java.lang.Long. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract Float getFloatWrapper(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=java.lang.Float. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract Double getDoubleWrapper(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=java.lang.Double. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract boolean getBooleanNoNull(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=boolean. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract byte getByteNoNull(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=byte. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract short getShortNoNull(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=short. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract int getIntNoNull(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=int. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract long getLongNoNull(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=long. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract float getFloatNoNull(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=float. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract double getDoubleNoNull(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=double. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract AsciiStream getAsciiStreamWrapper(int columnIndex) throws SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not.
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=sqlj.runtime.AsciiStream. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract UnicodeStream getUnicodeStreamWrapper(int columnIndex) throws SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not.
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=sqlj.runtime.UnicodeStream. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract BinaryStream getBinaryStreamWrapper(int columnIndex) throws SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not.
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=sqlj.runtime.BinaryStream. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract Object getObject(int columnIndex, Class objectType) throws SQLException
The static type of the java lvalue into which this parameter value is assigned is passed as "objectType". An exception is raised if the object returned is not assignable to an object with class "objectType".
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has SQLType=OTHER. In such cases, the javaTypeName indicates the expected Java Class of the object; the class cannot be handled by any other getXXX method defined by this statement. Accordingly, this method is used as the catch-all for any unrecognized types. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract BigDecimal getBigDecimal(int columnIndex) throws SQLException
Note: This method is used iff the result type info object for the current column in the profile entry for the statement which produced this result set has javaTypeName=java.math.BigDecimal. Note that if the entry's resultSetType is POSITIONED_RESULT, then the columnIndex can be used directly to find the result type info object. Otherwise, is the entry's resultSetType is NAMED_RESULT, the name of the current column must be used to find the result type info object with the same name.
public abstract int getColumnCount() throws SQLException
Note: This method can be implemented in JDBC using the
getColumnCount
method of a ResultSet's MetaData object.
public abstract boolean isValidRow() throws SQLException
public abstract boolean isClosed() throws SQLException
public abstract SQLWarning getWarnings() throws SQLException
The warning chain is automatically cleared each time a new role is read.
Note: This warning cheain only covers warnings caused by result set methods. Any warning caused by statement execution (such as fetching OUT parameters) will be chained on the statement object, and made available to the client on the ExecutionContext object.
public abstract void clearWarnings() throws SQLException
public abstract void close() throws SQLException
Note: A ResultSet is automatically closed by the Statement that generated it when that Statement is used to retrieve the next result from a sequence of multiple results. The generating statement can only release its underlying resources when its result set has been closed. A ResultSet is also automatically closed when it is garbage collected.
All Packages This Package Previous Next