# 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.

Methods
boolean | absolute(int rowNumber) Moves the current position to a specific row.

boolean

absolute(int rowNumber) throws SQLException
Moves the current position to a specific row.
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

void | afterLast() Moves the current position to after the last row, that means after the end.
void | afterLast() throws SQLException Moves the current position to after the last row, that means after the end. Throws: SQLException - if the result set is closed
void | beforeFirst() Moves the current position to before the first row, that means resets the result set.
void | beforeFirst() throws SQLException Moves the current position to before the first row, that means resets the result set. Throws: SQLException - if the result set is closed
void | cancelRowUpdates() Cancels updating a row.
void | cancelRowUpdates() throws SQLException Cancels updating a row. Throws: SQLException - if the result set is closed or if the current row is the insert row
void | clearWarnings() Clears all warnings.
void | clearWarnings() throws SQLException Clears all warnings.
void | close() Closes the result set.
void | close() throws SQLException Closes the result set.
void | deleteRow() Deletes the current row.
void | deleteRow() throws SQLException Deletes the current row. 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
int | findColumn(String columnLabel) Searches for a specific column in the result set.
int | findColumn(String columnLabel) throws SQLException Searches for a specific column in the result set. A case-insensitive search is made. 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
boolean | first() Moves the current position to the first row.
boolean | first() throws SQLException Moves the current position to the first row. This is the same as calling beforeFirst() followed by next(). Returns: true if there is a row available, false if not Throws: SQLException - if the result set is closed
Array | getArray(int columnIndex) Returns the value of the specified column as an Array.
Array | getArray(int columnIndex) throws SQLException Returns the value of the specified column as an Array. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Array | getArray(String columnLabel) Returns the value of the specified column as an Array.
Array | getArray(String columnLabel) throws SQLException Returns the value of the specified column as an Array. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
InputStream | getAsciiStream(int columnIndex) Returns the value of the specified column as an input stream.
InputStream | getAsciiStream(int columnIndex) throws SQLException Returns the value of the specified column as an input stream. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
InputStream | getAsciiStream(String columnLabel) Returns the value of the specified column as an input stream.
InputStream | getAsciiStream(String columnLabel) throws SQLException Returns the value of the specified column as an input stream. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
BigDecimal | getBigDecimal(int columnIndex) Returns the value of the specified column as a BigDecimal.
BigDecimal | getBigDecimal(int columnIndex) throws SQLException Returns the value of the specified column as a BigDecimal. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
BigDecimal | getBigDecimal(String columnLabel) Returns the value of the specified column as a BigDecimal.
BigDecimal | getBigDecimal(String columnLabel) throws SQLException Returns the value of the specified column as a BigDecimal. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
BigDecimal | getBigDecimal(String columnLabel, int scale) Returns the value of the specified column as a BigDecimal.
BigDecimal | getBigDecimal(String columnLabel, int scale) throws SQLException Returns the value of the specified column as a BigDecimal. 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
BigDecimal | getBigDecimal(int columnIndex, int scale) Returns the value of the specified column as a BigDecimal.
BigDecimal | getBigDecimal(int columnIndex, int scale) throws SQLException Returns the value of the specified column as a BigDecimal. 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
InputStream | getBinaryStream(int columnIndex) Returns the value of the specified column as an input stream.
InputStream | getBinaryStream(int columnIndex) throws SQLException Returns the value of the specified column as an input stream. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
InputStream | getBinaryStream(String columnLabel) Returns the value of the specified column as an input stream.
InputStream | getBinaryStream(String columnLabel) throws SQLException Returns the value of the specified column as an input stream. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Blob | getBlob(int columnIndex) Returns the value of the specified column as a Blob.
Blob | getBlob(int columnIndex) throws SQLException Returns the value of the specified column as a Blob. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Blob | getBlob(String columnLabel) Returns the value of the specified column as a Blob.
Blob | getBlob(String columnLabel) throws SQLException Returns the value of the specified column as a Blob. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
boolean | getBoolean(int columnIndex) Returns the value of the specified column as a boolean.
boolean | getBoolean(int columnIndex) throws SQLException Returns the value of the specified column as a boolean. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
boolean | getBoolean(String columnLabel) Returns the value of the specified column as a boolean.
boolean | getBoolean(String columnLabel) throws SQLException Returns the value of the specified column as a boolean. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
byte | getByte(int columnIndex) Returns the value of the specified column as a byte.
byte | getByte(int columnIndex) throws SQLException Returns the value of the specified column as a byte. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
byte | getByte(String columnLabel) Returns the value of the specified column as a byte.
byte | getByte(String columnLabel) throws SQLException Returns the value of the specified column as a byte. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
byte[] | getBytes(int columnIndex) Returns the value of the specified column as a byte array.
byte[] | getBytes(int columnIndex) throws SQLException Returns the value of the specified column as a byte array. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
byte[] | getBytes(String columnLabel) Returns the value of the specified column as a byte array.
byte[] | getBytes(String columnLabel) throws SQLException Returns the value of the specified column as a byte array. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Reader | getCharacterStream(int columnIndex) Returns the value of the specified column as a reader.
Reader | getCharacterStream(int columnIndex) throws SQLException Returns the value of the specified column as a reader. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Reader | getCharacterStream(String columnLabel) Returns the value of the specified column as a reader.
Reader | getCharacterStream(String columnLabel) throws SQLException Returns the value of the specified column as a reader. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Clob | getClob(int columnIndex) Returns the value of the specified column as a Clob.
Clob | getClob(int columnIndex) throws SQLException Returns the value of the specified column as a Clob. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Clob | getClob(String columnLabel) Returns the value of the specified column as a Clob.
Clob | getClob(String columnLabel) throws SQLException Returns the value of the specified column as a Clob. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
int | getConcurrency() Gets the result set concurrency.
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. Returns: ResultSet.CONCUR_UPDATABLE if the result set is updatable, or ResultSet.CONCUR_READ_ONLY otherwise
String | getCursorName() [Not supported] Gets the cursor name if it was defined.
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.
Date | getDate(int columnIndex) Returns the value of the specified column as a java.sql.Date.
Date | getDate(int columnIndex) throws SQLException Returns the value of the specified column as a java.sql.Date. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Date | getDate(String columnLabel) Returns the value of the specified column as a java.sql.Date.
Date | getDate(String columnLabel) throws SQLException Returns the value of the specified column as a java.sql.Date. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
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(int columnIndex, Calendar calendar) throws SQLException Returns the value of the specified column as a java.sql.Date using a specified time zone. 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
Date | getDate(String columnLabel, Calendar calendar) Returns the value of the specified column as a java.sql.Date using a specified time zone.
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. 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
double | getDouble(int columnIndex) Returns the value of the specified column as a double.
double | getDouble(int columnIndex) throws SQLException Returns the value of the specified column as a double. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
double | getDouble(String columnLabel) Returns the value of the specified column as a double.
double | getDouble(String columnLabel) throws SQLException Returns the value of the specified column as a double. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
int | getFetchDirection() Gets the fetch direction.
int | getFetchDirection() throws SQLException Gets the fetch direction. Returns: the direction: FETCH_FORWARD
int | getFetchSize() Gets the number of rows suggested to read in one step.
int | getFetchSize() throws SQLException Gets the number of rows suggested to read in one step. Returns: the current fetch size
float | getFloat(int columnIndex) Returns the value of the specified column as a float.
float | getFloat(int columnIndex) throws SQLException Returns the value of the specified column as a float. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
float | getFloat(String columnLabel) Returns the value of the specified column as a float.
float | getFloat(String columnLabel) throws SQLException Returns the value of the specified column as a float. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
int | getHoldability() Returns the current result set holdability.
int | getHoldability() throws SQLException Returns the current result set holdability. Returns: the holdability Throws: SQLException - if the connection is closed
int | getInt(int columnIndex) Returns the value of the specified column as an int.
int | getInt(int columnIndex) throws SQLException Returns the value of the specified column as an int. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
int | getInt(String columnLabel) Returns the value of the specified column as an int.
int | getInt(String columnLabel) throws SQLException Returns the value of the specified column as an int. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
long | getLong(int columnIndex) Returns the value of the specified column as a long.
long | getLong(int columnIndex) throws SQLException Returns the value of the specified column as a long. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
long | getLong(String columnLabel) Returns the value of the specified column as a long.
long | getLong(String columnLabel) throws SQLException Returns the value of the specified column as a long. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
ResultSetMetaData | getMetaData() Gets the meta data of this result set.
ResultSetMetaData | getMetaData() throws SQLException Gets the meta data of this result set. Returns: the meta data
Reader | getNCharacterStream(int columnIndex) Returns the value of the specified column as a reader.
Reader | getNCharacterStream(int columnIndex) throws SQLException Returns the value of the specified column as a reader. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Reader | getNCharacterStream(String columnLabel) Returns the value of the specified column as a reader.
Reader | getNCharacterStream(String columnLabel) throws SQLException Returns the value of the specified column as a reader. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
NClob | getNClob(int columnIndex) Returns the value of the specified column as a Clob.
NClob | getNClob(int columnIndex) throws SQLException Returns the value of the specified column as a Clob. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
NClob | getNClob(String columnLabel) Returns the value of the specified column as a Clob.
NClob | getNClob(String columnLabel) throws SQLException Returns the value of the specified column as a Clob. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
String | getNString(int columnIndex) Returns the value of the specified column as a String.
String | getNString(int columnIndex) throws SQLException Returns the value of the specified column as a String. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
String | getNString(String columnLabel) Returns the value of the specified column as a String.
String | getNString(String columnLabel) throws SQLException Returns the value of the specified column as a String. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Object | getObject(int columnIndex) Returns a column value as a Java object.
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). Parameters: columnIndex - (1,2,...) Returns: the value or null Throws: SQLException - if the column is not found or if the result set is closed
Object | getObject(String columnLabel) Returns a column value as a Java object.
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). 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
Object | getObject(int columnIndex, Map map) [Not supported] Gets a column as a object using the specified type mapping.
Object | getObject(int columnIndex, Map map) throws SQLException [Not supported] Gets a column as a object using the specified type mapping.
Object | getObject(String columnLabel, Map map) [Not supported] Gets a column as a object using the specified type mapping.
Object | getObject(String columnLabel, Map map) throws SQLException [Not supported] Gets a column as a object using the specified type mapping.
T | getObject(int columnIndex, Class type) Returns a column value as a Java object.
T | getObject(int columnIndex, Class type) throws SQLException Returns a column value as a Java object. The data is de-serialized into a Java object (on the client side). Parameters: columnIndex - the column index (1, 2, ...) type - the class of the returned value Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
T | getObject(String columnName, Class type) Returns a column value as a Java object.
T | getObject(String columnName, Class type) throws SQLException Returns a column value as a Java object. The data is de-serialized into a Java object (on the client side). Parameters: columnName - the column name type - the class of the returned value Returns: the value
Ref | getRef(int columnIndex) [Not supported] Gets a column as a reference.
Ref | getRef(int columnIndex) throws SQLException [Not supported] Gets a column as a reference.
Ref | getRef(String columnLabel) [Not supported] Gets a column as a reference.
Ref | getRef(String columnLabel) throws SQLException [Not supported] Gets a column as a reference.
int | getRow() Gets the current row number.
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. Returns: the row number
RowId | getRowId(int columnIndex) [Not supported] Returns the value of the specified column as a row id.
RowId | getRowId(int columnIndex) throws SQLException [Not supported] Returns the value of the specified column as a row id. Parameters: columnIndex - (1,2,...)
RowId | getRowId(String columnLabel) [Not supported] Returns the value of the specified column as a row id.
RowId | getRowId(String columnLabel) throws SQLException [Not supported] Returns the value of the specified column as a row id. Parameters: columnLabel - the column label
SQLXML | getSQLXML(int columnIndex) [Not supported] Returns the value of the specified column as a SQLXML object.
SQLXML | getSQLXML(int columnIndex) throws SQLException [Not supported] Returns the value of the specified column as a SQLXML object.
SQLXML | getSQLXML(String columnLabel) [Not supported] Returns the value of the specified column as a SQLXML object.
SQLXML | getSQLXML(String columnLabel) throws SQLException [Not supported] Returns the value of the specified column as a SQLXML object.
short | getShort(int columnIndex) Returns the value of the specified column as a short.
short | getShort(int columnIndex) throws SQLException Returns the value of the specified column as a short. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
short | getShort(String columnLabel) Returns the value of the specified column as a short.
short | getShort(String columnLabel) throws SQLException Returns the value of the specified column as a short. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Statement | getStatement() Returns the statement that created this object.
Statement | getStatement() throws SQLException Returns the statement that created this object. Returns: the statement or prepared statement, or null if created by a DatabaseMetaData call.
String | getString(int columnIndex) Returns the value of the specified column as a String.
String | getString(int columnIndex) throws SQLException Returns the value of the specified column as a String. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
String | getString(String columnLabel) Returns the value of the specified column as a String.
String | getString(String columnLabel) throws SQLException Returns the value of the specified column as a String. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Time | getTime(int columnIndex) Returns the value of the specified column as a java.sql.Time.
Time | getTime(int columnIndex) throws SQLException Returns the value of the specified column as a java.sql.Time. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Time | getTime(String columnLabel) Returns the value of the specified column as a java.sql.Time.
Time | getTime(String columnLabel) throws SQLException Returns the value of the specified column as a java.sql.Time. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
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(int columnIndex, Calendar calendar) throws SQLException Returns the value of the specified column as a java.sql.Time using a specified time zone. 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
Time | getTime(String columnLabel, Calendar calendar) Returns the value of the specified column as a java.sql.Time using a specified time zone.
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. 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
Timestamp | getTimestamp(int columnIndex) Returns the value of the specified column as a java.sql.Timestamp.
Timestamp | getTimestamp(int columnIndex) throws SQLException Returns the value of the specified column as a java.sql.Timestamp. Parameters: columnIndex - (1,2,...) Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
Timestamp | getTimestamp(String columnLabel) Returns the value of the specified column as a java.sql.Timestamp.
Timestamp | getTimestamp(String columnLabel) throws SQLException Returns the value of the specified column as a java.sql.Timestamp. Parameters: columnLabel - the column label Returns: the value Throws: SQLException - if the column is not found or if the result set is closed
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(int columnIndex, Calendar calendar) throws SQLException Returns the value of the specified column as a java.sql.Timestamp using a specified time zone. 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
Timestamp | getTimestamp(String columnLabel, Calendar calendar) Returns the value of the specified column as a java.sql.Timestamp.
Timestamp | getTimestamp(String columnLabel, Calendar calendar) throws SQLException Returns the value of the specified column as a java.sql.Timestamp. 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
int | getType() Get the result set type.
int | getType() throws SQLException Get the result set type. 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
URL | getURL(int columnIndex) [Not supported]
URL | getURL(int columnIndex) throws SQLException [Not supported]
URL | getURL(String columnLabel) [Not supported]
URL | getURL(String columnLabel) throws SQLException [Not supported]
InputStream | getUnicodeStream(int columnIndex) [Not supported]
InputStream | getUnicodeStream(int columnIndex) throws SQLException [Not supported]
InputStream | getUnicodeStream(String columnLabel) [Not supported]
InputStream | getUnicodeStream(String columnLabel) throws SQLException [Not supported]
SQLWarning | getWarnings() Gets the first warning reported by calls on this object.
SQLWarning | getWarnings() throws SQLException Gets the first warning reported by calls on this object. Returns: null
void | insertRow() Inserts the current row.
void | insertRow() throws SQLException Inserts the current row. The current position must be the insert row. Throws: SQLException - if the result set is closed or if not on the insert row, or if the result set it not updatable
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 | 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. Returns: if there are results and the current position is after the last row Throws: SQLException - if the result set is closed
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 | 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. Returns: if there are results and the current position is before the first row Throws: SQLException - if the result set is closed
boolean | isClosed() Returns whether this result set is closed.
boolean | isClosed() throws SQLException Returns whether this result set is closed. Returns: true if the result set is closed
boolean | isFirst() Checks if the current position is row 1, that means next() was called once and returned true.
boolean | isFirst() throws SQLException Checks if the current position is row 1, that means next() was called once and returned true. Returns: if the current position is the first row Throws: SQLException - if the result set is closed
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 | 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. Returns: if the current position is the last row Throws: SQLException - if the result set is closed
boolean | isWrapperFor(Class iface) Checks if unwrap can return an object of this class.
boolean | isWrapperFor(Class iface) throws SQLException Checks if unwrap can return an object of this class. Parameters: iface - the class Returns: whether or not the interface is assignable from this class
boolean | last() Moves the current position to the last row.
boolean | last() throws SQLException Moves the current position to the last row. Returns: true if there is a row available, false if not Throws: SQLException - if the result set is closed
void | moveToCurrentRow() Moves the current position to the current row.
void | moveToCurrentRow() throws SQLException Moves the current position to the current row. Throws: SQLException - if the result set is closed or is not updatable
void | moveToInsertRow() Moves the current position to the insert row.
void | moveToInsertRow() throws SQLException Moves the current position to the insert row. The current row is remembered. Throws: SQLException - if the result set is closed or is not updatable
boolean | next() Moves the cursor to the next row of the result set.
boolean | next() throws SQLException Moves the cursor to the next row of the result set. Returns: true if successful, false if there are no more rows
boolean | previous() Moves the cursor to the last row, or row before first row if the current position is the first row.
boolean | previous() throws SQLException Moves the cursor to the last row, or row before first row if the current position is the first row. Returns: true if there is a row available, false if not Throws: SQLException - if the result set is closed
void | refreshRow() Re-reads the current row from the database.
void | refreshRow() throws SQLException Re-reads the current row from the database. 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
boolean | relative(int rowCount) Moves the current position to a specific row relative to the current row.

