java.lang.AutoCloseable, java.sql.ResultSet, java.sql.Wrapperpublic class VirtuosoResultSet
extends java.lang.Object
implements java.sql.ResultSet
ResultSet rs = statement.executeQuery("SELECT * FROM TABLE ...")
ResultSet,
VirtuosoStatement,
VirtuosoPreparedStatement,
VirtuosoCallableStatement| Modifier and Type | Field | Description |
|---|---|---|
static int |
CONCUR_READ_ONLY |
JDBC 2.0 extension.
|
static int |
CONCUR_UPDATABLE |
JDBC 2.0 extension.
|
static int |
CONCUR_VALUES |
|
protected int |
currentRow |
|
static int |
FETCH_FORWARD |
JDBC 2.0 extension.
|
static int |
FETCH_REVERSE |
JDBC 2.0 extension.
|
static int |
FETCH_UNKNOWN |
JDBC 2.0 extension.
|
protected boolean |
isLastResult |
|
protected boolean |
isLastRow |
|
protected VirtuosoResultSetMetaData |
metaData |
|
protected Vector |
rows |
|
protected boolean |
stmt_co_last_in_batch |
|
protected int |
stmt_current_of |
|
protected int |
stmt_n_rows_to_get |
|
protected int |
totalRows |
|
static int |
TYPE_FORWARD_ONLY |
JDBC 2.0 extension.
|
static int |
TYPE_SCROLL_INSENSITIVE |
JDBC 2.0 extension.
|
static int |
TYPE_SCROLL_SENSITIVE |
JDBC 2.0 extension.
|
| Modifier | Constructor | Description |
|---|---|---|
protected |
VirtuosoResultSet(VirtuosoConnection vc,
java.lang.String[] col_names,
int[] col_dtps) |
| Modifier and Type | Method | Description |
|---|---|---|
boolean |
absolute(int row) |
Moves the cursor to the given row number in the result set.
|
void |
afterLast() |
Moves the cursor to the end of the result set, just after the last
row.
|
void |
beforeFirst() |
Moves the cursor to the front of the result set, just before the
first row.
|
void |
cancelRowUpdates() |
Cancels the updates made to a row.
|
void |
clearWarnings() |
Clears all the warnings reported on this ResultSet object.
|
void |
close() |
Releases this ResultSet object's database and
JDBC resources immediately instead of new wait for
this to happen when it is automatically closed.
|
void |
deleteRow() |
Deletes the current row from the result set and the underlying
database.
|
boolean |
equals(java.lang.Object obj) |
Compares two Objects for equality.
|
void |
finalize() |
Method runs when the garbage collector want to erase the object
|
int |
findColumn(java.lang.String name) |
Returns the column number corresponding to the name.
|
boolean |
first() |
Moves the cursor to the first row in the result set.
|
java.sql.Array |
getArray(int i) |
Gets an SQL ARRAY value from the current row of this
ResultSet object. |
java.sql.Array |
getArray(java.lang.String columnName) |
Gets an SQL ARRAY value in the current row of this
ResultSet object. |
java.io.InputStream |
getAsciiStream(int columnIndex) |
Gets the value of a column in the current row as a stream of
ASCII characters.
|
java.io.InputStream |
getAsciiStream(java.lang.String columnName) |
Gets the value of a column in the current row as a stream of
ASCII characters.
|
java.math.BigDecimal |
getBigDecimal(int columnIndex) |
Gets the value of a column in the current row as a java.math.BigDecimal
object with full precision.
|
java.math.BigDecimal |
getBigDecimal(int columnIndex,
int scale) |
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName) |
Gets 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) |
Gets the value of a column in the current row as a stream of
uninterpreted bytes.
|
java.io.InputStream |
getBinaryStream(java.lang.String columnName) |
Gets the value of a column in the current row as a stream of
uninterpreted bytes.
|
java.sql.Blob |
getBlob(int i) |
Gets a BLOB value in the current row of this
ResultSet object. |
java.sql.Blob |
getBlob(java.lang.String columnName) |
Gets a BLOB value in the current row of this
ResultSet object. |
boolean |
getBoolean(int columnIndex) |
Gets the value of a column in the current row as a Java boolean.
|
boolean |
getBoolean(java.lang.String columnName) |
Gets the value of a column in the current row as a Java boolean.
|
byte |
getByte(int columnIndex) |
Gets the value of a column in the current row as a Java byte.
|
byte |
getByte(java.lang.String columnName) |
Gets the value of a column in the current row as a Java byte.
|
byte[] |
getBytes(int columnIndex) |
Gets the value of a column in the current row as a Java byte array.
|
byte[] |
getBytes(java.lang.String columnName) |
Gets the value of a column in the current row as a Java byte array.
|
java.io.Reader |
getCharacterStream(int columnIndex) |
Gets the value of a column in the current row as a java.io.Reader.
|
java.io.Reader |
getCharacterStream(java.lang.String columnName) |
Gets the value of a column in the current row as a java.io.Reader.
|
java.sql.Clob |
getClob(int i) |
Gets a CLOB value in the current row of this
ResultSet object. |
java.sql.Clob |
getClob(java.lang.String columnName) |
Gets a CLOB value in the current row of this
ResultSet object. |
int |
getConcurrency() |
Returns the concurrency mode of this result set.
|
java.lang.String |
getCursorName() |
Gets the name of the SQL cursor used by this ResultSet.
|
java.sql.Date |
getDate(int columnIndex) |
Gets 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) |
Gets the value of a column in the current row as a java.sql.Date
object.
|
java.sql.Date |
getDate(java.lang.String columnName) |
Gets 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) |
Gets the value of a column in the current row as a java.sql.Date
object.
|
double |
getDouble(int columnIndex) |
Gets the value of a column in the current row as a Java double.
|
double |
getDouble(java.lang.String columnName) |
Gets the value of a column in the current row as a Java double.
|
int |
getFetchDirection() |
Retrieves the fetch direction of this result set.
|
int |
getFetchSize() |
Retrieves the number of result set rows that is the default
fetch size for result sets generated from this ResultSet object.
|
float |
getFloat(int columnIndex) |
Gets the value of a column in the current row as a Java float.
|
float |
getFloat(java.lang.String columnName) |
Gets 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) |
Gets the value of a column in the current row as a Java int.
|
int |
getInt(java.lang.String columnName) |
Gets the value of a column in the current row as a Java int.
|
long |
getLong(int columnIndex) |
Gets the value of a column in the current row as a Java long.
|
long |
getLong(java.lang.String columnName) |
Gets the value of a column in the current row as a Java long.
|
java.sql.ResultSetMetaData |
getMetaData() |
Retrieves the number, types and properties of a ResultSet's columns.
|
protected void |
getMoreResults(boolean isPrepare) |
Method uses to get next rows of this result set.
|
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) |
Gets 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 i,
java.util.Map map) |
Returns the value of a column in the current row as a Java object.
|
java.lang.Object |
getObject(java.lang.String columnName) |
Gets 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 columnName,
java.util.Map map) |
Returns the value in the specified column as a Java object.
|
java.sql.Ref |
getRef(int i) |
Gets a REF(<structured-type>) column value from the current row.
|
java.sql.Ref |
getRef(java.lang.String columnName) |
Gets a REF(<structured-type>) column value from the current row.
|
int |
getRow() |
Retrieves 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) |
Gets the value of a column in the current row as a Java short.
|
short |
getShort(java.lang.String columnName) |
Gets 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() |
Returns the VirtuosoStatement object that produced this
VirtuosoResultSet object.
|
java.lang.String |
getString(int columnIndex) |
Gets the value of a column in the current row as a Java String.
|
java.lang.String |
getString(java.lang.String columnName) |
Gets the value of a column in the current row as a Java String.
|
java.sql.Time |
getTime(int columnIndex) |
Gets 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) |
Gets the value of a column in the current row as a java.sql.Time
object.
|
java.sql.Time |
getTime(java.lang.String columnName) |
Gets 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) |
Gets the value of a column in the current row as a java.sql.Time
object.
|
java.sql.Timestamp |
getTimestamp(int columnIndex) |
Gets 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) |
Gets the value of a column in the current row as a java.sql.Timestamp
object.
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnName) |
Gets 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) |
Gets the value of a column in the current row as a java.sql.Timestamp
object.
|
int |
getType() |
Returns the type of this result set.
|
java.io.InputStream |
getUnicodeStream(int columnIndex) |
Deprecated.
|
java.io.InputStream |
getUnicodeStream(java.lang.String columnName) |
Deprecated.
|
protected int |
getUpdateCount() |
Method uses to retrieve the Update count.
|
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() |
Retrieves the first warning reported by calls on this ResultSet.
|
void |
insertRow() |
Inserts the contents of the insert row into the result set and
the database.
|
boolean |
isAfterLast() |
Indicates whether the cursor is after the last row in the result
set.
|
boolean |
isBeforeFirst() |
Indicates whether the cursor is before the first row in the result
set.
|
boolean |
isClosed() |
Retrieves whether this
ResultSet object has been closed. |
boolean |
isFirst() |
Indicates whether the cursor is on the first row of the result set.
|
boolean |
isLast() |
Indicates whether 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.
|
protected int |
kindop() |
Retrieves the kind of operation of this Result set.
|
boolean |
last() |
Moves the cursor to the last row in the result set.
|
protected boolean |
more_result() |
Retrieves if it exist more result after this set.
|
void |
moveToCurrentRow() |
Moves the cursor to the remembered cursor position, usually the
current row.
|
void |
moveToInsertRow() |
Moves the cursor to the insert row.
|
boolean |
next() |
Moves the cursor down one row from its current position.
|
boolean |
previous() |
Moves the cursor to the previous row in the result set.
|
void |
refreshRow() |
Refreshes the current row with its most recent value in
the database.
|
boolean |
relative(int row) |
Moves the cursor a relative number of rows, either positive or negative.
|
boolean |
rowDeleted() |
Indicates whether a row has been deleted.
|
boolean |
rowInserted() |
Indicates whether the current row has had an insertion.
|
boolean |
rowUpdated() |
Indicates whether the current row has been updated.
|
protected void |
sendBlobData(Vector result) |
|
void |
setFetchDirection(int direction) |
Sets the default fetch direction of this result set.
|
void |
setFetchSize(int rows) |
Gives the JDBC driver a hint as to the number of rows that should
be fetched from the database when more rows are needed.
|
protected void |
setUpdateCount(int n) |
|
<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) |
Updates 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) |
Updates 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) |
Updates a column with a BigDecimal value.
|
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x) |
Updates 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) |
Updates 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) |
Updates 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) |
Updates a column with a boolean value.
|
void |
updateBoolean(java.lang.String columnName,
boolean x) |
Updates a column with a boolean value.
|
void |
updateByte(int columnIndex,
byte x) |
Updates a column with a byte value.
|
void |
updateByte(java.lang.String columnName,
byte x) |
Updates a column with a byte value.
|
void |
updateBytes(int columnIndex,
byte[] x) |
Updates a column with a byte array value.
|
void |
updateBytes(java.lang.String columnName,
byte[] x) |
Updates 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) |
Updates 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 reader,
int length) |
Updates 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) |
Updates a column with a Date value.
|
void |
updateDate(java.lang.String columnName,
java.sql.Date x) |
Updates a column with a Date value.
|
void |
updateDouble(int columnIndex,
double x) |
Updates a column with a Double value.
|
void |
updateDouble(java.lang.String columnName,
double x) |
Updates a column with a double value.
|
void |
updateFloat(int columnIndex,
float x) |
Updates a column with a float value.
|
void |
updateFloat(java.lang.String columnName,
float x) |
Updates a column with a float value.
|
void |
updateInt(int columnIndex,
int x) |
Updates a column with an integer value.
|
void |
updateInt(java.lang.String columnName,
int x) |
Updates a column with an integer value.
|
void |
updateLong(int columnIndex,
long x) |
Updates a column with a long value.
|
void |
updateLong(java.lang.String columnName,
long x) |
Updates 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 x) |
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) |
Updates a column with a null value.
|
void |
updateObject(int columnIndex,
java.lang.Object x) |
Updates a column with an Object value.
|
void |
updateObject(int columnIndex,
java.lang.Object x,
int scale) |
Updates a column with an Object value.
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x) |
Updates a column with an Object value.
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int scale) |
Updates 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() |
Updates 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) |
Updates a column with a short value.
|
void |
updateShort(java.lang.String columnName,
short x) |
Updates 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) |
Updates a column with a String value.
|
void |
updateString(java.lang.String columnName,
java.lang.String x) |
Updates a column with a String value.
|
void |
updateTime(int columnIndex,
java.sql.Time x) |
Updates a column with a Time value.
|
void |
updateTime(java.lang.String columnName,
java.sql.Time x) |
Updates a column with a Time value.
|
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x) |
Updates a column with a Timestamp value.
|
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x) |
Updates a column with a Timestamp value.
|
boolean |
wasNull() |
Reports whether the last column read had a value of SQL NULL.
|
protected void |
wasNull(boolean flag) |
Method used to change the wasNull flag;
|
protected Vector rows
protected VirtuosoResultSetMetaData metaData
protected int totalRows
protected int currentRow
protected int stmt_current_of
protected int stmt_n_rows_to_get
protected boolean stmt_co_last_in_batch
protected boolean isLastResult
protected boolean isLastRow
public static final int TYPE_FORWARD_ONLY
ResultSet object whose cursor may
move only forward.public static final int TYPE_SCROLL_INSENSITIVE
ResultSet object that is scrollable
but generally not sensitive to changes made by others.public static final int TYPE_SCROLL_SENSITIVE
ResultSet object that is scrollable
and generally sensitive to changes made by others.public static final int FETCH_FORWARD
public static final int FETCH_REVERSE
public static final int FETCH_UNKNOWN
public static final int CONCUR_READ_ONLY
ResultSet object
that may NOT be updated.public static final int CONCUR_UPDATABLE
ResultSet object
that may be updated.public static final int CONCUR_VALUES
protected VirtuosoResultSet(VirtuosoConnection vc, java.lang.String[] col_names, int[] col_dtps) throws VirtuosoException
VirtuosoExceptionprotected void getMoreResults(boolean isPrepare)
throws VirtuosoException
isPrepare - true if it is call for preparedStatementVirtuosoException - An internal error occurredprotected int getUpdateCount()
protected void setUpdateCount(int n)
public void finalize()
throws java.lang.Throwable
finalize in class java.lang.Objectjava.lang.Throwablepublic java.sql.SQLWarning getWarnings()
throws VirtuosoException
getWarnings in interface java.sql.ResultSetVirtuosoException - No errors returned (just an implementation question).ResultSet.getWarnings()public void clearWarnings()
throws VirtuosoException
clearWarnings in interface java.sql.ResultSetVirtuosoException - No errors returned (just an implementation question).ResultSet.clearWarnings()public int getType()
throws VirtuosoException
This is a JDBC 2.0 function. So to use it with the current Virtuoso DBMS,
you have to cast the ResultSet class to a VirtuosoResultSet
class like :
int type = (VirtuosoResultSet)currentrs.getType();
getType in interface java.sql.ResultSetVirtuosoException - No errors returned (just an implementation question).ResultSet.getType()public int getConcurrency()
throws VirtuosoException
This is a JDBC 2.0 function. So to use it with the current Virtuoso DBMS,
you have to cast the ResultSet class to a VirtuosoResultSet
class like :
int concurrency = (VirtuosoResultSet)currentrs.getConcurrency();
getConcurrency in interface java.sql.ResultSetVirtuosoException - No errors returned (just an implementation question).ResultSet.getConcurrency()public void setFetchDirection(int direction)
throws VirtuosoException
This is a JDBC 2.0 function. So to use it with the current Virtuoso DBMS,
you have to cast the ResultSet class to a VirtuosoResultSet
class like :
(VirtuosoResultSet)currentrs.setFetchDirection(...);
setFetchDirection in interface java.sql.ResultSetdirection - The initial direction for processing rowsVirtuosoException - An internal error occurred.ResultSet.setFetchDirection(int)public int getFetchDirection()
throws VirtuosoException
This is a JDBC 2.0 function. So to use it with the current Virtuoso DBMS,
you have to cast the ResultSet class to a VirtuosoResultSet
class like :
int fetchdir = (VirtuosoResultSet)currentrs.getFetchDirection();
getFetchDirection in interface java.sql.ResultSetVirtuosoException - No errors returned (just an implementation question).ResultSet.getFetchDirection()public void setFetchSize(int rows)
throws VirtuosoException
This is a JDBC 2.0 function. So to use it with the current Virtuoso DBMS,
you have to cast the ResultSet class to a VirtuosoResultSet
class like :
(VirtuosoResultSet)currentrs.setFetchSize(...);
setFetchSize in interface java.sql.ResultSetrows - the number of rows to fetchVirtuosoException - An internal error occurred.ResultSet.setFetchSize(int)public int getFetchSize()
throws VirtuosoException
This is a JDBC 2.0 function. So to use it with the current Virtuoso DBMS,
you have to cast the ResultSet class to a VirtuosoResultSet
class like :
int fetchsize = (VirtuosoResultSet)currentrs.getFetchSize();
getFetchSize in interface java.sql.ResultSetVirtuosoException - No errors returned (just an implementation question).ResultSet.getFetchSize()public java.sql.Statement getStatement()
throws VirtuosoException
This is a JDBC 2.0 function. So to use it with the current Virtuoso DBMS,
you have to cast the ResultSet class to a VirtuosoResultSet
class like :
Statement statement = (VirtuosoResultSet)currentrs.getStatement();
getStatement in interface java.sql.ResultSetVirtuosoException - No errors returned (just an implementation question).ResultSet.getStatement()public java.sql.ResultSetMetaData getMetaData()
throws VirtuosoException
getMetaData in interface java.sql.ResultSetVirtuosoException - No errors returned (just an implementation question).ResultSet.getMetaData()protected int kindop()
throws VirtuosoException
VirtuosoException - No errors returned (just an implementation question).protected boolean more_result()
throws VirtuosoException
VirtuosoException - No errors returned (just an implementation question).public int findColumn(java.lang.String name)
throws VirtuosoException
findColumn in interface java.sql.ResultSetname - The column name.VirtuosoException - If an internal error occurred.ResultSet.findColumn(java.lang.String)public boolean wasNull()
throws VirtuosoException
wasNull in interface java.sql.ResultSetVirtuosoException - No errors returned (just an implementation question).ResultSet.wasNull()public java.lang.String getString(int columnIndex)
throws VirtuosoException
getString in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getString(int)public boolean getBoolean(int columnIndex)
throws VirtuosoException
getBoolean in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getBoolean(int)public byte getByte(int columnIndex)
throws VirtuosoException
getByte in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getByte(int)public short getShort(int columnIndex)
throws VirtuosoException
getShort in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getShort(int)public int getInt(int columnIndex)
throws VirtuosoException
getInt in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getInt(int)public long getLong(int columnIndex)
throws VirtuosoException
getLong in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getLong(int)public float getFloat(int columnIndex)
throws VirtuosoException
getFloat in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getFloat(int)public double getDouble(int columnIndex)
throws VirtuosoException
getDouble in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getDouble(int)public java.math.BigDecimal getBigDecimal(int columnIndex,
int scale)
throws VirtuosoException
getBigDecimal in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...scale - the number of digits to the right of the decimalVirtuosoException - An internal error occurred.ResultSet.getBigDecimal(int, int)public byte[] getBytes(int columnIndex)
throws VirtuosoException
getBytes in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getBytes(int)public java.math.BigDecimal getBigDecimal(int columnIndex)
throws VirtuosoException
getBigDecimal in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getBigDecimal(int, int)public java.io.InputStream getAsciiStream(int columnIndex)
throws VirtuosoException
getAsciiStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getAsciiStream(int)public java.io.InputStream getUnicodeStream(int columnIndex)
throws VirtuosoException
getUnicodeStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getUnicodeStream(int)public java.io.InputStream getBinaryStream(int columnIndex)
throws VirtuosoException
getBinaryStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getBinaryStream(int)public java.io.Reader getCharacterStream(int columnIndex)
throws VirtuosoException
getCharacterStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getCharacterStream(int)public java.lang.String getString(java.lang.String columnName)
throws VirtuosoException
getString in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getString(int)public boolean getBoolean(java.lang.String columnName)
throws VirtuosoException
getBoolean in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getBoolean(int)public byte getByte(java.lang.String columnName)
throws VirtuosoException
getByte in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getByte(int)public short getShort(java.lang.String columnName)
throws VirtuosoException
getShort in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getShort(int)public int getInt(java.lang.String columnName)
throws VirtuosoException
getInt in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getInt(int)public long getLong(java.lang.String columnName)
throws VirtuosoException
getLong in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getLong(int)public float getFloat(java.lang.String columnName)
throws VirtuosoException
getFloat in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getFloat(int)public double getDouble(java.lang.String columnName)
throws VirtuosoException
getDouble in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getDouble(int)public java.math.BigDecimal getBigDecimal(java.lang.String columnName,
int scale)
throws VirtuosoException
getBigDecimal in interface java.sql.ResultSetcolumnName - the SQL name of the columnscale - the number of digits to the right of the decimalVirtuosoException - An internal error occurred.ResultSet.getBigDecimal(int, int)public byte[] getBytes(java.lang.String columnName)
throws VirtuosoException
getBytes in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getBytes(int)public java.io.Reader getCharacterStream(java.lang.String columnName)
throws VirtuosoException
getCharacterStream in interface java.sql.ResultSetcolumnName - the name of the columnVirtuosoException - An internal error occurred.ResultSet.getCharacterStream(int)public java.math.BigDecimal getBigDecimal(java.lang.String columnName)
throws VirtuosoException
getBigDecimal in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getBigDecimal(int, int)public java.io.InputStream getAsciiStream(java.lang.String columnName)
throws VirtuosoException
getAsciiStream in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getAsciiStream(int)public java.io.InputStream getUnicodeStream(java.lang.String columnName)
throws VirtuosoException
getUnicodeStream in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getUnicodeStream(int)public java.io.InputStream getBinaryStream(java.lang.String columnName)
throws VirtuosoException
getBinaryStream in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getBinaryStream(int)public java.lang.Object getObject(int columnIndex)
throws VirtuosoException
getObject in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - An internal error occurred.ResultSet.getObject(int)public java.lang.Object getObject(java.lang.String columnName)
throws VirtuosoException
getObject in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - An internal error occurred.ResultSet.getObject(int)public java.sql.Date getDate(int columnIndex)
throws VirtuosoException
getDate in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - if a database access error occurspublic java.sql.Time getTime(int columnIndex)
throws VirtuosoException
getTime in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - if a database access error occurspublic java.sql.Timestamp getTimestamp(int columnIndex)
throws VirtuosoException
getTimestamp in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - if a database access error occurspublic java.sql.Date getDate(int columnIndex,
java.util.Calendar cal)
throws VirtuosoException
getDate in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...cal - the calendar to use in constructing the dateVirtuosoException - if a database access error occurspublic java.sql.Time getTime(int columnIndex,
java.util.Calendar cal)
throws VirtuosoException
getTime in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...cal - the calendar to use in constructing the timeVirtuosoException - if a database access error occurspublic java.sql.Timestamp getTimestamp(int columnIndex,
java.util.Calendar cal)
throws VirtuosoException
getTimestamp in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...cal - the calendar to use in constructing the timestampVirtuosoException - if a database access error occurspublic java.sql.Date getDate(java.lang.String columnName)
throws VirtuosoException
getDate in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - if a database access error occurspublic java.sql.Time getTime(java.lang.String columnName)
throws VirtuosoException
getTime in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - if a database access error occurspublic java.sql.Timestamp getTimestamp(java.lang.String columnName)
throws VirtuosoException
getTimestamp in interface java.sql.ResultSetcolumnName - the SQL name of the columnVirtuosoException - if a database access error occurspublic void updateNull(java.lang.String columnName)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateNull in interface java.sql.ResultSetcolumnName - the name of the columnVirtuosoException - if a database access error occurspublic void updateBoolean(java.lang.String columnName,
boolean x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateBoolean in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateByte(java.lang.String columnName,
byte x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateByte in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateShort(java.lang.String columnName,
short x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateShort in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateInt(java.lang.String columnName,
int x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateInt in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateLong(java.lang.String columnName,
long x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateLong in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateFloat(java.lang.String columnName,
float x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateFloat in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateDouble(java.lang.String columnName,
double x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateDouble in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateBigDecimal in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateString(java.lang.String columnName,
java.lang.String x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateString in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateBytes(java.lang.String columnName,
byte[] x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateBytes in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateDate(java.lang.String columnName,
java.sql.Date x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateDate in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateTime(java.lang.String columnName,
java.sql.Time x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateTime in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateTimestamp in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic void updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateAsciiStream in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuelength - of the streamVirtuosoException - if a database access error occurspublic void updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateBinaryStream in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuelength - of the streamVirtuosoException - if a database access error occurspublic void updateCharacterStream(java.lang.String columnName,
java.io.Reader reader,
int length)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateCharacterStream in interface java.sql.ResultSetcolumnName - the name of the columnreader - the new column valuelength - of the streamVirtuosoException - if a database access error occurspublic void updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateObject in interface java.sql.ResultSetcolumnName - 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.VirtuosoException - if a database access error occurspublic void updateObject(java.lang.String columnName,
java.lang.Object x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateObject in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valueVirtuosoException - if a database access error occurspublic java.lang.Object getObject(java.lang.String columnName,
java.util.Map map)
throws VirtuosoException
Map object for
custom mapping if appropriate.getObject in interface java.sql.ResultSetcolumnName - the name of the column from which to retrieve the valuemap - the mapping from SQL type names to Java classesVirtuosoExceptionpublic java.sql.Ref getRef(java.lang.String columnName)
throws VirtuosoException
getRef in interface java.sql.ResultSetcolumnName - the column nameRef object representing the SQL REF value in
the specified columnVirtuosoExceptionpublic java.sql.Blob getBlob(java.lang.String columnName)
throws VirtuosoException
ResultSet object.getBlob in interface java.sql.ResultSetcolumnName - the name of the column from which to retrieve the valueBlob object representing the SQL BLOB value in
the specified columnVirtuosoExceptionVirtuosoBlobpublic java.sql.Clob getClob(java.lang.String columnName)
throws VirtuosoException
ResultSet object.getClob in interface java.sql.ResultSetcolumnName - the name of the column from which to retrieve the valueClob object representing the SQL CLOB value in
the specified columnVirtuosoExceptionVirtuosoClobpublic java.sql.Array getArray(java.lang.String columnName)
throws VirtuosoException
ResultSet object.getArray in interface java.sql.ResultSetcolumnName - the name of the column from which to retrieve the valueArray object representing the SQL ARRAY value in
the specified columnVirtuosoExceptionpublic java.sql.Date getDate(java.lang.String columnName,
java.util.Calendar cal)
throws VirtuosoException
getDate in interface java.sql.ResultSetcolumnName - the SQL name of the column from which to retrieve the valuecal - the calendar to use in constructing the dateVirtuosoException - if a database access error occurspublic java.sql.Time getTime(java.lang.String columnName,
java.util.Calendar cal)
throws VirtuosoException
getTime in interface java.sql.ResultSetcolumnName - the SQL name of the columncal - the calendar to use in constructing the timeVirtuosoException - if a database access error occurspublic java.sql.Timestamp getTimestamp(java.lang.String columnName,
java.util.Calendar cal)
throws VirtuosoException
getTimestamp in interface java.sql.ResultSetcolumnName - the SQL name of the columncal - the calendar to use in constructing the timestampVirtuosoException - if a database access error occursprotected void wasNull(boolean flag)
flag - The new value of the flag.public void close()
throws VirtuosoException
close in interface java.lang.AutoCloseableclose in interface java.sql.ResultSetVirtuosoException - An internal error occurred.ResultSet.close()public boolean next()
throws VirtuosoException
next in interface java.sql.ResultSetVirtuosoException - No errors returned (just implementation).ResultSet.next()public int getRow()
throws VirtuosoException
getRow in interface java.sql.ResultSetVirtuosoException - No errors returned (just implementation).ResultSet.getRow()public boolean previous()
throws VirtuosoException
previous in interface java.sql.ResultSetVirtuosoException - If the result set type is TYPE_FORWARD_ONLY.ResultSet.previous()public void beforeFirst()
throws VirtuosoException
beforeFirst in interface java.sql.ResultSetVirtuosoException - If the result set type is TYPE_FORWARD_ONLY.ResultSet.beforeFirst()public void afterLast()
throws VirtuosoException
afterLast in interface java.sql.ResultSetVirtuosoException - If the result set type is TYPE_FORWARD_ONLY.ResultSet.afterLast()public boolean first()
throws VirtuosoException
first in interface java.sql.ResultSetVirtuosoException - If the result set type is TYPE_FORWARD_ONLY.ResultSet.first()public boolean isBeforeFirst()
throws VirtuosoException
isBeforeFirst in interface java.sql.ResultSetVirtuosoException - No errors returned (just implementation).ResultSet.isBeforeFirst()public boolean isAfterLast()
throws VirtuosoException
isAfterLast in interface java.sql.ResultSetVirtuosoException - No errors returned (just implementation).ResultSet.isAfterLast()public boolean isFirst()
throws VirtuosoException
isFirst in interface java.sql.ResultSetVirtuosoException - No errors returned (just implementation).ResultSet.isFirst()public boolean isLast()
throws VirtuosoException
isLast in interface java.sql.ResultSetVirtuosoException - No errors returned (just implementation).ResultSet.isLast()public boolean last()
throws VirtuosoException
last in interface java.sql.ResultSetVirtuosoException - If the result set type is TYPE_FORWARD_ONLY.ResultSet.last()public boolean absolute(int row)
throws VirtuosoException
absolute in interface java.sql.ResultSetVirtuosoException - If the result set type is TYPE_FORWARD_ONLY.ResultSet.absolute(int)public boolean relative(int row)
throws VirtuosoException
relative in interface java.sql.ResultSetVirtuosoException - If the result set type is TYPE_FORWARD_ONLY.ResultSet.relative(int)public java.lang.String getCursorName()
throws VirtuosoException
getCursorName in interface java.sql.ResultSetVirtuosoException - if a database access error occurspublic java.sql.Blob getBlob(int i)
throws VirtuosoException
ResultSet object.getBlob in interface java.sql.ResultSeti - the first column is 1, the second is 2, ...Blob object representing the SQL BLOB value in
the specified columnVirtuosoExceptionpublic java.sql.Clob getClob(int i)
throws VirtuosoException
ResultSet object.getClob in interface java.sql.ResultSeti - the first column is 1, the second is 2, ...Clob object representing the SQL CLOB value in
the specified columnVirtuosoExceptionpublic boolean rowUpdated()
throws VirtuosoException
rowUpdated in interface java.sql.ResultSetVirtuosoException - if a database access error occursDatabaseMetaData.updatesAreDetected(int)public boolean rowInserted()
throws VirtuosoException
rowInserted in interface java.sql.ResultSetVirtuosoException - if a database access error occursDatabaseMetaData.insertsAreDetected(int)public boolean rowDeleted()
throws VirtuosoException
rowDeleted in interface java.sql.ResultSetVirtuosoException - if a database access error occursDatabaseMetaData.deletesAreDetected(int)public void updateNull(int columnIndex)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateNull in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...VirtuosoException - if a database access error occurspublic void updateBoolean(int columnIndex,
boolean x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateBoolean in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateByte(int columnIndex,
byte x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateByte in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateShort(int columnIndex,
short x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateShort in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateInt(int columnIndex,
int x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateInt in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateLong(int columnIndex,
long x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateLong in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateFloat(int columnIndex,
float x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateFloat in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateDouble(int columnIndex,
double x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateDouble in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateBigDecimal in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateString(int columnIndex,
java.lang.String x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateString in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateBytes(int columnIndex,
byte[] x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateBytes in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateDate(int columnIndex,
java.sql.Date x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateDate in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateTime(int columnIndex,
java.sql.Time x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateTime in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateTimestamp(int columnIndex,
java.sql.Timestamp x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateTimestamp in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateAsciiStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamVirtuosoException - if a database access error occurspublic void updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateBinaryStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamVirtuosoException - if a database access error occurspublic void updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateCharacterStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamVirtuosoException - if a database access error occurspublic void updateObject(int columnIndex,
java.lang.Object x)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateObject in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueVirtuosoException - if a database access error occurspublic void updateObject(int columnIndex,
java.lang.Object x,
int scale)
throws VirtuosoException
updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.updateObject in interface java.sql.ResultSetcolumnIndex - 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.VirtuosoException - if a database access error occurspublic void cancelRowUpdates()
throws VirtuosoException
updateXXX method(s) and before calling updateRow to rollback
the updates made to a row. If no updates have been made or
updateRow has already been called, then this method has no
effect.cancelRowUpdates in interface java.sql.ResultSetVirtuosoException - if a database access error occurs or if
called when on the insert rowpublic void insertRow()
throws VirtuosoException
insertRow in interface java.sql.ResultSetVirtuosoException - if a database access error occurs,
if called when 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 VirtuosoException
updateRow in interface java.sql.ResultSetVirtuosoException - if a database access error occurs or
if called when on the insert rowpublic void deleteRow()
throws VirtuosoException
deleteRow in interface java.sql.ResultSetVirtuosoException - if a database access error occurs or if
called when on the insert row.public void refreshRow()
throws VirtuosoException
refreshRow method provides a way for an application to
explicitly tell the JDBC driver to refetch a row(s) from the
database. An application may want to call refreshRow when
caching or prefetching is being done by the JDBC driver to
fetch the latest value of a row from the database. The JDBC driver
may actually refresh multiple rows at once if the fetch size is
greater than one.
All values are refetched subject to the transaction isolation
level and cursor sensitivity. If refreshRow is called after
calling updateXXX, but before calling updateRow, then the
updates made to the row are lost. Calling the method refreshRow frequently
will likely slow performance.refreshRow in interface java.sql.ResultSetVirtuosoException - if a database access error occurs or if
called when on the insert rowpublic void moveToInsertRow()
throws VirtuosoException
updateXXX methods prior to
inserting the row into the result set.
Only the updateXXX, getXXX,
and insertRow methods may be
called when the cursor is on the insert row. All of the columns in
a result set must be given a value each time this method is
called before calling insertRow.
The method updateXXX must be called before a
getXXX method can be called on a column value.moveToInsertRow in interface java.sql.ResultSetVirtuosoException - if a database access error occurs
or the result set is not updatablepublic void moveToCurrentRow()
throws VirtuosoException
moveToCurrentRow in interface java.sql.ResultSetVirtuosoException - if a database access error occurs
or the result set is not updatablepublic java.lang.Object getObject(int i,
java.util.Map map)
throws VirtuosoException
Map object
for the custom mapping of the
SQL structured or distinct type that is being retrieved.getObject in interface java.sql.ResultSeti - the first column is 1, the second is 2, ...map - the mapping from SQL type names to Java classesVirtuosoExceptionpublic java.sql.Ref getRef(int i)
throws VirtuosoException
getRef in interface java.sql.ResultSeti - the first column is 1, the second is 2, ...Ref object representing an SQL REF valueVirtuosoExceptionpublic java.sql.Array getArray(int i)
throws VirtuosoException
ResultSet object.getArray in interface java.sql.ResultSeti - the first column is 1, the second is 2, ...Array object representing the SQL ARRAY value in
the specified columnVirtuosoExceptionprotected void sendBlobData(Vector result) throws VirtuosoException
VirtuosoExceptionpublic boolean equals(java.lang.Object obj)
equals in class java.lang.Objectpublic java.net.URL getURL(int columnIndex)
throws java.sql.SQLException
ResultSet object as a java.net.URL
object in the Java programming language.getURL in interface java.sql.ResultSetcolumnIndex - 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.getURL in interface java.sql.ResultSetcolumnName - 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.updateRef in interface java.sql.ResultSetcolumnIndex - 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.updateRef in interface java.sql.ResultSetcolumnName - 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.updateBlob in interface java.sql.ResultSetcolumnIndex - 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.updateBlob in interface java.sql.ResultSetcolumnName - 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.updateClob in interface java.sql.ResultSetcolumnIndex - 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.updateClob in interface java.sql.ResultSetcolumnName - 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.updateArray in interface java.sql.ResultSetcolumnIndex - 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.updateArray in interface java.sql.ResultSetcolumnName - 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.getRowId in interface java.sql.ResultSetcolumnIndex - 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.getRowId in interface java.sql.ResultSetcolumnLabel - 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.updateRowId in interface java.sql.ResultSetcolumnIndex - 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.updateRowId in interface java.sql.ResultSetcolumnLabel - 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 objectgetHoldability in interface java.sql.ResultSetResultSet.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.isClosed in interface java.sql.ResultSetResultSet object is closed; false if it is still openjava.sql.SQLException - if a database access error occurspublic void updateNString(int columnIndex,
java.lang.String x)
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.updateNString in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second 2, ...x - 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.updateNString in interface java.sql.ResultSetcolumnLabel - 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.updateNClob in interface java.sql.ResultSetcolumnIndex - 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.updateNClob in interface java.sql.ResultSetcolumnLabel - 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.getNClob in interface java.sql.ResultSetcolumnIndex - 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.getNClob in interface java.sql.ResultSetcolumnLabel - 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.getSQLXML in interface java.sql.ResultSetcolumnIndex - 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.getSQLXML in interface java.sql.ResultSetcolumnLabel - 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.
updateSQLXML in interface java.sql.ResultSetcolumnIndex - 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.
updateSQLXML in interface java.sql.ResultSetcolumnLabel - 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.getNString in interface java.sql.ResultSetcolumnIndex - 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.getNString in interface java.sql.ResultSetcolumnLabel - 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.getNCharacterStream in interface java.sql.ResultSetcolumnIndex - 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.getNCharacterStream in interface java.sql.ResultSetcolumnLabel - 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.
updateNCharacterStream in interface java.sql.ResultSetcolumnIndex - 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.
updateNCharacterStream in interface java.sql.ResultSetcolumnLabel - 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.
updateAsciiStream in interface java.sql.ResultSetcolumnIndex - 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.
updateBinaryStream in interface java.sql.ResultSetcolumnIndex - 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.
updateCharacterStream in interface java.sql.ResultSetcolumnIndex - 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.
updateAsciiStream in interface java.sql.ResultSetcolumnLabel - 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.
updateBinaryStream in interface java.sql.ResultSetcolumnLabel - 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.
updateCharacterStream in interface java.sql.ResultSetcolumnLabel - 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.
updateBlob in interface java.sql.ResultSetcolumnIndex - 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.
updateBlob in interface java.sql.ResultSetcolumnLabel - 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.
updateClob in interface java.sql.ResultSetcolumnIndex - 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.
updateClob in interface java.sql.ResultSetcolumnLabel - 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.
updateNClob in interface java.sql.ResultSetcolumnIndex - 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.
updateNClob in interface java.sql.ResultSetcolumnLabel - 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.
updateNCharacterStream in interface java.sql.ResultSetcolumnIndex - 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.
updateNCharacterStream in interface java.sql.ResultSetcolumnLabel - 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.
updateAsciiStream in interface java.sql.ResultSetcolumnIndex - 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.
updateBinaryStream in interface java.sql.ResultSetcolumnIndex - 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.
updateCharacterStream in interface java.sql.ResultSetcolumnIndex - 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.
updateAsciiStream in interface java.sql.ResultSetcolumnLabel - 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.
updateBinaryStream in interface java.sql.ResultSetcolumnLabel - 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.
updateCharacterStream in interface java.sql.ResultSetcolumnLabel - 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.
updateBlob in interface java.sql.ResultSetcolumnIndex - 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.
updateBlob in interface java.sql.ResultSetcolumnLabel - 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.
updateClob in interface java.sql.ResultSetcolumnIndex - 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.
updateClob in interface java.sql.ResultSetcolumnLabel - 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.
updateNClob in interface java.sql.ResultSetcolumnIndex - 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.
updateNClob in interface java.sql.ResultSetcolumnLabel - 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.unwrap in interface java.sql.Wrapperiface - 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.isWrapperFor in interface java.sql.Wrapperiface - 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.
getObject in interface java.sql.ResultSetcolumnIndex - 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.
getObject in interface java.sql.ResultSetcolumnLabel - 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