com.mirth.connect.server.userutil

Class MirthCachedRowSet

java.lang.Object

javax.sql.rowset.BaseRowSet

com.sun.rowset.CachedRowSetImpl

com.mirth.connect.server.userutil.MirthCachedRowSet

All Implemented Interfaces:

Serializable, AutoCloseable, Cloneable, ResultSet, Wrapper, RowSet, CachedRowSet, Joinable, RowSetInternal

public class MirthCachedRowSet
extends com.sun.rowset.CachedRowSetImpl

An implementation of CachedRowSet that retrieves values based on the column label value. CachedRowSetImpl uses the column name which ignores alias for drivers that correctly follow the JDBC 4.0 recommendations. Using the column label ensures that aliases will work for these drivers.

See Also:

Serialized Form

Field Summary

Fields inherited from class com.sun.rowset.CachedRowSetImpl

resBundle

Fields inherited from class javax.sql.rowset.BaseRowSet

ASCII_STREAM_PARAM, asciiStream, BINARY_STREAM_PARAM, binaryStream, charStream, UNICODE_STREAM_PARAM, unicodeStream

Fields inherited from interface javax.sql.rowset.CachedRowSet

COMMIT_ON_ACCEPT_CHANGES

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 and Description
MirthCachedRowSet()
MirthCachedRowSet(Hashtable env)

Method Summary

