Package rife.database

Class DbResultSet

java.lang.Object

rife.database.DbResultSet

All Implemented Interfaces:

AutoCloseable, Cloneable, ResultSet, Wrapper

public class DbResultSet
extends Object
implements ResultSet, Cloneable

Field Summary

Fields

Modifier and Type	Field	Description
protected boolean	firstRowSkew_
protected boolean	hasResultRows_
protected ResultSet	resultSet_
protected DbStatement	statement_

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
final boolean	absolute(int row)
final void	afterLast()
final void	beforeFirst()
final void	cancelRowUpdates()
final void	clearWarnings()
Object	clone()	Simply clones the instance with the default clone method.
final void	close()
final void	deleteRow()
final int	findColumn(String columnName)
final boolean	first()
final Array	getArray(int i)
final Array	getArray(String colName)
final InputStream	getAsciiStream(int columnIndex)
final InputStream	getAsciiStream(String columnName)
final BigDecimal	getBigDecimal(int columnIndex)
final BigDecimal	getBigDecimal(int columnIndex, int scale)
final BigDecimal	getBigDecimal(String columnName)
final BigDecimal	getBigDecimal(String columnName, int scale)
final InputStream	getBinaryStream(int columnIndex)
final InputStream	getBinaryStream(String columnName)
final Blob	getBlob(int i)
final Blob	getBlob(String colName)
final boolean	getBoolean(int columnIndex)
final boolean	getBoolean(String columnName)
final byte	getByte(int columnIndex)
final byte	getByte(String columnName)
final byte[]	getBytes(int columnIndex)
final byte[]	getBytes(String columnName)
final Reader	getCharacterStream(int columnIndex)
final Reader	getCharacterStream(String columnName)
final Clob	getClob(int i)
final Clob	getClob(String colName)
final int	getConcurrency()
final String	getCursorName()
final Date	getDate(int columnIndex)
final Date	getDate(int columnIndex, Calendar cal)
final Date	getDate(String columnName)
final Date	getDate(String columnName, Calendar cal)
final double	getDouble(int columnIndex)
final double	getDouble(String columnName)
final int	getFetchDirection()
final int	getFetchSize()
InputStream	getFirstAsciiStream()	Retrieves the first field of the first row of this DbResultSet object as an ascii stream.
BigDecimal	getFirstBigDecimal()	Retrieves the first field of the first row of this DbResultSet object as a big decimal.
InputStream	getFirstBinaryStream()	Retrieves the first field of the first row of this DbResultSet object as a binary stream.
boolean	getFirstBoolean()	Retrieves the first field of the first row of this DbResultSet object as a boolean.
byte	getFirstByte()	Retrieves the first field of the first row of this DbResultSet object as a byte.
byte[]	getFirstBytes()	Retrieves the first field of the first row of this DbResultSet object as an array of bytes.
Reader	getFirstCharacterStream()	Retrieves the first field of the first row of this DbResultSet object as a character stream.
Date	getFirstDate()	Retrieves the first field of the first row of this DbResultSet object as a sql date.
Date	getFirstDate(Calendar cal)	Retrieves the first field of the first row of this DbResultSet object as a sql date.
double	getFirstDouble()	Retrieves the first field of the first row of this DbResultSet object as a double.
float	getFirstFloat()	Retrieves the first field of the first row of this DbResultSet object as a float.
int	getFirstInt()	Retrieves the first field of the first row of this DbResultSet object as an integer.
long	getFirstLong()	Retrieves the first field of the first row of this DbResultSet object as a long.
short	getFirstShort()	Retrieves the first field of the first row of this DbResultSet object as a short.
String	getFirstString()	Retrieves the first field of the first row of this DbResultSet object as a string.
Time	getFirstTime()	Retrieves the first field of the first row of this DbResultSet object as a sql time.
Time	getFirstTime(Calendar cal)	Retrieves the first field of the first row of this DbResultSet object as a sql time.
Timestamp	getFirstTimestamp()	Retrieves the first field of the first row of this DbResultSet object as a sql timestamo.
Timestamp	getFirstTimestamp(Calendar cal)	Retrieves the first field of the first row of this DbResultSet object as a sql timestamp.
final float	getFloat(int columnIndex)
final float	getFloat(String columnName)
int	getHoldability()
final int	getInt(int columnIndex)
final int	getInt(String columnName)
final long	getLong(int columnIndex)
final long	getLong(String columnName)
final ResultSetMetaData	getMetaData()
Reader	getNCharacterStream(int columnIndex)
Reader	getNCharacterStream(String columnLabel)
NClob	getNClob(int columnIndex)
NClob	getNClob(String columnLabel)
String	getNString(int columnIndex)
String	getNString(String columnLabel)
final Object	getObject(int columnIndex)
final <T> T	getObject(int columnIndex, Class<T> type)
final Object	getObject(int i, Map map)
final Object	getObject(String columnName)
final <T> T	getObject(String columnLabel, Class<T> type)
final Object	getObject(String colName, Map map)
final Ref	getRef(int i)
final Ref	getRef(String colName)
final int	getRow()
RowId	getRowId(int columnIndex)
RowId	getRowId(String columnLabel)
final short	getShort(int columnIndex)
final short	getShort(String columnName)
SQLXML	getSQLXML(int columnIndex)
SQLXML	getSQLXML(String columnLabel)
final Statement	getStatement()
final String	getString(int columnIndex)
final String	getString(String columnName)
final Time	getTime(int columnIndex)
final Time	getTime(int columnIndex, Calendar cal)
final Time	getTime(String columnName)
final Time	getTime(String columnName, Calendar cal)
final Timestamp	getTimestamp(int columnIndex)
final Timestamp	getTimestamp(int columnIndex, Calendar cal)
final Timestamp	getTimestamp(String columnName)
final Timestamp	getTimestamp(String columnName, Calendar cal)
final int	getType()
final InputStream	getUnicodeStream(int columnIndex)
final InputStream	getUnicodeStream(String columnName)
final URL	getURL(int columnIndex)
final URL	getURL(String columnName)
final SQLWarning	getWarnings()
boolean	hasResultRows()	Determines if there are rows available in the ResultSet object that was returned by an execute method.
final void	insertRow()
final boolean	isAfterLast()
final boolean	isBeforeFirst()
boolean	isClosed()
final boolean	isFirst()
final boolean	isLast()
boolean	isWrapperFor(Class<?> iface)
final boolean	last()
final void	moveToCurrentRow()
final void	moveToInsertRow()
final boolean	next()
final boolean	previous()
final void	refreshRow()
final boolean	relative(int rows)
final boolean	rowDeleted()
final boolean	rowInserted()
final boolean	rowUpdated()
final void	setFetchDirection(int direction)
final void	setFetchSize(int rows)
<T> T	unwrap(Class<T> iface)
final void	updateArray(int columnIndex, Array x)
final void	updateArray(String columnName, Array x)
void	updateAsciiStream(int columnIndex, InputStream x)
final void	updateAsciiStream(int columnIndex, InputStream x, int length)
void	updateAsciiStream(int columnIndex, InputStream x, long length)
void	updateAsciiStream(String columnLabel, InputStream x)
final void	updateAsciiStream(String columnName, InputStream x, int length)
void	updateAsciiStream(String columnLabel, InputStream x, long length)
final void	updateBigDecimal(int columnIndex, BigDecimal x)
final void	updateBigDecimal(String columnName, BigDecimal x)
void	updateBinaryStream(int columnIndex, InputStream x)
final void	updateBinaryStream(int columnIndex, InputStream x, int length)
void	updateBinaryStream(int columnIndex, InputStream x, long length)
void	updateBinaryStream(String columnLabel, InputStream x)
final void	updateBinaryStream(String columnName, 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)
final void	updateBlob(int columnIndex, Blob x)
void	updateBlob(String columnLabel, InputStream inputStream)
void	updateBlob(String columnLabel, InputStream inputStream, long length)
final void	updateBlob(String columnName, Blob x)
final void	updateBoolean(int columnIndex, boolean x)
final void	updateBoolean(String columnName, boolean x)
final void	updateByte(int columnIndex, byte x)
final void	updateByte(String columnName, byte x)
final void	updateBytes(int columnIndex, byte[] x)
final void	updateBytes(String columnName, byte[] x)
void	updateCharacterStream(int columnIndex, Reader x)
final void	updateCharacterStream(int columnIndex, Reader x, int length)
void	updateCharacterStream(int columnIndex, Reader x, long length)
void	updateCharacterStream(String columnLabel, Reader reader)
final void	updateCharacterStream(String columnName, 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)
final void	updateClob(int columnIndex, Clob x)
void	updateClob(String columnLabel, Reader reader)
void	updateClob(String columnLabel, Reader reader, long length)
final void	updateClob(String columnName, Clob x)
final void	updateDate(int columnIndex, Date x)
final void	updateDate(String columnName, Date x)
final void	updateDouble(int columnIndex, double x)
final void	updateDouble(String columnName, double x)
final void	updateFloat(int columnIndex, float x)
final void	updateFloat(String columnName, float x)
final void	updateInt(int columnIndex, int x)
final void	updateInt(String columnName, int x)
final void	updateLong(int columnIndex, long x)
final void	updateLong(String columnName, 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 nClob)
void	updateNClob(String columnLabel, Reader reader)
void	updateNClob(String columnLabel, Reader reader, long length)
void	updateNClob(String columnLabel, NClob nClob)
void	updateNString(int columnIndex, String nString)
void	updateNString(String columnLabel, String nString)
final void	updateNull(int columnIndex)
final void	updateNull(String columnName)
final void	updateObject(int columnIndex, Object x)
final void	updateObject(int columnIndex, Object x, int scale)
void	updateObject(int columnIndex, Object x, SQLType targetSqlType)
void	updateObject(int columnIndex, Object x, SQLType targetSqlType, int scaleOrLength)
final void	updateObject(String columnName, Object x)
final void	updateObject(String columnName, Object x, int scale)
void	updateObject(String columnLabel, Object x, SQLType targetSqlType)
void	updateObject(String columnLabel, Object x, SQLType targetSqlType, int scaleOrLength)
final void	updateRef(int columnIndex, Ref x)
final void	updateRef(String columnName, Ref x)
final void	updateRow()
void	updateRowId(int columnIndex, RowId x)
void	updateRowId(String columnLabel, RowId x)
final void	updateShort(int columnIndex, short x)
final void	updateShort(String columnName, short x)
void	updateSQLXML(int columnIndex, SQLXML xmlObject)
void	updateSQLXML(String columnLabel, SQLXML xmlObject)
final void	updateString(int columnIndex, String x)
final void	updateString(String columnName, String x)
final void	updateTime(int columnIndex, Time x)
final void	updateTime(String columnName, Time x)
final void	updateTimestamp(int columnIndex, Timestamp x)
final void	updateTimestamp(String columnName, Timestamp x)
final boolean	wasNull()

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

