APIdia Launch Partner
Top Description Fields Constructors Methods
com.sun.rowset

public Class CachedRowSetImpl

extends BaseRowSet
implements RowSet, RowSetInternal, Serializable, Cloneable, CachedRowSet
Class Inheritance
All Implemented Interfaces
javax.sql.rowset.CachedRowSet, javax.sql.rowset.Joinable, javax.sql.RowSet, java.sql.ResultSet, java.lang.AutoCloseable, java.sql.Wrapper, java.lang.Cloneable, java.io.Serializable, javax.sql.RowSetInternal
Known Direct Subclasses
com.sun.rowset.WebRowSetImpl, com.sun.rowset.internal.SyncResolverImpl
Imports
java.sql.*, javax.sql.*, java.io.*, java.math.*, java.util.*, java.text.*, javax.sql.rowset.*, javax.sql.rowset.spi.*, javax.sql.rowset.serial.*, com.sun.rowset.internal.*, com.sun.rowset.providers.*

The standard implementation of the CachedRowSet interface. See interface definition for full behavior 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.
Author
Jonathan Bruce, Amit Handa

Field Summary

Modifier and TypeField and Description
private int
absolutePos

The current position of the cursor in this CachedRowSetImpl object not counting rows that have been deleted, if any.

private boolean
callWithCon

The boolean value indicating how the CahedRowSet object has been populated for paging purpose.

private transient Connection
conn

The Connection object that connects with this CachedRowSetImpl object's current underlying data source.

private CachedRowSetReader
crsReader

CachedRowSet reader object to read the data from the ResultSet when a connection parameter is passed to populate the CachedRowSet object for paging.

private int
currentRow

The field that temporarily holds the last position of the cursor before it moved to the insert row, thus preserving the number of the current row to which the cursor may return.

private int
cursorPos

The current position of the cursor in this CachedRowSetImpl object.

private boolean
dbmslocatorsUpdateCopy

The boolean variable indicating locatorsUpdateValue

private String
DEFAULT_SYNC_PROVIDER

The default SyncProvider for the RI CachedRowSetImpl

private int
endPos

The integer value indicating the end position in the ResultSetwhere the picking up of rows for populating a CachedRowSet object was left off.

private int
iMatchColumn

Used to track match column for JoinRowSet consumption

private Vector<Integer>
iMatchColumns

The Vector holding the Match Columns

private InsertRow
insertRow

A special row used for constructing a new row.

private int[]
keyCols

An array containing the columns in this CachedRowSetImpl object that form a unique identifier for a row.

private boolean
lastValueNull

A boolean indicating whether the last value returned was an SQL NULL.

private int
maxRowsreached

The integer value indicating number of rows that have been processed so far.

private int
numDeleted

The number of deleted rows currently in this CachedRowSetImpl object.

private int
numRows

The total number of rows currently in this CachedRowSetImpl object.

private boolean
onFirstPage

The boolean value indicating whether this is the first page or not.

private boolean
onInsertRow

A boolean indicating whether the cursor is currently on the insert row.

private boolean
onLastPage

The boolean value indicating whether this is the last page or not.

private boolean
pagenotend

The boolean value when true signifies that pages are still to follow and a false value indicates that this is the last page.

private int
pageSize

The integer value indicating size of the page.

private int
populatecallcount

The integer value indicating how many times the populate function has been called.

private int
prevEndPos

The integer value indicating the end position in the ResultSetwhere the picking up of rows for populating a CachedRowSet object was left off.

private SyncProvider
provider

The SyncProvider used by the CachedRowSet

protected transient JdbcRowSetResourceBundle
private transient ResultSet
resultSet

The ResultSet object that is used to maintain the data when a ResultSet and start position are passed as parameters to the populate function

private RowSetMetaDataImpl
RowSetMD

The RowSetMetaData object that contains information about the columns in this CachedRowSetImpl object.

private RowSetReader
rowSetReader

The RowSetReaderImpl object that is the reader for this rowset.

private RowSetWarning
rowsetWarning

A RowSetWarning which logs on the warnings

private RowSetWriter
rowSetWriter

The RowSetWriterImpl object that is the writer for this rowset.

private transient ResultSetMetaData
RSMD

The ResultSetMetaData object that contains information about the columns in the ResultSet object that is the current source of data for this CachedRowSetImpl object.

private Vector<Object>
rvh

A Vector object containing the Row objects that comprise this CachedRowSetImpl object.

pack-priv static final long
private SQLWarning
sqlwarn

A SQLWarning which logs on the warnings

private int
startPos

The integer value indicating the position in the ResultSet, to populate the CachedRowSet object.

private int
startPrev

The integer value indicating the position from where the page prior to this was populated.

private String
strMatchColumn

Used to track match column for JoinRowSet consumption

private Vector<String>
strMatchColumns

The Vector that will hold the Match Column names.

private String
tableName

The name of the table in the underlying database to which updates should be written.

private int
totalRows

The integer value indicating the total number of rows to be processed in the ResultSet object passed to the populate function.

private TransactionalWriter
tWriter

The field object for a transactional RowSet writer

private boolean
tXWriter

Trigger that indicates whether the active SyncProvider is exposes the additional TransactionalWriter method

private boolean
Inherited from javax.sql.rowset.BaseRowSet:
ASCII_STREAM_PARAMasciiStreamBINARY_STREAM_PARAMbinaryStreamcharStreamUNICODE_STREAM_PARAMunicodeStream

Constructor Summary

AccessConstructor and Description
public
CachedRowSetImpl()

Constructs a new default CachedRowSetImpl object with the capacity to hold 100 rows.

public
CachedRowSetImpl(Hashtable<K, V>
a Hashtable object with a list of desired synchronization providers
env
)

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

Method Summary

Modifier and TypeMethod and Description
public boolean

Returns:

true if the cursor is on the rowset; false otherwise
absolute
(int
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
row
)

Implements java.sql.ResultSet.absolute.

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

public void
acceptChanges()

Implements javax.sql.rowset.CachedRowSet.acceptChanges.

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

public void
acceptChanges(Connection
a standard JDBC Connection object
con
)

Implements javax.sql.rowset.CachedRowSet.acceptChanges.

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

public void
afterLast()

Implements java.sql.ResultSet.afterLast.

Moves this CachedRowSetImpl object's cursor to the end of the rowset, just after the last row.

public void
beforeFirst()

Implements java.sql.ResultSet.beforeFirst.

Moves this CachedRowSetImpl object's cursor to the front of the rowset, just before the first row.

private String

Returns:

the tablename if only one table in query else return ""
buildTableName
(String command)

The function tries to isolate the tablename when only setCommand is set and not setTablename is called provided there is only one table name in the query else just leaves the setting of table name as such.

public void
cancelRowUpdates()

Implements java.sql.ResultSet.cancelRowUpdates.

Rolls back any updates made to the current row of this CachedRowSetImpl object and notifies listeners that a row has changed.

private void
checkCursor()

Checks to see whether the cursor for this CachedRowSetImpl object is on a row in the rowset and throws an SQLException if it is not.

private void
checkIndex(int
the number of a column in this CachedRowSetImpl object; must be between 1 and the number of rows in this rowset
idx
)

Checks to see whether the given index is a valid column number in this CachedRowSetImpl object and throws an SQLException if it is not.

private void
checkTransactionalWriter()

Determine whether the SyncProvider's writer implements the TransactionalWriter interface

public void
clearWarnings()

Implements java.sql.ResultSet.clearWarnings.

Clears all the warnings reporeted for the CachedRowSetImpl object.

protected Object

Returns:

a copy of this CachedRowSetImpl object
clone
()

Overrides java.lang.Object.clone.

Returns a new RowSet object containing by the same data as this CachedRowSetImpl object.

public void
close()

Implements java.sql.ResultSet.close.

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

public boolean

Returns:

true is the designated column has been updated and the rowset detects updates; false if the rowset has not been updated or the rowset does not detect updates
columnUpdated
(int
the index identifier of the column that may be have been updated.
idx
)

Implements javax.sql.rowset.CachedRowSet.columnUpdated.

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

public boolean

Returns:

