JdbcResultSet (JBoss Application Server: Build 7.1.2.Final API)

java.lang.Object
- org.h2.message.TraceObject
- - org.h2.jdbc.JdbcResultSet

All Implemented Interfaces:

AutoCloseable, ResultSet, Wrapper
```
public class JdbcResultSet
extends TraceObject
implements ResultSet
```
Represents a result set.

Column labels are case-insensitive, quotes are not supported. The first column has the column index 1.

Updatable result sets: Result sets are updatable when the result only contains columns from one table, and if it contains all columns of a unique index (primary key or other) of this table. Key columns may not contain NULL (because multiple rows with NULL could exist). In updatable result sets, own changes are visible, but not own inserts and deletes.

Field Summary
- Fields inherited from class org.h2.message.TraceObject
  ARRAY, BLOB, CALLABLE_STATEMENT, CLOB, CONNECTION, DATA_SOURCE, DATABASE_META_DATA, PARAMETER_META_DATA, PREPARED_STATEMENT, RESULT_SET, RESULT_SET_META_DATA, SAVEPOINT, SQL_EXCEPTION, STATEMENT, trace, XA_DATA_SOURCE, XA_RESOURCE, XID
- Fields inherited from interface java.sql.ResultSet
  CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Method Summary

Methods
Modifier and Type	Method and Description
`boolean`	`absolute(int rowNumber)` Moves the current position to a specific row.
`void`	`afterLast()` Moves the current position to after the last row, that means after the end.
`void`	`beforeFirst()` Moves the current position to before the first row, that means resets the result set.
`void`	`cancelRowUpdates()` Cancels updating a row.
`void`	`clearWarnings()` Clears all warnings.
`void`	`close()` Closes the result set.
`void`	`deleteRow()` Deletes the current row.
`int`	`findColumn(String columnLabel)` Searches for a specific column in the result set.
`boolean`	`first()` Moves the current position to the first row.
`Array`	`getArray(int columnIndex)` Returns the value of the specified column as an Array.
`Array`	`getArray(String columnLabel)` Returns the value of the specified column as an Array.
`InputStream`	`getAsciiStream(int columnIndex)` Returns the value of the specified column as an input stream.
`InputStream`	`getAsciiStream(String columnLabel)` Returns the value of the specified column as an input stream.
`BigDecimal`	`getBigDecimal(int columnIndex)` Returns the value of the specified column as a BigDecimal.
`BigDecimal`	`getBigDecimal(int columnIndex, int scale)` Deprecated. use `getBigDecimal(int)`
`BigDecimal`	`getBigDecimal(String columnLabel)` Returns the value of the specified column as a BigDecimal.
`BigDecimal`	`getBigDecimal(String columnLabel, int scale)` Deprecated. use `getBigDecimal(String)`
`InputStream`	`getBinaryStream(int columnIndex)` Returns the value of the specified column as an input stream.
`InputStream`	`getBinaryStream(String columnLabel)` Returns the value of the specified column as an input stream.
`Blob`	`getBlob(int columnIndex)` Returns the value of the specified column as a Blob.
`Blob`	`getBlob(String columnLabel)` Returns the value of the specified column as a Blob.
`boolean`	`getBoolean(int columnIndex)` Returns the value of the specified column as a boolean.
`boolean`	`getBoolean(String columnLabel)` Returns the value of the specified column as a boolean.
`byte`	`getByte(int columnIndex)` Returns the value of the specified column as a byte.
`byte`	`getByte(String columnLabel)` Returns the value of the specified column as a byte.
`byte[]`	`getBytes(int columnIndex)` Returns the value of the specified column as a byte array.
`byte[]`	`getBytes(String columnLabel)` Returns the value of the specified column as a byte array.
`Reader`	`getCharacterStream(int columnIndex)` Returns the value of the specified column as a reader.
`Reader`	`getCharacterStream(String columnLabel)` Returns the value of the specified column as a reader.
`Clob`	`getClob(int columnIndex)` Returns the value of the specified column as a Clob.
`Clob`	`getClob(String columnLabel)` Returns the value of the specified column as a Clob.
`int`	`getConcurrency()` Gets the result set concurrency.
`String`	`getCursorName()` [Not supported] Gets the cursor name if it was defined.
`Date`	`getDate(int columnIndex)` Returns the value of the specified column as a java.sql.Date.
`Date`	`getDate(int columnIndex, Calendar calendar)` Returns the value of the specified column as a java.sql.Date using a specified time zone.
`Date`	`getDate(String columnLabel)` Returns the value of the specified column as a java.sql.Date.
`Date`	`getDate(String columnLabel, Calendar calendar)` Returns the value of the specified column as a java.sql.Date using a specified time zone.
`double`	`getDouble(int columnIndex)` Returns the value of the specified column as a double.
`double`	`getDouble(String columnLabel)` Returns the value of the specified column as a double.
`int`	`getFetchDirection()` Gets the fetch direction.
`int`	`getFetchSize()` Gets the number of rows suggested to read in one step.
`float`	`getFloat(int columnIndex)` Returns the value of the specified column as a float.
`float`	`getFloat(String columnLabel)` Returns the value of the specified column as a float.
`int`	`getHoldability()` Returns the current result set holdability.
`int`	`getInt(int columnIndex)` Returns the value of the specified column as an int.
`int`	`getInt(String columnLabel)` Returns the value of the specified column as an int.
`long`	`getLong(int columnIndex)` Returns the value of the specified column as a long.
`long`	`getLong(String columnLabel)` Returns the value of the specified column as a long.
`ResultSetMetaData`	`getMetaData()` Gets the meta data of this result set.
`Object`	`getObject(int columnIndex)` Returns a column value as a Java object.
`Object`	`getObject(int columnIndex, Map<String,Class<?>> map)` [Not supported] Gets a column as a object using the specified type mapping.
`Object`	`getObject(String columnLabel)` Returns a column value as a Java object.
`Object`	`getObject(String columnLabel, Map<String,Class<?>> map)` [Not supported] Gets a column as a object using the specified type mapping.
`Ref`	`getRef(int columnIndex)` [Not supported] Gets a column as a reference.
`Ref`	`getRef(String columnLabel)` [Not supported] Gets a column as a reference.
`int`	`getRow()` Gets the current row number.
`short`	`getShort(int columnIndex)` Returns the value of the specified column as a short.
`short`	`getShort(String columnLabel)` Returns the value of the specified column as a short.
`Statement`	`getStatement()` Returns the statement that created this object.
`String`	`getString(int columnIndex)` Returns the value of the specified column as a String.
`String`	`getString(String columnLabel)` Returns the value of the specified column as a String.
`Time`	`getTime(int columnIndex)` Returns the value of the specified column as a java.sql.Time.
`Time`	`getTime(int columnIndex, Calendar calendar)` Returns the value of the specified column as a java.sql.Time using a specified time zone.
`Time`	`getTime(String columnLabel)` Returns the value of the specified column as a java.sql.Time.
`Time`	`getTime(String columnLabel, Calendar calendar)` Returns the value of the specified column as a java.sql.Time using a specified time zone.
`Timestamp`	`getTimestamp(int columnIndex)` Returns the value of the specified column as a java.sql.Timestamp.
`Timestamp`	`getTimestamp(int columnIndex, Calendar calendar)` Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.
`Timestamp`	`getTimestamp(String columnLabel)` Returns the value of the specified column as a java.sql.Timestamp.
`Timestamp`	`getTimestamp(String columnLabel, Calendar calendar)` Returns the value of the specified column as a java.sql.Timestamp.
`int`	`getType()` Get the result set type.
`InputStream`	`getUnicodeStream(int columnIndex)` Deprecated.
`InputStream`	`getUnicodeStream(String columnLabel)` Deprecated.
`URL`	`getURL(int columnIndex)` [Not supported]
`URL`	`getURL(String columnLabel)` [Not supported]
`SQLWarning`	`getWarnings()` Gets the first warning reported by calls on this object.
`void`	`insertRow()` Inserts the current row.
`boolean`	`isAfterLast()` Checks if the current position is after the last row, that means next() was called and returned false, and there was at least one row.
`boolean`	`isBeforeFirst()` Checks if the current position is before the first row, that means next() was not called yet, and there is at least one row.
`boolean`	`isClosed()` Returns whether this result set is closed.
`boolean`	`isFirst()` Checks if the current position is row 1, that means next() was called once and returned true.
`boolean`	`isLast()` Checks if the current position is the last row, that means next() was called and did not yet returned false, but will in the next call.
`boolean`	`last()` Moves the current position to the last row.
`void`	`moveToCurrentRow()` Moves the current position to the current row.
`void`	`moveToInsertRow()` Moves the current position to the insert row.
`boolean`	`next()` Moves the cursor to the next row of the result set.
`boolean`	`previous()` Moves the cursor to the last row, or row before first row if the current position is the first row.
`void`	`refreshRow()` Re-reads the current row from the database.
`boolean`	`relative(int rowCount)` Moves the current position to a specific row relative to the current row.
`boolean`	`rowDeleted()` Detects if the row was deleted (by somebody else or the caller).
`boolean`	`rowInserted()` Detects if the row was inserted.
`boolean`	`rowUpdated()` Detects if the row was updated (by somebody else or the caller).
`void`	`setFetchDirection(int direction)` [Not supported] Sets (changes) the fetch direction for this result set.
`void`	`setFetchSize(int rows)` Sets the number of rows suggested to read in one step.
`String`	`toString()` INTERNAL
`void`	`updateArray(int columnIndex, Array x)` [Not supported]
`void`	`updateArray(String columnLabel, Array x)` [Not supported]
`void`	`updateAsciiStream(int columnIndex, InputStream x)` Updates a column in the current or insert row.
`void`	`updateAsciiStream(int columnIndex, InputStream x, int length)` Updates a column in the current or insert row.
`void`	`updateAsciiStream(int columnIndex, InputStream x, long length)` Updates a column in the current or insert row.
`void`	`updateAsciiStream(String columnLabel, InputStream x)` Updates a column in the current or insert row.
`void`	`updateAsciiStream(String columnLabel, InputStream x, int length)` Updates a column in the current or insert row.
`void`	`updateAsciiStream(String columnLabel, InputStream x, long length)` Updates a column in the current or insert row.
`void`	`updateBigDecimal(int columnIndex, BigDecimal x)` Updates a column in the current or insert row.
`void`	`updateBigDecimal(String columnLabel, BigDecimal x)` Updates a column in the current or insert row.
`void`	`updateBinaryStream(int columnIndex, InputStream x)` Updates a column in the current or insert row.
`void`	`updateBinaryStream(int columnIndex, InputStream x, int length)` Updates a column in the current or insert row.
`void`	`updateBinaryStream(int columnIndex, InputStream x, long length)` Updates a column in the current or insert row.
`void`	`updateBinaryStream(String columnLabel, InputStream x)` Updates a column in the current or insert row.
`void`	`updateBinaryStream(String columnLabel, InputStream x, int length)` Updates a column in the current or insert row.
`void`	`updateBinaryStream(String columnLabel, InputStream x, long length)` Updates a column in the current or insert row.
`void`	`updateBlob(int columnIndex, Blob x)` Updates a column in the current or insert row.
`void`	`updateBlob(int columnIndex, InputStream x)` Updates a column in the current or insert row.
`void`	`updateBlob(int columnIndex, InputStream x, long length)` Updates a column in the current or insert row.
`void`	`updateBlob(String columnLabel, Blob x)` Updates a column in the current or insert row.
`void`	`updateBlob(String columnLabel, InputStream x)` Updates a column in the current or insert row.
`void`	`updateBlob(String columnLabel, InputStream x, long length)` Updates a column in the current or insert row.
`void`	`updateBoolean(int columnIndex, boolean x)` Updates a column in the current or insert row.
`void`	`updateBoolean(String columnLabel, boolean x)` Updates a column in the current or insert row.
`void`	`updateByte(int columnIndex, byte x)` Updates a column in the current or insert row.
`void`	`updateByte(String columnLabel, byte x)` Updates a column in the current or insert row.
`void`	`updateBytes(int columnIndex, byte[] x)` Updates a column in the current or insert row.
`void`	`updateBytes(String columnLabel, byte[] x)` Updates a column in the current or insert row.
`void`	`updateCharacterStream(int columnIndex, Reader x)` Updates a column in the current or insert row.
`void`	`updateCharacterStream(int columnIndex, Reader x, int length)` Updates a column in the current or insert row.
`void`	`updateCharacterStream(int columnIndex, Reader x, long length)` Updates a column in the current or insert row.
`void`	`updateCharacterStream(String columnLabel, Reader x)` Updates a column in the current or insert row.
`void`	`updateCharacterStream(String columnLabel, Reader x, int length)` Updates a column in the current or insert row.
`void`	`updateCharacterStream(String columnLabel, Reader x, long length)` Updates a column in the current or insert row.
`void`	`updateClob(int columnIndex, Clob x)` Updates a column in the current or insert row.
`void`	`updateClob(int columnIndex, Reader x)` Updates a column in the current or insert row.
`void`	`updateClob(int columnIndex, Reader x, long length)` Updates a column in the current or insert row.
`void`	`updateClob(String columnLabel, Clob x)` Updates a column in the current or insert row.
`void`	`updateClob(String columnLabel, Reader x)` Updates a column in the current or insert row.
`void`	`updateClob(String columnLabel, Reader x, long length)` Updates a column in the current or insert row.
`void`	`updateDate(int columnIndex, Date x)` Updates a column in the current or insert row.
`void`	`updateDate(String columnLabel, Date x)` Updates a column in the current or insert row.
`void`	`updateDouble(int columnIndex, double x)` Updates a column in the current or insert row.
`void`	`updateDouble(String columnLabel, double x)` Updates a column in the current or insert row.
`void`	`updateFloat(int columnIndex, float x)` Updates a column in the current or insert row.
`void`	`updateFloat(String columnLabel, float x)` Updates a column in the current or insert row.
`void`	`updateInt(int columnIndex, int x)` Updates a column in the current or insert row.
`void`	`updateInt(String columnLabel, int x)` Updates a column in the current or insert row.
`void`	`updateLong(int columnIndex, long x)` Updates a column in the current or insert row.
`void`	`updateLong(String columnLabel, long x)` Updates a column in the current or insert row.
`void`	`updateNull(int columnIndex)` Updates a column in the current or insert row.
`void`	`updateNull(String columnLabel)` Updates a column in the current or insert row.
`void`	`updateObject(int columnIndex, Object x)` Updates a column in the current or insert row.
`void`	`updateObject(int columnIndex, Object x, int scale)` Updates a column in the current or insert row.
`void`	`updateObject(String columnLabel, Object x)` Updates a column in the current or insert row.
`void`	`updateObject(String columnLabel, Object x, int scale)` Updates a column in the current or insert row.
`void`	`updateRef(int columnIndex, Ref x)` [Not supported]
`void`	`updateRef(String columnLabel, Ref x)` [Not supported]
`void`	`updateRow()` Updates the current row.
`void`	`updateShort(int columnIndex, short x)` Updates a column in the current or insert row.
`void`	`updateShort(String columnLabel, short x)` Updates a column in the current or insert row.
`void`	`updateString(int columnIndex, String x)` Updates a column in the current or insert row.
`void`	`updateString(String columnLabel, String x)` Updates a column in the current or insert row.
`void`	`updateTime(int columnIndex, Time x)` Updates a column in the current or insert row.
`void`	`updateTime(String columnLabel, Time x)` Updates a column in the current or insert row.
`void`	`updateTimestamp(int columnIndex, Timestamp x)` Updates a column in the current or insert row.
`void`	`updateTimestamp(String columnLabel, Timestamp x)` Updates a column in the current or insert row.
`boolean`	`wasNull()` Returns whether the last column accessed was null.