boolean

relative(int rowCount) throws SQLException
Moves the current position to a specific row relative to the current row.
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

boolean | rowDeleted() Detects if the row was deleted (by somebody else or the caller).
boolean | rowDeleted() throws SQLException Detects if the row was deleted (by somebody else or the caller). Returns: false because this driver does not detect this
boolean | rowInserted() Detects if the row was inserted.
boolean | rowInserted() throws SQLException Detects if the row was inserted. Returns: false because this driver does not detect this
boolean | rowUpdated() Detects if the row was updated (by somebody else or the caller).
boolean | rowUpdated() throws SQLException Detects if the row was updated (by somebody else or the caller). Returns: false because this driver does not detect this
void | setFetchDirection(int direction) [Not supported] Sets (changes) the fetch direction for this result set.

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).
Parameters:
direction - the new fetch direction
Throws:
SQLException - Unsupported Feature if the method is called for a forward-only result set

void | setFetchSize(int rows) Sets the number of rows suggested to read in one step.

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.
Parameters:
rows - the number of rows

T | unwrap(Class iface) Return an object of this class if possible.
T | unwrap(Class iface) throws SQLException Return an object of this class if possible. Parameters: iface - the class Returns: this
void | updateArray(int columnIndex, Array x) [Not supported]
void | updateArray(int columnIndex, Array x) throws SQLException [Not supported]
void | updateArray(String columnLabel, Array x) [Not supported]
void | updateArray(String columnLabel, Array x) throws SQLException [Not supported]
void | updateAsciiStream(int columnIndex, InputStream x, int length) Updates a column in the current or insert row.
void | updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateAsciiStream(int columnIndex, InputStream x) Updates a column in the current or insert row.
void | updateAsciiStream(int columnIndex, InputStream x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateAsciiStream(int columnIndex, InputStream x, long length) Updates a column in the current or insert row.
void | updateAsciiStream(int columnIndex, InputStream x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateAsciiStream(String columnLabel, InputStream x, int length) Updates a column in the current or insert row.
void | updateAsciiStream(String columnLabel, InputStream x, int length) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateAsciiStream(String columnLabel, InputStream x) Updates a column in the current or insert row.
void | updateAsciiStream(String columnLabel, InputStream x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed
void | updateAsciiStream(String columnLabel, InputStream x, long length) Updates a column in the current or insert row.
void | updateAsciiStream(String columnLabel, InputStream x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateBigDecimal(int columnIndex, BigDecimal x) Updates a column in the current or insert row.
void | updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateBigDecimal(String columnLabel, BigDecimal x) Updates a column in the current or insert row.
void | updateBigDecimal(String columnLabel, BigDecimal x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateBinaryStream(int columnIndex, InputStream x, int length) Updates a column in the current or insert row.
void | updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateBinaryStream(int columnIndex, InputStream x) Updates a column in the current or insert row.
void | updateBinaryStream(int columnIndex, InputStream x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateBinaryStream(int columnIndex, InputStream x, long length) Updates a column in the current or insert row.
void | updateBinaryStream(int columnIndex, InputStream x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateBinaryStream(String columnLabel, InputStream x) Updates a column in the current or insert row.
void | updateBinaryStream(String columnLabel, InputStream x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateBinaryStream(String columnLabel, InputStream x, int length) Updates a column in the current or insert row.
void | updateBinaryStream(String columnLabel, InputStream x, int length) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateBinaryStream(String columnLabel, InputStream x, long length) Updates a column in the current or insert row.
void | updateBinaryStream(String columnLabel, InputStream x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateBlob(int columnIndex, InputStream x) Updates a column in the current or insert row.
void | updateBlob(int columnIndex, InputStream x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateBlob(int columnIndex, InputStream x, long length) Updates a column in the current or insert row.
void | updateBlob(int columnIndex, InputStream x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value length - the length Throws: SQLException - if the result set is closed or not updatable
void | updateBlob(int columnIndex, Blob x) Updates a column in the current or insert row.
void | updateBlob(int columnIndex, Blob x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateBlob(String columnLabel, Blob x) Updates a column in the current or insert row.
void | updateBlob(String columnLabel, Blob x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateBlob(String columnLabel, InputStream x) Updates a column in the current or insert row.
void | updateBlob(String columnLabel, InputStream x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateBlob(String columnLabel, InputStream x, long length) Updates a column in the current or insert row.
void | updateBlob(String columnLabel, InputStream x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value length - the length Throws: SQLException - if the result set is closed or not updatable
void | updateBoolean(int columnIndex, boolean x) Updates a column in the current or insert row.
void | updateBoolean(int columnIndex, boolean x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateBoolean(String columnLabel, boolean x) Updates a column in the current or insert row.
void | updateBoolean(String columnLabel, boolean x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if result set is closed or not updatable
void | updateByte(int columnIndex, byte x) Updates a column in the current or insert row.
void | updateByte(int columnIndex, byte x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateByte(String columnLabel, byte x) Updates a column in the current or insert row.
void | updateByte(String columnLabel, byte x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateBytes(int columnIndex, byte[] x) Updates a column in the current or insert row.
void | updateBytes(int columnIndex, byte[] x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateBytes(String columnLabel, byte[] x) Updates a column in the current or insert row.
void | updateBytes(String columnLabel, byte[] x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateCharacterStream(int columnIndex, Reader x, long length) Updates a column in the current or insert row.
void | updateCharacterStream(int columnIndex, Reader x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateCharacterStream(int columnIndex, Reader x, int length) Updates a column in the current or insert row.
void | updateCharacterStream(int columnIndex, Reader x, int length) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateCharacterStream(int columnIndex, Reader x) Updates a column in the current or insert row.
void | updateCharacterStream(int columnIndex, Reader x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateCharacterStream(String columnLabel, Reader x, int length) Updates a column in the current or insert row.
void | updateCharacterStream(String columnLabel, Reader x, int length) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateCharacterStream(String columnLabel, Reader x) Updates a column in the current or insert row.
void | updateCharacterStream(String columnLabel, Reader x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateCharacterStream(String columnLabel, Reader x, long length) Updates a column in the current or insert row.
void | updateCharacterStream(String columnLabel, Reader x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateClob(int columnIndex, Clob x) Updates a column in the current or insert row.
void | updateClob(int columnIndex, Clob x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateClob(int columnIndex, Reader x) Updates a column in the current or insert row.
void | updateClob(int columnIndex, Reader x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateClob(int columnIndex, Reader x, long length) Updates a column in the current or insert row.
void | updateClob(int columnIndex, Reader x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value length - the length Throws: SQLException - if the result set is closed or not updatable
void | updateClob(String columnLabel, Clob x) Updates a column in the current or insert row.
void | updateClob(String columnLabel, Clob x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateClob(String columnLabel, Reader x) Updates a column in the current or insert row.
void | updateClob(String columnLabel, Reader x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateClob(String columnLabel, Reader x, long length) Updates a column in the current or insert row.
void | updateClob(String columnLabel, Reader x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value length - the length Throws: SQLException - if the result set is closed or not updatable
void | updateDate(int columnIndex, Date x) Updates a column in the current or insert row.
void | updateDate(int columnIndex, Date x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateDate(String columnLabel, Date x) Updates a column in the current or insert row.
void | updateDate(String columnLabel, Date x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateDouble(int columnIndex, double x) Updates a column in the current or insert row.
void | updateDouble(int columnIndex, double x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateDouble(String columnLabel, double x) Updates a column in the current or insert row.
void | updateDouble(String columnLabel, double x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateFloat(int columnIndex, float x) Updates a column in the current or insert row.
void | updateFloat(int columnIndex, float x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateFloat(String columnLabel, float x) Updates a column in the current or insert row.
void | updateFloat(String columnLabel, float x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateInt(int columnIndex, int x) Updates a column in the current or insert row.
void | updateInt(int columnIndex, int x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateInt(String columnLabel, int x) Updates a column in the current or insert row.
void | updateInt(String columnLabel, int x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateLong(int columnIndex, long x) Updates a column in the current or insert row.
void | updateLong(int columnIndex, long x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateLong(String columnLabel, long x) Updates a column in the current or insert row.
void | updateLong(String columnLabel, long x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateNCharacterStream(int columnIndex, Reader x) Updates a column in the current or insert row.
void | updateNCharacterStream(int columnIndex, Reader x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateNCharacterStream(int columnIndex, Reader x, long length) Updates a column in the current or insert row.
void | updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateNCharacterStream(String columnLabel, Reader x) Updates a column in the current or insert row.
void | updateNCharacterStream(String columnLabel, Reader x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateNCharacterStream(String columnLabel, Reader x, long length) Updates a column in the current or insert row.
void | updateNCharacterStream(String columnLabel, Reader x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value length - the number of characters Throws: SQLException - if the result set is closed or not updatable
void | updateNClob(int columnIndex, NClob x) [Not supported]
void | updateNClob(int columnIndex, NClob x) throws SQLException [Not supported]
void | updateNClob(int columnIndex, Reader x) Updates a column in the current or insert row.
void | updateNClob(int columnIndex, Reader x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateNClob(int columnIndex, Reader x, long length) Updates a column in the current or insert row.
void | updateNClob(int columnIndex, Reader x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value length - the length Throws: SQLException - if the result set is closed or not updatable
void | updateNClob(String columnLabel, Reader x) Updates a column in the current or insert row.
void | updateNClob(String columnLabel, Reader x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateNClob(String columnLabel, Reader x, long length) Updates a column in the current or insert row.
void | updateNClob(String columnLabel, Reader x, long length) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value length - the length Throws: SQLException - if the result set is closed or not updatable
void | updateNClob(String columnLabel, NClob x) [Not supported]
void | updateNClob(String columnLabel, NClob x) throws SQLException [Not supported]
void | updateNString(int columnIndex, String x) Updates a column in the current or insert row.
void | updateNString(int columnIndex, String x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateNString(String columnLabel, String x) Updates a column in the current or insert row.
void | updateNString(String columnLabel, String x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateNull(int columnIndex) Updates a column in the current or insert row.
void | updateNull(int columnIndex) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) Throws: SQLException - if the result set is closed or not updatable
void | updateNull(String columnLabel) Updates a column in the current or insert row.
void | updateNull(String columnLabel) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label Throws: SQLException - if the result set is closed or not updatable
void | updateObject(int columnIndex, Object x, int scale) Updates a column in the current or insert row.
void | updateObject(int columnIndex, Object x, int scale) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value scale - is ignored Throws: SQLException - if the result set is closed or not updatable
void | updateObject(String columnLabel, Object x, int scale) Updates a column in the current or insert row.
void | updateObject(String columnLabel, Object x, int scale) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value scale - is ignored Throws: SQLException - if the result set is closed or not updatable
void | updateObject(int columnIndex, Object x) Updates a column in the current or insert row.
void | updateObject(int columnIndex, Object x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateObject(String columnLabel, Object x) Updates a column in the current or insert row.
void | updateObject(String columnLabel, Object x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateRef(int columnIndex, Ref x) [Not supported]
void | updateRef(int columnIndex, Ref x) throws SQLException [Not supported]
void | updateRef(String columnLabel, Ref x) [Not supported]
void | updateRef(String columnLabel, Ref x) throws SQLException [Not supported]
void | updateRow() Updates the current row.
void | updateRow() throws SQLException Updates the current row. 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
void | updateRowId(int columnIndex, RowId x) [Not supported] Updates a column in the current or insert row.
void | updateRowId(int columnIndex, RowId x) throws SQLException [Not supported] Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value
void | updateRowId(String columnLabel, RowId x) [Not supported] Updates a column in the current or insert row.
void | updateRowId(String columnLabel, RowId x) throws SQLException [Not supported] Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value
void | updateSQLXML(int columnIndex, SQLXML xmlObject) [Not supported] Updates a column in the current or insert row.
void | updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException [Not supported] Updates a column in the current or insert row.
void | updateSQLXML(String columnLabel, SQLXML xmlObject) [Not supported] Updates a column in the current or insert row.
void | updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException [Not supported] Updates a column in the current or insert row.
void | updateShort(int columnIndex, short x) Updates a column in the current or insert row.
void | updateShort(int columnIndex, short x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateShort(String columnLabel, short x) Updates a column in the current or insert row.
void | updateShort(String columnLabel, short x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateString(int columnIndex, String x) Updates a column in the current or insert row.
void | updateString(int columnIndex, String x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateString(String columnLabel, String x) Updates a column in the current or insert row.
void | updateString(String columnLabel, String x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateTime(int columnIndex, Time x) Updates a column in the current or insert row.
void | updateTime(int columnIndex, Time x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateTime(String columnLabel, Time x) Updates a column in the current or insert row.
void | updateTime(String columnLabel, Time x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateTimestamp(int columnIndex, Timestamp x) Updates a column in the current or insert row.
void | updateTimestamp(int columnIndex, Timestamp x) throws SQLException Updates a column in the current or insert row. Parameters: columnIndex - (1,2,...) x - the value Throws: SQLException - if the result set is closed or not updatable
void | updateTimestamp(String columnLabel, Timestamp x) Updates a column in the current or insert row.
void | updateTimestamp(String columnLabel, Timestamp x) throws SQLException Updates a column in the current or insert row. Parameters: columnLabel - the column label x - the value Throws: SQLException - if the result set is closed or not updatable
boolean | wasNull() Returns whether the last column accessed was null.
boolean | wasNull() throws SQLException Returns whether the last column accessed was null. Returns: true if the last column accessed was null