public class OPLJdbcRowSet extends BaseRowSet
A OPLJdbcRowSet is a connected rowset. The purpose of the OPLJdbcRowSet class is to act like a JavaBean at design time and provide a thin layer that wraps around a JDBC ResultSet at runtime.
When execute() is called a OPLJdbcRowSet object opens a JDBC connection internally which remains open until close() is called, unless a Connection is passed to execute() explicitly, in which case that Connection is used instead. ResultSet operations such as cursor movement, updating, etc. are simply delegated to an underlying JDBC ResultSet object which is maintained internally.
BaseRowSet.Parameterev_CursorMoved, ev_RowChanged, ev_RowSetChanged, map| Constructor | Description |
|---|---|
OPLJdbcRowSet() |
| Modifier and Type | Method | Description |
|---|---|---|
boolean |
absolute(int row) |
Move to an absolute row number in the result set.
|
void |
afterLast() |
Moves to the end of the result set, just after the last
row.
|
void |
beforeFirst() |
Moves to the front of the result set, just before the
first row.
|
void |
cancelRowUpdates() |
The cancelRowUpdates() method may be called after calling an
updateXXX() method(s) and before calling updateRow() to rollback
the updates made to a row.
|
void |
clearWarnings() |
After this call getWarnings returns null until a new warning is
reported for this ResultSet.
|
void |
close() |
In some cases, it is desirable to immediately release a
ResultSet's database and JDBC resources instead of waiting for
this to happen when it is automatically closed; the close
method provides this immediate release.
|
void |
deleteRow() |
Delete the current row from the result set and the underlying
database.
|
void |
execute() |
Populates the rowset with data.
|
void |
execute(java.sql.Connection _conn) |
Populates the rowset with data.
|
void |
finalize() |
|
int |
findColumn(java.lang.String columnName) |
Map a Resultset column name to a ResultSet column index.
|
boolean |
first() |
Moves to the first row in the result set.
|
java.sql.Array |
getArray(int colIndex) |
Get an array column.
|
java.sql.Array |
getArray(java.lang.String colName) |
Get an array column.
|
java.io.InputStream |
getAsciiStream(int columnIndex) |
A column value can be retrieved as a stream of ASCII characters
and then read in chunks from the stream.
|
java.io.InputStream |
getAsciiStream(java.lang.String columnName) |
A column value can be retrieved as a stream of ASCII characters
and then read in chunks from the stream.
|
java.math.BigDecimal |
getBigDecimal(int columnIndex) |
Get the value of a column in the current row as a java.math.BigDecimal
object.
|
java.math.BigDecimal |
getBigDecimal(int columnIndex,
int scale) |
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName) |
Get the value of a column in the current row as a java.math.BigDecimal
object.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName,
int scale) |
Deprecated.
|
java.io.InputStream |
getBinaryStream(int columnIndex) |
A column value can be retrieved as a stream of uninterpreted bytes
and then read in chunks from the stream.
|
java.io.InputStream |
getBinaryStream(java.lang.String columnName) |
A column value can be retrieved as a stream of uninterpreted bytes
and then read in chunks from the stream.
|
java.sql.Blob |
getBlob(int colIndex) |
Get a BLOB column.
|
java.sql.Blob |
getBlob(java.lang.String colName) |
Get a BLOB column.
|
boolean |
getBoolean(int columnIndex) |
Get the value of a column in the current row as a Java boolean.
|
boolean |
getBoolean(java.lang.String columnName) |
Get the value of a column in the current row as a Java boolean.
|
byte |
getByte(int columnIndex) |
Get the value of a column in the current row as a Java byte.
|
byte |
getByte(java.lang.String columnName) |
Get the value of a column in the current row as a Java byte.
|
byte[] |
getBytes(int columnIndex) |
Get the value of a column in the current row as a Java byte array.
|
byte[] |
getBytes(java.lang.String columnName) |
Get the value of a column in the current row as a Java byte array.
|
java.io.Reader |
getCharacterStream(int columnIndex) |
Get the value of a column in the current row as a java.io.Reader.
|
java.io.Reader |
getCharacterStream(java.lang.String columnName) |
Get the value of a column in the current row as a java.io.Reader.
|
java.sql.Clob |
getClob(int colIndex) |
Get a CLOB column.
|
java.sql.Clob |
getClob(java.lang.String colName) |
Get a CLOB column.
|
java.lang.String |
getCursorName() |
Get the name of the SQL cursor used by this ResultSet.
|
java.sql.Date |
getDate(int columnIndex) |
Get the value of a column in the current row as a java.sql.Date object.
|
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar cal) |
Get the value of a column in the current row as a java.sql.Date
object.
|
java.sql.Date |
getDate(java.lang.String columnName) |
Get the value of a column in the current row as a java.sql.Date object.
|
java.sql.Date |
getDate(java.lang.String columnName,
java.util.Calendar cal) |
Get the value of a column in the current row as a java.sql.Date
object.
|
double |
getDouble(int columnIndex) |
Get the value of a column in the current row as a Java double.
|
double |
getDouble(java.lang.String columnName) |
Get the value of a column in the current row as a Java double.
|
float |
getFloat(int columnIndex) |
Get the value of a column in the current row as a Java float.
|
float |
getFloat(java.lang.String columnName) |
Get the value of a column in the current row as a Java float.
|
int |
getHoldability() |
Retrieves the holdability of this
ResultSet object |
int |
getInt(int columnIndex) |
Get the value of a column in the current row as a Java int.
|
int |
getInt(java.lang.String columnName) |
Get the value of a column in the current row as a Java int.
|
long |
getLong(int columnIndex) |
Get the value of a column in the current row as a Java long.
|
long |
getLong(java.lang.String columnName) |
Get the value of a column in the current row as a Java long.
|
java.sql.ResultSetMetaData |
getMetaData() |
The number, types and properties of a ResultSet's columns
are provided by the getMetaData method.
|
java.io.Reader |
getNCharacterStream(int columnIndex) |
Retrieves the value of the designated column in the current row
of this
ResultSet object as a
java.io.Reader object. |
java.io.Reader |
getNCharacterStream(java.lang.String columnLabel) |
Retrieves the value of the designated column in the current row
of this
ResultSet object as a
java.io.Reader object. |
java.sql.NClob |
getNClob(int columnIndex) |
Retrieves the value of the designated column in the current row
of this
ResultSet object as a NClob object
in the Java programming language. |
java.sql.NClob |
getNClob(java.lang.String columnLabel) |
Retrieves the value of the designated column in the current row
of this
ResultSet object as a NClob object
in the Java programming language. |
java.lang.String |
getNString(int columnIndex) |
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a String in the Java programming language. |
java.lang.String |
getNString(java.lang.String columnLabel) |
Retrieves the value of the designated column in the current row
of this
ResultSet object as
a String in the Java programming language. |
java.lang.Object |
getObject(int columnIndex) |
Get the value of a column in the current row as a Java object.
|
<T> T |
getObject(int columnIndex,
java.lang.Class<T> type) |
Retrieves the value of the designated column in the current row
of this
ResultSet object and will convert from the
SQL type of the column to the requested Java data type, if the
conversion is supported. |
java.lang.Object |
getObject(int colIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
Returns the value of column @i as a Java object.
|
java.lang.Object |
getObject(java.lang.String columnName) |
Get the value of a column in the current row as a Java object.
|
<T> T |
getObject(java.lang.String columnLabel,
java.lang.Class<T> type) |
Retrieves the value of the designated column in the current row
of this
ResultSet object and will convert from the
SQL type of the column to the requested Java data type, if the
conversion is supported. |
java.lang.Object |
getObject(java.lang.String colName,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
Returns the value of column @i as a Java object.
|
java.sql.Ref |
getRef(int colIndex) |
Get a REF(<structured-type>) column.
|
java.sql.Ref |
getRef(java.lang.String colName) |
Get a REF(<structured-type>) column.
|
int |
getRow() |
Determine the current row number.
|
java.sql.RowId |
getRowId(int columnIndex) |
Retrieves the value of the designated column in the current row of this
ResultSet object as a java.sql.RowId object in the Java
programming language. |
java.sql.RowId |
getRowId(java.lang.String columnLabel) |
Retrieves the value of the designated column in the current row of this
ResultSet object as a java.sql.RowId object in the Java
programming language. |
short |
getShort(int columnIndex) |
Get the value of a column in the current row as a Java short.
|
short |
getShort(java.lang.String columnName) |
Get the value of a column in the current row as a Java short.
|
java.sql.SQLXML |
getSQLXML(int columnIndex) |
Retrieves the value of the designated column in the current row of
this
ResultSet as a
java.sql.SQLXML object in the Java programming language. |
java.sql.SQLXML |
getSQLXML(java.lang.String columnLabel) |
Retrieves the value of the designated column in the current row of
this
ResultSet as a
java.sql.SQLXML object in the Java programming language. |
java.sql.Statement |
getStatement() |
Return the Statement that produced the ResultSet.
|
java.lang.String |
getString(int columnIndex) |
Get the value of a column in the current row as a Java String.
|
java.lang.String |
getString(java.lang.String columnName) |
Get the value of a column in the current row as a Java String.
|
java.sql.Time |
getTime(int columnIndex) |
Get the value of a column in the current row as a java.sql.Time object.
|
java.sql.Time |
getTime(int columnIndex,
java.util.Calendar cal) |
Get the value of a column in the current row as a java.sql.Time
object.
|
java.sql.Time |
getTime(java.lang.String columnName) |
Get the value of a column in the current row as a java.sql.Time object.
|
java.sql.Time |
getTime(java.lang.String columnName,
java.util.Calendar cal) |
Get the value of a column in the current row as a java.sql.Time
object.
|
java.sql.Timestamp |
getTimestamp(int columnIndex) |
Get the value of a column in the current row as a java.sql.Timestamp object.
|
java.sql.Timestamp |
getTimestamp(int columnIndex,
java.util.Calendar cal) |
Get the value of a column in the current row as a java.sql.Timestamp
object.
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnName) |
Get the value of a column in the current row as a java.sql.Timestamp object.
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnName,
java.util.Calendar cal) |
Get the value of a column in the current row as a java.sql.Timestamp
object.
|
java.io.InputStream |
getUnicodeStream(int columnIndex) |
Deprecated.
|
java.io.InputStream |
getUnicodeStream(java.lang.String columnName) |
Deprecated.
|
java.net.URL |
getURL(int columnIndex) |
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.net.URL
object in the Java programming language. |
java.net.URL |
getURL(java.lang.String columnName) |
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.net.URL
object in the Java programming language. |
java.sql.SQLWarning |
getWarnings() |
The first warning reported by calls on this ResultSet is
returned.
|
void |
insertRow() |
Inserts the contents of the insert row into this
ResultSet objaect and into the database. |
boolean |
isAfterLast() |
Determine if the cursor is after the last row in the result
set.
|
boolean |
isBeforeFirst() |
Determine if the cursor is before the first row in the result
set.
|
boolean |
isClosed() |
Retrieves whether this
ResultSet object has been closed. |
boolean |
isFirst() |
Determine if the cursor is on the first row of the result set.
|
boolean |
isLast() |
Determine if the cursor is on the last row of the result set.
|
boolean |
isWrapperFor(java.lang.Class<?> iface) |
Returns true if this either implements the interface argument or is directly or indirectly a wrapper
for an object that does.
|
boolean |
last() |
Moves to the last row in the result set.
|
void |
moveToCurrentRow() |
Move the cursor to the remembered cursor position, usually the
current row.
|
void |
moveToInsertRow() |
Move to the insert row.
|
boolean |
next() |
A ResultSet is initially positioned before its first row; the
first call to next makes the first row the current row; the
second call makes the second row the current row, etc.
|
boolean |
previous() |
Moves to the previous row in the result set.
|
void |
refreshRow() |
Refresh the value of the current row with its current value in
the database.
|
boolean |
relative(int rows) |
Moves a relative number of rows, either positive or negative.
|
boolean |
rowDeleted() |
Determine if this row has been deleted.
|
boolean |
rowInserted() |
Determine if the current row has been inserted.
|
boolean |
rowUpdated() |
Determine if the current row has been updated.
|
<T> T |
unwrap(java.lang.Class<T> iface) |
Returns an object that implements the given interface to allow access to
non-standard methods, or standard methods not exposed by the proxy.
|
void |
updateArray(int columnIndex,
java.sql.Array x) |
Updates the designated column with a
java.sql.Array value. |
void |
updateArray(java.lang.String columnName,
java.sql.Array x) |
Updates the designated column with a
java.sql.Array value. |
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x) |
Updates the designated column with an ascii stream value.
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length) |
Update a column with an ascii stream value.
|
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length) |
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x) |
Updates the designated column with an ascii stream value.
|
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length) |
Update a column with an ascii stream value.
|
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
long length) |
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal x) |
Update a column with a BigDecimal value.
|
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x) |
Update a column with a BigDecimal value.
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x) |
Updates the designated column with a binary stream value.
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length) |
Update a column with a binary stream value.
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length) |
Updates the designated column with a binary stream value, which will have
the specified number of bytes.
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x) |
Updates the designated column with a binary stream value.
|
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length) |
Update a column with a binary stream value.
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
long length) |
Updates the designated column with a binary stream value, which will have
the specified number of bytes.
|
void |
updateBlob(int columnIndex,
java.io.InputStream inputStream) |
Updates the designated column using the given input stream.
|
void |
updateBlob(int columnIndex,
java.io.InputStream inputStream,
long length) |
Updates the designated column using the given input stream, which
will have the specified number of bytes.
|
void |
updateBlob(int columnIndex,
java.sql.Blob x) |
Updates the designated column with a
java.sql.Blob value. |
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream) |
Updates the designated column using the given input stream.
|
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream,
long length) |
Updates the designated column using the given input stream, which
will have the specified number of bytes.
|
void |
updateBlob(java.lang.String columnName,
java.sql.Blob x) |
Updates the designated column with a
java.sql.Blob value. |
void |
updateBoolean(int columnIndex,
boolean x) |
Update a column with a boolean value.
|
void |
updateBoolean(java.lang.String columnName,
boolean x) |
Update a column with a boolean value.
|
void |
updateByte(int columnIndex,
byte x) |
Update a column with a byte value.
|
void |
updateByte(java.lang.String columnName,
byte x) |
Update a column with a byte value.
|
void |
updateBytes(int columnIndex,
byte[] x) |
Update a column with a byte array value.
|
void |
updateBytes(java.lang.String columnName,
byte[] x) |
Update a column with a byte array value.
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x) |
Updates the designated column with a character stream value.
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
int length) |
Update a column with a character stream value.
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
long length) |
Updates the designated column with a character stream value, which will have
the specified number of bytes.
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader) |
Updates the designated column with a character stream value.
|
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader x,
int length) |
Update a column with a character stream value.
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length) |
Updates the designated column with a character stream value, which will have
the specified number of bytes.
|
void |
updateClob(int columnIndex,
java.io.Reader reader) |
Updates the designated column using the given
Reader
object. |
void |
updateClob(int columnIndex,
java.io.Reader reader,
long length) |
Updates the designated column using the given
Reader
object, which is the given number of characters long. |
void |
updateClob(int columnIndex,
java.sql.Clob x) |
Updates the designated column with a
java.sql.Clob value. |
void |
updateClob(java.lang.String columnLabel,
java.io.Reader reader) |
Updates the designated column using the given
Reader
object. |
void |
updateClob(java.lang.String columnLabel,
java.io.Reader reader,
long length) |
Updates the designated column using the given
Reader
object, which is the given number of characters long. |
void |
updateClob(java.lang.String columnName,
java.sql.Clob x) |
Updates the designated column with a
java.sql.Clob value. |
void |
updateDate(int columnIndex,
java.sql.Date x) |
Update a column with a Date value.
|
void |
updateDate(java.lang.String columnName,
java.sql.Date x) |
Update a column with a Date value.
|
void |
updateDouble(int columnIndex,
double x) |
Update a column with a Double value.
|
void |
updateDouble(java.lang.String columnName,
double x) |
Update a column with a double value.
|
void |
updateFloat(int columnIndex,
float x) |
Update a column with a float value.
|
void |
updateFloat(java.lang.String columnName,
float x) |
Update a column with a float value.
|
void |
updateInt(int columnIndex,
int x) |
Update a column with an integer value.
|
void |
updateInt(java.lang.String columnName,
int x) |
Update a column with an integer value.
|
void |
updateLong(int columnIndex,
long x) |
Update a column with a long value.
|
void |
updateLong(java.lang.String columnName,
long x) |
Update a column with a long value.
|
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x) |
Updates the designated column with a character stream value.
|
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x,
long length) |
Updates the designated column with a character stream value, which will have
the specified number of bytes.
|
void |
updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader) |
Updates the designated column with a character stream value.
|
void |
updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length) |
Updates the designated column with a character stream value, which will have
the specified number of bytes.
|
void |
updateNClob(int columnIndex,
java.io.Reader reader) |
Updates the designated column using the given
Reader
The data will be read from the stream
as needed until end-of-stream is reached. |
void |
updateNClob(int columnIndex,
java.io.Reader reader,
long length) |
Updates the designated column using the given
Reader
object, which is the given number of characters long. |
void |
updateNClob(int columnIndex,
java.sql.NClob nClob) |
Updates the designated column with a
java.sql.NClob value. |
void |
updateNClob(java.lang.String columnLabel,
java.io.Reader reader) |
Updates the designated column using the given
Reader
object. |
void |
updateNClob(java.lang.String columnLabel,
java.io.Reader reader,
long length) |
Updates the designated column using the given
Reader
object, which is the given number of characters long. |
void |
updateNClob(java.lang.String columnLabel,
java.sql.NClob nClob) |
Updates the designated column with a
java.sql.NClob value. |
void |
updateNString(int columnIndex,
java.lang.String nString) |
Updates the designated column with a
String value. |
void |
updateNString(java.lang.String columnLabel,
java.lang.String nString) |
Updates the designated column with a
String value. |
void |
updateNull(int columnIndex) |
Give a nullable column a null value.
|
void |
updateNull(java.lang.String columnName) |
Update a column with a null value.
|
void |
updateObject(int columnIndex,
java.lang.Object x) |
Update a column with an Object value.
|
void |
updateObject(int columnIndex,
java.lang.Object x,
int scale) |
Update a column with an Object value.
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x) |
Update a column with an Object value.
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int scale) |
Update a column with an Object value.
|
void |
updateRef(int columnIndex,
java.sql.Ref x) |
Updates the designated column with a
java.sql.Ref value. |
void |
updateRef(java.lang.String columnName,
java.sql.Ref x) |
Updates the designated column with a
java.sql.Ref value. |
void |
updateRow() |
Update the underlying database with the new contents of the
current row.
|
void |
updateRowId(int columnIndex,
java.sql.RowId x) |
Updates the designated column with a
RowId value. |
void |
updateRowId(java.lang.String columnLabel,
java.sql.RowId x) |
Updates the designated column with a
RowId value. |
void |
updateShort(int columnIndex,
short x) |
Update a column with a short value.
|
void |
updateShort(java.lang.String columnName,
short x) |
Update a column with a short value.
|
void |
updateSQLXML(int columnIndex,
java.sql.SQLXML xmlObject) |
Updates the designated column with a
java.sql.SQLXML value. |
void |
updateSQLXML(java.lang.String columnLabel,
java.sql.SQLXML xmlObject) |
Updates the designated column with a
java.sql.SQLXML value. |
void |
updateString(int columnIndex,
java.lang.String x) |
Update a column with a String value.
|
void |
updateString(java.lang.String columnName,
java.lang.String x) |
Update a column with a String value.
|
void |
updateTime(int columnIndex,
java.sql.Time x) |
Update a column with a Time value.
|
void |
updateTime(java.lang.String columnName,
java.sql.Time x) |
Update a column with a Time value.
|
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x) |
Update a column with a Timestamp value.
|
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x) |
Update a column with a Timestamp value.
|
boolean |
wasNull() |
A column may have the value of SQL NULL; wasNull reports whether
the last column read had this special value.
|
addRowSetListener, clearParameters, getCommand, getConcurrency, getDataSourceName, getEscapeProcessing, getFetchDirection, getFetchSize, getMaxFieldSize, getMaxRows, getParam, getParams, getPassword, getQueryTimeout, getTransactionIsolation, getType, getTypeMap, getUrl, getUsername, isReadOnly, notifyListener, removeRowSetListener, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBlob, setBlob, setBlob, setBoolean, setBoolean, setByte, setByte, setBytes, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setClob, setClob, setClob, setCommand, setConcurrency, setDataSourceName, setDate, setDate, setDate, setDate, setDouble, setDouble, setEscapeProcessing, setFetchDirection, setFetchSize, setFloat, setFloat, setInt, setInt, setLong, setLong, setMaxFieldSize, setMaxRows, setNCharacterStream, setNCharacterStream, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNClob, setNClob, setNClob, setNString, setNString, setNull, setNull, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setObject, setPassword, setQueryTimeout, setReadOnly, setRef, setRowId, setRowId, setShort, setShort, setSQLXML, setSQLXML, setString, setString, setTime, setTime, setTime, setTime, setTimestamp, setTimestamp, setTimestamp, setTimestamp, setTransactionIsolation, setType, setTypeMap, setUnicodeStream, setUrl, setURL, setUsernamepublic void finalize()
throws java.lang.Throwable
finalize in class java.lang.Objectjava.lang.Throwablepublic void execute()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occurs.public void execute(java.sql.Connection _conn)
throws java.sql.SQLException
_conn - a Connection to usejava.sql.SQLException - if a database-access error occurs.public void close()
throws java.sql.SQLException
Note: A ResultSet is automatically closed by the Statement that generated it when that Statement is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results. A ResultSet is also automatically closed when it is garbage collected.
close in class BaseRowSetjava.sql.SQLException - if a database-access error occurs.public void cancelRowUpdates()
throws java.sql.SQLException
java.sql.SQLException - if an error occurs.public boolean next()
throws java.sql.SQLException
If an input stream from the previous row is open, it is implicitly closed. The ResultSet's warning chain is cleared when a new row is read.
java.sql.SQLException - if a database-access error occurs.public boolean previous()
throws java.sql.SQLException
Moves to the previous row in the result set.
Note: previous() is not the same as relative(-1) since it makes sense to call previous() when there is no current row.
java.sql.SQLException - if a database-access error occurs, or
result set type is TYPE_FORWAR_DONLY.public boolean first()
throws java.sql.SQLException
Moves to the first row in the result set.
java.sql.SQLException - if a database-access error occurs, or
result set type is TYPE_FORWARD_ONLY.public boolean last()
throws java.sql.SQLException
Moves to the last row in the result set.
java.sql.SQLException - if a database-access error occurs, or
result set type is TYPE_FORWARD_ONLY.public boolean absolute(int row)
throws java.sql.SQLException
Move to an absolute row number in the result set.
If row is positive, moves to an absolute row with respect to the beginning of the result set. The first row is row 1, the second is row 2, etc.
If row is negative, moves to an absolute row position with respect to the end of result set. For example, calling absolute(-1) positions the cursor on the last row, absolute(-2) indicates the next-to-last row, etc.
An attempt to position the cursor beyond the first/last row in the result set, leaves the cursor before/after the first/last row, respectively.
Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().
java.sql.SQLException - if a database-access error occurs, or
row is 0, or result set type is TYPE_FORWARD_ONLY.public boolean relative(int rows)
throws java.sql.SQLException
Moves a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the result set positions the cursor before/after the the first/last row. Calling relative(0) is valid, but does not change the cursor position.
Note: Calling relative(1) is different than calling next() since is makes sense to call next() when there is no current row, for example, when the cursor is positioned before the first row or after the last row of the result set.
java.sql.SQLException - if a database-access error occurs, or there
is no current row, or result set type is TYPE_FORWARD_ONLY.public void beforeFirst()
throws java.sql.SQLException
Moves to the front of the result set, just before the first row. Has no effect if the result set contains no rows.
java.sql.SQLException - if a database-access error occurs, or
result set type is TYPE_FORWARD_ONLYpublic void afterLast()
throws java.sql.SQLException
Moves to the end of the result set, just after the last row. Has no effect if the result set contains no rows.
java.sql.SQLException - if a database-access error occurs, or
result set type is TYPE_FORWARD_ONLY.public boolean isBeforeFirst()
throws java.sql.SQLException
Determine if the cursor is before the first row in the result set.
java.sql.SQLException - if a database-access error occurs.public boolean isAfterLast()
throws java.sql.SQLException
Determine if the cursor is after the last row in the result set.
java.sql.SQLException - if a database-access error occurs.public boolean isFirst()
throws java.sql.SQLException
Determine if the cursor is on the first row of the result set.
java.sql.SQLException - if a database-access error occurs.public boolean isLast()
throws java.sql.SQLException
Determine if the cursor is on the last row of the result set. Note: Calling isLast() may be expensive since the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.
java.sql.SQLException - if a database-access error occurs.public int getRow()
throws java.sql.SQLException
Determine the current row number. The first row is number 1, the second number 2, etc.
java.sql.SQLException - if a database-access error occurs.public boolean rowUpdated()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occursDatabaseMetaData.updatesAreDetected(int)public boolean rowInserted()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occursDatabaseMetaData.insertsAreDetected(int)public boolean rowDeleted()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occursDatabaseMetaData.deletesAreDetected(int)public void refreshRow()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occurs, or if
called when on the insert row.public void insertRow()
throws java.sql.SQLException
ResultSet objaect and into the database.
The cursor must be on the insert row when this method is called.java.sql.SQLException - if a database access error occurs,
if this method is called when the cursor is not on the insert row,
or if not all of non-nullable columns in
the insert row have been given a valuepublic void updateRow()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occurs, or
if called when on the insert rowpublic void deleteRow()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occurs, or if
called when on the insert row.public void moveToInsertRow()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occurs,
or the result set is not updatablepublic void moveToCurrentRow()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occurs,
or the result set is not updatablepublic boolean wasNull()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occurs.public java.sql.SQLWarning getWarnings()
throws java.sql.SQLException
The first warning reported by calls on this ResultSet is returned. Subsequent ResultSet warnings will be chained to this SQLWarning.
The warning chain is automatically cleared each time a new row is read.
Note: This warning chain only covers warnings caused by ResultSet methods. Any warning caused by statement methods (such as reading OUT parameters) will be chained on the Statement object.
java.sql.SQLException - if a database-access error occurs.public void clearWarnings()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occurs.public java.lang.String getCursorName()
throws java.sql.SQLException
java.sql.SQLException - if an error occurs.public java.sql.ResultSetMetaData getMetaData()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occurs.public int findColumn(java.lang.String columnName)
throws java.sql.SQLException
columnName - the name of the columnjava.sql.SQLException - if a database-access error occurs.public java.lang.String getString(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public boolean getBoolean(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public byte getByte(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public short getShort(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public int getInt(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public long getLong(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public float getFloat(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public double getDouble(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.math.BigDecimal getBigDecimal(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.math.BigDecimal getBigDecimal(int columnIndex,
int scale)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...scale - the number of digits to the right of the decimaljava.sql.SQLException - if a database-access error occurs.public byte[] getBytes(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.sql.Date getDate(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.sql.Time getTime(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.sql.Timestamp getTimestamp(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.io.InputStream getAsciiStream(int columnIndex)
throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. . Also, a stream may return 0 for available() whether there is data available or not.
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.io.InputStream getUnicodeStream(int columnIndex)
throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. . Also, a stream may return 0 for available() whether there is data available or not.
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.io.InputStream getBinaryStream(int columnIndex)
throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not.
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.lang.Object getObject(int columnIndex)
throws java.sql.SQLException
Get the value of a column in the current row as a Java object.
This method will return the value of the given column as a Java object. The type of the Java object will be the default Java object type corresponding to the column SQL type, following the mapping for built-in types specified in the JDBC spec.
This method may also be used to read database specific abstract data types. JDBC 2.0 New behavior for getObject(). The behavior of method getObject() is extended to materialize data of SQL user-defined types. When the column @column is a structured or distinct value, the behavior of this method is as if it were a call to: getObject(column, this.getStatement().getConnection().getTypeMap()).
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.public java.lang.String getString(java.lang.String columnName)
throws java.sql.SQLException
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public boolean getBoolean(java.lang.String columnName)
throws java.sql.SQLException
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public byte getByte(java.lang.String columnName)
throws java.sql.SQLException
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public short getShort(java.lang.String columnName)
throws java.sql.SQLException
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public int getInt(java.lang.String columnName)
throws java.sql.SQLException
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public long getLong(java.lang.String columnName)
throws java.sql.SQLException
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public float getFloat(java.lang.String columnName)
throws java.sql.SQLException
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public double getDouble(java.lang.String columnName)
throws java.sql.SQLException
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public java.math.BigDecimal getBigDecimal(java.lang.String columnName,
int scale)
throws java.sql.SQLException
columnName - is the SQL name of the columnscale - the number of digits to the right of the decimaljava.sql.SQLException - if a database-access error occurs.public byte[] getBytes(java.lang.String columnName)
throws java.sql.SQLException
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public java.sql.Date getDate(java.lang.String columnName)
throws java.sql.SQLException
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public java.sql.Time getTime(java.lang.String columnName)
throws java.sql.SQLException
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public java.sql.Timestamp getTimestamp(java.lang.String columnName)
throws java.sql.SQLException
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public java.io.InputStream getAsciiStream(java.lang.String columnName)
throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public java.io.InputStream getUnicodeStream(java.lang.String columnName)
throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public java.io.InputStream getBinaryStream(java.lang.String columnName)
throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public java.lang.Object getObject(java.lang.String columnName)
throws java.sql.SQLException
Get the value of a column in the current row as a Java object.
This method will return the value of the given column as a Java object. The type of the Java object will be the default Java object type corresponding to the column SQL type, following the mapping for built-in types specified in the JDBC spec.
This method may also be used to read database specific abstract data types. JDBC 2.0 New behavior for getObject(). The behavior of method getObject() is extended to materialize data of SQL user-defined types. When the column @columnName is a structured or distinct value, the behavior of this method is as if it were a call to: getObject(columnName, this.getStatement().getConnection().getTypeMap()).
columnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public java.io.Reader getCharacterStream(int columnIndex)
throws java.sql.SQLException
Get the value of a column in the current row as a java.io.Reader.
java.sql.SQLExceptionpublic java.io.Reader getCharacterStream(java.lang.String columnName)
throws java.sql.SQLException
Get the value of a column in the current row as a java.io.Reader.
java.sql.SQLExceptionpublic java.math.BigDecimal getBigDecimal(java.lang.String columnName)
throws java.sql.SQLException
java.sql.SQLExceptionpublic void updateNull(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurspublic void updateBoolean(int columnIndex,
boolean x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateByte(int columnIndex,
byte x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateShort(int columnIndex,
short x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateInt(int columnIndex,
int x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateLong(int columnIndex,
long x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateFloat(int columnIndex,
float x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateDouble(int columnIndex,
double x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateString(int columnIndex,
java.lang.String x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateBytes(int columnIndex,
byte[] x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateDate(int columnIndex,
java.sql.Date x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateTime(int columnIndex,
java.sql.Time x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateTimestamp(int columnIndex,
java.sql.Timestamp x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if a database-access error occurspublic void updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if a database-access error occurspublic void updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if a database-access error occurspublic void updateObject(int columnIndex,
java.lang.Object x,
int scale)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuescale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types
this is the number of digits after the decimal. For all other
types this value will be ignored.java.sql.SQLException - if a database-access error occurspublic void updateObject(int columnIndex,
java.lang.Object x)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateNull(java.lang.String columnName)
throws java.sql.SQLException
columnName - the name of the columnjava.sql.SQLException - if a database-access error occurspublic void updateBoolean(java.lang.String columnName,
boolean x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateByte(java.lang.String columnName,
byte x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateShort(java.lang.String columnName,
short x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateInt(java.lang.String columnName,
int x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateLong(java.lang.String columnName,
long x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateFloat(java.lang.String columnName,
float x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateDouble(java.lang.String columnName,
double x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateString(java.lang.String columnName,
java.lang.String x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateBytes(java.lang.String columnName,
byte[] x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateDate(java.lang.String columnName,
java.sql.Date x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateTime(java.lang.String columnName,
java.sql.Time x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuelength - of the streamjava.sql.SQLException - if a database-access error occurspublic void updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuelength - of the streamjava.sql.SQLException - if a database-access error occurspublic void updateCharacterStream(java.lang.String columnName,
java.io.Reader x,
int length)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuelength - of the streamjava.sql.SQLException - if a database-access error occurspublic void updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuescale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types
this is the number of digits after the decimal. For all other
types this value will be ignored.java.sql.SQLException - if a database-access error occurspublic void updateObject(java.lang.String columnName,
java.lang.Object x)
throws java.sql.SQLException
columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic java.sql.Statement getStatement()
throws java.sql.SQLException
java.sql.SQLException - if a database-access error occurspublic java.lang.Object getObject(int colIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
colIndex - the first column is 1, the second is 2, ...map - the mapping from SQL type names to Java classesjava.sql.SQLExceptionpublic java.sql.Ref getRef(int colIndex)
throws java.sql.SQLException
colIndex - the first column is 1, the second is 2, ...java.sql.SQLExceptionpublic java.sql.Blob getBlob(int colIndex)
throws java.sql.SQLException
colIndex - the first column is 1, the second is 2, ...java.sql.SQLExceptionpublic java.sql.Clob getClob(int colIndex)
throws java.sql.SQLException
colIndex - the first column is 1, the second is 2, ...java.sql.SQLExceptionpublic java.sql.Array getArray(int colIndex)
throws java.sql.SQLException
colIndex - the first column is 1, the second is 2, ...java.sql.SQLExceptionpublic java.lang.Object getObject(java.lang.String colName,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
colName - the column namemap - the mapping from SQL type names to Java classesjava.sql.SQLExceptionpublic java.sql.Ref getRef(java.lang.String colName)
throws java.sql.SQLException
colName - the column namejava.sql.SQLExceptionpublic java.sql.Blob getBlob(java.lang.String colName)
throws java.sql.SQLException
colName - the column namejava.sql.SQLExceptionpublic java.sql.Clob getClob(java.lang.String colName)
throws java.sql.SQLException
colName - the column namejava.sql.SQLExceptionpublic java.sql.Array getArray(java.lang.String colName)
throws java.sql.SQLException
colName - the column namejava.sql.SQLExceptionpublic java.sql.Date getDate(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...cal - the calendar to use in constructing the datejava.sql.SQLException - if a database-access error occurs.public java.sql.Date getDate(java.lang.String columnName,
java.util.Calendar cal)
throws java.sql.SQLException
columnName - is the SQL name of the columncal - the calendar to use in constructing the datejava.sql.SQLException - if a database-access error occurs.public java.sql.Time getTime(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...cal - the calendar to use in constructing the timejava.sql.SQLException - if a database-access error occurs.public java.sql.Time getTime(java.lang.String columnName,
java.util.Calendar cal)
throws java.sql.SQLException
columnName - is the SQL name of the columncal - the calendar to use in constructing the timejava.sql.SQLException - if a database-access error occurs.public java.sql.Timestamp getTimestamp(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...cal - the calendar to use in constructing the timestampjava.sql.SQLException - if a database-access error occurs.public java.sql.Timestamp getTimestamp(java.lang.String columnName,
java.util.Calendar cal)
throws java.sql.SQLException
columnName - is the SQL name of the columncal - the calendar to use in constructing the timestampjava.sql.SQLException - if a database-access error occurs.public java.net.URL getURL(int columnIndex)
throws java.sql.SQLException
ResultSet object as a java.net.URL
object in the Java programming language.columnIndex - the index of the column 1 is the first, 2 is the second,...java.net.URL object;
if the value is SQL NULL,
the value returned is null in the Java programming languagejava.sql.SQLException - if a database access error occurs,
or if a URL is malformedpublic java.net.URL getURL(java.lang.String columnName)
throws java.sql.SQLException
ResultSet object as a java.net.URL
object in the Java programming language.columnName - the SQL name of the columnjava.net.URL object;
if the value is SQL NULL,
the value returned is null in the Java programming languagejava.sql.SQLException - if a database access error occurs
or if a URL is malformedpublic void updateRef(int columnIndex,
java.sql.Ref x)
throws java.sql.SQLException
java.sql.Ref value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database access error occurspublic void updateRef(java.lang.String columnName,
java.sql.Ref x)
throws java.sql.SQLException
java.sql.Ref value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database access error occurspublic void updateBlob(int columnIndex,
java.sql.Blob x)
throws java.sql.SQLException
java.sql.Blob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database access error occurspublic void updateBlob(java.lang.String columnName,
java.sql.Blob x)
throws java.sql.SQLException
java.sql.Blob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database access error occurspublic void updateClob(int columnIndex,
java.sql.Clob x)
throws java.sql.SQLException
java.sql.Clob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database access error occurspublic void updateClob(java.lang.String columnName,
java.sql.Clob x)
throws java.sql.SQLException
java.sql.Clob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database access error occurspublic void updateArray(int columnIndex,
java.sql.Array x)
throws java.sql.SQLException
java.sql.Array value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database access error occurspublic void updateArray(java.lang.String columnName,
java.sql.Array x)
throws java.sql.SQLException
java.sql.Array value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.columnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database access error occurspublic java.sql.RowId getRowId(int columnIndex)
throws java.sql.SQLException
ResultSet object as a java.sql.RowId object in the Java
programming language.columnIndex - the first column is 1, the second 2, ...NULL the
value returned is nulljava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.sql.RowId getRowId(java.lang.String columnLabel)
throws java.sql.SQLException
ResultSet object as a java.sql.RowId object in the Java
programming language.columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnNULL the
value returned is nulljava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateRowId(int columnIndex,
java.sql.RowId x)
throws java.sql.SQLException
RowId value. The updater
methods are used to update column values in the current row or the insert
row. The updater methods do not update the underlying database; instead
the updateRow or insertRow methods are called
to update the database.columnIndex - the first column is 1, the second 2, ...x - the column valuejava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateRowId(java.lang.String columnLabel,
java.sql.RowId x)
throws java.sql.SQLException
RowId value. The updater
methods are used to update column values in the current row or the insert
row. The updater methods do not update the underlying database; instead
the updateRow or insertRow methods are called
to update the database.columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx - the column valuejava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic int getHoldability()
throws java.sql.SQLException
ResultSet objectResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMITjava.sql.SQLException - if a database access error occurs
or this method is called on a closed result setpublic boolean isClosed()
throws java.sql.SQLException
ResultSet object has been closed. A ResultSet is closed if the
method close has been called on it, or if it is automatically closed.ResultSet object is closed; false if it is still openjava.sql.SQLException - if a database access error occurspublic void updateNString(int columnIndex,
java.lang.String nString)
throws java.sql.SQLException
String value.
It is intended for use when updating NCHAR,NVARCHAR
and LONGNVARCHAR columns.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.columnIndex - the first column is 1, the second 2, ...nString - the value for the column to be updatedjava.sql.SQLException - if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set;
the result set concurrency is CONCUR_READ_ONLY
or if a database access error occursjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateNString(java.lang.String columnLabel,
java.lang.String nString)
throws java.sql.SQLException
String value.
It is intended for use when updating NCHAR,NVARCHAR
and LONGNVARCHAR columns.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnnString - the value for the column to be updatedjava.sql.SQLException - if the columnLabel is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set;
the result set concurrency is CONCUR_READ_ONLY
or if a database access error occursjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateNClob(int columnIndex,
java.sql.NClob nClob)
throws java.sql.SQLException
java.sql.NClob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.columnIndex - the first column is 1, the second 2, ...nClob - the value for the column to be updatedjava.sql.SQLException - if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set;
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLYjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateNClob(java.lang.String columnLabel,
java.sql.NClob nClob)
throws java.sql.SQLException
java.sql.NClob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnnClob - the value for the column to be updatedjava.sql.SQLException - if the columnLabel is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set;
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLYjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.sql.NClob getNClob(int columnIndex)
throws java.sql.SQLException
ResultSet object as a NClob object
in the Java programming language.columnIndex - the first column is 1, the second is 2, ...NClob object representing the SQL
NCLOB value in the specified columnjava.sql.SQLException - if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set
or if a database access error occursjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.sql.NClob getNClob(java.lang.String columnLabel)
throws java.sql.SQLException
ResultSet object as a NClob object
in the Java programming language.columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnNClob object representing the SQL NCLOB
value in the specified columnjava.sql.SQLException - if the columnLabel is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set
or if a database access error occursjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.sql.SQLXML getSQLXML(int columnIndex)
throws java.sql.SQLException
ResultSet as a
java.sql.SQLXML object in the Java programming language.columnIndex - the first column is 1, the second is 2, ...SQLXML object that maps an SQL XML valuejava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.sql.SQLXML getSQLXML(java.lang.String columnLabel)
throws java.sql.SQLException
ResultSet as a
java.sql.SQLXML object in the Java programming language.columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnSQLXML object that maps an SQL XML valuejava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateSQLXML(int columnIndex,
java.sql.SQLXML xmlObject)
throws java.sql.SQLException
java.sql.SQLXML value.
The updater
methods are used to update column values in the current row or the insert
row. The updater methods do not update the underlying database; instead
the updateRow or insertRow methods are called
to update the database.
columnIndex - the first column is 1, the second 2, ...xmlObject - the value for the column to be updatedjava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs; this method
is called on a closed result set;
the java.xml.transform.Result,
Writer or OutputStream has not been closed
for the SQLXML object;
if there is an error processing the XML value or
the result set concurrency is CONCUR_READ_ONLY. The getCause method
of the exception may provide a more detailed exception, for example, if the
stream does not contain valid XML.java.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateSQLXML(java.lang.String columnLabel,
java.sql.SQLXML xmlObject)
throws java.sql.SQLException
java.sql.SQLXML value.
The updater
methods are used to update column values in the current row or the insert
row. The updater methods do not update the underlying database; instead
the updateRow or insertRow methods are called
to update the database.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnxmlObject - the column valuejava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs; this method
is called on a closed result set;
the java.xml.transform.Result,
Writer or OutputStream has not been closed
for the SQLXML object;
if there is an error processing the XML value or
the result set concurrency is CONCUR_READ_ONLY. The getCause method
of the exception may provide a more detailed exception, for example, if the
stream does not contain valid XML.java.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.lang.String getNString(int columnIndex)
throws java.sql.SQLException
ResultSet object as
a String in the Java programming language.
It is intended for use when
accessing NCHAR,NVARCHAR
and LONGNVARCHAR columns.columnIndex - the first column is 1, the second is 2, ...NULL, the
value returned is nulljava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.lang.String getNString(java.lang.String columnLabel)
throws java.sql.SQLException
ResultSet object as
a String in the Java programming language.
It is intended for use when
accessing NCHAR,NVARCHAR
and LONGNVARCHAR columns.columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnNULL, the
value returned is nulljava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.io.Reader getNCharacterStream(int columnIndex)
throws java.sql.SQLException
ResultSet object as a
java.io.Reader object.
It is intended for use when
accessing NCHAR,NVARCHAR
and LONGNVARCHAR columns.columnIndex - the first column is 1, the second is 2, ...java.io.Reader object that contains the column
value; if the value is SQL NULL, the value returned is
null in the Java programming language.java.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic java.io.Reader getNCharacterStream(java.lang.String columnLabel)
throws java.sql.SQLException
ResultSet object as a
java.io.Reader object.
It is intended for use when
accessing NCHAR,NVARCHAR
and LONGNVARCHAR columns.columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnjava.io.Reader object that contains the column
value; if the value is SQL NULL, the value returned is
null in the Java programming languagejava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateNCharacterStream(int columnIndex,
java.io.Reader x,
long length)
throws java.sql.SQLException
NCHAR,NVARCHAR
and LONGNVARCHAR columns.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length)
throws java.sql.SQLException
NCHAR,NVARCHAR
and LONGNVARCHAR columns.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader - the java.io.Reader object containing
the new column valuelength - the length of the streamjava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateCharacterStream(int columnIndex,
java.io.Reader x,
long length)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx - the new column valuelength - the length of the streamjava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
long length)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx - the new column valuelength - the length of the streamjava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader,
long length)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader - the java.io.Reader object containing
the new column valuelength - the length of the streamjava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateBlob(int columnIndex,
java.io.InputStream inputStream,
long length)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnIndex - the first column is 1, the second is 2, ...inputStream - An object that contains the data to set the parameter
value to.length - the number of bytes in the parameter data.java.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream,
long length)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columninputStream - An object that contains the data to set the parameter
value to.length - the number of bytes in the parameter data.java.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateClob(int columnIndex,
java.io.Reader reader,
long length)
throws java.sql.SQLException
Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader object. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnIndex - the first column is 1, the second is 2, ...reader - An object that contains the data to set the parameter value to.length - the number of characters in the parameter data.java.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateClob(java.lang.String columnLabel,
java.io.Reader reader,
long length)
throws java.sql.SQLException
Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader object. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader - An object that contains the data to set the parameter value to.length - the number of characters in the parameter data.java.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateNClob(int columnIndex,
java.io.Reader reader,
long length)
throws java.sql.SQLException
Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader object. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnIndex - the first column is 1, the second 2, ...reader - An object that contains the data to set the parameter value to.length - the number of characters in the parameter data.java.sql.SQLException - if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set,
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLYjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateNClob(java.lang.String columnLabel,
java.io.Reader reader,
long length)
throws java.sql.SQLException
Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader object. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader - An object that contains the data to set the parameter value to.length - the number of characters in the parameter data.java.sql.SQLException - if the columnLabel is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set;
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLYjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateNCharacterStream(int columnIndex,
java.io.Reader x)
throws java.sql.SQLException
NCHAR,NVARCHAR
and LONGNVARCHAR columns.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateNCharacterStream which takes a length parameter.
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateNCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
NCHAR,NVARCHAR
and LONGNVARCHAR columns.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateNCharacterStream which takes a length parameter.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader - the java.io.Reader object containing
the new column valuejava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateAsciiStream(int columnIndex,
java.io.InputStream x)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateAsciiStream which takes a length parameter.
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateBinaryStream(int columnIndex,
java.io.InputStream x)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateBinaryStream which takes a length parameter.
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateCharacterStream(int columnIndex,
java.io.Reader x)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateCharacterStream which takes a length parameter.
columnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateAsciiStream which takes a length parameter.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx - the new column valuejava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateBinaryStream which takes a length parameter.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnx - the new column valuejava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateCharacterStream which takes a length parameter.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader - the java.io.Reader object containing
the new column valuejava.sql.SQLException - if the columnLabel is not valid; if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateBlob(int columnIndex,
java.io.InputStream inputStream)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateBlob which takes a length parameter.
columnIndex - the first column is 1, the second is 2, ...inputStream - An object that contains the data to set the parameter
value to.java.sql.SQLException - if the columnIndex is not valid; if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateBlob(java.lang.String columnLabel,
java.io.InputStream inputStream)
throws java.sql.SQLException
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateBlob which takes a length parameter.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columninputStream - An object that contains the data to set the parameter
value to.java.sql.SQLException - if the columnLabel is not valid; if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateClob(int columnIndex,
java.io.Reader reader)
throws java.sql.SQLException
Reader
object.
The data will be read from the stream
as needed until end-of-stream is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateClob which takes a length parameter.
columnIndex - the first column is 1, the second is 2, ...reader - An object that contains the data to set the parameter value to.java.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateClob(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
Reader
object.
The data will be read from the stream
as needed until end-of-stream is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateClob which takes a length parameter.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader - An object that contains the data to set the parameter value to.java.sql.SQLException - if the columnLabel is not valid; if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateNClob(int columnIndex,
java.io.Reader reader)
throws java.sql.SQLException
Reader
The data will be read from the stream
as needed until end-of-stream is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateNClob which takes a length parameter.
columnIndex - the first column is 1, the second 2, ...reader - An object that contains the data to set the parameter value to.java.sql.SQLException - if the columnIndex is not valid;
if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set,
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLYjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic void updateNClob(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
Reader
object.
The data will be read from the stream
as needed until end-of-stream is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
updateNClob which takes a length parameter.
columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the columnreader - An object that contains the data to set the parameter value to.java.sql.SQLException - if the columnLabel is not valid; if the driver does not support national
character sets; if the driver can detect that a data conversion
error could occur; this method is called on a closed result set;
if a database access error occurs or
the result set concurrency is CONCUR_READ_ONLYjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic <T> T unwrap(java.lang.Class<T> iface)
throws java.sql.SQLException
unwrap recursively on the wrapped object
or a proxy for that result. If the receiver is not a
wrapper and does not implement the interface, then an SQLException is thrown.iface - A Class defining an interface that the result must implement.java.sql.SQLException - If no object found that implements the interfacepublic boolean isWrapperFor(java.lang.Class<?> iface)
throws java.sql.SQLException
isWrapperFor on the wrapped
object. If this does not implement the interface and is not a wrapper, return false.
This method should be implemented as a low-cost operation compared to unwrap so that
callers can use this method to avoid expensive unwrap calls that may fail. If this method
returns true then calling unwrap with the same argument should succeed.iface - a Class defining an interface.java.sql.SQLException - if an error occurs while determining whether this is a wrapper
for an object with the given interface.public <T> T getObject(int columnIndex,
java.lang.Class<T> type)
throws java.sql.SQLException
Retrieves the value of the designated column in the current row
of this ResultSet object and will convert from the
SQL type of the column to the requested Java data type, if the
conversion is supported. If the conversion is not
supported or null is specified for the type, a
SQLException is thrown.
At a minimum, an implementation must support the conversions defined in
Appendix B, Table B-3 and conversion of appropriate user defined SQL
types to a Java type which implements SQLData, or Struct.
Additional conversions may be supported and are vendor defined.
columnIndex - the first column is 1, the second is 2, ...type - Class representing the Java data type to convert the designated
column to.type holding the column valuejava.sql.SQLException - if conversion is not supported, type is null or
another error occurs. The getCause() method of the
exception may provide a more detailed exception, for example, if
a conversion error occursjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this methodpublic <T> T getObject(java.lang.String columnLabel,
java.lang.Class<T> type)
throws java.sql.SQLException
Retrieves the value of the designated column in the current row
of this ResultSet object and will convert from the
SQL type of the column to the requested Java data type, if the
conversion is supported. If the conversion is not
supported or null is specified for the type, a
SQLException is thrown.
At a minimum, an implementation must support the conversions defined in
Appendix B, Table B-3 and conversion of appropriate user defined SQL
types to a Java type which implements SQLData, or Struct.
Additional conversions may be supported and are vendor defined.
columnLabel - the label for the column specified with the SQL AS clause.
If the SQL AS clause was not specified, then the label is the name
of the columntype - Class representing the Java data type to convert the designated
column to.type holding the column valuejava.sql.SQLException - if conversion is not supported, type is null or
another error occurs. The getCause() method of the
exception may provide a more detailed exception, for example, if
a conversion error occursjava.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support
this method