|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object javax.sql.rowset.BaseRowSet com.sun.rowset.CachedRowSetImpl com.sun.rowset.WebRowSetImpl com.sun.rowset.JoinRowSetImpl
The standard implementation of the JoinRowSet
interface providing an SQL JOIN
between RowSet
objects.
The implementation provides an ANSI-style JOIN
providing an
inner join between two tables. Any unmatched rows in either table of the
join are discarded.
Typically, a JoinRowSet
implementation is leveraged by
RowSet
instances that are in a disconnected environment and
thus do not have the luxury of an open connection to the data source to
establish logical relationships between themselves. In other words, it is
largely CachedRowSet
objects and implementations derived from
the CachedRowSet
interface that will use the JoinRowSetImpl
implementation.
Field Summary |
Fields inherited from class javax.sql.rowset.BaseRowSet |
ASCII_STREAM_PARAM, asciiStream, BINARY_STREAM_PARAM, binaryStream, charStream, UNICODE_STREAM_PARAM, unicodeStream |
Fields inherited from interface javax.sql.rowset.JoinRowSet |
CROSS_JOIN, FULL_JOIN, INNER_JOIN, LEFT_OUTER_JOIN, RIGHT_OUTER_JOIN |
Fields inherited from interface javax.sql.rowset.WebRowSet |
PUBLIC_XML_SCHEMA, SCHEMA_SYSTEM_ID |
Fields inherited from interface javax.sql.rowset.CachedRowSet |
COMMIT_ON_ACCEPT_CHANGES |
Fields inherited from interface java.sql.ResultSet |
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
Constructor Summary | |
JoinRowSetImpl()
Constructor for JoinRowSetImpl class. |
Method Summary | |
boolean |
absolute(int row)
Moves this JoinRowSetImpl object's cursor to the row number
specified. |
void |
addRowSet(Joinable rowset)
Adds the given RowSet object to this
JoinRowSet object. |
void |
addRowSet(javax.sql.RowSet[] rowset,
int[] columnIdx)
Adds the given RowSet objects to the JOIN relationship
and sets the designated columns as the match columns. |
void |
addRowSet(javax.sql.RowSet[] rowset,
java.lang.String[] columnName)
Adds the given RowSet objects to the JOIN relationship
and sets the designated columns as the match columns. |
void |
addRowSet(javax.sql.RowSet rowset,
int columnIdx)
Adds the given RowSet object to the JOIN relation
and sets the designated column as the match column. |
void |
addRowSet(javax.sql.RowSet rowset,
java.lang.String columnName)
Adds the given RowSet object to the JOIN relationship
and sets the designated column as the match column. |
void |
afterLast()
Moves this JoinRowSetImpl object's cursor to the end of
the rowset, just after the last row. |
void |
beforeFirst()
Moves this JoinRowSetImpl object's cursor to the front of
the rowset, just before the first row. |
void |
cancelRowUpdates()
Rolls back any updates made to the current row of this JoinRowSetImpl object and notifies listeners that
a row has changed. |
void |
clearWarnings()
Throws an UnsupportedOperationException if called. |
void |
close()
Releases the current contents of this rowset, discarding outstanding updates. |
boolean |
columnUpdated(int indexColumn)
Indicates whether the designated column of the current row of this JoinRowSetImpl object has been updated. |
void |
deleteRow()
Deletes the current row from this JoinRowSetImpl object and
notifies listeners registered with this rowset that a row has changed. |
void |
execute()
Populates this JoinRowSetImpl object with data. |
void |
execute(java.sql.Connection conn)
Populates this JoinRowSetImpl object with data,
using the given connection to produce the result set from
which data will be read. |
int |
findColumn(java.lang.String columnName)
Returns the index of the column whose name is columnName. |
boolean |
first()
Moves this JoinRowSetImpl object's cursor to the first row
and returns true if the operation was successful. |
java.sql.Array |
getArray(int columnIndex)
Retrieves the value of the designated column in this JoinRowSetImpl object as an Array object
in the Java programming lanugage. |
java.sql.Array |
getArray(java.lang.String columnName)
Retrieves the value of the designated column in this JoinRowSetImpl object as an Array object
in the Java programming lanugage. |
java.io.InputStream |
getAsciiStream(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
java.sql.Timestamp object. |
java.io.InputStream |
getAsciiStream(java.lang.String columnName)
This method is not supported, and it will throw an UnsupportedOperationException if it is called. |
java.math.BigDecimal |
getBigDecimal(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
java.math.BigDecimal object. |
java.math.BigDecimal |
getBigDecimal(int columnIndex,
int scale)
Deprecated. |
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
java.math.BigDecimal object. |
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName,
int scale)
Deprecated. use the method getBigDecimal(String columnName)
instead |
java.io.InputStream |
getBinaryStream(int columnIndex)
A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream. |
java.io.InputStream |
getBinaryStream(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a java.io.InputStream object. |
java.sql.Blob |
getBlob(int columnIndex)
Retrieves the value of the designated column in this JoinRowSetImpl object as a Blob object
in the Java programming lanugage. |
java.sql.Blob |
getBlob(java.lang.String columnName)
Retrieves the value of the designated column in this JoinRowSetImpl object as a Blob object
in the Java programming lanugage. |
boolean |
getBoolean(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
boolean value. |
boolean |
getBoolean(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a boolean value. |
byte |
getByte(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
byte value. |
byte |
getByte(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a byte value. |
byte[] |
getBytes(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
byte array value. |
byte[] |
getBytes(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a byte array. |
java.io.Reader |
getCharacterStream(int columnIndex)
Retrieves the value stored in the designated column of the current row as a java.io.Reader object. |
java.io.Reader |
getCharacterStream(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a java.io.Reader object. |
java.sql.Clob |
getClob(int columnIndex)
Retrieves the value of the designated column in this JoinRowSetImpl object as a Clob object
in the Java programming lanugage. |
java.sql.Clob |
getClob(java.lang.String columnName)
Retrieves the value of the designated column in this JoinRowSetImpl object as a Clob object
in the Java programming lanugage. |
java.lang.String |
getCursorName()
Retrieves the name of the SQL cursor used by this JoinRowSetImpl object. |
java.sql.Date |
getDate(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
java.sql.Date object. |
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar cal)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a java.sql.Date
object, using the given Calendar object to construct an
appropriate millisecond value for the date. |
java.sql.Date |
getDate(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a java.sql.Date object. |
java.sql.Date |
getDate(java.lang.String columnName,
java.util.Calendar cal)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a java.sql.Date
object, using the given Calendar object to construct an
appropriate millisecond value for the date. |
double |
getDouble(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
double value. |
double |
getDouble(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a double value. |
float |
getFloat(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
float value. |
float |
getFloat(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a float value. |
int |
getInt(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
short value. |
int |
getInt(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as an int value. |
int |
getJoinType()
Returns the last set SQL JOIN type in this JoinRowSetImpl
object |
int[] |
getKeyColumns()
Returns the columns that make a key to uniquely identify a row in this JoinRowSetImpl object. |
long |
getLong(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
long value. |
long |
getLong(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a long value. |
java.sql.ResultSetMetaData |
getMetaData()
Retrieves the ResultSetMetaData object that contains
information about this CachedRowsSet object. |
java.lang.Object |
getObject(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as an
Object value. |
java.lang.Object |
getObject(int columnIndex,
java.util.Map map)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as an
Object value. |
java.lang.Object |
getObject(java.lang.String columnName)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as an
Object value. |
java.lang.Object |
getObject(java.lang.String columnName,
java.util.Map map)
Retrieves the value of the designated column in this JoinRowSetImpl object as an Object in
the Java programming lanugage, using the given
java.util.Map object to custom map the value if
appropriate. |
java.sql.ResultSet |
getOriginal()
Returns a ResultSet object containing the original value of this
CachedRowSet object. |
java.sql.ResultSet |
getOriginalRow()
Returns a result set containing the original value of the rowset. |
java.sql.Ref |
getRef(int columnIndex)
Retrieves the value of the designated column in this JoinRowSetImpl object as a Ref object
in the Java programming lanugage. |
java.sql.Ref |
getRef(java.lang.String columnName)
Retrieves the value of the designated column in this JoinRowSetImpl object as a Ref object
in the Java programming lanugage. |
int |
getRow()
Returns the number of the current row in this JoinRowSetImpl
object. |
java.lang.String[] |
getRowSetNames()
Returns a string array of the RowSet names currently residing with the JoinRowSet object instance. |
java.util.Collection |
getRowSets()
Returns a Collection of the RowSet object instances
currently residing with the instance of the JoinRowSet
object instance. |
short |
getShort(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
short value. |
short |
getShort(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a short value. |
java.sql.Statement |
getStatement()
Returns null . |
java.lang.String |
getString(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
String object. |
java.lang.String |
getString(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a String object. |
java.sql.Time |
getTime(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
java.sql.Time object. |
java.sql.Time |
getTime(int columnIndex,
java.util.Calendar cal)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a java.sql.Time
object, using the given Calendar object to construct an
appropriate millisecond value for the date. |
java.sql.Time |
getTime(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a java.sql.Time object. |
java.sql.Time |
getTime(java.lang.String columnName,
java.util.Calendar cal)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a java.sql.Time
object, using the given Calendar object to construct an
appropriate millisecond value for the date. |
java.sql.Timestamp |
getTimestamp(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
java.sql.Timestamp object. |
java.sql.Timestamp |
getTimestamp(int columnIndex,
java.util.Calendar cal)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a java.sql.Timestamp
object, using the given Calendar object to construct an
appropriate millisecond value for the date. |
java.sql.Timestamp |
getTimestamp(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a java.sql.Timestamp object. |
java.sql.Timestamp |
getTimestamp(java.lang.String columnName,
java.util.Calendar cal)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a
java.sql.Timestamp object, using the given
Calendar object to construct an appropriate
millisecond value for the date. |
java.io.InputStream |
getUnicodeStream(int columnIndex)
Deprecated. |
java.io.InputStream |
getUnicodeStream(java.lang.String columnName)
Deprecated. use the method getCharacterStream instead |
java.net.URL |
getURL(int columnIndex)
Provide interface coverage for getURL(int) in ResultSet->RowSet |
java.net.URL |
getURL(java.lang.String columnName)
Provide interface coverage for getURL(String) in ResultSet->RowSet |
java.sql.SQLWarning |
getWarnings()
The first warning reported by calls on this CachedRowSetImpl
object is returned. |
java.lang.String |
getWhereClause()
Return a SQL-like description of the WHERE clause being used
in a JoinRowSet object instance. |
void |
insertRow()
Inserts the contents of this JoinRowSetImpl object's insert
row into this rowset immediately following the current row. |
boolean |
isAfterLast()
Indicates whether the cursor is after the last row in this JoinRowSetImpl object. |
boolean |
isBeforeFirst()
Indicates whether the cursor is before the first row in this JoinRowSetImpl object. |
boolean |
isFirst()
Indicates whether the cursor is on the first row in this JoinRowSetImpl object. |
boolean |
isLast()
Indicates whether the cursor is on the last row in this JoinRowSetImpl object. |
boolean |
last()
Moves this JoinRowSetImpl object's cursor to the last row
and returns true if the operation was successful. |
void |
moveToCurrentRow()
Moves the cursor for this JoinRowSetImpl object to
the current row. |
void |
moveToInsertRow()
Moves the cursor for this JoinRowSetImpl object
to the insert row. |
boolean |
next()
Moves the cursor down one row from its current position and returns true if the new cursor position is a
valid row. |
boolean |
previous()
Moves this JoinRowSetImpl object's cursor to the
previous row and returns true if the cursor is on
a valid row or false if it is not. |
void |
readXml(java.io.InputStream iStream)
Reads a stream based XML input to populate an WebRowSet |
void |
readXml(java.io.Reader reader)
Reads this JoinRowSet object in its XML format. |
void |
refreshRow()
Sets the current row with its original value and marks the row as not updated, thus undoing any changes made to the row since the last call to the methods updateRow or deleteRow . |
boolean |
relative(int rows)
Moves the cursor the specified number of rows from the current position, with a positive number moving it forward and a negative number moving it backward. |
boolean |
rowDeleted()
Indicates whether the current row has been deleted. |
boolean |
rowInserted()
Indicates whether the current row has been inserted. |
boolean |
rowUpdated()
Indicates whether the current row of this JoinRowSetImpl
object has been updated. |
void |
setJoinType(int type)
Sets the type of SQL JOIN that this JoinRowSet
object will use. |
void |
setKeyColumns(int[] cols)
Sets this JoinRowSetImpl object's
keyCols field with the given array of column
numbers, which forms a key for uniquely identifying a row
in this rowset. |
void |
setMetaData(javax.sql.RowSetMetaData md)
Sets the metadata for this JoinRowSetImpl object
with the given RowSetMetaData object. |
void |
setOriginalRow()
Returns a result set containing the original value of the current row only. |
int |
size()
Returns the number of rows in this JoinRowSetImpl object. |
boolean |
supportsCrossJoin()
Returns true if this JoinRowSet object supports
an SQL CROSS_JOIN and false if it does not. |
boolean |
supportsFullJoin()
Returns true if this JoinRowSet object supports
an SQL FULL_JOIN and false if it does not. |
boolean |
supportsInnerJoin()
Returns true if this JoinRowSet object supports
an SQL INNER_JOIN and false if it does not. |
boolean |
supportsLeftOuterJoin()
Returns true if this JoinRowSet object supports
an SQL LEFT_OUTER_JOIN and false if it does not. |
boolean |
supportsRightOuterJoin()
Returns true if this JoinRowSet object supports
an SQL RIGHT_OUTER_JOIN and false if it does not. |
CachedRowSet |
toCachedRowSet()
Creates a separate CachedRowSet object that contains the data
in this JoinRowSet object. |
void |
updateArray(int columnIndex,
java.sql.Array a)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Array object. |
void |
updateArray(java.lang.String columnName,
java.sql.Array a)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Array object. |
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given
ASCII stream value. |
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
Unsupported; throws an UnsupportedOperationException
if called. |
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
java.math.BigDecimal object. |
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
java.math.BigDecimal object. |
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
java.io.InputStream object. |
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
java.io.InputStream object. |
void |
updateBlob(int columnIndex,
java.sql.Blob b)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Blob value. |
void |
updateBlob(java.lang.String columnName,
java.sql.Blob b)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Blob object. |
void |
updateBoolean(int columnIndex,
boolean x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
boolean value. |
void |
updateBoolean(java.lang.String columnName,
boolean x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
boolean value. |
void |
updateByte(int columnIndex,
byte x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
byte value. |
void |
updateByte(java.lang.String columnName,
byte x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
byte value. |
void |
updateBytes(int columnIndex,
byte[] x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
byte array. |
void |
updateBytes(java.lang.String columnName,
byte[] x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
byte array. |
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
java.io.Reader object. |
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader x,
int length)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
java.io.Reader object. |
void |
updateClob(int columnIndex,
java.sql.Clob c)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Clob object. |
void |
updateClob(java.lang.String columnName,
java.sql.Clob c)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Clob object. |
void |
updateDate(int columnIndex,
java.sql.Date x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Date object. |
void |
updateDate(java.lang.String columnName,
java.sql.Date x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Date object. |
void |
updateDouble(int columnIndex,
double x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
double value. |
void |
updateDouble(java.lang.String columnName,
double x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
double value. |
void |
updateFloat(int columnIndex,
float x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
float value. |
void |
updateFloat(java.lang.String columnName,
float x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
float value. |
void |
updateInt(int columnIndex,
int x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
int value. |
void |
updateInt(java.lang.String columnName,
int x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
int value. |
void |
updateLong(int columnIndex,
long x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
long value. |
void |
updateLong(java.lang.String columnName,
long x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
long value. |
void |
updateNull(int columnIndex)
Sets the designated nullable column in the current row or the insert row of this JoinRowSetImpl object with
null value. |
void |
updateNull(java.lang.String columnName)
Sets the designated nullable column in the current row or the insert row of this JoinRowSetImpl object with
null value. |
void |
updateObject(int columnIndex,
java.lang.Object x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Object value. |
void |
updateObject(int columnIndex,
java.lang.Object x,
int scale)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Object value. |
void |
updateRef(int columnIndex,
java.sql.Ref ref)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Ref value. |
void |
updateRef(java.lang.String columnName,
java.sql.Ref ref)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Ref value. |
void |
updateRow()
Marks the current row of this JoinRowSetImpl object as
updated and notifies listeners registered with this rowset that the
row has changed. |
void |
updateShort(int columnIndex,
short x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
short value. |
void |
updateShort(java.lang.String columnName,
short x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
short value. |
void |
updateString(int columnIndex,
java.lang.String x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
String object. |
void |
updateString(java.lang.String columnName,
java.lang.String x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
String object. |
void |
updateTime(int columnIndex,
java.sql.Time x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Time object. |
void |
updateTime(java.lang.String columnName,
java.sql.Time x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Time object. |
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Timestamp object. |
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given
Timestamp object. |
boolean |
wasNull()
Reports whether the last column read was SQL NULL . |
void |
writeXml(java.io.OutputStream oStream)
Creates an an output stream of the internal state and contents of a WebRowSet for XML proceessing |
void |
writeXml(java.sql.ResultSet rs,
java.io.OutputStream oStream)
Creates a new WebRowSet object, populates it with
the contents of the ResultSet and creates an output
streams the internal state and contents of the rowset for XML processing. |
void |
writeXml(java.sql.ResultSet rs,
java.io.Writer writer)
Creates a new WebRowSet object, populates it with the
data in the given ResultSet object, and writes it
to the given java.io.Writer object in XML format. |
void |
writeXml(java.io.Writer writer)
Writes this JoinRowSet object to the given
java.io.Writer object in XML format. |
Methods inherited from class java.lang.Object |
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface javax.sql.rowset.CachedRowSet |
acceptChanges, acceptChanges, columnUpdated, commit, createCopy, createCopyNoConstraints, createCopySchema, createShared, getPageSize, getRowSetWarnings, getShowDeleted, getSyncProvider, getTableName, nextPage, populate, populate, previousPage, release, restoreOriginal, rollback, rollback, rowSetPopulated, setPageSize, setShowDeleted, setSyncProvider, setTableName, toCollection, toCollection, toCollection, undoDelete, undoInsert, undoUpdate |
Methods inherited from interface javax.sql.RowSet |
addRowSetListener, clearParameters, getCommand, getDataSourceName, getEscapeProcessing, getMaxFieldSize, getMaxRows, getPassword, getQueryTimeout, getTransactionIsolation, getTypeMap, getUrl, getUsername, isReadOnly, removeRowSetListener, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setCommand, setConcurrency, setDataSourceName, setDate, setDate, setDouble, setEscapeProcessing, setFloat, setInt, setLong, setMaxFieldSize, setMaxRows, setNull, setNull, setObject, setObject, setObject, setPassword, setQueryTimeout, setReadOnly, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setTransactionIsolation, setType, setTypeMap, setUrl, setUsername |
Methods inherited from interface java.sql.ResultSet |
getConcurrency, getFetchDirection, getFetchSize, getType, setFetchDirection, setFetchSize |
Methods inherited from interface javax.sql.rowset.Joinable |
getMatchColumnIndexes, getMatchColumnNames, setMatchColumn, setMatchColumn, setMatchColumn, setMatchColumn, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn |
Methods inherited from interface javax.sql.RowSetInternal |
getParams |
Constructor Detail |
public JoinRowSetImpl() throws java.sql.SQLException
JoinRowSetImpl
class. Configures various internal data
structures to provide mechanisms required for JoinRowSet
interface
implementation.
java.sql.SQLException
- if an error occurs in instantiating an instance of
JoinRowSetImpl
Method Detail |
public void addRowSet(Joinable rowset) throws java.sql.SQLException
RowSet
object to this
JoinRowSet
object. If this
rowset is the first to be added to the JoinRowSet
object, it forms the basis for the JOIN
relationships to be formed.
This method should be used when the given RowSet
object
already has a match column set.
addRowSet
in interface JoinRowSet
rowset
- the RowSet
object that implements the
Joinable
interface and is to be added
to this JoinRowSet
object
java.sql.SQLException
- if an empty RowSet
is added to the to the
JoinRowSet
; if a match column is not set; or if an
additional RowSet
violates the active JOIN
Joinable.setMatchColumn(int)
public void addRowSet(javax.sql.RowSet rowset, int columnIdx) throws java.sql.SQLException
RowSet
object to the JOIN
relation
and sets the designated column as the match column.
If the given RowSet
object is the first to be added to this JoinRowSet
object, it forms the basis of the JOIN
relationship to be formed
when other RowSet
objects are added .
This method should be used when the given RowSet
object
does not already have a match column set.
addRowSet
in interface JoinRowSet
rowset
- a RowSet
object to be added to
the JOIN
relation; must implement the Joinable
interfacecolumnIdx
- an int
giving the index of the column to be set as
the match column
java.sql.SQLException
- if (1) an empty RowSet
object is added to this
JoinRowSet
object, (2) a match column has not been set,
or (3) the RowSet
object being added violates the active
JOIN
Joinable.unsetMatchColumn(int)
public void addRowSet(javax.sql.RowSet rowset, java.lang.String columnName) throws java.sql.SQLException
RowSet
object to the JOIN
relationship
and sets the designated column as the match column. If the given
RowSet
object is the first to be added to this JoinRowSet
object, it forms the basis of the JOIN
relationship to be formed
when other RowSet
objects are added .
This method should be used when the given RowSet
object
does not already have a match column set.
addRowSet
in interface JoinRowSet
rowset
- a RowSet
object to be added to
the JOIN
relationcolumnName
- a String
object giving the name of the column
to be set as the match column; must implement the Joinable
interface
java.sql.SQLException
- if (1) an empty RowSet
object is added to this
JoinRowSet
object, (2) a match column has not been set,
or (3) the RowSet
object being added violates the active
JOIN
public void addRowSet(javax.sql.RowSet[] rowset, int[] columnIdx) throws java.sql.SQLException
RowSet
objects to the JOIN
relationship
and sets the designated columns as the match columns. If the first
RowSet
object in the array of RowSet
objects
is the first to be added to this JoinRowSet
object, it forms the basis of the JOIN
relationship to be formed
when other RowSet
objects are added.
The first int
in columnIdx is used to set the match column for the first
RowSet
object in rowset, the second int
in columnIdx is used to set the match column for the second
RowSet
object in rowset, and so on.
This method should be used when the given RowSet
objects
do not already have match columns set.
addRowSet
in interface JoinRowSet
rowset
- an array of RowSet
objects to be added to
the JOIN
relation; each RowSet
object must
implement the Joinable
interfacecolumnIdx
- an array of int
values designating the columns
to be set as the
match columns for the RowSet
objects in rowset
java.sql.SQLException
- if the number of RowSet
objects in
rowset is not equal to the number of int
values
in columnIdxpublic void addRowSet(javax.sql.RowSet[] rowset, java.lang.String[] columnName) throws java.sql.SQLException
RowSet
objects to the JOIN
relationship
and sets the designated columns as the match columns. If the first
RowSet
object in the array of RowSet
objects
is the first to be added to this JoinRowSet
object, it forms the basis of the JOIN
relationship to be formed
when other RowSet
objects are added.
The first String
object
in columnName is used to set the match column for the first
RowSet
object in rowset, the second String
object in columnName is used to set the match column for the second
RowSet
object in rowset, and so on.
This method should be used when the given RowSet
objects
do not already have match columns set.
addRowSet
in interface JoinRowSet
rowset
- an array of RowSet
objects to be added to
the JOIN
relation; each RowSet
object must
implement the Joinable
interfacecolumnName
- an array of String
objects designating the columns
to be set as the
match columns for the RowSet
objects in rowset
java.sql.SQLException
- if the number of RowSet
objects in
rowset is not equal to the number of String
objects
in columnName, an empty JdbcRowSet
is added to the to the
JoinRowSet
, if a match column is not set,
or one or the RowSet
objects in rowset violates the
active JOIN
public java.util.Collection getRowSets() throws java.sql.SQLException
RowSet
object instances
currently residing with the instance of the JoinRowSet
object instance. This should return the 'n' number of RowSet contained
within the JOIN and maintain any updates that have occoured while in
this union.
getRowSets
in interface JoinRowSet
Collection
of the added RowSet
object instances
java.sql.SQLException
- if an error occours generating a collection
of the originating RowSets contained within the JOIN.public java.lang.String[] getRowSetNames() throws java.sql.SQLException
JoinRowSet
object instance.
getRowSetNames
in interface JoinRowSet
java.sql.SQLException
- if an error occours retrieving the RowSet namesCachedRowSet.setTableName(java.lang.String)
public CachedRowSet toCachedRowSet() throws java.sql.SQLException
CachedRowSet
object that contains the data
in this JoinRowSet
object.
If any updates or modifications have been applied to this JoinRowSet
object, the CachedRowSet
object returned by this method will
not be able to persist
the changes back to the originating rows and tables in the
data source because the data may be from different tables. The
CachedRowSet
instance returned should not
contain modification data, such as whether a row has been updated or what the
original values are. Also, the CachedRowSet
object should clear
its properties pertaining to
its originating SQL statement. An application should reset the
SQL statement using the RowSet.setCommand
method.
To persist changes back to the data source, the JoinRowSet
object
calls the method acceptChanges
. Implementations
can leverage the internal data and update tracking in their
implementations to interact with the SyncProvider
to persist any
changes.
toCachedRowSet
in interface JoinRowSet
CachedRowSet
object containing the contents of this
JoinRowSet
object
java.sql.SQLException
- if an error occurs assembling the CachedRowSet
objectRowSet
,
CachedRowSet
,
SyncProvider
public boolean supportsCrossJoin()
true
if this JoinRowSet
object supports
an SQL CROSS_JOIN
and false
if it does not.
supportsCrossJoin
in interface JoinRowSet
true
if the CROSS_JOIN is supported; false
otherwisepublic boolean supportsInnerJoin()
true
if this JoinRowSet
object supports
an SQL INNER_JOIN
and false
if it does not.
supportsInnerJoin
in interface JoinRowSet
public boolean supportsLeftOuterJoin()
true
if this JoinRowSet
object supports
an SQL LEFT_OUTER_JOIN
and false
if it does not.
supportsLeftOuterJoin
in interface JoinRowSet
public boolean supportsRightOuterJoin()
true
if this JoinRowSet
object supports
an SQL RIGHT_OUTER_JOIN
and false
if it does not.
supportsRightOuterJoin
in interface JoinRowSet
public boolean supportsFullJoin()
true
if this JoinRowSet
object supports
an SQL FULL_JOIN
and false
if it does not.
supportsFullJoin
in interface JoinRowSet
public void setJoinType(int type) throws java.sql.SQLException
JOIN
that this JoinRowSet
object will use. This method
allows an application to adjust the type of JOIN
imposed
on tables contained within this JoinRowSet
object and to do it
on the fly. The last JOIN
type set determines the type of
JOIN
to be performed.
Implementations should throw an SQLException
if they do
not support the given JOIN
type.
setJoinType
in interface JoinRowSet
type
- one of the standard JoinRowSet
constants
indicating the type of JOIN
. Must be one of the
following:
JoinRowSet.CROSS_JOIN
JoinRowSet.INNER_JOIN
JoinRowSet.LEFT_OUTER_JOIN
JoinRowSet.RIGHT_OUTER_JOIN
, or
JoinRowSet.FULL_JOIN
java.sql.SQLException
- if an unsupported JOIN
type is setJoinRowSet.getJoinType()
public java.lang.String getWhereClause() throws java.sql.SQLException
WHERE
clause being used
in a JoinRowSet
object instance. An implementation can describe
the WHERE
clause of the SQL JOIN
by supplying a SQL
strings description of JOIN
or provide a textual description to assist
applications using a JoinRowSet
.
getWhereClause
in interface JoinRowSet
WHERE
cluase used in the JoinRowSet
instance
java.sql.SQLException
- if an error occurs in generating a representation
of the WHERE
clause.public boolean next() throws java.sql.SQLException
true
if the new cursor position is a
valid row.
The cursor for a new ResultSet
object is initially
positioned before the first row. The first call to the method
next
moves the cursor to the first row, making it
the current row; the second call makes the second row the
current row, and so on.
If an input stream from the previous row is open, it is
implicitly closed. The ResultSet
object's warning
chain is cleared when a new row is read.
next
in interface java.sql.ResultSet
next
in class CachedRowSetImpl
true
if the new current row is valid;
false
if there are no more rows
java.sql.SQLException
- if an error occurs or
the cursor is not positioned in the rowset, before
the first row, or after the last rowpublic void close() throws java.sql.SQLException
release
is called. This method sends a
RowSetChangedEvent
object to all registered listeners prior
to returning.
close
in interface java.sql.ResultSet
close
in class CachedRowSetImpl
java.sql.SQLException
- if an error occurspublic boolean wasNull() throws java.sql.SQLException
NULL
.
Note that you must first call the method getXXX
on a column to try to read its value and then call the method
wasNull
to determine whether the value was
SQL NULL
.
wasNull
in interface java.sql.ResultSet
wasNull
in class CachedRowSetImpl
true
if the value in the last column read
was SQL NULL
; false
otherwise
java.sql.SQLException
- if an error occurspublic java.lang.String getString(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
String
object.
getString
in interface java.sql.ResultSet
getString
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is null
java.sql.SQLException
- if the given column index is out of bounds or
the cursor is not on a valid rowpublic boolean getBoolean(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
boolean
value.
getBoolean
in interface java.sql.ResultSet
getBoolean
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is false
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failsCachedRowSetImpl.getBoolean(String)
public byte getByte(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
byte
value.
getByte
in interface java.sql.ResultSet
getByte
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is 0
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failsCachedRowSetImpl.getByte(String)
public short getShort(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
short
value.
getShort
in interface java.sql.ResultSet
getShort
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is 0
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failsCachedRowSetImpl.getShort(String)
public int getInt(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
short
value.
getInt
in interface java.sql.ResultSet
getInt
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is 0
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failspublic long getLong(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
long
value.
getLong
in interface java.sql.ResultSet
getLong
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is 0
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failsCachedRowSetImpl.getLong(String)
public float getFloat(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
float
value.
getFloat
in interface java.sql.ResultSet
getFloat
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is 0
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failsCachedRowSetImpl.getFloat(String)
public double getDouble(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
double
value.
getDouble
in interface java.sql.ResultSet
getDouble
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is 0
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failsCachedRowSetImpl.getDouble(String)
public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws java.sql.SQLException
JoinRowSetImpl
object as a
java.math.BigDecimal
object.
This method is deprecated; use the version of getBigDecimal
that does not take a scale parameter and returns a value with full
precision.
getBigDecimal
in interface java.sql.ResultSet
getBigDecimal
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowsetscale
- the number of digits to the right of the decimal point in the
value returned
NULL
, the
result is null
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failspublic byte[] getBytes(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
byte array
value.
getBytes
in interface java.sql.ResultSet
getBytes
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is null
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or the the value to be
retrieved is not binaryCachedRowSetImpl.getBytes(String)
public java.sql.Date getDate(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
java.sql.Date
object.
getDate
in interface java.sql.ResultSet
getDate
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is null
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failspublic java.sql.Time getTime(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
java.sql.Time
object.
getTime
in interface java.sql.ResultSet
getTime
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is null
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failspublic java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
java.sql.Timestamp
object.
getTimestamp
in interface java.sql.ResultSet
getTimestamp
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is null
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failspublic java.io.InputStream getAsciiStream(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
java.sql.Timestamp
object.
getAsciiStream
in interface java.sql.ResultSet
getAsciiStream
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
NULL
, the
result is null
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failsCachedRowSetImpl.getAsciiStream(String)
public java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. . Also, a stream may return 0 for available() whether there is data available or not.
getUnicodeStream
in interface java.sql.ResultSet
getUnicodeStream
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowset
java.sql.SQLException
- if an error occurspublic java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not.
getBinaryStream
in interface java.sql.ResultSet
getBinaryStream
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
java.sql.SQLException
- if an error occursCachedRowSetImpl.getBinaryStream(String)
public java.lang.String getString(java.lang.String columnName) throws java.sql.SQLException
String
object.
getString
in interface java.sql.ResultSet
getString
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
,
the result is null
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowpublic boolean getBoolean(java.lang.String columnName) throws java.sql.SQLException
boolean
value.
getBoolean
in interface java.sql.ResultSet
getBoolean
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
,
the result is false
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowCachedRowSetImpl.getBoolean(int)
public byte getByte(java.lang.String columnName) throws java.sql.SQLException
byte
value.
getByte
in interface java.sql.ResultSet
getByte
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
,
the result is 0
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowpublic short getShort(java.lang.String columnName) throws java.sql.SQLException
short
value.
getShort
in interface java.sql.ResultSet
getShort
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
,
the result is 0
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowCachedRowSetImpl.getShort(int)
public int getInt(java.lang.String columnName) throws java.sql.SQLException
int
value.
getInt
in interface java.sql.ResultSet
getInt
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
,
the result is 0
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowpublic long getLong(java.lang.String columnName) throws java.sql.SQLException
long
value.
getLong
in interface java.sql.ResultSet
getLong
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
,
the result is 0
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowCachedRowSetImpl.getLong(int)
public float getFloat(java.lang.String columnName) throws java.sql.SQLException
float
value.
getFloat
in interface java.sql.ResultSet
getFloat
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
,
the result is 0
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowCachedRowSetImpl.getFloat(String)
public double getDouble(java.lang.String columnName) throws java.sql.SQLException
double
value.
getDouble
in interface java.sql.ResultSet
getDouble
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
,
the result is 0
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowCachedRowSetImpl.getDouble(int)
public java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws java.sql.SQLException
getBigDecimal(String columnName)
instead
java.math.BigDecimal
object.
getBigDecimal
in interface java.sql.ResultSet
getBigDecimal
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
objectscale
- the number of digits to the right of the decimal point
NULL
,
the result is null
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowpublic byte[] getBytes(java.lang.String columnName) throws java.sql.SQLException
getBytes
in interface java.sql.ResultSet
getBytes
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
,
the result is null
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowCachedRowSetImpl.getBytes(int)
public java.sql.Date getDate(java.lang.String columnName) throws java.sql.SQLException
java.sql.Date
object.
getDate
in interface java.sql.ResultSet
getDate
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
,
the result is null
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowpublic java.sql.Time getTime(java.lang.String columnName) throws java.sql.SQLException
java.sql.Time
object.
getTime
in interface java.sql.ResultSet
getTime
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
,
the result is null
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowpublic java.sql.Timestamp getTimestamp(java.lang.String columnName) throws java.sql.SQLException
java.sql.Timestamp
object.
getTimestamp
in interface java.sql.ResultSet
getTimestamp
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
,
the result is null
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowpublic java.io.InputStream getAsciiStream(java.lang.String columnName) throws java.sql.SQLException
UnsupportedOperationException
if it is called.
A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII format.
Note: All the data in the returned stream must
be read prior to getting the value of any other column. The
next call to a getXXX
method implicitly closes the stream.
getAsciiStream
in interface java.sql.ResultSet
getAsciiStream
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
, the result is null
.
java.lang.UnsupportedOperationException
- if this method is called
java.sql.SQLException
- if (1) the given column name is not the name of
a column in this rowset
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) the designated column does not store an
SQL CHAR, VARCHAR
, LONGVARCHAR
BINARY, VARBINARY
or LONGVARBINARY
value. The
bold SQL type designates the recommended return types that this method is
used to retrieve.CachedRowSetImpl.getAsciiStream(int)
public java.io.InputStream getUnicodeStream(java.lang.String columnName) throws java.sql.SQLException
getCharacterStream
instead
java.io.InputStream
object.
A column value can be retrieved as a stream of Unicode characters
and then read in chunks from the stream. This method is particularly
suitable for retrieving large LONGVARCHAR
values.
The JDBC driver will do any necessary conversion from the database
format into Unicode.
Note: All the data in the returned stream must
be read prior to getting the value of any other column. The
next call to a getXXX
method implicitly closes the stream.
getUnicodeStream
in interface java.sql.ResultSet
getUnicodeStream
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
, the result is null
.
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowpublic java.io.InputStream getBinaryStream(java.lang.String columnName) throws java.sql.SQLException
java.io.InputStream
object.
A column value can be retrieved as a stream of uninterpreted bytes
and then read in chunks from the stream. This method is particularly
suitable for retrieving large LONGVARBINARY
values.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
getBinaryStream
in interface java.sql.ResultSet
getBinaryStream
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
, the result is null
.
java.sql.SQLException
- if the given column name does not match one of
this rowset's column names or the cursor is not on one of
this rowset's rows or its insert rowCachedRowSetImpl.getBinaryStream(int)
public java.sql.SQLWarning getWarnings()
CachedRowSetImpl
CachedRowSetImpl
object is returned. Subsequent CachedRowSetImpl
warnings will
be chained to this SQLWarning
.
The warning chain is automatically cleared each time a new row is read.
Note: This warning chain only covers warnings caused
by ResultSet
methods. Any warning caused by statement
methods (such as reading OUT parameters) will be chained on the
Statement
object.
getWarnings
in interface java.sql.ResultSet
getWarnings
in class CachedRowSetImpl
public void clearWarnings()
UnsupportedOperationException
if called.
After a call to this method, the getWarnings
method
returns null
until a new warning is reported for this
JoinRowSetImpl
object.
clearWarnings
in interface java.sql.ResultSet
clearWarnings
in class CachedRowSetImpl
java.lang.UnsupportedOperationException
- if this method is calledpublic java.lang.String getCursorName() throws java.sql.SQLException
JoinRowSetImpl
object.
In SQL, a result table is retrieved through a cursor that is
named. The current row of a result can be updated or deleted
using a positioned update/delete statement that references the
cursor name. To insure that the cursor has the proper isolation
level to support an update operation, the cursor's SELECT
statement should be of the form 'select for update'. If the 'for update'
clause is omitted, positioned updates may fail.
JDBC supports this SQL feature by providing the name of the
SQL cursor used by a ResultSet
object. The current row
of a result set is also the current row of this SQL cursor.
Note: If positioned updates are not supported, an
SQLException
is thrown.
getCursorName
in interface java.sql.ResultSet
getCursorName
in class CachedRowSetImpl
JoinRowSetImpl
object's
cursor
java.sql.SQLException
- if an error occurspublic java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
ResultSetMetaData
object that contains
information about this CachedRowsSet
object. The
information includes the number of columns, the data type for each
column, and other properties for each column.
getMetaData
in interface java.sql.ResultSet
getMetaData
in class CachedRowSetImpl
ResultSetMetaData
object that describes this
JoinRowSetImpl
object's columns
java.sql.SQLException
- if an error occursRowSetMetaData
public java.lang.Object getObject(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as an
Object
value.
The type of the Object
will be the default
Java object type corresponding to the column's SQL type,
following the mapping for built-in types specified in the JDBC
specification.
This method may also be used to read datatabase-specific abstract data types.
This implementation of the method getObject
extends its
behavior so that it gets the attributes of an SQL structured type as
as an array of Object
values. This method also custom
maps SQL user-defined types to classes in the Java programming language.
When the specified column contains
a structured or distinct value, the behavior of this method is as
if it were a call to the method getObject(columnIndex,
this.getStatement().getConnection().getTypeMap())
.
getObject
in interface java.sql.ResultSet
getObject
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
java.lang.Object
holding the column value;
if the value is SQL NULL
, the result is null
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or there is a problem getting
the Class
object for a custom mappingCachedRowSetImpl.getObject(String)
public java.lang.Object getObject(int columnIndex, java.util.Map map) throws java.sql.SQLException
JoinRowSetImpl
object as an
Object
value.
The type of the Object
will be the default
Java object type corresponding to the column's SQL type,
following the mapping for built-in types specified in the JDBC
specification.
This method may also be used to read datatabase-specific abstract data types.
This implementation of the method getObject
extends its
behavior so that it gets the attributes of an SQL structured type as
as an array of Object
values. This method also custom
maps SQL user-defined types to classes
in the Java programming language. When the specified column contains
a structured or distinct value, the behavior of this method is as
if it were a call to the method getObject(columnIndex,
this.getStatement().getConnection().getTypeMap())
.
getObject
in interface java.sql.ResultSet
getObject
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowsetmap
- a java.util.Map
object showing the mapping
from SQL type names to classes in the Java programming
language
java.lang.Object
holding the column value;
if the value is SQL NULL
, the result is
null
java.sql.SQLException
- if (1) the given column name does not match
one of this rowset's column names, (2) the cursor is not
on a valid row, or (3) there is a problem getting
the Class
object for a custom mappingpublic java.lang.Object getObject(java.lang.String columnName) throws java.sql.SQLException
JoinRowSetImpl
object as an
Object
value.
The type of the Object
will be the default
Java object type corresponding to the column's SQL type,
following the mapping for built-in types specified in the JDBC
specification.
This method may also be used to read datatabase-specific abstract data types.
This implementation of the method getObject
extends its
behavior so that it gets the attributes of an SQL structured type as
as an array of Object
values. This method also custom
maps SQL user-defined types to classes
in the Java programming language. When the specified column contains
a structured or distinct value, the behavior of this method is as
if it were a call to the method getObject(columnIndex,
this.getStatement().getConnection().getTypeMap())
.
getObject
in interface java.sql.ResultSet
getObject
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring case
java.lang.Object
holding the column value;
if the value is SQL NULL
, the result is
null
java.sql.SQLException
- if (1) the given column name does not match
one of this rowset's column names, (2) the cursor is not
on a valid row, or (3) there is a problem getting
the Class
object for a custom mappingCachedRowSetImpl.getObject(int)
public java.lang.Object getObject(java.lang.String columnName, java.util.Map map) throws java.sql.SQLException
JoinRowSetImpl
object as an Object
in
the Java programming lanugage, using the given
java.util.Map
object to custom map the value if
appropriate.
getObject
in interface java.sql.ResultSet
getObject
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casemap
- a java.util.Map
object showing the mapping
from SQL type names to classes in the Java programming
language
Object
representing the SQL value
java.sql.SQLException
- if the given column index is out of bounds or
the cursor is not on one of this rowset's rows or its
insert rowpublic java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException
java.io.Reader
object.
Note: All the data in the returned stream must
be read prior to getting the value of any other column. The
next call to a getXXX
method implicitly closes the stream.
getCharacterStream
in interface java.sql.ResultSet
getCharacterStream
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
java.io.Reader
object. If the value is
SQL NULL
, the result is null
.
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or there is a type mismatchCachedRowSetImpl.getCharacterStream(String)
public java.io.Reader getCharacterStream(java.lang.String columnName) throws java.sql.SQLException
java.io.Reader
object.
Note: All the data in the returned stream must
be read prior to getting the value of any other column. The
next call to a getXXX
method implicitly closes the stream.
getCharacterStream
in interface java.sql.ResultSet
getCharacterStream
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of
a column in this JoinRowSetImpl
object
NULL
, the result is null
.
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or there is a type mismatchpublic java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a
java.math.BigDecimal
object.
getBigDecimal
in interface java.sql.ResultSet
getBigDecimal
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowset
java.math.BigDecimal
value with full precision;
if the value is SQL NULL
, the result is null
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failsCachedRowSetImpl.getBigDecimal(String)
public java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws java.sql.SQLException
JoinRowSetImpl
object as a
java.math.BigDecimal
object.
getBigDecimal
in interface java.sql.ResultSet
getBigDecimal
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring case
java.math.BigDecimal
value with full precision;
if the value is SQL NULL
, the result is null
java.sql.SQLException
- if the given column index is out of bounds,
the cursor is not on a valid row, or this method failsCachedRowSetImpl.getBigDecimal(int)
public int size()
JoinRowSetImpl
object.
size
in interface CachedRowSet
size
in class CachedRowSetImpl
public boolean isBeforeFirst() throws java.sql.SQLException
JoinRowSetImpl
object.
isBeforeFirst
in interface java.sql.ResultSet
isBeforeFirst
in class CachedRowSetImpl
true
if the cursor is before the first row;
false
otherwise or if the rowset contains no rows
java.sql.SQLException
- if an error occurspublic boolean isAfterLast() throws java.sql.SQLException
JoinRowSetImpl
object.
isAfterLast
in interface java.sql.ResultSet
isAfterLast
in class CachedRowSetImpl
true
if the cursor is after the last row;
false
otherwise or if the rowset contains no rows
java.sql.SQLException
- if an error occurspublic boolean isFirst() throws java.sql.SQLException
JoinRowSetImpl
object.
isFirst
in interface java.sql.ResultSet
isFirst
in class CachedRowSetImpl
true
if the cursor is on the first row;
false
otherwise or if the rowset contains no rows
java.sql.SQLException
- if an error occurspublic boolean isLast() throws java.sql.SQLException
JoinRowSetImpl
object.
Note: Calling the method isLast
may be expensive
because the JDBC driver might need to fetch ahead one row in order
to determine whether the current row is the last row in this rowset.
isLast
in interface java.sql.ResultSet
isLast
in class CachedRowSetImpl
true
if the cursor is on the last row;
false
otherwise or if this rowset contains no rows
java.sql.SQLException
- if an error occurspublic void beforeFirst() throws java.sql.SQLException
JoinRowSetImpl
object's cursor to the front of
the rowset, just before the first row. This method has no effect if
this rowset contains no rows.
beforeFirst
in interface java.sql.ResultSet
beforeFirst
in class CachedRowSetImpl
java.sql.SQLException
- if an error occurs or the type of this rowset
is ResultSet.TYPE_FORWARD_ONLY
public void afterLast() throws java.sql.SQLException
JoinRowSetImpl
object's cursor to the end of
the rowset, just after the last row. This method has no effect if
this rowset contains no rows.
afterLast
in interface java.sql.ResultSet
afterLast
in class CachedRowSetImpl
java.sql.SQLException
- if an error occurspublic boolean first() throws java.sql.SQLException
JoinRowSetImpl
object's cursor to the first row
and returns true
if the operation was successful. This
method also notifies registered listeners that the cursor has moved.
first
in interface java.sql.ResultSet
first
in class CachedRowSetImpl
true
if the cursor is on a valid row;
false
otherwise or if there are no rows in this
JoinRowSetImpl
object
java.sql.SQLException
- if the type of this rowset
is ResultSet.TYPE_FORWARD_ONLY
public boolean last() throws java.sql.SQLException
JoinRowSetImpl
object's cursor to the last row
and returns true
if the operation was successful. This
method also notifies registered listeners that the cursor has moved.
last
in interface java.sql.ResultSet
last
in class CachedRowSetImpl
true
if the cursor is on a valid row;
false
otherwise or if there are no rows in this
JoinRowSetImpl
object
java.sql.SQLException
- if the type of this rowset
is ResultSet.TYPE_FORWARD_ONLY
public int getRow() throws java.sql.SQLException
JoinRowSetImpl
object. The first row is number 1, the second number 2, and so on.
getRow
in interface java.sql.ResultSet
getRow
in class CachedRowSetImpl
0
if there is no
current row
java.sql.SQLException
- if an error occurspublic boolean absolute(int row) throws java.sql.SQLException
JoinRowSetImpl
object's cursor to the row number
specified.
If the number is positive, the cursor moves to an absolute row with
respect to the beginning of the rowset. The first row is row 1, the second
is row 2, and so on. For example, the following command, in which
crs
is a JoinRowSetImpl
object, moves the cursor
to the fourth row, starting from the beginning of the rowset.
crs.absolute(4);
If the number is negative, the cursor moves to an absolute row position
with respect to the end of the rowset. For example, calling
absolute(-1)
positions the cursor on the last row,
absolute(-2)
moves it on the next-to-last row, and so on.
If the JoinRowSetImpl
object crs
has five rows,
the following command moves the cursor to the fourth-to-last row, which
in the case of a rowset with five rows, is also the second row, counting
from the beginning.
crs.absolute(-4);
If the number specified is larger than the number of rows, the cursor
will move to the position after the last row. If the number specified
would move the cursor one or more rows before the first row, the cursor
moves to the position before the first row.
Note: Calling absolute(1)
is the same as calling the
method first()
. Calling absolute(-1)
is the
same as calling last()
.
absolute
in interface java.sql.ResultSet
absolute
in class CachedRowSetImpl
row
- a positive number to indicate the row, starting row numbering from
the first row, which is 1
; a negative number to indicate
the row, starting row numbering from the last row, which is
-1
; must not be 0
true
if the cursor is on the rowset; false
otherwise
java.sql.SQLException
- if the given cursor position is 0
or the
type of this rowset is ResultSet.TYPE_FORWARD_ONLY
public boolean relative(int rows) throws java.sql.SQLException
If the number is positive, the cursor moves the specified number of
rows toward the end of the rowset, starting at the current row.
For example, the following command, in which
crs
is a JoinRowSetImpl
object with 100 rows,
moves the cursor forward four rows from the current row. If the
current row is 50, the cursor would move to row 54.
crs.relative(4);
If the number is negative, the cursor moves back toward the beginning
the specified number of rows, starting at the current row.
For example, calling the method
absolute(-1)
positions the cursor on the last row,
absolute(-2)
moves it on the next-to-last row, and so on.
If the JoinRowSetImpl
object crs
has five rows,
the following command moves the cursor to the fourth-to-last row, which
in the case of a rowset with five rows, is also the second row
from the beginning.
crs.absolute(-4);
If the number specified is larger than the number of rows, the cursor
will move to the position after the last row. If the number specified
would move the cursor one or more rows before the first row, the cursor
moves to the position before the first row. In both cases, this method
throws an SQLException
.
Note: Calling absolute(1)
is the same as calling the
method first()
. Calling absolute(-1)
is the
same as calling last()
. Calling relative(0)
is valid, but it does not change the cursor position.
relative
in interface java.sql.ResultSet
relative
in class CachedRowSetImpl
rows
- an int
indicating the number of rows to move
the cursor, starting at the current row; a positive number
moves the cursor forward; a negative number moves the cursor
backward; must not move the cursor past the valid
rows
true
if the cursor is on a row in this
JoinRowSetImpl
object; false
otherwise
java.sql.SQLException
- if there are no rows in this rowset, the cursor is
positioned either before the first row or after the last row, or
the rowset is type ResultSet.TYPE_FORWARD_ONLY
public boolean previous() throws java.sql.SQLException
JoinRowSetImpl
object's cursor to the
previous row and returns true
if the cursor is on
a valid row or false
if it is not.
This method also notifies all listeners registered with this
JoinRowSetImpl
object that its cursor has moved.
Note: calling the method previous()
is not the same
as calling the method relative(-1)
. This is true
because it is possible to call previous()
from the insert
row, from after the last row, or from the current row, whereas
relative
may only be called from the current row.
The method previous
may used in a while
loop to iterate through a rowset starting after the last row
and moving toward the beginning. The loop ends when previous
returns false
, meaning that there are no more rows.
For example, the following code fragment retrieves all the data in
the JoinRowSetImpl
object crs
, which has
three columns. Note that the cursor must initially be positioned
after the last row so that the first call to the method
previous
places the cursor on the last line.
crs.afterLast();
while (previous()) {
String name = crs.getString(1);
int age = crs.getInt(2);
short ssn = crs.getShort(3);
System.out.println(name + " " + age + " " + ssn);
}
This method throws an SQLException
if the cursor is not
on a row in the rowset, before the first row, or after the last row.
previous
in interface java.sql.ResultSet
previous
in class CachedRowSetImpl
true
if the cursor is on a valid row;
false
if it is before the first row or after the
last row
java.sql.SQLException
- if the cursor is not on a valid position or the
type of this rowset is ResultSet.TYPE_FORWARD_ONLY
public int findColumn(java.lang.String columnName) throws java.sql.SQLException
findColumn
in interface java.sql.ResultSet
findColumn
in class CachedRowSetImpl
columnName
- a String
object giving the name of the
column for which the index will be returned; the name must
match the SQL name of a column in this JoinRowSet
object, ignoring case
java.sql.SQLException
- if the given column name does not match one of the
column names for this JoinRowSet
objectpublic boolean rowUpdated() throws java.sql.SQLException
JoinRowSetImpl
object has been updated. The value returned
depends on whether this rowset can detect updates: false
will always be returned if it does not detect updates.
rowUpdated
in interface java.sql.ResultSet
rowUpdated
in class CachedRowSetImpl
true
if the row has been visibly updated
by the owner or another and updates are detected;
false
otherwise
java.sql.SQLException
- if the cursor is on the insert row or not
on a valid rowDatabaseMetaData.updatesAreDetected(int)
public boolean columnUpdated(int indexColumn) throws java.sql.SQLException
JoinRowSetImpl
object has been updated. The
value returned depends on whether this rowset can detcted updates:
false
will always be returned if it does not detect updates.
columnUpdated
in interface CachedRowSet
columnUpdated
in class CachedRowSetImpl
indexColumn
- the index identifier of the column that may be have been updated.
true
if the column updated
false
otherwse
java.sql.SQLException
- if the cursor is on the insert row or not
on a valid rowDatabaseMetaData.updatesAreDetected(int)
public boolean rowInserted() throws java.sql.SQLException
rowInserted
in interface java.sql.ResultSet
rowInserted
in class CachedRowSetImpl
true
if a row has been inserted and inserts are detected;
false
otherwise
java.sql.SQLException
- if the cursor is on the insert row or not
not on a valid rowDatabaseMetaData.insertsAreDetected(int)
public boolean rowDeleted() throws java.sql.SQLException
false
if this rowset cannot detect
deletions.
rowDeleted
in interface java.sql.ResultSet
rowDeleted
in class CachedRowSetImpl
true
if (1)the current row is blank, indicating that
the row has been deleted, and (2)deletions are detected;
false
otherwise
java.sql.SQLException
- if the cursor is on a valid row in this rowsetDatabaseMetaData.deletesAreDetected(int)
public void updateNull(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object with
null
value.
This method updates a column value in the current row or the insert
row of this rowset; however, another method must be called to complete
the update process. If the cursor is on a row in the rowset, the
method updateRow()
must be called to mark the row as updated
and to notify listeners that the row has changed.
If the cursor is on the insert row, the method insertRow()
must be called to insert the new row into this rowset and to notify
listeners that a row has changed.
In order to propagate updates in this rowset to the underlying
data source, an application must call the method acceptChanges
after it calls either updateRow
or insertRow
.
updateNull
in interface java.sql.ResultSet
updateNull
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowset
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
boolean
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateBoolean
in interface java.sql.ResultSet
updateBoolean
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateByte(int columnIndex, byte x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
byte
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateByte
in interface java.sql.ResultSet
updateByte
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateShort(int columnIndex, short x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
short
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateShort
in interface java.sql.ResultSet
updateShort
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateInt(int columnIndex, int x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
int
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateInt
in interface java.sql.ResultSet
updateInt
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateLong(int columnIndex, long x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
long
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateLong
in interface java.sql.ResultSet
updateLong
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateFloat(int columnIndex, float x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
float
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateFloat
in interface java.sql.ResultSet
updateFloat
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateDouble(int columnIndex, double x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
double
value.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateDouble
in interface java.sql.ResultSet
updateDouble
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
java.math.BigDecimal
object.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateBigDecimal
in interface java.sql.ResultSet
updateBigDecimal
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
String
object.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to mark the row as updated.
If the cursor is on the insert row, the method insertRow()
must be called to insert the new row into this rowset and mark it
as inserted. Both of these methods must be called before the
cursor moves to another row.
The method acceptChanges
must be called if the
updated values are to be written back to the underlying database.
updateString
in interface java.sql.ResultSet
updateString
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
byte
array.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateBytes
in interface java.sql.ResultSet
updateBytes
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Date
object.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateDate
in interface java.sql.ResultSet
updateDate
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, (3) the type of the designated column is not
an SQL DATE
or TIMESTAMP
, or
(4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Time
object.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateTime
in interface java.sql.ResultSet
updateTime
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, (3) the type of the designated column is not
an SQL TIME
or TIMESTAMP
, or
(4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Timestamp
object.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateTimestamp
in interface java.sql.ResultSet
updateTimestamp
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, (3) the type of the designated column is not
an SQL DATE
, TIME
, or
TIMESTAMP
, or (4) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
CachedRowSetImpl
CachedRowSetImpl
object with the given
ASCII stream value.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method CachedRowSetImpl.updateRow()
must be called to update the database.
If the cursor is on the insert row, the method CachedRowSetImpl.insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateAsciiStream
in interface java.sql.ResultSet
updateAsciiStream
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column valuelength
- the number of one-byte ASCII characters in the stream
java.sql.SQLException
- if this method is invokedpublic void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
JoinRowSetImpl
object with the given
java.io.InputStream
object.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateBinaryStream
in interface java.sql.ResultSet
updateBinaryStream
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value; must be a java.io.InputStream
containing BINARY
, VARBINARY
, or
LONGVARBINARY
datalength
- the length of the stream in bytes
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, (3) the data in the stream is not binary, or
(4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException
JoinRowSetImpl
object with the given
java.io.Reader
object.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateCharacterStream
in interface java.sql.ResultSet
updateCharacterStream
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value; must be a java.io.Reader
containing BINARY
, VARBINARY
,
LONGVARBINARY
, CHAR
, VARCHAR
,
or LONGVARCHAR
datalength
- the length of the stream in characters
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, (3) the data in the stream is not a binary or
character type, or (4) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Object
value. The scale
parameter indicates
the number of digits to the right of the decimal point and is ignored
if the new column value is not a type that will be mapped to an SQL
DECIMAL
or NUMERIC
value.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateObject
in interface java.sql.ResultSet
updateObject
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column valuescale
- the number of digits to the right of the decimal point (for
DECIMAL
and NUMERIC
types only)
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Object
value.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateObject
in interface java.sql.ResultSet
updateObject
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetx
- the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateNull(java.lang.String columnName) throws java.sql.SQLException
JoinRowSetImpl
object with
null
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database.
updateNull
in interface java.sql.ResultSet
updateNull
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring case
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateBoolean(java.lang.String columnName, boolean x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
boolean
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateBoolean
in interface java.sql.ResultSet
updateBoolean
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateByte(java.lang.String columnName, byte x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
byte
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateByte
in interface java.sql.ResultSet
updateByte
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateShort(java.lang.String columnName, short x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
short
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateShort
in interface java.sql.ResultSet
updateShort
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateInt(java.lang.String columnName, int x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
int
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateInt
in interface java.sql.ResultSet
updateInt
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateLong(java.lang.String columnName, long x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
long
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateLong
in interface java.sql.ResultSet
updateLong
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateFloat(java.lang.String columnName, float x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
float
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateFloat
in interface java.sql.ResultSet
updateFloat
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateDouble(java.lang.String columnName, double x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
double
value.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateDouble
in interface java.sql.ResultSet
updateDouble
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
java.math.BigDecimal
object.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateBigDecimal
in interface java.sql.ResultSet
updateBigDecimal
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateString(java.lang.String columnName, java.lang.String x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
String
object.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateString
in interface java.sql.ResultSet
updateString
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateBytes(java.lang.String columnName, byte[] x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
byte
array.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateBytes
in interface java.sql.ResultSet
updateBytes
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateDate(java.lang.String columnName, java.sql.Date x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Date
object.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateDate
in interface java.sql.ResultSet
updateDate
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, (3) the type
of the designated column is not an SQL DATE
or
TIMESTAMP
, or (4) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateTime(java.lang.String columnName, java.sql.Time x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Time
object.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateTime
in interface java.sql.ResultSet
updateTime
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, (3) the type
of the designated column is not an SQL TIME
or
TIMESTAMP
, or (4) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Timestamp
object.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateTimestamp
in interface java.sql.ResultSet
updateTimestamp
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if the given column index is out of bounds or
the cursor is not on one of this rowset's rows or its
insert row
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, (3) the type
of the designated column is not an SQL DATE
,
TIME
, or TIMESTAMP
, or (4) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
UnsupportedOperationException
if called.
Sets the designated column in either the current row or the insert
row of this JoinRowSetImpl
object with the given
ASCII stream value.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateAsciiStream
in interface java.sql.ResultSet
updateAsciiStream
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column valuelength
- the number of one-byte ASCII characters in the stream
java.lang.UnsupportedOperationException
- if this method is invoked
java.sql.SQLException
public void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
JoinRowSetImpl
object with the given
java.io.InputStream
object.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateBinaryStream
in interface java.sql.ResultSet
updateBinaryStream
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value; must be a java.io.InputStream
containing BINARY
, VARBINARY
, or
LONGVARBINARY
datalength
- the length of the stream in bytes
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, (3) the data
in the stream is not binary, or (4) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateCharacterStream(java.lang.String columnName, java.io.Reader x, int length) throws java.sql.SQLException
JoinRowSetImpl
object with the given
java.io.Reader
object.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateCharacterStream
in interface java.sql.ResultSet
updateCharacterStream
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value; must be a java.io.Reader
containing BINARY
, VARBINARY
,
LONGVARBINARY
, CHAR
, VARCHAR
,
or LONGVARCHAR
datalength
- the length of the stream in characters
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, (3) the data
in the stream is not a binary or character type, or (4) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Object
value. The scale
parameter
indicates the number of digits to the right of the decimal point
and is ignored if the new column value is not a type that will be
mapped to an SQL DECIMAL
or NUMERIC
value.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateObject
in interface java.sql.ResultSet
updateObject
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column valuescale
- the number of digits to the right of the decimal point (for
DECIMAL
and NUMERIC
types only)
java.sql.SQLException
- if the given column index is out of bounds or
the cursor is not on one of this rowset's rows or its
insert row
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateObject(java.lang.String columnName, java.lang.Object x) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Object
value.
This method updates a column value in either the current row or
the insert row of this rowset, but it does not update the
database. If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Both of these methods must be called before the
cursor moves to another row.
updateObject
in interface java.sql.ResultSet
updateObject
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casex
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void insertRow() throws java.sql.SQLException
JoinRowSetImpl
object's insert
row into this rowset immediately following the current row.
If the current row is the
position after the last row or before the first row, the new row will
be inserted at the end of the rowset. This method also notifies
listeners registered with this rowset that the row has changed.
The cursor must be on the insert row when this method is called.
insertRow
in interface java.sql.ResultSet
insertRow
in class CachedRowSetImpl
java.sql.SQLException
- if (1) the cursor is not on the insert row,
(2) one or more of the non-nullable columns in the insert
row has not been given a value, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateRow() throws java.sql.SQLException
JoinRowSetImpl
object as
updated and notifies listeners registered with this rowset that the
row has changed.
This method cannot be called when the cursor is on the insert row, and it should be called before the cursor moves to another row. If it is called after the cursor moves to another row, this method has no effect, and the updates made before the cursor moved will be lost.
updateRow
in interface java.sql.ResultSet
updateRow
in class CachedRowSetImpl
java.sql.SQLException
- if the cursor is on the insert row or this
rowset is ResultSet.CONCUR_READ_ONLY
public void deleteRow() throws java.sql.SQLException
JoinRowSetImpl
object and
notifies listeners registered with this rowset that a row has changed.
This method cannot be called when the cursor is on the insert row.
This method marks the current row as deleted, but it does not delete
the row from the underlying data source. The method
acceptChanges
must be called to delete the row in
the data source.
deleteRow
in interface java.sql.ResultSet
deleteRow
in class CachedRowSetImpl
java.sql.SQLException
- if (1) this method is called when the cursor
is on the insert row, before the first row, or after the
last row or (2) this rowset is
ResultSet.CONCUR_READ_ONLY
public void refreshRow() throws java.sql.SQLException
updateRow
or deleteRow
.
This method should be called only when the cursor is on a row in
this rowset.
refreshRow
in interface java.sql.ResultSet
refreshRow
in class CachedRowSetImpl
java.sql.SQLException
- if the cursor is on the insert row, before the
first row, or after the last rowpublic void cancelRowUpdates() throws java.sql.SQLException
JoinRowSetImpl
object and notifies listeners that
a row has changed. To have an effect, this method
must be called after an updateXXX
method has been
called and before the method updateRow
has been called.
If no updates have been made or the method updateRow
has already been called, this method has no effect.
After updateRow
is called it is the
cancelRowUpdates
has no affect on the newly
inserted values. The method cancelRowInsert
can
be used to remove any rows inserted into the RowSet.
cancelRowUpdates
in interface java.sql.ResultSet
cancelRowUpdates
in class CachedRowSetImpl
java.sql.SQLException
- if the cursor is on the insert row, before the
first row, or after the last rowpublic void moveToInsertRow() throws java.sql.SQLException
JoinRowSetImpl
object
to the insert row. The current row in the rowset is remembered
while the cursor is on the insert row.
The insert row is a special row associated with an updatable
rowset. It is essentially a buffer where a new row may
be constructed by calling the appropriate updateXXX
methods to assign a value to each column in the row. A complete
row must be constructed; that is, every column that is not nullable
must be assigned a value. In order for the new row to become part
of this rowset, the method insertRow
must be called
before the cursor is moved back to the rowset.
Only certain methods may be invoked while the cursor is on the insert
row; many methods throw an exception if they are called while the
cursor is there. In addition to the updateXXX
and insertRow
methods, only the getXXX
methods
may be called when the cursor is on the insert row. A getXXX
method should be called on a column only after an updateXXX
method has been called on that column; otherwise, the value returned is
undetermined.
moveToInsertRow
in interface java.sql.ResultSet
moveToInsertRow
in class CachedRowSetImpl
java.sql.SQLException
- if this JoinRowSetImpl
object is
ResultSet.CONCUR_READ_ONLY
public void moveToCurrentRow() throws java.sql.SQLException
JoinRowSetImpl
object to
the current row. The current row is the row the cursor was on
when the method moveToInsertRow
was called.
Calling this method has no effect unless it is called while the cursor is on the insert row.
moveToCurrentRow
in interface java.sql.ResultSet
moveToCurrentRow
in class CachedRowSetImpl
java.sql.SQLException
- if an error occurspublic java.sql.Statement getStatement() throws java.sql.SQLException
null
.
getStatement
in interface java.sql.ResultSet
getStatement
in class CachedRowSetImpl
null
java.sql.SQLException
- if an error occurspublic java.sql.Ref getRef(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a Ref
object
in the Java programming lanugage.
getRef
in interface java.sql.ResultSet
getRef
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowset
Ref
object representing an SQL REF
value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) the designated column does not store an
SQL REF
valueCachedRowSetImpl.getRef(String)
public java.sql.Blob getBlob(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a Blob
object
in the Java programming lanugage.
getBlob
in interface java.sql.ResultSet
getBlob
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowset
Blob
object representing an SQL BLOB
value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) the designated column does not store an
SQL BLOB
valueCachedRowSetImpl.getBlob(String)
public java.sql.Clob getClob(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as a Clob
object
in the Java programming lanugage.
getClob
in interface java.sql.ResultSet
getClob
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowset
Clob
object representing an SQL CLOB
value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) the designated column does not store an
SQL CLOB
valueCachedRowSetImpl.getClob(String)
public java.sql.Array getArray(int columnIndex) throws java.sql.SQLException
JoinRowSetImpl
object as an Array
object
in the Java programming lanugage.
getArray
in interface java.sql.ResultSet
getArray
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowset
Array
object representing an SQL
ARRAY
value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) the designated column does not store an
SQL ARRAY
valueCachedRowSetImpl.getArray(String)
public java.sql.Ref getRef(java.lang.String columnName) throws java.sql.SQLException
JoinRowSetImpl
object as a Ref
object
in the Java programming lanugage.
getRef
in interface java.sql.ResultSet
getRef
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring case
Ref
object representing an SQL REF
value
java.sql.SQLException
- if (1) the given column name is not the name
of a column in this rowset, (2) the cursor is not on one of
this rowset's rows or its insert row, or (3) the column value
is not an SQL REF
valueCachedRowSetImpl.getRef(int)
public java.sql.Blob getBlob(java.lang.String columnName) throws java.sql.SQLException
JoinRowSetImpl
object as a Blob
object
in the Java programming lanugage.
getBlob
in interface java.sql.ResultSet
getBlob
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring case
Blob
object representing an SQL
BLOB
value
java.sql.SQLException
- if (1) the given column name is not the name of
a column in this rowset, (2) the cursor is not on one of
this rowset's rows or its insert row, or (3) the designated
column does not store an SQL BLOB
valueCachedRowSetImpl.getBlob(int)
public java.sql.Clob getClob(java.lang.String columnName) throws java.sql.SQLException
JoinRowSetImpl
object as a Clob
object
in the Java programming lanugage.
getClob
in interface java.sql.ResultSet
getClob
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring case
Clob
object representing an SQL
CLOB
value
java.sql.SQLException
- if (1) the given column name is not the name of
a column in this rowset, (2) the cursor is not on one of
this rowset's rows or its insert row, or (3) the designated
column does not store an SQL CLOB
valueCachedRowSetImpl.getClob(int)
public java.sql.Array getArray(java.lang.String columnName) throws java.sql.SQLException
JoinRowSetImpl
object as an Array
object
in the Java programming lanugage.
getArray
in interface java.sql.ResultSet
getArray
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring case
Array
object representing an SQL
ARRAY
value
java.sql.SQLException
- if (1) the given column name is not the name of
a column in this rowset, (2) the cursor is not on one of
this rowset's rows or its insert row, or (3) the designated
column does not store an SQL ARRAY
valueCachedRowSetImpl.getArray(int)
public java.sql.Date getDate(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
JoinRowSetImpl
object as a java.sql.Date
object, using the given Calendar
object to construct an
appropriate millisecond value for the date.
getDate
in interface java.sql.ResultSet
getDate
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowsetcal
- the java.util.Calendar
object to use in
constructing the date
NULL
,
the result is null
java.sql.SQLException
- if (1) the given column name is not the name of
a column in this rowset, (2) the cursor is not on one of
this rowset's rows or its insert row, or (3) the designated
column does not store an SQL DATE
or
TIMESTAMP
valuepublic java.sql.Date getDate(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
JoinRowSetImpl
object as a java.sql.Date
object, using the given Calendar
object to construct an
appropriate millisecond value for the date.
getDate
in interface java.sql.ResultSet
getDate
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casecal
- the java.util.Calendar
object to use in
constructing the date
NULL
,
the result is null
java.sql.SQLException
- if (1) the given column name is not the name of
a column in this rowset, (2) the cursor is not on one of
this rowset's rows or its insert row, or (3) the designated
column does not store an SQL DATE
or
TIMESTAMP
valuepublic java.sql.Time getTime(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
JoinRowSetImpl
object as a java.sql.Time
object, using the given Calendar
object to construct an
appropriate millisecond value for the date.
getTime
in interface java.sql.ResultSet
getTime
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowsetcal
- the java.util.Calendar
object to use in
constructing the date
NULL
,
the result is null
java.sql.SQLException
- if (1) the given column name is not the name of
a column in this rowset, (2) the cursor is not on one of
this rowset's rows or its insert row, or (3) the designated
column does not store an SQL TIME
or
TIMESTAMP
valuepublic java.sql.Time getTime(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
JoinRowSetImpl
object as a java.sql.Time
object, using the given Calendar
object to construct an
appropriate millisecond value for the date.
getTime
in interface java.sql.ResultSet
getTime
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casecal
- the java.util.Calendar
object to use in
constructing the date
NULL
,
the result is null
java.sql.SQLException
- if (1) the given column name is not the name of
a column in this rowset, (2) the cursor is not on one of
this rowset's rows or its insert row, or (3) the designated
column does not store an SQL TIME
or
TIMESTAMP
valuepublic java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
JoinRowSetImpl
object as a java.sql.Timestamp
object, using the given Calendar
object to construct an
appropriate millisecond value for the date.
getTimestamp
in interface java.sql.ResultSet
getTimestamp
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in the rowsetcal
- the java.util.Calendar
object to use in
constructing the date
NULL
,
the result is null
java.sql.SQLException
- if (1) the given column name is not the name of
a column in this rowset, (2) the cursor is not on one of
this rowset's rows or its insert row, or (3) the designated
column does not store an SQL TIME
or
TIMESTAMP
valuepublic java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
JoinRowSetImpl
object as a
java.sql.Timestamp
object, using the given
Calendar
object to construct an appropriate
millisecond value for the date.
getTimestamp
in interface java.sql.ResultSet
getTimestamp
in class CachedRowSetImpl
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casecal
- the java.util.Calendar
object to use in
constructing the date
NULL
,
the result is null
java.sql.SQLException
- if (1) the given column name is not the name of
a column in this rowset, (2) the cursor is not on one of
this rowset's rows or its insert row, or (3) the designated
column does not store an SQL DATE
,
TIME
, or TIMESTAMP
valuepublic void setMetaData(javax.sql.RowSetMetaData md) throws java.sql.SQLException
JoinRowSetImpl
object
with the given RowSetMetaData
object.
setMetaData
in interface CachedRowSet
setMetaData
in class CachedRowSetImpl
md
- a RowSetMetaData
object instance containing
metadata about the columsn in the rowset
java.sql.SQLException
- if invalid meta data is supplied to the
rowsetpublic java.sql.ResultSet getOriginal() throws java.sql.SQLException
CachedRowSet
ResultSet
object containing the original value of this
CachedRowSet
object.
The cursor for the ResultSet
object should be positioned before the first row.
In addition, the returned ResultSet
object should have the following
properties:
The original value for a RowSet
object is the value it had before
the last synchronization with the underlying data source. If there have been
no synchronizations, the original value will be the value with which the
RowSet
object was populated. This method is called internally
when an aplication calls the method acceptChanges
and the
SyncProvider
object has been implemented to check for conflicts.
If this is the case, the writer compares the original value with the value
currently in the data source to check for conflicts.
getOriginal
in interface CachedRowSet
getOriginal
in class CachedRowSetImpl
java.sql.SQLException
- if an error occurs produce the
ResultSet
objectpublic java.sql.ResultSet getOriginalRow() throws java.sql.SQLException
getOriginalRow
in interface CachedRowSet
getOriginalRow
in class CachedRowSetImpl
java.sql.SQLException
- if an error occurs produce the
ResultSet
objectCachedRowSetImpl.setOriginalRow()
public void setOriginalRow() throws java.sql.SQLException
setOriginalRow
in interface CachedRowSet
setOriginalRow
in class CachedRowSetImpl
java.sql.SQLException
- if there is no current rowsetOriginalRow()
public int[] getKeyColumns() throws java.sql.SQLException
JoinRowSetImpl
object.
getKeyColumns
in interface CachedRowSet
getKeyColumns
in class CachedRowSetImpl
java.sql.SQLException
- if the rowset is empty or no columns
are designated as primary keyssetKeyColumns(int[])
public void setKeyColumns(int[] cols) throws java.sql.SQLException
JoinRowSetImpl
object's
keyCols
field with the given array of column
numbers, which forms a key for uniquely identifying a row
in this rowset.
setKeyColumns
in interface CachedRowSet
setKeyColumns
in class CachedRowSetImpl
cols
- an array of int
indicating the
columns that form a primary key for this
JoinRowSetImpl
object; every
element in the array must be greater than
0
and less than or equal to the number
of columns in this rowset
java.sql.SQLException
- if any of the numbers in the
given array is not valid for this rowsetgetKeyColumns()
public void updateRef(int columnIndex, java.sql.Ref ref) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Ref
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Either of these methods must be called before the
cursor moves to another row.
updateRef
in interface java.sql.ResultSet
updateRef
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetref
- the java.sql.Ref
object that will be set as
the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateRef(java.lang.String columnName, java.sql.Ref ref) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Ref
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Either of these methods must be called before the
cursor moves to another row.
updateRef
in interface java.sql.ResultSet
updateRef
in class CachedRowSetImpl
columnName
- a String
object giving the name of the column
to be updated; must match one of the column names in this
JoinRowSetImpl
objectref
- the java.sql.Ref
object that will be set as
the new column value
java.sql.SQLException
- if (1) the given column name is not valid,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateClob(int columnIndex, java.sql.Clob c) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Clob
object.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Either of these methods must be called before the
cursor moves to another row.
updateClob
in interface java.sql.ResultSet
updateClob
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetc
- the java.sql.Clob
object that will be set as
the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateClob(java.lang.String columnName, java.sql.Clob c) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Clob
object.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Either of these methods must be called before the
cursor moves to another row.
updateClob
in interface java.sql.ResultSet
updateClob
in class CachedRowSetImpl
columnName
- a String
object giving the name of the column
to be updated; must match one of the column names in this
JoinRowSetImpl
objectc
- the java.sql.Clob
object that will be set as
the new column value
java.sql.SQLException
- if (1) the given column name is not valid,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateBlob(int columnIndex, java.sql.Blob b) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Blob
value.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Either of these methods must be called before the
cursor moves to another row.
updateBlob
in interface java.sql.ResultSet
updateBlob
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetb
- the java.sql.Blob
object that will be set as
the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateBlob(java.lang.String columnName, java.sql.Blob b) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Blob
object.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Either of these methods must be called before the
cursor moves to another row.
updateBlob
in interface java.sql.ResultSet
updateBlob
in class CachedRowSetImpl
columnName
- a String
object giving the name of the column
to be updated; must match one of the column names in this
JoinRowSetImpl
objectb
- the java.sql.Blob
object that will be set as
the new column value
java.sql.SQLException
- if (1) the given column name is not valid,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateArray(int columnIndex, java.sql.Array a) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Array
object.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Either of these methods must be called before the
cursor moves to another row.
updateArray
in interface java.sql.ResultSet
updateArray
in class CachedRowSetImpl
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowseta
- the java.sql.Array
object that will be set as
the new column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateArray(java.lang.String columnName, java.sql.Array a) throws java.sql.SQLException
JoinRowSetImpl
object with the given
Array
object.
This method updates a column value in the current row or the insert
row of this rowset, but it does not update the database.
If the cursor is on a row in the rowset, the
method updateRow()
must be called to update the database.
If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset
and the database. Either of these methods must be called before the
cursor moves to another row.
updateArray
in interface java.sql.ResultSet
updateArray
in class CachedRowSetImpl
columnName
- a String
object giving the name of the column
to be updated; must match one of the column names in this
JoinRowSetImpl
objecta
- the java.sql.Array
object that will be set as
the new column value
java.sql.SQLException
- if (1) the given column name is not valid,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void execute() throws java.sql.SQLException
JoinRowSetImpl
object with data.
This form of the method uses the rowset's user, password, and url or
data source name properties to create a database
connection. If properties that are needed
have not been set, this method will throw an exception.
Another form of this method uses an existing JDBC Connection
object instead of creating a new one; therefore, it ignores the
properties used for establishing a new connection.
The query specified by the command property is executed to create a
ResultSet
object from which to retrieve data.
The current contents of the rowset are discarded, and the
rowset's metadata is also (re)set. If there are outstanding updates,
they are also ignored.
The method execute
closes any database connections that it
creates.
execute
in interface javax.sql.RowSet
execute
in class CachedRowSetImpl
java.sql.SQLException
- if an error occurs or the
necessary properties have not been setpublic void execute(java.sql.Connection conn) throws java.sql.SQLException
JoinRowSetImpl
object with data,
using the given connection to produce the result set from
which data will be read. A second form of this method,
which takes no arguments, uses the values from this rowset's
user, password, and either url or data source properties to
create a new database connection. The form of execute
that is given a connection ignores these properties.
execute
in interface CachedRowSet
execute
in class CachedRowSetImpl
conn
- A standard JDBC Connection
object with valid
properties that the JoinRowSet
implementation
can pass to a synchronization provider to establish a
connection to the datasource
java.sql.SQLException
- if an invalid Connection
is supplied
or an error occurs in establishing the connection to the
data soureConnection
public java.net.URL getURL(int columnIndex) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
getURL
in class CachedRowSetImpl
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) the designated column does not store an
SQL DATALINK
value.CachedRowSetImpl.getURL(String)
public java.net.URL getURL(java.lang.String columnName) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
getURL
in class CachedRowSetImpl
java.sql.SQLException
- if (1) the given column name not the name of a column
in this rowset, or
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) the designated column does not store an
SQL DATALINK
value.CachedRowSetImpl.getURL(int)
public void writeXml(java.sql.ResultSet rs, java.io.Writer writer) throws java.sql.SQLException
WebRowSet
object, populates it with the
data in the given ResultSet
object, and writes it
to the given java.io.Writer
object in XML format.
writeXml
in interface WebRowSet
writeXml
in class WebRowSetImpl
java.sql.SQLException
- if an error occurs writing out the rowset
contents to XMLpublic void writeXml(java.io.Writer writer) throws java.sql.SQLException
JoinRowSet
object to the given
java.io.Writer
object in XML format. In
addition to the rowset's data, its properties and metadata
are also included.
writeXml
in interface WebRowSet
writeXml
in class WebRowSetImpl
java.sql.SQLException
- if an error occurs writing out the rowset
contents to XMLpublic void readXml(java.io.Reader reader) throws java.sql.SQLException
JoinRowSet
object in its XML format.
readXml
in interface WebRowSet
readXml
in class WebRowSetImpl
java.sql.SQLException
- if a database access error occurspublic void readXml(java.io.InputStream iStream) throws java.sql.SQLException, java.io.IOException
WebRowSet
readXml
in interface WebRowSet
readXml
in class WebRowSetImpl
java.sql.SQLException
- if a data source access occurs
java.io.IOException
- if a IO exception occurspublic void writeXml(java.io.OutputStream oStream) throws java.sql.SQLException, java.io.IOException
WebRowSet
for XML proceessing
writeXml
in interface WebRowSet
writeXml
in class WebRowSetImpl
java.sql.SQLException
- if a datasource access occurs
java.io.IOException
- if an IO exception occurspublic void writeXml(java.sql.ResultSet rs, java.io.OutputStream oStream) throws java.sql.SQLException, java.io.IOException
WebRowSet
object, populates it with
the contents of the ResultSet
and creates an output
streams the internal state and contents of the rowset for XML processing.
writeXml
in interface WebRowSet
writeXml
in class WebRowSetImpl
java.sql.SQLException
- if a datasource access occurs
java.io.IOException
- if an IO exception occurspublic int getJoinType() throws java.sql.SQLException
JOIN
type in this JoinRowSetImpl
object
getJoinType
in interface JoinRowSet
java.sql.SQLException
- if an error occurs determining the current join typeJoinRowSet.setJoinType(int)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |