public class

CachedRowSetImpl

extends BaseRowSet
implements Serializable Cloneable RowSet RowSetInternal CachedRowSet
java.lang.Object
   ↳ javax.sql.rowset.BaseRowSet
     ↳ com.sun.rowset.CachedRowSetImpl
Known Direct Subclasses
Known Indirect Subclasses

Class Overview

The standard implementation of the CachedRowSet interface. See interface defintion for full behaviour and implementation requirements. This reference implementation has made provision for a one-to-one write back facility and it is curremtly be possible to change the peristence provider during the life-time of any CachedRowSetImpl.

Summary

[Expand]
Inherited Constants
From class javax.sql.rowset.BaseRowSet
From interface java.sql.ResultSet
From interface javax.sql.rowset.CachedRowSet
Fields
protected JdbcRowSetResourceBundle resBundle
[Expand]
Inherited Fields
From class javax.sql.rowset.BaseRowSet
Public Constructors
CachedRowSetImpl()
Constructs a new default CachedRowSetImpl object with the capacity to hold 100 rows.
CachedRowSetImpl(Hashtable env)
Provides a CachedRowSetImpl instance with the same default properties as as the zero parameter constructor.
Public Methods
boolean absolute(int row)
Moves this CachedRowSetImpl object's cursor to the row number specified.
void acceptChanges()
Propagates all row update, insert, and delete changes to the underlying data source backing this CachedRowSetImpl object.
void acceptChanges(Connection con)
Propagates all row update, insert, and delete changes to the data source backing this CachedRowSetImpl object using the given Connection object.
void afterLast()
Moves this CachedRowSetImpl object's cursor to the end of the rowset, just after the last row.
void beforeFirst()
Moves this CachedRowSetImpl object's cursor to the front of the rowset, just before the first row.
void cancelRowUpdates()
Rolls back any updates made to the current row of this CachedRowSetImpl object and notifies listeners that a row has changed.
void clearWarnings()
Clears all the warnings reporeted for the CachedRowSetImpl object.
void close()
Closes this CachedRowSetImpl objecy and releases any resources it was using.
boolean columnUpdated(int idx)
Indicates whether the designated column of the current row of this CachedRowSetImpl object has been updated.
boolean columnUpdated(String columnName)
Indicates whether the designated column of the current row of this CachedRowSetImpl object has been updated.
void commit()
Commits all changes performed by the acceptChanges() methods
CachedRowSet createCopy()
Creates a RowSet object that is a deep copy of this CachedRowSetImpl object's data, including constraints.
CachedRowSet createCopyNoConstraints()
Creates a CachedRowSet object that is a copy of this CachedRowSetImpl object's data only.
CachedRowSet createCopySchema()
Creates a RowSet object that is a copy of this CachedRowSetImpl object's table structure and the constraints only.
RowSet createShared()
Returns a new RowSet object backed by the same data as that of this CachedRowSetImpl object and sharing a set of cursors with it.
void deleteRow()
Deletes the current row from this CachedRowSetImpl object and notifies listeners registered with this rowset that a row has changed.
void execute()
Populates this CachedRowSetImpl object with data.
void execute(Connection conn)
Populates this CachedRowSetImpl object with data, using the given connection to produce the result set from which data will be read.
int findColumn(String columnName)
Maps the given column name for one of this CachedRowSetImpl object's columns to its column number.
boolean first()
Moves this CachedRowSetImpl object's cursor to the first row and returns true if the operation was successful.
Array getArray(int columnIndex)
Retrieves the value of the designated column in this CachedRowSetImpl object as an Array object in the Java programming language.
Array getArray(String colName)
Retrieves the value of the designated column in this CachedRowSetImpl object as an Array object in the Java programming langugage.
InputStream getAsciiStream(String columnName)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.io.InputStream object.
InputStream getAsciiStream(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.io.InputStream object.
BigDecimal getBigDecimal(String columnName)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.math.BigDecimal object.
BigDecimal getBigDecimal(int columnIndex, int scale)
This method is deprecated. No replacement.
BigDecimal getBigDecimal(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.math.BigDecimal object.
BigDecimal getBigDecimal(String columnName, int scale)
This method is deprecated. Use the getBigDecimal(String columnName) method instead
InputStream getBinaryStream(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.io.InputStream object.
InputStream getBinaryStream(String columnName)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.io.InputStream object.
Blob getBlob(String colName)
Retrieves the value of the designated column in this CachedRowSetImpl object as a Blob object in the Java programming language.
Blob getBlob(int columnIndex)
Retrieves the value of the designated column in this CachedRowSetImpl object as a Blob object in the Java programming language.
boolean getBoolean(String columnName)
Retrieves the value stored in the designated column of the current row as a boolean value.
boolean getBoolean(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a boolean value.
byte getByte(String columnName)
Retrieves the value stored in the designated column of the current row as a byte value.
byte getByte(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a byte value.
byte[] getBytes(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a byte array value.
byte[] getBytes(String columnName)
Retrieves the value stored in the designated column of the current row as a byte array.
Reader getCharacterStream(String columnName)
Retrieves the value stored in the designated column of the current row as a java.io.Reader object.
Reader getCharacterStream(int columnIndex)
Retrieves the value stored in the designated column of the current row as a java.io.Reader object.
Clob getClob(int columnIndex)
Retrieves the value of the designated column in this CachedRowSetImpl object as a Clob object in the Java programming language.
Clob getClob(String colName)
Retrieves the value of the designated column in this CachedRowSetImpl object as a Clob object in the Java programming language.
Connection getConnection()
Retrieves the Connection object passed to this CachedRowSetImpl object.
String getCursorName()
Retrieves the name of the SQL cursor used by this CachedRowSetImpl object.
Date getDate(int columnIndex, Calendar cal)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Date object, using the given Calendar object to construct an appropriate millisecond value for the date.
Date getDate(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Date object.
Date getDate(String columnName, Calendar cal)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Date object, using the given Calendar object to construct an appropriate millisecond value for the date.
Date getDate(String columnName)
Retrieves the value stored in the designated column of the current row as a java.sql.Date object.
double getDouble(String columnName)
Retrieves the value stored in the designated column of the current row of this CachedRowSetImpl object as a double value.
double getDouble(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a double value.
float getFloat(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a float value.
float getFloat(String columnName)
Retrieves the value stored in the designated column of the current row as a float value.
int getHoldability()
Retrieves the holdability of this ResultSet object
int getInt(String columnName)
Retrieves the value stored in the designated column of the current row as an int value.
int getInt(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as an int value.
int[] getKeyColumns()
Returns the columns that make a key to uniquely identify a row in this CachedRowSetImpl object.
long getLong(String columnName)
Retrieves the value stored in the designated column of the current row as a long value.
long getLong(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a long value.
int[] getMatchColumnIndexes()
Retrieves the column id as int array that was set using setMatchColumn(int []) for this rowset.
String[] getMatchColumnNames()
Retrieves the column name as String array that was set using setMatchColumn(String []) for this rowset.
ResultSetMetaData getMetaData()
Retrieves a ResultSetMetaData object instance that contains information about the CachedRowSet object.
Reader getNCharacterStream(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
Reader getNCharacterStream(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.
NClob getNClob(int i)
Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.
NClob getNClob(String colName)
Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.
String getNString(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.
String getNString(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
Object getObject(String columnName, Map<String, Class<?>> map)
Retrieves the value of the designated column in this CachedRowSetImpl object as an Object in the Java programming language, using the given java.util.Map object to custom map the value if appropriate.
Object getObject(int columnIndex, Map<String, Class<?>> map)
Retrieves the value of the designated column in this CachedRowSetImpl object as an Object in the Java programming language, using the given java.util.Map object to custom map the value if appropriate.
Object getObject(String columnName)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as an Object value.
Object getObject(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as an Object value.
ResultSet getOriginal()
Returns a result set containing the original value of the rowset.
ResultSet getOriginalRow()
Returns a result set containing the original value of the current row only.
int getPageSize()
This is the getter function for the size of the page.
Ref getRef(String colName)
Retrieves the value of the designated column in this CachedRowSetImpl object as a Ref object in the Java programming language.
Ref getRef(int columnIndex)
Retrieves the value of the designated column in this CachedRowSetImpl object as a Ref object in the Java programming language.
int getRow()
Returns the number of the current row in this CachedRowSetImpl object.
RowId getRowId(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.
RowId getRowId(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.
RowSetWarning getRowSetWarnings()
The first warning reported by calls on this CachedRowSetImpl object is returned.
SQLXML getSQLXML(String colName)
Retrieves the value of the designated SQL XML parameter as a SQLXML object in the Java programming language.
SQLXML getSQLXML(int columnIndex)
Retrieves the value of the designated SQL XML parameter as a SQLXML object in the Java programming language.
short getShort(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a short value.
short getShort(String columnName)
Retrieves the value stored in the designated column of the current row as a short value.
Statement getStatement()
Returns null.
String getString(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a String object.
String getString(String columnName)
Retrieves the value stored in the designated column of the current row as a String object.
SyncProvider getSyncProvider()
Returns the SyncProvider implementation being used with this CachedRowSetImpl implementation rowset.
String getTableName()
Returns an identifier for the object (table) that was used to create this rowset.
Time getTime(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Time object.
Time getTime(String columnName, Calendar cal)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Time object, using the given Calendar object to construct an appropriate millisecond value for the date.
Time getTime(String columnName)
Retrieves the value stored in the designated column of the current row as a java.sql.Time object.
Time getTime(int columnIndex, Calendar cal)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Time object, using the given Calendar object to construct an appropriate millisecond value for the date.
Timestamp getTimestamp(int columnIndex, Calendar cal)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Timestamp object, using the given Calendar object to construct an appropriate millisecond value for the date.
Timestamp getTimestamp(String columnName, Calendar cal)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Timestamp object, using the given Calendar object to construct an appropriate millisecond value for the date.
Timestamp getTimestamp(String columnName)
Retrieves the value stored in the designated column of the current row as a java.sql.Timestamp object.
Timestamp getTimestamp(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Timestamp object.
URL getURL(String columnName)
Retrieves the value of the designated column in this CachedRowSetImpl object as a java.net.URL object in the Java programming language.
URL getURL(int columnIndex)
Retrieves the value of the designated column in this CachedRowSetImpl object as a java.net.URL object in the Java programming language.
InputStream getUnicodeStream(int columnIndex)
This method is deprecated. No replacement.
InputStream getUnicodeStream(String columnName)
This method is deprecated. use the method getCharacterStream instead
SQLWarning getWarnings()
The first warning reported by calls on this CachedRowSetImpl object is returned.
void insertRow()
Inserts the contents of this CachedRowSetImpl object's insert row into this rowset immediately following the current row.
boolean isAfterLast()
Indicates whether the cursor is after the last row in this CachedRowSetImpl object.
boolean isBeforeFirst()
Indicates whether the cursor is before the first row in this CachedRowSetImpl object.
boolean isClosed()
Retrieves whether this ResultSet object has been closed.
boolean isFirst()
Indicates whether the cursor is on the first row in this CachedRowSetImpl object.
boolean isLast()
Indicates whether the cursor is on the last row in this CachedRowSetImpl object.
boolean isWrapperFor(Class<?> interfaces)
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
boolean last()
Moves this CachedRowSetImpl object's cursor to the last row and returns true if the operation was successful.
void moveToCurrentRow()
Moves the cursor for this CachedRowSetImpl object to the current row.
void moveToInsertRow()
Moves the cursor for this CachedRowSetImpl object to the insert row.
boolean next()
Moves the cursor down one row from its current position and returns true if the new cursor position is a valid row.
boolean nextPage()
The nextPage gets the next page, that is a CachedRowSetImpl object containing the number of rows specified by page size.
void populate(ResultSet data)
Populates this CachedRowSetImpl object with data from the given ResultSet object.
void populate(ResultSet data, int start)
Populates this CachedRowSet object with data from the given ResultSet object.
boolean previous()
Moves this CachedRowSetImpl object's cursor to the previous row and returns true if the cursor is on a valid row or false if it is not.
boolean previousPage()
Retrieves the data present in the page prior to the page from where it is called.
void refreshRow()
Sets the current row with its original value and marks the row as not updated, thus undoing any changes made to the row since the last call to the methods updateRow or deleteRow.
boolean relative(int rows)
Moves the cursor the specified number of rows from the current position, with a positive number moving it forward and a negative number moving it backward.
void release()
Releases the current contents of this CachedRowSetImpl object and sends a rowSetChanged event object to all registered listeners.
void restoreOriginal()
Restores this CachedRowSetImpl object to its original state, that is, its state before the last set of changes.
void rollback(Savepoint s)
Rolls back all changes performed by the acceptChanges() to the last Savepoint transaction marker.
void rollback()
Rolls back all changes performed by the acceptChanges() methods
boolean rowDeleted()
Indicates whether the current row has been deleted.
boolean rowInserted()
Indicates whether the current row has been inserted.
void rowSetPopulated(RowSetEvent event, int numRows)
Notifies registered listeners that a RowSet object in the given RowSetEvent object has populated a number of additional rows.
boolean rowUpdated()
Indicates whether the current row of this CachedRowSetImpl object has been updated.
void setAsciiStream(String parameterName, InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
void setAsciiStream(String parameterName, InputStream x)
Sets the designated parameter to the given input stream.
void setBigDecimal(String parameterName, BigDecimal x)
Sets the designated parameter to the given java.math.BigDecimal value.
void setBinaryStream(String parameterName, InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
void setBinaryStream(String parameterName, InputStream x)
Sets the designated parameter to the given input stream.
void setBlob(int parameterIndex, InputStream inputStream, long length)
Sets the designated parameter to a InputStream object.
void setBlob(String parameterName, Blob x)
Sets the designated parameter to the given java.sql.Blob object.
void setBlob(int parameterIndex, InputStream inputStream)
Sets the designated parameter to a InputStream object.
void setBlob(String parameterName, InputStream inputStream, long length)
Sets the designated parameter to a InputStream object.
void setBlob(String parameterName, InputStream inputStream)
Sets the designated parameter to a InputStream object.
void setBoolean(String parameterName, boolean x)
Sets the designated parameter to the given Java boolean value.
void setByte(String parameterName, byte x)
Sets the designated parameter to the given Java byte value.
void setBytes(String parameterName, byte[] x)
Sets the designated parameter to the given Java array of bytes.
void setCharacterStream(String parameterName, Reader reader, int length)
Sets the designated parameter to the given Reader object, which is the given number of characters long.
void setCharacterStream(String parameterName, Reader reader)
Sets the designated parameter to the given Reader object.
void setClob(int parameterIndex, Reader reader, long length)
Sets the designated parameter to a Reader object.
void setClob(String parameterName, Clob x)
Sets the designated parameter to the given java.sql.Clob object.
void setClob(String parameterName, Reader reader)
Sets the designated parameter to a Reader object.
void setClob(String parameterName, Reader reader, long length)
Sets the designated parameter to a Reader object.
void setClob(int parameterIndex, Reader reader)
Sets the designated parameter to a Reader object.
void setCommand(String cmd)
Sets this CachedRowSetImpl object's command property to the given String object and clears the parameters, if any, that were set for the previous command.
void setDate(String parameterName, Date x)
Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.
void setDate(String parameterName, Date x, Calendar cal)
Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
void setDouble(String parameterName, double x)
Sets the designated parameter to the given Java double value.
void setFloat(String parameterName, float x)
Sets the designated parameter to the given Java float value.
void setInt(String parameterName, int x)
Sets the designated parameter to the given Java int value.
void setKeyColumns(int[] keys)
Sets this CachedRowSetImpl object's keyCols field with the given array of column numbers, which forms a key for uniquely identifying a row in this rowset.
void setLong(String parameterName, long x)
Sets the designated parameter to the given Java long value.
void setMatchColumn(int columnIdx)
Sets the designated parameter to the given int object.
void setMatchColumn(String[] columnNames)
Sets the designated parameter to the given String array.
void setMatchColumn(int[] columnIdxes)
Sets the designated parameter to the given int array.
void setMatchColumn(String columnName)
Sets the designated parameter to the given String object.
void setMetaData(RowSetMetaData md)
Sets the metadata for this CachedRowSetImpl object with the given RowSetMetaData object.
void setNCharacterStream(int parameterIndex, Reader value)
Sets the designated parameter to a Reader object.
void setNCharacterStream(String parameterName, Reader value)
Sets the designated parameter to a Reader object.
void setNCharacterStream(String parameterName, Reader value, long length)
Sets the designated parameter to a Reader object.
void setNCharacterStream(int parameterIndex, Reader value, long length)
Sets the designated parameter to a Reader object.
void setNClob(int parameterIndex, Reader reader)
Sets the designated parameter to a Reader object.
void setNClob(String parameterName, Reader reader)
Sets the designated parameter to a Reader object.
void setNClob(int parameterIndex, NClob value)
Sets the designated parameter to a java.sql.NClob object.
void setNClob(String parameterName, Reader reader, long length)
Sets the designated parameter to a Reader object.
void setNClob(String parameterName, NClob value)
Sets the designated parameter to a java.sql.NClob object.
void setNClob(int parameterIndex, Reader reader, long length)
Sets the designated parameter to a Reader object.
void setNString(String parameterName, String value)
Sets the designated paramter to the given String object.
void setNString(int parameterIndex, String value)
Sets the designated paramter to the given String object.
void setNull(String parameterName, int sqlType)
Sets the designated parameter to SQL NULL.
void setNull(String parameterName, int sqlType, String typeName)
Sets the designated parameter to SQL NULL.
void setObject(String parameterName, Object x)
Sets the value of the designated parameter with the given object.
void setObject(String parameterName, Object x, int targetSqlType)
Sets the value of the designated parameter with the given object.
void setObject(String parameterName, Object x, int targetSqlType, int scale)
Sets the value of the designated parameter with the given object.
void setOriginal()
Marks all rows in this rowset as being original rows.
void setOriginalRow()
Marks the current row in this rowset as being an original row.
void setPageSize(int size)
This is the setter function for setting the size of the page, which specifies how many rows have to be retrived at a time.
void setRowId(int parameterIndex, RowId x)
Sets the designated parameter to the given java.sql.RowId object.
void setRowId(String parameterName, RowId x)
Sets the designated parameter to the given java.sql.RowId object.
void setRowInserted(boolean insertFlag)
Sets the status for the row on which the cursor is positioned.
void setSQLXML(int parameterIndex, SQLXML xmlObject)
Sets the designated parameter to the given java.sql.SQLXML object.
void setSQLXML(String parameterName, SQLXML xmlObject)
Sets the designated parameter to the given java.sql.SQLXML object.
void setShort(String parameterName, short x)
Sets the designated parameter to the given Java short value.
void setString(String parameterName, String x)
Sets the designated parameter to the given Java String value.
void setSyncProvider(String providerStr)
Sets the active SyncProvider and attempts to load load the new provider using the SyncFactory SPI.
void setTableName(String tabName)
Sets the identifier for the table from which this rowset was derived to the given table name.
void setTime(String parameterName, Time x)
Sets the designated parameter to the given java.sql.Time value.
void setTime(String parameterName, Time x, Calendar cal)
Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.
void setTimestamp(String parameterName, Timestamp x, Calendar cal)
Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.
void setTimestamp(String parameterName, Timestamp x)
Sets the designated parameter to the given java.sql.Timestamp value.
void setURL(int parameterIndex, URL x)
Sets the designated parameter to the given java.net.URL value.
int size()
Returns the number of rows in this CachedRowSetImpl object.
Collection<?> toCollection()
Converts this CachedRowSetImpl object to a collection of tables.
Collection<?> toCollection(String column)
Returns the specified column of this CachedRowSetImpl object as a Collection object.
Collection<?> toCollection(int column)
Returns the specified column of this CachedRowSetImpl object as a Collection object.
void undoDelete()
Cancels deletion of the current row and notifies listeners that a row has changed.
void undoInsert()
Immediately removes the current row from this CachedRowSetImpl object if the row has been inserted, and also notifies listeners the a row has changed.
void undoUpdate()
Immediately reverses the last update operation if the row has been modified.
void unsetMatchColumn(int[] columnIdxes)
Unsets the designated parameter to the given int array.
void unsetMatchColumn(String[] columnIdxes)
Unsets the designated parameter to the given String array.
void unsetMatchColumn(String columnName)
Unsets the designated parameter to the given String object.
void unsetMatchColumn(int columnIdx)
Unsets the designated parameter to the given int object.
<T> T unwrap(Class<T> iface)
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
void updateArray(int columnIndex, Array a)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.sql.Array values.
void updateArray(String columnName, Array a)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.sql.Array value.
void updateAsciiStream(String columnName, InputStream x, int length)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given ASCII stream value.
void updateAsciiStream(int columnIndex, InputStream x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.
void updateAsciiStream(int columnIndex, InputStream x)
Updates the designated column with an ascii stream value.
void updateAsciiStream(String columnLabel, InputStream x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes..
void updateAsciiStream(String columnLabel, InputStream x)
Updates the designated column with an ascii stream value.
void updateAsciiStream(int columnIndex, InputStream x, int length)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given ASCII stream value.
void updateBigDecimal(int columnIndex, BigDecimal x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.math.BigDecimal object.
void updateBigDecimal(String columnName, BigDecimal x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.math.BigDecimal object.
void updateBinaryStream(int columnIndex, InputStream x)
Updates the designated column with a binary stream value.
void updateBinaryStream(String columnLabel, InputStream x)
Updates the designated column with a binary stream value.
void updateBinaryStream(String columnName, InputStream x, int length)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.io.InputStream object.
void updateBinaryStream(int columnIndex, InputStream x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.
void updateBinaryStream(String columnLabel, InputStream x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.
void updateBinaryStream(int columnIndex, InputStream x, int length)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.io.InputStream object.
void updateBlob(int columnIndex, Blob b)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.sql.Blob value.
void updateBlob(String columnLabel, InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes.
void updateBlob(int columnIndex, InputStream inputStream)
Updates the designated column using the given input stream.
void updateBlob(int columnIndex, InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes.
void updateBlob(String columnName, Blob b)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.sql.Blob value.
void updateBlob(String columnLabel, InputStream inputStream)
Updates the designated column using the given input stream.
void updateBoolean(int columnIndex, boolean x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given boolean value.
void updateBoolean(String columnName, boolean x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given boolean value.
void updateByte(int columnIndex, byte x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given byte value.
void updateByte(String columnName, byte x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given byte value.
void updateBytes(int columnIndex, byte[] x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given byte array.
void updateBytes(String columnName, byte[] x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given byte array.
void updateCharacterStream(String columnName, Reader reader, int length)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.io.Reader object.
void updateCharacterStream(String columnLabel, Reader reader, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.
void updateCharacterStream(String columnLabel, Reader reader)
Updates the designated column with a character stream value.
void updateCharacterStream(int columnIndex, Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.
void updateCharacterStream(int columnIndex, Reader x)
Updates the designated column with a character stream value.
void updateCharacterStream(int columnIndex, Reader x, int length)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.io.Reader object.
void updateClob(int columnIndex, Clob c)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given double value.
void updateClob(int columnIndex, Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long.
void updateClob(int columnIndex, Reader reader)
Updates the designated column using the given Reader object.
void updateClob(String columnName, Clob c)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given double value.
void updateClob(String columnLabel, Reader reader)
Updates the designated column using the given Reader object.
void updateClob(String columnLabel, Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long.
void updateDate(String columnName, Date x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Date object.
void updateDate(int columnIndex, Date x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Date object.
void updateDouble(String columnName, double x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given double value.
void updateDouble(int columnIndex, double x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given double value.
void updateFloat(String columnName, float x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given float value.
void updateFloat(int columnIndex, float x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given float value.
void updateInt(String columnName, int x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given int value.
void updateInt(int columnIndex, int x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given int value.
void updateLong(int columnIndex, long x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given long value.
void updateLong(String columnName, long x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given long value.
void updateNCharacterStream(String columnName, Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.
void updateNCharacterStream(int columnIndex, Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.
void updateNCharacterStream(String columnLabel, Reader reader)
Updates the designated column with a character stream value.
void updateNCharacterStream(int columnIndex, Reader x)
Updates the designated column with a character stream value.
void updateNClob(String columnName, NClob nClob)
This method is used for updating SQL NCLOB type that maps to java.sql.Types.NCLOB
void updateNClob(int columnIndex, Reader reader)
Updates the designated column using the given Reader object.
void updateNClob(int columnIndex, NClob nClob)
Updates the designated column with a java.sql.NClob value.
void updateNClob(String columnLabel, Reader reader)
Updates the designated column using the given Reader object.
void updateNClob(int columnIndex, Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long.
void updateNClob(String columnLabel, Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long.
void updateNString(String columnName, String nString)
This method is used for updating columns that support National Character sets.
void updateNString(int columnIndex, String nString)
This method is used for updating columns that support National Character sets.
void updateNull(String columnName)
Sets the designated nullable column in the current row or the insert row of this CachedRowSetImpl object with null value.
void updateNull(int columnIndex)
Sets the designated nullable column in the current row or the insert row of this CachedRowSetImpl object with null value.
void updateObject(int columnIndex, Object x, int scale)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Object value.
void updateObject(int columnIndex, Object x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Object value.
void updateObject(String columnName, Object x, int scale)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Object value.
void updateObject(String columnName, Object x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Object value.
void updateRef(int columnIndex, Ref ref)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Ref value.
void updateRef(String columnName, Ref ref)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given double value.
void updateRow()
Marks the current row of this CachedRowSetImpl object as updated and notifies listeners registered with this rowset that the row has changed.
void updateRowId(String columnName, RowId x)
Updates the designated column with a RowId value.
void updateRowId(int columnIndex, RowId x)
Updates the designated column with a RowId value.
void updateSQLXML(int columnIndex, SQLXML xmlObject)
Updates the designated column with a java.sql.SQLXML value.
void updateSQLXML(String columnName, SQLXML xmlObject)
Updates the designated column with a java.sql.SQLXML value.
void updateShort(int columnIndex, short x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given short value.
void updateShort(String columnName, short x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given short value.
void updateString(int columnIndex, String x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given String object.
void updateString(String columnName, String x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given String object.
void updateTime(int columnIndex, Time x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Time object.
void updateTime(String columnName, Time x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Time object.
void updateTimestamp(int columnIndex, Timestamp x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Timestamp object.
void updateTimestamp(String columnName, Timestamp x)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Timestamp object.
boolean wasNull()
Reports whether the last column read was SQL NULL.
Protected Methods
Object clone()
Returns a new RowSet object containing by the same data as this CachedRowSetImpl object.
BaseRow getCurrentRow()
Returns the insert row or the current row of this CachedRowSetImplobject.
boolean internalFirst()
Moves this CachedRowSetImpl object's cursor to the first row and returns true if the operation is successful.
boolean internalLast()
Moves this CachedRowSetImpl object's cursor to the last row and returns true if the operation is successful.
boolean internalNext()
Moves this CachedRowSetImpl object's cursor to the next row and returns true if the cursor is still in the rowset; returns false if the cursor has moved to the position after the last row.
boolean internalPrevious()
Moves the cursor to the previous row in this CachedRowSetImpl object, skipping past deleted rows that are not visible; returns true if the cursor is on a row in this rowset and false when the cursor goes before the first row.
void readObject(ObjectInputStream ois)
This method re populates the resBundle during the deserialization process
void removeCurrentRow()
Removes the row on which the cursor is positioned.
[Expand]
Inherited Methods
From class javax.sql.rowset.BaseRowSet
From class java.lang.Object
From interface java.sql.ResultSet
From interface java.sql.Wrapper
From interface javax.sql.RowSet
From interface javax.sql.RowSetInternal
From interface javax.sql.rowset.CachedRowSet
From interface javax.sql.rowset.Joinable

Fields

protected JdbcRowSetResourceBundle resBundle

Public Constructors

public CachedRowSetImpl ()

Constructs a new default CachedRowSetImpl object with the capacity to hold 100 rows. This new object has no metadata and has the following default values: 

     onInsertRow = false
     insertRow = null
     cursorPos = 0
     numRows = 0
     showDeleted = false
     queryTimeout = 0
     maxRows = 0
     maxFieldSize = 0
     rowSetType = ResultSet.TYPE_SCROLL_INSENSITIVE
     concurrency = ResultSet.CONCUR_UPDATABLE
     readOnly = false
     isolation = Connection.TRANSACTION_READ_COMMITTED
     escapeProcessing = true
     onInsertRow = false
     insertRow = null
     cursorPos = 0
     absolutePos = 0
     numRows = 0
A CachedRowSetImpl object is configured to use the default RIOptimisticProvider implementation to provide connectivity and synchronization capabilities to the set data source.

Throws
SQLException if an error occurs

public CachedRowSetImpl (Hashtable env)

Provides a CachedRowSetImpl instance with the same default properties as as the zero parameter constructor. 

     onInsertRow = false
     insertRow = null
     cursorPos = 0
     numRows = 0
     showDeleted = false
     queryTimeout = 0
     maxRows = 0
     maxFieldSize = 0
     rowSetType = ResultSet.TYPE_SCROLL_INSENSITIVE
     concurrency = ResultSet.CONCUR_UPDATABLE
     readOnly = false
     isolation = Connection.TRANSACTION_READ_COMMITTED
     escapeProcessing = true
     onInsertRow = false
     insertRow = null
     cursorPos = 0
     absolutePos = 0
     numRows = 0
However, applications will have the means to specify at runtime the desired SyncProvider object.

For example, creating a CachedRowSetImpl object as follows ensures that a it is established with the com.foo.provider.Impl synchronization implementation providing the synchronization mechanism for this disconnected RowSet object. 

     Hashtable env = new Hashtable();
     env.put(javax.sql.rowset.spi.SyncFactory.ROWSET_PROVIDER_NAME,
         "com.foo.provider.Impl");
     CachedRowSetImpl crs = new CachedRowSet(env);

Calling this constructor with a null parameter will cause the SyncFactory to provide the reference optimistic provider com.sun.rowset.providers.RIOptimisticProvider.

In addition, the following properties can be associated with the provider to assist in determining the choice of the synchronizaton provider such as:

  • ROWSET_SYNC_PROVIDER - the property specifying the the SyncProvider class name to be instantiated by the SyncFacttory
  • ROWSET_SYNC_VENDOR - the property specifying the software vendor associated with a SyncProvider implementation.
  • ROWSET_SYNC_PROVIDER_VER - the property specifying the version of the SyncProvider implementation provided by the software vendor.
More specific detailes are available in the SyncFactory and SyncProvider specificiations later in this document.

Parameters
env a Hashtable object with a list of desired synchronization providers
Throws
SQLException if the requested provider cannot be found by the synchonization factory
See Also

Public Methods

public boolean absolute (int row)

Moves this CachedRowSetImpl object's cursor to the row number specified.

If the number is positive, the cursor moves to an absolute row with respect to the beginning of the rowset. The first row is row 1, the second is row 2, and so on. For example, the following command, in which crs is a CachedRowSetImpl object, moves the cursor to the fourth row, starting from the beginning of the rowset. 



    crs.absolute(4);

If the number is negative, the cursor moves to an absolute row position with respect to the end of the rowset. For example, calling absolute(-1) positions the cursor on the last row, absolute(-2) moves it on the next-to-last row, and so on. If the CachedRowSetImpl object crs has five rows, the following command moves the cursor to the fourth-to-last row, which in the case of a rowset with five rows, is also the second row, counting from the beginning. 



    crs.absolute(-4);
If the number specified is larger than the number of rows, the cursor will move to the position after the last row. If the number specified would move the cursor one or more rows before the first row, the cursor moves to the position before the first row.

Note: Calling absolute(1) is the same as calling the method first(). Calling absolute(-1) is the same as calling last().

Parameters
row a positive number to indicate the row, starting row numbering from the first row, which is 1; a negative number to indicate the row, starting row numbering from the last row, which is -1; it must not be 0
Returns
  • true if the cursor is on the rowset; false otherwise
Throws
SQLException if the given cursor position is 0 or the type of this rowset is ResultSet.TYPE_FORWARD_ONLY

public void acceptChanges ()

Propagates all row update, insert, and delete changes to the underlying data source backing this CachedRowSetImpl object.

NoteIn the reference implementation an optimistic concurrency implementation is provided as a sample implementation of a the SyncProvider abstract class.

This method fails if any of the updates cannot be propagated back to the data source. When it fails, the caller can assume that none of the updates are reflected in the data source. When an exception is thrown, the current row is set to the first "updated" row that resulted in an exception unless the row that caused the exception is a "deleted" row. In that case, when deleted rows are not shown, which is usually true, the current row is not affected.

If no SyncProvider is configured, the reference implementation leverages the RIOptimisticProvider available which provides the default and reference synchronization capabilities for disconnected RowSets.

Throws
SQLException if the cursor is on the insert row or the underlying reference synchronization provider fails to commit the updates to the datasource
SyncProviderException if an internal error occurs within the SyncProvider instance during either during the process or at any time when the SyncProvider instance touches the data source.
See Also

public void acceptChanges (Connection con)

Propagates all row update, insert, and delete changes to the data source backing this CachedRowSetImpl object using the given Connection object.

The reference implementation RIOptimisticProvider modifies its synchronization to a write back function given the updated connection The reference implementation modifies its synchronization behaviour via the SyncProvider to ensure the synchronization occurs according to the updated JDBC Connection properties.

Parameters
con a standard JDBC Connection object
Throws
SQLException if the cursor is on the insert row or the underlying synchronization provider fails to commit the updates back to the data source
SyncProviderException
See Also

public void afterLast ()

Moves this CachedRowSetImpl object's cursor to the end of the rowset, just after the last row. This method has no effect if this rowset contains no rows.

Throws
SQLException if an error occurs

public void beforeFirst ()

Moves this CachedRowSetImpl object's cursor to the front of the rowset, just before the first row. This method has no effect if this rowset contains no rows.

Throws
SQLException if an error occurs or the type of this rowset is ResultSet.TYPE_FORWARD_ONLY

public void cancelRowUpdates ()

Rolls back any updates made to the current row of this CachedRowSetImpl object and notifies listeners that a row has changed. To have an effect, this method must be called after an updateXXX method has been called and before the method updateRow has been called. If no updates have been made or the method updateRow has already been called, this method has no effect.

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

public void clearWarnings ()

Clears all the warnings reporeted for the CachedRowSetImpl object. After a call to this method, the getWarnings method returns null until a new warning is reported for this CachedRowSetImpl object.

public void close ()

Closes this CachedRowSetImpl objecy and releases any resources it was using.

Throws
SQLException if an error occurs when releasing any resources in use by this CachedRowSetImpl object

public boolean columnUpdated (int idx)

Indicates whether the designated column of the current row of this CachedRowSetImpl object has been updated. The value returned depends on whether this rowset can detcted updates: false will always be returned if it does not detect updates.

Parameters
idx the index identifier of the column that may be have been updated.
Returns
  • true is the designated column has been updated and the rowset detects updates; false if the rowset has not been updated or the rowset does not detect updates
Throws
SQLException if the cursor is on the insert row or not on a valid row
See Also

public boolean columnUpdated (String columnName)

Indicates whether the designated column of the current row of this CachedRowSetImpl object has been updated. The value returned depends on whether this rowset can detcted updates: false will always be returned if it does not detect updates.

Parameters
columnName the String column name column that may be have been updated.
Returns
  • true is the designated column has been updated and the rowset detects updates; false if the rowset has not been updated or the rowset does not detect updates
Throws
SQLException if the cursor is on the insert row or not on a valid row
See Also

public void commit ()

Commits all changes performed by the acceptChanges() methods

Throws
SQLException
See Also

public CachedRowSet createCopy ()

Creates a RowSet object that is a deep copy of this CachedRowSetImpl object's data, including constraints. Updates made on a copy are not visible to the original rowset; a copy of a rowset is completely independent from the original.

Making a copy saves the cost of creating an identical rowset from first principles, which can be quite expensive. For example, it can eliminate the need to query a remote database server.

Returns
  • a new CachedRowSet object that is a deep copy of this CachedRowSet object and is completely independent from this CachedRowSetImpl object.
Throws
SQLException if an error occurs in generating the copy of this of the CachedRowSetImpl
See Also

public CachedRowSet createCopyNoConstraints ()

Creates a CachedRowSet object that is a copy of this CachedRowSetImpl object's data only. All constraints set in this object will not be there in the returning object. Updates made on a copy are not visible to the original rowset.

Returns
  • a new CachedRowSet object that is a deep copy of this CachedRowSetImpl object and is completely independent from this CachedRowSetImpl object
Throws
SQLException if an error occurs in generating the copy of the of the CachedRowSet
See Also

public CachedRowSet createCopySchema ()

Creates a RowSet object that is a copy of this CachedRowSetImpl object's table structure and the constraints only. There will be no data in the object being returned. Updates made on a copy are not visible to the original rowset.

This helps in getting the underlying XML schema which can be used as the basis for populating a WebRowSet.

Returns
  • a new CachedRowSet object that is a copy of this CachedRowSetImpl object's schema and retains all the constraints on the original rowset but contains no data
Throws
SQLException if an error occurs in generating the copy of the CachedRowSet object
See Also

public RowSet createShared ()

Returns a new RowSet object backed by the same data as that of this CachedRowSetImpl object and sharing a set of cursors with it. This allows cursors to interate over a shared set of rows, providing multiple views of the underlying data.

Returns
  • a RowSet object that is a copy of this CachedRowSetImpl object and shares a set of cursors with it
Throws
SQLException if an error occurs or cloning is not supported
See Also

public void deleteRow ()

Deletes the current row from this CachedRowSetImpl object and notifies listeners registered with this rowset that a row has changed. This method cannot be called when the cursor is on the insert row.

This method marks the current row as deleted, but it does not delete the row from the underlying data source. The method acceptChanges must be called to delete the row in the data source.

Throws
SQLException if (1) this method is called when the cursor is on the insert row, before the first row, or after the last row or (2) this rowset is ResultSet.CONCUR_READ_ONLY

public void execute ()

Populates this CachedRowSetImpl object with data. This form of the method uses the rowset's user, password, and url or data source name properties to create a database connection. If properties that are needed have not been set, this method will throw an exception.

Another form of this method uses an existing JDBC Connection object instead of creating a new one; therefore, it ignores the properties used for establishing a new connection.

The query specified by the command property is executed to create a ResultSet object from which to retrieve data. The current contents of the rowset are discarded, and the rowset's metadata is also (re)set. If there are outstanding updates, they are also ignored.

The method execute closes any database connections that it creates.

Throws
SQLException if an error occurs or the necessary properties have not been set

public void execute (Connection conn)

Populates this CachedRowSetImpl object with data, using the given connection to produce the result set from which data will be read. A second form of this method, which takes no arguments, uses the values from this rowset's user, password, and either url or data source properties to create a new database connection. The form of execute that is given a connection ignores these properties.

Parameters
conn A standard JDBC Connection object that this CachedRowSet object can pass to a synchronization provider to establish a connection to the data source
Throws
SQLException if an invalid Connection is supplied or an error occurs in establishing the connection to the data source
See Also

public int findColumn (String columnName)

Maps the given column name for one of this CachedRowSetImpl object's columns to its column number.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
Returns
  • the column index of the given column name
Throws
SQLException if the given column name does not match one of this rowset's column names

public boolean first ()

Moves this CachedRowSetImpl object's cursor to the first row and returns true if the operation was successful. This method also notifies registered listeners that the cursor has moved.

Returns
  • true if the cursor is on a valid row; false otherwise or if there are no rows in this CachedRowSetImpl object
Throws
SQLException if the type of this rowset is ResultSet.TYPE_FORWARD_ONLY

public Array getArray (int columnIndex)

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

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
Returns
  • an Array object representing an SQL ARRAY value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL ARRAY value
See Also

public Array getArray (String colName)

Retrieves the value of the designated column in this CachedRowSetImpl object as an Array object in the Java programming langugage.

Parameters
colName a String object that must match the SQL name of a column in this rowset, ignoring case
Returns
  • an Array object representing an SQL ARRAY value
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL ARRAY value
See Also

public InputStream getAsciiStream (String columnName)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.io.InputStream object. A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The SyncProvider will rely on the JDBC driver to do any necessary conversion from the database format into ASCII format.

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 getXXX method implicitly closes the stream.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
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 result is null.
Throws
SQLException if (1) the given column name is not the name of a column in this rowset (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL CHAR, VARCHAR, LONGVARCHAR BINARY, VARBINARY or LONGVARBINARY value. The bold SQL type designates the recommended return types that this method is used to retrieve.
See Also

public InputStream getAsciiStream (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.io.InputStream object. A column value can be retrieved as a stream of ASCII characters and then 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 get method implicitly closes the stream. . Also, a stream may return 0 for CachedRowSetImpl.available() whether there is data available or not.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
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 result is null.
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL CHAR, VARCHAR, LONGVARCHAR BINARY, VARBINARY or LONGVARBINARY value. The bold SQL type designates the recommended return types that this method is used to retrieve.
See Also

public BigDecimal getBigDecimal (String columnName)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.math.BigDecimal object.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
Returns
  • a java.math.BigDecimal value with full precision; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type that this method is used to retrieve
See Also

public BigDecimal getBigDecimal (int columnIndex, int scale)

This method is deprecated.
No replacement.

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.math.BigDecimal object.

This method is deprecated; use the version of getBigDecimal that does not take a scale parameter and returns a value with full precision.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
scale the number of digits to the right of the decimal point in the value returned
Returns
  • the column value with the specified number of digits to the right of the decimal point; if the value is SQL NULL, the result is null
Throws
SQLException if the given column index is out of bounds, the cursor is not on a valid row, or this method fails

public BigDecimal getBigDecimal (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.math.BigDecimal object.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • a java.math.BigDecimal value with full precision; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return types that this method is used to retrieve.
See Also

public BigDecimal getBigDecimal (String columnName, int scale)

This method is deprecated.
Use the getBigDecimal(String columnName) method instead

Retrieves the value stored in the designated column of the current row as a java.math.BigDecimal object.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
scale the number of digits to the right of the decimal point
Returns
  • a java.math.BugDecimal object with scale number of digits to the right of the decimal point.
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type that this method is used to retrieve.

public InputStream getBinaryStream (int columnIndex)

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

A column value can be retrieved as a stream of uninterpreted bytes and then 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 get method implicitly closes the stream. Also, a stream may return 0 for CachedRowSetImpl.available() whether there is data available or not.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • a Java input stream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL then the result is null.
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL BINARY, VARBINARY or LONGVARBINARY The bold type indicates the SQL type that this method is recommened to retrieve.
See Also

public InputStream getBinaryStream (String columnName)

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

A column value can be retrieved as a stream of uninterpreted bytes and then 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 get method implicitly closes the stream. Also, a stream may return 0 for CachedRowSetImpl.available() whether there is data available or not.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
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 (1) the given column name is unknown, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL BINARY, VARBINARY or LONGVARBINARY The bold type indicates the SQL type that this method is recommened to retrieve.
See Also

public Blob getBlob (String colName)

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

Parameters
colName a String object that must match the SQL name of a column in this rowset, ignoring case
Returns
  • a Blob object representing an SQL BLOB value
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL BLOB value
See Also

public Blob getBlob (int columnIndex)

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

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
Returns
  • a Blob object representing an SQL BLOB value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL BLOB value
See Also

public boolean getBoolean (String columnName)

Retrieves the value stored in the designated column of the current row as a boolean value.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
Returns
  • the column value as a boolean in the Java programming language; if the value is SQL NULL, the result is false
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL BOOLEAN value
See Also

public boolean getBoolean (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a boolean value.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • the column value as a boolean in the Java progamming language; if the value is SQL NULL, the result is false
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL BOOLEAN value
See Also

public byte getByte (String columnName)

Retrieves the value stored in the designated column of the current row as a byte value.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
Returns
  • the column value as a byte in the Java programming language; if the value is SQL NULL, the result is 0
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold type designates the recommended return type

public byte getByte (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a byte value.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • the column value as a byte in the Java programming language; if the value is SQL NULL, the result is 0
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type.
See Also

public byte[] getBytes (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a byte array value.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • the column value as a byte array in the Java programming language; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL BINARY, VARBINARY or LONGVARBINARY value. The bold SQL type designates the recommended return type.
See Also

public byte[] getBytes (String columnName)

Retrieves the value stored in the designated column of the current row as a byte array. The bytes represent the raw values returned by the driver.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
Returns
  • the column value as a byte array in the Java programming language; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL BINARY, VARBINARY or LONGVARBINARY values The bold SQL type designates the recommended return type.
See Also

public Reader getCharacterStream (String columnName)

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

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 getXXX method implicitly closes the stream.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
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 result is null.
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL CHAR, VARCHAR, LONGVARCHAR, BINARY, VARYBINARY or LONGVARBINARY value. The bold SQL type designates the recommended return type.

public Reader getCharacterStream (int columnIndex)

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

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 getXXX method implicitly closes the stream.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • a Java character stream that delivers the database column value as a stream of two-byte unicode characters in a java.io.Reader object. If the value is SQL NULL, the result is null.
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL CHAR, VARCHAR, LONGVARCHAR, BINARY, VARBINARY or LONGVARBINARY value. The bold SQL type designates the recommended return type.
See Also

public Clob getClob (int columnIndex)

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

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
Returns
  • a Clob object representing an SQL CLOB value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL CLOB value
See Also

public Clob getClob (String colName)

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

Parameters
colName a String object that must match the SQL name of a column in this rowset, ignoring case
Returns
  • a Clob object representing an SQL CLOB value
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL CLOB value
See Also

public Connection getConnection ()

Retrieves the Connection object passed to this CachedRowSetImpl object. This connection may be used to populate this rowset with data or to write data back to its underlying data source.

Returns
  • the Connection object passed to this rowset; may be null if there is no connection
Throws
SQLException if an error occurs

public String getCursorName ()

Retrieves the name of the SQL cursor used by this CachedRowSetImpl object.

In SQL, a result table is retrieved through a cursor that is named. The current row of a ResultSet can be updated or deleted using a positioned update/delete statement that references the cursor name. To ensure that the cursor has the proper isolation level to support an update operation, the cursor's SELECT statement should be of the form select for update. If the for update clause is omitted, positioned updates may fail.

JDBC supports this SQL feature by providing the name of the SQL cursor used by a ResultSet object. The current row of a result set is also the current row of this SQL cursor.

Note: If positioned updates are not supported, an SQLException is thrown.

Returns
  • the SQL cursor name for this CachedRowSetImpl object's cursor
Throws
SQLException if an error occurs

public Date getDate (int columnIndex, Calendar cal)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Date object, using the given Calendar object to construct an appropriate millisecond value for the date.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
cal the java.util.Calendar object to use in constructing the date
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL DATE or TIMESTAMP value

public Date getDate (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Date object.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • the column value as a java.sql.Data object; if the value is SQL NULL, the result is null
Throws
SQLException if the given column index is out of bounds, the cursor is not on a valid row, or this method fails

public Date getDate (String columnName, Calendar cal)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Date object, using the given Calendar object to construct an appropriate millisecond value for the date.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
cal the java.util.Calendar object to use in constructing the date
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL DATE or TIMESTAMP value

public Date getDate (String columnName)

Retrieves the value stored in the designated column of the current row as a java.sql.Date object.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL DATE or TIMESTAMP value

public double getDouble (String columnName)

Retrieves the value stored in the designated column of the current row of this CachedRowSetImpl object as a double value.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
Returns
  • the column value; if the value is SQL NULL, the result is 0
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return types.
See Also

public double getDouble (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a double value.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • the column value; if the value is SQL NULL, the result is 0
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type.
See Also

public float getFloat (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a float value.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • the column value; if the value is SQL NULL, the result is 0
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type.
See Also

public float getFloat (String columnName)

Retrieves the value stored in the designated column of the current row as a float value.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
Returns
  • the column value; if the value is SQL NULL, the result is 0
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type.
See Also

public int getHoldability ()

Retrieves the holdability of this ResultSet object

Returns
  • either ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
Throws
SQLException if a database error occurs

public int getInt (String columnName)

Retrieves the value stored in the designated column of the current row as an int value.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
Returns
  • the column value; if the value is SQL NULL, the result is 0
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER, BIGINT, REAL FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type.

public int getInt (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as an int value.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • the column value; if the value is SQL NULL, the result is 0
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER, BIGINT, REAL FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type.

public int[] getKeyColumns ()

Returns the columns that make a key to uniquely identify a row in this CachedRowSetImpl object.

Returns
  • an array of column numbers that constitutes a primary key for this rowset. This array should be empty if no column is representitive of a primary key
Throws
SQLException if the rowset is empty or no columns are designated as primary keys
See Also

public long getLong (String columnName)

Retrieves the value stored in the designated column of the current row as a long value.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
Returns
  • the column value; if the value is SQL NULL, the result is 0
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type.
See Also

public long getLong (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a long value.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • the column value; if the value is SQL NULL, the result is 0
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER, BIGINT, REAL FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type.
See Also

public int[] getMatchColumnIndexes ()

Retrieves the column id as int array that was set using setMatchColumn(int []) for this rowset.

Returns
  • a int array object that contains the column ids for the rowset which has this as the match columns.
Throws
SQLException if an error occurs or column index is not set

public String[] getMatchColumnNames ()

Retrieves the column name as String array that was set using setMatchColumn(String []) for this rowset.

Returns
  • a String array object that contains the column names for the rowset which has this the match columns
Throws
SQLException if an error occurs or column name is not set

public ResultSetMetaData getMetaData ()

Retrieves a ResultSetMetaData object instance that contains information about the CachedRowSet object. However, applications should cast the returned object to a RowSetMetaData interface implementation. In the reference implementation, this cast can be done on the RowSetMetaDataImpl class.

For example: 

 CachedRowSet crs = new CachedRowSetImpl();
 RowSetMetaDataImpl metaData =
     (RowSetMetaDataImpl)crs.getMetaData();
 // Set the number of columns in the RowSet object for
 // which this RowSetMetaDataImpl object was created to the
 // given number.
 metaData.setColumnCount(3);
 crs.setMetaData(metaData);

Returns
  • the ResultSetMetaData object that describes this CachedRowSetImpl object's columns
Throws
SQLException if an error occurs in generating the RowSet meta data; or if the CachedRowSetImpl is empty.
See Also

public Reader getNCharacterStream (int columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. It is intended for use when accessing NCHAR,NVARCHAR and LONGNVARCHAR columns.

Parameters
columnIndex the first column is 1, the second is 2, ...
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 a database access error occurs

public Reader getNCharacterStream (String columnName)

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. It is intended for use when accessing NCHAR,NVARCHAR and LONGNVARCHAR columns.

Parameters
columnName 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 a database access error occurs

public NClob getNClob (int i)

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

Parameters
i the first column is 1, the second is 2, ...
Returns
  • a NClob object representing the SQL NCLOB value in the specified column
Throws
SQLException if a database access error occurs

public NClob getNClob (String colName)

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

Parameters
colName the name of the column from which to retrieve the value
Returns
  • a NClob object representing the SQL NCLOB value in the specified column
Throws
SQLException if a database access error occurs

public String getNString (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. It is intended for use when accessing NCHAR,NVARCHAR and LONGNVARCHAR columns.

Parameters
columnName the SQL name of the column
Returns
  • the column value; if the value is SQL NULL, the value returned is null
Throws
SQLException if a database access error occurs

public String getNString (int columnIndex)

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. It is intended for use when accessing NCHAR,NVARCHAR and LONGNVARCHAR columns.

Parameters
columnIndex the first column is 1, the second is 2, ...
Returns
  • the column value; if the value is SQL NULL, the value returned is null
Throws
SQLException if a database access error occurs

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

Retrieves the value of the designated column in this CachedRowSetImpl object as an Object in the Java programming language, using the given java.util.Map object to custom map the value if appropriate.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
map a java.util.Map object showing the mapping from SQL type names to classes in the Java programming language
Returns
  • an Object representing the SQL value
Throws
SQLException if the given column name is not the name of a column in this rowset or the cursor is not on one of this rowset's rows or its insert row

public Object getObject (int columnIndex, Map<String, Class<?>> map)

Retrieves the value of the designated column in this CachedRowSetImpl object as an Object in the Java programming language, using the given java.util.Map object to custom map the value if appropriate.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
map a java.util.Map object showing the mapping from SQL type names to classes in the Java programming language
Returns
  • an Object representing the SQL value
Throws
SQLException if the given column index is out of bounds or the cursor is not on one of this rowset's rows or its insert row

public Object getObject (String columnName)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as an Object value.

The type of the 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 3.0 specification.

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

This implementation of the method getObject extends its behavior so that it gets the attributes of an SQL structured type as an array of Object values. This method also custom maps SQL user-defined types to classes in the Java programming language. When the specified column contains a structured or distinct value, the behavior of this method is as if it were a call to the method getObject(columnIndex, this.getStatement().getConnection().getTypeMap()).

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
Returns
  • a java.lang.Object holding the column value; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column name does not match one of this rowset's column names, (2) the cursor is not on a valid row, or (3) there is a problem getting the Class object for a custom mapping
See Also

public Object getObject (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as an Object value.

The type of the 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 3.0 specification.

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

This implementation of the method getObject extends its behavior so that it gets the attributes of an SQL structured type as an array of Object values. This method also custom maps SQL user-defined types to classes in the Java programming language. When the specified column contains a structured or distinct value, the behavior of this method is as if it were a call to the method getObject(columnIndex, this.getStatement().getConnection().getTypeMap()).

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • a java.lang.Object holding the column value; if the value is SQL NULL, the result is null
Throws
SQLException if the given column index is out of bounds, the cursor is not on a valid row, or there is a problem getting the Class object for a custom mapping
See Also

public ResultSet getOriginal ()

Returns a result set containing the original value of the rowset. The original value is the state of the CachedRowSetImpl after the last population or synchronization (whichever occured most recently) with the data source.

The cursor is positioned before the first row in the result set. Only rows contained in the result set returned by getOriginal() are said to have an original value.

Returns
  • the original result set of the rowset
Throws
SQLException if an error occurs produce the ResultSet object

public ResultSet getOriginalRow ()

Returns a result set containing the original value of the current row only. The original value is the state of the CachedRowSetImpl after the last population or synchronization (whichever occured most recently) with the data source.

Returns
  • the original result set of the row
Throws
SQLException if there is no current row
See Also

public int getPageSize ()

This is the getter function for the size of the page.

Returns
  • an integer that is the page size.

public Ref getRef (String colName)

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

Parameters
colName a String object that must match the SQL name of a column in this rowset, ignoring case
Returns
  • a Ref object representing an SQL REF value
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the column value is not an SQL REF value
See Also

public Ref getRef (int columnIndex)

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

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
Returns
  • a Ref object representing an SQL REF value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL REF value
See Also

public int getRow ()

Returns the number of the current row in this CachedRowSetImpl object. The first row is number 1, the second number 2, and so on.

Returns
  • the number of the current row; 0 if there is no current row
Throws
SQLException if an error occurs; or if the CacheRowSetImpl is empty

public RowId getRowId (String columnName)

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

Parameters
columnName the name of the column
Returns
  • the column value if the value is a SQL NULL the value returned is null
Throws
SQLException if a database access error occurs

public RowId getRowId (int columnIndex)

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

Parameters
columnIndex the first column is 1, the second 2, ...
Returns
  • the column value if the value is a SQL NULL the value returned is null
Throws
SQLException if a database access error occurs

public RowSetWarning getRowSetWarnings ()

The first warning reported by calls on this CachedRowSetImpl object is returned. Subsequent CachedRowSetImpl warnings will be chained to this SQLWarning. All RowSetWarnings warnings are generated in the disconnected environment and remain a seperate warning chain to that provided by the getWarnings method.

The warning chain is automatically cleared each time a new row is read.

Note: This warning chain only covers warnings caused by CachedRowSet (and their child interface) methods. All SQLWarnings can be obtained using the getWarnings method which tracks warnings generated by the underlying JDBC driver.

Returns
  • the first SQLWarning or null

public SQLXML getSQLXML (String colName)

Retrieves the value of the designated SQL XML parameter as a SQLXML object in the Java programming language.

Parameters
colName the name of the column from which to retrieve the value
Returns
  • a SQLXML object that maps an SQL XML value
Throws
SQLException if a database access error occurs

public SQLXML getSQLXML (int columnIndex)

Retrieves the value of the designated SQL XML parameter as a SQLXML object in the Java programming language.

Parameters
columnIndex the first column is 1, the second is 2, ...
Returns
  • a SQLXML object that maps an SQL XML value
Throws
SQLException if a database access error occurs

public short getShort (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a short value.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • the column value; if the value is SQL NULL, the result is 0
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER, BIGINT, REAL FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type.
See Also

public short getShort (String columnName)

Retrieves the value stored in the designated column of the current row as a short value.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
Returns
  • the column value; if the value is SQL NULL, the result is 0
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type.
See Also

public Statement getStatement ()

Returns null.

Returns
  • null
Throws
SQLException if an error occurs

public String getString (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a String object.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER, BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR value. The bold SQL type designates the recommended return type.

public String getString (String columnName)

Retrieves the value stored in the designated column of the current row as a String object.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TINYINT, SMALLINT, INTEGER BIGINT, REAL, FLOAT, DOUBLE, DECIMAL, NUMERIC, BIT, CHAR, VARCHAR or LONGVARCHAR< value. The bold SQL type designates the recommended return type.

public SyncProvider getSyncProvider ()

Returns the SyncProvider implementation being used with this CachedRowSetImpl implementation rowset.

Returns
  • the SyncProvider used by the rowset. If not provider was set when the rowset was instantiated, the reference implementation (default) provider is returned.
Throws
SQLException if error occurs while return the SyncProvider instance.

public String getTableName ()

Returns an identifier for the object (table) that was used to create this rowset.

Returns
  • a String object that identifies the table from which this CachedRowSetImpl object was derived
Throws
SQLException if an error occurs

public Time getTime (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Time object.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if the given column index is out of bounds, the cursor is not on a valid row, or this method fails

public Time getTime (String columnName, Calendar cal)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Time object, using the given Calendar object to construct an appropriate millisecond value for the date.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
cal the java.util.Calendar object to use in constructing the date
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TIME or TIMESTAMP value

public Time getTime (String columnName)

Retrieves the value stored in the designated column of the current row as a java.sql.Time object.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row

public Time getTime (int columnIndex, Calendar cal)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Time object, using the given Calendar object to construct an appropriate millisecond value for the date.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
cal the java.util.Calendar object to use in constructing the date
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TIME or TIMESTAMP value

public Timestamp getTimestamp (int columnIndex, Calendar cal)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Timestamp object, using the given Calendar object to construct an appropriate millisecond value for the date.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
cal the java.util.Calendar object to use in constructing the date
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TIME or TIMESTAMP value

public Timestamp getTimestamp (String columnName, Calendar cal)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Timestamp object, using the given Calendar object to construct an appropriate millisecond value for the date.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
cal the java.util.Calendar object to use in constructing the date
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL DATE, TIME, or TIMESTAMP value

public Timestamp getTimestamp (String columnName)

Retrieves the value stored in the designated column of the current row as a java.sql.Timestamp object.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row

public Timestamp getTimestamp (int columnIndex)

Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Timestamp object.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns
  • the column value; if the value is SQL NULL, the result is null
Throws
SQLException if the given column index is out of bounds, the cursor is not on a valid row, or this method fails

public URL getURL (String columnName)

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

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.net.URL object containing the resource reference described by the URL
Throws
SQLException if (1) the given column name not the name of a column in this rowset, or (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL DATALINK value.
See Also

public URL getURL (int columnIndex)

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

Parameters
columnIndex the index of the column 1 is the first, 2 is the second,...
Returns
  • a java.net.URL object containing the resource reference described by the URL
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL DATALINK value.
See Also

public InputStream getUnicodeStream (int columnIndex)

This method is deprecated.
No replacement.

A column value can be retrieved as a stream of Unicode characters and then 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 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 get method implicitly closes the stream. . Also, a stream may return 0 for available() whether there is data available or not.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
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 then the result is null.
Throws
SQLException if an error occurs

public InputStream getUnicodeStream (String columnName)

This method is deprecated.
use the method getCharacterStream instead

A column value can be retrieved as a stream of Unicode characters and then 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 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 getXXX method implicitly closes the stream.

Parameters
columnName a String object giving the SQL name of a column in this CachedRowSetImpl object
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 result is null.
Throws
SQLException if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row

public SQLWarning getWarnings ()

The first warning reported by calls on this CachedRowSetImpl object is returned. Subsequent CachedRowSetImpl warnings will be chained to this SQLWarning.

The warning chain is automatically cleared each time a new row is read.

Note: This warning chain only covers warnings caused by ResultSet methods. Any warning caused by statement methods (such as reading OUT parameters) will be chained on the Statement object.

Returns
  • the first SQLWarning or null

public void insertRow ()

Inserts the contents of this CachedRowSetImpl object's insert row into this rowset immediately following the current row. If the current row is the position after the last row or before the first row, the new row will be inserted at the end of the rowset. This method also notifies listeners registered with this rowset that the row has changed.

The cursor must be on the insert row when this method is called.

Throws
SQLException if (1) the cursor is not on the insert row, (2) one or more of the non-nullable columns in the insert row has not been given a value, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public boolean isAfterLast ()

Indicates whether the cursor is after the last row in this CachedRowSetImpl object.

Returns
  • true if the cursor is after the last row; false otherwise or if the rowset contains no rows
Throws
SQLException if an error occurs

public boolean isBeforeFirst ()

Indicates whether the cursor is before the first row in this CachedRowSetImpl object.

Returns
  • true if the cursor is before the first row; false otherwise or if the rowset contains no rows
Throws
SQLException if an error occurs

public boolean isClosed ()

Retrieves whether this ResultSet object has been closed. A ResultSet is closed if the method close has been called on it, or if it is automatically closed.

Returns
  • true if this ResultSet object is closed; false if it is still open
Throws
SQLException if a database access error occurs

public boolean isFirst ()

Indicates whether the cursor is on the first row in this CachedRowSetImpl object.

Returns
  • true if the cursor is on the first row; false otherwise or if the rowset contains no rows
Throws
SQLException if an error occurs

public boolean isLast ()

Indicates whether the cursor is on the last row in this CachedRowSetImpl object.

Note: Calling the method isLast may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in this rowset.

Returns
  • true if the cursor is on the last row; false otherwise or if this rowset contains no rows
Throws
SQLException if an error occurs

public boolean isWrapperFor (Class<?> interfaces)

Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. Returns false otherwise. If this implements the interface then return true, else if this is a wrapper then return the result of recursively calling isWrapperFor on the wrapped object. If this does not implement the interface and is not a wrapper, return false. This method should be implemented as a low-cost operation compared to unwrap so that callers can use this method to avoid expensive unwrap calls that may fail. If this method returns true then calling unwrap with the same argument should succeed.

Parameters
interfaces a Class defining an interface.
Returns
  • true if this implements the interface or directly or indirectly wraps an object that does.
Throws
SQLException

public boolean last ()

Moves this CachedRowSetImpl object's cursor to the last row and returns true if the operation was successful. This method also notifies registered listeners that the cursor has moved.

Returns
  • true if the cursor is on a valid row; false otherwise or if there are no rows in this CachedRowSetImpl object
Throws
SQLException if the type of this rowset is ResultSet.TYPE_FORWARD_ONLY

public void moveToCurrentRow ()

Moves the cursor for this CachedRowSetImpl object to the current row. The current row is the row the cursor was on when the method moveToInsertRow was called.

Calling this method has no effect unless it is called while the cursor is on the insert row.

Throws
SQLException if an error occurs

public void moveToInsertRow ()

Moves the cursor for this CachedRowSetImpl object to the insert row. The current row in the rowset is remembered while the cursor is on the insert row.

The insert row is a special row associated with an updatable rowset. It is essentially a buffer where a new row may be constructed by calling the appropriate updateXXX methods to assign a value to each column in the row. A complete row must be constructed; that is, every column that is not nullable must be assigned a value. In order for the new row to become part of this rowset, the method insertRow must be called before the cursor is moved back to the rowset.

Only certain methods may be invoked while the cursor is on the insert row; many methods throw an exception if they are called while the cursor is there. In addition to the updateXXX and insertRow methods, only the getXXX methods may be called when the cursor is on the insert row. A getXXX method should be called on a column only after an updateXXX method has been called on that column; otherwise, the value returned is undetermined.

Throws
SQLException if this CachedRowSetImpl object is ResultSet.CONCUR_READ_ONLY

public boolean next ()

Moves the cursor down one row from its current position and returns true if the new cursor position is a valid row. The cursor for a new ResultSet object is initially positioned before the first row. The first call to the method next moves the cursor to the first row, making it the current row; the second call makes the second row the current row, and so on.

If an input stream from the previous row is open, it is implicitly closed. The ResultSet object's warning chain is cleared when a new row is read.

Returns
  • true if the new current row is valid; false if there are no more rows
Throws
SQLException if an error occurs or the cursor is not positioned in the rowset, before the first row, or after the last row

public boolean nextPage ()

The nextPage gets the next page, that is a CachedRowSetImpl object containing the number of rows specified by page size.

Returns
  • boolean value true indicating whether there are more pages to come and false indicating that this is the last page.
Throws
SQLException if an error occurs or this called before calling populate.

public void populate (ResultSet data)

Populates this CachedRowSetImpl object with data from the given ResultSet object. This method is an alternative to the method execute for filling the rowset with data. The method populate does not require that the properties needed by the method execute, such as the command property, be set. This is true because the method populate is given the ResultSet object from which to get data and thus does not need to use the properties required for setting up a connection and executing this CachedRowSetImpl object's command.

After populating this rowset with data, the method populate sets the rowset's metadata and then sends a RowSetChangedEvent object to all registered listeners prior to returning.

Parameters
data the ResultSet object containing the data to be read into this CachedRowSetImpl object
Throws
SQLException if an error occurs; or the max row setting is violated while populating the RowSet
See Also

public void populate (ResultSet data, int start)

Populates this CachedRowSet object with data from the given ResultSet object. While related to the populate(ResultSet) method, an additional parameter is provided to allow starting position within the ResultSet from where to populate the CachedRowSet instance. This method is an alternative to the method execute for filling the rowset with data. The method populate does not require that the properties needed by the method execute, such as the command property, be set. This is true because the method populate is given the ResultSet object from which to get data and thus does not need to use the properties required for setting up a connection and executing this CachedRowSetImpl object's command.

After populating this rowset with data, the method populate sets the rowset's metadata and then sends a RowSetChangedEvent object to all registered listeners prior to returning.

Parameters
data the ResultSet object containing the data to be read into this CachedRowSetImpl object
start the integer specifing the position in the ResultSet object to popultate the CachedRowSetImpl object.
Throws
SQLException if an error occurs; or the max row setting is violated while populating the RowSet.Also id the start position is negative.
See Also

public boolean previous ()

Moves this CachedRowSetImpl object's cursor to the previous row and returns true if the cursor is on a valid row or false if it is not. This method also notifies all listeners registered with this CachedRowSetImpl object that its cursor has moved.

Note: calling the method previous() is not the same as calling the method relative(-1). This is true because it is possible to call previous() from the insert row, from after the last row, or from the current row, whereas relative may only be called from the current row.

The method previous may used in a while loop to iterate through a rowset starting after the last row and moving toward the beginning. The loop ends when previous returns false, meaning that there are no more rows. For example, the following code fragment retrieves all the data in the CachedRowSetImpl object crs, which has three columns. Note that the cursor must initially be positioned after the last row so that the first call to the method previous places the cursor on the last line. 

 

     crs.afterLast();
     while (previous()) {
         String name = crs.getString(1);
         int age = crs.getInt(2);
         short ssn = crs.getShort(3);
         System.out.println(name + "   " + age + "   " + ssn);
     }
This method throws an SQLException if the cursor is not on a row in the rowset, before the first row, or after the last row.

Returns
  • true if the cursor is on a valid row; false if it is before the first row or after the last row
Throws
SQLException if the cursor is not on a valid position or the type of this rowset is ResultSet.TYPE_FORWARD_ONLY

public boolean previousPage ()

Retrieves the data present in the page prior to the page from where it is called.

Returns
  • boolean value true if it retrieves the previous page, flase if it is on the first page.
Throws
SQLException if it is called before populate is called or ResultSet is of type ResultSet.TYPE_FORWARD_ONLY or if an error occurs.

public void refreshRow ()

Sets the current row with its original value and marks the row as not updated, thus undoing any changes made to the row since the last call to the methods updateRow or deleteRow. This method should be called only when the cursor is on a row in this rowset.

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

public boolean relative (int rows)

Moves the cursor the specified number of rows from the current position, with a positive number moving it forward and a negative number moving it backward.

If the number is positive, the cursor moves the specified number of rows toward the end of the rowset, starting at the current row. For example, the following command, in which crs is a CachedRowSetImpl object with 100 rows, moves the cursor forward four rows from the current row. If the current row is 50, the cursor would move to row 54. 



    crs.relative(4);

If the number is negative, the cursor moves back toward the beginning the specified number of rows, starting at the current row. For example, calling the method absolute(-1) positions the cursor on the last row, absolute(-2) moves it on the next-to-last row, and so on. If the CachedRowSetImpl object crs has five rows, the following command moves the cursor to the fourth-to-last row, which in the case of a rowset with five rows, is also the second row from the beginning. 



    crs.absolute(-4);
If the number specified is larger than the number of rows, the cursor will move to the position after the last row. If the number specified would move the cursor one or more rows before the first row, the cursor moves to the position before the first row. In both cases, this method throws an SQLException.

Note: Calling absolute(1) is the same as calling the method first(). Calling absolute(-1) is the same as calling last(). Calling relative(0) is valid, but it does not change the cursor position.

Parameters
rows an int indicating the number of rows to move the cursor, starting at the current row; a positive number moves the cursor forward; a negative number moves the cursor backward; must not move the cursor past the valid rows
Returns
  • true if the cursor is on a row in this CachedRowSetImpl object; false otherwise
Throws
SQLException if there are no rows in this rowset, the cursor is positioned either before the first row or after the last row, or the rowset is type ResultSet.TYPE_FORWARD_ONLY

public void release ()

Releases the current contents of this CachedRowSetImpl object and sends a rowSetChanged event object to all registered listeners.

Throws
SQLException if an error occurs flushing the contents of RowSet.
See Also

public void restoreOriginal ()

Restores this CachedRowSetImpl object to its original state, that is, its state before the last set of changes.

Before returning, this method moves the cursor before the first row and sends a rowSetChanged event to all registered listeners.

Throws
SQLException if an error is occurs rolling back the RowSet state to the definied original value.
See Also

public void rollback (Savepoint s)

Rolls back all changes performed by the acceptChanges() to the last Savepoint transaction marker.

Parameters
s A Savepoint transaction marker
Throws
SQLException
See Also

public void rollback ()

Rolls back all changes performed by the acceptChanges() methods

Throws
SQLException
See Also

public boolean rowDeleted ()

Indicates whether the current row has been deleted. A deleted row may leave a visible "hole" in a rowset. This method can be used to detect such holes if the rowset can detect deletions. This method will always return false if this rowset cannot detect deletions.

Returns
  • true if (1)the current row is blank, indicating that the row has been deleted, and (2)deletions are detected; false otherwise
Throws
SQLException if the cursor is on a valid row in this rowset
See Also

public boolean rowInserted ()

Indicates whether the current row has been inserted. The value returned depends on whether or not the rowset can detect visible inserts.

Returns
  • true if a row has been inserted and inserts are detected; false otherwise
Throws
SQLException if the cursor is on the insert row or not not on a valid row
See Also

public void rowSetPopulated (RowSetEvent event, int numRows)

Notifies registered listeners that a RowSet object in the given RowSetEvent object has populated a number of additional rows. The numRows parameter ensures that this event will only be fired every numRow.

The source of the event can be retrieved with the method event.getSource.

Parameters
event a RowSetEvent object that contains the RowSet object that is the source of the events
numRows when populating, the number of rows interval on which the CachedRowSet populated should fire; the default value is zero; cannot be less than fetchSize or zero
Throws
SQLException

public boolean rowUpdated ()

Indicates whether the current row of this CachedRowSetImpl object has been updated. The value returned depends on whether this rowset can detect updates: false will always be returned if it does not detect updates.

Returns
  • true if the row has been visibly updated by the owner or another and updates are detected; false otherwise
Throws
SQLException if the cursor is on the insert row or not not on a valid row
See Also

public void setAsciiStream (String parameterName, InputStream x, int length)

Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Parameters
parameterName the name of the parameter
x the Java input stream that contains the ASCII parameter value
length the number of bytes in the stream
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setAsciiStream (String parameterName, InputStream x)

Sets the designated parameter to the given input stream. When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setAsciiStream which takes a length parameter.

Parameters
parameterName the name of the parameter
x the Java input stream that contains the ASCII parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setBigDecimal (String parameterName, BigDecimal x)

Sets the designated parameter to the given java.math.BigDecimal value. The driver converts this to an SQL NUMERIC value when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setBinaryStream (String parameterName, InputStream x, int length)

Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream object. The data will be read from the stream as needed until end-of-file is reached.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Parameters
parameterName the name of the parameter
x the java input stream which contains the binary parameter value
length the number of bytes in the stream
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setBinaryStream (String parameterName, InputStream x)

Sets the designated parameter to the given input stream. When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream object. The data will be read from the stream as needed until end-of-file is reached.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setBinaryStream which takes a length parameter.

Parameters
parameterName the name of the parameter
x the java input stream which contains the binary parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setBlob (int parameterIndex, InputStream inputStream, long length)

Sets the designated parameter to a InputStream object. The inputstream must contain the number of characters specified by length otherwise a SQLException will be generated when the PreparedStatement is executed. This method differs from the setBinaryStream (int, InputStream, int) method because it informs the driver that the parameter value should be sent to the server as a BLOB. When the setBinaryStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARBINARY or a BLOB

Parameters
parameterIndex index of the first parameter is 1, the second is 2, ...
inputStream An object that contains the data to set the parameter value to.
length the number of bytes in the parameter data.
Throws
SQLException if a database access error occurs, this method is called on a closed PreparedStatement, if parameterIndex does not correspond to a parameter marker in the SQL statement, if the length specified is less than zero or if the number of bytes in the inputstream does not match the specfied length.
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setBlob (String parameterName, Blob x)

Sets the designated parameter to the given java.sql.Blob object. The driver converts this to an SQL BLOB value when it sends it to the database.

Parameters
parameterName the name of the parameter
x a Blob object that maps an SQL BLOB value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setBlob (int parameterIndex, InputStream inputStream)

Sets the designated parameter to a InputStream object. This method differs from the setBinaryStream (int, InputStream) method because it informs the driver that the parameter value should be sent to the server as a BLOB. When the setBinaryStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARBINARY or a BLOB

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setBlob which takes a length parameter.

Parameters
parameterIndex index of the first parameter is 1, the second is 2, ...
inputStream An object that contains the data to set the parameter value to.
Throws
SQLException if a database access error occurs, this method is called on a closed PreparedStatement or if parameterIndex does not correspond to a parameter marker in the SQL statement,
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setBlob (String parameterName, InputStream inputStream, long length)

Sets the designated parameter to a InputStream object. The inputstream must contain the number of characters specified by length, otherwise a SQLException will be generated when the CallableStatement is executed. This method differs from the setBinaryStream (int, InputStream, int) method because it informs the driver that the parameter value should be sent to the server as a BLOB. When the setBinaryStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARBINARY or a BLOB

Parameters
parameterName the name of the parameter to be set the second is 2, ...
inputStream An object that contains the data to set the parameter value to.
length the number of bytes in the parameter data.
Throws
SQLException if parameterIndex does not correspond to a parameter marker in the SQL statement, or if the length specified is less than zero; if the number of bytes in the inputstream does not match the specfied length; if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setBlob (String parameterName, InputStream inputStream)

Sets the designated parameter to a InputStream object. This method differs from the setBinaryStream (int, InputStream) method because it informs the driver that the parameter value should be sent to the server as a BLOB. When the setBinaryStream method is used, the driver may have to do extra work to determine whether the parameter data should be send to the server as a LONGVARBINARY or a BLOB

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setBlob which takes a length parameter.

Parameters
parameterName the name of the parameter
inputStream An object that contains the data to set the parameter value to.
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setBoolean (String parameterName, boolean x)

Sets the designated parameter to the given Java boolean value. The driver converts this to an SQL BIT or BOOLEAN value when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setByte (String parameterName, byte x)

Sets the designated parameter to the given Java byte value. The driver converts this to an SQL TINYINT value when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setBytes (String parameterName, byte[] x)

Sets the designated parameter to the given Java array of bytes. The driver converts this to an SQL VARBINARY or LONGVARBINARY (depending on the argument's size relative to the driver's limits on VARBINARY values) when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setCharacterStream (String parameterName, Reader reader, int length)

Sets the designated parameter to the given Reader object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Parameters
parameterName the name of the parameter
reader the java.io.Reader object that contains the UNICODE data used as the designated parameter
length the number of characters in the stream
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setCharacterStream (String parameterName, Reader reader)

Sets the designated parameter to the given Reader object. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setCharacterStream which takes a length parameter.

Parameters
parameterName the name of the parameter
reader the java.io.Reader object that contains the Unicode data
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setClob (int parameterIndex, Reader reader, long length)

Sets the designated parameter to a Reader object. The reader must contain the number of characters specified by length otherwise a SQLException will be generated when the PreparedStatement is executed. This method differs from the setCharacterStream (int, Reader, int) method because it informs the driver that the parameter value should be sent to the server as a CLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARCHAR or a CLOB

Parameters
parameterIndex index of the first parameter is 1, the second is 2, ...
reader An object that contains the data to set the parameter value to.
length the number of characters in the parameter data.
Throws
SQLException if a database access error occurs, this method is called on a closed PreparedStatement, if parameterIndex does not correspond to a parameter marker in the SQL statement, or if the length specified is less than zero.
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setClob (String parameterName, Clob x)

Sets the designated parameter to the given java.sql.Clob object. The driver converts this to an SQL CLOB value when it sends it to the database.

Parameters
parameterName the name of the parameter
x a Clob object that maps an SQL CLOB value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setClob (String parameterName, Reader reader)

Sets the designated parameter to a Reader object. This method differs from the setCharacterStream (int, Reader) method because it informs the driver that the parameter value should be sent to the server as a CLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be send to the server as a LONGVARCHAR or a CLOB

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setClob which takes a length parameter.

Parameters
parameterName the name of the parameter
reader An object that contains the data to set the parameter value to.
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setClob (String parameterName, Reader reader, long length)

Sets the designated parameter to a Reader object. The reader must contain the number of characters specified by length otherwise a SQLException will be generated when the CallableStatement is executed. This method differs from the setCharacterStream (int, Reader, int) method because it informs the driver that the parameter value should be sent to the server as a CLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be send to the server as a LONGVARCHAR or a CLOB

Parameters
parameterName the name of the parameter to be set
reader An object that contains the data to set the parameter value to.
length the number of characters in the parameter data.
Throws
SQLException if parameterIndex does not correspond to a parameter marker in the SQL statement; if the length specified is less than zero; a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setClob (int parameterIndex, Reader reader)

Sets the designated parameter to a Reader object. This method differs from the setCharacterStream (int, Reader) method because it informs the driver that the parameter value should be sent to the server as a CLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARCHAR or a CLOB

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setClob which takes a length parameter.

Parameters
parameterIndex index of the first parameter is 1, the second is 2, ...
reader An object that contains the data to set the parameter value to.
Throws
SQLException if a database access error occurs, this method is called on a closed PreparedStatementor if parameterIndex does not correspond to a parameter marker in the SQL statement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setCommand (String cmd)

Sets this CachedRowSetImpl object's command property to the given String object and clears the parameters, if any, that were set for the previous command.

The command property may not be needed if the rowset is produced by a data source, such as a spreadsheet, that does not support commands. Thus, this property is optional and may be null.

Parameters
cmd a String object containing an SQL query that will be set as the command; may be null
Throws
SQLException if an error occurs

public void setDate (String parameterName, Date x)

Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application. The driver converts this to an SQL DATE value when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setDate (String parameterName, Date x, Calendar cal)

Sets the designated parameter to the given java.sql.Date value, using the given Calendar object. The driver uses the Calendar object to construct an SQL DATE value, which the driver then sends to the database. With a a Calendar object, the driver can calculate the date taking into account a custom timezone. If no Calendar object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.

Parameters
parameterName the name of the parameter
x the parameter value
cal the Calendar object the driver will use to construct the date
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setDouble (String parameterName, double x)

Sets the designated parameter to the given Java double value. The driver converts this to an SQL DOUBLE value when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setFloat (String parameterName, float x)

Sets the designated parameter to the given Java float value. The driver converts this to an SQL FLOAT value when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setInt (String parameterName, int x)

Sets the designated parameter to the given Java int value. The driver converts this to an SQL INTEGER value when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setKeyColumns (int[] keys)

Sets this CachedRowSetImpl object's keyCols field with the given array of column numbers, which forms a key for uniquely identifying a row in this rowset.

Parameters
keys an array of int indicating the columns that form a primary key for this CachedRowSetImpl object; every element in the array must be greater than 0 and less than or equal to the number of columns in this rowset
Throws
SQLException if any of the numbers in the given array is not valid for this rowset
See Also

public void setLong (String parameterName, long x)

Sets the designated parameter to the given Java long value. The driver converts this to an SQL BIGINT value when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setMatchColumn (int columnIdx)

Sets the designated parameter to the given int object. This forms the basis of the join for the JoinRowSet as the column which will form the basis of the join.

The parameter value set by this method is stored internally and will be supplied as the appropriate parameter in this rowset's command when the method getMatchColumn is called.

Parameters
columnIdx the index into this rowset object's internal representation of parameter values; the first parameter is 0, the second is 1, and so on; must be 0 or greater
Throws
SQLException if an error occurs or the parameter index is out of bounds

public void setMatchColumn (String[] columnNames)

Sets the designated parameter to the given String array. This forms the basis of the join for the JoinRowSet as the column which will form the basis of the join.

The parameter value set by this method is stored internally and will be supplied as the appropriate parameter in this rowset's command when the method getMatchColumn is called.

Parameters
columnNames the name of the column into this rowset object's internal representation of parameter values
Throws
SQLException if an error occurs or the parameter index is out of bounds

public void setMatchColumn (int[] columnIdxes)

Sets the designated parameter to the given int array. This forms the basis of the join for the JoinRowSet as the column which will form the basis of the join.

The parameter value set by this method is stored internally and will be supplied as the appropriate parameter in this rowset's command when the method getMatchColumnIndexes is called.

Parameters
columnIdxes the indexes into this rowset object's internal representation of parameter values; the first parameter is 0, the second is 1, and so on; must be 0 or greater
Throws
SQLException if an error occurs or the parameter index is out of bounds

public void setMatchColumn (String columnName)

Sets the designated parameter to the given String object. This forms the basis of the join for the JoinRowSet as the column which will form the basis of the join.

The parameter value set by this method is stored internally and will be supplied as the appropriate parameter in this rowset's command when the method getMatchColumn is called.

Parameters
columnName the name of the column into this rowset object's internal representation of parameter values
Throws
SQLException if an error occurs or the parameter index is out of bounds

public void setMetaData (RowSetMetaData md)

Sets the metadata for this CachedRowSetImpl object with the given RowSetMetaData object.

Parameters
md a RowSetMetaData object instance containing metadata about the columsn in the rowset
Throws
SQLException if invalid meta data is supplied to the rowset

public void setNCharacterStream (int parameterIndex, Reader value)

Sets the designated parameter to a Reader object. The Reader reads the data till end-of-file is reached. The driver does the necessary conversion from Java character format to the national character set in the database.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setNCharacterStream which takes a length parameter.

Parameters
parameterIndex of the first parameter is 1, the second is 2, ...
value the parameter value
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; if a database access error occurs; or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setNCharacterStream (String parameterName, Reader value)

Sets the designated parameter to a Reader object. The Reader reads the data till end-of-file is reached. The driver does the necessary conversion from Java character format to the national character set in the database.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setNCharacterStream which takes a length parameter.

Parameters
parameterName the name of the parameter
value the parameter value
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; if a database access error occurs; or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setNCharacterStream (String parameterName, Reader value, long length)

Sets the designated parameter to a Reader object. The Reader reads the data till end-of-file is reached. The driver does the necessary conversion from Java character format to the national character set in the database.

Parameters
parameterName the name of the column to be set
value the parameter value
length the number of characters in the parameter data.
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs

public void setNCharacterStream (int parameterIndex, Reader value, long length)

Sets the designated parameter to a Reader object. The Reader reads the data till end-of-file is reached. The driver does the necessary conversion from Java character format to the national character set in the database.

Parameters
parameterIndex of the first parameter is 1, the second is 2, ...
value the parameter value
length the number of characters in the parameter data.
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; or if a database access error occurs

public void setNClob (int parameterIndex, Reader reader)

Sets the designated parameter to a Reader object. This method differs from the setCharacterStream (int, Reader) method because it informs the driver that the parameter value should be sent to the server as a NCLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGNVARCHAR or a NCLOB

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setNClob which takes a length parameter.

Parameters
parameterIndex index of the first parameter is 1, the second is 2, ...
reader An object that contains the data to set the parameter value to.
Throws
SQLException if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setNClob (String parameterName, Reader reader)

Sets the designated parameter to a Reader object. This method differs from the setCharacterStream (int, Reader) method because it informs the driver that the parameter value should be sent to the server as a NCLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be send to the server as a LONGNVARCHAR or a NCLOB

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setNClob which takes a length parameter.

Parameters
parameterName the name of the parameter
reader An object that contains the data to set the parameter value to.
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setNClob (int parameterIndex, NClob value)

Sets the designated parameter to a java.sql.NClob object. The driver converts this to a SQL NCLOB value when it sends it to the database.

Parameters
parameterIndex of the first parameter is 1, the second is 2, ...
value the parameter value
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; or if a database access error occurs

public void setNClob (String parameterName, Reader reader, long length)

Sets the designated parameter to a Reader object. The reader must contain the number of characters specified by length otherwise a SQLException will be generated when the CallableStatement is executed. This method differs from the setCharacterStream (int, Reader, int) method because it informs the driver that the parameter value should be sent to the server as a NCLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be send to the server as a LONGNVARCHAR or a NCLOB

Parameters
parameterName the name of the parameter to be set
reader An object that contains the data to set the parameter value to.
length the number of characters in the parameter data.
Throws
SQLException if parameterIndex does not correspond to a parameter marker in the SQL statement; if the length specified is less than zero; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setNClob (String parameterName, NClob value)

Sets the designated parameter to a java.sql.NClob object. The object implements the java.sql.NClob interface. This NClob object maps to a SQL NCLOB.

Parameters
parameterName the name of the column to be set
value the parameter value
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs

public void setNClob (int parameterIndex, Reader reader, long length)

Sets the designated parameter to a Reader object. The reader must contain the number of characters specified by length otherwise a SQLException will be generated when the PreparedStatement is executed. This method differs from the setCharacterStream (int, Reader, int) method because it informs the driver that the parameter value should be sent to the server as a NCLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGNVARCHAR or a NCLOB

Parameters
parameterIndex index of the first parameter is 1, the second is 2, ...
reader An object that contains the data to set the parameter value to.
length the number of characters in the parameter data.
Throws
SQLException if parameterIndex does not correspond to a parameter marker in the SQL statement; if the length specified is less than zero; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setNString (String parameterName, String value)

Sets the designated paramter to the given String object. The driver converts this to a SQL NCHAR or NVARCHAR or LONGNVARCHAR

Parameters
parameterName the name of the column to be set
value the parameter value
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs

public void setNString (int parameterIndex, String value)

Sets the designated paramter to the given String object. The driver converts this to a SQL NCHAR or NVARCHAR or LONGNVARCHAR value (depending on the argument's size relative to the driver's limits on NVARCHAR values) when it sends it to the database.

Parameters
parameterIndex of the first parameter is 1, the second is 2, ...
value the parameter value
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; or if a database access error occurs

public void setNull (String parameterName, int sqlType)

Sets the designated parameter to SQL NULL.

Note: You must specify the parameter's SQL type.

Parameters
parameterName the name of the parameter
sqlType the SQL type code defined in java.sql.Types
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setNull (String parameterName, int sqlType, String typeName)

Sets the designated parameter to SQL NULL. This version of the method setNull should be used for user-defined types and REF type parameters. Examples of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types.

Note: To be portable, applications must give the SQL type code and the fully-qualified SQL type name when specifying a NULL user-defined or REF parameter. In the case of a user-defined type the name is the type name of the parameter itself. For a REF parameter, the name is the type name of the referenced type. If a JDBC driver does not need the type code or type name information, it may ignore it. Although it is intended for user-defined and Ref parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the given typeName is ignored.

Parameters
parameterName the name of the parameter
sqlType a value from java.sql.Types
typeName the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQL REF value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void setObject (String parameterName, Object x)

Sets the value of the designated parameter with the given object. The second parameter must be of type Object; therefore, the java.lang equivalent objects should be used for built-in types.

The JDBC specification specifies a standard mapping from Java Object types to SQL types. The given argument will be converted to the corresponding SQL type before being sent to the database.

Note that this method may be used to pass datatabase- specific abstract data types, by using a driver-specific Java type. If the object is of a class implementing the interface SQLData, the JDBC driver should call the method SQLData.writeSQL to write it to the SQL data stream. If, on the other hand, the object is of a class implementing Ref, Blob, Clob, NClob, Struct, java.net.URL, or Array, the driver should pass it to the database as a value of the corresponding SQL type.

This method throws an exception if there is an ambiguity, for example, if the object is of a class implementing more than one of the interfaces named above.

Parameters
parameterName the name of the parameter
x the object containing the input parameter value
Throws
SQLException if a database access error occurs, this method is called on a closed CallableStatement or if the given Object parameter is ambiguous
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setObject (String parameterName, Object x, int targetSqlType)

Sets the value of the designated parameter with the given object. This method is like the method setObject above, except that it assumes a scale of zero.

Parameters
parameterName the name of the parameter
x the object containing the input parameter value
targetSqlType the SQL type (as defined in java.sql.Types) to be sent to the database
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if targetSqlType is a ARRAY, BLOB, CLOB, DATALINK, JAVA_OBJECT, NCHAR, NCLOB, NVARCHAR, LONGNVARCHAR, REF, ROWID, SQLXML or STRUCT data type and the JDBC driver does not support this data type
See Also

public void setObject (String parameterName, Object x, int targetSqlType, int scale)

Sets the value of the designated parameter with the given object. The second argument must be an object type; for integral values, the java.lang equivalent objects should be used.

The given Java object will be converted to the given targetSqlType before being sent to the database. If the object has a custom mapping (is of a class implementing the interface SQLData), the JDBC driver should call the method SQLData.writeSQL to write it to the SQL data stream. If, on the other hand, the object is of a class implementing Ref, Blob, Clob, NClob, Struct, java.net.URL, or Array, the driver should pass it to the database as a value of the corresponding SQL type.

Note that this method may be used to pass datatabase- specific abstract data types.

Parameters
parameterName the name of the parameter
x the object containing the input parameter value
targetSqlType the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.
scale for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types, this value will be ignored.
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if targetSqlType is a ARRAY, BLOB, CLOB, DATALINK, JAVA_OBJECT, NCHAR, NCLOB, NVARCHAR, LONGNVARCHAR, REF, ROWID, SQLXML or STRUCT data type and the JDBC driver does not support this data type
See Also

public void setOriginal ()

Marks all rows in this rowset as being original rows. Any updates made to the rows become the original values for the rowset. Calls to the method setOriginal connot be reversed.

Throws
SQLException if an error occurs

public void setOriginalRow ()

Marks the current row in this rowset as being an original row.

Throws
SQLException if there is no current row
See Also

public void setPageSize (int size)

This is the setter function for setting the size of the page, which specifies how many rows have to be retrived at a time.

Parameters
size which is the page size
Throws
SQLException if size is less than zero or greater than max rows.

public void setRowId (int parameterIndex, RowId x)

Sets the designated parameter to the given java.sql.RowId object. The driver converts this to a SQL ROWID value when it sends it to the database

Parameters
parameterIndex the first parameter is 1, the second is 2, ...
x the parameter value
Throws
SQLException if a database access error occurs

public void setRowId (String parameterName, RowId x)

Sets the designated parameter to the given java.sql.RowId object. The driver converts this to a SQL ROWID when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs

public void setRowInserted (boolean insertFlag)

Sets the status for the row on which the cursor is positioned. The insertFlag is used to mention the toggle status for this row

Parameters
insertFlag if it is true - marks this row as inserted if it is false - marks it as not a newly inserted row
Throws
SQLException if an error occurs while doing this operation

public void setSQLXML (int parameterIndex, SQLXML xmlObject)

Sets the designated parameter to the given java.sql.SQLXML object. The driver converts this to an SQL XML value when it sends it to the database.

Parameters
parameterIndex index of the first parameter is 1, the second is 2, ...
xmlObject a SQLXML object that maps an SQL XML value
Throws
SQLException if a database access error occurs

public void setSQLXML (String parameterName, SQLXML xmlObject)

Sets the designated parameter to the given java.sql.SQLXML object. The driver converts this to an SQL XML value when it sends it to the database.

Parameters
parameterName the name of the parameter
xmlObject a SQLXML object that maps an SQL XML value
Throws
SQLException if a database access error occurs

public void setShort (String parameterName, short x)

Sets the designated parameter to the given Java short value. The driver converts this to an SQL SMALLINT value when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setString (String parameterName, String x)

Sets the designated parameter to the given Java String value. The driver converts this to an SQL VARCHAR or LONGVARCHAR value (depending on the argument's size relative to the driver's limits on VARCHAR values) when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setSyncProvider (String providerStr)

Sets the active SyncProvider and attempts to load load the new provider using the SyncFactory SPI.

Parameters
providerStr a String object giving the fully qualified class name of a SyncProvider implementation
Throws
SQLException if an error occurs while resetting the SyncProvider.

public void setTableName (String tabName)

Sets the identifier for the table from which this rowset was derived to the given table name.

Parameters
tabName a String object that identifies the table from which this CachedRowSetImpl object was derived
Throws
SQLException if an error occurs

public void setTime (String parameterName, Time x)

Sets the designated parameter to the given java.sql.Time value. The driver converts this to an SQL TIME value when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setTime (String parameterName, Time x, Calendar cal)

Sets the designated parameter to the given java.sql.Time value, using the given Calendar object. The driver uses the Calendar object to construct an SQL TIME value, which the driver then sends to the database. With a a Calendar object, the driver can calculate the time taking into account a custom timezone. If no Calendar object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.

Parameters
parameterName the name of the parameter
x the parameter value
cal the Calendar object the driver will use to construct the time
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setTimestamp (String parameterName, Timestamp x, Calendar cal)

Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object. The driver uses the Calendar object to construct an SQL TIMESTAMP value, which the driver then sends to the database. With a a Calendar object, the driver can calculate the timestamp taking into account a custom timezone. If no Calendar object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.

Parameters
parameterName the name of the parameter
x the parameter value
cal the Calendar object the driver will use to construct the timestamp
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setTimestamp (String parameterName, Timestamp x)

Sets the designated parameter to the given java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value when it sends it to the database.

Parameters
parameterName the name of the parameter
x the parameter value
Throws
SQLException if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method
See Also

public void setURL (int parameterIndex, URL x)

Sets the designated parameter to the given java.net.URL value. The driver converts this to an SQL DATALINK value when it sends it to the database.

Parameters
parameterIndex the first parameter is 1, the second is 2, ...
x the java.net.URL object to be set
Throws
SQLException if a database access error occurs or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public int size ()

Returns the number of rows in this CachedRowSetImpl object.

Returns
  • number of rows in the rowset

public Collection<?> toCollection ()

Converts this CachedRowSetImpl object to a collection of tables. The sample implementation utilitizes the TreeMap collection type. This class guarantees that the map will be in ascending key order, sorted according to the natural order for the key's class.

Returns
  • a Collection object consisting of tables, each of which is a copy of a row in this CachedRowSetImpl object
Throws
SQLException if an error occurs in generating the collection
See Also

public Collection<?> toCollection (String column)

Returns the specified column of this CachedRowSetImpl object as a Collection object. This method makes a copy of the column's data and utilitizes the Vector to establish the collection. The Vector class implements a growable array objects allowing the individual components to be accessed using an an integer index similar to that of an array.

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 value(s) stored in the specified column of this CachedRowSetImpl object
Throws
SQLException if an error occurs generated the collection; or an invalid column is provided.
See Also

public Collection<?> toCollection (int column)

Returns the specified column of this CachedRowSetImpl object as a Collection object. This method makes a copy of the column's data and utilitizes the Vector to establish the collection. The Vector class implements a growable array objects allowing the individual components to be accessed using an an integer index similar to that of an array.

Parameters
column an int indicating the column whose values are to be represented in a Collection object
Returns
  • a Collection object that contains the value(s) stored in the specified column of this CachedRowSetImpl object
Throws
SQLException if an error occurs generated the collection; or an invalid column is provided.
See Also

public void undoDelete ()

Cancels deletion of the current row and notifies listeners that a row has changed.

Note: This method can be ignored if deleted rows are not being shown, which is the normal case.

Throws
SQLException if the cursor is not on a valid row

public void undoInsert ()

Immediately removes the current row from this CachedRowSetImpl object if the row has been inserted, and also notifies listeners the a row has changed. An exception is thrown if the row is not a row that has been inserted or the cursor is before the first row, after the last row, or on the insert row.

This operation cannot be undone.

Throws
SQLException if an error occurs, the cursor is not on a valid row, or the row has not been inserted

public void undoUpdate ()

Immediately reverses the last update operation if the row has been modified. This method can be called to reverse updates on a all columns until all updates in a row have been rolled back to their originating state since the last synchronization (acceptChanges) or population. This method may also be called while performing updates to the insert row.

undoUpdate

Throws
SQLException if cursor is before the first row, after the last row in rowset.
See Also

public void unsetMatchColumn (int[] columnIdxes)

Unsets the designated parameter to the given int array. This was set using setMatchColumn as the column which will form the basis of the join.

The parameter value unset by this method should be same as was set.

Parameters
columnIdxes the index into this rowset object's internal representation of parameter values
Throws
SQLException if an error occurs or the parameter index is out of bounds or if the columnIdx is not the same as set using setMatchColumn(int [])

public void unsetMatchColumn (String[] columnIdxes)

Unsets the designated parameter to the given String array. This was set using setMatchColumn as the column which will form the basis of the join.

The parameter value unset by this method should be same as was set.

Parameters
columnIdxes the index into this rowset object's internal representation of parameter values
Throws
SQLException if an error occurs or the parameter index is out of bounds or if the columnName is not the same as set using setMatchColumn(String [])

public void unsetMatchColumn (String columnName)

Unsets the designated parameter to the given String object. This was set using setMatchColumn as the column which will form the basis of the join.

The parameter value unset by this method should be same as was set.

Parameters
columnName the index into this rowset object's internal representation of parameter values
Throws
SQLException if an error occurs or the parameter index is out of bounds or if the columnName is not the same as set using setMatchColumn(String)

public void unsetMatchColumn (int columnIdx)

Unsets the designated parameter to the given int object. This was set using setMatchColumn as the column which will form the basis of the join.

The parameter value unset by this method should be same as was set.

Parameters
columnIdx the index into this rowset object's internal representation of parameter values
Throws
SQLException if an error occurs or the parameter index is out of bounds or if the columnIdx is not the same as set using setMatchColumn(int)

public T unwrap (Class<T> iface)

Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. If the receiver implements the interface then the result is the receiver or a proxy for the receiver. If the receiver is a wrapper and the wrapped object implements the interface then the result is the wrapped object or a proxy for the wrapped object. Otherwise return the the result of calling unwrap recursively on the wrapped object or a proxy for that result. If the receiver is not a wrapper and does not implement the interface, then an SQLException is thrown.

Parameters
iface A Class defining an interface that the result must implement.
Returns
  • an object that implements the interface. May be a proxy for the actual implementing object.
Throws
SQLException

public void updateArray (int columnIndex, Array a)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.sql.Array values. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
a the new column Array value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateArray (String columnName, Array a)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.sql.Array value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
a the new column Array value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

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

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given ASCII stream value.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
length the number of one-byte ASCII characters in the stream
Throws
SQLException

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

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.

Parameters
columnIndex the first column is 1, the second is 2, ...
x the new column value
length the length of the stream
Throws
SQLException 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

public void updateAsciiStream (int columnIndex, InputStream x)

Updates the designated column with an ascii stream 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.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateAsciiStream which takes a length parameter.

Parameters
columnIndex the first column is 1, the second is 2, ...
x the new column value
Throws
SQLException 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

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

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.

Parameters
columnLabel 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 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

public void updateAsciiStream (String columnLabel, InputStream x)

Updates the designated column with an ascii stream 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.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateAsciiStream which takes a length parameter.

Parameters
columnLabel the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column
x the new column value
Throws
SQLException 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

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

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given ASCII stream value.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
length the number of one-byte ASCII characters in the stream
Throws
SQLException if this method is invoked

public void updateBigDecimal (int columnIndex, BigDecimal x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.math.BigDecimal object.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateBigDecimal (String columnName, BigDecimal x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.math.BigDecimal object.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateBinaryStream (int columnIndex, InputStream x)

Updates the designated column with a binary stream 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.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateBinaryStream which takes a length parameter.

Parameters
columnIndex the first column is 1, the second is 2, ...
x the new column value
Throws
SQLException 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

public void updateBinaryStream (String columnLabel, InputStream x)

Updates the designated column with a binary stream 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.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateBinaryStream which takes a length parameter.

Parameters
columnLabel the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column
x the new column value
Throws
SQLException 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

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

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.io.InputStream object.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value; must be a java.io.InputStream containing BINARY, VARBINARY, or LONGVARBINARY data
length the length of the stream in bytes
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the data in the stream is not binary, or (4) this rowset is ResultSet.CONCUR_READ_ONLY

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

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.

Parameters
columnIndex the first column is 1, the second is 2, ...
x the new column value
length the length of the stream
Throws
SQLException 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

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

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.

Parameters
columnLabel 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 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

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

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.io.InputStream object.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value; must be a java.io.InputStream containing BINARY, VARBINARY, or LONGVARBINARY data
length the length of the stream in bytes
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the data in the stream is not binary, or (4) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateBlob (int columnIndex, Blob b)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.sql.Blob value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
b the new column Blob value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

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

Updates the designated column using the given input stream, which will have the specified number of bytes. When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

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.

Parameters
columnLabel 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
inputStream An object that contains the data to set the parameter value to.
length the number of bytes in the parameter data.
Throws
SQLException 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

public void updateBlob (int columnIndex, InputStream inputStream)

Updates the designated column using the given input stream. When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateBlob which takes a length parameter.

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.

Parameters
columnIndex the first column is 1, the second is 2, ...
inputStream An object that contains the data to set the parameter value to.
Throws
SQLException 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

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

Updates the designated column using the given input stream, which will have the specified number of bytes. When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

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.

Parameters
columnIndex the first column is 1, the second is 2, ...
inputStream An object that contains the data to set the parameter value to.
length the number of bytes in the parameter data.
Throws
SQLException 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

public void updateBlob (String columnName, Blob b)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.sql.Blob value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
b the new column Blob value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateBlob (String columnLabel, InputStream inputStream)

Updates the designated column using the given input stream. When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateBlob which takes a length parameter.

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.

Parameters
columnLabel the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column
inputStream An object that contains the data to set the parameter value to.
Throws
SQLException 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

public void updateBoolean (int columnIndex, boolean x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given boolean value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateBoolean (String columnName, boolean x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given boolean value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateByte (int columnIndex, byte x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given byte value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateByte (String columnName, byte x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given byte value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

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

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given byte array. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

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

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given byte array. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

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

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.io.Reader object.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
reader the new column value; must be a java.io.Reader containing BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, or LONGVARCHAR data
length the length of the stream in characters
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the data in the stream is not a binary or character type, or (4) this rowset is ResultSet.CONCUR_READ_ONLY

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

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.

Parameters
columnLabel the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel 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 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

public void updateCharacterStream (String columnLabel, Reader reader)

Updates the designated column with a character stream 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.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateCharacterStream which takes a length parameter.

Parameters
columnLabel the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column
reader the java.io.Reader object containing the new column value
Throws
SQLException 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

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

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.

Parameters
columnIndex the first column is 1, the second is 2, ...
x the new column value
length the length of the stream
Throws
SQLException 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

public void updateCharacterStream (int columnIndex, Reader x)

Updates the designated column with a character stream 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.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateCharacterStream which takes a length parameter.

Parameters
columnIndex the first column is 1, the second is 2, ...
x the new column value
Throws
SQLException 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

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

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.io.Reader object.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value; must be a java.io.Reader containing BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, or LONGVARCHAR data
length the length of the stream in characters
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the data in the stream is not a binary or character type, or (4) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateClob (int columnIndex, Clob c)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given double value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
c the new column Clob value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

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

Updates the designated column using the given Reader object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

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.

Parameters
columnIndex the first column is 1, the second is 2, ...
reader An object that contains the data to set the parameter value to.
length the number of characters in the parameter data.
Throws
SQLException 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

public void updateClob (int columnIndex, Reader reader)

Updates the designated column using the given Reader object. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateClob which takes a length parameter.

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.

Parameters
columnIndex the first column is 1, the second is 2, ...
reader An object that contains the data to set the parameter value to.
Throws
SQLException 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

public void updateClob (String columnName, Clob c)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given double value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
c the new column Clob value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateClob (String columnLabel, Reader reader)

Updates the designated column using the given Reader object. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateClob which takes a length parameter.

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.

Parameters
columnLabel the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column
reader An object that contains the data to set the parameter value to.
Throws
SQLException 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

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

Updates the designated column using the given Reader object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

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.

Parameters
columnLabel 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 An object that contains the data to set the parameter value to.
length the number of characters in the parameter data.
Throws
SQLException 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

public void updateDate (String columnName, Date x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Date object. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the type of the designated column is not an SQL DATE or TIMESTAMP, or (4) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateDate (int columnIndex, Date x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Date object. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the type of the designated column is not an SQL DATE or TIMESTAMP, or (4) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateDouble (String columnName, double x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given double value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateDouble (int columnIndex, double x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given double value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateFloat (String columnName, float x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given float value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateFloat (int columnIndex, float x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given float value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateInt (String columnName, int x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given int value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateInt (int columnIndex, int x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given int value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateLong (int columnIndex, long x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given long value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateLong (String columnName, long x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given long value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateNCharacterStream (String columnName, Reader x, long length)

Updates the designated column with a character stream value, which will have the specified number of bytes. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updating NCHAR,NVARCHAR and LONGNVARCHAR columns. 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.

Parameters
columnName - name of the Column
x - the new column value
length - the length of the stream
Throws
SQLException if a database access error occurs

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

Updates the designated column with a character stream value, which will have the specified number of bytes. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updating NCHAR,NVARCHAR and LONGNVARCHAR columns. 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.

Parameters
columnIndex - the first column is 1, the second is 2, ...
x - the new column value
length - the length of the stream
Throws
SQLException if a database access error occurs

public void updateNCharacterStream (String columnLabel, Reader reader)

Updates the designated column with a character stream value. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updating NCHAR,NVARCHAR and LONGNVARCHAR columns. 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.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateNCharacterStream which takes a length parameter.

Parameters
columnLabel the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column
reader the java.io.Reader object containing the new column value
Throws
SQLException 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

public void updateNCharacterStream (int columnIndex, Reader x)

Updates the designated column with a character stream value. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updating NCHAR,NVARCHAR and LONGNVARCHAR columns. 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.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateNCharacterStream which takes a length parameter.

Parameters
columnIndex the first column is 1, the second is 2, ...
x the new column value
Throws
SQLException 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

public void updateNClob (String columnName, NClob nClob)

This method is used for updating SQL NCLOB type that maps to java.sql.Types.NCLOB

Parameters
columnName name of the column
nClob the value for the column to be updated
Throws
SQLException if a database access error occurs

public void updateNClob (int columnIndex, Reader reader)

Updates the designated column using the given Reader object. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateNClob which takes a length parameter.

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.

Parameters
columnIndex the first column is 1, the second 2, ...
reader An object that contains the data to set the parameter value to.
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void updateNClob (int columnIndex, NClob nClob)

Updates the designated column with a java.sql.NClob 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.

Parameters
columnIndex the first column is 1, the second 2, ...
nClob the value for the column to be updated
Throws
SQLException

public void updateNClob (String columnLabel, Reader reader)

Updates the designated column using the given Reader object. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateNClob which takes a length parameter.

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.

Parameters
columnLabel the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column
reader An object that contains the data to set the parameter value to.
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException if the JDBC driver does not support this method

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

Updates the designated column using the given Reader object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

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.

Parameters
columnIndex the first column is 1, the second 2, ...
reader An object that contains the data to set the parameter value to.
length the number of characters in the parameter data.
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException if the JDBC driver does not support this method

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

Updates the designated column using the given Reader object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

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.

Parameters
columnLabel 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 An object that contains the data to set the parameter value to.
length the number of characters in the parameter data.
Throws
SQLException if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException if the JDBC driver does not support this method

public void updateNString (String columnName, String nString)

This method is used for updating columns that support National Character sets. It can be used for updating NCHAR,NVARCHAR and LONGNVARCHAR columns.

Parameters
columnName name of the Column
nString the value for the column to be updated
Throws
SQLException if a database access error occurs

public void updateNString (int columnIndex, String nString)

This method is used for updating columns that support National Character sets. It can be used for updating NCHAR,NVARCHAR and LONGNVARCHAR columns.

Parameters
columnIndex the first column is 1, the second 2, ...
nString the value for the column to be updated
Throws
SQLException if a database access error occurs

public void updateNull (String columnName)

Sets the designated nullable column in the current row or the insert row of this CachedRowSetImpl object with null value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateNull (int columnIndex)

Sets the designated nullable column in the current row or the insert row of this CachedRowSetImpl object with null value.

This method updates a column value in the current row or the insert row of this rowset; however, another method must be called to complete the update process. If the cursor is on a row in the rowset, the method updateRow() must be called to mark the row as updated and to notify listeners that the row has changed. If the cursor is on the insert row, the method insertRow() must be called to insert the new row into this rowset and to notify listeners that a row has changed.

In order to propagate updates in this rowset to the underlying data source, an application must call the method acceptChanges() after it calls either updateRow or insertRow.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateObject (int columnIndex, Object x, int scale)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Object value. The scale parameter indicates the number of digits to the right of the decimal point and is ignored if the new column value is not a type that will be mapped to an SQL DECIMAL or NUMERIC value.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
scale the number of digits to the right of the decimal point (for DECIMAL and NUMERIC types only)
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateObject (int columnIndex, Object x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Object value.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

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

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Object value. The scale parameter indicates the number of digits to the right of the decimal point and is ignored if the new column value is not a type that will be mapped to an SQL DECIMAL or NUMERIC value.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
scale the number of digits to the right of the decimal point (for DECIMAL and NUMERIC types only)
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateObject (String columnName, Object x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Object value.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateRef (int columnIndex, Ref ref)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Ref value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
ref the new column java.sql.Ref value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateRef (String columnName, Ref ref)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given double value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
ref the new column java.sql.Ref value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateRow ()

Marks the current row of this CachedRowSetImpl object as updated and notifies listeners registered with this rowset that the row has changed.

This method cannot be called when the cursor is on the insert row, and it should be called before the cursor moves to another row. If it is called after the cursor moves to another row, this method has no effect, and the updates made before the cursor moved will be lost.

Throws
SQLException if the cursor is on the insert row or this rowset is ResultSet.CONCUR_READ_ONLY

public void updateRowId (String columnName, RowId x)

Updates the designated column with a RowId 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.

Parameters
columnName the name of the column
x the column value
Throws
SQLException if a database access occurs

public void updateRowId (int columnIndex, RowId x)

Updates the designated column with a RowId 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.

Parameters
columnIndex the first column is 1, the second 2, ...
x the column value
Throws
SQLException if a database access occurs

public void updateSQLXML (int columnIndex, SQLXML xmlObject)

Updates the designated column with a java.sql.SQLXML 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.

Parameters
columnIndex the first column is 1, the second 2, ...
xmlObject the value for the column to be updated
Throws
SQLException if a database access error occurs

public void updateSQLXML (String columnName, SQLXML xmlObject)

Updates the designated column with a java.sql.SQLXML 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.

Parameters
columnName the name of the column
xmlObject the column value
Throws
SQLException if a database access occurs

public void updateShort (int columnIndex, short x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given short value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateShort (String columnName, short x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given short value.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateString (int columnIndex, String x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given String object.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to mark the row as updated. If the cursor is on the insert row, the method insertRow() must be called to insert the new row into this rowset and mark it as inserted. Both of these methods must be called before the cursor moves to another row.

The method acceptChanges must be called if the updated values are to be written back to the underlying database.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateString (String columnName, String x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given String object. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateTime (int columnIndex, Time x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Time object. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the type of the designated column is not an SQL TIME or TIMESTAMP, or (4) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateTime (String columnName, Time x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Time object. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the type of the designated column is not an SQL TIME or TIMESTAMP, or (4) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateTimestamp (int columnIndex, Timestamp x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Timestamp object. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnIndex the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
x the new column value
Throws
SQLException if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the type of the designated column is not an SQL DATE, TIME, or TIMESTAMP, or (4) this rowset is ResultSet.CONCUR_READ_ONLY

public void updateTimestamp (String columnName, Timestamp x)

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given Timestamp object. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow() must be called to update the database. If the cursor is on the insert row, the method insertRow() must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.

Parameters
columnName a String object that must match the SQL name of a column in this rowset, ignoring case
x the new column value
Throws
SQLException if the given column index is out of bounds or the cursor is not on one of this rowset's rows or its insert row
SQLException if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the type of the designated column is not an SQL DATE, TIME, or TIMESTAMP, or (4) this rowset is ResultSet.CONCUR_READ_ONLY

public boolean wasNull ()

Reports whether the last column read was SQL NULL. Note that you must first call the method getXXX on a column to try to read its value and then call the method wasNull to determine whether the value was SQL NULL.

Returns
  • true if the value in the last column read was SQL NULL; false otherwise
Throws
SQLException if an error occurs

Protected Methods

protected Object clone ()

Returns a new RowSet object containing by the same data as this CachedRowSetImpl object. This method differs from the method createCopy in that it throws a CloneNotSupportedException object instead of an SQLException object, as the method createShared does. This clone method is called internally by the method createShared, which catches the CloneNotSupportedException object and in turn throws a new SQLException object.

Returns
  • a copy of this CachedRowSetImpl object
Throws
CloneNotSupportedException if an error occurs when attempting to clone this CachedRowSetImpl object
See Also

protected BaseRow getCurrentRow ()

Returns the insert row or the current row of this CachedRowSetImplobject.

Returns
  • the Row object on which this CachedRowSetImpl objects's cursor is positioned

protected boolean internalFirst ()

Moves this CachedRowSetImpl object's cursor to the first row and returns true if the operation is successful.

This method is called internally by the methods first, isFirst, and absolute. It in turn calls the method internalNext in order to handle the case where the first row is a deleted row that is not visible.

This is a implementation only method and is not required as a standard implementation of the CachedRowSet interface.

Returns
  • true if the cursor moved to the first row; false otherwise
Throws
SQLException if an error occurs

protected boolean internalLast ()

Moves this CachedRowSetImpl object's cursor to the last row and returns true if the operation is successful.

This method is called internally by the method last when rows have been deleted and the deletions are not visible. The method internalLast handles the case where the last row is a deleted row that is not visible by in turn calling the method internalPrevious.

This is a implementation only method and is not required as a standard implementation of the CachedRowSet interface.

Returns
  • true if the cursor moved to the last row; false otherwise
Throws
SQLException if an error occurs

protected boolean internalNext ()

Moves this CachedRowSetImpl object's cursor to the next row and returns true if the cursor is still in the rowset; returns false if the cursor has moved to the position after the last row.

This method handles the cases where the cursor moves to a row that has been deleted. If this rowset shows deleted rows and the cursor moves to a row that has been deleted, this method moves the cursor to the next row until the cursor is on a row that has not been deleted.

The method internalNext is called by methods such as next, absolute, and relative, and, as its name implies, is only called internally.

This is a implementation only method and is not required as a standard implementation of the CachedRowSet interface.

Returns
  • true if the cursor is on a valid row in this rowset; false if it is after the last row
Throws
SQLException if an error occurs

protected boolean internalPrevious ()

Moves the cursor to the previous row in this CachedRowSetImpl object, skipping past deleted rows that are not visible; returns true if the cursor is on a row in this rowset and false when the cursor goes before the first row.

This method is called internally by the method previous.

This is a implementation only method and is not required as a standard implementation of the CachedRowSet interface.

Returns
  • true if the cursor is on a row in this rowset; false when the cursor reaches the position before the first row
Throws
SQLException if an error occurs

protected void readObject (ObjectInputStream ois)

This method re populates the resBundle during the deserialization process

Throws
ClassNotFoundException
IOException

protected void removeCurrentRow ()

Removes the row on which the cursor is positioned.

This is a implementation only method and is not required as a standard implementation of the CachedRowSet interface.

Throws
SQLException if the cursor is positioned on the insert row