true is the designated column has been updated and the rowset detects updates; false if the rowset has not been updated or the rowset does not detect updates
columnUpdated
(String
the String column name column that may be have been updated.
columnName
)

Implements javax.sql.rowset.CachedRowSet.columnUpdated.

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

public void
commit()

Implements javax.sql.rowset.CachedRowSet.commit.

Commits all changes performed by the acceptChanges() methods

private Object

Returns:

an Object value.that is the standard object mapping for the target SQL type
convertBoolean
(Object
the Object in the Java programming language that is to be converted to the target type
srcObj
,
int
the data type that is the standard mapping in SQL of the object to be converted; must be one of the constants in java.sql.Types
srcType
,
int
the SQL data type to which to convert the given object; must be one of the following constants in java.sql.Types: BIT, or BOOLEAN
trgType
)

Converts the given Object in the Java programming language to the standard mapping for the specified SQL target data type.

private Object

Returns:

an Object value.that is the standard object mapping for the target SQL type
convertNumeric
(Object
the Object in the Java programming language that is to be converted to the target type
srcObj
,
int
the data type that is the standard mapping in SQL of the object to be converted; must be one of the constants in java.sql.Types
srcType
,
int
the SQL data type to which to convert the given object; must be one of the following constants in java.sql.Types: NUMERIC, DECIMAL, BIT, TINYINT, SMALLINT, INTEGER, BIGINT, REAL, DOUBLE, FLOAT, VARCHAR, LONGVARCHAR, or CHAR
trgType
)

Converts the given Object in the Java programming language to the standard mapping for the specified SQL target data type.

private Object

Returns:

an Object value.that is the standard object mapping for the target SQL type
convertTemporal
(Object
the Object in the Java programming language that is to be converted to the target type
srcObj
,
int
the data type that is the standard mapping in SQL of the object to be converted; must be one of the constants in java.sql.Types
srcType
,
int
the SQL data type to which to convert the given object; must be one of the following constants in java.sql.Types: DATE, TIME, TIMESTAMP, CHAR, VARCHAR, or LONGVARCHAR
trgType
)

Converts the given Object in the Java programming language to the standard object mapping for the specified SQL target data type.

public CachedRowSet

Returns:

a new CachedRowSet object that is a deep copy of this CachedRowSet object and is completely independent from this CachedRowSetImpl object.
createCopy
()

Implements javax.sql.rowset.CachedRowSet.createCopy.

Creates a RowSet object that is a deep copy of this CachedRowSetImpl object's data, including constraints.

public CachedRowSet

Returns:

a new CachedRowSet object that is a deep copy of this CachedRowSetImpl object and is completely independent from this CachedRowSetImpl object
createCopyNoConstraints
()

Implements javax.sql.rowset.CachedRowSet.createCopyNoConstraints.

Creates a CachedRowSet object that is a copy of this CachedRowSetImpl object's data only.

public CachedRowSet

Returns:

a new CachedRowSet object that is a copy of this CachedRowSetImpl object's schema and retains all the constraints on the original rowset but contains no data
createCopySchema
()

Implements javax.sql.rowset.CachedRowSet.createCopySchema.

Creates a RowSet object that is a copy of this CachedRowSetImpl object's table structure and the constraints only.

public RowSet

Returns:

a RowSet object that is a copy of this CachedRowSetImpl object and shares a set of cursors with it
createShared
()

Implements javax.sql.rowset.CachedRowSet.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.

public void
deleteRow()

Implements java.sql.ResultSet.deleteRow.

Deletes the current row from this CachedRowSetImpl object and notifies listeners registered with this rowset that a row has changed.

private void
establishTransactionalWriter()

Sets an private field to all transaction bounddaries to be set

public void
execute(Connection
A standard JDBC Connection object that this CachedRowSet object can pass to a synchronization provider to establish a connection to the data source
conn
)

Implements javax.sql.rowset.CachedRowSet.execute.

Populates this CachedRowSetImpl object with data, using the given connection to produce the result set from which data will be read.

public void
execute()

Implements javax.sql.RowSet.execute.

Populates this CachedRowSetImpl object with data.

public int

Returns:

the column index of the given column name
findColumn
(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
)

Implements java.sql.ResultSet.findColumn.

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

public boolean

Returns:

true if the cursor is on a valid row; false otherwise or if there are no rows in this CachedRowSetImpl object
first
()

Implements java.sql.ResultSet.first.

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

public Array

Returns:

an Array object representing an SQL ARRAY value
getArray
(int
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
columnIndex
)

Implements java.sql.ResultSet.getArray.

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

public Array

Returns:

an Array object representing an SQL ARRAY value
getArray
(String
a String object that must match the SQL name of a column in this rowset, ignoring case
colName
)

Implements java.sql.ResultSet.getArray.

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

public InputStream

Returns:

a Java input stream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQL NULL, the result is null.
getAsciiStream
(int
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
columnIndex
)

Implements java.sql.ResultSet.getAsciiStream.

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

public InputStream

Returns:

a Java input stream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQL NULL, the result is null.
getAsciiStream
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getAsciiStream.

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

public BigDecimal

Returns:

the column value with the specified number of digits to the right of the decimal point; if the value is SQL NULL, the result is null
getBigDecimal
(int
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
columnIndex
,
int
the number of digits to the right of the decimal point in the value returned
scale
)

Implements java.sql.ResultSet.getBigDecimal.

Deprecated

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

public BigDecimal

Returns:

a java.math.BugDecimal object with scale number of digits to the right of the decimal point.
getBigDecimal
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
,
int
the number of digits to the right of the decimal point
scale
)

Implements java.sql.ResultSet.getBigDecimal.

Deprecated Use the getBigDecimal(String columnName) method instead

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

public BigDecimal

Returns:

a java.math.BigDecimal value with full precision; if the value is SQL NULL, the result is null
getBigDecimal
(int
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
columnIndex
)

Implements java.sql.ResultSet.getBigDecimal.

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

public BigDecimal

Returns:

a java.math.BigDecimal value with full precision; if the value is SQL NULL, the result is null
getBigDecimal
(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
)

Implements java.sql.ResultSet.getBigDecimal.

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

public InputStream

Returns:

a Java input stream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL then the result is null.
getBinaryStream
(int
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
columnIndex
)

Implements java.sql.ResultSet.getBinaryStream.

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

public InputStream

Returns:

a Java input stream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL, the result is null.
getBinaryStream
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getBinaryStream.

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

public Blob

Returns:

a Blob object representing an SQL BLOB value
getBlob
(int
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
columnIndex
)

Implements java.sql.ResultSet.getBlob.

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

public Blob

Returns:

a Blob object representing an SQL BLOB value
getBlob
(String
a String object that must match the SQL name of a column in this rowset, ignoring case
colName
)

Implements java.sql.ResultSet.getBlob.

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

public boolean

Returns:

the column value as a boolean in the Java programming language; if the value is SQL NULL, the result is false
getBoolean
(int
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
columnIndex
)

Implements java.sql.ResultSet.getBoolean.

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

public boolean

Returns:

the column value as a boolean in the Java programming language; if the value is SQL NULL, the result is false
getBoolean
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getBoolean.

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

public byte

Returns:

the column value as a byte in the Java programming language; if the value is SQL NULL, the result is 0
getByte
(int
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
columnIndex
)

Implements java.sql.ResultSet.getByte.

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

public byte

Returns:

the column value as a byte in the Java programming language; if the value is SQL NULL, the result is 0
getByte
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getByte.

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

public byte[]

Returns:

the column value as a byte array in the Java programming language; if the value is SQL NULL, the result is null
getBytes
(int
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
columnIndex
)

Implements java.sql.ResultSet.getBytes.

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

public byte[]

Returns:

the column value as a byte array in the Java programming language; if the value is SQL NULL, the result is null
getBytes
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getBytes.

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

public Reader

Returns:

a Java character stream that delivers the database column value as a stream of two-byte unicode characters in a java.io.Reader object. If the value is SQL NULL, the result is null.
getCharacterStream
(int
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
columnIndex
)

Implements java.sql.ResultSet.getCharacterStream.

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

public Reader

Returns:

a Java input stream that delivers the database column value as a stream of two-byte Unicode characters. If the value is SQL NULL, the result is null.
getCharacterStream
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getCharacterStream.

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

public Clob

Returns:

a Clob object representing an SQL CLOB value
getClob
(int
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
columnIndex
)

Implements java.sql.ResultSet.getClob.

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

public Clob

Returns:

a Clob object representing an SQL CLOB value
getClob
(String
a String object that must match the SQL name of a column in this rowset, ignoring case
colName
)

Implements java.sql.ResultSet.getClob.

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

private int
getColIdxByName(String
a String object that is the name of a column in this CachedRowSetImpl object
name
)

Returns the column number of the column with the given name in this CachedRowSetImpl object.

public Connection

Returns:

the Connection object passed to this rowset; may be null if there is no connection
getConnection
()

Implements javax.sql.RowSetInternal.getConnection.

Retrieves the Connection object passed to this CachedRowSetImpl object.

protected BaseRow

Returns:

the Row object on which this CachedRowSetImpl objects's cursor is positioned
getCurrentRow
()

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

public String

Returns:

the SQL cursor name for this CachedRowSetImpl object's cursor
getCursorName
()

Implements java.sql.ResultSet.getCursorName.

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

public Date

Returns:

the column value as a java.sql.Data object; if the value is SQL NULL, the result is null
getDate
(int
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
columnIndex
)

Implements java.sql.ResultSet.getDate.

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

public Date

Returns:

the column value; if the value is SQL NULL, the result is null
getDate
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getDate.

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

public Date

Returns:

