Class ResultSetImpl
- java.lang.Object
-
- org.teiid.jdbc.WrapperImpl
-
- org.teiid.jdbc.ResultSetImpl
-
- All Implemented Interfaces:
AutoCloseable
,ResultSet
,Wrapper
,BatchResults.BatchFetcher
,TeiidResultSet
public class ResultSetImpl extends WrapperImpl implements TeiidResultSet, BatchResults.BatchFetcher
-
-
Field Summary
Fields Modifier and Type Field Description static String
DISABLE_FETCH_SIZE
-
Fields inherited from interface java.sql.ResultSet
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
-
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description boolean
absolute(int row)
protected void
accumulateWarnings(ResultsMessage resultsMsg)
void
afterLast()
Moves the cursor to the end of the result set, just after the last row.int
available()
Returns an estimate of the minimum number of rows that can be read (after the current) without blocking or the end of the ResultSet is reached.void
beforeFirst()
Moves the cursor to the front of the result set, just before the first row.void
cancelRowUpdates()
protected void
checkClosed()
protected void
checkNotForwardOnly()
void
clearWarnings()
void
close()
void
deleteRow()
int
findColumn(String columnName)
protected int
findColumnIndex(String columnName)
boolean
first()
Moves the cursor to the first row in this ResultSet object.protected int
getAbsoluteRowNumber()
Array
getArray(int columnIndex)
Array
getArray(String columnLabel)
InputStream
getAsciiStream(int columnIndex)
InputStream
getAsciiStream(String columnLabel)
BigDecimal
getBigDecimal(int columnIndex)
BigDecimal
getBigDecimal(int columnIndex, int scale)
BigDecimal
getBigDecimal(String columnName)
BigDecimal
getBigDecimal(String columnName, int scale)
InputStream
getBinaryStream(int columnIndex)
InputStream
getBinaryStream(String columnName)
Blob
getBlob(int columnIndex)
Blob
getBlob(String columnName)
boolean
getBoolean(int columnIndex)
boolean
getBoolean(String columnName)
byte
getByte(int columnIndex)
byte
getByte(String columnName)
byte[]
getBytes(int columnIndex)
byte[]
getBytes(String columnName)
Reader
getCharacterStream(int columnIndex)
Reader
getCharacterStream(String columnName)
Clob
getClob(int columnIndex)
Clob
getClob(String columnLabel)
int
getConcurrency()
Get the concurrency type for this ResultSet object.List<?>
getCurrentRecord()
Get all values in current record in column orderString
getCursorName()
Retrieves the RequestID for the query that created this ResultSet.Date
getDate(int columnIndex)
Date
getDate(int columnIndex, Calendar cal)
Date
getDate(String columnName)
Date
getDate(String columnName, Calendar cal)
protected Calendar
getDefaultCalendar()
double
getDouble(int columnIndex)
double
getDouble(String columnName)
int
getFetchDirection()
Gets the direction suggested to the driver as the direction in which to fetch rows.int
getFetchSize()
protected int
getFinalRowNumber()
float
getFloat(int columnIndex)
float
getFloat(String columnName)
int
getHoldability()
int
getInt(int columnIndex)
int
getInt(String columnName)
long
getLong(int columnIndex)
long
getLong(String columnName)
ResultSetMetaData
getMetaData()
This method returns the meta data of the result set, such as the number, types and properties of this resultSets columns.Reader
getNCharacterStream(int columnIndex)
Reader
getNCharacterStream(String columnLabel)
NClob
getNClob(int columnIndex)
NClob
getNClob(String columnLabel)
String
getNString(int columnIndex)
String
getNString(String columnLabel)
Object
getObject(int column)
Get a java object based on the column index for the current row.<T> T
getObject(int columnIndex, Class<T> type)
Object
getObject(int columnIndex, Map<String,Class<?>> map)
Object
getObject(String columnName)
<T> T
getObject(String columnLabel, Class<T> type)
Object
getObject(String columnLabel, Map<String,Class<?>> map)
Object
getObjectDirect(int column)
Get the value of the current row at the column index specified.protected int
getOffset()
Object
getRawCurrentValue()
Ref
getRef(int columnIndex)
Ref
getRef(String columnLabel)
int
getRow()
RowId
getRowId(int columnIndex)
RowId
getRowId(String columnLabel)
short
getShort(int columnIndex)
short
getShort(String columnName)
SQLXML
getSQLXML(int columnIndex)
SQLXML
getSQLXML(String columnLabel)
StatementImpl
getStatement()
Retrieves the Statement object that produced this ResultSet object.String
getString(int columnIndex)
String
getString(String columnName)
Time
getTime(int columnIndex)
Time
getTime(int columnIndex, Calendar cal)
Time
getTime(String columnName)
Time
getTime(String columnName, Calendar cal)
Timestamp
getTimestamp(int columnIndex)
Timestamp
getTimestamp(int columnIndex, Calendar cal)
Timestamp
getTimestamp(String columnName)
Timestamp
getTimestamp(String columnName, Calendar cal)
int
getType()
InputStream
getUnicodeStream(int columnIndex)
InputStream
getUnicodeStream(String columnLabel)
protected PlanNode
getUpdatedPlanDescription()
URL
getURL(int columnIndex)
URL
getURL(String columnLabel)
SQLWarning
getWarnings()
protected boolean
hasNext()
void
insertRow()
boolean
isAfterLast()
Determines whether the cursor is after the last row in this ResultSet object.boolean
isBeforeFirst()
Determines whether the cursor is before the first row in this ResultSet object.boolean
isClosed()
boolean
isFirst()
boolean
isLast()
boolean
last()
Moves the cursor to the last row in the in this ResultSet object.void
moveToCurrentRow()
Moves the cursor to the remembered cursor position, usually the current row.void
moveToInsertRow()
boolean
next()
boolean
previous()
void
refreshRow()
boolean
relative(int rows)
org.teiid.jdbc.BatchResults.Batch
requestBatch(int beginRow)
boolean
rowDeleted()
boolean
rowInserted()
boolean
rowUpdated()
void
setFetchDirection(int direction)
void
setFetchSize(int rows)
void
setMaxFieldSize(int maxFieldSize)
ResultsFuture<Boolean>
submitNext()
Assumes forward only cursoringvoid
updateArray(int columnIndex, Array x)
void
updateArray(String columnLabel, Array x)
void
updateAsciiStream(int columnIndex, InputStream x)
void
updateAsciiStream(int columnIndex, InputStream x, int length)
void
updateAsciiStream(int columnIndex, InputStream x, long length)
void
updateAsciiStream(String columnLabel, InputStream x)
void
updateAsciiStream(String columnLabel, InputStream x, int length)
void
updateAsciiStream(String columnLabel, InputStream x, long length)
void
updateBigDecimal(int columnIndex, BigDecimal x)
void
updateBigDecimal(String columnLabel, BigDecimal x)
void
updateBinaryStream(int columnIndex, InputStream x)
void
updateBinaryStream(int columnIndex, InputStream x, int length)
void
updateBinaryStream(int columnIndex, InputStream x, long length)
void
updateBinaryStream(String columnLabel, InputStream x)
void
updateBinaryStream(String columnLabel, InputStream x, int length)
void
updateBinaryStream(String columnLabel, InputStream x, long length)
void
updateBlob(int columnIndex, InputStream inputStream)
void
updateBlob(int columnIndex, InputStream inputStream, long length)
void
updateBlob(int columnIndex, Blob x)
void
updateBlob(String columnLabel, InputStream inputStream)
void
updateBlob(String columnLabel, InputStream inputStream, long length)
void
updateBlob(String columnLabel, Blob x)
void
updateBoolean(int columnIndex, boolean x)
void
updateBoolean(String columnLabel, boolean x)
void
updateByte(int columnIndex, byte x)
void
updateByte(String columnLabel, byte x)
void
updateBytes(int columnIndex, byte[] x)
void
updateBytes(String columnLabel, byte[] x)
void
updateCharacterStream(int columnIndex, Reader x)
void
updateCharacterStream(int columnIndex, Reader x, int length)
void
updateCharacterStream(int columnIndex, Reader x, long length)
void
updateCharacterStream(String columnLabel, Reader reader)
void
updateCharacterStream(String columnLabel, Reader reader, int length)
void
updateCharacterStream(String columnLabel, Reader reader, long length)
void
updateClob(int columnIndex, Reader reader)
void
updateClob(int columnIndex, Reader reader, long length)
void
updateClob(int columnIndex, Clob x)
void
updateClob(String columnLabel, Reader reader)
void
updateClob(String columnLabel, Reader reader, long length)
void
updateClob(String columnLabel, Clob x)
void
updateDate(int columnIndex, Date x)
void
updateDate(String columnLabel, Date x)
void
updateDouble(int columnIndex, double x)
void
updateDouble(String columnLabel, double x)
void
updateFloat(int columnIndex, float x)
void
updateFloat(String columnLabel, float x)
void
updateInt(int columnIndex, int x)
void
updateInt(String columnLabel, int x)
void
updateLong(int columnIndex, long x)
void
updateLong(String columnLabel, long x)
void
updateNCharacterStream(int columnIndex, Reader x)
void
updateNCharacterStream(int columnIndex, Reader x, long length)
void
updateNCharacterStream(String columnLabel, Reader reader)
void
updateNCharacterStream(String columnLabel, Reader reader, long length)
void
updateNClob(int columnIndex, Reader reader)
void
updateNClob(int columnIndex, Reader reader, long length)
void
updateNClob(int columnIndex, NClob clob)
void
updateNClob(String columnLabel, Reader reader)
void
updateNClob(String columnLabel, Reader reader, long length)
void
updateNClob(String columnLabel, NClob clob)
void
updateNString(int columnIndex, String string)
void
updateNString(String columnLabel, String string)
void
updateNull(int columnIndex)
void
updateNull(String columnLabel)
void
updateObject(int columnIndex, Object x)
void
updateObject(int columnIndex, Object x, int scaleOrLength)
void
updateObject(String columnLabel, Object x)
void
updateObject(String columnLabel, Object x, int scaleOrLength)
void
updateRef(int columnIndex, Ref x)
void
updateRef(String columnLabel, Ref x)
void
updateRow()
void
updateRowId(int columnIndex, RowId x)
void
updateRowId(String columnLabel, RowId x)
void
updateShort(int columnIndex, short x)
void
updateShort(String columnLabel, short x)
void
updateSQLXML(int columnIndex, SQLXML xmlObject)
void
updateSQLXML(String columnLabel, SQLXML xmlObject)
void
updateString(int columnIndex, String x)
void
updateString(String columnLabel, String x)
void
updateTime(int columnIndex, Time x)
void
updateTime(String columnLabel, Time x)
void
updateTimestamp(int columnIndex, Timestamp x)
void
updateTimestamp(String columnLabel, Timestamp x)
boolean
wasNull()
This will return a boolean value if the last column that was read had a value equal to null.-
Methods inherited from class org.teiid.jdbc.WrapperImpl
isWrapperFor, unwrap
-
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface java.sql.ResultSet
updateObject, updateObject, updateObject, updateObject
-
Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap
-
-
-
-
Field Detail
-
DISABLE_FETCH_SIZE
public static final String DISABLE_FETCH_SIZE
- See Also:
- Constant Field Values
-
-
Method Detail
-
setMaxFieldSize
public void setMaxFieldSize(int maxFieldSize)
-
close
public void close() throws SQLException
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceResultSet
- Throws:
SQLException
-
isClosed
public boolean isClosed() throws SQLException
- Specified by:
isClosed
in interfaceResultSet
- Throws:
SQLException
-
checkClosed
protected void checkClosed() throws SQLException
- Throws:
SQLException
-
getObject
public Object getObject(int column) throws SQLException
Get a java object based on the column index for the current row.
- Specified by:
getObject
in interfaceResultSet
- Parameters:
column
- The index of the column whose value needs to be fetched.- Returns:
- The value of the column as an object.
- Throws:
SQLException
- if a results access error occurs or transform fails.
-
getFetchSize
public int getFetchSize() throws SQLException
- Specified by:
getFetchSize
in interfaceResultSet
- Throws:
SQLException
-
submitNext
public ResultsFuture<Boolean> submitNext() throws SQLException
Assumes forward only cursoring- Throws:
SQLException
-
next
public boolean next() throws SQLException
- Specified by:
next
in interfaceResultSet
- Throws:
SQLException
-
previous
public boolean previous() throws SQLException
- Specified by:
previous
in interfaceResultSet
- Throws:
SQLException
-
getRow
public int getRow() throws SQLException
- Specified by:
getRow
in interfaceResultSet
- Throws:
SQLException
-
getRawCurrentValue
public Object getRawCurrentValue()
-
getObjectDirect
public Object getObjectDirect(int column) throws SQLException
Get the value of the current row at the column index specified.- Parameters:
column
- Column index- Returns:
- Value at column, which may be null
- Throws:
SQLException
- if this result set has an exception
-
getCurrentRecord
public List<?> getCurrentRecord() throws SQLException
Get all values in current record in column order- Returns:
- List of Object values in current row
- Throws:
SQLException
- if an access error occurs.
-
getType
public int getType() throws SQLException
- Specified by:
getType
in interfaceResultSet
- Throws:
SQLException
-
absolute
public boolean absolute(int row) throws SQLException
- Specified by:
absolute
in interfaceResultSet
- Throws:
SQLException
-
getUpdatedPlanDescription
protected PlanNode getUpdatedPlanDescription()
-
requestBatch
public org.teiid.jdbc.BatchResults.Batch requestBatch(int beginRow) throws SQLException
- Specified by:
requestBatch
in interfaceBatchResults.BatchFetcher
- Throws:
SQLException
-
getFinalRowNumber
protected int getFinalRowNumber()
-
hasNext
protected boolean hasNext() throws SQLException
- Throws:
SQLException
-
available
public int available() throws SQLException
Description copied from interface:TeiidResultSet
Returns an estimate of the minimum number of rows that can be read (after the current) without blocking or the end of the ResultSet is reached.- Specified by:
available
in interfaceTeiidResultSet
- Returns:
- an estimate of the minimum number of rows that can be read (after the current) without blocking or the end of the ResultSet is reached.
- Throws:
SQLException
- if the statement is closed or another error condition occurs.
-
getOffset
protected int getOffset()
-
getAbsoluteRowNumber
protected int getAbsoluteRowNumber()
-
cancelRowUpdates
public void cancelRowUpdates() throws SQLException
- Specified by:
cancelRowUpdates
in interfaceResultSet
- Throws:
SQLException
-
clearWarnings
public void clearWarnings() throws SQLException
- Specified by:
clearWarnings
in interfaceResultSet
- Throws:
SQLException
-
getBigDecimal
public BigDecimal getBigDecimal(int columnIndex) throws SQLException
- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
SQLException
-
getBigDecimal
public BigDecimal getBigDecimal(String columnName) throws SQLException
- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
SQLException
-
getBigDecimal
public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
SQLException
-
getBigDecimal
public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException
- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
SQLException
-
getBinaryStream
public InputStream getBinaryStream(int columnIndex) throws SQLException
- Specified by:
getBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
getBinaryStream
public InputStream getBinaryStream(String columnName) throws SQLException
- Specified by:
getBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
getBlob
public Blob getBlob(int columnIndex) throws SQLException
- Specified by:
getBlob
in interfaceResultSet
- Throws:
SQLException
-
getBlob
public Blob getBlob(String columnName) throws SQLException
- Specified by:
getBlob
in interfaceResultSet
- Throws:
SQLException
-
getBoolean
public boolean getBoolean(int columnIndex) throws SQLException
- Specified by:
getBoolean
in interfaceResultSet
- Throws:
SQLException
-
getBoolean
public boolean getBoolean(String columnName) throws SQLException
- Specified by:
getBoolean
in interfaceResultSet
- Throws:
SQLException
-
getByte
public byte getByte(int columnIndex) throws SQLException
- Specified by:
getByte
in interfaceResultSet
- Throws:
SQLException
-
getByte
public byte getByte(String columnName) throws SQLException
- Specified by:
getByte
in interfaceResultSet
- Throws:
SQLException
-
getBytes
public byte[] getBytes(int columnIndex) throws SQLException
- Specified by:
getBytes
in interfaceResultSet
- Throws:
SQLException
-
getBytes
public byte[] getBytes(String columnName) throws SQLException
- Specified by:
getBytes
in interfaceResultSet
- Throws:
SQLException
-
getConcurrency
public int getConcurrency() throws SQLException
Get the concurrency type for this ResultSet object. The concurrency was set by the Statement object. The possible concurrency types are CONCUR_READ_ONLY and CONCUR_UPDATABLE.- Specified by:
getConcurrency
in interfaceResultSet
- Returns:
- The resultSets are not updatable, this method returns CONCUR_READ_ONLY.
- Throws:
SQLException
- if the there is an error accesing results
-
getCharacterStream
public Reader getCharacterStream(int columnIndex) throws SQLException
- Specified by:
getCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getCharacterStream
public Reader getCharacterStream(String columnName) throws SQLException
- Specified by:
getCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getDate
public Date getDate(int columnIndex, Calendar cal) throws SQLException
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLException
-
getDate
public Date getDate(String columnName, Calendar cal) throws SQLException
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLException
-
getDate
public Date getDate(int columnIndex) throws SQLException
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLException
-
getDate
public Date getDate(String columnName) throws SQLException
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLException
-
getDouble
public double getDouble(int columnIndex) throws SQLException
- Specified by:
getDouble
in interfaceResultSet
- Throws:
SQLException
-
getDouble
public double getDouble(String columnName) throws SQLException
- Specified by:
getDouble
in interfaceResultSet
- Throws:
SQLException
-
getFetchDirection
public int getFetchDirection() throws SQLException
Gets the direction suggested to the driver as the direction in which to fetch rows.- Specified by:
getFetchDirection
in interfaceResultSet
- Returns:
- fetch direction for this ResultSet. This cannot be set and is always FETCH_FORWARD.
- Throws:
SQLException
-
getFloat
public float getFloat(int columnIndex) throws SQLException
- Specified by:
getFloat
in interfaceResultSet
- Throws:
SQLException
-
getFloat
public float getFloat(String columnName) throws SQLException
- Specified by:
getFloat
in interfaceResultSet
- Throws:
SQLException
-
getInt
public int getInt(int columnIndex) throws SQLException
- Specified by:
getInt
in interfaceResultSet
- Throws:
SQLException
-
getInt
public int getInt(String columnName) throws SQLException
- Specified by:
getInt
in interfaceResultSet
- Throws:
SQLException
-
getLong
public long getLong(int columnIndex) throws SQLException
- Specified by:
getLong
in interfaceResultSet
- Throws:
SQLException
-
getLong
public long getLong(String columnName) throws SQLException
- Specified by:
getLong
in interfaceResultSet
- Throws:
SQLException
-
getObject
public Object getObject(String columnName) throws SQLException
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getShort
public short getShort(int columnIndex) throws SQLException
- Specified by:
getShort
in interfaceResultSet
- Throws:
SQLException
-
getShort
public short getShort(String columnName) throws SQLException
- Specified by:
getShort
in interfaceResultSet
- Throws:
SQLException
-
getString
public String getString(int columnIndex) throws SQLException
- Specified by:
getString
in interfaceResultSet
- Throws:
SQLException
-
getString
public String getString(String columnName) throws SQLException
- Specified by:
getString
in interfaceResultSet
- Throws:
SQLException
-
getTime
public Time getTime(int columnIndex) throws SQLException
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLException
-
getTime
public Time getTime(String columnName) throws SQLException
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLException
-
getTime
public Time getTime(int columnIndex, Calendar cal) throws SQLException
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLException
-
getTime
public Time getTime(String columnName, Calendar cal) throws SQLException
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(int columnIndex) throws SQLException
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(String columnName) throws SQLException
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLException
-
moveToCurrentRow
public void moveToCurrentRow() throws SQLException
Moves the cursor to the remembered cursor position, usually the current row. This method does not have any effect if the cursor is not on the insert row. ResultSet cannot currently be updated.- Specified by:
moveToCurrentRow
in interfaceResultSet
- Throws:
SQLException
-
wasNull
public boolean wasNull() throws SQLException
This will return a boolean value if the last column that was read had a value equal to null. If the last column read was null return true, else return false.- Specified by:
wasNull
in interfaceResultSet
- Returns:
- A boolean value showing if the lastvalue read in was null or not.
- Throws:
SQLException
-
accumulateWarnings
protected void accumulateWarnings(ResultsMessage resultsMsg)
-
getMetaData
public ResultSetMetaData getMetaData() throws SQLException
This method returns the meta data of the result set, such as the number, types and properties of this resultSets columns.
- Specified by:
getMetaData
in interfaceResultSet
- Returns:
- ResultSerMetaData object for these results.
- Throws:
SQLException
- if results access error occurs
-
getCursorName
public String getCursorName() throws SQLException
Retrieves the RequestID for the query that created this ResultSet.- Specified by:
getCursorName
in interfaceResultSet
- Returns:
- The requestID for the query that created these results
- Throws:
SQLException
-
getStatement
public StatementImpl getStatement() throws SQLException
Retrieves the Statement object that produced this ResultSet object.
- Specified by:
getStatement
in interfaceResultSet
- Returns:
- a Statement object.
- Throws:
SQLException
- if the there is an error accesing results
-
getWarnings
public SQLWarning getWarnings() throws SQLException
- Specified by:
getWarnings
in interfaceResultSet
- Throws:
SQLException
-
isFirst
public boolean isFirst() throws SQLException
- Specified by:
isFirst
in interfaceResultSet
- Throws:
SQLException
-
isLast
public boolean isLast() throws SQLException
- Specified by:
isLast
in interfaceResultSet
- Throws:
SQLException
-
isAfterLast
public boolean isAfterLast() throws SQLException
Determines whether the cursor is after the last row in this ResultSet object. This method should be called only if the result set is scrollable.
- Specified by:
isAfterLast
in interfaceResultSet
- Returns:
- true if the cursor is after the last row in the resultSet.
- Throws:
SQLException
-
isBeforeFirst
public boolean isBeforeFirst() throws SQLException
Determines whether the cursor is before the first row in this ResultSet object. This method should be called only if the result set is scrollable.
- Specified by:
isBeforeFirst
in interfaceResultSet
- Returns:
- true if the cursor is before the last row in the resultSet;false if the cursor is at any other position or the result set contains no rows.
- Throws:
SQLException
-
relative
public boolean relative(int rows) throws SQLException
- Specified by:
relative
in interfaceResultSet
- Throws:
SQLException
-
last
public boolean last() throws SQLException
Moves the cursor to the last row in the in this ResultSet object. This method should be called only if the result set is scrollable.
- Specified by:
last
in interfaceResultSet
- Returns:
- true if the cursor is on a validRow, false otherwise or if no rows exist.
- Throws:
SQLException
- if the type of the ResultSet is TYPE_FORWARD_ONLY
-
checkNotForwardOnly
protected void checkNotForwardOnly() throws SQLException
- Throws:
SQLException
-
afterLast
public void afterLast() throws SQLException
Moves the cursor to the end of the result set, just after the last row. Has no effect if the result set contains no rows.
- Specified by:
afterLast
in interfaceResultSet
- Throws:
SQLException
- if a results access error occurs or the result set type is TYPE_FORWARD_ONLY
-
beforeFirst
public void beforeFirst() throws SQLException
Moves the cursor to the front of the result set, just before the first row. Has no effect if the result set contains no rows.
- Specified by:
beforeFirst
in interfaceResultSet
- Throws:
SQLException
- if a results can not be accessed or the result set type is TYPE_FORWARD_ONLY
-
first
public boolean first() throws SQLException
Moves the cursor to the first row in this ResultSet object.
- Specified by:
first
in interfaceResultSet
- Returns:
- true if the cursor is on valid row, false if there are no rows in the resultset.
- Throws:
SQLException
- if the ResulSet is of TYPE_FORWARD_ONLY.
-
findColumn
public int findColumn(String columnName) throws SQLException
- Specified by:
findColumn
in interfaceResultSet
- Throws:
SQLException
-
findColumnIndex
protected int findColumnIndex(String columnName) throws SQLException
- Throws:
SQLException
-
getDefaultCalendar
protected Calendar getDefaultCalendar()
-
deleteRow
public void deleteRow() throws SQLException
- Specified by:
deleteRow
in interfaceResultSet
- Throws:
SQLException
-
getArray
public Array getArray(int columnIndex) throws SQLException
- Specified by:
getArray
in interfaceResultSet
- Throws:
SQLException
-
getArray
public Array getArray(String columnLabel) throws SQLException
- Specified by:
getArray
in interfaceResultSet
- Throws:
SQLException
-
getAsciiStream
public InputStream getAsciiStream(int columnIndex) throws SQLException
- Specified by:
getAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
getAsciiStream
public InputStream getAsciiStream(String columnLabel) throws SQLException
- Specified by:
getAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
getClob
public Clob getClob(int columnIndex) throws SQLException
- Specified by:
getClob
in interfaceResultSet
- Throws:
SQLException
-
getSQLXML
public SQLXML getSQLXML(int columnIndex) throws SQLException
- Specified by:
getSQLXML
in interfaceResultSet
- Throws:
SQLException
-
getClob
public Clob getClob(String columnLabel) throws SQLException
- Specified by:
getClob
in interfaceResultSet
- Throws:
SQLException
-
getHoldability
public int getHoldability() throws SQLException
- Specified by:
getHoldability
in interfaceResultSet
- Throws:
SQLException
-
getNCharacterStream
public Reader getNCharacterStream(int columnIndex) throws SQLException
- Specified by:
getNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getNCharacterStream
public Reader getNCharacterStream(String columnLabel) throws SQLException
- Specified by:
getNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getNClob
public NClob getNClob(int columnIndex) throws SQLException
- Specified by:
getNClob
in interfaceResultSet
- Throws:
SQLException
-
getNClob
public NClob getNClob(String columnLabel) throws SQLException
- Specified by:
getNClob
in interfaceResultSet
- Throws:
SQLException
-
getNString
public String getNString(int columnIndex) throws SQLException
- Specified by:
getNString
in interfaceResultSet
- Throws:
SQLException
-
getNString
public String getNString(String columnLabel) throws SQLException
- Specified by:
getNString
in interfaceResultSet
- Throws:
SQLException
-
getObject
public Object getObject(int columnIndex, Map<String,Class<?>> map) throws SQLException
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getObject
public Object getObject(String columnLabel, Map<String,Class<?>> map) throws SQLException
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getRef
public Ref getRef(int columnIndex) throws SQLException
- Specified by:
getRef
in interfaceResultSet
- Throws:
SQLException
-
getRef
public Ref getRef(String columnLabel) throws SQLException
- Specified by:
getRef
in interfaceResultSet
- Throws:
SQLException
-
getRowId
public RowId getRowId(int columnIndex) throws SQLException
- Specified by:
getRowId
in interfaceResultSet
- Throws:
SQLException
-
getRowId
public RowId getRowId(String columnLabel) throws SQLException
- Specified by:
getRowId
in interfaceResultSet
- Throws:
SQLException
-
getSQLXML
public SQLXML getSQLXML(String columnLabel) throws SQLException
- Specified by:
getSQLXML
in interfaceResultSet
- Throws:
SQLException
-
getUnicodeStream
public InputStream getUnicodeStream(int columnIndex) throws SQLException
- Specified by:
getUnicodeStream
in interfaceResultSet
- Throws:
SQLException
-
getUnicodeStream
public InputStream getUnicodeStream(String columnLabel) throws SQLException
- Specified by:
getUnicodeStream
in interfaceResultSet
- Throws:
SQLException
-
getURL
public URL getURL(int columnIndex) throws SQLException
- Specified by:
getURL
in interfaceResultSet
- Throws:
SQLException
-
getURL
public URL getURL(String columnLabel) throws SQLException
- Specified by:
getURL
in interfaceResultSet
- Throws:
SQLException
-
insertRow
public void insertRow() throws SQLException
- Specified by:
insertRow
in interfaceResultSet
- Throws:
SQLException
-
moveToInsertRow
public void moveToInsertRow() throws SQLException
- Specified by:
moveToInsertRow
in interfaceResultSet
- Throws:
SQLException
-
refreshRow
public void refreshRow() throws SQLException
- Specified by:
refreshRow
in interfaceResultSet
- Throws:
SQLException
-
rowDeleted
public boolean rowDeleted() throws SQLException
- Specified by:
rowDeleted
in interfaceResultSet
- Throws:
SQLException
-
rowInserted
public boolean rowInserted() throws SQLException
- Specified by:
rowInserted
in interfaceResultSet
- Throws:
SQLException
-
rowUpdated
public boolean rowUpdated() throws SQLException
- Specified by:
rowUpdated
in interfaceResultSet
- Throws:
SQLException
-
setFetchDirection
public void setFetchDirection(int direction) throws SQLException
- Specified by:
setFetchDirection
in interfaceResultSet
- Throws:
SQLException
-
setFetchSize
public void setFetchSize(int rows) throws SQLException
- Specified by:
setFetchSize
in interfaceResultSet
- Throws:
SQLException
-
updateArray
public void updateArray(int columnIndex, Array x) throws SQLException
- Specified by:
updateArray
in interfaceResultSet
- Throws:
SQLException
-
updateArray
public void updateArray(String columnLabel, Array x) throws SQLException
- Specified by:
updateArray
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(String columnLabel, InputStream x, int length) throws SQLException
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, InputStream x, long length) throws SQLException
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, InputStream x) throws SQLException
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(String columnLabel, InputStream x, long length) throws SQLException
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(String columnLabel, InputStream x) throws SQLException
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateBigDecimal
public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException
- Specified by:
updateBigDecimal
in interfaceResultSet
- Throws:
SQLException
-
updateBigDecimal
public void updateBigDecimal(String columnLabel, BigDecimal x) throws SQLException
- Specified by:
updateBigDecimal
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(String columnLabel, InputStream x, int length) throws SQLException
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, InputStream x, long length) throws SQLException
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, InputStream x) throws SQLException
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(String columnLabel, InputStream x, long length) throws SQLException
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(String columnLabel, InputStream x) throws SQLException
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(int columnIndex, Blob x) throws SQLException
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(String columnLabel, Blob x) throws SQLException
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(int columnIndex, InputStream inputStream, long length) throws SQLException
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(int columnIndex, InputStream inputStream) throws SQLException
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(String columnLabel, InputStream inputStream, long length) throws SQLException
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(String columnLabel, InputStream inputStream) throws SQLException
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBoolean
public void updateBoolean(int columnIndex, boolean x) throws SQLException
- Specified by:
updateBoolean
in interfaceResultSet
- Throws:
SQLException
-
updateBoolean
public void updateBoolean(String columnLabel, boolean x) throws SQLException
- Specified by:
updateBoolean
in interfaceResultSet
- Throws:
SQLException
-
updateByte
public void updateByte(int columnIndex, byte x) throws SQLException
- Specified by:
updateByte
in interfaceResultSet
- Throws:
SQLException
-
updateByte
public void updateByte(String columnLabel, byte x) throws SQLException
- Specified by:
updateByte
in interfaceResultSet
- Throws:
SQLException
-
updateBytes
public void updateBytes(int columnIndex, byte[] x) throws SQLException
- Specified by:
updateBytes
in interfaceResultSet
- Throws:
SQLException
-
updateBytes
public void updateBytes(String columnLabel, byte[] x) throws SQLException
- Specified by:
updateBytes
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, Reader x, int length) throws SQLException
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(String columnLabel, Reader reader, int length) throws SQLException
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, Reader x, long length) throws SQLException
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, Reader x) throws SQLException
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(String columnLabel, Reader reader, long length) throws SQLException
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(String columnLabel, Reader reader) throws SQLException
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateClob
public void updateClob(int columnIndex, Clob x) throws SQLException
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
public void updateClob(String columnLabel, Clob x) throws SQLException
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
public void updateClob(int columnIndex, Reader reader, long length) throws SQLException
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
public void updateClob(int columnIndex, Reader reader) throws SQLException
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
public void updateClob(String columnLabel, Reader reader, long length) throws SQLException
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
public void updateClob(String columnLabel, Reader reader) throws SQLException
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateDate
public void updateDate(int columnIndex, Date x) throws SQLException
- Specified by:
updateDate
in interfaceResultSet
- Throws:
SQLException
-
updateDate
public void updateDate(String columnLabel, Date x) throws SQLException
- Specified by:
updateDate
in interfaceResultSet
- Throws:
SQLException
-
updateDouble
public void updateDouble(int columnIndex, double x) throws SQLException
- Specified by:
updateDouble
in interfaceResultSet
- Throws:
SQLException
-
updateDouble
public void updateDouble(String columnLabel, double x) throws SQLException
- Specified by:
updateDouble
in interfaceResultSet
- Throws:
SQLException
-
updateFloat
public void updateFloat(int columnIndex, float x) throws SQLException
- Specified by:
updateFloat
in interfaceResultSet
- Throws:
SQLException
-
updateFloat
public void updateFloat(String columnLabel, float x) throws SQLException
- Specified by:
updateFloat
in interfaceResultSet
- Throws:
SQLException
-
updateInt
public void updateInt(int columnIndex, int x) throws SQLException
- Specified by:
updateInt
in interfaceResultSet
- Throws:
SQLException
-
updateInt
public void updateInt(String columnLabel, int x) throws SQLException
- Specified by:
updateInt
in interfaceResultSet
- Throws:
SQLException
-
updateLong
public void updateLong(int columnIndex, long x) throws SQLException
- Specified by:
updateLong
in interfaceResultSet
- Throws:
SQLException
-
updateLong
public void updateLong(String columnLabel, long x) throws SQLException
- Specified by:
updateLong
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException
- Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, Reader x) throws SQLException
- Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
public void updateNCharacterStream(String columnLabel, Reader reader, long length) throws SQLException
- Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
public void updateNCharacterStream(String columnLabel, Reader reader) throws SQLException
- Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
public void updateNClob(int columnIndex, NClob clob) throws SQLException
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
public void updateNClob(int columnIndex, Reader reader, long length) throws SQLException
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
public void updateNClob(int columnIndex, Reader reader) throws SQLException
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
public void updateNClob(String columnLabel, NClob clob) throws SQLException
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
public void updateNClob(String columnLabel, Reader reader, long length) throws SQLException
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
public void updateNClob(String columnLabel, Reader reader) throws SQLException
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNString
public void updateNString(int columnIndex, String string) throws SQLException
- Specified by:
updateNString
in interfaceResultSet
- Throws:
SQLException
-
updateNString
public void updateNString(String columnLabel, String string) throws SQLException
- Specified by:
updateNString
in interfaceResultSet
- Throws:
SQLException
-
updateNull
public void updateNull(int columnIndex) throws SQLException
- Specified by:
updateNull
in interfaceResultSet
- Throws:
SQLException
-
updateNull
public void updateNull(String columnLabel) throws SQLException
- Specified by:
updateNull
in interfaceResultSet
- Throws:
SQLException
-
updateObject
public void updateObject(int columnIndex, Object x, int scaleOrLength) throws SQLException
- Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLException
-
updateObject
public void updateObject(int columnIndex, Object x) throws SQLException
- Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLException
-
updateObject
public void updateObject(String columnLabel, Object x, int scaleOrLength) throws SQLException
- Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLException
-
updateObject
public void updateObject(String columnLabel, Object x) throws SQLException
- Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLException
-
updateRef
public void updateRef(int columnIndex, Ref x) throws SQLException
- Specified by:
updateRef
in interfaceResultSet
- Throws:
SQLException
-
updateRef
public void updateRef(String columnLabel, Ref x) throws SQLException
- Specified by:
updateRef
in interfaceResultSet
- Throws:
SQLException
-
updateRow
public void updateRow() throws SQLException
- Specified by:
updateRow
in interfaceResultSet
- Throws:
SQLException
-
updateRowId
public void updateRowId(int columnIndex, RowId x) throws SQLException
- Specified by:
updateRowId
in interfaceResultSet
- Throws:
SQLException
-
updateRowId
public void updateRowId(String columnLabel, RowId x) throws SQLException
- Specified by:
updateRowId
in interfaceResultSet
- Throws:
SQLException
-
updateShort
public void updateShort(int columnIndex, short x) throws SQLException
- Specified by:
updateShort
in interfaceResultSet
- Throws:
SQLException
-
updateShort
public void updateShort(String columnLabel, short x) throws SQLException
- Specified by:
updateShort
in interfaceResultSet
- Throws:
SQLException
-
updateSQLXML
public void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException
- Specified by:
updateSQLXML
in interfaceResultSet
- Throws:
SQLException
-
updateSQLXML
public void updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException
- Specified by:
updateSQLXML
in interfaceResultSet
- Throws:
SQLException
-
updateString
public void updateString(int columnIndex, String x) throws SQLException
- Specified by:
updateString
in interfaceResultSet
- Throws:
SQLException
-
updateString
public void updateString(String columnLabel, String x) throws SQLException
- Specified by:
updateString
in interfaceResultSet
- Throws:
SQLException
-
updateTime
public void updateTime(int columnIndex, Time x) throws SQLException
- Specified by:
updateTime
in interfaceResultSet
- Throws:
SQLException
-
updateTime
public void updateTime(String columnLabel, Time x) throws SQLException
- Specified by:
updateTime
in interfaceResultSet
- Throws:
SQLException
-
updateTimestamp
public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException
- Specified by:
updateTimestamp
in interfaceResultSet
- Throws:
SQLException
-
updateTimestamp
public void updateTimestamp(String columnLabel, Timestamp x) throws SQLException
- Specified by:
updateTimestamp
in interfaceResultSet
- Throws:
SQLException
-
getObject
public <T> T getObject(int columnIndex, Class<T> type) throws SQLException
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getObject
public <T> T getObject(String columnLabel, Class<T> type) throws SQLException
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
-