Methods inherited from class org.h2.message.TraceObject
debugCode, debugCodeAssign, debugCodeCall, debugCodeCall, debugCodeCall, getNextId, getTrace, getTraceId, getTraceObjectName, isDebugEnabled, isInfoEnabled, logAndConvert, quote, quoteArray, quoteBigDecimal, quoteBytes, quoteDate, quoteIntArray, quoteMap, quoteTime, quoteTimestamp, setTrace, unsupported

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.sql.ResultSet
getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getRowId, getRowId, getSQLXML, getSQLXML, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateRowId, updateRowId, updateSQLXML, updateSQLXML

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

- Method Detail
  - next
```
public boolean next()
             throws SQLException
```
    Moves the cursor to the next row of the result set.
    
    Specified by:
    
    next in interface ResultSet
    
    Returns:
    true if successful, false if there are no more rows
    
    Throws:
    
    SQLException
  - getMetaData
```
public ResultSetMetaData getMetaData()
                              throws SQLException
```
    Gets the meta data of this result set.
    
    Specified by:
    
    getMetaData in interface ResultSet
    
    Returns:
    the meta data
    
    Throws:
    
    SQLException
  - wasNull
```
public boolean wasNull()
                throws SQLException
```
    Returns whether the last column accessed was null.
    
    Specified by:
    
    wasNull in interface ResultSet
    
    Returns:
    true if the last column accessed was null
    
    Throws:
    
    SQLException
  - findColumn