the column value; if the value is SQL NULL, the result is null
getDate
(int
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
columnIndex
,
Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getDate.

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.

public Date

Returns:

the column value; if the value is SQL NULL, the result is null
getDate
(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getDate.

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.

public double

Returns:

the column value; if the value is SQL NULL, the result is 0
getDouble
(int
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
columnIndex
)

Implements java.sql.ResultSet.getDouble.

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

public double

Returns:

the column value; if the value is SQL NULL, the result is 0
getDouble
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getDouble.

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

public float

Returns:

the column value; if the value is SQL NULL, the result is 0
getFloat
(int
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
columnIndex
)

Implements java.sql.ResultSet.getFloat.

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

public float

Returns:

the column value; if the value is SQL NULL, the result is 0
getFloat
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getFloat.

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

public int

Returns:

either ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
getHoldability
()

Implements java.sql.ResultSet.getHoldability.

Retrieves the holdability of this ResultSet object

public int

Returns:

the column value; if the value is SQL NULL, the result is 0
getInt
(int
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
columnIndex
)

Implements java.sql.ResultSet.getInt.

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

public int

Returns:

the column value; if the value is SQL NULL, the result is 0
getInt
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getInt.

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

public int[]

Returns:

an array of column numbers that constitutes a primary key for this rowset. This array should be empty if no column is representitive of a primary key
getKeyColumns
()

Implements javax.sql.rowset.CachedRowSet.getKeyColumns.

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

public long

Returns:

the column value; if the value is SQL NULL, the result is 0
getLong
(int
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
columnIndex
)

Implements java.sql.ResultSet.getLong.

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

public long

Returns:

the column value; if the value is SQL NULL, the result is 0
getLong
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getLong.

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

public int[]

Returns:

a int array object that contains the column ids for the rowset which has this as the match columns.
getMatchColumnIndexes
()

Implements javax.sql.rowset.Joinable.getMatchColumnIndexes.

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

public String[]

Returns:

a String array object that contains the column names for the rowset which has this the match columns
getMatchColumnNames
()

Implements javax.sql.rowset.Joinable.getMatchColumnNames.

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

public ResultSetMetaData

Returns:

the ResultSetMetaData object that describes this CachedRowSetImpl object's columns
getMetaData
()

Implements java.sql.ResultSet.getMetaData.

Retrieves a ResultSetMetaData object instance that contains information about the CachedRowSet object.

public Reader

Returns:

a java.io.Reader object that contains the column value; if the value is SQL NULL, the value returned is null in the Java programming language.
getNCharacterStream
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getNCharacterStream.

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

public Reader

Returns:

a java.io.Reader object that contains the column value; if the value is SQL NULL, the value returned is null in the Java programming language
getNCharacterStream
(String
the name of the column
columnName
)

Implements java.sql.ResultSet.getNCharacterStream.

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

public NClob

Returns:

a NClob object representing the SQL NCLOB value in the specified column
getNClob
(int
the first column is 1, the second is 2, ...
i
)

Implements java.sql.ResultSet.getNClob.

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

public NClob

Returns:

a NClob object representing the SQL NCLOB value in the specified column
getNClob
(String
the name of the column from which to retrieve the value
colName
)

Implements java.sql.ResultSet.getNClob.

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

public String

Returns:

the column value; if the value is SQL NULL, the value returned is null
getNString
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getNString.

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

public String

Returns:

the column value; if the value is SQL NULL, the value returned is null
getNString
(String
the SQL name of the column
columnName
)

Implements java.sql.ResultSet.getNString.

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

public Object

Returns:

a java.lang.Object holding the column value; if the value is SQL NULL, the result is null
getObject
(int
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
columnIndex
)

Implements java.sql.ResultSet.getObject.

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

public Object

Returns:

a java.lang.Object holding the column value; if the value is SQL NULL, the result is null
getObject
(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
)

Implements java.sql.ResultSet.getObject.

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

public Object

Returns:

an Object representing the SQL value
getObject
(int
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
columnIndex
,
Map<String, Class<?>>
a java.util.Map object showing the mapping from SQL type names to classes in the Java programming language
map
)

Implements java.sql.ResultSet.getObject.

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.

public Object

Returns:

an Object representing the SQL value
getObject
(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Map<String, Class<?>>
a java.util.Map object showing the mapping from SQL type names to classes in the Java programming language
map
)

Implements java.sql.ResultSet.getObject.

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.

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

Implements java.sql.ResultSet.getObject.

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.

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

Implements java.sql.ResultSet.getObject.

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.

public ResultSet

Returns:

the original result set of the rowset
getOriginal
()

Implements javax.sql.RowSetInternal.getOriginal, javax.sql.rowset.CachedRowSet.getOriginal.

Returns a result set containing the original value of the rowset.

public ResultSet

Returns:

the original result set of the row
getOriginalRow
()

Implements javax.sql.RowSetInternal.getOriginalRow, javax.sql.rowset.CachedRowSet.getOriginalRow.

Returns a result set containing the original value of the current row only.

public int

Returns:

an integer that is the page size.
getPageSize
()

Implements javax.sql.rowset.CachedRowSet.getPageSize.

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

public Ref

Returns:

a Ref object representing an SQL REF value
getRef
(int
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
columnIndex
)

Implements java.sql.ResultSet.getRef.

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

public Ref

Returns:

a Ref object representing an SQL REF value
getRef
(String
a String object that must match the SQL name of a column in this rowset, ignoring case
colName
)

Implements java.sql.ResultSet.getRef.

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

public int

Returns:

the number of the current row; 0 if there is no current row
getRow
()

Implements java.sql.ResultSet.getRow.

Returns the number of the current row in this CachedRowSetImpl object.

public RowId

Returns:

the column value if the value is a SQL NULL the value returned is null
getRowId
(int
the first column is 1, the second 2, ...
columnIndex
)

Implements java.sql.ResultSet.getRowId.

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.

public RowId

Returns:

the column value if the value is a SQL NULL the value returned is null
getRowId
(String
the name of the column
columnName
)

Implements java.sql.ResultSet.getRowId.

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.

public RowSetWarning

Returns:

the first SQLWarning or null
getRowSetWarnings
()

Implements javax.sql.rowset.CachedRowSet.getRowSetWarnings.

The first warning reported by calls on this CachedRowSetImpl object is returned.

public short

Returns:

the column value; if the value is SQL NULL, the result is 0
getShort
(int
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
columnIndex
)

Implements java.sql.ResultSet.getShort.

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

public short

Returns:

the column value; if the value is SQL NULL, the result is 0
getShort
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getShort.

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

public SQLXML

Returns:

a SQLXML object that maps an SQL XML value
getSQLXML
(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getSQLXML.

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

public SQLXML

Returns:

a SQLXML object that maps an SQL XML value
getSQLXML
(String
the name of the column from which to retrieve the value
colName
)

Implements java.sql.ResultSet.getSQLXML.

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

public Statement

Returns:

null
getStatement
()

Implements java.sql.ResultSet.getStatement.

Returns null.

public String

Returns:

the column value; if the value is SQL NULL, the result is null
getString
(int
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
columnIndex
)

Implements java.sql.ResultSet.getString.

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

public String

Returns:

the column value; if the value is SQL NULL, the result is null
getString
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getString.

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

public SyncProvider

Returns:

the SyncProvider used by the rowset. If not provider was set when the rowset was instantiated, the reference implementation (default) provider is returned.
getSyncProvider
()

Implements javax.sql.rowset.CachedRowSet.getSyncProvider.

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

public String

Returns:

a String object that identifies the table from which this CachedRowSetImpl object was derived
getTableName
()

Implements javax.sql.rowset.CachedRowSet.getTableName.

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

public Time

Returns:

the column value; if the value is SQL NULL, the result is null
getTime
(int
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
columnIndex
)

Implements java.sql.ResultSet.getTime.

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

public Time

Returns:

the column value; if the value is SQL NULL, the result is null
getTime
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getTime.

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

public Time

Returns:

the column value; if the value is SQL NULL, the result is null
getTime
(int
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
columnIndex
,
Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getTime.

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.

public Time

Returns:

the column value; if the value is SQL NULL, the result is null
getTime
(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getTime.

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.

public Timestamp

Returns:

the column value; if the value is SQL NULL, the result is null
getTimestamp
(int
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
columnIndex
)

Implements java.sql.ResultSet.getTimestamp.

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

public Timestamp

Returns:

the column value; if the value is SQL NULL, the result is null
getTimestamp
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getTimestamp.

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

public Timestamp

Returns:

the column value; if the value is SQL NULL, the result is null
getTimestamp
(int
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
columnIndex
,
Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getTimestamp.

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.

public Timestamp

Returns:

the column value; if the value is SQL NULL, the result is null
getTimestamp
(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getTimestamp.

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.

public InputStream

Returns:

a Java input stream that delivers the database column value as a stream of two byte Unicode characters. If the value is SQL NULL then the result is null.
getUnicodeStream
(int
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
columnIndex
)

Implements java.sql.ResultSet.getUnicodeStream.

Deprecated

A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream.

public InputStream

Returns:

a Java input stream that delivers the database column value as a stream of two-byte Unicode characters. If the value is SQL NULL, the result is null.
getUnicodeStream
(String
a String object giving the SQL name of a column in this CachedRowSetImpl object
columnName
)

Implements java.sql.ResultSet.getUnicodeStream.

Deprecated use the method getCharacterStream instead

A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream.

public URL

Returns:

a java.net.URL object containing the resource reference described by the URL
getURL
(int columnIndex)

Implements java.sql.ResultSet.getURL.

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

public URL

Returns:

a java.net.URL object containing the resource reference described by the URL
getURL
(String columnName)

Implements java.sql.ResultSet.getURL.

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

public SQLWarning

Returns:

the first SQLWarning or null
getWarnings
()

Implements java.sql.ResultSet.getWarnings.

The first warning reported by calls on this CachedRowSetImpl object is returned.

private void
initContainer()

Sets the rvh field to a new Vector object with a capacity of 100 and sets the cursorPos and numRows fields to zero.

private void
initMetaData(RowSetMetaDataImpl
the RowSetMetaData object for this CachedRowSetImpl object, which will be set with values from rsmd
md
,
ResultSetMetaData
the ResultSetMetaData object from which new values for md will be read
rsmd
)

Initializes the given RowSetMetaData object with the values in the given ResultSetMetaData object.

private void
initProperties()

Sets the properties for this CachedRowSetImpl object to their default values.

public void
insertRow()

Implements java.sql.ResultSet.insertRow.

Inserts the contents of this CachedRowSetImpl object's insert row into this rowset immediately following the current row.

protected boolean

Returns:

true if the cursor moved to the first row; false otherwise
internalFirst
()

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

protected boolean

Returns:

true if the cursor moved to the last row; false otherwise
internalLast
()

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

protected boolean

Returns:

true if the cursor is on a valid row in this rowset; false if it is after the last row
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

Returns:

true if the cursor is on a row in this rowset; false when the cursor reaches the position before the first row
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.

public boolean

Returns:

true if the cursor is after the last row; false otherwise or if the rowset contains no rows
isAfterLast
()

Implements java.sql.ResultSet.isAfterLast.

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

public boolean

Returns:

true if the cursor is before the first row; false otherwise or if the rowset contains no rows
isBeforeFirst
()

Implements java.sql.ResultSet.isBeforeFirst.

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

private boolean

Returns:

true if the given type is BINARY,' VARBINARY, or LONGVARBINARY; false otherwise
isBinary
(int
one of the constants from java.sql.Types
type
)

Indicates whether the given SQL data type is a binary type.

private boolean

Returns:

true if the given type is BIT, , or BOOLEAN; false otherwise
isBoolean
(int
one of the constants from java.sql.Types
type
)

Indicates whether the given SQL data type is a boolean type.

public boolean

Returns:

true if this ResultSet object is closed; false if it is still open
isClosed
()

Implements java.sql.ResultSet.isClosed.

Retrieves whether this ResultSet object has been closed.

public boolean

Returns:

true if the cursor is on the first row; false otherwise or if the rowset contains no rows
isFirst
()

Implements java.sql.ResultSet.isFirst.

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

public boolean

Returns:

true if the cursor is on the last row; false otherwise or if this rowset contains no rows
isLast
()

Implements java.sql.ResultSet.isLast.

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

private boolean

Returns:

true if the given type is NUMERIC,' DECIMAL, BIT, TINYINT, SMALLINT, INTEGER, BIGINT, REAL, DOUBLE, or FLOAT; false otherwise
isNumeric
(int
one of the constants from java.sql.Types
type
)

Indicates whether the given SQL data type is a numeric type.

private boolean

Returns:

true if the given type is CHAR,' VARCHAR, or LONGVARCHAR; false otherwise
isString
(int
one of the constants from java.sql.Types
type
)

Indicates whether the given SQL data type is a string type.

private boolean

Returns:

true if the given type is DATE, TIME, or TIMESTAMP; false otherwise
isTemporal
(int
one of the constants from java.sql.Types
type
)

Indicates whether the given SQL data type is a temporal type.

public boolean
isWrapperFor(Class<?> interfaces)

Implements java.sql.Wrapper.isWrapperFor.

Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.

public boolean

Returns:

true if the cursor is on a valid row; false otherwise or if there are no rows in this CachedRowSetImpl object
last
()

Implements java.sql.ResultSet.last.

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

private void
makeRowOriginal(Row
the row to be made the original row
row
)

Makes the given row of this rowset the original row by clearing any settings that mark the row as having been inserted, deleted, or updated.

public void
moveToCurrentRow()

Implements java.sql.ResultSet.moveToCurrentRow.

Moves the cursor for this CachedRowSetImpl object to the current row.

public void
moveToInsertRow()

Implements java.sql.ResultSet.moveToInsertRow.

Moves the cursor for this CachedRowSetImpl object to the insert row.

public boolean

Returns:

true if the new current row is valid; false if there are no more rows
next
()

Implements java.sql.ResultSet.next.

Moves the cursor down one row from its current position and returns true if the new cursor position is a valid row.

public boolean

Returns:

boolean value true indicating whether there are more pages to come and false indicating that this is the last page.
nextPage
()

Implements javax.sql.rowset.CachedRowSet.nextPage.

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

public void
populate(ResultSet
the ResultSet object containing the data to be read into this CachedRowSetImpl object
data
)

Implements javax.sql.rowset.CachedRowSet.populate.

Populates this CachedRowSetImpl object with data from the given ResultSet object.

public void
populate(ResultSet
the ResultSet object containing the data to be read into this CachedRowSetImpl object
data
,
int
the integer specifying the position in the ResultSet object to popultate the CachedRowSetImpl object.
start
)

Implements javax.sql.rowset.CachedRowSet.populate.

Populates this CachedRowSet object with data from the given ResultSet object.

public boolean

Returns:

true if the cursor is on a valid row; false if it is before the first row or after the last row
previous
()

Implements java.sql.ResultSet.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.

public boolean

Returns:

boolean value true if it retrieves the previous page, flase if it is on the first page.
previousPage
()

Implements javax.sql.rowset.CachedRowSet.previousPage.

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

private void
readObject(ObjectInputStream ois)

This method re populates the resBundle during the deserialization process

public void
refreshRow()

Implements java.sql.ResultSet.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.

public boolean

Returns:

true if the cursor is on a row in this CachedRowSetImpl object; false otherwise
relative
(int
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
rows
)

Implements java.sql.ResultSet.relative.

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.

public void
release()

Implements javax.sql.rowset.CachedRowSet.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.

public void
restoreOriginal()

Implements javax.sql.rowset.CachedRowSet.restoreOriginal.

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

public void
rollback()

Implements javax.sql.rowset.CachedRowSet.rollback.

Rolls back all changes performed by the acceptChanges() methods

public void
rollback(Savepoint s)

Implements javax.sql.rowset.CachedRowSet.rollback.

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

public boolean

Returns:

true if (1)the current row is blank, indicating that the row has been deleted, and (2)deletions are detected; false otherwise
rowDeleted
()

Implements java.sql.ResultSet.rowDeleted.

Indicates whether the current row has been deleted.

public boolean

Returns:

true if a row has been inserted and inserts are detected; false otherwise
rowInserted
()

Implements java.sql.ResultSet.rowInserted.

Indicates whether the current row has been inserted.

public void
rowSetPopulated(RowSetEvent
a RowSetEvent object that contains the RowSet object that is the source of the events
event
,
int
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
numRows
)

Implements javax.sql.rowset.CachedRowSet.rowSetPopulated.

Notifies registered listeners that a RowSet object in the given RowSetEvent object has populated a number of additional rows.

public boolean

Returns:

true if the row has been visibly updated by the owner or another and updates are detected; false otherwise
rowUpdated
()

Implements java.sql.ResultSet.rowUpdated.

Indicates whether the current row of this CachedRowSetImpl object has been updated.

public void
setAsciiStream(String
the name of the parameter
parameterName
,
InputStream
the Java input stream that contains the ASCII parameter value
x
,
int
the number of bytes in the stream
length
)

Overrides javax.sql.rowset.BaseRowSet.setAsciiStream.

Implements javax.sql.RowSet.setAsciiStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public void
setAsciiStream(String
the name of the parameter
parameterName
,
InputStream
the Java input stream that contains the ASCII parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setAsciiStream.

Implements javax.sql.RowSet.setAsciiStream.

Sets the designated parameter to the given input stream.

public void
setBigDecimal(String
the name of the parameter
parameterName
,
BigDecimal
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setBigDecimal.

Implements javax.sql.RowSet.setBigDecimal.

Sets the designated parameter to the given java.math.BigDecimal value.

public void
setBinaryStream(String
the name of the parameter
parameterName
,
InputStream
the java input stream which contains the binary parameter value
x
,
int
the number of bytes in the stream
length
)

Overrides javax.sql.rowset.BaseRowSet.setBinaryStream.

Implements javax.sql.RowSet.setBinaryStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public void
setBinaryStream(String
the name of the parameter
parameterName
,
InputStream
the java input stream which contains the binary parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setBinaryStream.

Implements javax.sql.RowSet.setBinaryStream.

Sets the designated parameter to the given input stream.

public void
setBlob(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
,
long
the number of bytes in the parameter data.
length
)

Overrides javax.sql.rowset.BaseRowSet.setBlob.

Implements javax.sql.RowSet.setBlob.

Sets the designated parameter to a InputStream object.

public void
setBlob(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
)

Overrides javax.sql.rowset.BaseRowSet.setBlob.

Implements javax.sql.RowSet.setBlob.

Sets the designated parameter to a InputStream object.

public void
setBlob(String
the name of the parameter to be set the second is 2, ...
parameterName
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
,
long
the number of bytes in the parameter data.
length
)

Overrides javax.sql.rowset.BaseRowSet.setBlob.

Implements javax.sql.RowSet.setBlob.

Sets the designated parameter to a InputStream object.

public void
setBlob(String
the name of the parameter
parameterName
,
Blob
a Blob object that maps an SQL BLOB value
x
)

Overrides javax.sql.rowset.BaseRowSet.setBlob.

Implements javax.sql.RowSet.setBlob.

Sets the designated parameter to the given java.sql.Blob object.

public void
setBlob(String
the name of the parameter
parameterName
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
)

Overrides javax.sql.rowset.BaseRowSet.setBlob.

Implements javax.sql.RowSet.setBlob.

Sets the designated parameter to a InputStream object.

public void
setBoolean(String
the name of the parameter
parameterName
,
boolean
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setBoolean.

Implements javax.sql.RowSet.setBoolean.

Sets the designated parameter to the given Java boolean value.

public void
setByte(String
the name of the parameter
parameterName
,
byte
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setByte.

Implements javax.sql.RowSet.setByte.

Sets the designated parameter to the given Java byte value.

public void
setBytes(String
the name of the parameter
parameterName
,
byte[]
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setBytes.

Implements javax.sql.RowSet.setBytes.

Sets the designated parameter to the given Java array of bytes.

public void
setCharacterStream(String
the name of the parameter
parameterName
,
Reader
the java.io.Reader object that contains the UNICODE data used as the designated parameter
reader
,
int
the number of characters in the stream
length
)

Overrides javax.sql.rowset.BaseRowSet.setCharacterStream.

Implements javax.sql.RowSet.setCharacterStream.

Sets the designated parameter to the given Reader object, which is the given number of characters long.

public void
setCharacterStream(String
the name of the parameter
parameterName
,
Reader
the java.io.Reader object that contains the Unicode data
reader
)

Overrides javax.sql.rowset.BaseRowSet.setCharacterStream.

Implements javax.sql.RowSet.setCharacterStream.

Sets the designated parameter to the given Reader object.

public void
setClob(String
the name of the parameter to be set
parameterName
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Overrides javax.sql.rowset.BaseRowSet.setClob.

Implements javax.sql.RowSet.setClob.

Sets the designated parameter to a Reader object.

public void
setClob(String
the name of the parameter
parameterName
,
Clob
a Clob object that maps an SQL CLOB value
x
)

Overrides javax.sql.rowset.BaseRowSet.setClob.

Implements javax.sql.RowSet.setClob.

Sets the designated parameter to the given java.sql.Clob object.

public void
setClob(String
the name of the parameter
parameterName
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Overrides javax.sql.rowset.BaseRowSet.setClob.

Implements javax.sql.RowSet.setClob.

Sets the designated parameter to a Reader object.

public void
setClob(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Overrides javax.sql.rowset.BaseRowSet.setClob.

Implements javax.sql.RowSet.setClob.

Sets the designated parameter to a Reader object.

public void
setClob(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Overrides javax.sql.rowset.BaseRowSet.setClob.

Implements javax.sql.RowSet.setClob.

Sets the designated parameter to a Reader object.

public void
setCommand(String
a String object containing an SQL query that will be set as the command; may be null
cmd
)

Overrides javax.sql.rowset.BaseRowSet.setCommand.

Implements javax.sql.RowSet.setCommand.

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.

private void
setConnection(Connection
the Connection object that was passed in to the method execute and is to be stored in this CachedRowSetImpl object's connection property
connection
)

Sets this CachedRowSetImpl object's connection property to the given Connection object.

public void
setDate(String
the name of the parameter
parameterName
,
Date
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setDate.

Implements javax.sql.RowSet.setDate.

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.

public void
setDate(String
the name of the parameter
parameterName
,
Date
the parameter value
x
,
Calendar
the Calendar object the driver will use to construct the date
cal
)

Overrides javax.sql.rowset.BaseRowSet.setDate.

Implements javax.sql.RowSet.setDate.

Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.

public void
setDouble(String
the name of the parameter
parameterName
,
double
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setDouble.

Implements javax.sql.RowSet.setDouble.

Sets the designated parameter to the given Java double value.

public void
setFloat(String
the name of the parameter
parameterName
,
float
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setFloat.

Implements javax.sql.RowSet.setFloat.

Sets the designated parameter to the given Java float value.

public void
setInt(String
the name of the parameter
parameterName
,
int
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setInt.

Implements javax.sql.RowSet.setInt.

Sets the designated parameter to the given Java int value.

public void
setKeyColumns(int[]
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
keys
)

Implements javax.sql.rowset.CachedRowSet.setKeyColumns.

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.

private void
setLastValueNull(boolean
true to indicate that the value of the last column read was SQL NULL; false to indicate that it was not
value
)

Sets the field lastValueNull to the given boolean value.

public void
setLong(String
the name of the parameter
parameterName
,
long
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setLong.

Implements javax.sql.RowSet.setLong.

Sets the designated parameter to the given Java long value.

public void
setMatchColumn(int[]
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
columnIdxes
)

Implements javax.sql.rowset.Joinable.setMatchColumn.

Sets the designated parameter to the given int array.

public void
setMatchColumn(String[]
the name of the column into this rowset object's internal representation of parameter values
columnNames
)

Implements javax.sql.rowset.Joinable.setMatchColumn.

Sets the designated parameter to the given String array.

public void
setMatchColumn(int
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
columnIdx
)

Implements javax.sql.rowset.Joinable.setMatchColumn.

Sets the designated parameter to the given int object.

public void
setMatchColumn(String
the name of the column into this rowset object's internal representation of parameter values
columnName
)

Implements javax.sql.rowset.Joinable.setMatchColumn.

Sets the designated parameter to the given String object.

public void
setMetaData(RowSetMetaData
a RowSetMetaData object instance containing metadata about the columns in the rowset
md
)

Implements javax.sql.RowSetInternal.setMetaData, javax.sql.rowset.CachedRowSet.setMetaData.

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

public void
setNCharacterStream(int
of the first parameter is 1, the second is 2, ...
parameterIndex
,
Reader
the parameter value
value
)

Overrides javax.sql.rowset.BaseRowSet.setNCharacterStream.

Implements javax.sql.RowSet.setNCharacterStream.

Sets the designated parameter to a Reader object.

public void
setNCharacterStream(int
of the first parameter is 1, the second is 2, ...
parameterIndex
,
Reader
the parameter value
value
,
long
the number of characters in the parameter data.
length
)

Overrides javax.sql.rowset.BaseRowSet.setNCharacterStream.

Implements javax.sql.RowSet.setNCharacterStream.

Sets the designated parameter to a Reader object.

public void
setNCharacterStream(String
the name of the column to be set
parameterName
,
Reader
the parameter value
value
,
long
the number of characters in the parameter data.
length
)

Overrides javax.sql.rowset.BaseRowSet.setNCharacterStream.

Implements javax.sql.RowSet.setNCharacterStream.

Sets the designated parameter to a Reader object.

public void
setNCharacterStream(String
the name of the parameter
parameterName
,
Reader
the parameter value
value
)

Overrides javax.sql.rowset.BaseRowSet.setNCharacterStream.

Implements javax.sql.RowSet.setNCharacterStream.

Sets the designated parameter to a Reader object.

public void
setNClob(String
the name of the column to be set
parameterName
,
NClob
the parameter value
value
)

Overrides javax.sql.rowset.BaseRowSet.setNClob.

Implements javax.sql.RowSet.setNClob.

Sets the designated parameter to a java.sql.NClob object.

public void
setNClob(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Overrides javax.sql.rowset.BaseRowSet.setNClob.

Implements javax.sql.RowSet.setNClob.

Sets the designated parameter to a Reader object.

public void
setNClob(String
the name of the parameter to be set
parameterName
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Overrides javax.sql.rowset.BaseRowSet.setNClob.

Implements javax.sql.RowSet.setNClob.

Sets the designated parameter to a Reader object.

public void
setNClob(String
the name of the parameter
parameterName
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Overrides javax.sql.rowset.BaseRowSet.setNClob.

Implements javax.sql.RowSet.setNClob.

Sets the designated parameter to a Reader object.

public void
setNClob(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Overrides javax.sql.rowset.BaseRowSet.setNClob.

Implements javax.sql.RowSet.setNClob.

Sets the designated parameter to a Reader object.

public void
setNClob(int
of the first parameter is 1, the second is 2, ...
parameterIndex
,
NClob
the parameter value
value
)

Overrides javax.sql.rowset.BaseRowSet.setNClob.

Implements javax.sql.RowSet.setNClob.

Sets the designated parameter to a java.sql.NClob object.

public void
setNString(int
of the first parameter is 1, the second is 2, ...
parameterIndex
,
String
the parameter value
value
)

Overrides javax.sql.rowset.BaseRowSet.setNString.

Implements javax.sql.RowSet.setNString.

Sets the designated parameter to the given String object.

public void
setNString(String
the name of the column to be set
parameterName
,
String
the parameter value
value
)

Overrides javax.sql.rowset.BaseRowSet.setNString.

Implements javax.sql.RowSet.setNString.

Sets the designated parameter to the given String object.

public void
setNull(String
the name of the parameter
parameterName
,
int
the SQL type code defined in java.sql.Types
sqlType
)

Overrides javax.sql.rowset.BaseRowSet.setNull.

Implements javax.sql.RowSet.setNull.

Sets the designated parameter to SQL NULL.

public void
setNull(String
the name of the parameter
parameterName
,
int
a value from java.sql.Types
sqlType
,
String
the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQL REF value
typeName
)

Overrides javax.sql.rowset.BaseRowSet.setNull.

Implements javax.sql.RowSet.setNull.

Sets the designated parameter to SQL NULL.

public void
setObject(String
the name of the parameter
parameterName
,
Object
the object containing the input parameter value
x
,
int
the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.
targetSqlType
,
int
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.
scale
)

Overrides javax.sql.rowset.BaseRowSet.setObject.

Implements javax.sql.RowSet.setObject.

Sets the value of the designated parameter with the given object.

public void
setObject(String
the name of the parameter
parameterName
,
Object
the object containing the input parameter value
x
,
int
the SQL type (as defined in java.sql.Types) to be sent to the database
targetSqlType
)

Overrides javax.sql.rowset.BaseRowSet.setObject.

Implements javax.sql.RowSet.setObject.

Sets the value of the designated parameter with the given object.

public void
setObject(String
the name of the parameter
parameterName
,
Object
the object containing the input parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setObject.

Implements javax.sql.RowSet.setObject.

Sets the value of the designated parameter with the given object.

public void
setOriginal()

Marks all rows in this rowset as being original rows.

public void
setOriginalRow()

Implements javax.sql.rowset.CachedRowSet.setOriginalRow.

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

public void
setPageSize(int
which is the page size
size
)

Implements javax.sql.rowset.CachedRowSet.setPageSize.

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

public void
setRowId(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
RowId
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setRowId.

Implements javax.sql.RowSet.setRowId.

Sets the designated parameter to the given java.sql.RowId object.

public void
setRowId(String
the name of the parameter
parameterName
,
RowId
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setRowId.

Implements javax.sql.RowSet.setRowId.

Sets the designated parameter to the given java.sql.RowId object.

public void
setRowInserted(boolean
if it is true - marks this row as inserted if it is false - marks it as not a newly inserted row
insertFlag
)

Sets the status for the row on which the cursor is positioned.

public void
setShort(String
the name of the parameter
parameterName
,
short
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setShort.

Implements javax.sql.RowSet.setShort.

Sets the designated parameter to the given Java short value.

public void
setSQLXML(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
SQLXML
a SQLXML object that maps an SQL XML value
xmlObject
)

Overrides javax.sql.rowset.BaseRowSet.setSQLXML.

Implements javax.sql.RowSet.setSQLXML.

Sets the designated parameter to the given java.sql.SQLXML object.

public void
setSQLXML(String
the name of the parameter
parameterName
,
SQLXML
a SQLXML object that maps an SQL XML value
xmlObject
)

Overrides javax.sql.rowset.BaseRowSet.setSQLXML.

Implements javax.sql.RowSet.setSQLXML.

Sets the designated parameter to the given java.sql.SQLXML object.

public void
setString(String
the name of the parameter
parameterName
,
String
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setString.

Implements javax.sql.RowSet.setString.

Sets the designated parameter to the given Java String value.

public void
setSyncProvider(String providerStr)

Implements javax.sql.rowset.CachedRowSet.setSyncProvider.

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

public void
setTableName(String
a String object that identifies the table from which this CachedRowSetImpl object was derived
tabName
)

Implements javax.sql.rowset.CachedRowSet.setTableName.

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

public void
setTime(String
the name of the parameter
parameterName
,
Time
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setTime.

Implements javax.sql.RowSet.setTime.

Sets the designated parameter to the given java.sql.Time value.

public void
setTime(String
the name of the parameter
parameterName
,
Time
the parameter value
x
,
Calendar
the Calendar object the driver will use to construct the time
cal
)

Overrides javax.sql.rowset.BaseRowSet.setTime.

Implements javax.sql.RowSet.setTime.

Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.

public void
setTimestamp(String
the name of the parameter
parameterName
,
Timestamp
the parameter value
x
,
Calendar
the Calendar object the driver will use to construct the timestamp
cal
)

Overrides javax.sql.rowset.BaseRowSet.setTimestamp.

Implements javax.sql.RowSet.setTimestamp.

Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.

public void
setTimestamp(String
the name of the parameter
parameterName
,
Timestamp
the parameter value
x
)

Overrides javax.sql.rowset.BaseRowSet.setTimestamp.

Implements javax.sql.RowSet.setTimestamp.

Sets the designated parameter to the given java.sql.Timestamp value.

public void
setURL(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
URL
the java.net.URL object to be set
x
)

Overrides javax.sql.rowset.BaseRowSet.setURL.

Implements javax.sql.RowSet.setURL.

Sets the designated parameter to the given java.net.URL value.

public int

Returns:

number of rows in the rowset
size
()

Implements javax.sql.rowset.CachedRowSet.size.

Returns the number of rows in this CachedRowSetImpl object.

public Collection<?>

Returns:

a Collection object consisting of tables, each of which is a copy of a row in this CachedRowSetImpl object
toCollection
()

Implements javax.sql.rowset.CachedRowSet.toCollection.

Converts this CachedRowSetImpl object to a collection of tables.

public Collection<?>

Returns:

a Collection object that contains the value(s) stored in the specified column of this CachedRowSetImpl object
toCollection
(int column)

Implements javax.sql.rowset.CachedRowSet.toCollection.

Returns the specified column of this CachedRowSetImpl object as a Collection object.

public Collection<?>

Returns:

a Collection object that contains the value(s) stored in the specified column of this CachedRowSetImpl object
toCollection
(String column)

Implements javax.sql.rowset.CachedRowSet.toCollection.

Returns the specified column of this CachedRowSetImpl object as a Collection object.

public void
undoDelete()

Implements javax.sql.rowset.CachedRowSet.undoDelete.

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

public void
undoInsert()

Implements javax.sql.rowset.CachedRowSet.undoInsert.

Immediately removes the current row from this CachedRowSetImpl object if the row has been inserted, and also notifies listeners the row has changed.

public void
undoUpdate()

Implements javax.sql.rowset.CachedRowSet.undoUpdate.

Immediately reverses the last update operation if the row has been modified.

public void
unsetMatchColumn(int[]
the index into this rowset object's internal representation of parameter values
columnIdxes
)

Implements javax.sql.rowset.Joinable.unsetMatchColumn.

Unsets the designated parameter to the given int array.

public void
unsetMatchColumn(String[]
the index into this rowset object's internal representation of parameter values
columnIdxes
)

Implements javax.sql.rowset.Joinable.unsetMatchColumn.

Unsets the designated parameter to the given String array.

public void
unsetMatchColumn(int
the index into this rowset object's internal representation of parameter values
columnIdx
)

Implements javax.sql.rowset.Joinable.unsetMatchColumn.

Unsets the designated parameter to the given int object.

public void
unsetMatchColumn(String
the index into this rowset object's internal representation of parameter values
columnName
)

Implements javax.sql.rowset.Joinable.unsetMatchColumn.

Unsets the designated parameter to the given String object.

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

Implements java.sql.Wrapper.unwrap.

Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

public void
updateArray(int
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
columnIndex
,
Array
the new column Array value
a
)

Implements java.sql.ResultSet.updateArray.

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given java.sql.Array values.

public void
updateArray(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Array
the new column Array value
a
)

Implements java.sql.ResultSet.updateArray.

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

public void
updateAsciiStream(int
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
columnIndex
,
InputStream
the new column value
x
,
int
the number of one-byte ASCII characters in the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

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

public void
updateAsciiStream(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
InputStream
the new column value
x
,
int
the number of one-byte ASCII characters in the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

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

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with an ascii stream value, which will have the specified number of bytes.

public void
updateAsciiStream(String
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
columnLabel
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with an ascii stream value, which will have the specified number of bytes..

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with an ascii stream value.

public void
updateAsciiStream(String
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
columnLabel
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateAsciiStream.

Updates the designated column with an ascii stream value.

public void
updateBigDecimal(int
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
columnIndex
,
BigDecimal
the new column value
x
)

Implements java.sql.ResultSet.updateBigDecimal.

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

public void
updateBigDecimal(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
BigDecimal
the new column value
x
)

Implements java.sql.ResultSet.updateBigDecimal.

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

public void
updateBinaryStream(int
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
columnIndex
,
InputStream
the new column value; must be a java.io.InputStream containing BINARY, VARBINARY, or LONGVARBINARY data
x
,
int
the length of the stream in bytes
length
)

Implements java.sql.ResultSet.updateBinaryStream.

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

public void
updateBinaryStream(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
InputStream
the new column value; must be a java.io.InputStream containing BINARY, VARBINARY, or LONGVARBINARY data
x
,
int
the length of the stream in bytes
length
)

Implements java.sql.ResultSet.updateBinaryStream.

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

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value, which will have the specified number of bytes.

public void
updateBinaryStream(String
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
columnLabel
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value, which will have the specified number of bytes.

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value.

public void
updateBinaryStream(String
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
columnLabel
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateBinaryStream.

Updates the designated column with a binary stream value.

public void
updateBlob(int
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
columnIndex
,
Blob
the new column Blob value
b
)

Implements java.sql.ResultSet.updateBlob.

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

public void
updateBlob(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Blob
the new column Blob value
b
)

Implements java.sql.ResultSet.updateBlob.

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

public void
updateBlob(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
,
long
the number of bytes in the parameter data.
length
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream, which will have the specified number of bytes.

public void
updateBlob(String
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
columnLabel
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
,
long
the number of bytes in the parameter data.
length
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream, which will have the specified number of bytes.

public void
updateBlob(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream.

public void
updateBlob(String
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
columnLabel
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
)

Implements java.sql.ResultSet.updateBlob.

Updates the designated column using the given input stream.

public void
updateBoolean(int
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
columnIndex
,
boolean
the new column value
x
)

Implements java.sql.ResultSet.updateBoolean.

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

public void
updateBoolean(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
boolean
the new column value
x
)

Implements java.sql.ResultSet.updateBoolean.

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

public void
updateByte(int
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
columnIndex
,
byte
the new column value
x
)

Implements java.sql.ResultSet.updateByte.

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

public void
updateByte(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
byte
the new column value
x
)

Implements java.sql.ResultSet.updateByte.

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

public void
updateBytes(int
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
columnIndex
,
byte[]
the new column value
x
)

Implements java.sql.ResultSet.updateBytes.

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

public void
updateBytes(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
byte[]
the new column value
x
)

Implements java.sql.ResultSet.updateBytes.

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

public void
updateCharacterStream(int
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
columnIndex
,
Reader
the new column value; must be a java.io.Reader containing BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, or LONGVARCHAR data
x
,
int
the length of the stream in characters
length
)

Implements java.sql.ResultSet.updateCharacterStream.

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

public void
updateCharacterStream(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Reader
the new column value; must be a java.io.Reader containing BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, or LONGVARCHAR data
reader
,
int
the length of the stream in characters
length
)

Implements java.sql.ResultSet.updateCharacterStream.

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

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateCharacterStream(String
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
columnLabel
,
Reader
the java.io.Reader object containing the new column value
reader
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value.

public void
updateCharacterStream(String
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
columnLabel
,
Reader
the java.io.Reader object containing the new column value
reader
)

Implements java.sql.ResultSet.updateCharacterStream.

Updates the designated column with a character stream value.

public void
updateClob(int
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
columnIndex
,
Clob
the new column Clob value
c
)

Implements java.sql.ResultSet.updateClob.

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

public void
updateClob(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Clob
the new column Clob value
c
)

Implements java.sql.ResultSet.updateClob.

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

public void
updateClob(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateClob(String
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
columnLabel
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateClob(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object.

public void
updateClob(String
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
columnLabel
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.ResultSet.updateClob.

Updates the designated column using the given Reader object.

public void
updateDate(int
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
columnIndex
,
Date
the new column value
x
)

Implements java.sql.ResultSet.updateDate.

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

public void
updateDate(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Date
the new column value
x
)

Implements java.sql.ResultSet.updateDate.

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

public void
updateDouble(int
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
columnIndex
,
double
the new column value
x
)

Implements java.sql.ResultSet.updateDouble.

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

public void
updateDouble(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
double
the new column value
x
)

Implements java.sql.ResultSet.updateDouble.

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

public void
updateFloat(int
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
columnIndex
,
float
the new column value
x
)

Implements java.sql.ResultSet.updateFloat.

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

public void
updateFloat(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
float
the new column value
x
)

Implements java.sql.ResultSet.updateFloat.

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

public void
updateInt(int
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
columnIndex
,
int
the new column value
x
)

Implements java.sql.ResultSet.updateInt.

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

public void
updateInt(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
int
the new column value
x
)

Implements java.sql.ResultSet.updateInt.

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

public void
updateLong(int
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
columnIndex
,
long
the new column value
x
)

Implements java.sql.ResultSet.updateLong.

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

public void
updateLong(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
long
the new column value
x
)

Implements java.sql.ResultSet.updateLong.

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

public void
updateNCharacterStream(int
- the first column is 1, the second is 2, ...
columnIndex
,
Reader
- the new column value
x
,
long
- the length of the stream
length
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateNCharacterStream(String
- name of the Column
columnName
,
Reader
- the new column value
x
,
long
- the length of the stream
length
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value, which will have the specified number of bytes.

public void
updateNCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value.

public void
updateNCharacterStream(String
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
columnLabel
,
Reader
the java.io.Reader object containing the new column value
reader
)

Implements java.sql.ResultSet.updateNCharacterStream.

Updates the designated column with a character stream value.

public void
updateNClob(int columnIndex, NClob nClob)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column with a java.sql.NClob value.

public void
updateNClob(String
name of the column
columnName
,
NClob
the value for the column to be updated
nClob
)

Implements java.sql.ResultSet.updateNClob.

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

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateNClob(String
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
columnLabel
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader object, which is the given number of characters long.

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader object.

public void
updateNClob(String
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
columnLabel
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.ResultSet.updateNClob.

Updates the designated column using the given Reader object.

public void
updateNString(int
the first column is 1, the second 2, ...
columnIndex
,
String
the value for the column to be updated
nString
)

Implements java.sql.ResultSet.updateNString.

This method is used for updating columns that support National Character sets.

public void
updateNString(String
name of the Column
columnName
,
String
the value for the column to be updated
nString
)

Implements java.sql.ResultSet.updateNString.

This method is used for updating columns that support National Character sets.

public void
updateNull(int
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
columnIndex
)

Implements java.sql.ResultSet.updateNull.

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

public void
updateNull(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
)

Implements java.sql.ResultSet.updateNull.

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

public void
updateObject(int
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
columnIndex
,
Object
the new column value
x
,
int
the number of digits to the right of the decimal point (for DECIMAL and NUMERIC types only)
scale
)

Implements java.sql.ResultSet.updateObject.

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

public void
updateObject(int
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
columnIndex
,
Object
the new column value
x
)

Implements java.sql.ResultSet.updateObject.

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

public void
updateObject(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Object
the new column value
x
,
int
the number of digits to the right of the decimal point (for DECIMAL and NUMERIC types only)
scale
)

Implements java.sql.ResultSet.updateObject.

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

public void
updateObject(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Object
the new column value
x
)

Implements java.sql.ResultSet.updateObject.

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

public void
updateRef(int
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
columnIndex
,
Ref
the new column java.sql.Ref value
ref
)

Implements java.sql.ResultSet.updateRef.

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

public void
updateRef(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Ref
the new column java.sql.Ref value
ref
)

Implements java.sql.ResultSet.updateRef.

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

public void
updateRow()

Implements java.sql.ResultSet.updateRow.

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

public void
updateRowId(int
the first column is 1, the second 2, ...
columnIndex
,
RowId
the column value
x
)

Implements java.sql.ResultSet.updateRowId.

Updates the designated column with a RowId value.

public void
updateRowId(String
the name of the column
columnName
,
RowId
the column value
x
)

Implements java.sql.ResultSet.updateRowId.

Updates the designated column with a RowId value.

public void
updateShort(int
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
columnIndex
,
short
the new column value
x
)

Implements java.sql.ResultSet.updateShort.

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

public void
updateShort(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
short
the new column value
x
)

Implements java.sql.ResultSet.updateShort.

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

public void
updateSQLXML(int
the first column is 1, the second 2, ...
columnIndex
,
SQLXML
the value for the column to be updated
xmlObject
)

Implements java.sql.ResultSet.updateSQLXML.

Updates the designated column with a java.sql.SQLXML value.

public void
updateSQLXML(String
the name of the column
columnName
,
SQLXML
the column value
xmlObject
)

Implements java.sql.ResultSet.updateSQLXML.

Updates the designated column with a java.sql.SQLXML value.

public void
updateString(int
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
columnIndex
,
String
the new column value
x
)

Implements java.sql.ResultSet.updateString.

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

public void
updateString(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
String
the new column value
x
)

Implements java.sql.ResultSet.updateString.

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

public void
updateTime(int
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
columnIndex
,
Time
the new column value
x
)

Implements java.sql.ResultSet.updateTime.

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

public void
updateTime(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Time
the new column value
x
)

Implements java.sql.ResultSet.updateTime.

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

public void
updateTimestamp(int
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
columnIndex
,
Timestamp
the new column value
x
)

Implements java.sql.ResultSet.updateTimestamp.

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

public void
updateTimestamp(String
a String object that must match the SQL name of a column in this rowset, ignoring case
columnName
,
Timestamp
the new column value
x
)

Implements java.sql.ResultSet.updateTimestamp.

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

public boolean

Returns:

true if the value in the last column read was SQL NULL; false otherwise
wasNull
()

Implements java.sql.ResultSet.wasNull.

Reports whether the last column read was SQL NULL.

Inherited from javax.sql.rowset.BaseRowSet:
addRowSetListenerclearParametersgetCommandgetConcurrencygetDataSourceNamegetEscapeProcessinggetFetchDirectiongetFetchSizegetMaxFieldSizegetMaxRowsgetParamsgetPasswordgetQueryTimeoutgetShowDeletedgetTransactionIsolationgetTypegetTypeMapgetUrlgetUsernameinitParamsisReadOnlynotifyCursorMovednotifyRowChangednotifyRowSetChangedremoveRowSetListenersetArraysetAsciiStreamsetAsciiStreamsetBigDecimalsetBinaryStreamsetBinaryStreamsetBlobsetBooleansetBytesetBytessetCharacterStreamsetCharacterStreamsetClobsetConcurrencysetDataSourceNamesetDatesetDatesetDoublesetEscapeProcessingsetFetchDirectionsetFetchSizesetFloatsetIntsetLongsetMaxFieldSizesetMaxRowssetNullsetNullsetObjectsetObjectsetObjectsetPasswordsetQueryTimeoutsetReadOnlysetRefsetShortsetShowDeletedsetStringsetTimesetTimesetTimestampsetTimestampsetTransactionIsolationsetTypesetTypeMapsetUnicodeStreamsetUrlsetUsername