public abstract class ResultSet extends Object implements ResultSet, ResultSetCallbackInterface
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE| Modifier | Constructor and Description |
|---|---|
protected |
ResultSet(Agent agent,
Statement statement,
Cursor cursor,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability) |
| Modifier and Type | Method and Description |
|---|---|
boolean |
absolute(int row) |
boolean |
absoluteX(int row) |
void |
accumulateWarning(SqlWarning e) |
void |
afterLast() |
void |
beforeFirst() |
void |
cancelRowUpdates() |
protected void |
checkAndThrowReceivedQueryTerminatingException() |
protected void |
checkForClosedResultSet() |
void |
clearWarnings()
Clear all warnings on this
ResultSet and make
subsequent calls to getWarnings() return
null until a new warning is reported. |
void |
clearWarningsX() |
void |
close() |
void |
closeX() |
void |
completeLocalCommit(Iterator listenerIterator) |
void |
completeLocalRollback(Iterator listenerIterator) |
int |
completeSqlca(Sqlca sqlca) |
protected void |
delete() |
void |
deleteRow() |
void |
earlyCloseComplete(Sqlca sqlca) |
void |
expandRowsetSqlca() |
int |
findColumn(String columnName) |
boolean |
first() |
void |
flowFetch() |
void |
flowPositioningFetch(int scrollOrientation,
int rowToFetch) |
Array |
getArray(int column) |
Array |
getArray(String columnName) |
InputStream |
getAsciiStream(int column) |
InputStream |
getAsciiStream(String columnName) |
BigDecimal |
getBigDecimal(int column) |
BigDecimal |
getBigDecimal(int column,
int scale)
Deprecated.
|
BigDecimal |
getBigDecimal(String columnName) |
BigDecimal |
getBigDecimal(String columnName,
int scale)
Deprecated.
|
InputStream |
getBinaryStream(int column) |
InputStream |
getBinaryStream(String columnName) |
Blob |
getBlob(int column) |
Blob |
getBlob(String columnName) |
boolean |
getBoolean(int column) |
boolean |
getBoolean(String columnName) |
byte |
getByte(int column) |
byte |
getByte(String columnName) |
byte[] |
getBytes(int column) |
byte[] |
getBytes(String columnName) |
Reader |
getCharacterStream(int column) |
Reader |
getCharacterStream(String columnName) |
Clob |
getClob(int column) |
Clob |
getClob(String columnName) |
int |
getConcurrency() |
ConnectionCallbackInterface |
getConnectionCallbackInterface() |
String |
getCursorName() |
Date |
getDate(int column) |
Date |
getDate(int column,
Calendar calendar) |
Date |
getDate(String columnName) |
Date |
getDate(String columnName,
Calendar cal) |
double |
getDouble(int column) |
double |
getDouble(String columnName) |
int |
getFetchDirection() |
int |
getFetchSize() |
float |
getFloat(int column) |
float |
getFloat(String columnName) |
int |
getHoldability()
Retrieves the holdability for this
ResultSet
object. |
int |
getInt(int column) |
int |
getInt(String columnName) |
long |
getLong(int column) |
long |
getLong(String columnName) |
ResultSetMetaData |
getMetaData() |
Object |
getObject(int column) |
Object |
getObject(int column,
Map map) |
Object |
getObject(String columnName) |
Object |
getObject(String columnName,
Map map) |
Ref |
getRef(int column) |
Ref |
getRef(String columnName) |
int |
getRow() |
protected void |
getRowCount() |
byte |
getRSReturnability() |
short |
getShort(int column) |
short |
getShort(String columnName) |
Statement |
getStatement()
Retrieves the
Statement object that produced this
object, or null if the ResultSet was
not produced by a Statement object. |
StatementCallbackInterface |
getStatementCallbackInterface() |
String |
getString(int column) |
String |
getString(String columnName) |
Time |
getTime(int column) |
Time |
getTime(int column,
Calendar calendar) |
Time |
getTime(String columnName) |
Time |
getTime(String columnName,
Calendar cal) |
Timestamp |
getTimestamp(int column) |
Timestamp |
getTimestamp(int column,
Calendar calendar) |
Timestamp |
getTimestamp(String columnName) |
Timestamp |
getTimestamp(String columnName,
Calendar cal) |
int |
getType() |
InputStream |
getUnicodeStream(int column)
Deprecated.
|
InputStream |
getUnicodeStream(String columnName)
Deprecated.
|
URL |
getURL(int columnIndex) |
URL |
getURL(String columnName) |
SQLWarning |
getWarnings()
Returns the first
SQLWarning reported on this
ResultSet object, or null if there
are no warnings. |
protected void |
insert() |
void |
insertRow() |
boolean |
isAfterLast() |
boolean |
isBeforeFirst() |
boolean |
isClosed()
Checks whether this
ResultSet object has been
closed, either automatically or because close()
has been called. |
boolean |
isFirst() |
boolean |
isLast() |
boolean |
last() |
void |
listenToUnitOfWork() |
void |
markClosedOnServer()
Mark this ResultSet as closed on the server.
|
void |
markLOBAsAccessed(int index)
Marks the LOB at the specified column as accessed.
|
protected void |
moveToAfterLast() |
protected void |
moveToBeforeFirst() |
void |
moveToCurrentRow() |
void |
moveToInsertRow() |
boolean |
next() |
void |
nullDataForGC() |
protected abstract void |
parseRowset_() |
void |
parseScrollableRowset() |
protected void |
positionToCurrentRowAndDelete() |
protected void |
positionToCurrentRowAndUpdate() |
protected abstract void |
preClose_()
Method that is invoked by
closeX() before the
result set is actually being closed. |
boolean |
previous() |
abstract void |
readCursorClose_() |
void |
readDeleteRow() |
abstract void |
readFetch_() |
void |
readInsertRow() |
abstract void |
readPositioningFetch_() |
abstract void |
readScrollableFetch_() |
void |
readUpdateRow() |
void |
refreshRow() |
boolean |
relative(int rows) |
boolean |
repositionScrollableResultSetBeforeJDBC1PositionedUpdateDelete() |
protected boolean |
rowCountIsKnown() |
protected boolean |
rowCountIsUnknown() |
boolean |
rowDeleted() |
boolean |
rowInserted() |
boolean |
rowUpdated() |
void |
setFetchDirection(int direction) |
abstract void |
setFetchSize_(int rows) |
void |
setFetchSize(int rows) |
void |
setRowCountEvent(long rowCount) |
void |
setRowsetAfterLastEvent() |
void |
setRowsetBeforeFirstEvent() |
void |
setRowsetNoRowsEvent() |
void |
setRSReturnability(byte rsReturnability) |
void |
setValidCursorPosition(boolean isValidCursorPosition) |
protected void |
update() |
void |
updateArray(int columnIndex,
Array x) |
void |
updateArray(String columnName,
Array x) |
void |
updateAsciiStream(int columnIndex,
InputStream x)
Updates the designated column with an ascii stream value.
|
void |
updateAsciiStream(int column,
InputStream x,
int length) |
void |
updateAsciiStream(int columnIndex,
InputStream x,
long length)
Update a column with an ascii stream value.
|
void |
updateAsciiStream(String columnName,
InputStream x)
Updates the designated column with an ascii stream value.
|
void |
updateAsciiStream(String columnName,
InputStream x,
int length) |
void |
updateAsciiStream(String columnName,
InputStream x,
long length)
Update a column with an ascii stream value.
|
void |
updateBigDecimal(int column,
BigDecimal x) |
void |
updateBigDecimal(String columnName,
BigDecimal x) |
void |
updateBinaryStream(int columnIndex,
InputStream x)
Updates the designated column with a binary stream value.
|
void |
updateBinaryStream(int column,
InputStream x,
int length) |
void |
updateBinaryStream(int columnIndex,
InputStream x,
long length)
Update a column with a binary stream value.
|
void |
updateBinaryStream(String columnLabel,
InputStream x)
Updates the designated column with a binary stream value.
|
void |
updateBinaryStream(String columnName,
InputStream x,
int length) |
void |
updateBinaryStream(String columnName,
InputStream x,
long length)
Update a column with a binary stream value.
|
void |
updateBlob(int columnIndex,
Blob x)
Updates the designated column with a
java.sql.Blob value. |
void |
updateBlob(int columnIndex,
InputStream x)
Updates the designated column using the given input stream.
|
void |
updateBlob(int columnIndex,
InputStream x,
long length)
Updates the designated column using the given input stream, which
will have the specified number of bytes.
|
void |
updateBlob(String columnName,
Blob x)
Updates the designated column with a
java.sql.Blob value. |
void |
updateBlob(String columnLabel,
InputStream x)
Updates the designated column using the given input stream.
|
void |
updateBlob(String columnName,
InputStream x,
long length)
Updates the designated column using the given input stream, which
will have the specified number of bytes.
|
void |
updateBoolean(int column,
boolean x) |
void |
updateBoolean(String columnName,
boolean x) |
void |
updateByte(int column,
byte x) |
void |
updateByte(String columnName,
byte x) |
void |
updateBytes(int column,
byte[] x) |
void |
updateBytes(String columnName,
byte[] x) |
void |
updateCharacterStream(int columnIndex,
Reader reader)
Updates the designated column with a character stream value.
|
void |
updateCharacterStream(int column,
Reader x,
int length) |
void |
updateCharacterStream(int columnIndex,
Reader x,
long length)
Update a column with a character stream value.
|
void |
updateCharacterStream(String columnLabel,
Reader reader)
Updates the designated column with a character stream value.
|
void |
updateCharacterStream(String columnName,
Reader x,
int length) |
void |
updateCharacterStream(String columnName,
Reader reader,
long length)
Update a column with a character stream value.
|
void |
updateClob(int columnIndex,
Clob x)
Updates the designated column with a
java.sql.Clob value. |
void |
updateClob(int columnIndex,
Reader reader)
Updates the designated column using the given
Reader
object. |
void |
updateClob(int columnIndex,
Reader x,
long length)
Updates the designated column using the given
Reader
object, which is the given number of characters long. |
void |
updateClob(String columnLabel,
Clob x)
Updates the designated column with a
java.sql.Clob value. |
void |
updateClob(String columnLabel,
Reader reader)
Updates the designated column using the given
Reader
object. |
void |
updateClob(String columnName,
Reader x,
long length)
Updates the designated column using the given
Reader
object, which is the given number of characters long. |
protected void |
updateColumnInfoFromCache() |
void |
updateDate(int column,
Date x) |
void |
updateDate(String columnName,
Date x) |
void |
updateDouble(int column,
double x) |
void |
updateDouble(String columnName,
double x) |
void |
updateFloat(int column,
float x) |
void |
updateFloat(String columnName,
float x) |
void |
updateInt(int column,
int x) |
void |
updateInt(String columnName,
int x) |
void |
updateLong(int column,
long x) |
void |
updateLong(String columnName,
long x) |
void |
updateNCharacterStream(int columnIndex,
Reader x) |
void |
updateNCharacterStream(String columnName,
Reader x) |
void |
updateNClob(int columnIndex,
Reader reader) |
void |
updateNClob(String columnName,
Reader reader) |
void |
updateNull(int column) |
void |
updateNull(String columnName) |
void |
updateObject(int column,
Object x) |
void |
updateObject(int column,
Object x,
int scale) |
void |
updateObject(String columnName,
Object x) |
void |
updateObject(String columnName,
Object x,
int scale) |
void |
updateRef(int columnIndex,
Ref x) |
void |
updateRef(String columnName,
Ref x) |
void |
updateRow() |
void |
updateShort(int column,
short x) |
void |
updateShort(String columnName,
short x) |
void |
updateString(int column,
String x) |
void |
updateString(String columnName,
String x) |
void |
updateTime(int column,
Time x) |
void |
updateTime(String columnName,
Time x) |
void |
updateTimestamp(int column,
Timestamp x) |
void |
updateTimestamp(String columnName,
Timestamp x) |
boolean |
wasNull() |
abstract void |
writeCursorClose_(Section section) |
void |
writeDeleteRow() |
abstract void |
writeFetch_(Section section) |
void |
writeInsertRow(boolean chainedWritesFollowingSetLob) |
abstract void |
writePositioningFetch_(Section section,
int orientation,
long rowToFetch) |
abstract void |
writeScrollableFetch_(Section section,
int fetchSize,
int orientation,
long rowToFetch,
boolean resetQueryBlocks) |
void |
writeUpdateRow(boolean chainedWritesFollowingSetLob) |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitgetNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getRowId, getRowId, getSQLXML, getSQLXML, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateRowId, updateRowId, updateSQLXML, updateSQLXMLisWrapperFor, unwrappublic Statement statement_
public ColumnMetaData resultSetMetaData_
public Cursor cursor_
protected Agent agent_
public Section generatedSection_
public final Connection connection_
public static final int scrollOrientation_relative__
public static final int scrollOrientation_absolute__
public static final int scrollOrientation_after__
public static final int scrollOrientation_before__
public static final int scrollOrientation_prior__
public static final int scrollOrientation_first__
public static final int scrollOrientation_last__
public static final int scrollOrientation_current__
public static final int scrollOrientation_next__
public static final int updatability_unknown__
public static final int updatability_readOnly__
public static final int updatability_delete__
public static final int updatability_update__
public static final int sensitivity_unknown__
public static final int sensitivity_insensitive__
public static final int sensitivity_sensitive_static__
public static final int sensitivity_sensitive_dynamic__
public static final int NEXT_ROWSET
public static final int PREVIOUS_ROWSET
public static final int ABSOLUTE_ROWSET
public static final int FIRST_ROWSET
public static final int LAST_ROWSET
public static final int RELATIVE_ROWSET
public static final int REFRESH_ROWSET
public static final byte DDM_RETURN_CALLER
public static final byte DDM_RETURN_CLIENT
protected byte rsReturnability_
public boolean openOnServer_
public Sqlca queryTerminatingSqlca_
public boolean isValidCursorPosition_
public boolean cursorHold_
public long queryInstanceIdentifier_
public int resultSetType_
public int resultSetConcurrency_
public int resultSetHoldability_
public boolean scrollable_
public int sensitivity_
public boolean isRowsetCursor_
public boolean isBeforeFirst_
public boolean isAfterLast_
public boolean isFirst_
public boolean isLast_
public boolean rowsetContainsLastRow_
public Sqlca[] rowsetSqlca_
protected int suggestedFetchSize_
public int fetchSize_
public int fetchDirection_
public long rowCount_
protected long absolutePosition_
protected long firstRowInRowset_
protected long lastRowInRowset_
protected long currentRowInRowset_
protected long absoluteRowNumberForTheIntendedRow_
protected boolean isOnCurrentRow_
public int rowsReceivedInCurrentRowset_
public int rowsYetToBeReceivedForRowset_
public int nestingLevel_
public boolean cursorUnpositionedOnServer_
public boolean next()
throws SQLException
next in interface ResultSetSQLExceptionpublic void close()
throws SQLException
close in interface AutoCloseableclose in interface ResultSetSQLExceptionpublic final void closeX()
throws SqlException
SqlExceptionpublic void nullDataForGC()
public boolean wasNull()
throws SQLException
wasNull in interface ResultSetSQLExceptionpublic boolean getBoolean(int column)
throws SQLException
getBoolean in interface ResultSetSQLExceptionpublic byte getByte(int column)
throws SQLException
getByte in interface ResultSetSQLExceptionpublic short getShort(int column)
throws SQLException
getShort in interface ResultSetSQLExceptionpublic int getInt(int column)
throws SQLException
getInt in interface ResultSetSQLExceptionpublic long getLong(int column)
throws SQLException
getLong in interface ResultSetSQLExceptionpublic float getFloat(int column)
throws SQLException
getFloat in interface ResultSetSQLExceptionpublic double getDouble(int column)
throws SQLException
getDouble in interface ResultSetSQLExceptionpublic BigDecimal getBigDecimal(int column, int scale) throws SQLException
getBigDecimal in interface ResultSetSQLExceptionpublic BigDecimal getBigDecimal(int column) throws SQLException
getBigDecimal in interface ResultSetSQLExceptionpublic Date getDate(int column) throws SQLException
getDate in interface ResultSetSQLExceptionpublic Date getDate(int column, Calendar calendar) throws SQLException
getDate in interface ResultSetSQLExceptionpublic Time getTime(int column) throws SQLException
getTime in interface ResultSetSQLExceptionpublic Time getTime(int column, Calendar calendar) throws SQLException
getTime in interface ResultSetSQLExceptionpublic Timestamp getTimestamp(int column) throws SQLException
getTimestamp in interface ResultSetSQLExceptionpublic Timestamp getTimestamp(int column, Calendar calendar) throws SQLException
getTimestamp in interface ResultSetSQLExceptionpublic String getString(int column) throws SQLException
getString in interface ResultSetSQLExceptionpublic byte[] getBytes(int column)
throws SQLException
getBytes in interface ResultSetSQLExceptionpublic InputStream getBinaryStream(int column) throws SQLException
getBinaryStream in interface ResultSetSQLExceptionpublic InputStream getAsciiStream(int column) throws SQLException
getAsciiStream in interface ResultSetSQLExceptionpublic InputStream getUnicodeStream(int column) throws SQLException
getUnicodeStream in interface ResultSetcolumn - the column to retrieve as a Unicode streamSQLException - throws feature not implementedpublic Reader getCharacterStream(int column) throws SQLException
getCharacterStream in interface ResultSetSQLExceptionpublic Blob getBlob(int column) throws SQLException
getBlob in interface ResultSetSQLExceptionpublic Clob getClob(int column) throws SQLException
getClob in interface ResultSetSQLExceptionpublic Ref getRef(int column) throws SQLException
getRef in interface ResultSetSQLExceptionpublic Array getArray(int column) throws SQLException
getArray in interface ResultSetSQLExceptionpublic Object getObject(int column) throws SQLException
getObject in interface ResultSetSQLExceptionpublic Object getObject(int column, Map map) throws SQLException
getObject in interface ResultSetSQLExceptionpublic final boolean getBoolean(String columnName) throws SQLException
getBoolean in interface ResultSetSQLExceptionpublic final byte getByte(String columnName) throws SQLException
getByte in interface ResultSetSQLExceptionpublic final short getShort(String columnName) throws SQLException
getShort in interface ResultSetSQLExceptionpublic final int getInt(String columnName) throws SQLException
getInt in interface ResultSetSQLExceptionpublic final long getLong(String columnName) throws SQLException
getLong in interface ResultSetSQLExceptionpublic final float getFloat(String columnName) throws SQLException
getFloat in interface ResultSetSQLExceptionpublic final double getDouble(String columnName) throws SQLException
getDouble in interface ResultSetSQLExceptionpublic final BigDecimal getBigDecimal(String columnName, int scale) throws SQLException
getBigDecimal in interface ResultSetSQLExceptionpublic final BigDecimal getBigDecimal(String columnName) throws SQLException
getBigDecimal in interface ResultSetSQLExceptionpublic final Date getDate(String columnName) throws SQLException
getDate in interface ResultSetSQLExceptionpublic final Date getDate(String columnName, Calendar cal) throws SQLException
getDate in interface ResultSetSQLExceptionpublic final Time getTime(String columnName) throws SQLException
getTime in interface ResultSetSQLExceptionpublic final Time getTime(String columnName, Calendar cal) throws SQLException
getTime in interface ResultSetSQLExceptionpublic final Timestamp getTimestamp(String columnName) throws SQLException
getTimestamp in interface ResultSetSQLExceptionpublic final Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException
getTimestamp in interface ResultSetSQLExceptionpublic final String getString(String columnName) throws SQLException
getString in interface ResultSetSQLExceptionpublic final byte[] getBytes(String columnName) throws SQLException
getBytes in interface ResultSetSQLExceptionpublic final InputStream getBinaryStream(String columnName) throws SQLException
getBinaryStream in interface ResultSetSQLExceptionpublic final InputStream getAsciiStream(String columnName) throws SQLException
getAsciiStream in interface ResultSetSQLExceptionpublic final InputStream getUnicodeStream(String columnName) throws SQLException
getUnicodeStream in interface ResultSetSQLExceptionpublic final Reader getCharacterStream(String columnName) throws SQLException
getCharacterStream in interface ResultSetSQLExceptionpublic final Blob getBlob(String columnName) throws SQLException
getBlob in interface ResultSetSQLExceptionpublic final Clob getClob(String columnName) throws SQLException
getClob in interface ResultSetSQLExceptionpublic final Array getArray(String columnName) throws SQLException
getArray in interface ResultSetSQLExceptionpublic final Ref getRef(String columnName) throws SQLException
getRef in interface ResultSetSQLExceptionpublic final Object getObject(String columnName) throws SQLException
getObject in interface ResultSetSQLExceptionpublic final Object getObject(String columnName, Map map) throws SQLException
getObject in interface ResultSetSQLExceptionpublic final SQLWarning getWarnings() throws SQLException
SQLWarning reported on this
ResultSet object, or null if there
are no warnings. Subsequent warnings are chained on the
returned object.getWarnings in interface ResultSetSQLWarning in the chain, or
null if no warnings are reportedSQLException - if a database error occurs or the
result set is closedpublic final void clearWarnings()
throws SQLException
ResultSet and make
subsequent calls to getWarnings() return
null until a new warning is reported.clearWarnings in interface ResultSetSQLException - if a database error occurs or the
result set is closedpublic final void clearWarningsX()
public String getCursorName() throws SQLException
getCursorName in interface ResultSetSQLExceptionpublic ResultSetMetaData getMetaData() throws SQLException
getMetaData in interface ResultSetSQLExceptionpublic final int findColumn(String columnName) throws SQLException
findColumn in interface ResultSetSQLExceptionpublic boolean isBeforeFirst()
throws SQLException
isBeforeFirst in interface ResultSetSQLExceptionpublic boolean isAfterLast()
throws SQLException
isAfterLast in interface ResultSetSQLExceptionpublic boolean isFirst()
throws SQLException
isFirst in interface ResultSetSQLExceptionpublic boolean isLast()
throws SQLException
isLast in interface ResultSetSQLExceptionpublic void beforeFirst()
throws SQLException
beforeFirst in interface ResultSetSQLExceptionpublic void afterLast()
throws SQLException
afterLast in interface ResultSetSQLExceptionpublic boolean first()
throws SQLException
first in interface ResultSetSQLExceptionpublic boolean last()
throws SQLException
last in interface ResultSetSQLExceptionpublic int getRow()
throws SQLException
getRow in interface ResultSetSQLExceptionpublic boolean absolute(int row)
throws SQLException
absolute in interface ResultSetSQLExceptionpublic boolean absoluteX(int row)
throws SqlException
SqlExceptionpublic boolean relative(int rows)
throws SQLException
relative in interface ResultSetSQLExceptionpublic boolean previous()
throws SQLException
previous in interface ResultSetSQLExceptionpublic void setFetchDirection(int direction)
throws SQLException
setFetchDirection in interface ResultSetSQLExceptionpublic int getFetchDirection()
throws SQLException
getFetchDirection in interface ResultSetSQLExceptionpublic void setFetchSize(int rows)
throws SQLException
setFetchSize in interface ResultSetSQLExceptionpublic int getFetchSize()
throws SQLException
getFetchSize in interface ResultSetSQLExceptionpublic int getType()
throws SQLException
getType in interface ResultSetSQLExceptionpublic int getConcurrency()
throws SQLException
getConcurrency in interface ResultSetSQLExceptionpublic boolean rowUpdated()
throws SQLException
rowUpdated in interface ResultSetSQLExceptionpublic boolean rowInserted()
throws SQLException
rowInserted in interface ResultSetSQLExceptionpublic boolean rowDeleted()
throws SQLException
rowDeleted in interface ResultSetSQLExceptionpublic void updateNull(int column)
throws SQLException
updateNull in interface ResultSetSQLExceptionpublic void updateBoolean(int column,
boolean x)
throws SQLException
updateBoolean in interface ResultSetSQLExceptionpublic void updateByte(int column,
byte x)
throws SQLException
updateByte in interface ResultSetSQLExceptionpublic void updateShort(int column,
short x)
throws SQLException
updateShort in interface ResultSetSQLExceptionpublic void updateInt(int column,
int x)
throws SQLException
updateInt in interface ResultSetSQLExceptionpublic void updateLong(int column,
long x)
throws SQLException
updateLong in interface ResultSetSQLExceptionpublic void updateFloat(int column,
float x)
throws SQLException
updateFloat in interface ResultSetSQLExceptionpublic void updateDouble(int column,
double x)
throws SQLException
updateDouble in interface ResultSetSQLExceptionpublic void updateBigDecimal(int column,
BigDecimal x)
throws SQLException
updateBigDecimal in interface ResultSetSQLExceptionpublic void updateDate(int column,
Date x)
throws SQLException
updateDate in interface ResultSetSQLExceptionpublic void updateTime(int column,
Time x)
throws SQLException
updateTime in interface ResultSetSQLExceptionpublic void updateTimestamp(int column,
Timestamp x)
throws SQLException
updateTimestamp in interface ResultSetSQLExceptionpublic void updateString(int column,
String x)
throws SQLException
updateString in interface ResultSetSQLExceptionpublic void updateBytes(int column,
byte[] x)
throws SQLException
updateBytes in interface ResultSetSQLExceptionpublic void updateBinaryStream(int column,
InputStream x,
int length)
throws SQLException
updateBinaryStream in interface ResultSetSQLExceptionpublic void updateAsciiStream(int column,
InputStream x,
int length)
throws SQLException
updateAsciiStream in interface ResultSetSQLExceptionpublic void updateCharacterStream(int column,
Reader x,
int length)
throws SQLException
updateCharacterStream in interface ResultSetSQLExceptionpublic void updateObject(int column,
Object x,
int scale)
throws SQLException
updateObject in interface ResultSetSQLExceptionpublic void updateObject(int column,
Object x)
throws SQLException
updateObject in interface ResultSetSQLExceptionpublic void updateNCharacterStream(int columnIndex,
Reader x)
throws SQLException
updateNCharacterStream in interface ResultSetSQLExceptionpublic void updateNClob(int columnIndex,
Reader reader)
throws SQLException
updateNClob in interface ResultSetSQLExceptionpublic void updateNull(String columnName) throws SQLException
updateNull in interface ResultSetSQLExceptionpublic void updateBoolean(String columnName, boolean x) throws SQLException
updateBoolean in interface ResultSetSQLExceptionpublic void updateByte(String columnName, byte x) throws SQLException
updateByte in interface ResultSetSQLExceptionpublic void updateShort(String columnName, short x) throws SQLException
updateShort in interface ResultSetSQLExceptionpublic void updateInt(String columnName, int x) throws SQLException
updateInt in interface ResultSetSQLExceptionpublic void updateLong(String columnName, long x) throws SQLException
updateLong in interface ResultSetSQLExceptionpublic void updateFloat(String columnName, float x) throws SQLException
updateFloat in interface ResultSetSQLExceptionpublic void updateDouble(String columnName, double x) throws SQLException
updateDouble in interface ResultSetSQLExceptionpublic void updateBigDecimal(String columnName, BigDecimal x) throws SQLException
updateBigDecimal in interface ResultSetSQLExceptionpublic void updateDate(String columnName, Date x) throws SQLException
updateDate in interface ResultSetSQLExceptionpublic void updateTime(String columnName, Time x) throws SQLException
updateTime in interface ResultSetSQLExceptionpublic void updateTimestamp(String columnName, Timestamp x) throws SQLException
updateTimestamp in interface ResultSetSQLExceptionpublic void updateString(String columnName, String x) throws SQLException
updateString in interface ResultSetSQLExceptionpublic void updateBytes(String columnName, byte[] x) throws SQLException
updateBytes in interface ResultSetSQLExceptionpublic void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException
updateBinaryStream in interface ResultSetSQLExceptionpublic void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException
updateAsciiStream in interface ResultSetSQLExceptionpublic void updateCharacterStream(String columnName, Reader x, int length) throws SQLException
updateCharacterStream in interface ResultSetSQLExceptionpublic void updateObject(String columnName, Object x, int scale) throws SQLException
updateObject in interface ResultSetSQLExceptionpublic void updateObject(String columnName, Object x) throws SQLException
updateObject in interface ResultSetSQLExceptionpublic void updateNCharacterStream(String columnName, Reader x) throws SQLException
updateNCharacterStream in interface ResultSetSQLExceptionpublic void updateNClob(String columnName, Reader reader) throws SQLException
updateNClob in interface ResultSetSQLExceptionpublic void insertRow()
throws SQLException
insertRow in interface ResultSetSQLExceptionpublic void updateRow()
throws SQLException
updateRow in interface ResultSetSQLExceptionpublic void deleteRow()
throws SQLException
deleteRow in interface ResultSetSQLExceptionpublic void refreshRow()
throws SQLException
refreshRow in interface ResultSetSQLExceptionpublic void cancelRowUpdates()
throws SQLException
cancelRowUpdates in interface ResultSetSQLExceptionpublic void moveToInsertRow()
throws SQLException
moveToInsertRow in interface ResultSetSQLExceptionpublic void moveToCurrentRow()
throws SQLException
moveToCurrentRow in interface ResultSetSQLExceptionpublic Statement getStatement() throws SQLException
Statement object that produced this
object, or null if the ResultSet was
not produced by a Statement object.getStatement in interface ResultSetStatement that produced this object or
nullSQLException - if a database error occurs or the
result set is closedpublic URL getURL(int columnIndex) throws SQLException
getURL in interface ResultSetSQLExceptionpublic URL getURL(String columnName) throws SQLException
getURL in interface ResultSetSQLExceptionpublic void updateRef(int columnIndex,
Ref x)
throws SQLException
updateRef in interface ResultSetSQLExceptionpublic void updateRef(String columnName, Ref x) throws SQLException
updateRef in interface ResultSetSQLExceptionpublic void updateBlob(int columnIndex,
Blob x)
throws SQLException
java.sql.Blob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateBlob in interface ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBlob(String columnName, Blob x) throws SQLException
java.sql.Blob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateBlob in interface ResultSetcolumnName - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is the
name of the columnx - the new column valueSQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBlob(int columnIndex,
InputStream x,
long length)
throws SQLException
updateRow or
insertRow methods are called to update the database.updateBlob in interface ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - An object that contains the data to set the parameter
value to.length - the number of bytes in the parameter data.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBlob(String columnName, InputStream x, long length) throws SQLException
updateRow or
insertRow methods are called to update the database.updateBlob in interface ResultSetcolumnName - the label for the column specified with the
SQL AS clause. If the SQL AS clause was not specified, then the
label is the name of the columnx - An object that contains the data to set the parameter
value to.length - the number of bytes in the parameter data.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateArray(int columnIndex,
Array x)
throws SQLException
updateArray in interface ResultSetSQLExceptionpublic void updateArray(String columnName, Array x) throws SQLException
updateArray in interface ResultSetSQLExceptionpublic boolean repositionScrollableResultSetBeforeJDBC1PositionedUpdateDelete()
throws SqlException
SqlExceptionpublic void flowPositioningFetch(int scrollOrientation,
int rowToFetch)
throws DisconnectException
DisconnectExceptionprotected void positionToCurrentRowAndUpdate()
throws SqlException
SqlExceptionprotected void insert()
throws SqlException
SqlExceptionprotected void update()
throws SqlException
SqlExceptionprotected void positionToCurrentRowAndDelete()
throws SqlException
SqlExceptionprotected void delete()
throws SqlException
SqlExceptionpublic void setRowsetAfterLastEvent()
throws SqlException
SqlExceptionpublic void setRowsetBeforeFirstEvent()
throws SqlException
SqlExceptionpublic void setRowsetNoRowsEvent()
public void setValidCursorPosition(boolean isValidCursorPosition)
protected void moveToAfterLast()
throws DisconnectException
DisconnectExceptionprotected void moveToBeforeFirst()
throws DisconnectException
DisconnectExceptionpublic void flowFetch()
throws DisconnectException,
SqlException
DisconnectExceptionSqlExceptionpublic void writeInsertRow(boolean chainedWritesFollowingSetLob)
throws SQLException
SQLExceptionpublic void writeUpdateRow(boolean chainedWritesFollowingSetLob)
throws SQLException
SQLExceptionpublic void writeDeleteRow()
throws SQLException
SQLExceptionpublic void readInsertRow()
throws DisconnectException,
SqlException
DisconnectExceptionSqlExceptionpublic void readUpdateRow()
throws DisconnectException,
SqlException
DisconnectExceptionSqlExceptionpublic void readDeleteRow()
throws DisconnectException,
SqlException
DisconnectExceptionSqlExceptionpublic void listenToUnitOfWork()
listenToUnitOfWork in interface UnitOfWorkListenerpublic void completeLocalCommit(Iterator listenerIterator)
completeLocalCommit in interface UnitOfWorkListenerpublic void completeLocalRollback(Iterator listenerIterator)
completeLocalRollback in interface UnitOfWorkListenerpublic void markClosedOnServer()
public void earlyCloseComplete(Sqlca sqlca)
earlyCloseComplete in interface ResultSetCallbackInterfacepublic int completeSqlca(Sqlca sqlca)
completeSqlca in interface ResultSetCallbackInterfacepublic void setRowCountEvent(long rowCount)
throws DisconnectException
DisconnectExceptionpublic void accumulateWarning(SqlWarning e)
accumulateWarning in interface ResultSetCallbackInterfaceprotected boolean rowCountIsUnknown()
protected boolean rowCountIsKnown()
protected final void checkForClosedResultSet()
throws SqlException
SqlExceptionprotected void updateColumnInfoFromCache()
protected final void checkAndThrowReceivedQueryTerminatingException()
throws SqlException
SqlExceptionpublic void parseScrollableRowset()
throws SqlException
SqlExceptionpublic byte getRSReturnability()
public void setRSReturnability(byte rsReturnability)
protected void getRowCount()
throws SqlException
SqlExceptionpublic abstract void writeFetch_(Section section) throws SqlException
SqlExceptionpublic abstract void readFetch_()
throws SqlException
SqlExceptionpublic abstract void writeScrollableFetch_(Section section, int fetchSize, int orientation, long rowToFetch, boolean resetQueryBlocks) throws SqlException
SqlExceptionpublic abstract void readScrollableFetch_()
throws SqlException
SqlExceptionpublic abstract void writePositioningFetch_(Section section, int orientation, long rowToFetch) throws SqlException
SqlExceptionpublic abstract void readPositioningFetch_()
throws SqlException
SqlExceptionpublic abstract void writeCursorClose_(Section section) throws SqlException
SqlExceptionpublic abstract void readCursorClose_()
throws SqlException
SqlExceptionprotected abstract void parseRowset_()
throws SqlException
SqlExceptionpublic abstract void setFetchSize_(int rows)
protected abstract void preClose_()
throws SqlException
closeX() before the
result set is actually being closed. Subclasses may override
this method if work needs to be done before closing.SqlExceptionpublic ConnectionCallbackInterface getConnectionCallbackInterface()
getConnectionCallbackInterface in interface ResultSetCallbackInterfacepublic StatementCallbackInterface getStatementCallbackInterface()
getStatementCallbackInterface in interface ResultSetCallbackInterfacepublic void expandRowsetSqlca()
public final int getHoldability()
throws SQLException
ResultSet
object.getHoldability in interface ResultSetResultSet.HOLD_CURSORS_OVER_COMMIT
or ResultSet.CLOSE_CURSORS_AT_COMMITSQLException - if a database error occurspublic final boolean isClosed()
throws SQLException
ResultSet object has been
closed, either automatically or because close()
has been called.isClosed in interface ResultSettrue if the ResultSet is
closed, false otherwiseSQLException - if a database error occurspublic void updateAsciiStream(int columnIndex,
InputStream x)
throws SQLException
updateRow or insertRow
methods are called to update the database.updateAsciiStream in interface ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if the columnIndex is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateAsciiStream(int columnIndex,
InputStream x,
long length)
throws SQLException
updateAsciiStream in interface ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamSQLException - if a database-access error occurspublic void updateBinaryStream(int columnIndex,
InputStream x)
throws SQLException
updateRow or insertRow
methods are called to update the database.updateBinaryStream in interface ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if the columnIndex is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateBinaryStream(int columnIndex,
InputStream x,
long length)
throws SQLException
updateBinaryStream in interface ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamSQLException - if a database-access error occurspublic void updateBlob(int columnIndex,
InputStream x)
throws SQLException
updateRow or insertRow
methods are called to update the database.updateBlob in interface ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valueSQLException - if the columnIndex is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateCharacterStream(int columnIndex,
Reader reader)
throws SQLException
updateRow or insertRow
methods are called to update the database.updateCharacterStream in interface ResultSetcolumnIndex - the first column is 1, the second is 2, ...reader - the new column valueSQLException - if the columnLabel is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateCharacterStream(int columnIndex,
Reader x,
long length)
throws SQLException
updateCharacterStream in interface ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamSQLException - if a database-access error occurspublic void updateClob(int columnIndex,
Reader reader)
throws SQLException
Reader
object.
The data will be read from the stream as needed until end-of-stream is
reached. The JDBC driver will do any necessary conversion from UNICODE
to the database char format.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow or insertRow
methods are called to update the database.updateClob in interface ResultSetcolumnIndex - the first column is 1, the second is 2, ...reader - an object that contains the data to set the parameter
value to.SQLException - if the columnIndex is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateAsciiStream(String columnName, InputStream x) throws SQLException
updateRow or insertRow
methods are called to update the database.updateAsciiStream in interface ResultSetcolumnName - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnx - the new column valueSQLException - if the columnLabel is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateAsciiStream(String columnName, InputStream x, long length) throws SQLException
updateAsciiStream in interface ResultSetcolumnName - the name of the columnx - the new column valuelength - of the streamSQLException - if a database-access error occurspublic void updateBinaryStream(String columnLabel, InputStream x) throws SQLException
updateRow or insertRow
methods are called to update the database.updateBinaryStream in interface ResultSetcolumnLabel - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnx - the new column valueSQLException - if the columnLabel is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateBinaryStream(String columnName, InputStream x, long length) throws SQLException
updateBinaryStream in interface ResultSetcolumnName - the name of the columnx - the new column valuelength - of the streamSQLException - if a database-access error occurspublic void updateBlob(String columnLabel, InputStream x) throws SQLException
updateRow or insertRow
methods are called to update the database.updateBlob in interface ResultSetcolumnLabel - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnx - the new column valueSQLException - if the columnLabel is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateCharacterStream(String columnLabel, Reader reader) throws SQLException
updateRow or insertRow
methods are called to update the database.updateCharacterStream in interface ResultSetcolumnLabel - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnreader - the new column valueSQLException - if the columnLabel is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateCharacterStream(String columnName, Reader reader, long length) throws SQLException
updateCharacterStream in interface ResultSetcolumnName - the name of the columnreader - the new column valuelength - length of the streamSQLException - if a database-access error occurspublic void updateClob(String columnLabel, Reader reader) throws SQLException
Reader
object.
The data will be read from the stream as needed until end-of-stream is
reached. The JDBC driver will do any necessary conversion from UNICODE
to the database char format.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow or insertRow
methods are called to update the database.updateClob in interface ResultSetcolumnLabel - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnreader - an object that contains the data to set the parameter
value to.SQLException - if the columnIndex is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateClob(int columnIndex,
Reader x,
long length)
throws SQLException
Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader object. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
updateClob in interface ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - An object that contains the data to set the parameter value to.length - the number of characters in the parameter data.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException - if the JDBC driver does not
support this methodpublic void updateClob(String columnName, Reader x, long length) throws SQLException
Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader object. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
updateClob in interface ResultSetcolumnName - the label for the column specified with the
SQL AS clause. If the SQL AS clause was not specified,
then the label is the name of the columnx - An object that contains the data to set the parameter value to.length - the number of characters in the parameter data.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException - if the JDBC driver does not
support this methodpublic void updateClob(int columnIndex,
Clob x)
throws SQLException
java.sql.Clob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateClob in interface ResultSetcolumnIndex - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then
the label is the name of the columnx - the new column valueSQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateClob(String columnLabel, Clob x) throws SQLException
java.sql.Clob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateClob in interface ResultSetcolumnLabel - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then
the label is the name of the columnx - the new column valueSQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic final void markLOBAsAccessed(int index)
When a LOB is marked as accessed, the release mechanism will not be invoked by the result set. It is expected that the code accessing the LOB releases the locator when it is done with the LOB.
index - 1-based column indexCopyright © 2010-2015 Pivotal Software, Inc. All rights reserved.