Package Summary Overview Summary |
| ||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES All Classes | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectjavax.sql.rowset.BaseRowSet
com.sun.rowset.CachedRowSetImpl
public class CachedRowSetImpl
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.
Field Summary | |
---|---|
protected JdbcRowSetResourceBundle | resBundle
|
Fields inherited from class javax.sql.rowset.BaseRowSet |
---|
ASCII_STREAM_PARAM, asciiStream, BINARY_STREAM_PARAM, binaryStream, charStream, UNICODE_STREAM_PARAM, unicodeStream |
Fields inherited from interface javax.sql.rowset.CachedRowSet |
---|
COMMIT_ON_ACCEPT_CHANGES |
Fields inherited from interface java.sql.ResultSet |
---|
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
Constructor Summary | |
---|---|
CachedRowSetImpl()
Constructs a new default CachedRowSetImpl object with the capacity to hold 100 rows. |
|
CachedRowSetImpl(java.util.Hashtable env)
Provides a CachedRowSetImpl instance with the same default properties as as the zero parameter constructor. |
Method Summary | ||
---|---|---|
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. |
|
protected java.lang.Object | clone()
Returns a new RowSet object containing by the same data as this 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(java.lang.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(java.lang.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(java.lang.String colName)
Retrieves the value of the designated column in this CachedRowSetImpl object as an Array object in the Java programming langugage. |
|
java.io.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. |
|
java.io.InputStream | getAsciiStream(java.lang.String columnName)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.io.InputStream object. |
|
java.math.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. |
|
java.math.BigDecimal | getBigDecimal(int columnIndex, int scale)
Deprecated. |
|
java.math.BigDecimal | getBigDecimal(java.lang.String columnName)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.math.BigDecimal object. |
|
java.math.BigDecimal | getBigDecimal(java.lang.String columnName, int scale)
Deprecated. Use the getBigDecimal(String columnName) method instead |
|
java.io.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. |
|
java.io.InputStream | getBinaryStream(java.lang.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(int columnIndex)
Retrieves the value of the designated column in this CachedRowSetImpl object as a Blob object in the Java programming language. |
|
Blob | getBlob(java.lang.String colName)
Retrieves the value of the designated column in this CachedRowSetImpl object as a Blob object in the Java programming language. |
|
boolean | getBoolean(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a boolean value. |
|
boolean | getBoolean(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a boolean 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 | getByte(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row 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(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a byte array. |
|
java.io.Reader | getCharacterStream(int columnIndex)
Retrieves the value stored in the designated column of the current row as a java.io.Reader object. |
|
java.io.Reader | getCharacterStream(java.lang.String columnName)
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(java.lang.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. |
|
protected BaseRow | getCurrentRow()
Returns the insert row or the current row of this CachedRowSetImpl object. |
|
java.lang.String | getCursorName()
Retrieves the name of the SQL cursor used by this CachedRowSetImpl object. |
|
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(int columnIndex, java.util.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(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a java.sql.Date object. |
|
Date | getDate(java.lang.String columnName, java.util.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. |
|
double | getDouble(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a double value. |
|
double | getDouble(java.lang.String columnName)
Retrieves the value stored in the designated column of 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(java.lang.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(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as an int value. |
|
int | getInt(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as an int value. |
|
int[] | getKeyColumns()
Returns the columns that make a key to uniquely identify a row in this CachedRowSetImpl object. |
|
long | getLong(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a long value. |
|
long | getLong(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a long value. |
|
int[] | getMatchColumnIndexes()
Retrieves the column id as int array that was set using setMatchColumn(int []) for this rowset. |
|
java.lang.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. |
|
java.io.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. |
|
java.io.Reader | getNCharacterStream(java.lang.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(java.lang.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. |
|
java.lang.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. |
|
java.lang.String | getNString(java.lang.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. |
|
java.lang.Object | getObject(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as an Object value. |
|
| getObject(int columnIndex, java.lang.Class<T> type)
Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported. |
|
java.lang.Object | getObject(int columnIndex, java.util.Map<java.lang.String,java.lang.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. |
|
java.lang.Object | getObject(java.lang.String columnName)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as an Object value. |
|
| getObject(java.lang.String columnLabel, java.lang.Class<T> type)
Retrieves the value of the designated column in the current row of this ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported. |
|
java.lang.Object | getObject(java.lang.String columnName, java.util.Map<java.lang.String,java.lang.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. |
|
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(int columnIndex)
Retrieves the value of the designated column in this CachedRowSetImpl object as a Ref object in the Java programming language. |
|
Ref | getRef(java.lang.String colName)
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(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. |
|
RowId | getRowId(java.lang.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. |
|
RowSetWarning | getRowSetWarnings()
The first warning reported by calls on this CachedRowSetImpl object is returned. |
|
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(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a short value. |
|
SQLXML | getSQLXML(int columnIndex)
Retrieves the value of the designated SQL XML parameter as a SQLXML object in the Java programming language. |
|
SQLXML | getSQLXML(java.lang.String colName)
Retrieves the value of the designated SQL XML parameter as a SQLXML object in the Java programming language. |
|
Statement | getStatement()
Returns null . |
|
java.lang.String | getString(int columnIndex)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a String object. |
|
java.lang.String | getString(java.lang.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. |
|
java.lang.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(int columnIndex, java.util.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(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a java.sql.Time object. |
|
Time | getTime(java.lang.String columnName, java.util.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)
Retrieves the value of the designated column in the current row of this CachedRowSetImpl object as a java.sql.Timestamp object. |
|
Timestamp | getTimestamp(int columnIndex, java.util.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(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a java.sql.Timestamp object. |
|
Timestamp | getTimestamp(java.lang.String columnName, java.util.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. |
|
java.io.InputStream | getUnicodeStream(int columnIndex)
Deprecated. |
|
java.io.InputStream | getUnicodeStream(java.lang.String columnName)
Deprecated. use the method getCharacterStream instead |
|
java.net.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. |
|
java.net.URL | getURL(java.lang.String columnName)
Retrieves the value of the designated column in this CachedRowSetImpl object as a java.net.URL object in the Java programming language. |
|
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. |
|
protected boolean | internalFirst()
Moves this CachedRowSetImpl object's cursor to the first row and returns true if the operation is successful. |
|
protected boolean | internalLast()
Moves this CachedRowSetImpl object's cursor to the last row and returns true if the operation is successful. |
|
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. |
|
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. |
|
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(java.lang.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. |
|
protected void | removeCurrentRow()
Removes the row on which the cursor is positioned. |
|
void | restoreOriginal()
Restores this CachedRowSetImpl object to its original state, that is, its state before the last set of changes. |
|
void | rollback()
Rolls back all changes performed by the acceptChanges() methods |
|
void | rollback(Savepoint s)
Rolls back all changes performed by the acceptChanges() to the last Savepoint transaction marker. |
|
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(java.lang.String parameterName, java.io.InputStream x)
Sets the designated parameter to the given input stream. |
|
void | setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
|
void | setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x)
Sets the designated parameter to the given java.math.BigDecimal value. |
|
void | setBinaryStream(java.lang.String parameterName, java.io.InputStream x)
Sets the designated parameter to the given input stream. |
|
void | setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
|
void | setBlob(int parameterIndex, java.io.InputStream inputStream)
Sets the designated parameter to a InputStream object. |
|
void | setBlob(int parameterIndex, java.io.InputStream inputStream, long length)
Sets the designated parameter to a InputStream object. |
|
void | setBlob(java.lang.String parameterName, Blob x)
Sets the designated parameter to the given java.sql.Blob object. |
|
void | setBlob(java.lang.String parameterName, java.io.InputStream inputStream)
Sets the designated parameter to a InputStream object. |
|
void | setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length)
Sets the designated parameter to a InputStream object. |
|
void | setBoolean(java.lang.String parameterName, boolean x)
Sets the designated parameter to the given Java boolean value. |
|
void | setByte(java.lang.String parameterName, byte x)
Sets the designated parameter to the given Java byte value. |
|
void | setBytes(java.lang.String parameterName, byte[] x)
Sets the designated parameter to the given Java array of bytes. |
|
void | setCharacterStream(java.lang.String parameterName, java.io.Reader reader)
Sets the designated parameter to the given Reader object. |
|
void | setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length)
Sets the designated parameter to the given Reader object, which is the given number of characters long. |
|
void | setClob(int parameterIndex, java.io.Reader reader)
Sets the designated parameter to a Reader object. |
|
void | setClob(int parameterIndex, java.io.Reader reader, long length)
Sets the designated parameter to a Reader object. |
|
void | setClob(java.lang.String parameterName, Clob x)
Sets the designated parameter to the given java.sql.Clob object. |
|
void | setClob(java.lang.String parameterName, java.io.Reader reader)
Sets the designated parameter to a Reader object. |
|
void | setClob(java.lang.String parameterName, java.io.Reader reader, long length)
Sets the designated parameter to a Reader object. |
|
void | setCommand(java.lang.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(java.lang.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(java.lang.String parameterName, Date x, java.util.Calendar cal)
Sets the designated parameter to the given java.sql.Date value, using the given Calendar object. |
|
void | setDouble(java.lang.String parameterName, double x)
Sets the designated parameter to the given Java double value. |
|
void | setFloat(java.lang.String parameterName, float x)
Sets the designated parameter to the given Java float value. |
|
void | setInt(java.lang.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(java.lang.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(int[] columnIdxes)
Sets the designated parameter to the given int array. |
|
void | setMatchColumn(java.lang.String columnName)
Sets the designated parameter to the given String object. |
|
void | setMatchColumn(java.lang.String[] columnNames)
Sets the designated parameter to the given String array. |
|
void | setMetaData(RowSetMetaData md)
Sets the metadata for this CachedRowSetImpl object with the given RowSetMetaData object. |
|
void | setNCharacterStream(int parameterIndex, java.io.Reader value)
Sets the designated parameter to a Reader object. |
|
void | setNCharacterStream(int parameterIndex, java.io.Reader value, long length)
Sets the designated parameter to a Reader object. |
|
void | setNCharacterStream(java.lang.String parameterName, java.io.Reader value)
Sets the designated parameter to a Reader object. |
|
void | setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length)
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(int parameterIndex, java.io.Reader reader)
Sets the designated parameter to a Reader object. |
|
void | setNClob(int parameterIndex, java.io.Reader reader, long length)
Sets the designated parameter to a Reader object. |
|
void | setNClob(java.lang.String parameterName, NClob value)
Sets the designated parameter to a java.sql.NClob object. |
|
void | setNClob(java.lang.String parameterName, java.io.Reader reader)
Sets the designated parameter to a Reader object. |
|
void | setNClob(java.lang.String parameterName, java.io.Reader reader, long length)
Sets the designated parameter to a Reader object. |
|
void | setNString(int parameterIndex, java.lang.String value)
Sets the designated paramter to the given String object. |
|
void | setNString(java.lang.String parameterName, java.lang.String value)
Sets the designated paramter to the given String object. |
|
void | setNull(java.lang.String parameterName, int sqlType)
Sets the designated parameter to SQL NULL . |
|
void | setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName)
Sets the designated parameter to SQL NULL . |
|
void | setObject(java.lang.String parameterName, java.lang.Object x)
Sets the value of the designated parameter with the given object. |
|
void | setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType)
Sets the value of the designated parameter with the given object. |
|
void | setObject(java.lang.String parameterName, java.lang.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(java.lang.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 | setShort(java.lang.String parameterName, short x)
Sets the designated parameter to the given Java short value. |
|
void | setSQLXML(int parameterIndex, SQLXML xmlObject)
Sets the designated parameter to the given java.sql.SQLXML object. |
|
void | setSQLXML(java.lang.String parameterName, SQLXML xmlObject)
Sets the designated parameter to the given java.sql.SQLXML object. |
|
void | setString(java.lang.String parameterName, java.lang.String x)
Sets the designated parameter to the given Java String value. |
|
void | setSyncProvider(java.lang.String providerStr)
Sets the active SyncProvider and attempts to load load the new provider using the SyncFactory SPI. |
|
void | setTableName(java.lang.String tabName)
Sets the identifier for the table from which this rowset was derived to the given table name. |
|
void | setTime(java.lang.String parameterName, Time x)
Sets the designated parameter to the given java.sql.Time value. |
|
void | setTime(java.lang.String parameterName, Time x, java.util.Calendar cal)
Sets the designated parameter to the given java.sql.Time value, using the given Calendar object. |
|
void | setTimestamp(java.lang.String parameterName, Timestamp x)
Sets the designated parameter to the given java.sql.Timestamp value. |
|
void | setTimestamp(java.lang.String parameterName, Timestamp x, java.util.Calendar cal)
Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object. |
|
void | setURL(int parameterIndex, java.net.URL x)
Sets the designated parameter to the given java.net.URL value. |
|
int | size()
Returns the number of rows in this CachedRowSetImpl object. |
|
java.util.Collection<?> | toCollection()
Converts this CachedRowSetImpl object to a collection of tables. |
|
java.util.Collection<?> | toCollection(int column)
Returns the specified column of this CachedRowSetImpl object as a Collection object. |
|
java.util.Collection<?> | toCollection(java.lang.String 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 columnIdx)
Unsets the designated parameter to the given int object. |
|
void | unsetMatchColumn(int[] columnIdxes)
Unsets the designated parameter to the given int array. |
|
void | unsetMatchColumn(java.lang.String columnName)
Unsets the designated parameter to the given String object. |
|
void | unsetMatchColumn(java.lang.String[] columnIdxes)
Unsets the designated parameter to the given String array. |
|
| unwrap(java.lang.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(java.lang.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(int columnIndex, java.io.InputStream x)
Updates the designated column with an ascii stream value. |
|
void | updateAsciiStream(int columnIndex, java.io.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, java.io.InputStream x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes. |
|
void | updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x)
Updates the designated column with an ascii stream value. |
|
void | updateAsciiStream(java.lang.String columnName, java.io.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(java.lang.String columnLabel, java.io.InputStream x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.. |
|
void | updateBigDecimal(int columnIndex, java.math.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(java.lang.String columnName, java.math.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, java.io.InputStream x)
Updates the designated column with a binary stream value. |
|
void | updateBinaryStream(int columnIndex, java.io.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, java.io.InputStream x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes. |
|
void | updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x)
Updates the designated column with a binary stream value. |
|
void | updateBinaryStream(java.lang.String columnName, java.io.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(java.lang.String columnLabel, java.io.InputStream x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes. |
|
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(int columnIndex, java.io.InputStream inputStream)
Updates the designated column using the given input stream. |
|
void | updateBlob(int columnIndex, java.io.InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes. |
|
void | updateBlob(java.lang.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(java.lang.String columnLabel, java.io.InputStream inputStream)
Updates the designated column using the given input stream. |
|
void | updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes. |
|
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(java.lang.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(java.lang.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(java.lang.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(int columnIndex, java.io.Reader x)
Updates the designated column with a character stream value. |
|
void | updateCharacterStream(int columnIndex, java.io.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 | updateCharacterStream(int columnIndex, java.io.Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void | updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
Updates the designated column with a character stream value. |
|
void | updateCharacterStream(java.lang.String columnName, java.io.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(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
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, java.io.Reader reader)
Updates the designated column using the given Reader object. |
|
void | updateClob(int columnIndex, java.io.Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long. |
|
void | updateClob(java.lang.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(java.lang.String columnLabel, java.io.Reader reader)
Updates the designated column using the given Reader object. |
|
void | updateClob(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long. |
|
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 | updateDate(java.lang.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 | 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 | updateDouble(java.lang.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 | 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 | updateFloat(java.lang.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 | 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 | updateInt(java.lang.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 | 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(java.lang.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(int columnIndex, java.io.Reader x)
Updates the designated column with a character stream value. |
|
void | updateNCharacterStream(int columnIndex, java.io.Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void | updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
Updates the designated column with a character stream value. |
|
void | updateNCharacterStream(java.lang.String columnName, java.io.Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void | updateNClob(int columnIndex, NClob nClob)
Updates the designated column with a java.sql.NClob value. |
|
void | updateNClob(int columnIndex, java.io.Reader reader)
Updates the designated column using the given Reader object. |
|
void | updateNClob(int columnIndex, java.io.Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long. |
|
void | updateNClob(java.lang.String columnName, NClob nClob)
This method is used for updating SQL NCLOB type that maps to java.sql.Types.NCLOB |
|
void | updateNClob(java.lang.String columnLabel, java.io.Reader reader)
Updates the designated column using the given Reader object. |
|
void | updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long. |
|
void | updateNString(int columnIndex, java.lang.String nString)
This method is used for updating columns that support National Character sets. |
|
void | updateNString(java.lang.String columnName, java.lang.String nString)
This method is used for updating columns that support National Character sets. |
|
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 | updateNull(java.lang.String columnName)
Sets the designated nullable column in the current row or the insert row of this CachedRowSetImpl object with null value. |
|
void | updateObject(int columnIndex, java.lang.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(int columnIndex, java.lang.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(java.lang.String columnName, java.lang.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(java.lang.String columnName, java.lang.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 | 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(java.lang.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(int columnIndex, RowId x)
Updates the designated column with a RowId value. |
|
void | updateRowId(java.lang.String columnName, RowId x)
Updates the designated column with a RowId 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(java.lang.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 | updateSQLXML(int columnIndex, SQLXML xmlObject)
Updates the designated column with a java.sql.SQLXML value. |
|
void | updateSQLXML(java.lang.String columnName, SQLXML xmlObject)
Updates the designated column with a java.sql.SQLXML value. |
|
void | updateString(int columnIndex, java.lang.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(java.lang.String columnName, java.lang.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(java.lang.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(java.lang.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 . |
Methods inherited from class java.lang.Object |
---|
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface javax.sql.RowSetInternal |
---|
getParams |
Methods inherited from interface javax.sql.rowset.CachedRowSet |
---|
getShowDeleted, setShowDeleted |
Methods inherited from interface java.sql.ResultSet |
---|
getConcurrency, getFetchDirection, getFetchSize, getType, setFetchDirection, setFetchSize |
Field Detail |
---|
protected transient JdbcRowSetResourceBundleresBundle
Constructor Detail |
---|
public CachedRowSetImpl() throws SQLException
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 = 0A
CachedRowSetImpl
object is configured to use the default RIOptimisticProvider
implementation to provide connectivity and synchronization capabilities to the set data source.
SQLException
- if an error occurs public CachedRowSetImpl(java.util.Hashtable env) throws SQLException
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 = 0However, 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. SyncFactory
and SyncProvider
specificiations later in this document.
env
- a Hashtable
object with a list of desired synchronization providers SQLException
- if the requested provider cannot be found by the synchonization factory SyncProvider
Method Detail |
---|
public void setCommand(java.lang.String cmd) throws SQLException
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
.
setCommand
in interface RowSet
setCommand
in class BaseRowSet
cmd
- a String
object containing an SQL query that will be set as the command; may be null
SQLException
- if an error occurs BaseRowSet.getCommand()
public void populate(ResultSet data) throws SQLException
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.
populate
in interface CachedRowSet
data
- the ResultSet
object containing the data to be read into this CachedRowSetImpl
object SQLException
- if an error occurs; or the max row setting is violated while populating the RowSet execute(java.sql.Connection)
public void execute(Connection conn) throws SQLException
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.
execute
in interface CachedRowSet
conn
- A standard JDBC Connection
object that this CachedRowSet
object can pass to a synchronization provider to establish a connection to the data source SQLException
- if an invalid Connection
is supplied or an error occurs in establishing the connection to the data source populate(java.sql.ResultSet)
, Connection
public void acceptChanges() throws SyncProviderException
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
.
acceptChanges
in interface CachedRowSet
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. acceptChanges(java.sql.Connection)
, RowSetWriter
, SyncProvider
public void acceptChanges(Connection con) throws SyncProviderException
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.
acceptChanges
in interface CachedRowSet
con
- a standard JDBC Connection
object 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
- if the underlying synchronization provider's writer fails to write the updates back to the data source acceptChanges()
, RowSetWriter
, SyncFactory
, SyncProvider
public void restoreOriginal() throws SQLException
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.
restoreOriginal
in interface CachedRowSet
SQLException
- if an error is occurs rolling back the RowSet state to the definied original value. RowSetListener.rowSetChanged(javax.sql.RowSetEvent)
public void release() throws SQLException
CachedRowSetImpl
object and sends a rowSetChanged
event object to all registered listeners.
release
in interface CachedRowSet
SQLException
- if an error occurs flushing the contents of RowSet. RowSetListener.rowSetChanged(javax.sql.RowSetEvent)
public void undoDelete() throws SQLException
Note: This method can be ignored if deleted rows are not being shown, which is the normal case.
undoDelete
in interface CachedRowSet
SQLException
- if the cursor is not on a valid row CachedRowSet.undoInsert()
, ResultSet.cancelRowUpdates()
public void undoInsert() throws SQLException
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.
undoInsert
in interface CachedRowSet
SQLException
- if an error occurs, the cursor is not on a valid row, or the row has not been inserted CachedRowSet.undoDelete()
, ResultSet.cancelRowUpdates()
public void undoUpdate() throws SQLException
acceptChanges
) or population. This method may also be called while performing updates to the insert row.
undoUpdate
undoUpdate
in interface CachedRowSet
SQLException
- if cursor is before the first row, after the last row in rowset. undoDelete()
, undoInsert()
, ResultSet.cancelRowUpdates()
public RowSetcreateShared() throws SQLException
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.
createShared
in interface CachedRowSet
RowSet
object that is a copy of this CachedRowSetImpl
object and shares a set of cursors with it SQLException
- if an error occurs or cloning is not supported RowSetEvent
, RowSetListener
protected java.lang.Object clone() throws java.lang.CloneNotSupportedException
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.
clone
in class java.lang.Object
CachedRowSetImpl
object java.lang.CloneNotSupportedException
- if an error occurs when attempting to clone this CachedRowSetImpl
object createShared()
public CachedRowSetcreateCopy() throws SQLException
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.
createCopy
in interface CachedRowSet
CachedRowSet
object that is a deep copy of this CachedRowSet
object and is completely independent from this CachedRowSetImpl
object. SQLException
- if an error occurs in generating the copy of this of the CachedRowSetImpl
createShared()
, RowSetEvent
, RowSetListener
public CachedRowSetcreateCopySchema() throws SQLException
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
.
createCopySchema
in interface CachedRowSet
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 SQLException
- if an error occurs in generating the copy of the CachedRowSet
object createShared()
, createCopy()
, createCopyNoConstraints()
, RowSetEvent
, RowSetListener
public CachedRowSetcreateCopyNoConstraints() throws SQLException
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.
createCopyNoConstraints
in interface CachedRowSet
CachedRowSet
object that is a deep copy of this CachedRowSetImpl
object and is completely independent from this CachedRowSetImpl
object SQLException
- if an error occurs in generating the copy of the of the CachedRowSet
createShared()
, createCopy()
, createCopySchema()
, RowSetEvent
, RowSetListener
public java.util.Collection<?> toCollection() throws SQLException
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.
toCollection
in interface CachedRowSet
Collection
object consisting of tables, each of which is a copy of a row in this CachedRowSetImpl
object SQLException
- if an error occurs in generating the collection toCollection(int)
, toCollection(String)
, TreeMap
public java.util.Collection<?> toCollection(int column) throws SQLException
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.
toCollection
in interface CachedRowSet
column
- an int
indicating the column whose values are to be represented in a Collection
object Collection
object that contains the value(s) stored in the specified column of this CachedRowSetImpl
object SQLException
- if an error occurs generated the collection; or an invalid column is provided. toCollection()
, toCollection(String)
, Vector
public java.util.Collection<?> toCollection(java.lang.String column) throws SQLException
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.
toCollection
in interface CachedRowSet
column
- a String
object giving the name of the column whose values are to be represented in a collection Collection
object that contains the value(s) stored in the specified column of this CachedRowSetImpl
object SQLException
- if an error occurs generated the collection; or an invalid column is provided. toCollection()
, toCollection(int)
, Vector
public SyncProvidergetSyncProvider() throws SQLException
SyncProvider
implementation being used with this CachedRowSetImpl
implementation rowset.
getSyncProvider
in interface CachedRowSet
SQLException
- if error occurs while return the SyncProvider
instance. CachedRowSet.setSyncProvider(java.lang.String)
public void setSyncProvider(java.lang.String providerStr) throws SQLException
SyncProvider
and attempts to load load the new provider using the SyncFactory
SPI.
setSyncProvider
in interface CachedRowSet
providerStr
- a String
object giving the fully qualified class name of a SyncProvider
implementation SQLException
- if an error occurs while resetting the SyncProvider
. CachedRowSet.getSyncProvider()
public void execute() throws SQLException
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.
execute
in interface RowSet
SQLException
- if an error occurs or the necessary properties have not been set public boolean next() throws SQLException
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.
next
in interface ResultSet
true
if the new current row is valid; false
if there are no more rows SQLException
- if an error occurs or the cursor is not positioned in the rowset, before the first row, or after the last row protected boolean internalNext() throws SQLException
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.
true
if the cursor is on a valid row in this rowset; false
if it is after the last row SQLException
- if an error occurs public void close() throws SQLException
CachedRowSetImpl
objecy and releases any resources it was using.
close
in interface ResultSet
SQLException
- if an error occurs when releasing any resources in use by this CachedRowSetImpl
object public boolean wasNull() throws SQLException
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
.
wasNull
in interface ResultSet
true
if the value in the last column read was SQL NULL
; false
otherwise SQLException
- if an error occurs protected BaseRowgetCurrentRow()
CachedRowSetImpl
object.
Row
object on which this CachedRowSetImpl
objects's cursor is positioned protected void removeCurrentRow()
This is a implementation only method and is not required as a standard implementation of the CachedRowSet
interface.
SQLException
- if the cursor is positioned on the insert row public java.lang.String getString(int columnIndex) throws SQLException
CachedRowSetImpl
object as a String
object.
getString
in interface ResultSet
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 NULL
, the result is null
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 boolean getBoolean(int columnIndex) throws SQLException
CachedRowSetImpl
object as a boolean
value.
getBoolean
in interface ResultSet
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 boolean
in the Java progamming language; if the value is SQL NULL
, the result is false
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 getBoolean(String)
public byte getByte(int columnIndex) throws SQLException
CachedRowSetImpl
object as a byte
value.
getByte
in interface ResultSet
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 byte
in the Java programming language; if the value is SQL NULL
, the result is 0
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. getByte(String)
public short getShort(int columnIndex) throws SQLException
CachedRowSetImpl
object as a short
value.
getShort
in interface ResultSet
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 NULL
, the result is 0
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. getShort(String)
public int getInt(int columnIndex) throws SQLException
CachedRowSetImpl
object as an int
value.
getInt
in interface ResultSet
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 NULL
, the result is 0
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 long getLong(int columnIndex) throws SQLException
CachedRowSetImpl
object as a long
value.
getLong
in interface ResultSet
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 NULL
, the result is 0
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. getLong(String)
public float getFloat(int columnIndex) throws SQLException
CachedRowSetImpl
object as a float
value.
getFloat
in interface ResultSet
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 NULL
, the result is 0
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. getFloat(String)
public double getDouble(int columnIndex) throws SQLException
CachedRowSetImpl
object as a double
value.
getDouble
in interface ResultSet
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 NULL
, the result is 0
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. getDouble(String)
public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
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.
getBigDecimal
in interface ResultSet
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 NULL
, the result is null
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails public byte[] getBytes(int columnIndex) throws SQLException
CachedRowSetImpl
object as a byte
array value.
getBytes
in interface ResultSet
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 byte
array in the Java programming language; if the value is SQL NULL
, the result is null
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. getBytes(String)
public DategetDate(int columnIndex) throws SQLException
CachedRowSetImpl
object as a java.sql.Date
object.
getDate
in interface ResultSet
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 java.sql.Data
object; if the value is SQL NULL
, the result is null
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails public TimegetTime(int columnIndex) throws SQLException
CachedRowSetImpl
object as a java.sql.Time
object.
getTime
in interface ResultSet
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 NULL
, the result is null
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails public TimestampgetTimestamp(int columnIndex) throws SQLException
CachedRowSetImpl
object as a java.sql.Timestamp
object.
getTimestamp
in interface ResultSet
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 NULL
, the result is null
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails public java.io.InputStream getAsciiStream(int columnIndex) throws SQLException
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.
getAsciiStream
in interface ResultSet
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 NULL
, the result is null
. 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. getAsciiStream(String)
public java.io.InputStream getUnicodeStream(int columnIndex) throws SQLException
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.
getUnicodeStream
in interface ResultSet
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 SQLException
- if an error occurs public java.io.InputStream getBinaryStream(int columnIndex) throws SQLException
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.
getBinaryStream
in interface ResultSet
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 NULL
then the result is null
. 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. getBinaryStream(String)
public java.lang.String getString(java.lang.String columnName) throws SQLException
String
object.
getString
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is null
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 boolean getBoolean(java.lang.String columnName) throws SQLException
boolean
value.
getBoolean
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object boolean
in the Java programming language; if the value is SQL NULL
, the result is false
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 getBoolean(int)
public byte getByte(java.lang.String columnName) throws SQLException
byte
value.
getByte
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object byte
in the Java programming language; if the value is SQL NULL
, the result is 0
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 short getShort(java.lang.String columnName) throws SQLException
short
value.
getShort
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is 0
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. getShort(int)
public int getInt(java.lang.String columnName) throws SQLException
int
value.
getInt
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is 0
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 long getLong(java.lang.String columnName) throws SQLException
long
value.
getLong
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is 0
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. getLong(int)
public float getFloat(java.lang.String columnName) throws SQLException
float
value.
getFloat
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is 0
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. getFloat(String)
public double getDouble(java.lang.String columnName) throws SQLException
CachedRowSetImpl
object as a double
value.
getDouble
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is 0
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. getDouble(int)
public java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws SQLException
getBigDecimal(String columnName)
method instead
java.math.BigDecimal
object.
getBigDecimal
in interface ResultSet
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 scale
number of digits to the right of the decimal point. 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 byte[] getBytes(java.lang.String columnName) throws SQLException
byte
array. The bytes represent the raw values returned by the driver.
getBytes
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object byte
array in the Java programming language; if the value is SQL NULL
, the result is null
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. getBytes(int)
public DategetDate(java.lang.String columnName) throws SQLException
java.sql.Date
object.
getDate
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is null
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 TimegetTime(java.lang.String columnName) throws SQLException
java.sql.Time
object.
getTime
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is null
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 TimestampgetTimestamp(java.lang.String columnName) throws SQLException
java.sql.Timestamp
object.
getTimestamp
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is null
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 java.io.InputStream getAsciiStream(java.lang.String columnName) throws SQLException
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.
getAsciiStream
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is null
. 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. getAsciiStream(int)
public java.io.InputStream getUnicodeStream(java.lang.String columnName) throws SQLException
getCharacterStream
instead
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.
getUnicodeStream
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is null
. 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 java.io.InputStream getBinaryStream(java.lang.String columnName) throws SQLException
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.
getBinaryStream
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is null
. 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. getBinaryStream(int)
public SQLWarninggetWarnings()
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.
getWarnings
in interface ResultSet
public void clearWarnings()
CachedRowSetImpl
object. After a call to this method, the getWarnings
method returns null
until a new warning is reported for this CachedRowSetImpl
object.
clearWarnings
in interface ResultSet
public java.lang.String getCursorName() throws SQLException
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.
getCursorName
in interface ResultSet
CachedRowSetImpl
object's cursor SQLException
- if an error occurs public ResultSetMetaDatagetMetaData() throws SQLException
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);
getMetaData
in interface ResultSet
ResultSetMetaData
object that describes this CachedRowSetImpl
object's columns SQLException
- if an error occurs in generating the RowSet meta data; or if the CachedRowSetImpl
is empty. RowSetMetaData
public java.lang.Object getObject(int columnIndex) throws SQLException
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())
.
getObject
in interface ResultSet
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 java.lang.Object
holding the column value; if the value is SQL NULL
, the result is null
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 getObject(String)
public java.lang.Object getObject(java.lang.String columnName) throws SQLException
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())
.
getObject
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case java.lang.Object
holding the column value; if the value is SQL NULL
, the result is null
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 getObject(int)
public int findColumn(java.lang.String columnName) throws SQLException
CachedRowSetImpl
object's columns to its column number.
findColumn
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case SQLException
- if the given column name does not match one of this rowset's column names public java.io.Reader getCharacterStream(int columnIndex) throws SQLException
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.
getCharacterStream
in interface ResultSet
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 java.io.Reader
object. If the value is SQL NULL
, the result is null
. 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. getCharacterStream(String)
public java.io.Reader getCharacterStream(java.lang.String columnName) throws SQLException
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.
getCharacterStream
in interface ResultSet
columnName
- a String
object giving the SQL name of a column in this CachedRowSetImpl
object NULL
, the result is null
. 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 java.math.BigDecimal getBigDecimal(int columnIndex) throws SQLException
CachedRowSetImpl
object as a java.math.BigDecimal
object.
getBigDecimal
in interface ResultSet
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 java.math.BigDecimal
value with full precision; if the value is SQL NULL
, the result is null
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. getBigDecimal(String)
public java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws SQLException
CachedRowSetImpl
object as a java.math.BigDecimal
object.
getBigDecimal
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case java.math.BigDecimal
value with full precision; if the value is SQL NULL
, the result is null
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 getBigDecimal(int)
public int size()
CachedRowSetImpl
object.
size
in interface CachedRowSet
public boolean isBeforeFirst() throws SQLException
CachedRowSetImpl
object.
isBeforeFirst
in interface ResultSet
true
if the cursor is before the first row; false
otherwise or if the rowset contains no rows SQLException
- if an error occurs public boolean isAfterLast() throws SQLException
CachedRowSetImpl
object.
isAfterLast
in interface ResultSet
true
if the cursor is after the last row; false
otherwise or if the rowset contains no rows SQLException
- if an error occurs public boolean isFirst() throws SQLException
CachedRowSetImpl
object.
isFirst
in interface ResultSet
true
if the cursor is on the first row; false
otherwise or if the rowset contains no rows SQLException
- if an error occurs public boolean isLast() throws SQLException
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.
isLast
in interface ResultSet
true
if the cursor is on the last row; false
otherwise or if this rowset contains no rows SQLException
- if an error occurs public void beforeFirst() throws SQLException
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.
beforeFirst
in interface ResultSet
SQLException
- if an error occurs or the type of this rowset is ResultSet.TYPE_FORWARD_ONLY
public void afterLast() throws SQLException
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.
afterLast
in interface ResultSet
SQLException
- if an error occurs public boolean first() throws SQLException
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.
first
in interface ResultSet
true
if the cursor is on a valid row; false
otherwise or if there are no rows in this CachedRowSetImpl
object SQLException
- if the type of this rowset is ResultSet.TYPE_FORWARD_ONLY
protected boolean internalFirst() throws SQLException
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.
true
if the cursor moved to the first row; false
otherwise SQLException
- if an error occurs public boolean last() throws SQLException
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.
last
in interface ResultSet
true
if the cursor is on a valid row; false
otherwise or if there are no rows in this CachedRowSetImpl
object SQLException
- if the type of this rowset is ResultSet.TYPE_FORWARD_ONLY
protected boolean internalLast() throws SQLException
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.
true
if the cursor moved to the last row; false
otherwise SQLException
- if an error occurs public int getRow() throws SQLException
CachedRowSetImpl
object. The first row is number 1, the second number 2, and so on.
getRow
in interface ResultSet
0
if there is no current row SQLException
- if an error occurs; or if the CacheRowSetImpl
is empty public boolean absolute(int row) throws SQLException
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()
.
absolute
in interface ResultSet
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
true
if the cursor is on the rowset; false
otherwise SQLException
- if the given cursor position is 0
or the type of this rowset is ResultSet.TYPE_FORWARD_ONLY
public boolean relative(int rows) throws SQLException
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.
relative
in interface ResultSet
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 true
if the cursor is on a row in this CachedRowSetImpl
object; false
otherwise 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 boolean previous() throws SQLException
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.
previous
in interface ResultSet
true
if the cursor is on a valid row; false
if it is before the first row or after the last row SQLException
- if the cursor is not on a valid position or the type of this rowset is ResultSet.TYPE_FORWARD_ONLY
protected boolean internalPrevious() throws SQLException
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.
true
if the cursor is on a row in this rowset; false
when the cursor reaches the position before the first row SQLException
- if an error occurs public boolean rowUpdated() throws SQLException
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.
rowUpdated
in interface ResultSet
true
if the row has been visibly updated by the owner or another and updates are detected; false
otherwise SQLException
- if the cursor is on the insert row or not not on a valid row DatabaseMetaData.updatesAreDetected(int)
public boolean columnUpdated(int idx) throws SQLException
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.
columnUpdated
in interface CachedRowSet
idx
- the index identifier of the column that may be have been updated. 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 SQLException
- if the cursor is on the insert row or not on a valid row DatabaseMetaData.updatesAreDetected(int)
public boolean columnUpdated(java.lang.String columnName) throws SQLException
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.
columnUpdated
in interface CachedRowSet
columnName
- the String
column name column that may be have been updated. 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 SQLException
- if the cursor is on the insert row or not on a valid row DatabaseMetaData.updatesAreDetected(int)
public boolean rowInserted() throws SQLException
rowInserted
in interface ResultSet
true
if a row has been inserted and inserts are detected; false
otherwise SQLException
- if the cursor is on the insert row or not not on a valid row DatabaseMetaData.insertsAreDetected(int)
public boolean rowDeleted() throws SQLException
false
if this rowset cannot detect deletions.
rowDeleted
in interface ResultSet
true
if (1)the current row is blank, indicating that the row has been deleted, and (2)deletions are detected; false
otherwise SQLException
- if the cursor is on a valid row in this rowset DatabaseMetaData.deletesAreDetected(int)
public void updateNull(int columnIndex) throws SQLException
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
.
updateNull
in interface ResultSet
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 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(int columnIndex, boolean x) throws SQLException
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.
updateBoolean
in interface ResultSet
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 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(int columnIndex, byte x) throws SQLException
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.
updateByte
in interface ResultSet
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 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(int columnIndex, short x) throws SQLException
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.
updateShort
in interface ResultSet
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 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(int columnIndex, int x) throws SQLException
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.
updateInt
in interface ResultSet
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 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) throws SQLException
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.
updateLong
in interface ResultSet
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 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(int columnIndex, float x) throws SQLException
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.
updateFloat
in interface ResultSet
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 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 updateDouble(int columnIndex, double x) throws SQLException
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.
updateDouble
in interface ResultSet
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 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(int columnIndex, java.math.BigDecimal x) throws SQLException
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.
updateBigDecimal
in interface ResultSet
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 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(int columnIndex, java.lang.String x) throws SQLException
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.
updateString
in interface ResultSet
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 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(int columnIndex, byte[] x) throws SQLException
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.
updateBytes
in interface ResultSet
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 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 updateDate(int columnIndex, Date x) throws SQLException
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.
updateDate
in interface ResultSet
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 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 updateTime(int columnIndex, Time x) throws SQLException
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.
updateTime
in interface ResultSet
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 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 updateTimestamp(int columnIndex, Timestamp x) throws SQLException
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.
updateTimestamp
in interface ResultSet
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 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 updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws SQLException
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.
updateAsciiStream
in interface ResultSet
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 SQLException
- if this method is invoked public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws SQLException
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.
updateBinaryStream
in interface ResultSet
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 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 updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws SQLException
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.
updateCharacterStream
in interface ResultSet
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 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 updateObject(int columnIndex, java.lang.Object x, int scale) throws SQLException
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.
updateObject
in interface ResultSet
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) 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, java.lang.Object x) throws SQLException
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.
updateObject
in interface ResultSet
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 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 updateNull(java.lang.String columnName) throws SQLException
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.
updateNull
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case 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 updateBoolean(java.lang.String columnName, boolean x) throws SQLException
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.
updateBoolean
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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(java.lang.String columnName, byte x) throws SQLException
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.
updateByte
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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 updateShort(java.lang.String columnName, short x) throws SQLException
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.
updateShort
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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(java.lang.String columnName, int x) throws SQLException
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.
updateInt
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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 updateLong(java.lang.String columnName, long x) throws SQLException
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.
updateLong
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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(java.lang.String columnName, float x) throws SQLException
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.
updateFloat
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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(java.lang.String columnName, double x) throws SQLException
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.
updateDouble
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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 updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws SQLException
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.
updateBigDecimal
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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(java.lang.String columnName, java.lang.String x) throws SQLException
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.
updateString
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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(java.lang.String columnName, byte[] x) throws SQLException
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.
updateBytes
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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 updateDate(java.lang.String columnName, Date x) throws SQLException
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.
updateDate
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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 updateTime(java.lang.String columnName, Time x) throws SQLException
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.
updateTime
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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(java.lang.String columnName, Timestamp x) throws SQLException
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.
updateTimestamp
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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 void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws SQLException
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.
updateAsciiStream
in interface ResultSet
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 SQLException
- if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws SQLException
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.
updateBinaryStream
in interface ResultSet
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 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 updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length) throws SQLException
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.
updateCharacterStream
in interface ResultSet
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 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 updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws SQLException
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.
updateObject
in interface ResultSet
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) 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(java.lang.String columnName, java.lang.Object x) throws SQLException
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.
updateObject
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value 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 insertRow() throws SQLException
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.
insertRow
in interface ResultSet
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 void updateRow() throws SQLException
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.
updateRow
in interface ResultSet
SQLException
- if the cursor is on the insert row or this rowset is ResultSet.CONCUR_READ_ONLY
public void deleteRow() throws SQLException
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.
deleteRow
in interface ResultSet
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 refreshRow() throws SQLException
updateRow
or deleteRow
. This method should be called only when the cursor is on a row in this rowset.
refreshRow
in interface ResultSet
SQLException
- if the cursor is on the insert row, before the first row, or after the last row public void cancelRowUpdates() throws SQLException
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.
cancelRowUpdates
in interface ResultSet
SQLException
- if the cursor is on the insert row, before the first row, or after the last row public void moveToInsertRow() throws SQLException
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.
moveToInsertRow
in interface ResultSet
SQLException
- if this CachedRowSetImpl
object is ResultSet.CONCUR_READ_ONLY
public void moveToCurrentRow() throws SQLException
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.
moveToCurrentRow
in interface ResultSet
SQLException
- if an error occurs public StatementgetStatement() throws SQLException
null
.
getStatement
in interface ResultSet
null
SQLException
- if an error occurs public java.lang.Object getObject(int columnIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws SQLException
CachedRowSetImpl
object as an Object
in the Java programming language, using the given java.util.Map
object to custom map the value if appropriate.
getObject
in interface ResultSet
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 Object
representing the SQL value 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 RefgetRef(int columnIndex) throws SQLException
CachedRowSetImpl
object as a Ref
object in the Java programming language.
getRef
in interface ResultSet
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
object representing an SQL REF
value 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 getRef(String)
public BlobgetBlob(int columnIndex) throws SQLException
CachedRowSetImpl
object as a Blob
object in the Java programming language.
getBlob
in interface ResultSet
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 Blob
object representing an SQL BLOB
value 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 getBlob(String)
public ClobgetClob(int columnIndex) throws SQLException
CachedRowSetImpl
object as a Clob
object in the Java programming language.
getClob
in interface ResultSet
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 Clob
object representing an SQL CLOB
value 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 getClob(String)
public ArraygetArray(int columnIndex) throws SQLException
CachedRowSetImpl
object as an Array
object in the Java programming language.
getArray
in interface ResultSet
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 Array
object representing an SQL ARRAY
value 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 getArray(String)
public java.lang.Object getObject(java.lang.String columnName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws SQLException
CachedRowSetImpl
object as an Object
in the Java programming language, using the given java.util.Map
object to custom map the value if appropriate.
getObject
in interface ResultSet
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 Object
representing the SQL value 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 RefgetRef(java.lang.String colName) throws SQLException
CachedRowSetImpl
object as a Ref
object in the Java programming language.
getRef
in interface ResultSet
colName
- a String
object that must match the SQL name of a column in this rowset, ignoring case Ref
object representing an SQL REF
value 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 getRef(int)
public BlobgetBlob(java.lang.String colName) throws SQLException
CachedRowSetImpl
object as a Blob
object in the Java programming language.
getBlob
in interface ResultSet
colName
- a String
object that must match the SQL name of a column in this rowset, ignoring case Blob
object representing an SQL BLOB
value 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 getBlob(int)
public ClobgetClob(java.lang.String colName) throws SQLException
CachedRowSetImpl
object as a Clob
object in the Java programming language.
getClob
in interface ResultSet
colName
- a String
object that must match the SQL name of a column in this rowset, ignoring case Clob
object representing an SQL CLOB
value 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 getClob(int)
public ArraygetArray(java.lang.String colName) throws SQLException
CachedRowSetImpl
object as an Array
object in the Java programming langugage.
getArray
in interface ResultSet
colName
- a String
object that must match the SQL name of a column in this rowset, ignoring case Array
object representing an SQL ARRAY
value 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 getArray(int)
public DategetDate(int columnIndex, java.util.Calendar cal) throws SQLException
CachedRowSetImpl
object as a java.sql.Date
object, using the given Calendar
object to construct an appropriate millisecond value for the date.
getDate
in interface ResultSet
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 NULL
, the result is null
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 DategetDate(java.lang.String columnName, java.util.Calendar cal) throws SQLException
CachedRowSetImpl
object as a java.sql.Date
object, using the given Calendar
object to construct an appropriate millisecond value for the date.
getDate
in interface ResultSet
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 NULL
, the result is null
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 TimegetTime(int columnIndex, java.util.Calendar cal) throws SQLException
CachedRowSetImpl
object as a java.sql.Time
object, using the given Calendar
object to construct an appropriate millisecond value for the date.
getTime
in interface ResultSet
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 NULL
, the result is null
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 TimegetTime(java.lang.String columnName, java.util.Calendar cal) throws SQLException
CachedRowSetImpl
object as a java.sql.Time
object, using the given Calendar
object to construct an appropriate millisecond value for the date.
getTime
in interface ResultSet
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 NULL
, the result is null
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 TimestampgetTimestamp(int columnIndex, java.util.Calendar cal) throws SQLException
CachedRowSetImpl
object as a java.sql.Timestamp
object, using the given Calendar
object to construct an appropriate millisecond value for the date.
getTimestamp
in interface ResultSet
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 NULL
, the result is null
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 TimestampgetTimestamp(java.lang.String columnName, java.util.Calendar cal) throws SQLException
CachedRowSetImpl
object as a java.sql.Timestamp
object, using the given Calendar
object to construct an appropriate millisecond value for the date.
getTimestamp
in interface ResultSet
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 NULL
, the result is null
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 ConnectiongetConnection() throws SQLException
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.
getConnection
in interface RowSetInternal
Connection
object passed to this rowset; may be null
if there is no connection SQLException
- if an error occurs public void setMetaData(RowSetMetaData md) throws SQLException
CachedRowSetImpl
object with the given RowSetMetaData
object.
setMetaData
in interface CachedRowSet
setMetaData
in interface RowSetInternal
md
- a RowSetMetaData
object instance containing metadata about the columsn in the rowset SQLException
- if invalid meta data is supplied to the rowset public ResultSetgetOriginal() throws SQLException
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.
getOriginal
in interface CachedRowSet
getOriginal
in interface RowSetInternal
SQLException
- if an error occurs produce the ResultSet
object public ResultSetgetOriginalRow() throws SQLException
CachedRowSetImpl
after the last population or synchronization (whichever occured most recently) with the data source.
getOriginalRow
in interface CachedRowSet
getOriginalRow
in interface RowSetInternal
SQLException
- if there is no current row setOriginalRow()
public void setOriginalRow() throws SQLException
setOriginalRow
in interface CachedRowSet
SQLException
- if there is no current row getOriginalRow()
public void setOriginal() throws SQLException
setOriginal
connot be reversed.
SQLException
- if an error occurs public java.lang.String getTableName() throws SQLException
getTableName
in interface CachedRowSet
String
object that identifies the table from which this CachedRowSetImpl
object was derived SQLException
- if an error occurs ResultSetMetaData.getTableName(int)
public void setTableName(java.lang.String tabName) throws SQLException
setTableName
in interface CachedRowSet
tabName
- a String
object that identifies the table from which this CachedRowSetImpl
object was derived SQLException
- if an error occurs RowSetMetaData.setTableName(int, java.lang.String)
, RowSetWriter
, SyncProvider
public int[] getKeyColumns() throws SQLException
CachedRowSetImpl
object.
getKeyColumns
in interface CachedRowSet
SQLException
- if the rowset is empty or no columns are designated as primary keys setKeyColumns(int[])
public void setKeyColumns(int[] keys) throws SQLException
CachedRowSetImpl
object's keyCols
field with the given array of column numbers, which forms a key for uniquely identifying a row in this rowset.
setKeyColumns
in interface CachedRowSet
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 SQLException
- if any of the numbers in the given array is not valid for this rowset getKeyColumns()
public void updateRef(int columnIndex, Ref ref) throws SQLException
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.
updateRef
in interface ResultSet
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 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(java.lang.String columnName, Ref ref) throws SQLException
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.
updateRef
in interface ResultSet
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 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(int columnIndex, Clob c) throws SQLException
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.
updateClob
in interface ResultSet
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 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(java.lang.String columnName, Clob c) throws SQLException
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.
updateClob
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case c
- the new column Clob
value 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(int columnIndex, Blob b) throws SQLException
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.
updateBlob
in interface ResultSet
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 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(java.lang.String columnName, Blob b) throws SQLException
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.
updateBlob
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case b
- the new column Blob
value 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 updateArray(int columnIndex, Array a) throws SQLException
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.
updateArray
in interface ResultSet
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 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(java.lang.String columnName, Array a) throws SQLException
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.
updateArray
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case a
- the new column Array
value 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 java.net.URL getURL(int columnIndex) throws SQLException
CachedRowSetImpl
object as a java.net.URL
object in the Java programming language.
getURL
in interface ResultSet
columnIndex
- the index of the column 1 is the first, 2 is the second,... 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. getURL(String)
public java.net.URL getURL(java.lang.String columnName) throws SQLException
CachedRowSetImpl
object as a java.net.URL
object in the Java programming language.
getURL
in interface ResultSet
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 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. getURL(int)
public RowSetWarninggetRowSetWarnings()
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.
getRowSetWarnings
in interface CachedRowSet
RowSetWarning
public void commit() throws SQLException
acceptChanges()
methods
commit
in interface CachedRowSet
SQLException
- if a database access error occurs or this Connection object within this CachedRowSet
is in auto-commit mode Connection.commit()
public void rollback() throws SQLException
acceptChanges()
methods
rollback
in interface CachedRowSet
SQLException
- if a database access error occurs or this Connection object within this CachedRowSet
is in auto-commit mode. Connection.rollback()
public void rollback(Savepoint s) throws SQLException
acceptChanges()
to the last Savepoint
transaction marker.
rollback
in interface CachedRowSet
s
- A Savepoint
transaction marker SQLException
- if a database access error occurs or this Connection object within this CachedRowSet
is in auto-commit mode. Connection.rollback(Savepoint)
public void unsetMatchColumn(int[] columnIdxes) throws SQLException
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.
unsetMatchColumn
in interface Joinable
columnIdxes
- the index into this rowset object's internal representation of parameter values 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 [])
Joinable.setMatchColumn(int)
public void unsetMatchColumn(java.lang.String[] columnIdxes) throws SQLException
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.
unsetMatchColumn
in interface Joinable
columnIdxes
- the index into this rowset object's internal representation of parameter values 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 [])
Joinable.setMatchColumn(int)
public java.lang.String[] getMatchColumnNames() throws SQLException
String
array that was set using setMatchColumn(String [])
for this rowset.
getMatchColumnNames
in interface Joinable
String
array object that contains the column names for the rowset which has this the match columns SQLException
- if an error occurs or column name is not set Joinable.setMatchColumn(int)
, Joinable.unsetMatchColumn(int)
public int[] getMatchColumnIndexes() throws SQLException
int
array that was set using setMatchColumn(int [])
for this rowset.
getMatchColumnIndexes
in interface Joinable
int
array object that contains the column ids for the rowset which has this as the match columns. SQLException
- if an error occurs or column index is not set Joinable.setMatchColumn(int)
, Joinable.unsetMatchColumn(int)
public void setMatchColumn(int[] columnIdxes) throws SQLException
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.
setMatchColumn
in interface Joinable
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 SQLException
- if an error occurs or the parameter index is out of bounds Joinable.setMatchColumn(int[])
, Joinable.unsetMatchColumn(int[])
public void setMatchColumn(java.lang.String[] columnNames) throws SQLException
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.
setMatchColumn
in interface Joinable
columnNames
- the name of the column into this rowset object's internal representation of parameter values SQLException
- if an error occurs or the parameter index is out of bounds Joinable.unsetMatchColumn(int)
, Joinable.setMatchColumn(int[])
public void setMatchColumn(int columnIdx) throws SQLException
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.
setMatchColumn
in interface Joinable
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 SQLException
- if an error occurs or the parameter index is out of bounds Joinable.setMatchColumn(int[])
, Joinable.unsetMatchColumn(int)
public void setMatchColumn(java.lang.String columnName) throws SQLException
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.
setMatchColumn
in interface Joinable
columnName
- the name of the column into this rowset object's internal representation of parameter values SQLException
- if an error occurs or the parameter index is out of bounds Joinable.unsetMatchColumn(int)
, Joinable.setMatchColumn(int[])
public void unsetMatchColumn(int columnIdx) throws SQLException
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.
unsetMatchColumn
in interface Joinable
columnIdx
- the index into this rowset object's internal representation of parameter values 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)
Joinable.setMatchColumn(int)
public void unsetMatchColumn(java.lang.String columnName) throws SQLException
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.
unsetMatchColumn
in interface Joinable
columnName
- the index into this rowset object's internal representation of parameter values 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)
Joinable.setMatchColumn(int)
public void rowSetPopulated(RowSetEvent event, int numRows) throws SQLException
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.
rowSetPopulated
in interface CachedRowSet
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 SQLException
public void populate(ResultSet data, int start) throws SQLException
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.
populate
in interface CachedRowSet
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. SQLException
- if an error occurs; or the max row setting is violated while populating the RowSet.Also id the start position is negative. execute(java.sql.Connection)
public boolean nextPage() throws SQLException
CachedRowSetImpl
object containing the number of rows specified by page size.
nextPage
in interface CachedRowSet
SQLException
- if an error occurs or this called before calling populate. public void setPageSize(int size) throws SQLException
setPageSize
in interface CachedRowSet
size
- which is the page size SQLException
- if size is less than zero or greater than max rows. public int getPageSize()
getPageSize
in interface CachedRowSet
public boolean previousPage() throws SQLException
previousPage
in interface CachedRowSet
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 setRowInserted(boolean insertFlag) throws SQLException
insertFlag
- if it is true - marks this row as inserted if it is false - marks it as not a newly inserted row SQLException
- if an error occurs while doing this operation public SQLXMLgetSQLXML(int columnIndex) throws SQLException
SQL XML
parameter as a SQLXML
object in the Java programming language.
getSQLXML
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... SQLException
- if a database access error occurs public SQLXMLgetSQLXML(java.lang.String colName) throws SQLException
SQL XML
parameter as a SQLXML
object in the Java programming language.
getSQLXML
in interface ResultSet
colName
- the name of the column from which to retrieve the value SQLException
- if a database access error occurs public RowIdgetRowId(int columnIndex) throws SQLException
ResultSet
object as a java.sql.RowId object in the Java programming language.
getRowId
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... NULL
the value returned is null
SQLException
- if a database access error occurs public RowIdgetRowId(java.lang.String columnName) throws SQLException
ResultSet
object as a java.sql.RowId object in the Java programming language.
getRowId
in interface ResultSet
columnName
- the name of the column NULL
the value returned is null
SQLException
- if a database access error occurs public void updateRowId(int columnIndex, RowId x) throws SQLException
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.
updateRowId
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... x
- the column value SQLException
- if a database access occurs public void updateRowId(java.lang.String columnName, RowId x) throws SQLException
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.
updateRowId
in interface ResultSet
columnName
- the name of the column x
- the column value SQLException
- if a database access occurs public int getHoldability() throws SQLException
getHoldability
in interface ResultSet
SQLException
- if a database error occurs public boolean isClosed() throws SQLException
isClosed
in interface ResultSet
SQLException
- if a database access error occurs public void updateNString(int columnIndex, java.lang.String nString) throws SQLException
updateNString
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... nString
- the value for the column to be updated SQLException
- if a database access error occurs public void updateNString(java.lang.String columnName, java.lang.String nString) throws SQLException
updateNString
in interface ResultSet
columnName
- name of the Column nString
- the value for the column to be updated SQLException
- if a database access error occurs public void updateNClob(int columnIndex, NClob nClob) throws SQLException
ResultSet
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.
updateNClob
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... nClob
- the value for the column to be updated SQLException
- if the columnIndex is not valid; 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(java.lang.String columnName, NClob nClob) throws SQLException
NCLOB
type that maps to java.sql.Types.NCLOB
updateNClob
in interface ResultSet
columnName
- name of the column nClob
- the value for the column to be updated SQLException
- if a database access error occurs public NClobgetNClob(int i) throws SQLException
ResultSet
object as a NClob
object in the Java programming language.
getNClob
in interface ResultSet
i
- the first column is 1, the second is 2, ... NClob
object representing the SQL NCLOB
value in the specified column SQLException
- if a database access error occurs public NClobgetNClob(java.lang.String colName) throws SQLException
ResultSet
object as a NClob
object in the Java programming language.
getNClob
in interface ResultSet
colName
- the name of the column from which to retrieve the value NClob
object representing the SQL NCLOB
value in the specified column SQLException
- if a database access error occurs public <T> T unwrap(java.lang.Class<T> iface) throws SQLException
Wrapper
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.
unwrap
in interface Wrapper
iface
- A Class defining an interface that the result must implement. SQLException
- If no object found that implements the interface public boolean isWrapperFor(java.lang.Class<?> interfaces) throws SQLException
Wrapper
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.
isWrapperFor
in interface Wrapper
interfaces
- a Class defining an interface. SQLException
- if an error occurs while determining whether this is a wrapper for an object with the given interface. public void setSQLXML(int parameterIndex, SQLXML xmlObject) throws SQLException
java.sql.SQLXML
object. The driver converts this to an SQL XML
value when it sends it to the database.
setSQLXML
in interface RowSet
setSQLXML
in class BaseRowSet
parameterIndex
- index of the first parameter is 1, the second is 2, ... xmlObject
- a SQLXML
object that maps an SQL XML
value SQLException
- if a database access error occurs public void setSQLXML(java.lang.String parameterName, SQLXML xmlObject) throws SQLException
java.sql.SQLXML
object. The driver converts this to an SQL XML
value when it sends it to the database.
setSQLXML
in interface RowSet
setSQLXML
in class BaseRowSet
parameterName
- the name of the parameter xmlObject
- a SQLXML
object that maps an SQL XML
value SQLException
- if a database access error occurs public void setRowId(int parameterIndex, RowId x) throws SQLException
java.sql.RowId
object. The driver converts this to a SQL ROWID
value when it sends it to the database
setRowId
in interface RowSet
setRowId
in class BaseRowSet
parameterIndex
- the first parameter is 1, the second is 2, ... x
- the parameter value SQLException
- if a database access error occurs public void setRowId(java.lang.String parameterName, RowId x) throws SQLException
java.sql.RowId
object. The driver converts this to a SQL ROWID
when it sends it to the database.
setRowId
in interface RowSet
setRowId
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs public void setNCharacterStream(int parameterIndex, java.io.Reader value) throws SQLException
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.
setNCharacterStream
in interface RowSet
setNCharacterStream
in class BaseRowSet
parameterIndex
- of the first parameter is 1, the second is 2, ... value
- the parameter value 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 setNClob(java.lang.String parameterName, NClob value) throws SQLException
java.sql.NClob
object. The object implements the java.sql.NClob
interface. This NClob
object maps to a SQL NCLOB
.
setNClob
in interface RowSet
setNClob
in class BaseRowSet
parameterName
- the name of the column to be set value
- the parameter value 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 java.io.Reader getNCharacterStream(int columnIndex) throws SQLException
ResultSet
object as a java.io.Reader
object. It is intended for use when accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNCharacterStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... 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. SQLException
- if a database access error occurs public java.io.Reader getNCharacterStream(java.lang.String columnName) throws SQLException
ResultSet
object as a java.io.Reader
object. It is intended for use when accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNCharacterStream
in interface ResultSet
columnName
- the name of the column 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 SQLException
- if a database access error occurs public void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException
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.
updateSQLXML
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... xmlObject
- the value for the column to be updated SQLException
- if a database access error occurs public void updateSQLXML(java.lang.String columnName, SQLXML xmlObject) throws SQLException
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.
updateSQLXML
in interface ResultSet
columnName
- the name of the column xmlObject
- the column value SQLException
- if a database access occurs public java.lang.String getNString(int columnIndex) throws SQLException
ResultSet
object as a String
in the Java programming language. It is intended for use when accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNString
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... NULL
, the value returned is null
SQLException
- if a database access error occurs public java.lang.String getNString(java.lang.String columnName) throws SQLException
ResultSet
object as a String
in the Java programming language. It is intended for use when accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNString
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is null
SQLException
- if a database access error occurs public void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws SQLException
updateNCharacterStream
in interface ResultSet
columnIndex
- - the first column is 1, the second is 2, ... x
- - the new column value length
- - the length of the stream SQLException
- if a database access error occurs public void updateNCharacterStream(java.lang.String columnName, java.io.Reader x, long length) throws SQLException
updateNCharacterStream
in interface ResultSet
columnName
- - name of the Column x
- - the new column value length
- - the length of the stream SQLException
- if a database access error occurs public void updateNCharacterStream(int columnIndex, java.io.Reader x) throws SQLException
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.
updateNCharacterStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value 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(java.lang.String columnLabel, java.io.Reader reader) throws SQLException
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.
updateNCharacterStream
in interface ResultSet
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 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, java.io.InputStream inputStream, long length) throws SQLException
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.
updateBlob
in interface ResultSet
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. 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(java.lang.String columnLabel, java.io.InputStream inputStream, long length) throws SQLException
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.
updateBlob
in interface ResultSet
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. 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, java.io.InputStream inputStream) throws SQLException
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.
updateBlob
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... inputStream
- An object that contains the data to set the parameter value to. 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(java.lang.String columnLabel, java.io.InputStream inputStream) throws SQLException
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.
updateBlob
in interface ResultSet
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. 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, java.io.Reader reader, long length) throws SQLException
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.
updateClob
in interface ResultSet
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. 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(java.lang.String columnLabel, java.io.Reader reader, long length) throws SQLException
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.
updateClob
in interface ResultSet
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. 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, java.io.Reader reader) throws SQLException
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.
updateClob
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... reader
- An object that contains the data to set the parameter value to. 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(java.lang.String columnLabel, java.io.Reader reader) throws SQLException
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.
updateClob
in interface ResultSet
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. 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(int columnIndex, java.io.Reader reader, long length) throws SQLException
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.
updateNClob
in interface ResultSet
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. 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(java.lang.String columnLabel, java.io.Reader reader, long length) throws SQLException
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.
updateNClob
in interface ResultSet
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. 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, java.io.Reader reader) throws SQLException
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.
updateNClob
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... reader
- An object that contains the data to set the parameter value to. 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(java.lang.String columnLabel, java.io.Reader reader) throws SQLException
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.
updateNClob
in interface ResultSet
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. 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 updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws SQLException
updateRow
or insertRow
methods are called to update the database.
updateAsciiStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value length
- the length of the stream 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, java.io.InputStream x, long length) throws SQLException
updateRow
or insertRow
methods are called to update the database.
updateBinaryStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value length
- the length of the stream 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, java.io.Reader x, long length) throws SQLException
updateRow
or insertRow
methods are called to update the database.
updateCharacterStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value length
- the length of the stream 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(java.lang.String columnLabel, java.io.Reader reader, long length) throws SQLException
updateRow
or insertRow
methods are called to update the database.
updateCharacterStream
in interface ResultSet
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 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(java.lang.String columnLabel, java.io.InputStream x, long length) throws SQLException
updateRow
or insertRow
methods are called to update the database.
updateAsciiStream
in interface ResultSet
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 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(java.lang.String columnLabel, java.io.InputStream x, long length) throws SQLException
updateRow
or insertRow
methods are called to update the database.
updateBinaryStream
in interface ResultSet
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 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, java.io.InputStream x) throws SQLException
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.
updateBinaryStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value 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(java.lang.String columnLabel, java.io.InputStream x) throws SQLException
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.
updateBinaryStream
in interface ResultSet
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 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, java.io.Reader x) throws SQLException
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.
updateCharacterStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value 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(java.lang.String columnLabel, java.io.Reader reader) throws SQLException
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.
updateCharacterStream
in interface ResultSet
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 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, java.io.InputStream x) throws SQLException
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.
updateAsciiStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value 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(java.lang.String columnLabel, java.io.InputStream x) throws SQLException
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.
updateAsciiStream
in interface ResultSet
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 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 setURL(int parameterIndex, java.net.URL x) throws SQLException
java.net.URL
value. The driver converts this to an SQL DATALINK
value when it sends it to the database.
setURL
in interface RowSet
setURL
in class BaseRowSet
parameterIndex
- the first parameter is 1, the second is 2, ... x
- the java.net.URL
object to be set 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 void setNClob(int parameterIndex, java.io.Reader reader) throws SQLException
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.
setNClob
in interface RowSet
setNClob
in class BaseRowSet
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. 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(java.lang.String parameterName, java.io.Reader reader, long length) throws SQLException
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
setNClob
in interface RowSet
setNClob
in class BaseRowSet
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. 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(java.lang.String parameterName, java.io.Reader reader) throws SQLException
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.
setNClob
in interface RowSet
setNClob
in class BaseRowSet
parameterName
- the name of the parameter reader
- An object that contains the data to set the parameter value to. 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, java.io.Reader reader, long length) throws SQLException
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
setNClob
in interface RowSet
setNClob
in class BaseRowSet
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. 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 setNClob(int parameterIndex, NClob value) throws SQLException
java.sql.NClob
object. The driver converts this to a SQL NCLOB
value when it sends it to the database.
setNClob
in interface RowSet
setNClob
in class BaseRowSet
parameterIndex
- of the first parameter is 1, the second is 2, ... value
- the parameter value 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, java.lang.String value) throws SQLException
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.
setNString
in interface RowSet
setNString
in class BaseRowSet
parameterIndex
- of the first parameter is 1, the second is 2, ... value
- the parameter value 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(java.lang.String parameterName, java.lang.String value) throws SQLException
String
object. The driver converts this to a SQL NCHAR
or NVARCHAR
or LONGNVARCHAR
setNString
in interface RowSet
setNString
in class BaseRowSet
parameterName
- the name of the column to be set value
- the parameter value 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, java.io.Reader value, long length) throws SQLException
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.
setNCharacterStream
in interface RowSet
setNCharacterStream
in class BaseRowSet
parameterIndex
- of the first parameter is 1, the second is 2, ... value
- the parameter value length
- the number of characters in the parameter data. 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(java.lang.String parameterName, java.io.Reader value, long length) throws SQLException
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.
setNCharacterStream
in interface RowSet
setNCharacterStream
in class BaseRowSet
parameterName
- the name of the column to be set value
- the parameter value length
- the number of characters in the parameter data. 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(java.lang.String parameterName, java.io.Reader value) throws SQLException
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.
setNCharacterStream
in interface RowSet
setNCharacterStream
in class BaseRowSet
parameterName
- the name of the parameter value
- the parameter value 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 setTimestamp(java.lang.String parameterName, Timestamp x, java.util.Calendar cal) throws SQLException
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.
setTimestamp
in interface RowSet
setTimestamp
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value cal
- the Calendar
object the driver will use to construct the timestamp 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 getTimestamp(int)
public void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws SQLException
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
setClob
in interface RowSet
setClob
in class BaseRowSet
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. 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(java.lang.String parameterName, Clob x) throws SQLException
java.sql.Clob
object. The driver converts this to an SQL CLOB
value when it sends it to the database.
setClob
in interface RowSet
setClob
in class BaseRowSet
parameterName
- the name of the parameter x
- a Clob
object that maps an SQL CLOB
value 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(java.lang.String parameterName, java.io.Reader reader) throws SQLException
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.
setClob
in interface RowSet
setClob
in class BaseRowSet
parameterName
- the name of the parameter reader
- An object that contains the data to set the parameter value to. 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 setDate(java.lang.String parameterName, Date x) throws SQLException
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.
setDate
in interface RowSet
setDate
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getDate(int)
public void setDate(java.lang.String parameterName, Date x, java.util.Calendar cal) throws SQLException
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.
setDate
in interface RowSet
setDate
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value cal
- the Calendar
object the driver will use to construct the date 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 getDate(int)
public void setTime(java.lang.String parameterName, Time x) throws SQLException
java.sql.Time
value. The driver converts this to an SQL TIME
value when it sends it to the database.
setTime
in interface RowSet
setTime
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getTime(int)
public void setTime(java.lang.String parameterName, Time x, java.util.Calendar cal) throws SQLException
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.
setTime
in interface RowSet
setTime
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value cal
- the Calendar
object the driver will use to construct the time 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 getTime(int)
public void setClob(int parameterIndex, java.io.Reader reader) throws SQLException
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.
setClob
in interface RowSet
setClob
in class BaseRowSet
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. 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 setClob(int parameterIndex, java.io.Reader reader, long length) throws SQLException
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
setClob
in interface RowSet
setClob
in class BaseRowSet
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. 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 setBlob(int parameterIndex, java.io.InputStream inputStream, long length) throws SQLException
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
setBlob
in interface RowSet
setBlob
in class BaseRowSet
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. 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(int parameterIndex, java.io.InputStream inputStream) throws SQLException
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.
setBlob
in interface RowSet
setBlob
in class BaseRowSet
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. 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(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws SQLException
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
setBlob
in interface RowSet
setBlob
in class BaseRowSet
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. 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(java.lang.String parameterName, Blob x) throws SQLException
java.sql.Blob
object. The driver converts this to an SQL BLOB
value when it sends it to the database.
setBlob
in interface RowSet
setBlob
in class BaseRowSet
parameterName
- the name of the parameter x
- a Blob
object that maps an SQL BLOB
value 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(java.lang.String parameterName, java.io.InputStream inputStream) throws SQLException
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.
setBlob
in interface RowSet
setBlob
in class BaseRowSet
parameterName
- the name of the parameter inputStream
- An object that contains the data to set the parameter value to. 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(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws SQLException
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.
setObject
in interface RowSet
setObject
in class BaseRowSet
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. 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 Types
, getObject(int)
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws SQLException
setObject
above, except that it assumes a scale of zero.
setObject
in interface RowSet
setObject
in class BaseRowSet
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 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 getObject(int)
public void setObject(java.lang.String parameterName, java.lang.Object x) throws SQLException
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.
setObject
in interface RowSet
setObject
in class BaseRowSet
parameterName
- the name of the parameter x
- the object containing the input parameter value 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 getObject(int)
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws SQLException
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.
setAsciiStream
in interface RowSet
setAsciiStream
in class BaseRowSet
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 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(java.lang.String parameterName, java.io.InputStream x, int length) throws SQLException
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.
setBinaryStream
in interface RowSet
setBinaryStream
in class BaseRowSet
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 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(java.lang.String parameterName, java.io.Reader reader, int length) throws SQLException
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.
setCharacterStream
in interface RowSet
setCharacterStream
in class BaseRowSet
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 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(java.lang.String parameterName, java.io.InputStream x) throws SQLException
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.
setAsciiStream
in interface RowSet
setAsciiStream
in class BaseRowSet
parameterName
- the name of the parameter x
- the Java input stream that contains the ASCII parameter value 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(java.lang.String parameterName, java.io.InputStream x) throws SQLException
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.
setBinaryStream
in interface RowSet
setBinaryStream
in class BaseRowSet
parameterName
- the name of the parameter x
- the java input stream which contains the binary parameter value 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(java.lang.String parameterName, java.io.Reader reader) throws SQLException
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.
setCharacterStream
in interface RowSet
setCharacterStream
in class BaseRowSet
parameterName
- the name of the parameter reader
- the java.io.Reader
object that contains the Unicode data 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(java.lang.String parameterName, java.math.BigDecimal x) throws SQLException
java.math.BigDecimal
value. The driver converts this to an SQL NUMERIC
value when it sends it to the database.
setBigDecimal
in interface RowSet
setBigDecimal
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getBigDecimal(int, int)
public void setString(java.lang.String parameterName, java.lang.String x) throws SQLException
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.
setString
in interface RowSet
setString
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getString(int)
public void setBytes(java.lang.String parameterName, byte[] x) throws SQLException
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.
setBytes
in interface RowSet
setBytes
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getBytes(int)
public void setTimestamp(java.lang.String parameterName, Timestamp x) throws SQLException
java.sql.Timestamp
value. The driver converts this to an SQL TIMESTAMP
value when it sends it to the database.
setTimestamp
in interface RowSet
setTimestamp
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getTimestamp(int)
public void setNull(java.lang.String parameterName, int sqlType) throws SQLException
NULL
.Note: You must specify the parameter's SQL type.
setNull
in interface RowSet
setNull
in class BaseRowSet
parameterName
- the name of the parameter sqlType
- the SQL type code defined in java.sql.Types
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(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws SQLException
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.
setNull
in interface RowSet
setNull
in class BaseRowSet
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 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(java.lang.String parameterName, boolean x) throws SQLException
boolean
value. The driver converts this to an SQL BIT
or BOOLEAN
value when it sends it to the database.
setBoolean
in interface RowSet
setBoolean
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getBoolean(int)
public void setByte(java.lang.String parameterName, byte x) throws SQLException
byte
value. The driver converts this to an SQL TINYINT
value when it sends it to the database.
setByte
in interface RowSet
setByte
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getByte(int)
public void setShort(java.lang.String parameterName, short x) throws SQLException
short
value. The driver converts this to an SQL SMALLINT
value when it sends it to the database.
setShort
in interface RowSet
setShort
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getShort(int)
public void setInt(java.lang.String parameterName, int x) throws SQLException
int
value. The driver converts this to an SQL INTEGER
value when it sends it to the database.
setInt
in interface RowSet
setInt
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getInt(int)
public void setLong(java.lang.String parameterName, long x) throws SQLException
long
value. The driver converts this to an SQL BIGINT
value when it sends it to the database.
setLong
in interface RowSet
setLong
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getLong(int)
public void setFloat(java.lang.String parameterName, float x) throws SQLException
float
value. The driver converts this to an SQL FLOAT
value when it sends it to the database.
setFloat
in interface RowSet
setFloat
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getFloat(int)
public void setDouble(java.lang.String parameterName, double x) throws SQLException
double
value. The driver converts this to an SQL DOUBLE
value when it sends it to the database.
setDouble
in interface RowSet
setDouble
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value 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 getDouble(int)
public <T> T getObject(int columnIndex, java.lang.Class<T> type) throws SQLException
ResultSet
Retrieves the value of the designated column in the current row of this ResultSet
object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported. If the conversion is not supported or null is specified for the type, a SQLException
is thrown.
At the minimum an implementation must support the conversions defined in Appendix B, Table B-1 and conversion of appropriate user defined SQL types to a Java type which implements SQLData
. Additional conversions may be supported and are vendor defined.
getObject
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... type
- Class representing the Java data type to convert the designated column to. type
holding the column value SQLException
- if conversion is not supported, type is null or another error occurs public <T> T getObject(java.lang.String columnLabel, java.lang.Class<T> type) throws SQLException
ResultSet
Retrieves the value of the designated column in the current row of this ResultSet
object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported. If the conversion is not supported or null is specified for the type, a SQLException
is thrown.
At the minimum an implementation must support the conversions defined in Appendix B, Table B-1 and conversion of appropriate user defined SQL types to a Java type which implements SQLData
. Additional conversions may be supported and are vendor defined.
getObject
in interface ResultSet
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 type
- Class representing the Java data type to convert the designated column to. type
holding the column value SQLException
- if conversion is not supported, type is null or another error occurs
| ||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES All Classes | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |