Module org.postgresql.pljava.internal

Package org.postgresql.pljava.jdbc

Class ObjectResultSet

java.lang.Object

org.postgresql.pljava.jdbc.AbstractResultSet

org.postgresql.pljava.jdbc.ObjectResultSet

All Implemented Interfaces:

AutoCloseable, ResultSet, Wrapper

Direct Known Subclasses:

ReadOnlyResultSet, SingleRowResultSet

public abstract class ObjectResultSet
extends AbstractResultSet

Implements most getters in terms of getValue(int, java.lang.Class<T>), getNumber(int, java.lang.Class), or a few other ResultSet getters that are so implemented, tracks wasNull, and provides getObjectValue(int) as the chief method for subclasses to implement; turns most updaters into ResultSet.updateObject(int,Object).

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

Constructor Summary

Constructors

Constructor	Description
ObjectResultSet()

Method Summary

Modifier and Type	Method	Description
void	clearWarnings()	This is a noop since warnings are not supported.
Array	getArray(int columnIndex)	Implemented over getValue.
InputStream	getAsciiStream(int columnIndex)	Implemented over getClob.
BigDecimal	getBigDecimal(int columnIndex)	Implemented over getValue.
BigDecimal	getBigDecimal(int columnIndex, int scale)	Throws "unsupported" exception.
InputStream	getBinaryStream(int columnIndex)	Implemented over getBlob.
Blob	getBlob(int columnIndex)	Implemented over getBytes.
boolean	getBoolean(int columnIndex)	Implemented over getValue.
byte	getByte(int columnIndex)	Implemented over getNumber.
byte[]	getBytes(int columnIndex)	Implemented over getValue.
Reader	getCharacterStream(int columnIndex)	Implemented over getClob.
Clob	getClob(int columnIndex)	Implemented over getString.
Date	getDate(int columnIndex)	Implemented over getValue.
Date	getDate(int columnIndex, Calendar cal)	Implemented over getValue.
double	getDouble(int columnIndex)	Implemented over getNumber.
float	getFloat(int columnIndex)	Implemented over getNumber.
int	getInt(int columnIndex)	Implemented over getNumber.
long	getLong(int columnIndex)	Implemented over getNumber.
ResultSetMetaData	getMetaData()	Throws "unsupported" exception if not overridden in a subclass.
protected final Number	getNumber(int columnIndex, Class cls)	Implemented over getObjectValue(int, java.util.Map), tracks wasNull, applies SPIConnection.basicNumericCoercion(java.lang.Class, java.lang.Object) to cls.
final Object	getObject(int columnIndex)	Implemented over getObjectValue.
final <T> T	getObject(int columnIndex, Class<T> type)	Implemented over getObjectValue.
final Object	getObject(int columnIndex, Map map)	Implemented over getObjectValue.
protected Object	getObjectValue(int columnIndex)	Implemented over getObjectValue(int,Class), passing null for the class.
protected abstract Object	getObjectValue(int columnIndex, Class<?> type)	Primary method for subclass to override to retrieve a value.
protected Object	getObjectValue(int columnIndex, Map typeMap)	Implemented over getObjectValue(int), complains if typeMap is non-null.
Ref	getRef(int columnIndex)	Implemented over getValue.
short	getShort(int columnIndex)	Implemented over getNumber.
String	getString(int columnIndex)	Implemented over getValue.
Time	getTime(int columnIndex)	Implemented over getValue.
Time	getTime(int columnIndex, Calendar cal)	Implemented over getValue.
Timestamp	getTimestamp(int columnIndex)	Implemented over getValue.
Timestamp	getTimestamp(int columnIndex, Calendar cal)	Implemented over getValue.
InputStream	getUnicodeStream(int columnIndex)	Throws "unsupported" exception.
URL	getURL(int columnIndex)	Implemented over getValue.
protected final <T> T	getValue(int columnIndex, Class<T> cls)	Implemented over getObject(int), applies SPIConnection.basicCoercion(java.lang.Class<T>, java.lang.Object) to cls.
protected <T> T	getValue(int columnIndex, Class<T> cls, Calendar cal)	Implemented over getObject(int), applies SPIConnection.basicCalendricalCoercion(java.lang.Class<T>, java.lang.Object, java.util.Calendar) to cls.
SQLWarning	getWarnings()	Returns null if not overridden in a subclass.
void	refreshRow()	Refresh row is not yet implemented.
void	updateArray(int columnIndex, Array x)	Implemented over updateObject.
void	updateAsciiStream(int columnIndex, InputStream x, int length)	Implemented over ClobValue and updateObject.
void	updateBigDecimal(int columnIndex, BigDecimal x)	Implemented over updateObject.
void	updateBinaryStream(int columnIndex, InputStream x, int length)	Implemented over BlobValue and updateBlob.
void	updateBlob(int columnIndex, Blob x)	Implemented over updateObject.
void	updateBoolean(int columnIndex, boolean x)	Implemented over updateObject.
void	updateByte(int columnIndex, byte x)	Implemented over updateObject.
void	updateBytes(int columnIndex, byte[] x)	Implemented over updateObject.
void	updateCharacterStream(int columnIndex, Reader x, int length)	Implemented over ClobValue and updateClob.
void	updateClob(int columnIndex, Clob x)	Implemented over updateObject.
void	updateDate(int columnIndex, Date x)	Implemented over updateObject.
void	updateDouble(int columnIndex, double x)	Implemented over updateObject.
void	updateFloat(int columnIndex, float x)	Implemented over updateObject.
void	updateInt(int columnIndex, int x)	Implemented over updateObject.
void	updateLong(int columnIndex, long x)	Implemented over updateObject.
void	updateNull(int columnIndex)	Implemented over updateObject.
void	updateRef(int columnIndex, Ref x)	Implemented over updateObject.
void	updateShort(int columnIndex, short x)	Implemented over updateObject.
void	updateString(int columnIndex, String x)	Implemented over updateObject.
void	updateTime(int columnIndex, Time x)	Implemented over updateObject.
void	updateTimestamp(int columnIndex, Timestamp x)	Implemented over updateObject.
boolean	wasNull()	Returns a private value updated by final methods in this class.

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