Modifier and Type	Method and Description
boolean	columnUpdated(String columnName) Indicates whether the designated column in the current row of this CachedRowSet object has been updated.
int	findColumn(String columnName) Maps the given ResultSet column label to its ResultSet column index.
Array	getArray(String colName) Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.
InputStream	getAsciiStream(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.
BigDecimal	getBigDecimal(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.
BigDecimal	getBigDecimal(String columnName, int scale) Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal in the Java programming language.
InputStream	getBinaryStream(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.
Blob	getBlob(String colName) Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
boolean	getBoolean(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
byte	getByte(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
byte[]	getBytes(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
Reader	getCharacterStream(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
Clob	getClob(String colName) Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.
Date	getDate(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
Date	getDate(String columnName, Calendar cal) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
double	getDouble(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
float	getFloat(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
int	getInt(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
long	getLong(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
Object	getObject(String columnName) Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
Object	getObject(String columnName, Map<String,Class<?>> map) Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
Ref	getRef(String colName) Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.
short	getShort(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
String	getString(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
Time	getTime(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
Time	getTime(String columnName, Calendar cal) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
Timestamp	getTimestamp(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
Timestamp	getTimestamp(String columnName, Calendar cal) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
InputStream	getUnicodeStream(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a stream of two-byte Unicode characters.
URL	getURL(String columnName) Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.
Collection<?>	toCollection(String column) Converts the designated column in this CachedRowSet object to a Collection object.
void	updateArray(String columnName, Array a) Updates the designated column with a java.sql.Array value.
void	updateAsciiStream(String columnName, InputStream x, int length) Updates the designated column with an ascii stream value, which will have the specified number of bytes.
void	updateBigDecimal(String columnName, BigDecimal x) Updates the designated column with a java.sql.BigDecimal value.
void	updateBinaryStream(String columnName, InputStream x, int length) Updates the designated column with a binary stream value, which will have the specified number of bytes.
void	updateBlob(String columnName, Blob b) Updates the designated column with a java.sql.Blob value.
void	updateBoolean(String columnName, boolean x) Updates the designated column with a boolean value.
void	updateByte(String columnName, byte x) Updates the designated column with a byte value.
void	updateBytes(String columnName, byte[] x) Updates the designated column with a byte array value.
void	updateCharacterStream(String columnName, Reader reader, int length) Updates the designated column with a character stream value, which will have the specified number of bytes.
void	updateClob(String columnName, Clob c) Updates the designated column with a java.sql.Clob value.
void	updateDate(String columnName, Date x) Updates the designated column with a java.sql.Date value.
void	updateDouble(String columnName, double x) Updates the designated column with a double value.
void	updateFloat(String columnName, float x) Updates the designated column with a float value.
void	updateInt(String columnName, int x) Updates the designated column with an int value.
void	updateLong(String columnName, long x) Updates the designated column with a long value.
void	updateNull(String columnName) Updates the designated column with a null value.
void	updateObject(String columnName, Object x) Updates the designated column with an Object value.
void	updateObject(String columnName, Object x, int scale) Updates the designated column with an Object value.
void	updateRef(String columnName, Ref ref) Updates the designated column with a java.sql.Ref value.
void	updateShort(String columnName, short x) Updates the designated column with a short value.
void	updateString(String columnName, String x) Updates the designated column with a String value.
void	updateTime(String columnName, Time x) Updates the designated column with a java.sql.Time value.
void	updateTimestamp(String columnName, Timestamp x) Updates the designated column with a java.sql.Timestamp value.

Methods inherited from class com.sun.rowset.CachedRowSetImpl

absolute, acceptChanges, acceptChanges, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, clone, close, columnUpdated, commit, createCopy, createCopyNoConstraints, createCopySchema, createShared, deleteRow, execute, execute, first, getArray, getAsciiStream, getBigDecimal, getBigDecimal, getBinaryStream, getBlob, getBoolean, getByte, getBytes, getCharacterStream, getClob, getConnection, getCurrentRow, getCursorName, getDate, getDate, getDouble, getFloat, getHoldability, getInt, getKeyColumns, getLong, getMatchColumnIndexes, getMatchColumnNames, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getOriginal, getOriginalRow, getPageSize, getRef, getRow, getRowId, getRowId, getRowSetWarnings, getShort, getSQLXML, getSQLXML, getStatement, getString, getSyncProvider, getTableName, getTime, getTime, getTimestamp, getTimestamp, getUnicodeStream, getURL, getWarnings, insertRow, internalFirst, internalLast, internalNext, internalPrevious, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, isWrapperFor, last, moveToCurrentRow, moveToInsertRow, next, nextPage, populate, populate, previous, previousPage, refreshRow, relative, release, removeCurrentRow, restoreOriginal, rollback, rollback, rowDeleted, rowInserted, rowSetPopulated, rowUpdated, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setClob, setClob, setCommand, setDate, setDate, setDouble, setFloat, setInt, setKeyColumns, setLong, setMatchColumn, setMatchColumn, setMatchColumn, setMatchColumn, setMetaData, setNCharacterStream, setNCharacterStream, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNClob, setNClob, setNClob, setNString, setNString, setNull, setNull, setObject, setObject, setObject, setOriginal, setOriginalRow, setPageSize, setRowId, setRowId, setRowInserted, setShort, setSQLXML, setSQLXML, setString, setSyncProvider, setTableName, setTime, setTime, setTimestamp, setTimestamp, setURL, size, toCollection, toCollection, undoDelete, undoInsert, undoUpdate, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn, 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, updateRow, updateRowId, updateRowId, updateShort, updateSQLXML, updateSQLXML, updateString, updateTime, updateTimestamp, wasNull

Methods inherited from class javax.sql.rowset.BaseRowSet

addRowSetListener, clearParameters, getCommand, getConcurrency, getDataSourceName, getEscapeProcessing, getFetchDirection, getFetchSize, getMaxFieldSize, getMaxRows, getParams, getPassword, getQueryTimeout, getShowDeleted, getTransactionIsolation, getType, getTypeMap, getUrl, getUsername, initParams, isReadOnly, notifyCursorMoved, notifyRowChanged, notifyRowSetChanged, removeRowSetListener, setArray, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setClob, setConcurrency, setDataSourceName, setDate, setDate, setDouble, setEscapeProcessing, setFetchDirection, setFetchSize, setFloat, setInt, setLong, setMaxFieldSize, setMaxRows, setNull, setNull, setObject, setObject, setObject, setPassword, setQueryTimeout, setReadOnly, setRef, setShort, setShowDeleted, setString, setTime, setTime, setTimestamp, setTimestamp, setTransactionIsolation, setType, setTypeMap, setUnicodeStream, setUrl, setUsername

Methods inherited from class java.lang.Object

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

Methods inherited from interface javax.sql.RowSetInternal

getParams

Methods inherited from interface javax.sql.rowset.CachedRowSet

getShowDeleted, setShowDeleted

Methods inherited from interface javax.sql.RowSet

addRowSetListener, clearParameters, getCommand, getDataSourceName, getEscapeProcessing, getMaxFieldSize, getMaxRows, getPassword, getQueryTimeout, getTransactionIsolation, getTypeMap, getUrl, getUsername, isReadOnly, removeRowSetListener, setArray, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setClob, setConcurrency, setDataSourceName, setDate, setDate, setDouble, setEscapeProcessing, setFloat, setInt, setLong, setMaxFieldSize, setMaxRows, setNull, setNull, setObject, setObject, setObject, setPassword, setQueryTimeout, setReadOnly, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setTransactionIsolation, setType, setTypeMap, setUrl, setUsername

Methods inherited from interface java.sql.ResultSet

getConcurrency, getFetchDirection, getFetchSize, getType, setFetchDirection, setFetchSize, updateObject, updateObject, updateObject, updateObject

Constructor Detail

MirthCachedRowSet

public MirthCachedRowSet()
                  throws SQLException

Throws:

SQLException

MirthCachedRowSet

public MirthCachedRowSet(Hashtable env)
                  throws SQLException

Throws:

SQLException

Method Detail

toCollection

public Collection<?> toCollection(String column)
                           throws SQLException

Description copied from interface: javax.sql.rowset.CachedRowSet

Converts the designated column in this CachedRowSet object to a Collection object. Implementations have some latitude in how they can represent this Collection object because of the abstract nature of the Collection framework. Each column value should be fully represented in either a general purpose Collection implementation or a specialized Collection implementation, such as a Vector object. An SQL NULL column value must be represented as a null in the Java programming language.

The standard reference implementation uses a Vector object to contain the column values, and it is expected that most implementations will do the same. If a Vector object is used, it size must be exactly equal to the number of rows in this CachedRowSet object.

Specified by:

toCollection in interface CachedRowSet

Overrides:

toCollection in class com.sun.rowset.CachedRowSetImpl

Parameters:

column - a String object giving the name of the column whose values are to be represented in a collection

Returns:

a Collection object that contains the values stored in the specified column of this CachedRowSet object

Throws:

SQLException - if an error occurs generating the collection or an invalid column id is provided

See Also:

CachedRowSet.toCollection(), CachedRowSet.toCollection(int)

getString

public String getString(String columnName)
                 throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

Specified by:

getString in interface ResultSet

Overrides:

getString in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is null

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getBoolean

public boolean getBoolean(String columnName)
                   throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

If the designated column has a datatype of CHAR or VARCHAR and contains a "0" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT and contains a 0, a value of false is returned. If the designated column has a datatype of CHAR or VARCHAR and contains a "1" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT and contains a 1, a value of true is returned.

Specified by:

getBoolean in interface ResultSet

Overrides:

getBoolean in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is false

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getByte

public byte getByte(String columnName)
             throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

Specified by:

getByte in interface ResultSet

Overrides:

getByte in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is 0

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getShort

public short getShort(String columnName)
               throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

Specified by:

getShort in interface ResultSet

Overrides:

getShort in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is 0

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getInt

public int getInt(String columnName)
           throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

Specified by:

getInt in interface ResultSet

Overrides:

getInt in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is 0

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getLong

public long getLong(String columnName)
             throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

Specified by:

getLong in interface ResultSet

Overrides:

getLong in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is 0

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getFloat

public float getFloat(String columnName)
               throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

Specified by:

getFloat in interface ResultSet

Overrides:

getFloat in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is 0

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getDouble

public double getDouble(String columnName)
                 throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

Specified by:

getDouble in interface ResultSet

Overrides:

getDouble in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is 0

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getBigDecimal

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

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal in the Java programming language.

Specified by:

getBigDecimal in interface ResultSet

Overrides:

getBigDecimal in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

scale - the number of digits to the right of the decimal point

Returns:

the column value; if the value is SQL NULL, the value returned is null

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

getBytes

public byte[] getBytes(String columnName)
                throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language. The bytes represent the raw values returned by the driver.

Specified by:

getBytes in interface ResultSet

Overrides:

getBytes in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is null

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getDate

public Date getDate(String columnName)
             throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

Specified by:

getDate in interface ResultSet

Overrides:

getDate in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is null

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getTime

public Time getTime(String columnName)
             throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

Specified by:

getTime in interface ResultSet

Overrides:

getTime in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is null

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getTimestamp

public Timestamp getTimestamp(String columnName)
                       throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.

Specified by:

getTimestamp in interface ResultSet

Overrides:

getTimestamp in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value; if the value is SQL NULL, the value returned is null

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getAsciiStream

public InputStream getAsciiStream(String columnName)
                           throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

Specified by:

getAsciiStream in interface ResultSet

Overrides:

getAsciiStream in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

a Java input stream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQL NULL, the value returned is null.

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getUnicodeStream

public InputStream getUnicodeStream(String columnName)
                             throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of two-byte Unicode characters. The first byte is the high byte; the second byte is the low byte. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC technology-enabled driver will do any necessary conversion from the database format into Unicode.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called, whether there is data available or not.

Specified by:

getUnicodeStream in interface ResultSet

Overrides:

getUnicodeStream in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

a Java input stream that delivers the database column value as a stream of two-byte Unicode characters. If the value is SQL NULL, the value returned is null.

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

getBinaryStream

public InputStream getBinaryStream(String columnName)
                            throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

Specified by:

getBinaryStream in interface ResultSet

Overrides:

getBinaryStream in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQL NULL, the result is null

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getObject

public Object getObject(String columnName)
                 throws SQLException

Description copied from interface: java.sql.ResultSet

Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

This method will return the value of the given column as a Java object. The type of the Java object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification. If the value is an SQL NULL, the driver returns a Java null.

This method may also be used to read database-specific abstract data types.

In the JDBC 2.0 API, the behavior of the method getObject is extended to materialize data of SQL user-defined types. When a column contains a structured or distinct value, the behavior of this method is as if it were a call to: getObject(columnIndex, this.getStatement().getConnection().getTypeMap()).

Specified by:

getObject in interface ResultSet

Overrides:

getObject in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

a java.lang.Object holding the column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

findColumn

public int findColumn(String columnName)
               throws SQLException

Description copied from interface: java.sql.ResultSet

Maps the given ResultSet column label to its ResultSet column index.

Specified by:

findColumn in interface ResultSet

Overrides:

findColumn in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column index of the given column name

Throws:

SQLException - if the ResultSet object does not contain a column labeled columnLabel, a database access error occurs or this method is called on a closed result set

getCharacterStream

public Reader getCharacterStream(String columnName)
                          throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

Specified by:

getCharacterStream in interface ResultSet

Overrides:

getCharacterStream in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

a java.io.Reader object that contains the column value; if the value is SQL NULL, the value returned is null in the Java programming language

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getBigDecimal

public BigDecimal getBigDecimal(String columnName)
                         throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.

Specified by:

getBigDecimal in interface ResultSet

Overrides:

getBigDecimal in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value (full precision); if the value is SQL NULL, the value returned is null in the Java programming language.

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

columnUpdated

public boolean columnUpdated(String columnName)
                      throws SQLException

Description copied from interface: javax.sql.rowset.CachedRowSet

Indicates whether the designated column in the current row of this CachedRowSet object has been updated.

Specified by:

columnUpdated in interface CachedRowSet

Overrides:

columnUpdated in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - a String object giving the name of the column to be checked for updates

Returns:

true if the column has been visibly updated; false otherwise

Throws:

SQLException - if the cursor is on the insert row, before the first row, or after the last row

See Also:

DatabaseMetaData.updatesAreDetected(int)

updateNull

public void updateNull(String columnName)
                throws SQLException

Description copied from interface: java.sql.ResultSet

Updates the designated column with a null value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateNull in interface ResultSet

Overrides:

updateNull in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateBoolean

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a boolean value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateBoolean in interface ResultSet

Overrides:

updateBoolean in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateByte

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a byte value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateByte in interface ResultSet

Overrides:

updateByte in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateShort

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a short value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateShort in interface ResultSet

Overrides:

updateShort in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateInt

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with an int value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateInt in interface ResultSet

Overrides:

updateInt in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateLong

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a long value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateLong in interface ResultSet

Overrides:

updateLong in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateFloat

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a float value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateFloat in interface ResultSet

Overrides:

updateFloat in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateDouble

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a double value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateDouble in interface ResultSet

Overrides:

updateDouble in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateBigDecimal

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a java.sql.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateBigDecimal in interface ResultSet

Overrides:

updateBigDecimal in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateString

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a String value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateString in interface ResultSet

Overrides:

updateString in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateBytes

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a byte array value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateBytes in interface ResultSet

Overrides:

updateBytes in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateDate

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a java.sql.Date value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateDate in interface ResultSet

Overrides:

updateDate in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateTime

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a java.sql.Time value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateTime in interface ResultSet

Overrides:

updateTime in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateTimestamp

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateTimestamp in interface ResultSet

Overrides:

updateTimestamp in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateAsciiStream

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with an ascii stream value, which will have the specified number of bytes. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateAsciiStream in interface ResultSet

Overrides:

updateAsciiStream in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

length - the length of the stream

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateBinaryStream

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a binary stream value, which will have the specified number of bytes. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateBinaryStream in interface ResultSet

Overrides:

updateBinaryStream in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

length - the length of the stream

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateCharacterStream

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with a character stream value, which will have the specified number of bytes. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateCharacterStream in interface ResultSet

Overrides:

updateCharacterStream in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

reader - the java.io.Reader object containing the new column value

length - the length of the stream

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateObject

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

If the second argument is an InputStream then the stream must contain the number of bytes specified by scaleOrLength. If the second argument is a Reader then the reader must contain the number of characters specified by scaleOrLength. If these conditions are not true the driver will generate a SQLException when the statement is executed.

Specified by:

updateObject in interface ResultSet

Overrides:

updateObject in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

scale - for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateObject

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

Description copied from interface: java.sql.ResultSet

Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateObject in interface ResultSet

Overrides:

updateObject in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

x - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

getObject

public Object getObject(String columnName,
                        Map<String,Class<?>> map)
                 throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. If the value is an SQL NULL, the driver returns a Java null. This method uses the specified Map object for custom mapping if appropriate.

Specified by:

getObject in interface ResultSet

Overrides:

getObject in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

map - a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language

Returns:

an Object representing the SQL value in the specified column

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

getRef

public Ref getRef(String colName)
           throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language.

Specified by:

getRef in interface ResultSet

Overrides:

getRef in class com.sun.rowset.CachedRowSetImpl

Parameters:

colName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

a Ref object representing the SQL REF value in the specified column

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

getBlob

public Blob getBlob(String colName)
             throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.

Specified by:

getBlob in interface ResultSet

Overrides:

getBlob in class com.sun.rowset.CachedRowSetImpl

Parameters:

colName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

a Blob object representing the SQL BLOB value in the specified column

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

getClob

public Clob getClob(String colName)
             throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language.

Specified by:

getClob in interface ResultSet

Overrides:

getClob in class com.sun.rowset.CachedRowSetImpl

Parameters:

colName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

a Clob object representing the SQL CLOB value in the specified column

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

getArray

public Array getArray(String colName)
               throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.

Specified by:

getArray in interface ResultSet

Overrides:

getArray in class com.sun.rowset.CachedRowSetImpl

Parameters:

colName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

an Array object representing the SQL ARRAY value in the specified column

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

getDate

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

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.

Specified by:

getDate in interface ResultSet

Overrides:

getDate in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

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

Returns:

the column value as a java.sql.Date object; if the value is SQL NULL, the value returned is null in the Java programming language

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getTime

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

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the time if the underlying database does not store timezone information.

Specified by:

getTime in interface ResultSet

Overrides:

getTime in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

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

Returns:

the column value as a java.sql.Time object; if the value is SQL NULL, the value returned is null in the Java programming language

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getTimestamp

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

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.

Specified by:

getTimestamp in interface ResultSet

Overrides:

getTimestamp in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

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

Returns:

the column value as a java.sql.Timestamp object; if the value is SQL NULL, the value returned is null in the Java programming language

Throws:

SQLException - if the columnLabel is not valid or if a database access error occurs or this method is called on a closed result set

updateRef

public void updateRef(String columnName,
                      Ref ref)
               throws SQLException

Description copied from interface: java.sql.ResultSet

Updates the designated column with a java.sql.Ref value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateRef in interface ResultSet

Overrides:

updateRef in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

ref - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateClob

public void updateClob(String columnName,
                       Clob c)
                throws SQLException

Description copied from interface: java.sql.ResultSet

Updates the designated column with a java.sql.Clob value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateClob in interface ResultSet

Overrides:

updateClob in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

c - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateBlob

public void updateBlob(String columnName,
                       Blob b)
                throws SQLException

Description copied from interface: java.sql.ResultSet

Updates the designated column with a java.sql.Blob value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateBlob in interface ResultSet

Overrides:

updateBlob in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

b - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

updateArray

public void updateArray(String columnName,
                        Array a)
                 throws SQLException

Description copied from interface: java.sql.ResultSet

Updates the designated column with a java.sql.Array value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Specified by:

updateArray in interface ResultSet

Overrides:

updateArray in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

a - the new column value

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set

SQLFeatureNotSupportedException - if the JDBC driver does not support this method

getURL

public URL getURL(String columnName)
           throws SQLException

Description copied from interface: java.sql.ResultSet

Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language.

Specified by:

getURL in interface ResultSet

Overrides:

getURL in class com.sun.rowset.CachedRowSetImpl

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns:

the column value as a java.net.URL object; if the value is SQL NULL, the value returned is null in the Java programming language

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs; this method is called on a closed result set or if a URL is malformed

SQLFeatureNotSupportedException - if the JDBC driver does not support this method