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)
[Not supported]
|
T |
getObject(int columnIndex, Class type)
[Not supported]
Parameters:
columnIndex - the column index (1, 2, ...)
type - the class of the returned value
|
T |
getObject(String columnName, Class type)
[Not supported]
|
T |
getObject(String columnName, Class type)
[Not supported]
Parameters:
columnName - the column name
type - the class of the returned 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)
[Not supported] Checks if unwrap can return an object of this class.
|
boolean |
isWrapperFor(Class iface) throws SQLException
[Not supported] Checks if unwrap can return an object of 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)
[Not supported] Return an object of this class if possible.
|
T |
unwrap(Class iface) throws SQLException
[Not supported] Return an object of this class if possible.
|
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
|