statement_

protected DbStatement statement_

resultSet_

protected ResultSet resultSet_

firstRowSkew_

protected boolean firstRowSkew_

hasResultRows_

protected boolean hasResultRows_

Method Details

next

public final boolean next()
                   throws SQLException

Specified by:

next in interface ResultSet

Throws:

SQLException

previous

public final boolean previous()
                       throws SQLException

Specified by:

previous in interface ResultSet

Throws:

SQLException

absolute

public final boolean absolute(int row)
                       throws SQLException

Specified by:

absolute in interface ResultSet

Throws:

SQLException

relative

public final boolean relative(int rows)
                       throws SQLException

Specified by:

relative in interface ResultSet

Throws:

SQLException

beforeFirst

public final void beforeFirst()
                       throws SQLException

Specified by:

beforeFirst in interface ResultSet

Throws:

SQLException

first

public final boolean first()
                    throws SQLException

Specified by:

first in interface ResultSet

Throws:

SQLException

last

public final boolean last()
                   throws SQLException

Specified by:

last in interface ResultSet

Throws:

SQLException

afterLast

public final void afterLast()
                     throws SQLException

Specified by:

afterLast in interface ResultSet

Throws:

SQLException

moveToInsertRow

public final void moveToInsertRow()
                           throws SQLException