```
public int findColumn(String columnLabel)
               throws SQLException
```
    Searches for a specific column in the result set. A case-insensitive search is made.
    
    Specified by:
    
    findColumn in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the column index (1,2,...)
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - close
```
public void close()
           throws SQLException
```
    Closes the result set.
    
    Specified by:
    
    close in interface AutoCloseable
    
    Specified by:
    
    close in interface ResultSet
    
    Throws:
    
    SQLException
  - getStatement
```
public Statement getStatement()
                       throws SQLException
```
    Returns the statement that created this object.
    
    Specified by:
    
    getStatement in interface ResultSet
    
    Returns:
    the statement or prepared statement, or null if created by a DatabaseMetaData call.
    
    Throws:
    
    SQLException
  - getWarnings
```
public SQLWarning getWarnings()
                       throws SQLException
```
    Gets the first warning reported by calls on this object.
    
    Specified by:
    
    getWarnings in interface ResultSet
    
    Returns:
    null
    
    Throws:
    
    SQLException
  - clearWarnings
```
public void clearWarnings()
                   throws SQLException
```
    Clears all warnings.
    
    Specified by:
    
    clearWarnings in interface ResultSet
    
    Throws:
    
    SQLException
  - getString
```
public String getString(int columnIndex)
                 throws SQLException
```
    Returns the value of the specified column as a String.
    
    Specified by:
    
    getString in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getString
```
public String getString(String columnLabel)
                 throws SQLException
```
    Returns the value of the specified column as a String.
    
    Specified by:
    
    getString in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getInt
```
public int getInt(int columnIndex)
           throws SQLException
```
    Returns the value of the specified column as an int.
    
    Specified by:
    
    getInt in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getInt
```
public int getInt(String columnLabel)
           throws SQLException
```
    Returns the value of the specified column as an int.
    
    Specified by:
    
    getInt in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getBigDecimal
```
public BigDecimal getBigDecimal(int columnIndex)
                         throws SQLException
```
    Returns the value of the specified column as a BigDecimal.
    
    Specified by:
    
    getBigDecimal in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getDate
```
public Date getDate(int columnIndex)
             throws SQLException
```
    Returns the value of the specified column as a java.sql.Date.
    
    Specified by:
    
    getDate in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getTime
```
public Time getTime(int columnIndex)
             throws SQLException
```
    Returns the value of the specified column as a java.sql.Time.
    
    Specified by:
    
    getTime in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getTimestamp
```
public Timestamp getTimestamp(int columnIndex)
                       throws SQLException
```
    Returns the value of the specified column as a java.sql.Timestamp.
    
    Specified by:
    
    getTimestamp in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getBigDecimal
```
public BigDecimal getBigDecimal(String columnLabel)
                         throws SQLException
```
    Returns the value of the specified column as a BigDecimal.
    
    Specified by:
    
    getBigDecimal in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getDate
```
public Date getDate(String columnLabel)
             throws SQLException
```
    Returns the value of the specified column as a java.sql.Date.
    
    Specified by:
    
    getDate in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getTime
```
public Time getTime(String columnLabel)
             throws SQLException
```
    Returns the value of the specified column as a java.sql.Time.
    
    Specified by:
    
    getTime in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getTimestamp
```
public Timestamp getTimestamp(String columnLabel)
                       throws SQLException
```
    Returns the value of the specified column as a java.sql.Timestamp.
    
    Specified by:
    
    getTimestamp in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getObject
```
public Object getObject(int columnIndex)
                 throws SQLException
```
    Returns a column value as a Java object. The data is de-serialized into a Java object (on the client side).
    
    Specified by:
    
    getObject in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value or null
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getObject
```
public Object getObject(String columnLabel)
                 throws SQLException
```
    Returns a column value as a Java object. The data is de-serialized into a Java object (on the client side).
    
    Specified by:
    
    getObject in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value or null
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getBoolean
```
public boolean getBoolean(int columnIndex)
                   throws SQLException
```
    Returns the value of the specified column as a boolean.
    
    Specified by:
    
    getBoolean in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getBoolean
```
public boolean getBoolean(String columnLabel)
                   throws SQLException
```
    Returns the value of the specified column as a boolean.
    
    Specified by:
    
    getBoolean in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getByte
```
public byte getByte(int columnIndex)
             throws SQLException
```
    Returns the value of the specified column as a byte.
    
    Specified by:
    
    getByte in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getByte
```
public byte getByte(String columnLabel)
             throws SQLException
```
    Returns the value of the specified column as a byte.
    
    Specified by:
    
    getByte in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getShort
```
public short getShort(int columnIndex)
               throws SQLException
```
    Returns the value of the specified column as a short.
    
    Specified by:
    
    getShort in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getShort
```
public short getShort(String columnLabel)
               throws SQLException
```
    Returns the value of the specified column as a short.
    
    Specified by:
    
    getShort in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getLong
```
public long getLong(int columnIndex)
             throws SQLException
```
    Returns the value of the specified column as a long.
    
    Specified by:
    
    getLong in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getLong
```
public long getLong(String columnLabel)
             throws SQLException
```
    Returns the value of the specified column as a long.
    
    Specified by:
    
    getLong in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getFloat
```
public float getFloat(int columnIndex)
               throws SQLException
```
    Returns the value of the specified column as a float.
    
    Specified by:
    
    getFloat in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getFloat
```
public float getFloat(String columnLabel)
               throws SQLException
```
    Returns the value of the specified column as a float.
    
    Specified by:
    
    getFloat in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getDouble
```
public double getDouble(int columnIndex)
                 throws SQLException
```
    Returns the value of the specified column as a double.
    
    Specified by:
    
    getDouble in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getDouble
```
public double getDouble(String columnLabel)
                 throws SQLException
```
    Returns the value of the specified column as a double.
    
    Specified by:
    
    getDouble in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getBigDecimal
```
public BigDecimal getBigDecimal(String columnLabel,
                       int scale)
                         throws SQLException
```
    Deprecated. use getBigDecimal(String)
    
    Returns the value of the specified column as a BigDecimal.
    
    Specified by:
    
    getBigDecimal in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    scale - the scale of the returned value
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getBigDecimal
```
public BigDecimal getBigDecimal(int columnIndex,
                       int scale)
                         throws SQLException
```
    Deprecated. use getBigDecimal(int)
    
    Returns the value of the specified column as a BigDecimal.
    
    Specified by:
    
    getBigDecimal in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    scale - the scale of the returned value
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getUnicodeStream
```
public InputStream getUnicodeStream(int columnIndex)
                             throws SQLException
```
    Deprecated.
    
    [Not supported]
    
    Specified by:
    
    getUnicodeStream in interface ResultSet
    
    Throws:
    
    SQLException
  - getUnicodeStream
```
public InputStream getUnicodeStream(String columnLabel)
                             throws SQLException
```
    Deprecated.
    
    [Not supported]
    
    Specified by:
    
    getUnicodeStream in interface ResultSet
    
    Throws:
    
    SQLException
  - getObject
```
public Object getObject(int columnIndex,
               Map<String,Class<?>> map)
                 throws SQLException
```
    [Not supported] Gets a column as a object using the specified type mapping.
    
    Specified by:
    
    getObject in interface ResultSet
    
    Throws:
    
    SQLException
  - getObject
