| java.lang.Object org.apache.derby.impl.jdbc.ConnectionChild org.apache.derby.impl.jdbc.EmbedResultSet
All known Subclasses: org.apache.derby.impl.jdbc.EmbedResultSet20, org.apache.derby.impl.jdbc.EmbedResultSet169,
Field Summary | |
final protected static int | ABSOLUTE | final protected static int | AFTERLAST | final protected static int | BEFOREFIRST | final protected static int | FIRST | final protected static int | LAST | final protected static int | NEXT | final protected static int | PREVIOUS | final protected static int | RELATIVE | boolean | isClosed Set if this ResultSet is definitely closed.
If the connection has been closed, or the database
or system shutdown but the ResultSet has not been
closed explictly then this may be false. | final int | order | Activation | singleUseActivation This activation is set by EmbedStatement
for a single execution Activation. | protected boolean | wasNull |
Method Summary | |
public boolean | absolute(int row) JDBC 2.0
Move to an absolute row number in the result set.
If row is positive, moves to an absolute row with respect to the
beginning of the result set. | public void | afterLast() JDBC 2.0
Moves to the end of the result set, just after the last row. | public void | beforeFirst() JDBC 2.0
Moves to the front of the result set, just before the first row. | public void | cancelRowUpdates() JDBC 2.0
The cancelRowUpdates() method may be called after calling an
updateXXX() method(s) and before calling updateRow() to rollback
the updates made to a row. | final void | checkExecIfClosed(String operation) Throw an exception if this ResultSet is closed or its
Connection has been closed. | final void | checkIfClosed(String operation) Throw an exception if this ResultSet is closed. | final protected void | checkOnRow() | protected void | checksBeforeInsert() | protected void | checksBeforeUpdateOrDelete(String methodName, int columnIndex) | protected void | checksBeforeUpdateXXX(String methodName, int columnIndex) | final public void | clearWarnings() After this call getWarnings returns null until a new warning is
reported for this ResultSet. | public void | close() In some cases, it is desirable to immediately release a
ResultSet's database and JDBC resources instead of waiting for
this to happen when it is automatically closed; the close
method provides this immediate release.
Note: A ResultSet is automatically closed by the
Statement that generated it when that Statement is closed,
re-executed, or is used to retrieve the next result from a
sequence of multiple results. | final SQLException | closeOnTransactionError(Throwable thrownException) | final public int | compareTo(Object other) | public void | deleteRow() JDBC 2.0
Delete the current row from the result set and the underlying
database. | protected void | finalize() JDBC states that a ResultSet is closed when garbage collected.
We simply mark the activation as unused. | final public int | findColumn(String columnName) Map a Resultset column name to a ResultSet column index. | protected int | findColumnName(String columnName) Map a Resultset column name to a ResultSet column index. | public boolean | first() JDBC 2.0
Moves to the first row in the result set. | final public InputStream | getAsciiStream(int columnIndex) Pushes a converter on top of getCharacterStream().
Parameters: columnIndex - the first column is 1, the second is 2, ... | final public InputStream | getAsciiStream(String columnName) A column value can be retrieved as a stream of ASCII characters
and then read in chunks from the stream. | final public InputStream | getBinaryStream(int columnIndex) Get the column as an InputStream. | final public InputStream | getBinaryStream(String columnName) A column value can be retrieved as a stream of uninterpreted bytes
and then read in chunks from the stream. | public Blob | getBlob(int columnIndex) JDBC 2.0
Get a BLOB column.
Parameters: columnIndex - the first column is 1, the second is 2, ... | final public Blob | getBlob(String columnName) JDBC 2.0
Get a BLOB column. | final public boolean | getBoolean(int columnIndex) Get the value of a column in the current row as a Java boolean.
Parameters: columnIndex - the first column is 1, the second is 2, ... | final public boolean | getBoolean(String columnName) Get the value of a column in the current row as a Java boolean. | final public byte | getByte(int columnIndex) Get the value of a column in the current row as a Java byte.
Parameters: columnIndex - the first column is 1, the second is 2, ... | final public byte | getByte(String columnName) Get the value of a column in the current row as a Java byte. | final public byte[] | getBytes(int columnIndex) Get the value of a column in the current row as a Java byte array.
The bytes represent the raw values returned by the driver.
Parameters: columnIndex - the first column is 1, the second is 2, ... | final public byte[] | getBytes(String columnName) Get the value of a column in the current row as a Java byte array. | final public java.io.Reader | getCharacterStream(int columnIndex) JDBC 2.0
Get the value of a column in the current row as a java.io.Reader. | final public java.io.Reader | getCharacterStream(String columnName) JDBC 2.0
Get the value of a column in the current row as a java.io.Reader. | final public Clob | getClob(int columnIndex) JDBC 2.0
Get a CLOB column.
Parameters: columnIndex - the first column is 1, the second is 2, ... | final public Clob | getClob(String columnName) JDBC 2.0
Get a CLOB column. | final protected DataValueDescriptor | getColumn(int columnIndex) Get the column value for a getXXX() call. | final String | getColumnSQLType(int column) | final int | getColumnType(int columnIndex) Check the column is in range *and* return the JDBC type of the column. | public int | getConcurrency() JDBC 2.0
Return the concurrency of this result set. | final public String | getCursorName() Get the name of the SQL cursor used by this ResultSet.
In SQL, a result table is retrieved through a cursor that is
named. | protected DataValueDescriptor | getDVDforColumnToBeUpdated(int columnIndex, String updateMethodName) | final public Date | getDate(int columnIndex) Get the value of a column in the current row as a java.sql.Date object.
Parameters: columnIndex - the first column is 1, the second is 2, ... | public java.sql.Date | getDate(int columnIndex, Calendar cal) JDBC 2.0
Get the value of a column in the current row as a java.sql.Date
object. | public java.sql.Date | getDate(String columnName, Calendar cal) JDBC 2.0
Get the value of a column in the current row as a java.sql.Date
object. | final public Date | getDate(String columnName) Get the value of a column in the current row as a java.sql.Date object. | final public double | getDouble(int columnIndex) Get the value of a column in the current row as a Java double.
Parameters: columnIndex - the first column is 1, the second is 2, ... | final public double | getDouble(String columnName) Get the value of a column in the current row as a Java double. | public int | getFetchDirection() JDBC 2.0
Return the fetch direction for this result set. | public int | getFetchSize() JDBC 2.0
Return the fetch size for this result set. | final public float | getFloat(int columnIndex) Get the value of a column in the current row as a Java float.
Parameters: columnIndex - the first column is 1, the second is 2, ... | final public float | getFloat(String columnName) Get the value of a column in the current row as a Java float. | final public int | getHoldability() JDBC 4.0
Retrieves the holdability for this ResultSet
object. | final public int | getInt(int columnIndex) Get the value of a column in the current row as a Java int.
Parameters: columnIndex - the first column is 1, the second is 2, ... | final public int | getInt(String columnName) Get the value of a column in the current row as a Java int. | final public long | getLong(int columnIndex) Get the value of a column in the current row as a Java long.
Parameters: columnIndex - the first column is 1, the second is 2, ... | final public long | getLong(String columnName) Get the value of a column in the current row as a Java long. | public ResultSetMetaData | getMetaData() The number, types and properties of a ResultSet's columns
are provided by the getMetaData method. | final public Object | getObject(int columnIndex) Get the value of a column in the current row as a Java object.
This method will return the value of the given column as a
Java object. | final public Object | getObject(String columnName) Get the value of a column in the current row as a Java object.
This method will return the value of the given column as a
Java object. | protected ParameterValueSet | getParameterValueSet() Try to see if we can fish the pvs out of the local statement. | public int | getRow() JDBC 2.0
Determine the current row number. | protected String | getSQLText() Try to see if we can fish the SQL Statement out of the local statement. | final public short | getShort(int columnIndex) Get the value of a column in the current row as a Java short.
Parameters: columnIndex - the first column is 1, the second is 2, ... | final public short | getShort(String columnName) Get the value of a column in the current row as a Java short. | final public Statement | getStatement() JDBC 2.0
Return the Statement that produced the ResultSet. | final public String | getString(int columnIndex) Get the value of a column in the current row as a Java String.
Parameters: columnIndex - the first column is 1, the second is 2, ... | final public String | getString(String columnName) Get the value of a column in the current row as a Java String. | final public Time | getTime(int columnIndex) Get the value of a column in the current row as a java.sql.Time object.
Parameters: columnIndex - the first column is 1, the second is 2, ... | public java.sql.Time | getTime(int columnIndex, Calendar cal) JDBC 2.0
Get the value of a column in the current row as a java.sql.Time
object. | public java.sql.Time | getTime(String columnName, Calendar cal) JDBC 2.0
Get the value of a column in the current row as a java.sql.Time
object. | final public Time | getTime(String columnName) Get the value of a column in the current row as a java.sql.Time object. | final public Timestamp | getTimestamp(int columnIndex) Get the value of a column in the current row as a java.sql.Timestamp object.
Parameters: columnIndex - the first column is 1, the second is 2, ... | public java.sql.Timestamp | getTimestamp(String columnName, Calendar cal) JDBC 2.0
Get the value of a column in the current row as a java.sql.Timestamp
object. | public java.sql.Timestamp | getTimestamp(int columnIndex, Calendar cal) JDBC 2.0
Get the value of a column in the current row as a java.sql.Timestamp
object. | final public Timestamp | getTimestamp(String columnName) Get the value of a column in the current row as a java.sql.Timestamp object. | public int | getType() JDBC 2.0
Return the type of this result set. | public URL | getURL(int columnIndex) JDBC 3.0
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. | public URL | getURL(String columnName) JDBC 3.0
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. | final public SQLWarning | getWarnings() The first warning reported by calls on this ResultSet is
returned. | public void | insertRow() JDBC 2.0
Insert the contents of the insert row into the result set and the
database. | public boolean | isAfterLast() JDBC 2.0
Determine if the cursor is after the last row in the result set.
true if after the last row, false otherwise. | public boolean | isBeforeFirst() JDBC 2.0
Determine if the cursor is before the first row in the result set.
true if before the first row, false otherwise. | final public boolean | isClosed() JDBC 4.0
Checks whether this ResultSet object has been
closed, either automatically or because close()
has been called. | public boolean | isFirst() JDBC 2.0
Determine if the cursor is on the first row of the result set. | final public boolean | isForUpdate() | public boolean | isLast() JDBC 2.0
Determine if the cursor is on the last row of the result set. | public boolean | last() JDBC 2.0
Moves to the last row in the result set. | protected boolean | movePosition(int position, String positionText) | protected boolean | movePosition(int position, int row, String positionText) | public void | moveToCurrentRow() JDBC 2.0
Move the cursor to the remembered cursor position, usually the current
row. | public void | moveToInsertRow() JDBC 2.0
Move to the insert row. | protected EmbedResultSetMetaData | newEmbedResultSetMetaData(ResultDescription resultDesc) | public boolean | next() A ResultSet is initially positioned before its first row; the
first call to next makes the first row the current row; the
second call makes the second row the current row, etc.
If an input stream from the previous row is open, it is
implicitly closed. | final static SQLException | noStateChangeException(Throwable thrownException) An exception on many method calls to JDBC objects does not change the state
of the transaction or statement, or even the underlying object. | public boolean | previous() JDBC 2.0
Moves to the previous row in the result set. | public void | refreshRow() JDBC 2.0
Refresh the value of the current row with its current value in the
database. | public boolean | relative(int row) JDBC 2.0
Moves a relative number of rows, either positive or negative. | public boolean | rowDeleted() JDBC 2.0
Determine if this row has been deleted. | public boolean | rowInserted() JDBC 2.0
Determine if the current row has been inserted. | public boolean | rowUpdated() JDBC 2.0
Determine if the current row has been updated. | final public void | setApplicationStatement(Statement applicationStmt) Set the application Statement object that created this ResultSet. | void | setDynamicResultSet(EmbedStatement owningStmt) A dynamic result set was created in a procedure by a nested connection. | public void | setFetchDirection(int direction) JDBC 2.0
Give a hint as to the direction in which the rows in this result set will
be processed. | public void | setFetchSize(int rows) JDBC 2.0
Give the JDBC driver a hint as to the number of rows that should be
fetched from the database when more rows are needed for this result set.
If the fetch size specified is zero, then the JDBC driver ignores the
value, and is free to make its own best guess as to what the fetch size
should be. | public void | updateAsciiStream(int columnIndex, java.io.InputStream x, long length) Update a column with an ascii stream value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateAsciiStream(int columnIndex, InputStream x) Updates the designated column with a character stream value.
The data will be read from the stream as needed until end-of-stream is
reached.
The updater methods are used to update column values in the current row
or the insert row. | public void | updateAsciiStream(String columnName, java.io.InputStream x, int length) JDBC 2.0
Update a column with an ascii stream value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateAsciiStream(int columnIndex, java.io.InputStream x, int length) JDBC 2.0
Update a column with an ascii stream value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateAsciiStream(String columnName, java.io.InputStream x, long length) JDBC 4.0
Update a column with an ascii stream value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateAsciiStream(String columnName, InputStream x) Updates the designated column with a character stream value.
The data will be read from the stream as needed until end-of-stream is
reached.
The updater methods are used to update column values in the current row
or the insert row. | public void | updateBinaryStream(int columnIndex, java.io.InputStream x, long length) Update a column with a binary stream value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateBinaryStream(int columnIndex, InputStream x) Updates the designated column with a binary stream value.
The data will be read from the stream as needed until end-of-stream is
reached.
The updater methods are used to update column values in the current row
or the insert row. | public void | updateBinaryStream(String columnName, java.io.InputStream x, int length) JDBC 2.0
Update a column with a binary stream value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateBinaryStream(int columnIndex, java.io.InputStream x, int length) JDBC 2.0
Update a column with a binary stream value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateBinaryStream(String columnName, java.io.InputStream x, long length) JDBC 4.0
Update a column with a binary stream value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateBinaryStream(String columnName, InputStream x) Updates the designated column with a binary stream value.
The data will be read from the stream as needed until end-of-stream is
reached.
The updater methods are used to update column values in the current row
or the insert row. | public void | updateBlob(int columnIndex, Blob x) JDBC 3.0
Updates the designated column with a java.sql.Blob value. | public void | updateBlob(String columnName, Blob x) JDBC 3.0
Updates the designated column with a java.sql.Blob value. | public void | updateBlob(int columnIndex, InputStream x, long length) JDBC 4.0
Updates the designated column with a java.sql.Blob value. | public void | updateBlob(int columnIndex, InputStream x) Updates the designated column using the given input stream.
The data will be read from the stream as needed until end-of-stream is reached.
The updater methods are used to update column values in the current row
or the insert row. | public void | updateBlob(String columnName, InputStream x, long length) JDBC 4.0
Updates the designated column with a java.sql.Blob value. | public void | updateBlob(String columnName, InputStream x) Updates the designated column using the given input stream.
The data will be read from the stream as needed until end-of-stream is reached.
The updater methods are used to update column values in the current row
or the insert row. | public void | updateBoolean(int columnIndex, boolean x) JDBC 2.0
Update a column with a boolean value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateBoolean(String columnName, boolean x) JDBC 2.0
Update a column with a boolean value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateByte(int columnIndex, byte x) JDBC 2.0
Update a column with a byte value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateByte(String columnName, byte x) JDBC 2.0
Update a column with a byte value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateBytes(int columnIndex, byte x) JDBC 2.0
Update a column with a byte array value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateBytes(String columnName, byte x) JDBC 2.0
Update a column with a byte array value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateCharacterStream(int columnIndex, java.io.Reader x, long length) JDBC 4.0
Update a column with a character stream value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateCharacterStream(int columnIndex, Reader x) Updates the designated column with a character stream value.
The data will be read from the stream as needed until end-of-stream is
reached.
The updater methods are used to update column values in the current row
or the insert row. | public void | updateCharacterStream(String columnName, java.io.Reader reader, int length) JDBC 2.0
Update a column with a character stream value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateCharacterStream(int columnIndex, java.io.Reader x, int length) JDBC 2.0
Update a column with a character stream value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateCharacterStream(String columnName, java.io.Reader reader, long length) JDBC 4.0
Update a column with a character stream value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateCharacterStream(String columnName, Reader reader) Updates the designated column with a character stream value.
The data will be read from the stream as needed until end-of-stream is
reached.
The updater methods are used to update column values in the current row
or the insert row. | public void | updateClob(int columnIndex, Clob x) JDBC 3.0
Updates the designated column with a java.sql.Clob value. | public void | updateClob(String columnName, Clob x) JDBC 3.0
Updates the designated column with a java.sql.Clob value. | public void | updateClob(int columnIndex, Reader x, long length) JDBC 4.0
Updates the designated column with a java.sql.Clob value. | public void | updateClob(int columnIndex, Reader x) Updates the designated column using the given Reader
object.
The data will be read from the stream as needed until end-of-stream is
reached. | public void | updateClob(String columnName, Reader x, long length) JDBC 4.0
Updates the designated column with a java.sql.Clob value. | public void | updateClob(String columnName, Reader x) Updates the designated column using the given Reader
object.
The data will be read from the stream as needed until end-of-stream is
reached. | public void | updateDate(int columnIndex, java.sql.Date x) JDBC 2.0
Update a column with a Date value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateDate(String columnName, java.sql.Date x) JDBC 2.0
Update a column with a Date value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateDouble(int columnIndex, double x) JDBC 2.0
Update a column with a Double value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateDouble(String columnName, double x) JDBC 2.0
Update a column with a double value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateFloat(int columnIndex, float x) JDBC 2.0
Update a column with a float value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateFloat(String columnName, float x) JDBC 2.0
Update a column with a float value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateInt(int columnIndex, int x) JDBC 2.0
Update a column with an integer value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateInt(String columnName, int x) JDBC 2.0
Update a column with an integer value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateLong(int columnIndex, long x) JDBC 2.0
Update a column with a long value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateLong(String columnName, long x) JDBC 2.0
Update a column with a long value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateNull(int columnIndex) JDBC 2.0
Give a nullable column a null value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateNull(String columnName) JDBC 2.0
Update a column with a null value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateObject(int columnIndex, Object x, int scale) JDBC 2.0
Update a column with an Object value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateObject(int columnIndex, Object x) JDBC 2.0
Update a column with an Object value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateObject(String columnName, Object x, int scale) JDBC 2.0
Update a column with an Object value.
The updateXXX() methods are used to update column values in the
current row, or the insert row. | public void | updateObject(String columnName, Object x) JDBC 2.0
Update a column with an Object value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateRow() JDBC 2.0
Update the underlying database with the new contents of the
current row. | public void | updateShort(int columnIndex, short x) JDBC 2.0
Update a column with a short value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateShort(String columnName, short x) JDBC 2.0
Update a column with a short value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateString(int columnIndex, String x) JDBC 2.0
Update a column with a String value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateString(String columnName, String x) JDBC 2.0
Update a column with a String value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateTime(int columnIndex, java.sql.Time x) JDBC 2.0
Update a column with a Time value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateTime(String columnName, java.sql.Time x) JDBC 2.0
Update a column with a Time value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateTimestamp(int columnIndex, java.sql.Timestamp x) JDBC 2.0
Update a column with a Timestamp value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | public void | updateTimestamp(String columnName, java.sql.Timestamp x) JDBC 2.0
Update a column with a Timestamp value.
The updateXXX() methods are used to update column values in the current
row, or the insert row. | final void | useStream(int columnIndex) Mark a column as already having a stream accessed from it. | final public boolean | wasNull() A column may have the value of SQL NULL; wasNull reports whether
the last column read had this special value. |
ABSOLUTE | final protected static int ABSOLUTE(Code) | | |
AFTERLAST | final protected static int AFTERLAST(Code) | | |
BEFOREFIRST | final protected static int BEFOREFIRST(Code) | | |
FIRST | final protected static int FIRST(Code) | | |
LAST | final protected static int LAST(Code) | | |
NEXT | final protected static int NEXT(Code) | | |
PREVIOUS | final protected static int PREVIOUS(Code) | | |
RELATIVE | final protected static int RELATIVE(Code) | | |
isClosed | boolean isClosed(Code) | | Set if this ResultSet is definitely closed.
If the connection has been closed, or the database
or system shutdown but the ResultSet has not been
closed explictly then this may be false. Once
this object detects the connection is closed
isClosed will be set to true.
|
singleUseActivation | Activation singleUseActivation(Code) | | This activation is set by EmbedStatement
for a single execution Activation. Ie.
a ResultSet from a Statement.executeQuery().
In this case the closing of this ResultSet will close
the activation or the finalization of the ResultSet
without it being closed will mark the Activation as unused.
c.f. EmbedPreparedStatement.finalize().
|
wasNull | protected boolean wasNull(Code) | | |
absolute | public boolean absolute(int row) throws SQLException(Code) | | JDBC 2.0
Move to an absolute row number in the result set.
If row is positive, moves to an absolute row with respect to the
beginning of the result set. The first row is row 1, the second is row 2,
etc.
If row is negative, moves to an absolute row position with respect to the
end of result set. For example, calling absolute(-1) positions the cursor
on the last row, absolute(-2) indicates the next-to-last row, etc.
An attempt to position the cursor beyond the first/last row in the result
set, leaves the cursor before/after the first/last row, respectively.
Note: Calling absolute(1) is the same as calling first(). Calling
absolute(-1) is the same as calling last().
true if on the result set, false if off. exception: SQLException - if a database-access error occurs, or row is 0, or resultset type is TYPE_FORWARD_ONLY. |
afterLast | public void afterLast() throws SQLException(Code) | | JDBC 2.0
Moves to the end of the result set, just after the last row. Has no
effect if the result set contains no rows.
exception: SQLException - if a database-access error occurs, or result set type isTYPE_FORWARD_ONLY. |
beforeFirst | public void beforeFirst() throws SQLException(Code) | | JDBC 2.0
Moves to the front of the result set, just before the first row. Has no
effect if the result set contains no rows.
exception: SQLException - if a database-access error occurs, or result set type isTYPE_FORWARD_ONLY |
cancelRowUpdates | public void cancelRowUpdates() throws SQLException(Code) | | JDBC 2.0
The cancelRowUpdates() method may be called after calling an
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.
exception: SQLException - if a database-access error occurs, or ifcalled when on the insert row. |
checkExecIfClosed | final void checkExecIfClosed(String operation) throws SQLException(Code) | | Throw an exception if this ResultSet is closed or its
Connection has been closed. If the ResultSet has not
been explictly closed but the Connection is closed,
then this ResultSet will be marked as closed.
|
checkIfClosed | final void checkIfClosed(String operation) throws SQLException(Code) | | Throw an exception if this ResultSet is closed.
Parameters: operation - The operation the caller is trying to perform exception: SQLException - Thrown if this ResultSet is closed. |
checksBeforeUpdateOrDelete | protected void checksBeforeUpdateOrDelete(String methodName, int columnIndex) throws SQLException(Code) | | |
clearWarnings | final public void clearWarnings() throws SQLException(Code) | | After this call getWarnings returns null until a new warning is
reported for this ResultSet.
exception: SQLException - Thrown if this ResultSet is closed |
close | public void close() throws SQLException(Code) | | In some cases, it is desirable to immediately release a
ResultSet's database and JDBC resources instead of waiting for
this to happen when it is automatically closed; the close
method provides this immediate release.
Note: A ResultSet is automatically closed by the
Statement that generated it when that Statement is closed,
re-executed, or is used to retrieve the next result from a
sequence of multiple results. A ResultSet is also automatically
closed when it is garbage collected.
exception: SQLException - thrown on failure. |
deleteRow | public void deleteRow() throws SQLException(Code) | | JDBC 2.0
Delete the current row from the result set and the underlying
database. Cannot be called when on the insert row.
exception: SQLException - if a database-access error occurs, or ifcalled when on the insert row. |
finalize | protected void finalize() throws Throwable(Code) | | JDBC states that a ResultSet is closed when garbage collected.
We simply mark the activation as unused. Some later use
of the connection will clean everything up.
exception: Throwable - Allows any exception to be thrown during finalize |
findColumn | final public int findColumn(String columnName) throws SQLException(Code) | | Map a Resultset column name to a ResultSet column index.
Parameters: columnName - the name of the column the column index exception: SQLException - thrown on failure. |
findColumnName | protected int findColumnName(String columnName) throws SQLException(Code) | | Map a Resultset column name to a ResultSet column index.
Parameters: columnName - the name of the column the column index exception: SQLException - thrown on failure. |
first | public boolean first() throws SQLException(Code) | | JDBC 2.0
Moves to the first row in the result set.
true if on a valid row, false if no rows in the result set. exception: SQLException - if a database-access error occurs, or result set type isTYPE_FORWARD_ONLY. |
getAsciiStream | final public InputStream getAsciiStream(int columnIndex) throws SQLException(Code) | | Pushes a converter on top of getCharacterStream().
Parameters: columnIndex - the first column is 1, the second is 2, ... a Java input stream that delivers the database column valueas a stream of one byte ASCII characters. If the value is SQL NULLthen the result is null. exception: SQLException - thrown on failure. |
getAsciiStream | final public InputStream getAsciiStream(String columnName) throws SQLException(Code) | | A column value can be retrieved as a stream of ASCII characters
and then read in chunks from the stream. This method is particularly
suitable for retrieving large LONGVARCHAR values. The JDBC driver will
do any necessary conversion from the database format into ASCII.
Note: All the data in the returned stream must
be read prior to getting the value of any other column. The
next call to a get method implicitly closes the stream.
Parameters: columnName - is the SQL name of the column a Java input stream that delivers the database column valueas a stream of one byte ASCII characters. If the value is SQL NULLthen the result is null. exception: SQLException - thrown on failure. |
getBinaryStream | final public InputStream getBinaryStream(int columnIndex) throws SQLException(Code) | | Get the column as an InputStream. If the column is already of type
InputStream then just return it, otherwise convert the column to a set
of bytes and create a stream out of the bytes.
Parameters: columnIndex - the first column is 1, the second is 2, ... a Java input stream that delivers the database column valueas a stream of uninterpreted bytes. If the value is SQL NULLthen the result is null. exception: SQLException - thrown on failure. |
getBinaryStream | final public InputStream getBinaryStream(String columnName) throws SQLException(Code) | | A column value can be retrieved as a stream of uninterpreted bytes
and then read in chunks from the stream. This method is particularly
suitable for retrieving large LONGVARBINARY values.
Note: All the data in the returned stream must
be read prior to getting the value of any other column. The
next call to a get method implicitly closes the stream.
Parameters: columnName - is the SQL name of the column a Java input stream that delivers the database column valueas a stream of uninterpreted bytes. If the value is SQL NULLthen the result is null. exception: SQLException - thrown on failure. |
getBlob | public Blob getBlob(int columnIndex) throws SQLException(Code) | | JDBC 2.0
Get a BLOB column.
Parameters: columnIndex - the first column is 1, the second is 2, ... an object representing a BLOB |
getBlob | final public Blob getBlob(String columnName) throws SQLException(Code) | | JDBC 2.0
Get a BLOB column.
Parameters: columnName - the column name an object representing a BLOB |
getBoolean | final public boolean getBoolean(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java boolean.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is false exception: SQLException - thrown on failure. |
getBoolean | final public boolean getBoolean(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a Java boolean.
Parameters: columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is false exception: SQLException - thrown on failure. |
getByte | final public byte getByte(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java byte.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is 0 exception: SQLException - thrown on failure. |
getByte | final public byte getByte(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a Java byte.
Parameters: columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is 0 exception: SQLException - thrown on failure. |
getBytes | final public byte[] getBytes(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java byte array.
The bytes represent the raw values returned by the driver.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is null exception: SQLException - thrown on failure. |
getBytes | final public byte[] getBytes(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a Java byte array.
The bytes represent the raw values returned by the driver.
Parameters: columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is null exception: SQLException - thrown on failure. |
getCharacterStream | final public java.io.Reader getCharacterStream(int columnIndex) throws SQLException(Code) | | JDBC 2.0
Get the value of a column in the current row as a java.io.Reader.
exception: SQLException - database error. |
getClob | final public Clob getClob(int columnIndex) throws SQLException(Code) | | JDBC 2.0
Get a CLOB column.
Parameters: columnIndex - the first column is 1, the second is 2, ... an object representing a CLOB |
getClob | final public Clob getClob(String columnName) throws SQLException(Code) | | JDBC 2.0
Get a CLOB column.
Parameters: columnName - the column name an object representing a CLOB exception: SQLException - Feature not implemented for now. |
getColumn | final protected DataValueDescriptor getColumn(int columnIndex) throws SQLException, StandardException(Code) | | Get the column value for a getXXX() call.
This method:
- Closes the current stream (as per JDBC)
- Throws a SQLException if the result set is closed
- Throws a SQLException if the ResultSet is not on a row
- Throws a SQLException if the columnIndex is out of range
- Returns the DataValueDescriptor for the column.
|
getColumnSQLType | final String getColumnSQLType(int column)(Code) | | |
getColumnType | final int getColumnType(int columnIndex) throws SQLException(Code) | | Check the column is in range *and* return the JDBC type of the column.
exception: SQLException - ResultSet is not on a row or columnIndex is out of range. |
getConcurrency | public int getConcurrency() throws SQLException(Code) | | JDBC 2.0
Return the concurrency of this result set. The concurrency is determined
as follows If Statement object has CONCUR_READ_ONLY concurrency, then
ResultSet object will also have the CONCUR_READ_ONLY concurrency. But if
Statement object has CONCUR_UPDATABLE concurrency, then the concurrency
of ResultSet object depends on whether the underlying language resultset
is updatable or not. If the language resultset is updatable, then JDBC
ResultSet object will also have the CONCUR_UPDATABLE concurrency. If
lanugage resultset is not updatable, then JDBC ResultSet object
concurrency will be set to CONCUR_READ_ONLY.
the concurrency type, CONCUR_READ_ONLY, etc. exception: SQLException - if a database-access error occurs |
getCursorName | final public String getCursorName() throws SQLException(Code) | | Get the name of the SQL cursor used by this ResultSet.
In SQL, a result table is retrieved through a cursor that is
named. The current row of a result can be updated or deleted
using a positioned update/delete statement that references the
cursor name.
JDBC supports this SQL feature by providing the name of the
SQL cursor used by a ResultSet. The current row of a ResultSet
is also the current row of this SQL cursor.
Note: If positioned update is not supported a
SQLException is thrown
the ResultSet's SQL cursor name exception: SQLException - thrown on failure. |
getDate | final public Date getDate(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Date object.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is null exception: SQLException - thrown on failure. |
getDate | public java.sql.Date getDate(int columnIndex, Calendar cal) throws SQLException(Code) | | JDBC 2.0
Get the value of a column in the current row as a java.sql.Date
object. Use the calendar to construct an appropriate millisecond
value for the Date, if the underlying database doesn't store
timezone information.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: cal - the calendar to use in constructing the date the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getDate | public java.sql.Date getDate(String columnName, Calendar cal) throws SQLException(Code) | | JDBC 2.0
Get the value of a column in the current row as a java.sql.Date
object. Use the calendar to construct an appropriate millisecond
value for the Date, if the underlying database doesn't store
timezone information.
Parameters: columnName - is the SQL name of the column Parameters: cal - the calendar to use in constructing the date the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getDate | final public Date getDate(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Date object.
Parameters: columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is null exception: SQLException - thrown on failure. |
getDouble | final public double getDouble(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java double.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is 0 exception: SQLException - thrown on failure. |
getDouble | final public double getDouble(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a Java double.
Parameters: columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is 0 exception: SQLException - thrown on failure. |
getFetchDirection | public int getFetchDirection() throws SQLException(Code) | | JDBC 2.0
Return the fetch direction for this result set.
exception: SQLException - if a database-access error occurs |
getFetchSize | public int getFetchSize() throws SQLException(Code) | | JDBC 2.0
Return the fetch size for this result set.
exception: SQLException - if a database-access error occurs |
getFloat | final public float getFloat(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java float.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is 0 exception: SQLException - thrown on failure. |
getFloat | final public float getFloat(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a Java float.
Parameters: columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is 0 exception: SQLException - thrown on failure. |
getHoldability | final public int getHoldability() throws SQLException(Code) | | JDBC 4.0
Retrieves the holdability for this ResultSet
object.
either ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT exception: SQLException - if a database error occurs |
getInt | final public int getInt(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java int.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is 0 exception: SQLException - thrown on failure. |
getInt | final public int getInt(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a Java int.
Parameters: columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is 0 exception: SQLException - thrown on failure. |
getLong | final public long getLong(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java long.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is 0 exception: SQLException - thrown on failure. |
getLong | final public long getLong(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a Java long.
Parameters: columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is 0 exception: SQLException - thrown on failure. |
getMetaData | public ResultSetMetaData getMetaData() throws SQLException(Code) | | The number, types and properties of a ResultSet's columns
are provided by the getMetaData method.
the description of a ResultSet's columns exception: SQLException - thrown on failure. |
getObject | final public Object getObject(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java object.
This method will return the value of the given column as a
Java object. The type of the Java object will be the default
Java Object type corresponding to the column's SQL type,
following the mapping specified in the JDBC spec.
This method may also be used to read datatabase specific abstract
data types.
JDBC 2.0
New behavior for getObject().
The behavior of method getObject() is extended to materialize
data of SQL user-defined types. When the column @columnIndex is
a structured or distinct value, the behavior of this method is as
if it were a call to: getObject(columnIndex,
this.getStatement().getConnection().getTypeMap()).
Parameters: columnIndex - the first column is 1, the second is 2, ... A java.lang.Object holding the column value. exception: SQLException - thrown on failure. |
getObject | final public Object getObject(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a Java object.
This method will return the value of the given column as a
Java object. The type of the Java object will be the default
Java Object type corresponding to the column's SQL type,
following the mapping specified in the JDBC spec.
This method may also be used to read datatabase specific abstract
data types.
JDBC 2.0
New behavior for getObject().
The behavior of method getObject() is extended to materialize
data of SQL user-defined types. When the column @columnName is
a structured or distinct value, the behavior of this method is as
if it were a call to: getObject(columnName,
this.getStatement().getConnection().getTypeMap()).
Parameters: columnName - is the SQL name of the column A java.lang.Object holding the column value. exception: SQLException - thrown on failure. |
getParameterValueSet | protected ParameterValueSet getParameterValueSet()(Code) | | Try to see if we can fish the pvs out of the local statement.
null if we cannot figure out what parameter value set is currentlyusing |
getRow | public int getRow() throws SQLException(Code) | | JDBC 2.0
Determine the current row number. The first row is number 1, the second
number 2, etc.
the current row number, else return 0 if there is no current row exception: SQLException - if a database-access error occurs. |
getSQLText | protected String getSQLText()(Code) | | Try to see if we can fish the SQL Statement out of the local statement.
null if we cannot figure out what SQL Statement is currentlyexecuting |
getShort | final public short getShort(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java short.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is 0 exception: SQLException - thrown on failure. |
getShort | final public short getShort(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a Java short.
Parameters: columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is 0 exception: SQLException - thrown on failure. |
getStatement | final public Statement getStatement() throws SQLException(Code) | | JDBC 2.0
Return the Statement that produced the ResultSet.
the Statment that produced the result set, or null if the resultwas produced some other way. exception: SQLException - if a database error occurs or theresult set is closed |
getString | final public String getString(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java String.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is null exception: SQLException - thrown on failure. |
getString | final public String getString(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a Java String.
Parameters: columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is null exception: SQLException - thrown on failure. |
getTime | final public Time getTime(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Time object.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is null exception: SQLException - thrown on failure. |
getTime | public java.sql.Time getTime(int columnIndex, Calendar cal) throws SQLException(Code) | | JDBC 2.0
Get the value of a column in the current row as a java.sql.Time
object. Use the calendar to construct an appropriate millisecond
value for the Time, if the underlying database doesn't store
timezone information.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: cal - the calendar to use in constructing the time the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getTime | public java.sql.Time getTime(String columnName, Calendar cal) throws SQLException(Code) | | JDBC 2.0
Get the value of a column in the current row as a java.sql.Time
object. Use the calendar to construct an appropriate millisecond
value for the Time, if the underlying database doesn't store
timezone information.
Parameters: columnName - is the SQL name of the column Parameters: cal - the calendar to use in constructing the time the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getTime | final public Time getTime(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Time object.
Parameters: columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is null exception: SQLException - thrown on failure. |
getTimestamp | final public Timestamp getTimestamp(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Timestamp object.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is null exception: SQLException - thrown on failure. |
getTimestamp | public java.sql.Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException(Code) | | JDBC 2.0
Get the value of a column in the current row as a java.sql.Timestamp
object. Use the calendar to construct an appropriate millisecond
value for the Timestamp, if the underlying database doesn't store
timezone information.
Parameters: columnName - is the SQL name of the column Parameters: cal - the calendar to use in constructing the timestamp the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getTimestamp | public java.sql.Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException(Code) | | JDBC 2.0
Get the value of a column in the current row as a java.sql.Timestamp
object. Use the calendar to construct an appropriate millisecond
value for the Timestamp, if the underlying database doesn't store
timezone information.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: cal - the calendar to use in constructing the timestamp the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getTimestamp | final public Timestamp getTimestamp(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Timestamp object.
Parameters: columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is null exception: SQLException - thrown on failure. |
getType | public int getType() throws SQLException(Code) | | JDBC 2.0
Return the type of this result set. The type is determined based on the
statement that created the result set.
TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, orTYPE_SCROLL_SENSITIVE exception: SQLException - if a database-access error occurs |
getURL | public URL getURL(int columnIndex) throws SQLException(Code) | | JDBC 3.0
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.
Parameters: columnIndex - -the first column is 1, the second is 2 the column value as a java.net.URL object, if the value is SQLNULL, the value returned is null in the Java programming language exception: SQLException - Feature not implemented for now. |
getURL | public URL getURL(String columnName) throws SQLException(Code) | | JDBC 3.0
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.
Parameters: columnName - -the SQL name of the column the column value as a java.net.URL object, if the value is SQLNULL, the value returned is null in the Java programming language exception: SQLException - Feature not implemented for now. |
getWarnings | final public SQLWarning getWarnings() throws SQLException(Code) | | The first warning reported by calls on this ResultSet is
returned. Subsequent ResultSet warnings will be chained to this
SQLWarning.
The warning chain is automatically cleared each time a new
row is read.
Note: This warning chain only covers warnings caused
by ResultSet methods. Any warning caused by statement methods
(such as reading OUT parameters) will be chained on the
Statement object.
the first SQLWarning or null exception: SQLException - Thrown if this ResultSet is closed |
insertRow | public void insertRow() throws SQLException(Code) | | JDBC 2.0
Insert the contents of the insert row into the result set and the
database. Must be on the insert row when this method is called.
exception: SQLException - if a database-access error occurs, if called when not onthe insert row, or if all non-nullable columns in theinsert row have not been given a value |
isAfterLast | public boolean isAfterLast() throws SQLException(Code) | | JDBC 2.0
Determine if the cursor is after the last row in the result set.
true if after the last row, false otherwise. Returns false whenthe result set contains no rows. exception: SQLException - Thrown on error. |
isBeforeFirst | public boolean isBeforeFirst() throws SQLException(Code) | | JDBC 2.0
Determine if the cursor is before the first row in the result set.
true if before the first row, false otherwise. Returns false whenthe result set contains no rows. exception: SQLException - Thrown on error. |
isClosed | final public boolean isClosed() throws SQLException(Code) | | JDBC 4.0
Checks whether this ResultSet object has been
closed, either automatically or because close()
has been called.
true if the ResultSet isclosed, false otherwise exception: SQLException - if a database error occurs |
isFirst | public boolean isFirst() throws SQLException(Code) | | JDBC 2.0
Determine if the cursor is on the first row of the result set.
true if on the first row, false otherwise. exception: SQLException - Thrown on error. |
isForUpdate | final public boolean isForUpdate()(Code) | | Is this result set from a select for update statement?
|
isLast | public boolean isLast() throws SQLException(Code) | | JDBC 2.0
Determine if the cursor is on the last row of the result set. Note:
Calling isLast() may be expensive since the JDBC driver might need to
fetch ahead one row in order to determine whether the current row is the
last row in the result set.
true if on the last row, false otherwise. exception: SQLException - Thrown on error. |
last | public boolean last() throws SQLException(Code) | | JDBC 2.0
Moves to the last row in the result set.
true if on a valid row, false if no rows in the result set. exception: SQLException - if a database-access error occurs, or result set type isTYPE_FORWARD_ONLY. |
moveToCurrentRow | public void moveToCurrentRow() throws SQLException(Code) | | JDBC 2.0
Move the cursor to the remembered cursor position, usually the current
row. Has no effect unless the cursor is on the insert row.
exception: SQLException - if a database-access error occurs, or the result set isnot updatable |
moveToInsertRow | public void moveToInsertRow() throws SQLException(Code) | | JDBC 2.0
Move to the insert row. The current cursor position is remembered while
the cursor is positioned on the insert row.
The insert row is a special row associated with an updatable result set.
It is essentially a buffer where a new row may be constructed by calling
the 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(). UpdateXXX()must be called before getXXX() on a column.
exception: SQLException - if a database-access error occurs, or the result set isnot updatable |
next | public boolean next() throws SQLException(Code) | | A ResultSet is initially positioned before its first row; the
first call to next makes the first row the current row; the
second call makes the second row the current row, etc.
If an input stream from the previous row is open, it is
implicitly closed. The ResultSet's warning chain is cleared
when a new row is read.
true if the new current row is valid; false if thereare no more rows exception: SQLException - thrown on failure. |
noStateChangeException | final static SQLException noStateChangeException(Throwable thrownException)(Code) | | An exception on many method calls to JDBC objects does not change the state
of the transaction or statement, or even the underlying object. This method
simply wraps the excecption in a SQLException. Examples are:
- getXXX() calls on ResultSet - ResultSet is not closed.
- setXXX() calls on PreparedStatement - ResultSet is not closed.
In addition these exceptions must not call higher level objects to
be closed (e.g. when executing a server side Java procedure). See bug 4397
|
previous | public boolean previous() throws SQLException(Code) | | JDBC 2.0
Moves to the previous row in the result set.
Note: previous() is not the same as relative(-1) since it makes sense to
call previous() when there is no current row.
true if on a valid row, false if off the result set. exception: SQLException - if a database-access error occurs, or result set type isTYPE_FORWAR_DONLY. |
refreshRow | public void refreshRow() throws SQLException(Code) | | JDBC 2.0
Refresh the value of the current row with its current value in the
database. Cannot be called when on the insert row.
The 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 refreshRow() frequently will likely slow performance.
exception: SQLException - if a database-access error occurs, or if called when onthe insert row. |
relative | public boolean relative(int row) throws SQLException(Code) | | JDBC 2.0
Moves a relative number of rows, either positive or negative. Attempting
to move beyond the first/last row in the result set positions the cursor
before/after the the first/last row. Calling relative(0) is valid, but
does not change the cursor position.
Note: Calling relative(1) is different than calling next() since is makes
sense to call next() when there is no current row, for example, when the
cursor is positioned before the first row or after the last row of the
result set.
true if on a row, false otherwise. exception: SQLException - if a database-access error occurs, or there is no currentrow, or result set type is TYPE_FORWARD_ONLY. |
rowDeleted | public boolean rowDeleted() throws SQLException(Code) | | JDBC 2.0
Determine if this row has been deleted. A deleted row may leave a visible
"hole" in a result set. This method can be used to detect holes in a
result set. The value returned depends on whether or not the result set
can detect deletions.
true if deleted and deletes are detected exception: SQLException - if a database-access error occurs See Also: EmbedDatabaseMetaData.deletesAreDetected |
rowInserted | public boolean rowInserted() throws SQLException(Code) | | JDBC 2.0
Determine if the current row has been inserted. The value returned
depends on whether or not the result set can detect visible inserts.
true if inserted and inserts are detected exception: SQLException - if a database-access error occurs See Also: EmbedDatabaseMetaData.insertsAreDetected |
rowUpdated | public boolean rowUpdated() throws SQLException(Code) | | JDBC 2.0
Determine if the current row has been updated. The value returned depends
on whether or not the result set can detect updates.
true if the row has been visibly updated by the owner or another,and updates are detected exception: SQLException - if a database-access error occurs See Also: EmbedDatabaseMetaData.updatesAreDetected |
setApplicationStatement | final public void setApplicationStatement(Statement applicationStmt)(Code) | | Set the application Statement object that created this ResultSet.
Used when the Statement objects returned to the application
are wrapped for XA.
|
setDynamicResultSet | void setDynamicResultSet(EmbedStatement owningStmt)(Code) | | A dynamic result set was created in a procedure by a nested connection.
Once the procedure returns, there is a good chance that connection is closed,
so we re-attach the result set to the connection of the statement the called
the procedure, which will be still open.
|
setFetchDirection | public void setFetchDirection(int direction) throws SQLException(Code) | | JDBC 2.0
Give a hint as to the direction in which the rows in this result set will
be processed. The initial value is determined by the statement that
produced the result set. The fetch direction may be changed at any time.
exception: SQLException - if a database-access error occurs, or the result set typeis TYPE_FORWARD_ONLY and direction is not FETCH_FORWARD. |
setFetchSize | public void setFetchSize(int rows) throws SQLException(Code) | | JDBC 2.0
Give the JDBC driver a hint as to the number of rows that should be
fetched from the database when more rows are needed for this result set.
If the fetch size specified is zero, then the JDBC driver ignores the
value, and is free to make its own best guess as to what the fetch size
should be. The default value is set by the statement that creates the
result set. The fetch size may be changed at any time.
Parameters: rows - the number of rows to fetch exception: SQLException - if a database-access error occurs, or the condition 0 <=rows <= this.getMaxRows() is not satisfied. |
updateAsciiStream | public void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws SQLException(Code) | | Update a column with an ascii stream value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value Parameters: length - the length of the stream exception: SQLException - if a database-access error occurs |
updateAsciiStream | public void updateAsciiStream(int columnIndex, InputStream x) throws SQLException(Code) | | Updates the designated column with a character stream value.
The data will be read from the stream as needed until end-of-stream is
reached.
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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value throws: SQLException - if the columnIndex is not valid; if a databaseaccess error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closedresult set |
updateAsciiStream | public void updateAsciiStream(String columnName, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0
Update a column with an ascii stream value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value Parameters: length - of the stream exception: SQLException - if a database-access error occurs |
updateAsciiStream | public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0
Update a column with an ascii stream value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value Parameters: length - the length of the stream exception: SQLException - if a database-access error occurs |
updateAsciiStream | public void updateAsciiStream(String columnName, java.io.InputStream x, long length) throws SQLException(Code) | | JDBC 4.0
Update a column with an ascii stream value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value Parameters: length - of the stream exception: SQLException - if a database-access error occurs |
updateAsciiStream | public void updateAsciiStream(String columnName, InputStream x) throws SQLException(Code) | | Updates the designated column with a character stream value.
The data will be read from the stream as needed until end-of-stream is
reached.
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.
Parameters: columnName - the label for the column specified with the SQL ASclause. If the SQL AS clause was not specified, then the label isthe name of the column Parameters: x - the new column value throws: SQLException - if the columnIndex is not valid; if a databaseaccess error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closedresult set |
updateBinaryStream | public void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws SQLException(Code) | | Update a column with a binary stream value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value Parameters: length - the length of the stream exception: SQLException - if a database-access error occurs |
updateBinaryStream | public void updateBinaryStream(int columnIndex, InputStream x) throws SQLException(Code) | | Updates the designated column with a binary stream value.
The data will be read from the stream as needed until end-of-stream is
reached.
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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value throws: SQLException - if the columnLabel is not valid; if a databaseaccess error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closedresult set |
updateBinaryStream | public void updateBinaryStream(String columnName, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0
Update a column with a binary stream value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value Parameters: length - of the stream exception: SQLException - if a database-access error occurs |
updateBinaryStream | public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0
Update a column with a binary stream value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value Parameters: length - the length of the stream exception: SQLException - if a database-access error occurs |
updateBinaryStream | public void updateBinaryStream(String columnName, java.io.InputStream x, long length) throws SQLException(Code) | | JDBC 4.0
Update a column with a binary stream value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value Parameters: length - of the stream exception: SQLException - if a database-access error occurs |
updateBinaryStream | public void updateBinaryStream(String columnName, InputStream x) throws SQLException(Code) | | Updates the designated column with a binary stream value.
The data will be read from the stream as needed until end-of-stream is
reached.
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.
Parameters: columnName - the label for the column specified with the SQL ASclause. If the SQL AS clause was not specified, then the label isthe name of the column Parameters: x - the new column value throws: SQLException - if the columnLabel is not valid; if a databaseaccess error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closedresult set |
updateBlob | public void updateBlob(int columnIndex, Blob x) throws SQLException(Code) | | JDBC 3.0
Updates the designated column with a 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.
Parameters: columnIndex - -the first column is 1, the second is 2 Parameters: x - -the new column value exception: SQLException - Feature not implemented for now. |
updateBlob | public void updateBlob(String columnName, Blob x) throws SQLException(Code) | | JDBC 3.0
Updates the designated column with a 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.
Parameters: columnName - -the SQL name of the column Parameters: x - -the new column value exception: SQLException - Feature not implemented for now. |
updateBlob | public void updateBlob(int columnIndex, InputStream x, long length) throws SQLException(Code) | | JDBC 4.0
Updates the designated column with a 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.
Parameters: columnIndex - -the first column is 1, the second is 2 Parameters: x - -the new column value Parameters: length - -the length of the Blob datatype exception: SQLException - |
updateBlob | public void updateBlob(int columnIndex, InputStream x) throws SQLException(Code) | | Updates the designated column using the given input stream.
The data will be read from the stream as needed until end-of-stream is reached.
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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - an object that contains the data to set theparameter value to. throws: SQLException - if the columnIndex is not valid; if a databaseaccess error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closedresult set |
updateBlob | public void updateBlob(String columnName, InputStream x, long length) throws SQLException(Code) | | JDBC 4.0
Updates the designated column with a 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.
Parameters: columnName - -the name of the column to be updated Parameters: x - -the new column value Parameters: length - -the length of the Blob datatype exception: SQLException - |
updateBlob | public void updateBlob(String columnName, InputStream x) throws SQLException(Code) | | Updates the designated column using the given input stream.
The data will be read from the stream as needed until end-of-stream is reached.
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.
Parameters: columnName - the label for the column specified with the SQL ASclause. If the SQL AS clause was not specified, then the label isthe name of the column Parameters: x - an object that contains the data to set theparameter value to. throws: SQLException - if the columnIndex is not valid; if a databaseaccess error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closedresult set |
updateBoolean | public void updateBoolean(int columnIndex, boolean x) throws SQLException(Code) | | JDBC 2.0
Update a column with a boolean value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateBoolean | public void updateBoolean(String columnName, boolean x) throws SQLException(Code) | | JDBC 2.0
Update a column with a boolean value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateByte | public void updateByte(int columnIndex, byte x) throws SQLException(Code) | | JDBC 2.0
Update a column with a byte value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateByte | public void updateByte(String columnName, byte x) throws SQLException(Code) | | JDBC 2.0
Update a column with a byte value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateBytes | public void updateBytes(int columnIndex, byte x) throws SQLException(Code) | | JDBC 2.0
Update a column with a byte array value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateBytes | public void updateBytes(String columnName, byte x) throws SQLException(Code) | | JDBC 2.0
Update a column with a byte array value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateCharacterStream | public void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws SQLException(Code) | | JDBC 4.0
Update a column with a character stream value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value Parameters: length - the length of the stream exception: SQLException - if a database-access error occurs |
updateCharacterStream | public void updateCharacterStream(int columnIndex, Reader x) throws SQLException(Code) | | Updates the designated column with a character stream value.
The data will be read from the stream as needed until end-of-stream is
reached.
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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value throws: SQLException - if the columnIndex is not valid; if a databaseaccess error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closedresult set |
updateCharacterStream | public void updateCharacterStream(String columnName, java.io.Reader reader, int length) throws SQLException(Code) | | JDBC 2.0
Update a column with a character stream value.
The 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.
Parameters: columnName - the name of the column Parameters: reader - the new column value Parameters: length - length of the stream exception: SQLException - if a database-access error occurs |
updateCharacterStream | public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws SQLException(Code) | | JDBC 2.0
Update a column with a character stream value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value Parameters: length - the length of the stream exception: SQLException - if a database-access error occurs |
updateCharacterStream | public void updateCharacterStream(String columnName, java.io.Reader reader, long length) throws SQLException(Code) | | JDBC 4.0
Update a column with a character stream value.
The 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.
Parameters: columnName - the name of the column Parameters: reader - the new column value Parameters: length - length of the stream exception: SQLException - if a database-access error occurs |
updateCharacterStream | public void updateCharacterStream(String columnName, Reader reader) throws SQLException(Code) | | Updates the designated column with a character stream value.
The data will be read from the stream as needed until end-of-stream is
reached.
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.
Parameters: columnName - the label for the column specified with the SQL ASclause. If the SQL AS clause was not specified, then the label isthe name of the column Parameters: reader - the new column value throws: SQLException - if the columnIndex is not valid; if a databaseaccess error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closedresult set |
updateClob | public void updateClob(int columnIndex, Clob x) throws SQLException(Code) | | JDBC 3.0
Updates the designated column with a 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.
Parameters: columnIndex - -the first column is 1, the second is 2 Parameters: x - -the new column value exception: SQLException - Feature not implemented for now. |
updateClob | public void updateClob(String columnName, Clob x) throws SQLException(Code) | | JDBC 3.0
Updates the designated column with a 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.
Parameters: columnName - -the SQL name of the column Parameters: x - -the new column value exception: SQLException - Feature not implemented for now. |
updateClob | public void updateClob(int columnIndex, Reader x, long length) throws SQLException(Code) | | JDBC 4.0
Updates the designated column with a 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.
Parameters: columnIndex - -the first column is 1, the second is 2 Parameters: x - -the new column value exception: SQLException - Feature not implemented for now. |
updateClob | public void updateClob(int columnIndex, Reader x) throws SQLException(Code) | | Updates the designated column using the given 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - an object that contains the data to set the parametervalue to throws: SQLException - if the columnIndex is not valid; if a databaseaccess error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closedresult set |
updateClob | public void updateClob(String columnName, Reader x, long length) throws SQLException(Code) | | JDBC 4.0
Updates the designated column with a 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.
Parameters: columnName - -the name of the Clob column Parameters: x - -the new column value exception: SQLException - Feature not implemented for now. |
updateClob | public void updateClob(String columnName, Reader x) throws SQLException(Code) | | Updates the designated column using the given 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.
Parameters: columnName - the label for the column specified with the SQL ASclause. If the SQL AS clause was not specified, then the label isthe name of the column Parameters: x - an object that contains the data to set the parametervalue to throws: SQLException - if the columnIndex is not valid; if a databaseaccess error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closedresult set |
updateDate | public void updateDate(int columnIndex, java.sql.Date x) throws SQLException(Code) | | JDBC 2.0
Update a column with a Date value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateDate | public void updateDate(String columnName, java.sql.Date x) throws SQLException(Code) | | JDBC 2.0
Update a column with a Date value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateDouble | public void updateDouble(int columnIndex, double x) throws SQLException(Code) | | JDBC 2.0
Update a column with a Double value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateDouble | public void updateDouble(String columnName, double x) throws SQLException(Code) | | JDBC 2.0
Update a column with a double value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateFloat | public void updateFloat(int columnIndex, float x) throws SQLException(Code) | | JDBC 2.0
Update a column with a float value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateFloat | public void updateFloat(String columnName, float x) throws SQLException(Code) | | JDBC 2.0
Update a column with a float value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateInt | public void updateInt(int columnIndex, int x) throws SQLException(Code) | | JDBC 2.0
Update a column with an integer value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateInt | public void updateInt(String columnName, int x) throws SQLException(Code) | | JDBC 2.0
Update a column with an integer value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateLong | public void updateLong(int columnIndex, long x) throws SQLException(Code) | | JDBC 2.0
Update a column with a long value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateLong | public void updateLong(String columnName, long x) throws SQLException(Code) | | JDBC 2.0
Update a column with a long value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateNull | public void updateNull(int columnIndex) throws SQLException(Code) | | JDBC 2.0
Give a nullable column a null value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... exception: SQLException - if a database-access error occurs |
updateNull | public void updateNull(String columnName) throws SQLException(Code) | | JDBC 2.0
Update a column with a null value.
The 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.
Parameters: columnName - the name of the column exception: SQLException - if a database-access error occurs |
updateObject | public void updateObject(int columnIndex, Object x, int scale) throws SQLException(Code) | | JDBC 2.0
Update a column with an Object value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value Parameters: scale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC typesthis is the number of digits after the decimal. For all othertypes this value will be ignored. exception: SQLException - if a database-access error occurs |
updateObject | public void updateObject(int columnIndex, Object x) throws SQLException(Code) | | JDBC 2.0
Update a column with an Object value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateObject | public void updateObject(String columnName, Object x, int scale) throws SQLException(Code) | | JDBC 2.0
Update a column with an Object value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value Parameters: scale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC typesthis is the number of digits after the decimal. For all othertypes this value will be ignored. exception: SQLException - if a database-access error occurs |
updateObject | public void updateObject(String columnName, Object x) throws SQLException(Code) | | JDBC 2.0
Update a column with an Object value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateRow | public void updateRow() throws SQLException(Code) | | JDBC 2.0
Update the underlying database with the new contents of the
current row. Cannot be called when on the insert row.
exception: SQLException - if a database-access error occurs, orif called when on the insert row |
updateShort | public void updateShort(int columnIndex, short x) throws SQLException(Code) | | JDBC 2.0
Update a column with a short value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateShort | public void updateShort(String columnName, short x) throws SQLException(Code) | | JDBC 2.0
Update a column with a short value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateString | public void updateString(int columnIndex, String x) throws SQLException(Code) | | JDBC 2.0
Update a column with a String value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateString | public void updateString(String columnName, String x) throws SQLException(Code) | | JDBC 2.0
Update a column with a String value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateTime | public void updateTime(int columnIndex, java.sql.Time x) throws SQLException(Code) | | JDBC 2.0
Update a column with a Time value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateTime | public void updateTime(String columnName, java.sql.Time x) throws SQLException(Code) | | JDBC 2.0
Update a column with a Time value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateTimestamp | public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws SQLException(Code) | | JDBC 2.0
Update a column with a Timestamp value.
The 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.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateTimestamp | public void updateTimestamp(String columnName, java.sql.Timestamp x) throws SQLException(Code) | | JDBC 2.0
Update a column with a Timestamp value.
The 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.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
useStream | final void useStream(int columnIndex) throws SQLException(Code) | | Mark a column as already having a stream accessed from it.
If the stream was already accessed, then throw an exception.
Parameters: columnIndex - throws: SQLException - |
wasNull | final public boolean wasNull() throws SQLException(Code) | | A column may have the value of SQL NULL; wasNull reports whether
the last column read had this special value.
Note that you must first call getXXX on a column to try to read
its value and then call wasNull() to find if the value was
the SQL NULL.
we take the least exception approach and simply return false
if no column has been read yet.
true if last column read was SQL NULL exception: SQLException - Thrown if this ResultSet is closed |
|
|