Specified by:

moveToInsertRow in interface ResultSet

Throws:

SQLException

moveToCurrentRow

public final void moveToCurrentRow()
                            throws SQLException

Specified by:

moveToCurrentRow in interface ResultSet

Throws:

SQLException

isBeforeFirst

public final boolean isBeforeFirst()
                            throws SQLException

Specified by:

isBeforeFirst in interface ResultSet

Throws:

SQLException

isFirst

public final boolean isFirst()
                      throws SQLException

Specified by:

isFirst in interface ResultSet

Throws:

SQLException

isLast

public final boolean isLast()
                     throws SQLException

Specified by:

isLast in interface ResultSet

Throws:

SQLException

isAfterLast

public final boolean isAfterLast()
                          throws SQLException

Specified by:

isAfterLast in interface ResultSet

Throws:

SQLException

getRow

public final int getRow()
                 throws SQLException

Specified by:

getRow in interface ResultSet

Throws:

SQLException

refreshRow

public final void refreshRow()
                      throws SQLException

Specified by:

refreshRow in interface ResultSet

Throws:

SQLException

insertRow

public final void insertRow()
                     throws SQLException

Specified by:

insertRow in interface ResultSet

Throws:

SQLException

updateRow

public final void updateRow()
                     throws SQLException

Specified by:

updateRow in interface ResultSet

Throws:

SQLException

deleteRow

public final void deleteRow()
                     throws SQLException

Specified by:

deleteRow in interface ResultSet

Throws:

SQLException

rowInserted

public final boolean rowInserted()
                          throws SQLException

Specified by:

rowInserted in interface ResultSet

Throws:

SQLException

rowUpdated

public final boolean rowUpdated()
                         throws SQLException

Specified by:

rowUpdated in interface ResultSet

Throws:

SQLException

rowDeleted

public final boolean rowDeleted()
                         throws SQLException

Specified by:

rowDeleted in interface ResultSet

Throws:

SQLException

close

public final void close()
                 throws SQLException

Specified by:

close in interface AutoCloseable

Specified by:

close in interface ResultSet

Throws:

SQLException

wasNull

public final boolean wasNull()
                      throws SQLException

Specified by:

wasNull in interface ResultSet

Throws:

SQLException

setFetchDirection

public final void setFetchDirection(int direction)
                             throws SQLException

Specified by:

setFetchDirection in interface ResultSet

Throws:

SQLException

setFetchSize

public final void setFetchSize(int rows)
                        throws SQLException

Specified by:

setFetchSize in interface ResultSet

Throws:

SQLException

cancelRowUpdates

public final void cancelRowUpdates()
                            throws SQLException

Specified by:

cancelRowUpdates in interface ResultSet

Throws:

SQLException

getMetaData

public final ResultSetMetaData getMetaData()
                                    throws SQLException

Specified by:

getMetaData in interface ResultSet

Throws:

SQLException

getConcurrency

public final int getConcurrency()
                         throws SQLException

Specified by:

getConcurrency in interface ResultSet

Throws:

SQLException

getFetchDirection

public final int getFetchDirection()
                            throws SQLException

Specified by:

getFetchDirection in interface ResultSet

Throws:

SQLException

getFetchSize

public final int getFetchSize()
                       throws SQLException

Specified by:

getFetchSize in interface ResultSet

Throws:

SQLException

clearWarnings

public final void clearWarnings()
                         throws SQLException

Specified by:

clearWarnings in interface ResultSet

Throws:

SQLException

getWarnings

public final SQLWarning getWarnings()
                             throws SQLException

Specified by:

getWarnings in interface ResultSet

Throws:

SQLException

getCursorName

public final String getCursorName()
                           throws SQLException

Specified by:

getCursorName in interface ResultSet

Throws:

SQLException

getStatement

public final Statement getStatement()
                             throws SQLException

Specified by:

getStatement in interface ResultSet

Throws:

SQLException

getType

public final int getType()
                  throws SQLException

Specified by:

getType in interface ResultSet

Throws:

SQLException

findColumn

public final int findColumn(String columnName)
                     throws SQLException

Specified by:

findColumn in interface ResultSet

Throws:

SQLException