```
public Object getObject(String columnLabel,
               Map<String,Class<?>> map)
                 throws SQLException
```
    [Not supported] Gets a column as a object using the specified type mapping.
    
    Specified by:
    
    getObject in interface ResultSet
    
    Throws:
    
    SQLException
  - getRef
```
public Ref getRef(int columnIndex)
           throws SQLException
```
    [Not supported] Gets a column as a reference.
    
    Specified by:
    
    getRef in interface ResultSet
    
    Throws:
    
    SQLException
  - getRef
```
public Ref getRef(String columnLabel)
           throws SQLException
```
    [Not supported] Gets a column as a reference.
    
    Specified by:
    
    getRef in interface ResultSet
    
    Throws:
    
    SQLException
  - getDate
```
public Date getDate(int columnIndex,
           Calendar calendar)
             throws SQLException
```
    Returns the value of the specified column as a java.sql.Date using a specified time zone.
    
    Specified by:
    
    getDate in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    calendar - the calendar
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getDate
```
public Date getDate(String columnLabel,
           Calendar calendar)
             throws SQLException
```
    Returns the value of the specified column as a java.sql.Date using a specified time zone.
    
    Specified by:
    
    getDate in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    calendar - the calendar
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getTime
```
public Time getTime(int columnIndex,
           Calendar calendar)
             throws SQLException
```
    Returns the value of the specified column as a java.sql.Time using a specified time zone.
    
    Specified by:
    
    getTime in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    calendar - the calendar
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getTime
```
public Time getTime(String columnLabel,
           Calendar calendar)
             throws SQLException
```
    Returns the value of the specified column as a java.sql.Time using a specified time zone.
    
    Specified by:
    
    getTime in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    calendar - the calendar
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getTimestamp
```
public Timestamp getTimestamp(int columnIndex,
                     Calendar calendar)
                       throws SQLException
```
    Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.
    
    Specified by:
    
    getTimestamp in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    calendar - the calendar
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getTimestamp
```
public Timestamp getTimestamp(String columnLabel,
                     Calendar calendar)
                       throws SQLException
```
    Returns the value of the specified column as a java.sql.Timestamp.
    
    Specified by:
    
    getTimestamp in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    calendar - the calendar
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getBlob
```
public Blob getBlob(int columnIndex)
             throws SQLException
```
    Returns the value of the specified column as a Blob.
    
    Specified by:
    
    getBlob in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getBlob
```
public Blob getBlob(String columnLabel)
             throws SQLException
```
    Returns the value of the specified column as a Blob.
    
    Specified by:
    
    getBlob in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getBytes
```
public byte[] getBytes(int columnIndex)
                throws SQLException
```
    Returns the value of the specified column as a byte array.
    
    Specified by:
    
    getBytes in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getBytes
```
public byte[] getBytes(String columnLabel)
                throws SQLException
```
    Returns the value of the specified column as a byte array.
    
    Specified by:
    
    getBytes in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getBinaryStream
```
public InputStream getBinaryStream(int columnIndex)
                            throws SQLException
```
    Returns the value of the specified column as an input stream.
    
    Specified by:
    
    getBinaryStream in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getBinaryStream
```
public InputStream getBinaryStream(String columnLabel)
                            throws SQLException
```
    Returns the value of the specified column as an input stream.
    
    Specified by:
    
    getBinaryStream in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getClob
```
public Clob getClob(int columnIndex)
             throws SQLException
```
    Returns the value of the specified column as a Clob.
    
    Specified by:
    
    getClob in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getClob
```
public Clob getClob(String columnLabel)
             throws SQLException
```
    Returns the value of the specified column as a Clob.
    
    Specified by:
    
    getClob in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getArray
```
public Array getArray(int columnIndex)
               throws SQLException
```
    Returns the value of the specified column as an Array.
    
    Specified by:
    
    getArray in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getArray
```
public Array getArray(String columnLabel)
               throws SQLException
```
    Returns the value of the specified column as an Array.
    
    Specified by:
    
    getArray in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getAsciiStream
```
public InputStream getAsciiStream(int columnIndex)
                           throws SQLException
```
    Returns the value of the specified column as an input stream.
    
    Specified by:
    
    getAsciiStream in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getAsciiStream
```
public InputStream getAsciiStream(String columnLabel)
                           throws SQLException
```
    Returns the value of the specified column as an input stream.
    
    Specified by:
    
    getAsciiStream in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getCharacterStream
```
public Reader getCharacterStream(int columnIndex)
                          throws SQLException
```
    Returns the value of the specified column as a reader.
    
    Specified by:
    
    getCharacterStream in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getCharacterStream
```
public Reader getCharacterStream(String columnLabel)
                          throws SQLException
```
    Returns the value of the specified column as a reader.
    
    Specified by:
    
    getCharacterStream in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Returns:
    the value
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - getURL
```
public URL getURL(int columnIndex)
           throws SQLException
```
    [Not supported]
    
    Specified by:
    
    getURL in interface ResultSet
    
    Throws:
    
    SQLException
  - getURL
```
public URL getURL(String columnLabel)
           throws SQLException
```
    [Not supported]
    
    Specified by:
    
    getURL in interface ResultSet
    
    Throws:
    
    SQLException
  - updateNull
```
public void updateNull(int columnIndex)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateNull in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateNull
```
public void updateNull(String columnLabel)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateNull in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBoolean
```
public void updateBoolean(int columnIndex,
                 boolean x)
                   throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBoolean in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBoolean
```
public void updateBoolean(String columnLabel,
                 boolean x)
                   throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBoolean in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if result set is closed or not updatable
  - updateByte