getArray, getAsciiStream, getBigDecimal, getBigDecimal, getBinaryStream, getBlob, getBoolean, getByte, getBytes, getCharacterStream, getClob, getCursorName, getDate, getDate, getDouble, getFloat, getInt, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getRef, getRowId, getRowId, getShort, getSQLXML, getSQLXML, getStatement, 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

absolute, afterLast, beforeFirst, cancelRowUpdates, close, deleteRow, findColumn, first, getConcurrency, getFetchDirection, getFetchSize, getHoldability, getRow, getType, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateRow

Constructor Details

ObjectResultSet

public ObjectResultSet()

Method Details

wasNull

public boolean wasNull()

Returns a private value updated by final methods in this class.

clearWarnings

public void clearWarnings()
                   throws SQLException

This is a noop since warnings are not supported.

Throws:

SQLException

getWarnings

public SQLWarning getWarnings()
                       throws SQLException

Returns null if not overridden in a subclass.

Throws:

SQLException

getMetaData

public ResultSetMetaData getMetaData()
                              throws SQLException

Throws "unsupported" exception if not overridden in a subclass.

Throws:

SQLException - indicating that this feature is not supported.

getArray

public Array getArray(int columnIndex)
               throws SQLException

Implemented over getValue.

Throws:

SQLException

getAsciiStream

public InputStream getAsciiStream(int columnIndex)
                           throws SQLException

Implemented over getClob.

Throws:

SQLException

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex)
                         throws SQLException

Implemented over getValue.

Throws:

SQLException

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex,
 int scale)
                         throws SQLException

Throws "unsupported" exception.

Throws:

SQLException

getBinaryStream

public InputStream getBinaryStream(int columnIndex)
                            throws SQLException

Implemented over getBlob.

Throws:

SQLException

getBlob

public Blob getBlob(int columnIndex)
             throws SQLException

Implemented over getBytes.

Throws:

SQLException

getBoolean

public boolean getBoolean(int columnIndex)
                   throws SQLException

Implemented over getValue.

Throws:

SQLException

getByte

public byte getByte(int columnIndex)
             throws SQLException

Implemented over getNumber.

Throws:

SQLException

getBytes

public byte[] getBytes(int columnIndex)
                throws SQLException

Implemented over getValue.

Throws:

SQLException

getCharacterStream

public Reader getCharacterStream(int columnIndex)
                          throws SQLException

Implemented over getClob.

Throws:

SQLException

getClob

public Clob getClob(int columnIndex)
             throws SQLException

Implemented over getString.

Throws:

SQLException

getDate

public Date getDate(int columnIndex)
             throws SQLException

Implemented over getValue.

Throws:

SQLException

getDate

public Date getDate(int columnIndex,
 Calendar cal)
             throws SQLException

Implemented over getValue.

Throws:

SQLException

getDouble

public double getDouble(int columnIndex)
                 throws SQLException

Implemented over getNumber.

Throws:

SQLException

getFloat

public float getFloat(int columnIndex)
               throws SQLException

Implemented over getNumber.

Throws:

SQLException

getInt

public int getInt(int columnIndex)
           throws SQLException

Implemented over getNumber.

Throws:

SQLException

getLong

public long getLong(int columnIndex)
             throws SQLException

Implemented over getNumber.

Throws:

SQLException

getObject

public final Object getObject(int columnIndex)
                       throws SQLException

Implemented over getObjectValue. Final because it records wasNull for use by other methods.

Throws:

SQLException

getObject

public final Object getObject(int columnIndex,
 Map map)
                       throws SQLException

Implemented over getObjectValue. Final because it records wasNull for use by other methods.

Throws:

SQLException

getRef

public Ref getRef(int columnIndex)
           throws SQLException

Implemented over getValue.

Throws:

SQLException

getShort

public short getShort(int columnIndex)
               throws SQLException