hasResultRows

public boolean hasResultRows()
                      throws DatabaseException

Determines if there are rows available in the ResultSet object that was returned by an execute method.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

true if there are result rows available; or

false if no ResultSet object was available or it didn't have any result rows.

Throws:

DatabaseException - if a database access error occurs

Since:

1.0

getFirstString

public String getFirstString()
                      throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a string. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first String object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstBoolean

public boolean getFirstBoolean()
                        throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a boolean. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first boolean object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstByte

public byte getFirstByte()
                  throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a byte. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first byte object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstShort

public short getFirstShort()
                    throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a short. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first short object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstInt

public int getFirstInt()
                throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as an integer. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first int object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstLong

public long getFirstLong()
                  throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a long. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first long object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstFloat

public float getFirstFloat()
                    throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a float. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first float object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstDouble

public double getFirstDouble()
                      throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a double. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first String object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstBigDecimal

public BigDecimal getFirstBigDecimal()
                              throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a big decimal. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first BigDecimal object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstBytes

public byte[] getFirstBytes()
                     throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as an array of bytes. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first byte[] object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstDate

public Date getFirstDate()
                  throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a sql date. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first java.sql.Date object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstDate

public Date getFirstDate(Calendar cal)
                  throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a sql date. This method uses the given calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Parameters:

cal - the java.util.Calendar object to use in constructing the date

Returns:

the first java.sql.Date object in the resultsn; if the value is SQL NULL, the value returned is null in the Java programming language

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

getFirstTime

public Time getFirstTime()
                  throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a sql time. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first java.sql.Time object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstTime

public Time getFirstTime(Calendar cal)
                  throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a sql time. This method works both when the next method has never been called or once been called. This method uses the given calendar to construct an appropriate millisecond value for the time if the underlying database does not store timezone information. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Parameters:

cal - the java.util.Calendar object to use in constructing the time

Returns:

the first java.sql.Time object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstTimestamp

public Timestamp getFirstTimestamp()
                            throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a sql timestamo. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first java.sql.Timestamp object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstTimestamp

public Timestamp getFirstTimestamp(Calendar cal)
                            throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a sql timestamp. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information. This method works both when the next method has never been called or once been called.

It is perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Parameters:

cal - the java.util.Calendar object to use in constructing the date

Returns:

the first java.sql.Timestamp object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstAsciiStream

public InputStream getFirstAsciiStream()
                                throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as an ascii stream. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first java.io.InputStream object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstCharacterStream

public Reader getFirstCharacterStream()
                               throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a character stream. This method works both when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first java.io.Reader object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getFirstBinaryStream

public InputStream getFirstBinaryStream()
                                 throws DatabaseException

Retrieves the first field of the first row of this DbResultSet object as a binary stream. This method works hiboth when the next method has never been called or once been called.

Therefore, it's thus perfectly usable after the hasResultRows method or alone where catching the MissingResultsException is used to indicate the absence of results.

If an exception is thrown, the related DbStatement is automatically closed and an ongoing transaction will be automatically rolled back if it belongs to the executing thread.

Returns:

the first java.io.InputStream object in the results.

Throws:

DatabaseException - if a database access error occurs. If there are no results available the thrown exception is MissingResultsException.

Since:

1.0

See Also:

• hasResultRows()

getString

public final String getString(int columnIndex)
                       throws SQLException

Specified by:

getString in interface ResultSet

Throws:

SQLException

getString

public final String getString(String columnName)
                       throws SQLException

Specified by:

getString in interface ResultSet

Throws:

SQLException

getBoolean

public final boolean getBoolean(int columnIndex)
                         throws SQLException

Specified by:

getBoolean in interface ResultSet

Throws:

SQLException

getBoolean

public final boolean getBoolean(String columnName)
                         throws SQLException

Specified by:

getBoolean in interface ResultSet

Throws:

SQLException

getByte

public final byte getByte(int columnIndex)
                   throws SQLException

Specified by:

getByte in interface ResultSet

Throws:

SQLException

getByte

public final byte getByte(String columnName)
                   throws SQLException

Specified by:

getByte in interface ResultSet

Throws:

SQLException

getShort

public final short getShort(int columnIndex)
                     throws SQLException

Specified by:

getShort in interface ResultSet

Throws:

SQLException

getShort

public final short getShort(String columnName)
                     throws SQLException

Specified by:

getShort in interface ResultSet

Throws:

SQLException

getInt

public final int getInt(int columnIndex)
                 throws SQLException

Specified by:

getInt in interface ResultSet

Throws:

SQLException

getInt

public final int getInt(String columnName)
                 throws SQLException

Specified by:

getInt in interface ResultSet

Throws:

SQLException

getLong

public final long getLong(int columnIndex)
                   throws SQLException

Specified by:

getLong in interface ResultSet

Throws:

SQLException

getLong

public final long getLong(String columnName)
                   throws SQLException

Specified by:

getLong in interface ResultSet

Throws:

SQLException

getFloat

public final float getFloat(int columnIndex)
                     throws SQLException

Specified by:

getFloat in interface ResultSet

Throws:

SQLException

getFloat

public final float getFloat(String columnName)
                     throws SQLException

Specified by:

getFloat in interface ResultSet

Throws:

SQLException

getDouble

public final double getDouble(int columnIndex)
                       throws SQLException

Specified by:

getDouble in interface ResultSet

Throws:

SQLException

getDouble

public final double getDouble(String columnName)
                       throws SQLException