```
public void updateByte(int columnIndex,
              byte x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateByte in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateByte
```
public void updateByte(String columnLabel,
              byte x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateByte in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBytes
```
public void updateBytes(int columnIndex,
               byte[] x)
                 throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBytes in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBytes
```
public void updateBytes(String columnLabel,
               byte[] x)
                 throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBytes in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateShort
```
public void updateShort(int columnIndex,
               short x)
                 throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateShort in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateShort
```
public void updateShort(String columnLabel,
               short x)
                 throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateShort in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateInt
```
public void updateInt(int columnIndex,
             int x)
               throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateInt in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateInt
```
public void updateInt(String columnLabel,
             int x)
               throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateInt in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateLong
```
public void updateLong(int columnIndex,
              long x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateLong in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateLong
```
public void updateLong(String columnLabel,
              long x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateLong in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateFloat
```
public void updateFloat(int columnIndex,
               float x)
                 throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateFloat in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateFloat
```
public void updateFloat(String columnLabel,
               float x)
                 throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateFloat in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateDouble
```
public void updateDouble(int columnIndex,
                double x)
                  throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateDouble in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateDouble
```
public void updateDouble(String columnLabel,
                double x)
                  throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateDouble in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBigDecimal
```
public void updateBigDecimal(int columnIndex,
                    BigDecimal x)
                      throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBigDecimal in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBigDecimal
```
public void updateBigDecimal(String columnLabel,
                    BigDecimal x)
                      throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBigDecimal in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateString
```
public void updateString(int columnIndex,
                String x)
                  throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateString in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateString
```
public void updateString(String columnLabel,
                String x)
                  throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateString in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateDate
```
public void updateDate(int columnIndex,
              Date x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateDate in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateDate
```
public void updateDate(String columnLabel,
              Date x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateDate in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateTime
```
public void updateTime(int columnIndex,
              Time x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateTime in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateTime
```
public void updateTime(String columnLabel,
              Time x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateTime in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateTimestamp
```
public void updateTimestamp(int columnIndex,
                   Timestamp x)
                     throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateTimestamp in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateTimestamp
```
public void updateTimestamp(String columnLabel,
                   Timestamp x)
                     throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateTimestamp in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateAsciiStream
```
public void updateAsciiStream(int columnIndex,
                     InputStream x,
                     int length)
                       throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateAsciiStream in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    length - the number of characters
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateAsciiStream
```
public void updateAsciiStream(int columnIndex,
                     InputStream x)
                       throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateAsciiStream in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateAsciiStream
```
public void updateAsciiStream(int columnIndex,
                     InputStream x,
                     long length)
                       throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateAsciiStream in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    length - the number of characters
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateAsciiStream
```
public void updateAsciiStream(String columnLabel,
                     InputStream x,
                     int length)
                       throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateAsciiStream in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    length - the number of characters
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateAsciiStream
```
public void updateAsciiStream(String columnLabel,
                     InputStream x)
                       throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateAsciiStream in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed
  - updateAsciiStream
```
public void updateAsciiStream(String columnLabel,
                     InputStream x,
                     long length)
                       throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateAsciiStream in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    length - the number of characters
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBinaryStream
```
public void updateBinaryStream(int columnIndex,
                      InputStream x,
                      int length)
                        throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBinaryStream in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    length - the number of characters
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBinaryStream
```
public void updateBinaryStream(int columnIndex,
                      InputStream x)
                        throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBinaryStream in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBinaryStream
```
public void updateBinaryStream(int columnIndex,
                      InputStream x,
                      long length)
                        throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBinaryStream in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    length - the number of characters
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBinaryStream
```
public void updateBinaryStream(String columnLabel,
                      InputStream x)
                        throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBinaryStream in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBinaryStream
```
public void updateBinaryStream(String columnLabel,
                      InputStream x,
                      int length)
                        throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBinaryStream in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    length - the number of characters
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBinaryStream
```
public void updateBinaryStream(String columnLabel,
                      InputStream x,
                      long length)
                        throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBinaryStream in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    length - the number of characters
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateCharacterStream
```
public void updateCharacterStream(int columnIndex,
                         Reader x,
                         long length)
                           throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateCharacterStream in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    length - the number of characters
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateCharacterStream
```
public void updateCharacterStream(int columnIndex,
                         Reader x,
                         int length)
                           throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateCharacterStream in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    length - the number of characters
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateCharacterStream
```
public void updateCharacterStream(int columnIndex,
                         Reader x)
                           throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateCharacterStream in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateCharacterStream
```
public void updateCharacterStream(String columnLabel,
                         Reader x,
                         int length)
                           throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateCharacterStream in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    length - the number of characters
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateCharacterStream
```
public void updateCharacterStream(String columnLabel,
                         Reader x)
                           throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateCharacterStream in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateCharacterStream
```
public void updateCharacterStream(String columnLabel,
                         Reader x,
                         long length)
                           throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateCharacterStream in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    length - the number of characters
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateObject
```
public void updateObject(int columnIndex,
                Object x,
                int scale)
                  throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateObject in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    scale - is ignored
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateObject
```
public void updateObject(String columnLabel,
                Object x,
                int scale)
                  throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateObject in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    scale - is ignored
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateObject
```
public void updateObject(int columnIndex,
                Object x)
                  throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateObject in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateObject
```
public void updateObject(String columnLabel,
                Object x)
                  throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateObject in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateRef
```
public void updateRef(int columnIndex,
             Ref x)
               throws SQLException
```
    [Not supported]
    
    Specified by:
    
    updateRef in interface ResultSet
    
    Throws:
    
    SQLException
  - updateRef
```
public void updateRef(String columnLabel,
             Ref x)
               throws SQLException
```
    [Not supported]
    
    Specified by:
    
    updateRef in interface ResultSet
    
    Throws:
    
    SQLException
  - updateBlob
```
public void updateBlob(int columnIndex,
              InputStream x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBlob in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBlob
```
public void updateBlob(int columnIndex,
              InputStream x,
              long length)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBlob in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    length - the length
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBlob
```
public void updateBlob(int columnIndex,
              Blob x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBlob in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBlob
```
public void updateBlob(String columnLabel,
              Blob x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBlob in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBlob
```
public void updateBlob(String columnLabel,
              InputStream x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBlob in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateBlob
```
public void updateBlob(String columnLabel,
              InputStream x,
              long length)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateBlob in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    length - the length
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateClob
```
public void updateClob(int columnIndex,
              Clob x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateClob in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateClob
```
public void updateClob(int columnIndex,
              Reader x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateClob in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateClob
```
public void updateClob(int columnIndex,
              Reader x,
              long length)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateClob in interface ResultSet
    
    Parameters:
    columnIndex - (1,2,...)
    x - the value
    length - the length
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateClob
```
public void updateClob(String columnLabel,
              Clob x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateClob in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateClob
```
public void updateClob(String columnLabel,
              Reader x)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateClob in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateClob
```
public void updateClob(String columnLabel,
              Reader x,
              long length)
                throws SQLException
```
    Updates a column in the current or insert row.
    
    Specified by:
    
    updateClob in interface ResultSet
    
    Parameters:
    columnLabel - the column label
    x - the value
    length - the length
    
    Throws:
    
    SQLException - if the result set is closed or not updatable
  - updateArray
```
public void updateArray(int columnIndex,
               Array x)
                 throws SQLException
```
    [Not supported]
    
    Specified by:
    
    updateArray in interface ResultSet
    
    Throws:
    
    SQLException
  - updateArray
```
public void updateArray(String columnLabel,
               Array x)
                 throws SQLException
```
    [Not supported]
    
    Specified by:
    
    updateArray in interface ResultSet
    
    Throws:
    
    SQLException
  - getCursorName
```
public String getCursorName()
                     throws SQLException
```
    [Not supported] Gets the cursor name if it was defined. This feature is superseded by updateX methods. This method throws a SQLException because cursor names are not supported.
    
    Specified by:
    
    getCursorName in interface ResultSet
    
    Throws:
    
    SQLException
  - getRow
```
public int getRow()
           throws SQLException
```
    Gets the current row number. The first row is row 1, the second 2 and so on. This method returns 0 before the first and after the last row.
    
    Specified by:
    
    getRow in interface ResultSet
    
    Returns:
    the row number
    
    Throws:
    
    SQLException
  - getConcurrency
```
public int getConcurrency()
                   throws SQLException
```
    Gets the result set concurrency. Result sets are only updatable if the statement was created with updatable concurrency, and if the result set contains all columns of the primary key or of a unique index of a table.
    
    Specified by:
    
    getConcurrency in interface ResultSet
    
    Returns:
    ResultSet.CONCUR_UPDATABLE if the result set is updatable, or ResultSet.CONCUR_READ_ONLY otherwise
    
    Throws:
    
    SQLException
  - getFetchDirection
```
public int getFetchDirection()
                      throws SQLException
```
    Gets the fetch direction.
    
    Specified by:
    
    getFetchDirection in interface ResultSet
    
    Returns:
    the direction: FETCH_FORWARD
    
    Throws:
    
    SQLException
  - getFetchSize
```
public int getFetchSize()
                 throws SQLException
```
    Gets the number of rows suggested to read in one step.
    
    Specified by:
    
    getFetchSize in interface ResultSet
    
    Returns:
    the current fetch size
    
    Throws:
    
    SQLException
  - setFetchSize
```
public void setFetchSize(int rows)
                  throws SQLException
```
    Sets the number of rows suggested to read in one step. This value cannot be higher than the maximum rows (setMaxRows) set by the statement or prepared statement, otherwise an exception is throws. Setting the value to 0 will set the default value. The default value can be changed using the system property h2.serverResultSetFetchSize.
    
    Specified by:
    
    setFetchSize in interface ResultSet
    
    Parameters:
    rows - the number of rows
    
    Throws:
    
    SQLException
  - setFetchDirection
```
public void setFetchDirection(int direction)
                       throws SQLException
```
    [Not supported] Sets (changes) the fetch direction for this result set. This method should only be called for scrollable result sets, otherwise it will throw an exception (no matter what direction is used).
    
    Specified by:
    
    setFetchDirection in interface ResultSet
    
    Parameters:
    direction - the new fetch direction
    
    Throws:
    
    SQLException - Unsupported Feature if the method is called for a forward-only result set
  - getType
```
public int getType()
            throws SQLException
```
    Get the result set type.
    
    Specified by:
    
    getType in interface ResultSet
    
    Returns:
    the result set type (TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE)
    
    Throws:
    
    SQLException - if the column is not found or if the result set is closed
  - isBeforeFirst
```
public boolean isBeforeFirst()
                      throws SQLException
```
    Checks if the current position is before the first row, that means next() was not called yet, and there is at least one row.
    
    Specified by:
    
    isBeforeFirst in interface ResultSet
    
    Returns:
    if there are results and the current position is before the first row
    
    Throws:
    
    SQLException - if the result set is closed
  - isAfterLast
```
public boolean isAfterLast()
                    throws SQLException
```
    Checks if the current position is after the last row, that means next() was called and returned false, and there was at least one row.
    
    Specified by:
    
    isAfterLast in interface ResultSet
    
    Returns:
    if there are results and the current position is after the last row
    
    Throws:
    
    SQLException - if the result set is closed
  - isFirst
```
public boolean isFirst()
                throws SQLException
```
    Checks if the current position is row 1, that means next() was called once and returned true.
    
    Specified by:
    
    isFirst in interface ResultSet
    
    Returns:
    if the current position is the first row
    
    Throws:
    
    SQLException - if the result set is closed
  - isLast
```
public boolean isLast()
               throws SQLException
```
    Checks if the current position is the last row, that means next() was called and did not yet returned false, but will in the next call.
    
    Specified by:
    
    isLast in interface ResultSet
    
    Returns:
    if the current position is the last row
    
    Throws:
    
    SQLException - if the result set is closed
  - beforeFirst
```
public void beforeFirst()
                 throws SQLException
```
    Moves the current position to before the first row, that means resets the result set.
    
    Specified by:
    
    beforeFirst in interface ResultSet
    
    Throws:
    
    SQLException - if the result set is closed
  - afterLast
```
public void afterLast()
               throws SQLException
```
    Moves the current position to after the last row, that means after the end.
    
    Specified by:
    
    afterLast in interface ResultSet
    
    Throws:
    
    SQLException - if the result set is closed
  - first
```
public boolean first()
              throws SQLException
```
    Moves the current position to the first row. This is the same as calling beforeFirst() followed by next().
    
    Specified by:
    
    first in interface ResultSet
    
    Returns:
    true if there is a row available, false if not
    
    Throws:
    
    SQLException - if the result set is closed
  - last
```
public boolean last()
             throws SQLException
```
    Moves the current position to the last row.
    
    Specified by:
    
    last in interface ResultSet
    
    Returns:
    true if there is a row available, false if not
    
    Throws:
    
    SQLException - if the result set is closed
  - absolute
```
public boolean absolute(int rowNumber)
                 throws SQLException
```
    Moves the current position to a specific row.
    
    Specified by:
    
    absolute in interface ResultSet
    
    Parameters:
    rowNumber - the row number. 0 is not allowed, 1 means the first row, 2 the second. -1 means the last row, -2 the row before the last row. If the value is too large, the position is moved after the last row, if if the value is too small it is moved before the first row.
    
    Returns:
    true if there is a row available, false if not
    
    Throws:
    
    SQLException - if the result set is closed
  - relative
```
public boolean relative(int rowCount)
                 throws SQLException
```
    Moves the current position to a specific row relative to the current row.
    
    Specified by:
    
    relative in interface ResultSet
    
    Parameters:
    rowCount - 0 means don't do anything, 1 is the next row, -1 the previous. If the value is too large, the position is moved after the last row, if if the value is too small it is moved before the first row.
    
    Returns:
    true if there is a row available, false if not
    
    Throws:
    
    SQLException - if the result set is closed
  - previous
```
public boolean previous()
                 throws SQLException
```
    Moves the cursor to the last row, or row before first row if the current position is the first row.
    
    Specified by:
    
    previous in interface ResultSet
    
    Returns:
    true if there is a row available, false if not
    
    Throws:
    
    SQLException - if the result set is closed
  - moveToInsertRow
```
public void moveToInsertRow()
                     throws SQLException
```
    Moves the current position to the insert row. The current row is remembered.
    
    Specified by:
    
    moveToInsertRow in interface ResultSet
    
    Throws:
    
    SQLException - if the result set is closed or is not updatable
  - moveToCurrentRow
```
public void moveToCurrentRow()
                      throws SQLException
```
    Moves the current position to the current row.
    
    Specified by:
    
    moveToCurrentRow in interface ResultSet
    
    Throws:
    
    SQLException - if the result set is closed or is not updatable
  - rowUpdated
```
public boolean rowUpdated()
                   throws SQLException
```
    Detects if the row was updated (by somebody else or the caller).
    
    Specified by:
    
    rowUpdated in interface ResultSet
    
    Returns:
    false because this driver does not detect this
    
    Throws:
    
    SQLException
  - rowInserted
```
public boolean rowInserted()
                    throws SQLException
```
    Detects if the row was inserted.
    
    Specified by:
    
    rowInserted in interface ResultSet
    
    Returns:
    false because this driver does not detect this
    
    Throws:
    
    SQLException
  - rowDeleted
```
public boolean rowDeleted()
                   throws SQLException
```
    Detects if the row was deleted (by somebody else or the caller).
    
    Specified by:
    
    rowDeleted in interface ResultSet
    
    Returns:
    false because this driver does not detect this
    
    Throws:
    
    SQLException
  - insertRow
```
public void insertRow()
               throws SQLException
```
    Inserts the current row. The current position must be the insert row.
    
    Specified by:
    
    insertRow in interface ResultSet
    
    Throws:
    
    SQLException - if the result set is closed or if not on the insert row, or if the result set it not updatable
  - updateRow
```
public void updateRow()
               throws SQLException
```
    Updates the current row.
    
    Specified by:
    
    updateRow in interface ResultSet
    
    Throws:
    
    SQLException - if the result set is closed, if the current row is the insert row or if not on a valid row, or if the result set it not updatable
  - deleteRow
```
public void deleteRow()
               throws SQLException
```
    Deletes the current row.
    
    Specified by:
    
    deleteRow in interface ResultSet
    
    Throws:
    
    SQLException - if the result set is closed, if the current row is the insert row or if not on a valid row, or if the result set it not updatable
  - refreshRow
```
public void refreshRow()
                throws SQLException
```
    Re-reads the current row from the database.
    
    Specified by:
    
    refreshRow in interface ResultSet
    
    Throws:
    
    SQLException - if the result set is closed or if the current row is the insert row or if the row has been deleted or if not on a valid row
  - cancelRowUpdates
```
public void cancelRowUpdates()
                      throws SQLException
```
    Cancels updating a row.
    
    Specified by:
    
    cancelRowUpdates in interface ResultSet
    
    Throws:
    
    SQLException - if the result set is closed or if the current row is the insert row
  - getHoldability
```
public int getHoldability()
                   throws SQLException
```
    Returns the current result set holdability.
    
    Specified by:
    
    getHoldability in interface ResultSet
    
    Returns:
    the holdability
    
    Throws:
    
    SQLException - if the connection is closed
  - isClosed
```
public boolean isClosed()
                 throws SQLException
```
    Returns whether this result set is closed.
    
    Specified by:
    
    isClosed in interface ResultSet
    
    Returns:
    true if the result set is closed
    
    Throws:
    
    SQLException
  - toString
```
public String toString()
```
    INTERNAL
    
    Overrides:
    
    toString in class Object

Class JdbcResultSet

Field Summary

Fields inherited from class org.h2.message.TraceObject

Fields inherited from interface java.sql.ResultSet

Method Summary

Methods inherited from class org.h2.message.TraceObject

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.ResultSet

Methods inherited from interface java.sql.Wrapper

Method Detail

next

getMetaData

wasNull

findColumn

close

getStatement

getWarnings

clearWarnings

getString

getString

getInt

getInt

getBigDecimal

getDate

getTime

getTimestamp

getBigDecimal

getDate

getTime

getTimestamp

getObject

getObject

getBoolean

getBoolean

getByte

getByte

getShort

getShort

getLong

getLong

getFloat

getFloat

getDouble

getDouble

getBigDecimal

getBigDecimal

getUnicodeStream

getUnicodeStream

getObject

getObject

getRef

getRef

getDate

getDate

getTime

getTime

getTimestamp

getTimestamp

getBlob

getBlob

getBytes

getBytes

getBinaryStream

getBinaryStream

getClob

getClob

getArray

getArray

getAsciiStream

getAsciiStream

getCharacterStream

getCharacterStream

getURL

getURL

updateNull

updateNull

updateBoolean

updateBoolean

updateByte

updateByte