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 ()
Moves the cursor to the next row of the result set.
boolean () 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 ()
Moves the cursor to the last row, or row before first row if the current position is the first row.
boolean () 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