public abstract class ResultSet extends java.lang.Object implements java.sql.ResultSet, ResultSetCallbackInterface
| 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) |
private void |
adjustAbsoluteRowset(long rowNumber) |
private void |
adjustFirstRowset() |
private void |
adjustLastRowset(long row) |
private void |
adjustNextRowset() |
private void |
adjustPreviousRowset(int orientation,
long rowNumber,
boolean isAfterLastRow) |
private void |
adjustRefreshRowset() |
private void |
adjustRelativeRowset(long rowNumber) |
void |
afterLast() |
private void |
afterLastX() |
void |
beforeFirst() |
private void |
beforeFirstX() |
private java.lang.String |
buildDeleteString() |
private java.lang.String |
buildInsertString() |
private java.lang.String |
buildUpdateString() |
void |
cancelRowUpdates() |
protected void |
checkAndThrowReceivedQueryTerminatingException() |
protected void |
checkForClosedResultSet(java.lang.String operation) |
private void |
checkForUpdatableResultSet(java.lang.String operation) |
(package private) void |
checkForValidColumnIndex(int column) |
private void |
checkForValidCursorPosition() |
private void |
checkGetterPreconditions(int column,
java.lang.String operation) |
private void |
checkLOBMultiCall(int columnIndex)
Checks if a stream or a LOB object has already been created for the
specified LOB column.
|
private void |
checkPositionedOnPlainRow() |
private int |
checkRowsetSqlca() |
private int |
checkRowsetSqlca(int row) |
private void |
checkThatResultSetIsNotDynamic() |
private void |
checkThatResultSetTypeIsScrollable() |
private void |
checkUpdatePreconditions(int column,
java.lang.String operation) |
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() |
private void |
closeOpenStreams()
Closes the current stream, if there is one.
|
private void |
closeStatementOnCompletion()
Close Statement if it is set to closeOnCompletion
|
void |
closeX() |
void |
completeLocalCommit(java.util.Iterator listenerIterator) |
void |
completeLocalRollback(java.util.Iterator listenerIterator) |
int |
completeSqlca(Sqlca sqlca) |
private java.sql.Date |
convertFromDefaultCalendar(java.sql.Date date,
java.util.Calendar cal)
Convert a date originally set using the default calendar to a value
representing the same date in a different calendar.
|
private java.sql.Time |
convertFromDefaultCalendar(java.sql.Time time,
java.util.Calendar cal)
Convert a time originally set using the default calendar to a value
representing the same time in a different calendar.
|
private java.sql.Timestamp |
convertFromDefaultCalendar(java.sql.Timestamp ts,
java.util.Calendar cal)
Convert a timestamp originally set using the default calendar to a value
representing the same timestamp in a different calendar.
|
private static java.util.Calendar |
createCalendar(java.util.Date date)
Create a calendar with default locale and time zone.
|
private CloseFilterInputStream |
createCloseFilterInputStream(java.io.InputStream is) |
(package private) void |
createLOBColumnTracker()
Initializes the LOB state tracker.
|
protected void |
delete() |
void |
deleteRow() |
private void |
deleteRowX() |
void |
earlyCloseComplete(Sqlca sqlca) |
void |
expandRowsetSqlca() |
int |
findColumn(java.lang.String columnName) |
protected int |
findColumnX(java.lang.String columnName,
java.lang.String operation) |
boolean |
first() |
private boolean |
firstX() |
(package private) void |
flowCloseAndAutoCommitIfNotAutoCommitted() |
void |
flowFetch() |
private void |
flowGetRowset(int orientation,
long rowNumber) |
void |
flowPositioningFetch(int scrollOrientation,
int rowToFetch) |
private boolean |
getAbsoluteRowset(long row) |
java.sql.Array |
getArray(int column) |
java.sql.Array |
getArray(java.lang.String columnName) |
java.io.InputStream |
getAsciiStream(int column) |
java.io.InputStream |
getAsciiStream(java.lang.String columnName) |
java.math.BigDecimal |
getBigDecimal(int column) |
java.math.BigDecimal |
getBigDecimal(int column,
int scale)
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName) |
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName,
int scale)
Deprecated.
|
java.io.InputStream |
getBinaryStream(int column) |
java.io.InputStream |
getBinaryStream(java.lang.String columnName) |
java.sql.Blob |
getBlob(int column) |
java.sql.Blob |
getBlob(java.lang.String columnName) |
boolean |
getBoolean(int column) |
boolean |
getBoolean(java.lang.String columnName) |
byte |
getByte(int column) |
byte |
getByte(java.lang.String columnName) |
byte[] |
getBytes(int column) |
byte[] |
getBytes(java.lang.String columnName) |
java.io.Reader |
getCharacterStream(int column) |
java.io.Reader |
getCharacterStream(java.lang.String columnName) |
java.sql.Clob |
getClob(int column) |
java.sql.Clob |
getClob(java.lang.String columnName) |
int |
getConcurrency() |
ConnectionCallbackInterface |
getConnectionCallbackInterface() |
java.lang.String |
getCursorName() |
java.sql.Date |
getDate(int column) |
java.sql.Date |
getDate(int column,
java.util.Calendar cal) |
java.sql.Date |
getDate(java.lang.String columnName) |
java.sql.Date |
getDate(java.lang.String columnName,
java.util.Calendar cal) |
double |
getDouble(int column) |
double |
getDouble(java.lang.String columnName) |
int |
getFetchDirection() |
int |
getFetchSize() |
private boolean |
getFirstRowset() |
float |
getFloat(int column) |
float |
getFloat(java.lang.String columnName) |
int |
getHoldability()
Retrieves the holdability for this
ResultSet
object. |
int |
getInt(int column) |
int |
getInt(java.lang.String columnName) |
private boolean |
getLastRowset(long row) |
long |
getLong(int column) |
long |
getLong(java.lang.String columnName) |
java.sql.ResultSetMetaData |
getMetaData() |
(package private) ColumnMetaData |
getMetaDataX() |
private boolean |
getNextRowset() |
java.lang.Object |
getObject(int column) |
java.lang.Object |
getObject(int column,
java.util.Map map) |
java.lang.Object |
getObject(java.lang.String columnName) |
java.lang.Object |
getObject(java.lang.String columnName,
java.util.Map map) |
(package private) java.lang.Object |
getObjectX(int column) |
private void |
getPreparedStatementForDelete() |
private void |
getPreparedStatementForInsert() |
private void |
getPreparedStatementForUpdate() |
private boolean |
getPreviousRowset() |
java.sql.Ref |
getRef(int column) |
java.sql.Ref |
getRef(java.lang.String columnName) |
private boolean |
getRefreshRowset() |
private boolean |
getRelativeRowset(long rows) |
int |
getRow() |
protected void |
getRowCount() |
private long |
getRowUncast() |
private int |
getRowX() |
byte |
getRSReturnability() |
private java.lang.String |
getServerCursorName() |
short |
getShort(int column) |
short |
getShort(java.lang.String columnName) |
java.sql.Statement |
getStatement()
Retrieves the
Statement object that produced this
object, or null if the ResultSet was
not produced by a Statement object. |
StatementCallbackInterface |
getStatementCallbackInterface() |
java.lang.String |
getString(int column) |
java.lang.String |
getString(java.lang.String columnName) |
private java.lang.String |
getTableName() |
java.sql.Time |
getTime(int column) |
java.sql.Time |
getTime(int column,
java.util.Calendar cal) |
java.sql.Time |
getTime(java.lang.String columnName) |
java.sql.Time |
getTime(java.lang.String columnName,
java.util.Calendar cal) |
java.sql.Timestamp |
getTimestamp(int column) |
java.sql.Timestamp |
getTimestamp(int column,
java.util.Calendar calendar) |
java.sql.Timestamp |
getTimestamp(java.lang.String columnName) |
java.sql.Timestamp |
getTimestamp(java.lang.String columnName,
java.util.Calendar cal) |
int |
getType() |
java.io.InputStream |
getUnicodeStream(int column)
Deprecated.
|
java.io.InputStream |
getUnicodeStream(java.lang.String columnName)
Deprecated.
|
java.net.URL |
getURL(int columnIndex) |
java.net.URL |
getURL(java.lang.String columnName) |
java.sql.SQLWarning |
getWarnings()
Returns the first
SQLWarning reported on this
ResultSet object, or null if there
are no warnings. |
protected void |
insert() |
void |
insertRow() |
private void |
insertRowX() |
boolean |
isAfterLast() |
private boolean |
isAfterLastX() |
boolean |
isBeforeFirst() |
private boolean |
isBeforeFirstX() |
boolean |
isClosed()
Checks whether this
ResultSet object has been
closed, either automatically or because close()
has been called. |
boolean |
isFirst() |
private boolean |
isFirstX() |
boolean |
isLast() |
private boolean |
isLastX() |
private boolean |
isNull(int column) |
private boolean |
isServerCursorPositionAfterLast() |
private boolean |
isServersCursorPositionBeforeFirst() |
private java.sql.SQLException |
jdbc3MethodNotSupported() |
boolean |
last() |
private boolean |
lastX() |
void |
listenToUnitOfWork() |
(package private) void |
markAutoCommitted() |
(package private) void |
markClosed()
Mark this ResultSet as closed.
|
(package private) void |
markClosed(boolean removeListener)
Mark this ResultSet as closed.
|
void |
markClosedOnServer()
Mark this ResultSet as closed on the server.
|
void |
markLOBAsPublished(int index)
Marks the LOB at the specified column as published.
|
private void |
markPositionedUpdateDeletePreparedStatementsClosed() |
protected void |
moveToAfterLast() |
protected void |
moveToBeforeFirst() |
void |
moveToCurrentRow() |
private void |
moveToCurrentRowX()
Moves off the insert row if positioned there, and checks the current row
for releasable LOB locators if positioned on a valid data row.
|
void |
moveToInsertRow() |
boolean |
next() |
(package private) boolean |
nextX() |
void |
nullDataForGC() |
private void |
nullOutReferenceInStatement() |
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() |
private boolean |
previousX() |
private void |
readAutoCommitIfNotAutoCommitted() |
(package private) void |
readClose() |
private void |
readCloseAndAutoCommit(boolean readAutoCommit) |
abstract void |
readCursorClose_() |
void |
readDeleteRow() |
abstract void |
readFetch_() |
void |
readInsertRow() |
abstract void |
readPositioningFetch_() |
abstract void |
readScrollableFetch_() |
void |
readUpdateRow() |
void |
refreshRow() |
private void |
refreshRowX() |
boolean |
relative(int rows) |
private boolean |
relativeX(int rows) |
boolean |
repositionScrollableResultSetBeforeJDBC1PositionedUpdateDelete() |
private void |
resetRowsetFlags() |
private void |
resetRowsetSqlca() |
private void |
resetUpdatedColumns() |
private void |
resetUpdatedColumnsForInsert() |
private boolean |
resultSetContainsNoRows() |
protected boolean |
rowCountIsKnown() |
protected boolean |
rowCountIsUnknown() |
boolean |
rowDeleted() |
boolean |
rowInserted() |
private boolean |
rowIsInCurrentRowset(long rowNumber) |
private boolean |
rowIsInCurrentRowset(long rowNumber,
int orientation) |
boolean |
rowUpdated() |
private void |
setAbsolutePositionBasedOnAllRowsReceived() |
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) |
private void |
setWasNull(int column) |
private void |
unuseStreamsAndLOBs()
Clears the flags for used columns, typically invoked when changing the
result set position.
|
protected void |
update() |
void |
updateArray(int columnIndex,
java.sql.Array x) |
void |
updateArray(java.lang.String columnName,
java.sql.Array x) |
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x)
Updates the designated column with an ascii stream value.
|
void |
updateAsciiStream(int column,
java.io.InputStream x,
int length) |
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length)
Update a column with an ascii stream value.
|
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x)
Updates the designated column with an ascii stream value.
|
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length) |
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
long length)
Update a column with an ascii stream value.
|
void |
updateBigDecimal(int column,
java.math.BigDecimal x) |
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x) |
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x)
Updates the designated column with a binary stream value.
|
void |
updateBinaryStream(int column,
java.io.InputStream x,
int length) |
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length)
Update a column with a binary stream value.
|
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x)
Updates the designated column with a binary stream value.
|
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length) |
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
long length)
Update a column with a binary stream value.
|
void |
updateBlob(int columnIndex,
java.sql.Blob x)
Updates the designated column with a
java.sql.Blob value. |
void |
updateBlob(int columnIndex,
java.io.InputStream x)
Updates the designated column using the given input stream.
|
void |
updateBlob(int columnIndex,
java.io.InputStream x,
long length)
Updates the designated column using the given input stream, which
will have the specified number of bytes.
|
void |
updateBlob(java.lang.String columnName,
java.sql.Blob x)
Updates the designated column with a
java.sql.Blob value. |
void |
updateBlob(java.lang.String columnLabel,
java.io.InputStream x)
Updates the designated column using the given input stream.
|
void |
updateBlob(java.lang.String columnName,
java.io.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(java.lang.String columnName,
boolean x) |
void |
updateByte(int column,
byte x) |
void |
updateByte(java.lang.String columnName,
byte x) |
void |
updateBytes(int column,
byte[] x) |
void |
updateBytes(java.lang.String columnName,
byte[] x) |
void |
updateCharacterStream(int columnIndex,
java.io.Reader reader)
Updates the designated column with a character stream value.
|
void |
updateCharacterStream(int column,
java.io.Reader x,
int length) |
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
long length)
Update a column with a character stream value.
|
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
Updates the designated column with a character stream value.
|
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader x,
int length) |
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader reader,
long length)
Update a column with a character stream value.
|
void |
updateClob(int columnIndex,
java.sql.Clob x)
Updates the designated column with a
java.sql.Clob value. |
void |
updateClob(int columnIndex,
java.io.Reader reader)
Updates the designated column using the given
Reader
object. |
void |
updateClob(int columnIndex,
java.io.Reader x,
long length)
Updates the designated column using the given
Reader
object, which is the given number of characters long. |
void |
updateClob(java.lang.String columnLabel,
java.sql.Clob x)
Updates the designated column with a
java.sql.Clob value. |
void |
updateClob(java.lang.String columnLabel,
java.io.Reader reader)
Updates the designated column using the given
Reader
object. |
void |
updateClob(java.lang.String columnName,
java.io.Reader x,
long length)
Updates the designated column using the given
Reader
object, which is the given number of characters long. |
private void |
updateColumn(int column,
java.lang.Object value) |
protected void |
updateColumnInfoFromCache() |
void |
updateDate(int column,
java.sql.Date x) |
void |
updateDate(java.lang.String columnName,
java.sql.Date x) |
void |
updateDouble(int column,
double x) |
void |
updateDouble(java.lang.String columnName,
double x) |
void |
updateFloat(int column,
float x) |
void |
updateFloat(java.lang.String columnName,
float x) |
void |
updateInt(int column,
int x) |
void |
updateInt(java.lang.String columnName,
int x) |
void |
updateLong(int column,
long x) |
void |
updateLong(java.lang.String columnName,
long x) |
void |
updateNCharacterStream(int columnIndex,
java.io.Reader x) |
void |
updateNCharacterStream(java.lang.String columnName,
java.io.Reader x) |
void |
updateNClob(int columnIndex,
java.io.Reader reader) |
void |
updateNClob(java.lang.String columnName,
java.io.Reader reader) |
void |
updateNull(int column) |
void |
updateNull(java.lang.String columnName) |
void |
updateObject(int column,
java.lang.Object x) |
void |
updateObject(int column,
java.lang.Object x,
int scale) |
void |
updateObject(java.lang.String columnName,
java.lang.Object x) |
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int scale) |
void |
updateRef(int columnIndex,
java.sql.Ref x) |
void |
updateRef(java.lang.String columnName,
java.sql.Ref x) |
void |
updateRow() |
private boolean |
updateRowX() |
void |
updateShort(int column,
short x) |
void |
updateShort(java.lang.String columnName,
short x) |
void |
updateString(int column,
java.lang.String x) |
void |
updateString(java.lang.String columnName,
java.lang.String x) |
void |
updateTime(int column,
java.sql.Time x) |
void |
updateTime(java.lang.String columnName,
java.sql.Time x) |
void |
updateTimestamp(int column,
java.sql.Timestamp x) |
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x) |
(package private) void |
useStreamOrLOB(int columnIndex)
Mark a column as already having a stream or LOB accessed from it.
|
private boolean |
wasNonNullSensitiveUpdate(int column) |
boolean |
wasNull() |
private boolean |
wasNullSensitiveUpdate(int column) |
(package private) void |
writeClose() |
private boolean |
writeCloseAndAutoCommit() |
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, updateObject, updateObject, updateObject, updateObject, updateRowId, updateRowId, updateSQLXML, updateSQLXMLpublic Statement statement_
Statement outerStatement_
public ColumnMetaData resultSetMetaData_
private SqlWarning warnings_
public Cursor cursor_
private LOBStateTracker lobState
protected Agent agent_
public Section generatedSection_
private CloseFilterInputStream currentStream
private java.io.Reader currentReader
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__
private static final int WAS_NULL
private static final int WAS_NOT_NULL
private static final int WAS_NULL_UNSET
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
private int wasNull_
protected byte rsReturnability_
boolean openOnClient_
public boolean openOnServer_
public Sqlca queryTerminatingSqlca_
boolean autoCommitted_
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_
private boolean isOnInsertRow_
protected boolean isOnCurrentRow_
public int rowsReceivedInCurrentRowset_
public int rowsYetToBeReceivedForRowset_
private java.lang.Object[] updatedColumns_
private boolean[] columnUpdated_
private PreparedStatement preparedStatementForUpdate_
private PreparedStatement preparedStatementForDelete_
private PreparedStatement preparedStatementForInsert_
public int nestingLevel_
public boolean cursorUnpositionedOnServer_
private long maxRows_
private boolean[] columnUsedFlags_
boolean listenToUnitOfWork_
public final boolean next()
throws java.sql.SQLException
next in interface java.sql.ResultSetjava.sql.SQLExceptionboolean nextX()
throws SqlException
SqlExceptionpublic void close()
throws java.sql.SQLException
close in interface java.lang.AutoCloseableclose in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final void closeX()
throws SqlException
SqlExceptionprivate void closeStatementOnCompletion()
public void nullDataForGC()
void flowCloseAndAutoCommitIfNotAutoCommitted()
throws SqlException
SqlExceptionprivate boolean writeCloseAndAutoCommit()
throws SqlException
SqlExceptionprivate void readCloseAndAutoCommit(boolean readAutoCommit)
throws SqlException
SqlExceptionvoid writeClose()
throws SqlException
SqlExceptionvoid readClose()
throws SqlException
SqlExceptionprivate void readAutoCommitIfNotAutoCommitted()
throws SqlException
SqlExceptionpublic boolean wasNull()
throws java.sql.SQLException
wasNull in interface java.sql.ResultSetjava.sql.SQLExceptionpublic boolean getBoolean(int column)
throws java.sql.SQLException
getBoolean in interface java.sql.ResultSetjava.sql.SQLExceptionpublic byte getByte(int column)
throws java.sql.SQLException
getByte in interface java.sql.ResultSetjava.sql.SQLExceptionpublic short getShort(int column)
throws java.sql.SQLException
getShort in interface java.sql.ResultSetjava.sql.SQLExceptionpublic int getInt(int column)
throws java.sql.SQLException
getInt in interface java.sql.ResultSetjava.sql.SQLExceptionpublic long getLong(int column)
throws java.sql.SQLException
getLong in interface java.sql.ResultSetjava.sql.SQLExceptionpublic float getFloat(int column)
throws java.sql.SQLException
getFloat in interface java.sql.ResultSetjava.sql.SQLExceptionpublic double getDouble(int column)
throws java.sql.SQLException
getDouble in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.math.BigDecimal getBigDecimal(int column,
int scale)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.math.BigDecimal getBigDecimal(int column)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.Date getDate(int column,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.Date getDate(int column)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.Time getTime(int column,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.Time getTime(int column)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(int column,
java.util.Calendar calendar)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(int column)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetjava.sql.SQLExceptionprivate static java.util.Calendar createCalendar(java.util.Date date)
date - the initial time of the calendarprivate java.sql.Date convertFromDefaultCalendar(java.sql.Date date,
java.util.Calendar cal)
date - the date to convertcal - the calendar to convert it tocalprivate java.sql.Time convertFromDefaultCalendar(java.sql.Time time,
java.util.Calendar cal)
time - the time to convertcal - the calendar to convert it tocalprivate java.sql.Timestamp convertFromDefaultCalendar(java.sql.Timestamp ts,
java.util.Calendar cal)
ts - the timestamp to convertcal - the calendar to convert it tocalpublic java.lang.String getString(int column)
throws java.sql.SQLException
getString in interface java.sql.ResultSetjava.sql.SQLExceptionpublic byte[] getBytes(int column)
throws java.sql.SQLException
getBytes in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.io.InputStream getBinaryStream(int column)
throws java.sql.SQLException
getBinaryStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.io.InputStream getAsciiStream(int column)
throws java.sql.SQLException
getAsciiStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.io.InputStream getUnicodeStream(int column)
throws java.sql.SQLException
getUnicodeStream in interface java.sql.ResultSetcolumn - the column to retrieve as a Unicode streamjava.sql.SQLException - throws feature not implementedpublic java.io.Reader getCharacterStream(int column)
throws java.sql.SQLException
getCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.Blob getBlob(int column)
throws java.sql.SQLException
getBlob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.Clob getClob(int column)
throws java.sql.SQLException
getClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.Ref getRef(int column)
throws java.sql.SQLException
getRef in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.Array getArray(int column)
throws java.sql.SQLException
getArray in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.lang.Object getObject(int column)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetjava.sql.SQLExceptionjava.lang.Object getObjectX(int column)
throws SqlException
SqlExceptionpublic java.lang.Object getObject(int column,
java.util.Map map)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetjava.sql.SQLExceptionprivate boolean wasNonNullSensitiveUpdate(int column)
private boolean wasNullSensitiveUpdate(int column)
private void setWasNull(int column)
private boolean isNull(int column)
public final boolean getBoolean(java.lang.String columnName)
throws java.sql.SQLException
getBoolean in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final byte getByte(java.lang.String columnName)
throws java.sql.SQLException
getByte in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final short getShort(java.lang.String columnName)
throws java.sql.SQLException
getShort in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final int getInt(java.lang.String columnName)
throws java.sql.SQLException
getInt in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final long getLong(java.lang.String columnName)
throws java.sql.SQLException
getLong in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final float getFloat(java.lang.String columnName)
throws java.sql.SQLException
getFloat in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final double getDouble(java.lang.String columnName)
throws java.sql.SQLException
getDouble in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.math.BigDecimal getBigDecimal(java.lang.String columnName,
int scale)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.math.BigDecimal getBigDecimal(java.lang.String columnName)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.sql.Date getDate(java.lang.String columnName)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.sql.Date getDate(java.lang.String columnName,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.sql.Time getTime(java.lang.String columnName)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.sql.Time getTime(java.lang.String columnName,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.sql.Timestamp getTimestamp(java.lang.String columnName)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.sql.Timestamp getTimestamp(java.lang.String columnName,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.lang.String getString(java.lang.String columnName)
throws java.sql.SQLException
getString in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final byte[] getBytes(java.lang.String columnName)
throws java.sql.SQLException
getBytes in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.io.InputStream getBinaryStream(java.lang.String columnName)
throws java.sql.SQLException
getBinaryStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.io.InputStream getAsciiStream(java.lang.String columnName)
throws java.sql.SQLException
getAsciiStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.io.InputStream getUnicodeStream(java.lang.String columnName)
throws java.sql.SQLException
getUnicodeStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.io.Reader getCharacterStream(java.lang.String columnName)
throws java.sql.SQLException
getCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.sql.Blob getBlob(java.lang.String columnName)
throws java.sql.SQLException
getBlob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.sql.Clob getClob(java.lang.String columnName)
throws java.sql.SQLException
getClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.sql.Array getArray(java.lang.String columnName)
throws java.sql.SQLException
getArray in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.sql.Ref getRef(java.lang.String columnName)
throws java.sql.SQLException
getRef in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.lang.Object getObject(java.lang.String columnName)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.lang.Object getObject(java.lang.String columnName,
java.util.Map map)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetjava.sql.SQLExceptionpublic final java.sql.SQLWarning getWarnings()
throws java.sql.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 java.sql.ResultSetSQLWarning in the chain, or
null if no warnings are reportedjava.sql.SQLException - if a database error occurs or the
result set is closedpublic final void clearWarnings()
throws java.sql.SQLException
ResultSet and make
subsequent calls to getWarnings() return
null until a new warning is reported.clearWarnings in interface java.sql.ResultSetjava.sql.SQLException - if a database error occurs or the
result set is closedpublic final void clearWarningsX()
public java.lang.String getCursorName()
throws java.sql.SQLException
getCursorName in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.sql.ResultSetMetaData getMetaData()
throws java.sql.SQLException
getMetaData in interface java.sql.ResultSetjava.sql.SQLExceptionColumnMetaData getMetaDataX() throws SqlException
SqlExceptionpublic final int findColumn(java.lang.String columnName)
throws java.sql.SQLException
findColumn in interface java.sql.ResultSetjava.sql.SQLExceptionprotected final int findColumnX(java.lang.String columnName,
java.lang.String operation)
throws SqlException
SqlExceptionpublic boolean isBeforeFirst()
throws java.sql.SQLException
isBeforeFirst in interface java.sql.ResultSetjava.sql.SQLExceptionprivate boolean isBeforeFirstX()
throws SqlException
SqlExceptionpublic boolean isAfterLast()
throws java.sql.SQLException
isAfterLast in interface java.sql.ResultSetjava.sql.SQLExceptionprivate boolean isAfterLastX()
throws SqlException
SqlExceptionpublic boolean isFirst()
throws java.sql.SQLException
isFirst in interface java.sql.ResultSetjava.sql.SQLExceptionprivate boolean isFirstX()
public boolean isLast()
throws java.sql.SQLException
isLast in interface java.sql.ResultSetjava.sql.SQLExceptionprivate boolean isLastX()
throws SqlException
SqlExceptionpublic void beforeFirst()
throws java.sql.SQLException
beforeFirst in interface java.sql.ResultSetjava.sql.SQLExceptionprivate void beforeFirstX()
throws SqlException
SqlExceptionpublic void afterLast()
throws java.sql.SQLException
afterLast in interface java.sql.ResultSetjava.sql.SQLExceptionprivate void afterLastX()
throws SqlException
SqlExceptionpublic boolean first()
throws java.sql.SQLException
first in interface java.sql.ResultSetjava.sql.SQLExceptionprivate boolean firstX()
throws SqlException
SqlExceptionpublic boolean last()
throws java.sql.SQLException
last in interface java.sql.ResultSetjava.sql.SQLExceptionprivate boolean lastX()
throws SqlException
SqlExceptionpublic int getRow()
throws java.sql.SQLException
getRow in interface java.sql.ResultSetjava.sql.SQLExceptionprivate int getRowX()
throws SqlException
SqlExceptionpublic boolean absolute(int row)
throws java.sql.SQLException
absolute in interface java.sql.ResultSetjava.sql.SQLExceptionpublic boolean absoluteX(int row)
throws SqlException
SqlExceptionpublic boolean relative(int rows)
throws java.sql.SQLException
relative in interface java.sql.ResultSetjava.sql.SQLExceptionprivate boolean relativeX(int rows)
throws SqlException
SqlExceptionpublic boolean previous()
throws java.sql.SQLException
previous in interface java.sql.ResultSetjava.sql.SQLExceptionprivate boolean previousX()
throws SqlException
SqlExceptionpublic void setFetchDirection(int direction)
throws java.sql.SQLException
setFetchDirection in interface java.sql.ResultSetjava.sql.SQLExceptionpublic int getFetchDirection()
throws java.sql.SQLException
getFetchDirection in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void setFetchSize(int rows)
throws java.sql.SQLException
setFetchSize in interface java.sql.ResultSetjava.sql.SQLExceptionpublic int getFetchSize()
throws java.sql.SQLException
getFetchSize in interface java.sql.ResultSetjava.sql.SQLExceptionpublic int getType()
throws java.sql.SQLException
getType in interface java.sql.ResultSetjava.sql.SQLExceptionpublic int getConcurrency()
throws java.sql.SQLException
getConcurrency in interface java.sql.ResultSetjava.sql.SQLExceptionpublic boolean rowUpdated()
throws java.sql.SQLException
rowUpdated in interface java.sql.ResultSetjava.sql.SQLExceptionpublic boolean rowInserted()
throws java.sql.SQLException
rowInserted in interface java.sql.ResultSetjava.sql.SQLExceptionpublic boolean rowDeleted()
throws java.sql.SQLException
rowDeleted in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNull(int column)
throws java.sql.SQLException
updateNull in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBoolean(int column,
boolean x)
throws java.sql.SQLException
updateBoolean in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateByte(int column,
byte x)
throws java.sql.SQLException
updateByte in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateShort(int column,
short x)
throws java.sql.SQLException
updateShort in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateInt(int column,
int x)
throws java.sql.SQLException
updateInt in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateLong(int column,
long x)
throws java.sql.SQLException
updateLong in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateFloat(int column,
float x)
throws java.sql.SQLException
updateFloat in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateDouble(int column,
double x)
throws java.sql.SQLException
updateDouble in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBigDecimal(int column,
java.math.BigDecimal x)
throws java.sql.SQLException
updateBigDecimal in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateDate(int column,
java.sql.Date x)
throws java.sql.SQLException
updateDate in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateTime(int column,
java.sql.Time x)
throws java.sql.SQLException
updateTime in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateTimestamp(int column,
java.sql.Timestamp x)
throws java.sql.SQLException
updateTimestamp in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateString(int column,
java.lang.String x)
throws java.sql.SQLException
updateString in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBytes(int column,
byte[] x)
throws java.sql.SQLException
updateBytes in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBinaryStream(int column,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateAsciiStream(int column,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateCharacterStream(int column,
java.io.Reader x,
int length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateObject(int column,
java.lang.Object x,
int scale)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateObject(int column,
java.lang.Object x)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNCharacterStream(int columnIndex,
java.io.Reader x)
throws java.sql.SQLException
updateNCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNClob(int columnIndex,
java.io.Reader reader)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNull(java.lang.String columnName)
throws java.sql.SQLException
updateNull in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBoolean(java.lang.String columnName,
boolean x)
throws java.sql.SQLException
updateBoolean in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateByte(java.lang.String columnName,
byte x)
throws java.sql.SQLException
updateByte in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateShort(java.lang.String columnName,
short x)
throws java.sql.SQLException
updateShort in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateInt(java.lang.String columnName,
int x)
throws java.sql.SQLException
updateInt in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateLong(java.lang.String columnName,
long x)
throws java.sql.SQLException
updateLong in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateFloat(java.lang.String columnName,
float x)
throws java.sql.SQLException
updateFloat in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateDouble(java.lang.String columnName,
double x)
throws java.sql.SQLException
updateDouble in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
throws java.sql.SQLException
updateBigDecimal in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateDate(java.lang.String columnName,
java.sql.Date x)
throws java.sql.SQLException
updateDate in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateTime(java.lang.String columnName,
java.sql.Time x)
throws java.sql.SQLException
updateTime in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
throws java.sql.SQLException
updateTimestamp in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateString(java.lang.String columnName,
java.lang.String x)
throws java.sql.SQLException
updateString in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBytes(java.lang.String columnName,
byte[] x)
throws java.sql.SQLException
updateBytes in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateCharacterStream(java.lang.String columnName,
java.io.Reader x,
int length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateObject(java.lang.String columnName,
java.lang.Object x)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNCharacterStream(java.lang.String columnName,
java.io.Reader x)
throws java.sql.SQLException
updateNCharacterStream in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateNClob(java.lang.String columnName,
java.io.Reader reader)
throws java.sql.SQLException
updateNClob in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void insertRow()
throws java.sql.SQLException
insertRow in interface java.sql.ResultSetjava.sql.SQLExceptionprivate void insertRowX()
throws SqlException
SqlExceptionpublic void updateRow()
throws java.sql.SQLException
updateRow in interface java.sql.ResultSetjava.sql.SQLExceptionprivate boolean updateRowX()
throws SqlException
SqlExceptionpublic void deleteRow()
throws java.sql.SQLException
deleteRow in interface java.sql.ResultSetjava.sql.SQLExceptionprivate void deleteRowX()
throws SqlException
SqlExceptionpublic void refreshRow()
throws java.sql.SQLException
refreshRow in interface java.sql.ResultSetjava.sql.SQLExceptionprivate void refreshRowX()
throws SqlException
SqlExceptionpublic void cancelRowUpdates()
throws java.sql.SQLException
cancelRowUpdates in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void moveToInsertRow()
throws java.sql.SQLException
moveToInsertRow in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void moveToCurrentRow()
throws java.sql.SQLException
moveToCurrentRow in interface java.sql.ResultSetjava.sql.SQLExceptionprivate void moveToCurrentRowX()
throws SqlException
SqlException - if releasing a LOB locator failspublic java.sql.Statement getStatement()
throws java.sql.SQLException
Statement object that produced this
object, or null if the ResultSet was
not produced by a Statement object.getStatement in interface java.sql.ResultSetStatement that produced this object or
nulljava.sql.SQLException - if a database error occurs or the
result set is closedpublic java.net.URL getURL(int columnIndex)
throws java.sql.SQLException
getURL in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.net.URL getURL(java.lang.String columnName)
throws java.sql.SQLException
getURL in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateRef(int columnIndex,
java.sql.Ref x)
throws java.sql.SQLException
updateRef in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateRef(java.lang.String columnName,
java.sql.Ref x)
throws java.sql.SQLException
updateRef in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateBlob(int columnIndex,
java.sql.Blob x)
throws java.sql.SQLException
java.sql.Blob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateBlob in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if 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(java.lang.String columnName,
java.sql.Blob x)
throws java.sql.SQLException
java.sql.Blob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateBlob in interface java.sql.ResultSetcolumnName - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is the
name of the columnx - the new column valuejava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBlob(int columnIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
updateRow or
insertRow methods are called to update the database.updateBlob in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - An object that contains the data to set the parameter
value to.length - the number of bytes in the parameter data.java.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateBlob(java.lang.String columnName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
updateRow or
insertRow methods are called to update the database.updateBlob in interface java.sql.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.java.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateArray(int columnIndex,
java.sql.Array x)
throws java.sql.SQLException
updateArray in interface java.sql.ResultSetjava.sql.SQLExceptionpublic void updateArray(java.lang.String columnName,
java.sql.Array x)
throws java.sql.SQLException
updateArray in interface java.sql.ResultSetjava.sql.SQLExceptionpublic 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()
private boolean isServersCursorPositionBeforeFirst()
throws SqlException
SqlExceptionprivate boolean isServerCursorPositionAfterLast()
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 java.sql.SQLException
java.sql.SQLExceptionpublic void writeUpdateRow(boolean chainedWritesFollowingSetLob)
throws java.sql.SQLException
java.sql.SQLExceptionpublic void writeDeleteRow()
throws java.sql.SQLException
java.sql.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(java.util.Iterator listenerIterator)
completeLocalCommit in interface UnitOfWorkListenerpublic void completeLocalRollback(java.util.Iterator listenerIterator)
completeLocalRollback in interface UnitOfWorkListenerprivate void nullOutReferenceInStatement()
void markClosed()
org.apache.derby.client.am.Connection.void markClosed(boolean removeListener)
removeListener - if true the ResultSet will be removed
from the commit and rollback listeners list in
org.apache.derby.client.am.Connection.public void markClosedOnServer()
void markAutoCommitted()
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()
private void updateColumn(int column,
java.lang.Object value)
private java.lang.String buildInsertString()
throws SqlException
SqlExceptionprivate java.lang.String buildUpdateString()
throws SqlException
SqlExceptionprivate java.lang.String buildDeleteString()
throws SqlException
SqlExceptionprivate java.lang.String getTableName()
throws SqlException
SqlExceptionprivate java.lang.String getServerCursorName()
throws SqlException
SqlExceptionprivate void getPreparedStatementForInsert()
throws SqlException
SqlExceptionprivate void getPreparedStatementForUpdate()
throws SqlException
SqlExceptionprivate void getPreparedStatementForDelete()
throws SqlException
SqlExceptionprivate final void resetUpdatedColumnsForInsert()
private final void resetUpdatedColumns()
private final long getRowUncast()
private final void checkGetterPreconditions(int column,
java.lang.String operation)
throws SqlException
SqlExceptionprivate final void checkUpdatePreconditions(int column,
java.lang.String operation)
throws SqlException
SqlExceptionfinal void checkForValidColumnIndex(int column)
throws SqlException
SqlExceptionprotected final void checkForClosedResultSet(java.lang.String operation)
throws SqlException
SqlExceptionprivate final void checkForUpdatableResultSet(java.lang.String operation)
throws SqlException
SqlExceptionprivate final void checkForValidCursorPosition()
throws SqlException
SqlExceptionprivate final void checkPositionedOnPlainRow()
throws SqlException
SqlExceptionprivate final void checkThatResultSetTypeIsScrollable()
throws SqlException
SqlExceptionprivate final void checkThatResultSetIsNotDynamic()
throws SqlException
SqlExceptionprivate boolean resultSetContainsNoRows()
throws SqlException
SqlExceptionprivate boolean rowIsInCurrentRowset(long rowNumber,
int orientation)
throws SqlException
SqlExceptionprivate boolean rowIsInCurrentRowset(long rowNumber)
private void markPositionedUpdateDeletePreparedStatementsClosed()
protected 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
SqlExceptionprivate void flowGetRowset(int orientation,
long rowNumber)
throws SqlException
SqlExceptionprivate boolean getNextRowset()
throws SqlException
SqlExceptionprivate void adjustNextRowset()
private boolean getPreviousRowset()
throws SqlException
SqlExceptionprivate void adjustPreviousRowset(int orientation,
long rowNumber,
boolean isAfterLastRow)
private boolean getAbsoluteRowset(long row)
throws SqlException
SqlExceptionprivate void adjustAbsoluteRowset(long rowNumber)
private boolean getRelativeRowset(long rows)
throws SqlException
SqlExceptionprivate void adjustRelativeRowset(long rowNumber)
private boolean getFirstRowset()
throws SqlException
SqlExceptionprivate void adjustFirstRowset()
private boolean getLastRowset(long row)
throws SqlException
SqlExceptionprivate void adjustLastRowset(long row)
private boolean getRefreshRowset()
throws SqlException
SqlExceptionprivate void adjustRefreshRowset()
private void setAbsolutePositionBasedOnAllRowsReceived()
public 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()
private final int checkRowsetSqlca()
throws SqlException
SqlExceptionprivate final int checkRowsetSqlca(int row)
throws SqlException
SqlExceptionprivate void resetRowsetFlags()
private void resetRowsetSqlca()
private CloseFilterInputStream createCloseFilterInputStream(java.io.InputStream is) throws SqlException
SqlExceptionprivate void closeOpenStreams()
throws SqlException
Note that streams are implicitly closed when the next value is fetched.
SqlException - if closing the stream failsvoid useStreamOrLOB(int columnIndex)
throws SqlException
columnIndex - 1-based column indexjava.sql.SQLException - if the column has already been accessedSqlExceptionprivate void checkLOBMultiCall(int columnIndex)
throws SqlException
Accessing a LOB column more than once is not forbidden by the JDBC specification, but the Java API states that for maximum portability, result set columns within each row should be read in left-to-right order, and each column should be read only once. The restriction was implemented in Derby due to complexities with the positioning of store streams when the user was given multiple handles to the stream.
columnIndex - 1-based index of the LOB columnSqlException - if the column has already been accessedprivate void unuseStreamsAndLOBs()
private java.sql.SQLException jdbc3MethodNotSupported()
public final int getHoldability()
throws java.sql.SQLException
ResultSet
object.getHoldability in interface java.sql.ResultSetResultSet.HOLD_CURSORS_OVER_COMMIT
or ResultSet.CLOSE_CURSORS_AT_COMMITjava.sql.SQLException - if a database error occurspublic final boolean isClosed()
throws java.sql.SQLException
ResultSet object has been
closed, either automatically or because close()
has been called.isClosed in interface java.sql.ResultSettrue if the ResultSet is
closed, false otherwisejava.sql.SQLException - if a database error occurspublic void updateAsciiStream(int columnIndex,
java.io.InputStream x)
throws java.sql.SQLException
updateRow or insertRow
methods are called to update the database.updateAsciiStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if the columnIndex is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateAsciiStream(int columnIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if a database-access error occurspublic void updateBinaryStream(int columnIndex,
java.io.InputStream x)
throws java.sql.SQLException
updateRow or insertRow
methods are called to update the database.updateBinaryStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if the columnIndex is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateBinaryStream(int columnIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if a database-access error occurspublic void updateBlob(int columnIndex,
java.io.InputStream x)
throws java.sql.SQLException
updateRow or insertRow
methods are called to update the database.updateBlob in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if 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,
java.io.Reader reader)
throws java.sql.SQLException
updateRow or insertRow
methods are called to update the database.updateCharacterStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...reader - the new column valuejava.sql.SQLException - if the columnLabel is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateCharacterStream(int columnIndex,
java.io.Reader x,
long length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if a database-access error occurspublic void updateClob(int columnIndex,
java.io.Reader reader)
throws java.sql.SQLException
Reader
object.
The data will be read from the stream as needed until end-of-stream is
reached. The JDBC driver will do any necessary conversion from UNICODE
to the database char format.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow or insertRow
methods are called to update the database.updateClob in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...reader - an object that contains the data to set the parameter
value to.java.sql.SQLException - if the columnIndex is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateAsciiStream(java.lang.String columnName,
java.io.InputStream x)
throws java.sql.SQLException
updateRow or insertRow
methods are called to update the database.updateAsciiStream in interface java.sql.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 valuejava.sql.SQLException - if the columnLabel is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuelength - of the streamjava.sql.SQLException - if a database-access error occurspublic void updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x)
throws java.sql.SQLException
updateRow or insertRow
methods are called to update the database.updateBinaryStream in interface java.sql.ResultSetcolumnLabel - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnx - the new column valuejava.sql.SQLException - if the columnLabel is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuelength - of the streamjava.sql.SQLException - if a database-access error occurspublic void updateBlob(java.lang.String columnLabel,
java.io.InputStream x)
throws java.sql.SQLException
updateRow or insertRow
methods are called to update the database.updateBlob in interface java.sql.ResultSetcolumnLabel - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnx - the new column valuejava.sql.SQLException - if the columnLabel is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateCharacterStream(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
updateRow or insertRow
methods are called to update the database.updateCharacterStream in interface java.sql.ResultSetcolumnLabel - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnreader - the new column valuejava.sql.SQLException - if the columnLabel is not valid; if a database
access error occurs; the result set concurrency is
CONCUR_READ_ONLY or this method is called on a closed
result setpublic void updateCharacterStream(java.lang.String columnName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetcolumnName - the name of the columnreader - the new column valuelength - length of the streamjava.sql.SQLException - if a database-access error occurspublic void updateClob(java.lang.String columnLabel,
java.io.Reader reader)
throws java.sql.SQLException
Reader
object.
The data will be read from the stream as needed until end-of-stream is
reached. The JDBC driver will do any necessary conversion from UNICODE
to the database char format.
The updater methods are used to update column values in the current row
or the insert row. The updater methods do not update the underlying
database; instead the updateRow or insertRow
methods are called to update the database.updateClob in interface java.sql.ResultSetcolumnLabel - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then the label is
the name of the columnreader - an object that contains the data to set the parameter
value to.java.sql.SQLException - if the 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,
java.io.Reader x,
long length)
throws java.sql.SQLException
Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader object. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
updateClob in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - An object that contains the data to set the parameter value to.length - the number of characters in the parameter data.java.sql.SQLException - if the columnIndex is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException - if the JDBC driver does not
support this methodpublic void updateClob(java.lang.String columnName,
java.io.Reader x,
long length)
throws java.sql.SQLException
Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader object. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.
updateClob in interface java.sql.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.java.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setSQLFeatureNotSupportedException - if the JDBC driver does not
support this methodpublic void updateClob(int columnIndex,
java.sql.Clob x)
throws java.sql.SQLException
java.sql.Clob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateClob in interface java.sql.ResultSetcolumnIndex - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then
the label is the name of the columnx - the new column valuejava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic void updateClob(java.lang.String columnLabel,
java.sql.Clob x)
throws java.sql.SQLException
java.sql.Clob value.
The updater methods are used to update column values in the
current row or the insert row. The updater methods do not
update the underlying database; instead the updateRow or
insertRow methods are called to update the database.updateClob in interface java.sql.ResultSetcolumnLabel - the label for the column specified with the SQL AS
clause. If the SQL AS clause was not specified, then
the label is the name of the columnx - the new column valuejava.sql.SQLException - if the columnLabel is not valid;
if a database access error occurs;
the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result setpublic final void markLOBAsPublished(int index)
When a LOB is marked as published, 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, or that the commit/rollback handles the release.
index - 1-based column indexfinal void createLOBColumnTracker()
The state tracker is used to free LOB locators on the server. If the server doesn't support locators, or there are no LOBs in the result set, a no-op tracker will be used.
Apache Derby V10.10 Internals - Copyright © 2004,2014 The Apache Software Foundation. All Rights Reserved.