Package Summary Overview Summary |
| ||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES All Classes | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectjavax.sql.rowset.BaseRowSet
com.sun.rowset.CachedRowSetImpl
com.sun.rowset.WebRowSetImpl
com.sun.rowset.JoinRowSetImpl
public class 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 com.sun.rowset.CachedRowSetImpl |
---|
resBundle |
Fields inherited from class javax.sql.rowset.BaseRowSet |
---|
ASCII_STREAM_PARAM, asciiStream, BINARY_STREAM_PARAM, binaryStream, charStream, UNICODE_STREAM_PARAM, unicodeStream |
Fields inherited from interface javax.sql.rowset.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(RowSet[] rowset, int[] columnIdx)
Adds the given RowSet objects to the JOIN relationship and sets the designated columns as the match columns. |
void | addRowSet(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(RowSet rowset, int columnIdx)
Adds the given RowSet object to the JOIN relation and sets the designated column as the match column. |
void | addRowSet(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 | addRowSetListener(RowSetListener listener)
The listener will be notified whenever an event occurs on this JoinRowSet object. |
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. |
CachedRowSet | createCopySchema()
Creates a RowSet object that is a copy of this JoinRowSetImpl object's table structure and the constraints only. |
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(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. |
Array | getArray(int columnIndex)
Retrieves the value of the designated column in this JoinRowSetImpl object as an Array object in the Java programming lanugage. |
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. |
Blob | getBlob(int columnIndex)
Retrieves the value of the designated column in this JoinRowSetImpl object as a Blob object in the Java programming lanugage. |
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. |
Clob | getClob(int columnIndex)
Retrieves the value of the designated column in this JoinRowSetImpl object as a Clob object in the Java programming lanugage. |
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. |
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. |
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. |
Date | getDate(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a java.sql.Date object. |
Date | getDate(java.lang.String columnName, java.util.Calendar cal)
Retrieves the value of the designated column in the current row of this 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. |
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<java.lang.String,java.lang.Class<?>> 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<java.lang.String,java.lang.Class<?>> 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. |
ResultSet | getOriginal()
Returns a result set containing the original value of the rowset. |
ResultSet | getOriginalRow()
Returns a result set containing the original value of the rowset. |
Ref | getRef(int columnIndex)
Retrieves the value of the designated column in this JoinRowSetImpl object as a Ref object in the Java programming lanugage. |
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. |
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. |
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. |
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. |
Time | getTime(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a java.sql.Time object. |
Time | getTime(java.lang.String columnName, java.util.Calendar cal)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a java.sql.Time object, using the given Calendar object to construct an appropriate millisecond value for the date. |
Timestamp | getTimestamp(int columnIndex)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a java.sql.Timestamp object. |
Timestamp | getTimestamp(int columnIndex, java.util.Calendar cal)
Retrieves the value of the designated column in the current row of this JoinRowSetImpl object as a java.sql.Timestamp object, using the given Calendar object to construct an appropriate millisecond value for the date. |
Timestamp | getTimestamp(java.lang.String columnName)
Retrieves the value stored in the designated column of the current row as a java.sql.Timestamp object. |
Timestamp | getTimestamp(java.lang.String columnName, java.util.Calendar cal)
Retrieves the value of the designated column in the current row of this 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 |
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. |
void | removeRowSetListener(RowSetListener listener)
Removes the designated object from this JoinRowSet object's list of listeners. |
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(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. |
java.util.Collection<?> | toCollection()
Converts this JoinRowSetImpl object to a collection of tables. |
java.util.Collection<?> | toCollection(int column)
Returns the specified column of this JoinRowSetImpl object as a Collection object. |
java.util.Collection<?> | toCollection(java.lang.String column)
Returns the specified column of this JoinRowSetImpl object as a Collection object. |
void | updateArray(int columnIndex, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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(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(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, createShared, getPageSize, getRowSetWarnings, getShowDeleted, getSyncProvider, getTableName, nextPage, populate, populate, previousPage, release, restoreOriginal, rollback, rollback, rowSetPopulated, setPageSize, setShowDeleted, setSyncProvider, setTableName, undoDelete, undoInsert, undoUpdate |
Methods inherited from interface java.sql.Wrapper |
---|
isWrapperFor, unwrap |
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 SQLException
JoinRowSetImpl
class. Configures various internal data structures to provide mechanisms required for JoinRowSet
interface implementation.
SQLException
- if an error occurs in instantiating an instance of JoinRowSetImpl
Method Detail |
---|
public void addRowSet(Joinable rowset) throws 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 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(RowSet rowset, int columnIdx) throws 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
interface columnIdx
- an int
giving the index of the column to be set as the match column 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(RowSet rowset, java.lang.String columnName) throws 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
relation columnName
- a String
object giving the name of the column to be set as the match column; must implement the Joinable
interface 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(RowSet[] rowset, int[] columnIdx) throws 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
interface columnIdx
- an array of int
values designating the columns to be set as the match columns for the RowSet
objects in rowset
SQLException
- if the number of RowSet
objects in rowset is not equal to the number of int
values in columnIdx
public void addRowSet(RowSet[] rowset, java.lang.String[] columnName) throws 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
interface columnName
- an array of String
objects designating the columns to be set as the match columns for the RowSet
objects in rowset
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 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 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 SQLException
- if an error occours generating a collection of the originating RowSets contained within the JOIN. public java.lang.String[] getRowSetNames() throws SQLException
JoinRowSet
object instance.
getRowSetNames
in interface JoinRowSet
SQLException
- if an error occours retrieving the RowSet names CachedRowSet.setTableName(java.lang.String)
public CachedRowSettoCachedRowSet() throws 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 SQLException
- if an error occurs assembling the CachedRowSet
object RowSet
, 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
otherwise public 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 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
SQLException
- if an unsupported JOIN
type is set JoinRowSet.getJoinType()
public java.lang.String getWhereClause() throws 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 SQLException
- if an error occurs in generating a representation of the WHERE
clause. public boolean next() throws SQLException
true
if the new cursor position is a valid row. The cursor for a new ResultSet
object is initially positioned before the first row. The first call to the method next
moves the cursor to the first row, making it the current row; the second call makes the second row the current row, and so on.If an input stream from the previous row is open, it is implicitly closed. The ResultSet
object's warning chain is cleared when a new row is read.
next
in interface ResultSet
next
in class CachedRowSetImpl
true
if the new current row is valid; false
if there are no more rows SQLException
- if an error occurs or the cursor is not positioned in the rowset, before the first row, or after the last row public void close() throws SQLException
release
is called. This method sends a RowSetChangedEvent
object to all registered listeners prior to returning.
close
in interface ResultSet
close
in class CachedRowSetImpl
SQLException
- if an error occurs public boolean wasNull() throws SQLException
NULL
. Note that you must first call the method getXXX
on a column to try to read its value and then call the method wasNull
to determine whether the value was SQL NULL
.
wasNull
in interface ResultSet
wasNull
in class CachedRowSetImpl
true
if the value in the last column read was SQL NULL
; false
otherwise SQLException
- if an error occurs public java.lang.String getString(int columnIndex) throws SQLException
JoinRowSetImpl
object as a String
object.
getString
in interface 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
SQLException
- if the given column index is out of bounds or the cursor is not on a valid row public boolean getBoolean(int columnIndex) throws SQLException
JoinRowSetImpl
object as a boolean
value.
getBoolean
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails CachedRowSetImpl.getBoolean(String)
public byte getByte(int columnIndex) throws SQLException
JoinRowSetImpl
object as a byte
value.
getByte
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails CachedRowSetImpl.getByte(String)
public short getShort(int columnIndex) throws SQLException
JoinRowSetImpl
object as a short
value.
getShort
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails CachedRowSetImpl.getShort(String)
public int getInt(int columnIndex) throws SQLException
JoinRowSetImpl
object as a short
value.
getInt
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails public long getLong(int columnIndex) throws SQLException
JoinRowSetImpl
object as a long
value.
getLong
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails CachedRowSetImpl.getLong(String)
public float getFloat(int columnIndex) throws SQLException
JoinRowSetImpl
object as a float
value.
getFloat
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails CachedRowSetImpl.getFloat(String)
public double getDouble(int columnIndex) throws SQLException
JoinRowSetImpl
object as a double
value.
getDouble
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails CachedRowSetImpl.getDouble(String)
public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws 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 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 scale
- the number of digits to the right of the decimal point in the value returned NULL
, the result is null
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails public byte[] getBytes(int columnIndex) throws SQLException
JoinRowSetImpl
object as a byte array
value.
getBytes
in interface 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
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 binary CachedRowSetImpl.getBytes(String)
public DategetDate(int columnIndex) throws SQLException
JoinRowSetImpl
object as a java.sql.Date
object.
getDate
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails public TimegetTime(int columnIndex) throws SQLException
JoinRowSetImpl
object as a java.sql.Time
object.
getTime
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails public TimestampgetTimestamp(int columnIndex) throws SQLException
JoinRowSetImpl
object as a java.sql.Timestamp
object.
getTimestamp
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails public java.io.InputStream getAsciiStream(int columnIndex) throws SQLException
JoinRowSetImpl
object as a java.sql.Timestamp
object.
getAsciiStream
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails CachedRowSetImpl.getAsciiStream(String)
public java.io.InputStream getUnicodeStream(int columnIndex) throws SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. . Also, a stream may return 0 for available() whether there is data available or not.
getUnicodeStream
in interface ResultSet
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 SQLException
- if an error occurs public java.io.InputStream getBinaryStream(int columnIndex) throws SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not.
getBinaryStream
in interface 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 SQLException
- if an error occurs CachedRowSetImpl.getBinaryStream(String)
public java.lang.String getString(java.lang.String columnName) throws SQLException
String
object.
getString
in interface 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
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row public boolean getBoolean(java.lang.String columnName) throws SQLException
boolean
value.
getBoolean
in interface 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
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row CachedRowSetImpl.getBoolean(int)
public byte getByte(java.lang.String columnName) throws SQLException
byte
value.
getByte
in interface 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
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row public short getShort(java.lang.String columnName) throws SQLException
short
value.
getShort
in interface 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
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row CachedRowSetImpl.getShort(int)
public int getInt(java.lang.String columnName) throws SQLException
int
value.
getInt
in interface 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
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row public long getLong(java.lang.String columnName) throws SQLException
long
value.
getLong
in interface 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
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row CachedRowSetImpl.getLong(int)
public float getFloat(java.lang.String columnName) throws SQLException
float
value.
getFloat
in interface 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
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row CachedRowSetImpl.getFloat(String)
public double getDouble(java.lang.String columnName) throws SQLException
double
value.
getDouble
in interface 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
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row CachedRowSetImpl.getDouble(int)
public java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws SQLException
getBigDecimal(String columnName)
instead
java.math.BigDecimal
object.
getBigDecimal
in interface ResultSet
getBigDecimal
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of a column in this JoinRowSetImpl
object scale
- the number of digits to the right of the decimal point NULL
, the result is null
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row public byte[] getBytes(java.lang.String columnName) throws SQLException
getBytes
in interface 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
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row CachedRowSetImpl.getBytes(int)
public DategetDate(java.lang.String columnName) throws SQLException
java.sql.Date
object.
getDate
in interface 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
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row public TimegetTime(java.lang.String columnName) throws SQLException
java.sql.Time
object.
getTime
in interface 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
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row public TimestampgetTimestamp(java.lang.String columnName) throws SQLException
java.sql.Timestamp
object.
getTimestamp
in interface ResultSet
getTimestamp
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of a column in this JoinRowSetImpl
object NULL
, the result is null
SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row public java.io.InputStream getAsciiStream(java.lang.String columnName) throws SQLException
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 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 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 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 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
. SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row public java.io.InputStream getBinaryStream(java.lang.String columnName) throws SQLException
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 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
. SQLException
- if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row CachedRowSetImpl.getBinaryStream(int)
public SQLWarninggetWarnings()
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 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 ResultSet
clearWarnings
in class CachedRowSetImpl
java.lang.UnsupportedOperationException
- if this method is called public java.lang.String getCursorName() throws 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 ResultSet
getCursorName
in class CachedRowSetImpl
JoinRowSetImpl
object's cursor SQLException
- if an error occurs public ResultSetMetaDatagetMetaData() throws 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 ResultSet
getMetaData
in class CachedRowSetImpl
ResultSetMetaData
object that describes this JoinRowSetImpl
object's columns SQLException
- if an error occurs RowSetMetaData
public java.lang.Object getObject(int columnIndex) throws 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 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or there is a problem getting the Class
object for a custom mapping CachedRowSetImpl.getObject(String)
public java.lang.Object getObject(int columnIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws 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 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 map
- 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
SQLException
- if (1) the given column name does not match one of this rowset's column names, (2) the cursor is not on a valid row, or (3) there is a problem getting the Class
object for a custom mapping public java.lang.Object getObject(java.lang.String columnName) throws 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 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
SQLException
- if (1) the given column name does not match one of this rowset's column names, (2) the cursor is not on a valid row, or (3) there is a problem getting the Class
object for a custom mapping CachedRowSetImpl.getObject(int)
public java.lang.Object getObject(java.lang.String columnName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws 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 ResultSet
getObject
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case map
- a java.util.Map
object showing the mapping from SQL type names to classes in the Java programming language Object
representing the SQL value SQLException
- if the given column index is out of bounds or the cursor is not on one of this rowset's rows or its insert row public java.io.Reader getCharacterStream(int columnIndex) throws SQLException
java.io.Reader
object.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX
method implicitly closes the stream.
getCharacterStream
in interface ResultSet
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
. SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or there is a type mismatch CachedRowSetImpl.getCharacterStream(String)
public java.io.Reader getCharacterStream(java.lang.String columnName) throws SQLException
java.io.Reader
object.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX
method implicitly closes the stream.
getCharacterStream
in interface ResultSet
getCharacterStream
in class CachedRowSetImpl
columnName
- a String
object giving the SQL name of a column in this JoinRowSetImpl
object NULL
, the result is null
. SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or there is a type mismatch public java.math.BigDecimal getBigDecimal(int columnIndex) throws SQLException
JoinRowSetImpl
object as a java.math.BigDecimal
object.
getBigDecimal
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails CachedRowSetImpl.getBigDecimal(String)
public java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws SQLException
JoinRowSetImpl
object as a java.math.BigDecimal
object.
getBigDecimal
in interface 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
SQLException
- if the given column index is out of bounds, the cursor is not on a valid row, or this method fails CachedRowSetImpl.getBigDecimal(int)
public int size()
JoinRowSetImpl
object.
size
in interface CachedRowSet
size
in class CachedRowSetImpl
public boolean isBeforeFirst() throws SQLException
JoinRowSetImpl
object.
isBeforeFirst
in interface ResultSet
isBeforeFirst
in class CachedRowSetImpl
true
if the cursor is before the first row; false
otherwise or if the rowset contains no rows SQLException
- if an error occurs public boolean isAfterLast() throws SQLException
JoinRowSetImpl
object.
isAfterLast
in interface ResultSet
isAfterLast
in class CachedRowSetImpl
true
if the cursor is after the last row; false
otherwise or if the rowset contains no rows SQLException
- if an error occurs public boolean isFirst() throws SQLException
JoinRowSetImpl
object.
isFirst
in interface ResultSet
isFirst
in class CachedRowSetImpl
true
if the cursor is on the first row; false
otherwise or if the rowset contains no rows SQLException
- if an error occurs public boolean isLast() throws SQLException
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 ResultSet
isLast
in class CachedRowSetImpl
true
if the cursor is on the last row; false
otherwise or if this rowset contains no rows SQLException
- if an error occurs public void beforeFirst() throws SQLException
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 ResultSet
beforeFirst
in class CachedRowSetImpl
SQLException
- if an error occurs or the type of this rowset is ResultSet.TYPE_FORWARD_ONLY
public void afterLast() throws 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 ResultSet
afterLast
in class CachedRowSetImpl
SQLException
- if an error occurs public boolean first() throws 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 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 SQLException
- if the type of this rowset is ResultSet.TYPE_FORWARD_ONLY
public boolean last() throws 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 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 SQLException
- if the type of this rowset is ResultSet.TYPE_FORWARD_ONLY
public int getRow() throws SQLException
JoinRowSetImpl
object. The first row is number 1, the second number 2, and so on.
getRow
in interface ResultSet
getRow
in class CachedRowSetImpl
0
if there is no current row SQLException
- if an error occurs public boolean absolute(int row) throws 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 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 SQLException
- if the given cursor position is 0
or the type of this rowset is ResultSet.TYPE_FORWARD_ONLY
public boolean relative(int rows) throws SQLException
If the number is positive, the cursor moves the specified number of rows toward the end of the rowset, starting at the current row. For example, the following command, in which crs
is a 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 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 SQLException
- if there are no rows in this rowset, the cursor is positioned either before the first row or after the last row, or the rowset is type ResultSet.TYPE_FORWARD_ONLY
public boolean previous() throws SQLException
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 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 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 SQLException
findColumn
in interface 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 SQLException
- if the given column name does not match one of the column names for this JoinRowSet
object public boolean rowUpdated() throws 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 ResultSet
rowUpdated
in class CachedRowSetImpl
true
if the row has been visibly updated by the owner or another and updates are detected; false
otherwise SQLException
- if the cursor is on the insert row or not on a valid row DatabaseMetaData.updatesAreDetected(int)
public boolean columnUpdated(int indexColumn) throws 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 SQLException
- if the cursor is on the insert row or not on a valid row DatabaseMetaData.updatesAreDetected(int)
public boolean rowInserted() throws SQLException
rowInserted
in interface ResultSet
rowInserted
in class CachedRowSetImpl
true
if a row has been inserted and inserts are detected; false
otherwise SQLException
- if the cursor is on the insert row or not not on a valid row DatabaseMetaData.insertsAreDetected(int)
public boolean rowDeleted() throws SQLException
false
if this rowset cannot detect deletions.
rowDeleted
in interface ResultSet
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 SQLException
- if the cursor is on a valid row in this rowset DatabaseMetaData.deletesAreDetected(int)
public void updateNull(int columnIndex) throws 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 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 SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateBoolean(int columnIndex, boolean x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateByte(int columnIndex, byte x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateShort(int columnIndex, short x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateInt(int columnIndex, int x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateLong(int columnIndex, long x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateFloat(int columnIndex, float x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateDouble(int columnIndex, double x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateString(int columnIndex, java.lang.String x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateBytes(int columnIndex, byte[] x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateDate(int columnIndex, Date x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the type of the designated column is not an SQL DATE
or TIMESTAMP
, or (4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateTime(int columnIndex, Time x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the type of the designated column is not an SQL TIME
or TIMESTAMP
, or (4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the type of the designated column is not an SQL DATE
, TIME
, or TIMESTAMP
, or (4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws SQLException
CachedRowSetImpl
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 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 rowset x
- the new column value length
- the number of one-byte ASCII characters in the stream SQLException
- if this method is invoked public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws SQLException
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 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 rowset x
- the new column value; must be a java.io.InputStream
containing BINARY
, VARBINARY
, or LONGVARBINARY
data length
- the length of the stream in bytes SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the data in the stream is not binary, or (4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws SQLException
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 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 rowset x
- the new column value; must be a java.io.Reader
containing BINARY
, VARBINARY
, LONGVARBINARY
, CHAR
, VARCHAR
, or LONGVARCHAR
data length
- the length of the stream in characters SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the data in the stream is not a binary or character type, or (4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateObject(int columnIndex, java.lang.Object x, int scale) throws SQLException
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 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 rowset x
- the new column value scale
- the number of digits to the right of the decimal point (for DECIMAL
and NUMERIC
types only) SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateObject(int columnIndex, java.lang.Object x) throws SQLException
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 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 rowset x
- the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateNull(java.lang.String columnName) throws SQLException
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 ResultSet
updateNull
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateBoolean(java.lang.String columnName, boolean x) throws SQLException
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 ResultSet
updateBoolean
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateByte(java.lang.String columnName, byte x) throws SQLException
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 ResultSet
updateByte
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateShort(java.lang.String columnName, short x) throws SQLException
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 ResultSet
updateShort
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateInt(java.lang.String columnName, int x) throws SQLException
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 ResultSet
updateInt
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateLong(java.lang.String columnName, long x) throws SQLException
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 ResultSet
updateLong
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateFloat(java.lang.String columnName, float x) throws SQLException
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 ResultSet
updateFloat
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateDouble(java.lang.String columnName, double x) throws SQLException
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 ResultSet
updateDouble
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws SQLException
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 ResultSet
updateBigDecimal
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateString(java.lang.String columnName, java.lang.String x) throws SQLException
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 ResultSet
updateString
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateBytes(java.lang.String columnName, byte[] x) throws SQLException
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 ResultSet
updateBytes
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateDate(java.lang.String columnName, Date x) throws SQLException
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 ResultSet
updateDate
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the type of the designated column is not an SQL DATE
or TIMESTAMP
, or (4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateTime(java.lang.String columnName, Time x) throws SQLException
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 ResultSet
updateTime
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the type of the designated column is not an SQL TIME
or TIMESTAMP
, or (4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateTimestamp(java.lang.String columnName, Timestamp x) throws SQLException
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 ResultSet
updateTimestamp
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if the given column index is out of bounds or the cursor is not on one of this rowset's rows or its insert row SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the type of the designated column is not an SQL DATE
, TIME
, or TIMESTAMP
, or (4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws SQLException
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 ResultSet
updateAsciiStream
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value length
- the number of one-byte ASCII characters in the stream java.lang.UnsupportedOperationException
- if this method is invoked SQLException
- if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws SQLException
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 ResultSet
updateBinaryStream
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value; must be a java.io.InputStream
containing BINARY
, VARBINARY
, or LONGVARBINARY
data length
- the length of the stream in bytes SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the data in the stream is not binary, or (4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateCharacterStream(java.lang.String columnName, java.io.Reader x, int length) throws 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 ResultSet
updateCharacterStream
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value; must be a java.io.Reader
containing BINARY
, VARBINARY
, LONGVARBINARY
, CHAR
, VARCHAR
, or LONGVARCHAR
data length
- the length of the stream in characters SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, (3) the data in the stream is not a binary or character type, or (4) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws SQLException
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 ResultSet
updateObject
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value scale
- the number of digits to the right of the decimal point (for DECIMAL
and NUMERIC
types only) SQLException
- if the given column index is out of bounds or the cursor is not on one of this rowset's rows or its insert row SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateObject(java.lang.String columnName, java.lang.Object x) throws 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 ResultSet
updateObject
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case x
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void insertRow() throws SQLException
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 ResultSet
insertRow
in class CachedRowSetImpl
SQLException
- if (1) the cursor is not on the insert row, (2) one or more of the non-nullable columns in the insert row has not been given a value, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateRow() throws SQLException
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 ResultSet
updateRow
in class CachedRowSetImpl
SQLException
- if the cursor is on the insert row or this rowset is ResultSet.CONCUR_READ_ONLY
public void deleteRow() throws 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 ResultSet
deleteRow
in class CachedRowSetImpl
SQLException
- if (1) this method is called when the cursor is on the insert row, before the first row, or after the last row or (2) this rowset is ResultSet.CONCUR_READ_ONLY
public void refreshRow() throws SQLException
updateRow
or deleteRow
. This method should be called only when the cursor is on a row in this rowset.
refreshRow
in interface ResultSet
refreshRow
in class CachedRowSetImpl
SQLException
- if the cursor is on the insert row, before the first row, or after the last row public void cancelRowUpdates() throws 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 ResultSet
cancelRowUpdates
in class CachedRowSetImpl
SQLException
- if the cursor is on the insert row, before the first row, or after the last row public void moveToInsertRow() throws 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 ResultSet
moveToInsertRow
in class CachedRowSetImpl
SQLException
- if this JoinRowSetImpl
object is ResultSet.CONCUR_READ_ONLY
public void moveToCurrentRow() throws 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 ResultSet
moveToCurrentRow
in class CachedRowSetImpl
SQLException
- if an error occurs public StatementgetStatement() throws SQLException
null
.
getStatement
in interface ResultSet
getStatement
in class CachedRowSetImpl
null
SQLException
- if an error occurs public RefgetRef(int columnIndex) throws SQLException
JoinRowSetImpl
object as a Ref
object in the Java programming lanugage.
getRef
in interface 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 SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL REF
value CachedRowSetImpl.getRef(String)
public BlobgetBlob(int columnIndex) throws SQLException
JoinRowSetImpl
object as a Blob
object in the Java programming lanugage.
getBlob
in interface 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 SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL BLOB
value CachedRowSetImpl.getBlob(String)
public ClobgetClob(int columnIndex) throws SQLException
JoinRowSetImpl
object as a Clob
object in the Java programming lanugage.
getClob
in interface 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 SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL CLOB
value CachedRowSetImpl.getClob(String)
public ArraygetArray(int columnIndex) throws SQLException
JoinRowSetImpl
object as an Array
object in the Java programming lanugage.
getArray
in interface 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 SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL ARRAY
value CachedRowSetImpl.getArray(String)
public RefgetRef(java.lang.String columnName) throws SQLException
JoinRowSetImpl
object as a Ref
object in the Java programming lanugage.
getRef
in interface 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 SQLException
- if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the column value is not an SQL REF
value CachedRowSetImpl.getRef(int)
public BlobgetBlob(java.lang.String columnName) throws SQLException
JoinRowSetImpl
object as a Blob
object in the Java programming lanugage.
getBlob
in interface 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 SQLException
- if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL BLOB
value CachedRowSetImpl.getBlob(int)
public ClobgetClob(java.lang.String columnName) throws SQLException
JoinRowSetImpl
object as a Clob
object in the Java programming lanugage.
getClob
in interface 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 SQLException
- if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL CLOB
value CachedRowSetImpl.getClob(int)
public ArraygetArray(java.lang.String columnName) throws SQLException
JoinRowSetImpl
object as an Array
object in the Java programming lanugage.
getArray
in interface 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 SQLException
- if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL ARRAY
value CachedRowSetImpl.getArray(int)
public DategetDate(int columnIndex, java.util.Calendar cal) throws 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 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 cal
- the java.util.Calendar
object to use in constructing the date NULL
, the result is null
SQLException
- if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL DATE
or TIMESTAMP
value public DategetDate(java.lang.String columnName, java.util.Calendar cal) throws SQLException
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 ResultSet
getDate
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case cal
- the java.util.Calendar
object to use in constructing the date NULL
, the result is null
SQLException
- if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL DATE
or TIMESTAMP
value public TimegetTime(int columnIndex, java.util.Calendar cal) throws SQLException
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 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 cal
- the java.util.Calendar
object to use in constructing the date NULL
, the result is null
SQLException
- if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TIME
or TIMESTAMP
value public TimegetTime(java.lang.String columnName, java.util.Calendar cal) throws SQLException
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 ResultSet
getTime
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case cal
- the java.util.Calendar
object to use in constructing the date NULL
, the result is null
SQLException
- if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TIME
or TIMESTAMP
value public TimestampgetTimestamp(int columnIndex, java.util.Calendar cal) throws SQLException
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 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 cal
- the java.util.Calendar
object to use in constructing the date NULL
, the result is null
SQLException
- if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL TIME
or TIMESTAMP
value public TimestampgetTimestamp(java.lang.String columnName, java.util.Calendar cal) throws SQLException
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 ResultSet
getTimestamp
in class CachedRowSetImpl
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case cal
- the java.util.Calendar
object to use in constructing the date NULL
, the result is null
SQLException
- if (1) the given column name is not the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL DATE
, TIME
, or TIMESTAMP
value public void setMetaData(RowSetMetaData md) throws SQLException
JoinRowSetImpl
object with the given RowSetMetaData
object.
setMetaData
in interface CachedRowSet
setMetaData
in interface RowSetInternal
setMetaData
in class CachedRowSetImpl
md
- a RowSetMetaData
object instance containing metadata about the columsn in the rowset SQLException
- if invalid meta data is supplied to the rowset public ResultSetgetOriginal() throws SQLException
CachedRowSetImpl
CachedRowSetImpl
after the last population or synchronization (whichever occured most recently) with the data source. The cursor is positioned before the first row in the result set. Only rows contained in the result set returned by getOriginal()
are said to have an original value.
getOriginal
in interface CachedRowSet
getOriginal
in interface RowSetInternal
getOriginal
in class CachedRowSetImpl
SQLException
- if an error occurs produce the ResultSet
object public ResultSetgetOriginalRow() throws SQLException
getOriginalRow
in interface CachedRowSet
getOriginalRow
in interface RowSetInternal
getOriginalRow
in class CachedRowSetImpl
SQLException
- if an error occurs produce the ResultSet
object CachedRowSetImpl.setOriginalRow()
public void setOriginalRow() throws SQLException
setOriginalRow
in interface CachedRowSet
setOriginalRow
in class CachedRowSetImpl
SQLException
- if there is no current row setOriginalRow()
public int[] getKeyColumns() throws SQLException
JoinRowSetImpl
object.
getKeyColumns
in interface CachedRowSet
getKeyColumns
in class CachedRowSetImpl
SQLException
- if the rowset is empty or no columns are designated as primary keys setKeyColumns(int[])
public void setKeyColumns(int[] cols) throws 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 SQLException
- if any of the numbers in the given array is not valid for this rowset getKeyColumns()
public void updateRef(int columnIndex, Ref ref) throws SQLException
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 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 rowset ref
- the java.sql.Ref
object that will be set as the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateRef(java.lang.String columnName, Ref ref) throws 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 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
object ref
- the java.sql.Ref
object that will be set as the new column value 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, Clob c) throws 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 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 rowset c
- the java.sql.Clob
object that will be set as the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateClob(java.lang.String columnName, Clob c) throws 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 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
object c
- the java.sql.Clob
object that will be set as the new column value 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, Blob b) throws 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 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 rowset b
- the java.sql.Blob
object that will be set as the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateBlob(java.lang.String columnName, Blob b) throws 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 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
object b
- the java.sql.Blob
object that will be set as the new column value 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, Array a) throws 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 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 rowset a
- the java.sql.Array
object that will be set as the new column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateArray(java.lang.String columnName, Array a) throws 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 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
object a
- the java.sql.Array
object that will be set as the new column value 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 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 RowSet
execute
in class CachedRowSetImpl
SQLException
- if an error occurs or the necessary properties have not been set public void execute(Connection conn) throws 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 SQLException
- if an invalid Connection
is supplied or an error occurs in establishing the connection to the data soure Connection
public java.net.URL getURL(int columnIndex) throws SQLException
getURL
in interface ResultSet
getURL
in class CachedRowSetImpl
columnIndex
- the index of the column 1 is the first, 2 is the second,... SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL DATALINK
value. CachedRowSetImpl.getURL(String)
public java.net.URL getURL(java.lang.String columnName) throws SQLException
getURL
in interface ResultSet
getURL
in class CachedRowSetImpl
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column SQLException
- if (1) the given column name not the name of a column in this rowset, or (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL DATALINK
value. CachedRowSetImpl.getURL(int)
public void writeXml(ResultSet rs, java.io.Writer writer) throws 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
rs
- the ResultSet
object with which to populate this WebRowSet
object writer
- the java.io.Writer
object to write to. SQLException
- if an error occurs writing out the rowset contents to XML public void writeXml(java.io.Writer writer) throws 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
writer
- the java.io.Writer
stream to write to SQLException
- if an error occurs writing out the rowset contents to XML public void readXml(java.io.Reader reader) throws SQLException
JoinRowSet
object in its XML format.
readXml
in interface WebRowSet
readXml
in class WebRowSetImpl
reader
- the java.io.Reader
stream from which this WebRowSet
object will be populated SQLException
- if a database access error occurs public void readXml(java.io.InputStream iStream) throws SQLException, java.io.IOException
WebRowSet
readXml
in interface WebRowSet
readXml
in class WebRowSetImpl
iStream
- the java.io.InputStream
from which this WebRowSet
object will be populated SQLException
- if a data source access occurs java.io.IOException
- if a IO exception occurs public void writeXml(java.io.OutputStream oStream) throws SQLException, java.io.IOException
WebRowSet
for XML proceessing
writeXml
in interface WebRowSet
writeXml
in class WebRowSetImpl
oStream
- the java.io.OutputStream
stream to write to SQLException
- if a datasource access occurs java.io.IOException
- if an IO exception occurs public void writeXml(ResultSet rs, java.io.OutputStream oStream) throws 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
rs
- the ResultSet
object with which to populate this WebRowSet
object oStream
- the java.io.OutputStream
to write to SQLException
- if a datasource access occurs java.io.IOException
- if an IO exception occurs public int getJoinType() throws SQLException
JOIN
type in this JoinRowSetImpl object
getJoinType
in interface JoinRowSet
SQLException
- if an error occurs determining the current join type JoinRowSet.setJoinType(int)
public void addRowSetListener(RowSetListener listener)
JoinRowSet
object. A listener might, for example, be a table or graph that needs to be updated in order to accurately reflect the current state of the RowSet
object.
Note: if the RowSetListener
object is null
, this method silently discards the null
value and does not add a null reference to the set of listeners.
Note: if the listener is already set, and the new RowSetListerner
instance is added to the set of listeners already registered to receive event notifications from this RowSet
.
addRowSetListener
in interface RowSet
addRowSetListener
in class BaseRowSet
listener
- an object that has implemented the javax.sql.RowSetListener
interface and wants to be notified of any events that occur on this JoinRowSet
object; May be null. removeRowSetListener(javax.sql.RowSetListener)
public void removeRowSetListener(RowSetListener listener)
JoinRowSet
object's list of listeners. If the given argument is not a registered listener, this method does nothing. Note: if the RowSetListener
object is null
, this method silently discards the null
value.
removeRowSetListener
in interface RowSet
removeRowSetListener
in class BaseRowSet
listener
- a RowSetListener
object that is on the list of listeners for this JoinRowSet
object addRowSetListener(javax.sql.RowSetListener)
public java.util.Collection<?> toCollection() throws SQLException
JoinRowSetImpl
object to a collection of tables. The sample implementation utilitizes the TreeMap
collection type. This class guarantees that the map will be in ascending key order, sorted according to the natural order for the key's class.
toCollection
in interface CachedRowSet
toCollection
in class CachedRowSetImpl
Collection
object consisting of tables, each of which is a copy of a row in this JoinRowSetImpl
object SQLException
- if an error occurs in generating the collection toCollection(int)
, toCollection(String)
, TreeMap
public java.util.Collection<?> toCollection(int column) throws SQLException
JoinRowSetImpl
object as a Collection
object. This method makes a copy of the column's data and utilitizes the Vector
to establish the collection. The Vector
class implements a growable array objects allowing the individual components to be accessed using an an integer index similar to that of an array.
toCollection
in interface CachedRowSet
toCollection
in class CachedRowSetImpl
column
- an int
indicating the column whose values are to be represented in a Collection
object Collection
object that contains the value(s) stored in the specified column of this JoinRowSetImpl
object SQLException
- if an error occurs generated the collection; or an invalid column is provided. toCollection()
, toCollection(String)
, Vector
public java.util.Collection<?> toCollection(java.lang.String column) throws SQLException
JoinRowSetImpl
object as a Collection
object. This method makes a copy of the column's data and utilitizes the Vector
to establish the collection. The Vector
class implements a growable array objects allowing the individual components to be accessed using an an integer index similar to that of an array.
toCollection
in interface CachedRowSet
toCollection
in class CachedRowSetImpl
column
- a String
object giving the name of the column whose values are to be represented in a collection Collection
object that contains the value(s) stored in the specified column of this JoinRowSetImpl
object SQLException
- if an error occurs generated the collection; or an invalid column is provided. toCollection()
, toCollection(int)
, Vector
public CachedRowSetcreateCopySchema() throws SQLException
RowSet
object that is a copy of this JoinRowSetImpl
object's table structure and the constraints only. There will be no data in the object being returned. Updates made on a copy are not visible to the original rowset. This helps in getting the underlying XML schema which can be used as the basis for populating a WebRowSet
.
createCopySchema
in interface CachedRowSet
createCopySchema
in class CachedRowSetImpl
CachedRowSet
object that is a copy of this JoinRowSetImpl
object's schema and retains all the constraints on the original rowset but contains no data SQLException
- if an error occurs in generating the copy of the CachedRowSet
object CachedRowSetImpl.createShared()
, CachedRowSetImpl.createCopy()
, CachedRowSetImpl.createCopyNoConstraints()
, RowSetEvent
, RowSetListener
| ||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES All Classes | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |