Module org.postgresql.pljava.internal

Package org.postgresql.pljava.jdbc

Class SPIResultSet

java.lang.Object

org.postgresql.pljava.jdbc.AbstractResultSet

org.postgresql.pljava.jdbc.ObjectResultSet

org.postgresql.pljava.jdbc.ReadOnlyResultSet

org.postgresql.pljava.jdbc.ResultSetBase

org.postgresql.pljava.jdbc.SPIResultSet

All Implemented Interfaces:

AutoCloseable, ResultSet, Wrapper

public class SPIResultSet
extends ResultSetBase

A Read-only ResultSet that provides direct access to a Portal. At present, only forward positioning is implemented. Attempts to use reverse or absolute positioning will fail.

Author:

Thomas Hallgren

Field Summary

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

Modifier and Type	Method	Description
void	close()
int	findColumn(String columnName)
protected final Tuple	getCurrentRow()	Return the Tuple most recently returned by next().
String	getCursorName()	This method does return the name of the portal, but beware of attempting positioned update/delete, because rows are read from the portal in ResultSetBase.getFetchSize() batches.
ResultSetMetaData	getMetaData()	Returns an SPIResultSetMetaData instance.
protected Object	getObjectValue(int columnIndex, Class<?> type)	Implemented over Tuple.getObject(TupleDesc,int,Class).
protected final Portal	getPortal()	Return the Portal associated with this ResultSet.
Statement	getStatement()	Returns null if not overridden in a subclass.
protected final TupleTable	getTupleTable()	Get a(nother) table of ResultSetBase.getFetchSize() rows from the Portal.
boolean	isLast()
boolean	next()
protected final Tuple	peekNext()	Get another Tuple from the TupleTable, refreshing the table as needed.
Portal	unwrapAsPortal()

Methods inherited from class org.postgresql.pljava.jdbc.ResultSetBase

absolute, afterLast, beforeFirst, first, getFetchDirection, getFetchSize, getHoldability, getRow, getType, isAfterLast, isBeforeFirst, isClosed, isFirst, last, previous, relative, setFetchDirection, setFetchSize

Methods inherited from class org.postgresql.pljava.jdbc.ReadOnlyResultSet

cancelRowUpdates, deleteRow, getConcurrency, insertRow, moveToCurrentRow, moveToInsertRow, rowDeleted, rowInserted, rowUpdated, updateObject, updateObject, updateRow

Methods inherited from class org.postgresql.pljava.jdbc.ObjectResultSet

clearWarnings, getArray, getAsciiStream, getBigDecimal, getBigDecimal, getBinaryStream, getBlob, getBoolean, getByte, getBytes, getCharacterStream, getClob, getDate, getDate, getDouble, getFloat, getInt, getLong, getNumber, getObject, getObject, getObject, getObjectValue, getObjectValue, getRef, getShort, getString, getTime, getTime, getTimestamp, getTimestamp, getUnicodeStream, getURL, getValue, getValue, getWarnings, refreshRow, updateArray, updateAsciiStream, updateBigDecimal, updateBinaryStream, updateBlob, updateBoolean, updateByte, updateBytes, updateCharacterStream, updateClob, updateDate, updateDouble, updateFloat, updateInt, updateLong, updateNull, updateRef, updateShort, updateString, updateTime, updateTimestamp, wasNull

Methods inherited from class org.postgresql.pljava.jdbc.AbstractResultSet

getArray, getAsciiStream, getBigDecimal, getBigDecimal, getBinaryStream, getBlob, getBoolean, getByte, getBytes, getCharacterStream, getClob, getDate, getDate, getDouble, getFloat, getInt, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getRef, getRowId, getRowId, getShort, getSQLXML, getSQLXML, getString, getTime, getTime, getTimestamp, getTimestamp, getUnicodeStream, getURL, isWrapperFor, unwrap, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateByte, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDouble, updateFloat, updateInt, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateObject, updateObject, updateRef, updateRowId, updateRowId, updateShort, updateSQLXML, updateSQLXML, updateString, updateTime, updateTimestamp

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

Method Details

unwrapAsPortal

public Portal unwrapAsPortal()
                      throws SQLException

Throws:

SQLException

close

public void close()
           throws SQLException

Specified by:

close in interface AutoCloseable

Specified by:

close in interface ResultSet

Overrides:

close in class ResultSetBase

Throws:

SQLException

isLast

public boolean isLast()
               throws SQLException

Throws:

SQLException

next

public boolean next()
             throws SQLException

Throws:

SQLException

getCursorName

public String getCursorName()
                     throws SQLException

This method does return the name of the portal, but beware of attempting positioned update/delete, because rows are read from the portal in ResultSetBase.getFetchSize() batches.

Specified by:

getCursorName in interface ResultSet

Overrides:

getCursorName in class AbstractResultSet

Throws:

SQLException

findColumn

public int findColumn(String columnName)
               throws SQLException

Throws:

SQLException

getStatement

public Statement getStatement()
                       throws SQLException

Description copied from class: AbstractResultSet

Returns null if not overridden in a subclass.

Specified by:

getStatement in interface ResultSet

Overrides:

getStatement in class AbstractResultSet

Throws:

SQLException

getPortal

protected final Portal getPortal()
                          throws SQLException

Return the Portal associated with this ResultSet.

Throws:

SQLException

getTupleTable

protected final TupleTable getTupleTable()
                                  throws SQLException

Get a(nother) table of ResultSetBase.getFetchSize() rows from the Portal.

Throws:

SQLException

getCurrentRow

protected final Tuple getCurrentRow()
                             throws SQLException

Return the Tuple most recently returned by next().

Throws:

SQLException

peekNext

protected final Tuple peekNext()
                        throws SQLException

Get another Tuple from the TupleTable, refreshing the table as needed.

Throws:

SQLException

getObjectValue

protected Object getObjectValue(int columnIndex,
 Class<?> type)
                         throws SQLException

Implemented over Tuple.getObject(TupleDesc,int,Class).

Specified by:

getObjectValue in class ObjectResultSet

Throws:

SQLException

getMetaData

public ResultSetMetaData getMetaData()
                              throws SQLException

Returns an SPIResultSetMetaData instance.

Specified by:

getMetaData in interface ResultSet

Overrides:

getMetaData in class ObjectResultSet

Throws:

SQLException - indicating that this feature is not supported.