Specified by:

getDouble in interface ResultSet

Throws:

SQLException

getBigDecimal

public final BigDecimal getBigDecimal(int columnIndex)
                               throws SQLException

Specified by:

getBigDecimal in interface ResultSet

Throws:

SQLException

getBigDecimal

public final BigDecimal getBigDecimal(String columnName)
                               throws SQLException

Specified by:

getBigDecimal in interface ResultSet

Throws:

SQLException

getBigDecimal

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

Specified by:

getBigDecimal in interface ResultSet

Throws:

SQLException

getBigDecimal

public final BigDecimal getBigDecimal(String columnName,
 int scale)
                               throws SQLException

Specified by:

getBigDecimal in interface ResultSet

Throws:

SQLException

getBytes

public final byte[] getBytes(int columnIndex)
                      throws SQLException

Specified by:

getBytes in interface ResultSet

Throws:

SQLException

getBytes

public final byte[] getBytes(String columnName)
                      throws SQLException

Specified by:

getBytes in interface ResultSet

Throws:

SQLException

getDate

public final Date getDate(int columnIndex)
                   throws SQLException

Specified by:

getDate in interface ResultSet

Throws:

SQLException

getDate

public final Date getDate(String columnName)
                   throws SQLException

Specified by:

getDate in interface ResultSet

Throws:

SQLException

getDate

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

Specified by:

getDate in interface ResultSet

Throws:

SQLException

getDate

public final Date getDate(String columnName,
 Calendar cal)
                   throws SQLException

Specified by:

getDate in interface ResultSet

Throws:

SQLException

getTime

public final Time getTime(int columnIndex)
                   throws SQLException

Specified by:

getTime in interface ResultSet

Throws:

SQLException

getTime

public final Time getTime(String columnName)
                   throws SQLException

Specified by:

getTime in interface ResultSet

Throws:

SQLException

getTime

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

Specified by:

getTime in interface ResultSet

Throws:

SQLException

getTime

public final Time getTime(String columnName,
 Calendar cal)
                   throws SQLException

Specified by:

getTime in interface ResultSet

Throws:

SQLException

getTimestamp

public final Timestamp getTimestamp(int columnIndex)
                             throws SQLException

Specified by:

getTimestamp in interface ResultSet

Throws:

SQLException

getTimestamp

public final Timestamp getTimestamp(String columnName)
                             throws SQLException

Specified by:

getTimestamp in interface ResultSet

Throws:

SQLException

getTimestamp

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

Specified by:

getTimestamp in interface ResultSet

Throws:

SQLException

getTimestamp

public final Timestamp getTimestamp(String columnName,
 Calendar cal)
                             throws SQLException

Specified by:

getTimestamp in interface ResultSet

Throws:

SQLException

getAsciiStream

public final InputStream getAsciiStream(int columnIndex)
                                 throws SQLException

Specified by:

getAsciiStream in interface ResultSet

Throws:

SQLException

getAsciiStream

public final InputStream getAsciiStream(String columnName)
                                 throws SQLException

Specified by:

getAsciiStream in interface ResultSet

Throws:

SQLException

getUnicodeStream

public final InputStream getUnicodeStream(int columnIndex)
                                   throws SQLException

Specified by:

getUnicodeStream in interface ResultSet

Throws:

SQLException

getUnicodeStream

public final InputStream getUnicodeStream(String columnName)
                                   throws SQLException

Specified by:

getUnicodeStream in interface ResultSet

Throws:

SQLException

getCharacterStream

public final Reader getCharacterStream(int columnIndex)
                                throws SQLException

Specified by:

getCharacterStream in interface ResultSet

Throws:

SQLException

getCharacterStream

public final Reader getCharacterStream(String columnName)
                                throws SQLException

Specified by:

getCharacterStream in interface ResultSet

Throws:

SQLException

getBinaryStream

public final InputStream getBinaryStream(int columnIndex)
                                  throws SQLException

Specified by:

getBinaryStream in interface ResultSet

Throws:

SQLException

getBinaryStream

public final InputStream getBinaryStream(String columnName)
                                  throws SQLException

Specified by:

getBinaryStream in interface ResultSet

Throws:

SQLException

getRef

public final Ref getRef(String colName)
                 throws SQLException

Specified by:

getRef in interface ResultSet

Throws:

SQLException

getRef

public final Ref getRef(int i)
                 throws SQLException

Specified by:

getRef in interface ResultSet

Throws:

SQLException

getObject

public final Object getObject(int columnIndex)
                       throws SQLException

Specified by:

getObject in interface ResultSet

Throws:

SQLException

getObject

public final Object getObject(String columnName)
                       throws SQLException

Specified by:

getObject in interface ResultSet

Throws:

SQLException

getObject

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

Specified by:

getObject in interface ResultSet

Throws:

SQLException

getObject

public final Object getObject(String colName,
 Map map)
                       throws SQLException

Specified by:

getObject in interface ResultSet

Throws:

SQLException

getObject

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

Specified by:

getObject in interface ResultSet

Throws:

SQLException

getObject

public final <T> T getObject(String columnLabel,
 Class<T> type)
                      throws SQLException

Specified by:

getObject in interface ResultSet

Throws:

SQLException

getBlob

public final Blob getBlob(int i)
                   throws SQLException

Specified by:

getBlob in interface ResultSet

Throws:

SQLException

getBlob

public final Blob getBlob(String colName)
                   throws SQLException

Specified by:

getBlob in interface ResultSet

Throws:

SQLException

getClob

public final Clob getClob(int i)
                   throws SQLException

Specified by:

getClob in interface ResultSet

Throws:

SQLException

getClob

public final Clob getClob(String colName)
                   throws SQLException

Specified by:

getClob in interface ResultSet

Throws:

SQLException

getArray

public final Array getArray(String colName)
                     throws SQLException

Specified by:

getArray in interface ResultSet

Throws:

SQLException

getArray

public final Array getArray(int i)
                     throws SQLException

Specified by:

getArray in interface ResultSet

Throws:

SQLException

getURL

public final URL getURL(int columnIndex)
                 throws SQLException

Specified by:

getURL in interface ResultSet

Throws:

SQLException

getURL

public final URL getURL(String columnName)
                 throws SQLException

Specified by:

getURL in interface ResultSet

Throws:

SQLException

updateNull

public final void updateNull(int columnIndex)
                      throws SQLException

Specified by:

updateNull in interface ResultSet

Throws:

SQLException

updateNull

public final void updateNull(String columnName)
                      throws SQLException

Specified by:

updateNull in interface ResultSet

Throws:

SQLException

updateString

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

Specified by:

updateString in interface ResultSet

Throws:

SQLException

updateString

public final void updateString(String columnName,
 String x)
                        throws SQLException

Specified by:

updateString in interface ResultSet

Throws:

SQLException

updateBoolean

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

Specified by:

updateBoolean in interface ResultSet

Throws:

SQLException

updateBoolean

public final void updateBoolean(String columnName,
 boolean x)
                         throws SQLException

Specified by:

updateBoolean in interface ResultSet

Throws:

SQLException

updateByte

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

Specified by:

updateByte in interface ResultSet

Throws:

SQLException

updateByte

public final void updateByte(String columnName,
 byte x)
                      throws SQLException

Specified by:

updateByte in interface ResultSet

Throws:

SQLException

updateShort

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

Specified by:

updateShort in interface ResultSet

Throws:

SQLException

updateShort

public final void updateShort(String columnName,
 short x)
                       throws SQLException

Specified by:

updateShort in interface ResultSet

Throws:

SQLException

updateInt

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

Specified by:

updateInt in interface ResultSet

Throws:

SQLException

updateInt

public final void updateInt(String columnName,
 int x)
                     throws SQLException

Specified by:

updateInt in interface ResultSet

Throws:

SQLException

updateLong

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

Specified by:

updateLong in interface ResultSet

Throws:

SQLException

updateLong

public final void updateLong(String columnName,
 long x)
                      throws SQLException

Specified by:

updateLong in interface ResultSet

Throws:

SQLException

updateFloat

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

Specified by:

updateFloat in interface ResultSet

Throws:

SQLException

updateFloat

public final void updateFloat(String columnName,
 float x)
                       throws SQLException

Specified by:

updateFloat in interface ResultSet

Throws:

SQLException

updateDouble

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

Specified by:

updateDouble in interface ResultSet

Throws:

SQLException

updateDouble

public final void updateDouble(String columnName,
 double x)
                        throws SQLException

Specified by:

updateDouble in interface ResultSet

Throws:

SQLException

updateBigDecimal

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

Specified by:

updateBigDecimal in interface ResultSet

Throws:

SQLException

updateBigDecimal

public final void updateBigDecimal(String columnName,
 BigDecimal x)
                            throws SQLException

Specified by:

updateBigDecimal in interface ResultSet

Throws:

SQLException

updateBytes

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

Specified by:

updateBytes in interface ResultSet

Throws:

SQLException

updateBytes

public final void updateBytes(String columnName,
 byte[] x)
                       throws SQLException

Specified by:

updateBytes in interface ResultSet

Throws:

SQLException

updateDate

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

Specified by:

updateDate in interface ResultSet

Throws:

SQLException

updateDate

public final void updateDate(String columnName,
 Date x)
                      throws SQLException

Specified by:

updateDate in interface ResultSet

Throws:

SQLException

updateTime

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

Specified by:

updateTime in interface ResultSet

Throws:

SQLException

updateTime

public final void updateTime(String columnName,
 Time x)
                      throws SQLException

Specified by:

updateTime in interface ResultSet

Throws:

SQLException

updateTimestamp

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

Specified by:

updateTimestamp in interface ResultSet

Throws:

SQLException

updateTimestamp

public final void updateTimestamp(String columnName,
 Timestamp x)
                           throws SQLException

Specified by:

updateTimestamp in interface ResultSet

Throws:

SQLException

updateAsciiStream

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

Specified by:

updateAsciiStream in interface ResultSet

Throws:

SQLException

updateAsciiStream

public final void updateAsciiStream(String columnName,
 InputStream x,
 int length)
                             throws SQLException

Specified by:

updateAsciiStream in interface ResultSet

Throws:

SQLException

updateCharacterStream

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

Specified by:

updateCharacterStream in interface ResultSet

Throws:

SQLException

updateCharacterStream

public final void updateCharacterStream(String columnName,
 Reader reader,
 int length)
                                 throws SQLException

Specified by:

updateCharacterStream in interface ResultSet

Throws:

SQLException

updateBinaryStream

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

Specified by:

updateBinaryStream in interface ResultSet

Throws:

SQLException

updateBinaryStream

public final void updateBinaryStream(String columnName,
 InputStream x,
 int length)
                              throws SQLException

Specified by:

updateBinaryStream in interface ResultSet

Throws:

SQLException

updateRef

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

Specified by:

updateRef in interface ResultSet