Implemented over getNumber.

Throws:

SQLException

getString

public String getString(int columnIndex)
                 throws SQLException

Implemented over getValue.

Throws:

SQLException

getTime

public Time getTime(int columnIndex)
             throws SQLException

Implemented over getValue.

Throws:

SQLException

getTime

public Time getTime(int columnIndex,
 Calendar cal)
             throws SQLException

Implemented over getValue.

Throws:

SQLException

getTimestamp

public Timestamp getTimestamp(int columnIndex)
                       throws SQLException

Implemented over getValue.

Throws:

SQLException

getTimestamp

public Timestamp getTimestamp(int columnIndex,
 Calendar cal)
                       throws SQLException

Implemented over getValue.

Throws:

SQLException

getUnicodeStream

public InputStream getUnicodeStream(int columnIndex)
                             throws SQLException

Throws "unsupported" exception.

Throws:

SQLException

getURL

public URL getURL(int columnIndex)
           throws SQLException

Implemented over getValue.

Throws:

SQLException

refreshRow

public void refreshRow()
                throws SQLException

Refresh row is not yet implemented.

Throws:

SQLException - indicating that this feature is not supported.

updateArray

public void updateArray(int columnIndex,
 Array x)
                 throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex,
 InputStream x,
 int length)
                       throws SQLException

Implemented over ClobValue and updateObject.

Throws:

SQLException

updateBigDecimal

public void updateBigDecimal(int columnIndex,
 BigDecimal x)
                      throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex,
 InputStream x,
 int length)
                        throws SQLException

Implemented over BlobValue and updateBlob.

Throws:

SQLException

updateBlob

public void updateBlob(int columnIndex,
 Blob x)
                throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateBoolean

public void updateBoolean(int columnIndex,
 boolean x)
                   throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateByte

public void updateByte(int columnIndex,
 byte x)
                throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateBytes

public void updateBytes(int columnIndex,
 byte[] x)
                 throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex,
 Reader x,
 int length)
                           throws SQLException

Implemented over ClobValue and updateClob.

Throws:

SQLException

updateClob

public void updateClob(int columnIndex,
 Clob x)
                throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateDate

public void updateDate(int columnIndex,
 Date x)
                throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateDouble

public void updateDouble(int columnIndex,
 double x)
                  throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateFloat

public void updateFloat(int columnIndex,
 float x)
                 throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateInt

public void updateInt(int columnIndex,
 int x)
               throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateLong

public void updateLong(int columnIndex,
 long x)
                throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateNull

public void updateNull(int columnIndex)
                throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateRef

public void updateRef(int columnIndex,
 Ref x)
               throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateShort

public void updateShort(int columnIndex,
 short x)
                 throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateString

public void updateString(int columnIndex,
 String x)
                  throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateTime

public void updateTime(int columnIndex,
 Time x)
                throws SQLException

Implemented over updateObject.

Throws:

SQLException

updateTimestamp

public void updateTimestamp(int columnIndex,
 Timestamp x)
                     throws SQLException

Implemented over updateObject.

Throws:

SQLException

getObject

public final <T> T getObject(int columnIndex,
 Class<T> type)
                      throws SQLException

Implemented over getObjectValue. Final because it records wasNull for use by other methods.

Throws:

SQLException

getNumber

protected final Number getNumber(int columnIndex,
 Class cls)
                          throws SQLException

Implemented over getObjectValue(int, java.util.Map), tracks wasNull, applies SPIConnection.basicNumericCoercion(java.lang.Class, java.lang.Object) to cls.

Throws:

SQLException

getValue

protected final <T> T getValue(int columnIndex,
 Class<T> cls)
                        throws SQLException

Implemented over getObject(int), applies SPIConnection.basicCoercion(java.lang.Class<T>, java.lang.Object) to cls.

Throws:

SQLException

getValue

protected <T> T getValue(int columnIndex,
 Class<T> cls,
 Calendar cal)
                  throws SQLException

Implemented over getObject(int), applies SPIConnection.basicCalendricalCoercion(java.lang.Class<T>, java.lang.Object, java.util.Calendar) to cls.

Throws:

SQLException

getObjectValue

protected Object getObjectValue(int columnIndex,
 Map typeMap)
                         throws SQLException

Implemented over getObjectValue(int), complains if typeMap is non-null.

Throws:

SQLException

getObjectValue

protected Object getObjectValue(int columnIndex)
                         throws SQLException

Implemented over getObjectValue(int,Class), passing null for the class.

To preserve back-compatible behavior in the 1.5.x branch, this is still what ends up getting called in all cases that do not explicitly use the JDBC 4.1 new getObject(int,Class).

Throws:

SQLException

getObjectValue

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

Primary method for subclass to override to retrieve a value.

The signature does not constrain this to return an object of the requested class, so it can still be used as before by methods that may do additional coercions. When called by getObject(int,Class), that caller enforces the class of the result.

Throws:

SQLException