Throws:

SQLException

updateRef

public final void updateRef(String columnName,
 Ref x)
                     throws SQLException

Specified by:

updateRef in interface ResultSet

Throws:

SQLException

updateObject

public final void updateObject(int columnIndex,
 Object x)
                        throws SQLException

Specified by:

updateObject in interface ResultSet

Throws:

SQLException

updateObject

public final void updateObject(String columnName,
 Object x)
                        throws SQLException

Specified by:

updateObject in interface ResultSet

Throws:

SQLException

updateObject

public final void updateObject(int columnIndex,
 Object x,
 int scale)
                        throws SQLException

Specified by:

updateObject in interface ResultSet

Throws:

SQLException

updateObject

public final void updateObject(String columnName,
 Object x,
 int scale)
                        throws SQLException

Specified by:

updateObject in interface ResultSet

Throws:

SQLException

updateObject

public void updateObject(int columnIndex,
 Object x,
 SQLType targetSqlType,
 int scaleOrLength)
                  throws SQLException

Specified by:

updateObject in interface ResultSet

Throws:

SQLException

updateObject

public void updateObject(String columnLabel,
 Object x,
 SQLType targetSqlType,
 int scaleOrLength)
                  throws SQLException

Specified by:

updateObject in interface ResultSet

Throws:

SQLException

updateObject

public void updateObject(int columnIndex,
 Object x,
 SQLType targetSqlType)
                  throws SQLException

Specified by:

updateObject in interface ResultSet

Throws:

SQLException

updateObject

public void updateObject(String columnLabel,
 Object x,
 SQLType targetSqlType)
                  throws SQLException

Specified by:

updateObject in interface ResultSet

Throws:

SQLException

updateBlob

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

Specified by:

updateBlob in interface ResultSet

Throws:

SQLException

updateBlob

public final void updateBlob(String columnName,
 Blob x)
                      throws SQLException

Specified by:

updateBlob in interface ResultSet

Throws:

SQLException

updateClob

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

Specified by:

updateClob in interface ResultSet

Throws:

SQLException

updateClob

public final void updateClob(String columnName,
 Clob x)
                      throws SQLException

Specified by:

updateClob in interface ResultSet

Throws:

SQLException

updateArray

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

Specified by:

updateArray in interface ResultSet

Throws:

SQLException

updateArray

public final void updateArray(String columnName,
 Array x)
                       throws SQLException

Specified by:

updateArray in interface ResultSet

Throws:

SQLException

getRowId

public RowId getRowId(int columnIndex)
               throws SQLException

Specified by:

getRowId in interface ResultSet

Throws:

SQLException

getRowId

public RowId getRowId(String columnLabel)
               throws SQLException

Specified by:

getRowId in interface ResultSet

Throws:

SQLException

updateRowId

public void updateRowId(int columnIndex,
 RowId x)
                 throws SQLException

Specified by:

updateRowId in interface ResultSet

Throws:

SQLException

updateRowId

public void updateRowId(String columnLabel,
 RowId x)
                 throws SQLException

Specified by:

updateRowId in interface ResultSet

Throws:

SQLException

getHoldability

public int getHoldability()
                   throws SQLException

Specified by:

getHoldability in interface ResultSet

Throws:

SQLException

isClosed

public boolean isClosed()
                 throws SQLException

Specified by:

isClosed in interface ResultSet

Throws:

SQLException

updateNString

public void updateNString(int columnIndex,
 String nString)
                   throws SQLException

Specified by:

updateNString in interface ResultSet

Throws:

SQLException

updateNString

public void updateNString(String columnLabel,
 String nString)
                   throws SQLException

Specified by:

updateNString in interface ResultSet

Throws:

SQLException

updateNClob

public void updateNClob(int columnIndex,
 NClob nClob)
                 throws SQLException

Specified by:

updateNClob in interface ResultSet

Throws:

SQLException

updateNClob

public void updateNClob(String columnLabel,
 NClob nClob)
                 throws SQLException

Specified by:

updateNClob in interface ResultSet

Throws:

SQLException

getNClob

public NClob getNClob(int columnIndex)
               throws SQLException

Specified by:

getNClob in interface ResultSet

Throws:

SQLException

getNClob

public NClob getNClob(String columnLabel)
               throws SQLException

Specified by:

getNClob in interface ResultSet

Throws:

SQLException

getSQLXML

public SQLXML getSQLXML(int columnIndex)
                 throws SQLException

Specified by:

getSQLXML in interface ResultSet

Throws:

SQLException

getSQLXML

public SQLXML getSQLXML(String columnLabel)
                 throws SQLException

Specified by:

getSQLXML in interface ResultSet

Throws:

SQLException

updateSQLXML

public void updateSQLXML(int columnIndex,
 SQLXML xmlObject)
                  throws SQLException

Specified by:

updateSQLXML in interface ResultSet

Throws:

SQLException

updateSQLXML

public void updateSQLXML(String columnLabel,
 SQLXML xmlObject)
                  throws SQLException

Specified by:

updateSQLXML in interface ResultSet

Throws:

SQLException

getNString

public String getNString(int columnIndex)
                  throws SQLException

Specified by:

getNString in interface ResultSet

Throws:

SQLException

getNString

public String getNString(String columnLabel)
                  throws SQLException

Specified by:

getNString in interface ResultSet

Throws:

SQLException

getNCharacterStream

public Reader getNCharacterStream(int columnIndex)
                           throws SQLException

Specified by:

getNCharacterStream in interface ResultSet

Throws:

SQLException

getNCharacterStream

public Reader getNCharacterStream(String columnLabel)
                           throws SQLException

Specified by:

getNCharacterStream in interface ResultSet

Throws:

SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex,
 Reader x)
                            throws SQLException

Specified by:

updateNCharacterStream in interface ResultSet

Throws:

SQLException

updateNCharacterStream

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

Specified by:

updateNCharacterStream in interface ResultSet

Throws:

SQLException

updateNCharacterStream

public void updateNCharacterStream(String columnLabel,
 Reader reader)
                            throws SQLException

Specified by:

updateNCharacterStream in interface ResultSet

Throws:

SQLException

updateNCharacterStream

public void updateNCharacterStream(String columnLabel,
 Reader reader,
 long length)
                            throws SQLException

Specified by:

updateNCharacterStream in interface ResultSet

Throws:

SQLException

updateAsciiStream

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

Specified by:

updateAsciiStream in interface ResultSet

Throws:

SQLException

updateAsciiStream

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

Specified by:

updateAsciiStream in interface ResultSet

Throws:

SQLException

updateBinaryStream

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

Specified by:

updateBinaryStream in interface ResultSet

Throws:

SQLException

updateBinaryStream

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

Specified by:

updateBinaryStream in interface ResultSet

Throws:

SQLException

updateCharacterStream

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

Specified by:

updateCharacterStream in interface ResultSet

Throws:

SQLException

updateCharacterStream

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

Specified by:

updateCharacterStream in interface ResultSet

Throws:

SQLException

updateAsciiStream

public void updateAsciiStream(String columnLabel,
 InputStream x)
                       throws SQLException

Specified by:

updateAsciiStream in interface ResultSet

Throws:

SQLException

updateAsciiStream

public void updateAsciiStream(String columnLabel,
 InputStream x,
 long length)
                       throws SQLException

Specified by:

updateAsciiStream in interface ResultSet

Throws:

SQLException

updateBinaryStream

public void updateBinaryStream(String columnLabel,
 InputStream x)
                        throws SQLException

Specified by:

updateBinaryStream in interface ResultSet

Throws:

SQLException

updateBinaryStream

public void updateBinaryStream(String columnLabel,
 InputStream x,
 long length)
                        throws SQLException

Specified by:

updateBinaryStream in interface ResultSet

Throws:

SQLException

updateCharacterStream

public void updateCharacterStream(String columnLabel,
 Reader reader)
                           throws SQLException

Specified by:

updateCharacterStream in interface ResultSet

Throws:

SQLException

updateCharacterStream

public void updateCharacterStream(String columnLabel,
 Reader reader,
 long length)
                           throws SQLException

Specified by:

updateCharacterStream in interface ResultSet

Throws:

SQLException

updateBlob

public void updateBlob(int columnIndex,
 InputStream inputStream)
                throws SQLException

Specified by:

updateBlob in interface ResultSet

Throws:

SQLException

updateBlob

public void updateBlob(String columnLabel,
 InputStream inputStream)
                throws SQLException

Specified by:

updateBlob in interface ResultSet

Throws:

SQLException

updateBlob

public void updateBlob(int columnIndex,
 InputStream inputStream,
 long length)
                throws SQLException

Specified by:

updateBlob in interface ResultSet

Throws:

SQLException

updateBlob

public void updateBlob(String columnLabel,
 InputStream inputStream,
 long length)
                throws SQLException

Specified by:

updateBlob in interface ResultSet

Throws:

SQLException

updateClob

public void updateClob(int columnIndex,
 Reader reader)
                throws SQLException

Specified by:

updateClob in interface ResultSet

Throws:

SQLException

updateClob

public void updateClob(String columnLabel,
 Reader reader)
                throws SQLException

Specified by:

updateClob in interface ResultSet

Throws:

SQLException

updateClob

public void updateClob(int columnIndex,
 Reader reader,
 long length)
                throws SQLException

Specified by:

updateClob in interface ResultSet

Throws:

SQLException

updateClob

public void updateClob(String columnLabel,
 Reader reader,
 long length)
                throws SQLException

Specified by:

updateClob in interface ResultSet

Throws:

SQLException

updateNClob

public void updateNClob(String columnLabel,
 Reader reader)
                 throws SQLException

Specified by:

updateNClob in interface ResultSet

Throws:

SQLException

updateNClob

public void updateNClob(int columnIndex,
 Reader reader)
                 throws SQLException

Specified by:

updateNClob in interface ResultSet

Throws:

SQLException

updateNClob

public void updateNClob(int columnIndex,
 Reader reader,
 long length)
                 throws SQLException

Specified by:

updateNClob in interface ResultSet

Throws:

SQLException

updateNClob

public void updateNClob(String columnLabel,
 Reader reader,
 long length)
                 throws SQLException

Specified by:

updateNClob in interface ResultSet

Throws:

SQLException

unwrap

public <T> T unwrap(Class<T> iface)
             throws SQLException

Specified by:

unwrap in interface Wrapper

Throws:

SQLException

isWrapperFor

public boolean isWrapperFor(Class<?> iface)
                     throws SQLException

Specified by:

isWrapperFor in interface Wrapper

Throws:

SQLException

clone

public Object clone()

Simply clones the instance with the default clone method. This creates a shallow copy of all fields and the clone will in fact just be another reference to the same underlying data. The independence of each cloned instance is consciously not respected since they rely on resources that can't be cloned.

Overrides:

clone in class Object

Since:

1.0