JoinRowSetImpl

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.sun.rowset
Class JoinRowSetImpl

java.lang.Object
  javax.sql.rowset.BaseRowSet
      com.sun.rowset.CachedRowSetImpl
          com.sun.rowset.WebRowSetImpl
              com.sun.rowset.JoinRowSetImpl

All Implemented Interfaces:: CachedRowSet, java.lang.Cloneable, Joinable, JoinRowSet, java.sql.ResultSet, javax.sql.RowSet, javax.sql.RowSetInternal, java.io.Serializable, WebRowSet

public class JoinRowSetImpl
extends WebRowSetImpl
implements JoinRowSet

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.

Author:: Amit Handa, Jonathan Bruce
See Also:: Serialized Form

Field Summary

Fields inherited from class javax.sql.rowset.BaseRowSet

ASCII_STREAM_PARAM, asciiStream, BINARY_STREAM_PARAM, binaryStream, charStream, UNICODE_STREAM_PARAM, unicodeStream

Fields inherited from interface javax.sql.rowset.JoinRowSet

CROSS_JOIN, FULL_JOIN, INNER_JOIN, LEFT_OUTER_JOIN, RIGHT_OUTER_JOIN

Fields inherited from interface javax.sql.rowset.WebRowSet

PUBLIC_XML_SCHEMA, SCHEMA_SYSTEM_ID

Fields inherited from interface javax.sql.rowset.CachedRowSet

COMMIT_ON_ACCEPT_CHANGES

Fields inherited from interface java.sql.ResultSet

CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Constructor Summary
`JoinRowSetImpl()` Constructor for `JoinRowSetImpl` class.

Method Summary
`boolean`	`absolute(int row)` Moves this `JoinRowSetImpl` object's cursor to the row number specified.
`void`	`addRowSet(Joinable rowset)` Adds the given `RowSet` object to this `JoinRowSet` object.
`void`	`addRowSet(javax.sql.RowSet[] rowset, int[] columnIdx)` Adds the given `RowSet` objects to the `JOIN` relationship and sets the designated columns as the match columns.
`void`	`addRowSet(javax.sql.RowSet[] rowset, java.lang.String[] columnName)` Adds the given `RowSet` objects to the `JOIN` relationship and sets the designated columns as the match columns.
`void`	`addRowSet(javax.sql.RowSet rowset, int columnIdx)` Adds the given `RowSet` object to the `JOIN` relation and sets the designated column as the match column.
`void`	`addRowSet(javax.sql.RowSet rowset, java.lang.String columnName)` Adds the given `RowSet` object to the `JOIN` relationship and sets the designated column as the match column.
`void`	`afterLast()` Moves this `JoinRowSetImpl` object's cursor to the end of the rowset, just after the last row.
`void`	`beforeFirst()` Moves this `JoinRowSetImpl` object's cursor to the front of the rowset, just before the first row.
`void`	`cancelRowUpdates()` Rolls back any updates made to the current row of this `JoinRowSetImpl` object and notifies listeners that a row has changed.
`void`	`clearWarnings()` Throws an `UnsupportedOperationException` if called.
`void`	`close()` Releases the current contents of this rowset, discarding outstanding updates.
`boolean`	`columnUpdated(int indexColumn)` Indicates whether the designated column of the current row of this `JoinRowSetImpl` object has been updated.
`void`	`deleteRow()` Deletes the current row from this `JoinRowSetImpl` object and notifies listeners registered with this rowset that a row has changed.
`void`	`execute()` Populates this `JoinRowSetImpl` object with data.
`void`	`execute(java.sql.Connection conn)` Populates this `JoinRowSetImpl` object with data, using the given connection to produce the result set from which data will be read.
`int`	`findColumn(java.lang.String columnName)` Returns the index of the column whose name is columnName.
`boolean`	`first()` Moves this `JoinRowSetImpl` object's cursor to the first row and returns `true` if the operation was successful.
`java.sql.Array`	`getArray(int columnIndex)` Retrieves the value of the designated column in this `JoinRowSetImpl` object as an `Array` object in the Java programming lanugage.
`java.sql.Array`	`getArray(java.lang.String columnName)` Retrieves the value of the designated column in this `JoinRowSetImpl` object as an `Array` object in the Java programming lanugage.
`java.io.InputStream`	`getAsciiStream(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `java.sql.Timestamp` object.
`java.io.InputStream`	`getAsciiStream(java.lang.String columnName)` This method is not supported, and it will throw an `UnsupportedOperationException` if it is called.
`java.math.BigDecimal`	`getBigDecimal(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `java.math.BigDecimal` object.
`java.math.BigDecimal`	`getBigDecimal(int columnIndex, int scale)` Deprecated.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `java.math.BigDecimal` object.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String columnName, int scale)` Deprecated. use the method `getBigDecimal(String columnName)` instead
`java.io.InputStream`	`getBinaryStream(int columnIndex)` A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.
`java.io.InputStream`	`getBinaryStream(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a `java.io.InputStream` object.
`java.sql.Blob`	`getBlob(int columnIndex)` Retrieves the value of the designated column in this `JoinRowSetImpl` object as a `Blob` object in the Java programming lanugage.
`java.sql.Blob`	`getBlob(java.lang.String columnName)` Retrieves the value of the designated column in this `JoinRowSetImpl` object as a `Blob` object in the Java programming lanugage.
`boolean`	`getBoolean(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `boolean` value.
`boolean`	`getBoolean(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a `boolean` value.
`byte`	`getByte(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `byte` value.
`byte`	`getByte(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a `byte` value.
`byte[]`	`getBytes(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `byte array` value.
`byte[]`	`getBytes(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a byte array.
`java.io.Reader`	`getCharacterStream(int columnIndex)` Retrieves the value stored in the designated column of the current row as a `java.io.Reader` object.
`java.io.Reader`	`getCharacterStream(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a `java.io.Reader` object.
`java.sql.Clob`	`getClob(int columnIndex)` Retrieves the value of the designated column in this `JoinRowSetImpl` object as a `Clob` object in the Java programming lanugage.
`java.sql.Clob`	`getClob(java.lang.String columnName)` Retrieves the value of the designated column in this `JoinRowSetImpl` object as a `Clob` object in the Java programming lanugage.
`java.lang.String`	`getCursorName()` Retrieves the name of the SQL cursor used by this `JoinRowSetImpl` object.
`java.sql.Date`	`getDate(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `java.sql.Date` object.
`java.sql.Date`	`getDate(int columnIndex, java.util.Calendar cal)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `java.sql.Date` object, using the given `Calendar` object to construct an appropriate millisecond value for the date.
`java.sql.Date`	`getDate(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a `java.sql.Date` object.
`java.sql.Date`	`getDate(java.lang.String columnName, java.util.Calendar cal)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `java.sql.Date` object, using the given `Calendar` object to construct an appropriate millisecond value for the date.
`double`	`getDouble(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `double` value.
`double`	`getDouble(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a `double` value.
`float`	`getFloat(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `float` value.
`float`	`getFloat(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a `float` value.
`int`	`getInt(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `short` value.
`int`	`getInt(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as an `int` value.
`int`	`getJoinType()` Returns the last set SQL `JOIN` type in this JoinRowSetImpl object
`int[]`	`getKeyColumns()` Returns the columns that make a key to uniquely identify a row in this `JoinRowSetImpl` object.
`long`	`getLong(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `long` value.
`long`	`getLong(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a `long` value.
`java.sql.ResultSetMetaData`	`getMetaData()` Retrieves the `ResultSetMetaData` object that contains information about this `CachedRowsSet` object.
`java.lang.Object`	`getObject(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as an `Object` value.
`java.lang.Object`	`getObject(int columnIndex, java.util.Map map)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as an `Object` value.
`java.lang.Object`	`getObject(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as an `Object` value.
`java.lang.Object`	`getObject(java.lang.String columnName, java.util.Map map)` Retrieves the value of the designated column in this `JoinRowSetImpl` object as an `Object` in the Java programming lanugage, using the given `java.util.Map` object to custom map the value if appropriate.
`java.sql.ResultSet`	`getOriginal()` Returns a `ResultSet` object containing the original value of this `CachedRowSet` object.
`java.sql.ResultSet`	`getOriginalRow()` Returns a result set containing the original value of the rowset.
`java.sql.Ref`	`getRef(int columnIndex)` Retrieves the value of the designated column in this `JoinRowSetImpl` object as a `Ref` object in the Java programming lanugage.
`java.sql.Ref`	`getRef(java.lang.String columnName)` Retrieves the value of the designated column in this `JoinRowSetImpl` object as a `Ref` object in the Java programming lanugage.
`int`	`getRow()` Returns the number of the current row in this `JoinRowSetImpl` object.
`java.lang.String[]`	`getRowSetNames()` Returns a string array of the RowSet names currently residing with the `JoinRowSet` object instance.
`java.util.Collection`	`getRowSets()` Returns a Collection of the `RowSet` object instances currently residing with the instance of the `JoinRowSet` object instance.
`short`	`getShort(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `short` value.
`short`	`getShort(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a `short` value.
`java.sql.Statement`	`getStatement()` Returns `null`.
`java.lang.String`	`getString(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `String` object.
`java.lang.String`	`getString(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a `String` object.
`java.sql.Time`	`getTime(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `java.sql.Time` object.
`java.sql.Time`	`getTime(int columnIndex, java.util.Calendar cal)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `java.sql.Time` object, using the given `Calendar` object to construct an appropriate millisecond value for the date.
`java.sql.Time`	`getTime(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a `java.sql.Time` object.
`java.sql.Time`	`getTime(java.lang.String columnName, java.util.Calendar cal)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `java.sql.Time` object, using the given `Calendar` object to construct an appropriate millisecond value for the date.
`java.sql.Timestamp`	`getTimestamp(int columnIndex)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `java.sql.Timestamp` object.
`java.sql.Timestamp`	`getTimestamp(int columnIndex, java.util.Calendar cal)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `java.sql.Timestamp` object, using the given `Calendar` object to construct an appropriate millisecond value for the date.
`java.sql.Timestamp`	`getTimestamp(java.lang.String columnName)` Retrieves the value stored in the designated column of the current row as a `java.sql.Timestamp` object.
`java.sql.Timestamp`	`getTimestamp(java.lang.String columnName, java.util.Calendar cal)` Retrieves the value of the designated column in the current row of this `JoinRowSetImpl` object as a `java.sql.Timestamp` object, using the given `Calendar` object to construct an appropriate millisecond value for the date.
`java.io.InputStream`	`getUnicodeStream(int columnIndex)` Deprecated.
`java.io.InputStream`	`getUnicodeStream(java.lang.String columnName)` Deprecated. use the method `getCharacterStream` instead
`java.net.URL`	`getURL(int columnIndex)` Provide interface coverage for getURL(int) in ResultSet->RowSet
`java.net.URL`	`getURL(java.lang.String columnName)` Provide interface coverage for getURL(String) in ResultSet->RowSet
`java.sql.SQLWarning`	`getWarnings()` The first warning reported by calls on this `CachedRowSetImpl` object is returned.
`java.lang.String`	`getWhereClause()` Return a SQL-like description of the `WHERE` clause being used in a `JoinRowSet` object instance.
`void`	`insertRow()` Inserts the contents of this `JoinRowSetImpl` object's insert row into this rowset immediately following the current row.
`boolean`	`isAfterLast()` Indicates whether the cursor is after the last row in this `JoinRowSetImpl` object.
`boolean`	`isBeforeFirst()` Indicates whether the cursor is before the first row in this `JoinRowSetImpl` object.
`boolean`	`isFirst()` Indicates whether the cursor is on the first row in this `JoinRowSetImpl` object.
`boolean`	`isLast()` Indicates whether the cursor is on the last row in this `JoinRowSetImpl` object.
`boolean`	`last()` Moves this `JoinRowSetImpl` object's cursor to the last row and returns `true` if the operation was successful.
`void`	`moveToCurrentRow()` Moves the cursor for this `JoinRowSetImpl` object to the current row.
`void`	`moveToInsertRow()` Moves the cursor for this `JoinRowSetImpl` object to the insert row.
`boolean`	`next()` Moves the cursor down one row from its current position and returns `true` if the new cursor position is a valid row.
`boolean`	`previous()` Moves this `JoinRowSetImpl` object's cursor to the previous row and returns `true` if the cursor is on a valid row or `false` if it is not.
`void`	`readXml(java.io.InputStream iStream)` Reads a stream based XML input to populate an `WebRowSet`
`void`	`readXml(java.io.Reader reader)` Reads this `JoinRowSet` object in its XML format.
`void`	`refreshRow()` Sets the current row with its original value and marks the row as not updated, thus undoing any changes made to the row since the last call to the methods `updateRow` or `deleteRow`.
`boolean`	`relative(int rows)` Moves the cursor the specified number of rows from the current position, with a positive number moving it forward and a negative number moving it backward.
`boolean`	`rowDeleted()` Indicates whether the current row has been deleted.
`boolean`	`rowInserted()` Indicates whether the current row has been inserted.
`boolean`	`rowUpdated()` Indicates whether the current row of this `JoinRowSetImpl` object has been updated.
`void`	`setJoinType(int type)` Sets the type of SQL `JOIN` that this `JoinRowSet` object will use.
`void`	`setKeyColumns(int[] cols)` Sets this `JoinRowSetImpl` object's `keyCols` field with the given array of column numbers, which forms a key for uniquely identifying a row in this rowset.
`void`	`setMetaData(javax.sql.RowSetMetaData md)` Sets the metadata for this `JoinRowSetImpl` object with the given `RowSetMetaData` object.
`void`	`setOriginalRow()` Returns a result set containing the original value of the current row only.
`int`	`size()` Returns the number of rows in this `JoinRowSetImpl` object.
`boolean`	`supportsCrossJoin()` Returns `true` if this `JoinRowSet` object supports an SQL `CROSS_JOIN` and `false` if it does not.
`boolean`	`supportsFullJoin()` Returns `true` if this `JoinRowSet` object supports an SQL `FULL_JOIN` and `false` if it does not.
`boolean`	`supportsInnerJoin()` Returns `true` if this `JoinRowSet` object supports an SQL `INNER_JOIN` and `false` if it does not.
`boolean`	`supportsLeftOuterJoin()` Returns `true` if this `JoinRowSet` object supports an SQL `LEFT_OUTER_JOIN` and `false` if it does not.
`boolean`	`supportsRightOuterJoin()` Returns `true` if this `JoinRowSet` object supports an SQL `RIGHT_OUTER_JOIN` and `false` if it does not.
`CachedRowSet`	`toCachedRowSet()` Creates a separate `CachedRowSet` object that contains the data in this `JoinRowSet` object.
`void`	`updateArray(int columnIndex, java.sql.Array a)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Array` object.
`void`	`updateArray(java.lang.String columnName, java.sql.Array a)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Array` object.
`void`	`updateAsciiStream(int columnIndex, java.io.InputStream x, int length)` Sets the designated column in either the current row or the insert row of this `CachedRowSetImpl` object with the given ASCII stream value.
`void`	`updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length)` Unsupported; throws an `UnsupportedOperationException` if called.
`void`	`updateBigDecimal(int columnIndex, java.math.BigDecimal x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `java.math.BigDecimal` object.
`void`	`updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `java.math.BigDecimal` object.
`void`	`updateBinaryStream(int columnIndex, java.io.InputStream x, int length)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `java.io.InputStream` object.
`void`	`updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `java.io.InputStream` object.
`void`	`updateBlob(int columnIndex, java.sql.Blob b)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Blob` value.
`void`	`updateBlob(java.lang.String columnName, java.sql.Blob b)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Blob` object.
`void`	`updateBoolean(int columnIndex, boolean x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `boolean` value.
`void`	`updateBoolean(java.lang.String columnName, boolean x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `boolean` value.
`void`	`updateByte(int columnIndex, byte x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `byte` value.
`void`	`updateByte(java.lang.String columnName, byte x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `byte` value.
`void`	`updateBytes(int columnIndex, byte[] x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `byte` array.
`void`	`updateBytes(java.lang.String columnName, byte[] x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `byte` array.
`void`	`updateCharacterStream(int columnIndex, java.io.Reader x, int length)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `java.io.Reader` object.
`void`	`updateCharacterStream(java.lang.String columnName, java.io.Reader x, int length)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `java.io.Reader` object.
`void`	`updateClob(int columnIndex, java.sql.Clob c)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Clob` object.
`void`	`updateClob(java.lang.String columnName, java.sql.Clob c)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Clob` object.
`void`	`updateDate(int columnIndex, java.sql.Date x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Date` object.
`void`	`updateDate(java.lang.String columnName, java.sql.Date x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Date` object.
`void`	`updateDouble(int columnIndex, double x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `double` value.
`void`	`updateDouble(java.lang.String columnName, double x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `double` value.
`void`	`updateFloat(int columnIndex, float x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `float` value.
`void`	`updateFloat(java.lang.String columnName, float x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `float` value.
`void`	`updateInt(int columnIndex, int x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `int` value.
`void`	`updateInt(java.lang.String columnName, int x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `int` value.
`void`	`updateLong(int columnIndex, long x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `long` value.
`void`	`updateLong(java.lang.String columnName, long x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `long` value.
`void`	`updateNull(int columnIndex)` Sets the designated nullable column in the current row or the insert row of this `JoinRowSetImpl` object with `null` value.
`void`	`updateNull(java.lang.String columnName)` Sets the designated nullable column in the current row or the insert row of this `JoinRowSetImpl` object with `null` value.
`void`	`updateObject(int columnIndex, java.lang.Object x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Object` value.
`void`	`updateObject(int columnIndex, java.lang.Object x, int scale)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Object` value.
`void`	`updateObject(java.lang.String columnName, java.lang.Object x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Object` value.
`void`	`updateObject(java.lang.String columnName, java.lang.Object x, int scale)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Object` value.
`void`	`updateRef(int columnIndex, java.sql.Ref ref)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Ref` value.
`void`	`updateRef(java.lang.String columnName, java.sql.Ref ref)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Ref` value.
`void`	`updateRow()` Marks the current row of this `JoinRowSetImpl` object as updated and notifies listeners registered with this rowset that the row has changed.
`void`	`updateShort(int columnIndex, short x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `short` value.
`void`	`updateShort(java.lang.String columnName, short x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `short` value.
`void`	`updateString(int columnIndex, java.lang.String x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `String` object.
`void`	`updateString(java.lang.String columnName, java.lang.String x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `String` object.
`void`	`updateTime(int columnIndex, java.sql.Time x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Time` object.
`void`	`updateTime(java.lang.String columnName, java.sql.Time x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Time` object.
`void`	`updateTimestamp(int columnIndex, java.sql.Timestamp x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Timestamp` object.
`void`	`updateTimestamp(java.lang.String columnName, java.sql.Timestamp x)` Sets the designated column in either the current row or the insert row of this `JoinRowSetImpl` object with the given `Timestamp` object.
`boolean`	`wasNull()` Reports whether the last column read was SQL `NULL`.
`void`	`writeXml(java.io.OutputStream oStream)` Creates an an output stream of the internal state and contents of a `WebRowSet` for XML proceessing
`void`	`writeXml(java.sql.ResultSet rs, java.io.OutputStream oStream)` Creates a new `WebRowSet` object, populates it with the contents of the `ResultSet` and creates an output streams the internal state and contents of the rowset for XML processing.
`void`	`writeXml(java.sql.ResultSet rs, java.io.Writer writer)` Creates a new `WebRowSet` object, populates it with the data in the given `ResultSet` object, and writes it to the given `java.io.Writer` object in XML format.
`void`	`writeXml(java.io.Writer writer)` Writes this `JoinRowSet` object to the given `java.io.Writer` object in XML format.

Methods inherited from class com.sun.rowset.CachedRowSetImpl

acceptChanges, acceptChanges, clone, columnUpdated, commit, createCopy, createCopyNoConstraints, createCopySchema, createShared, getConnection, getCurrentRow, getMatchColumnIndexes, getMatchColumnNames, getPageSize, getRowSetWarnings, getSyncProvider, getTableName, internalFirst, internalLast, internalNext, internalPrevious, nextPage, populate, populate, previousPage, release, removeCurrentRow, restoreOriginal, rollback, rollback, rowSetPopulated, setCommand, setMatchColumn, setMatchColumn, setMatchColumn, setMatchColumn, setOriginal, setPageSize, setSyncProvider, setTableName, toCollection, toCollection, toCollection, undoDelete, undoInsert, undoUpdate, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn

Methods inherited from class javax.sql.rowset.BaseRowSet

addRowSetListener, clearParameters, getCommand, getConcurrency, getDataSourceName, getEscapeProcessing, getFetchDirection, getFetchSize, getMaxFieldSize, getMaxRows, getParams, getPassword, getQueryTimeout, getShowDeleted, getTransactionIsolation, getType, getTypeMap, getUrl, getUsername, initParams, isReadOnly, notifyCursorMoved, notifyRowChanged, notifyRowSetChanged, removeRowSetListener, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setConcurrency, setDataSourceName, setDate, setDate, setDouble, setEscapeProcessing, setFetchDirection, setFetchSize, setFloat, setInt, setLong, setMaxFieldSize, setMaxRows, setNull, setNull, setObject, setObject, setObject, setPassword, setQueryTimeout, setReadOnly, setRef, setShort, setShowDeleted, setString, setTime, setTime, setTimestamp, setTimestamp, setTransactionIsolation, setType, setTypeMap, setUrl, setUsername

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface javax.sql.rowset.CachedRowSet

acceptChanges, acceptChanges, columnUpdated, commit, createCopy, createCopyNoConstraints, createCopySchema, createShared, getPageSize, getRowSetWarnings, getShowDeleted, getSyncProvider, getTableName, nextPage, populate, populate, previousPage, release, restoreOriginal, rollback, rollback, rowSetPopulated, setPageSize, setShowDeleted, setSyncProvider, setTableName, toCollection, toCollection, toCollection, undoDelete, undoInsert, undoUpdate

Methods inherited from interface javax.sql.RowSet

addRowSetListener, clearParameters, getCommand, getDataSourceName, getEscapeProcessing, getMaxFieldSize, getMaxRows, getPassword, getQueryTimeout, getTransactionIsolation, getTypeMap, getUrl, getUsername, isReadOnly, removeRowSetListener, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setCommand, setConcurrency, setDataSourceName, setDate, setDate, setDouble, setEscapeProcessing, setFloat, setInt, setLong, setMaxFieldSize, setMaxRows, setNull, setNull, setObject, setObject, setObject, setPassword, setQueryTimeout, setReadOnly, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setTransactionIsolation, setType, setTypeMap, setUrl, setUsername

Methods inherited from interface java.sql.ResultSet

getConcurrency, getFetchDirection, getFetchSize, getType, setFetchDirection, setFetchSize

Methods inherited from interface javax.sql.rowset.Joinable

getMatchColumnIndexes, getMatchColumnNames, setMatchColumn, setMatchColumn, setMatchColumn, setMatchColumn, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn

Methods inherited from interface javax.sql.RowSetInternal

getParams

Constructor Detail

JoinRowSetImpl

public JoinRowSetImpl()
               throws java.sql.SQLException

Constructor for JoinRowSetImpl class. Configures various internal data structures to provide mechanisms required for JoinRowSet interface implementation.
Throws:: java.sql.SQLException - if an error occurs in instantiating an instance of JoinRowSetImpl

Method Detail

addRowSet

public void addRowSet(Joinable rowset)
               throws java.sql.SQLException

Adds the given 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.

Specified by:: addRowSet in interface JoinRowSet

Parameters:: rowset - the RowSet object that implements the Joinable interface and is to be added to this JoinRowSet object
Throws:: java.sql.SQLException - if an empty RowSet is added to the to the JoinRowSet; if a match column is not set; or if an additional RowSet violates the active JOIN
See Also:: Joinable.setMatchColumn(int)

addRowSet

public void addRowSet(javax.sql.RowSet rowset,
                      int columnIdx)
               throws java.sql.SQLException

Adds the given 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.

Specified by:: addRowSet in interface JoinRowSet

Parameters:: 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
Throws:: java.sql.SQLException - if (1) an empty RowSet object is added to this JoinRowSet object, (2) a match column has not been set, or (3) the RowSet object being added violates the active JOIN
See Also:: Joinable.unsetMatchColumn(int)

addRowSet

public void addRowSet(javax.sql.RowSet rowset,
                      java.lang.String columnName)
               throws java.sql.SQLException

Adds the given 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.

Specified by:: addRowSet in interface JoinRowSet

Parameters:: 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
Throws:: java.sql.SQLException - if (1) an empty RowSet object is added to this JoinRowSet object, (2) a match column has not been set, or (3) the RowSet object being added violates the active JOIN

addRowSet

public void addRowSet(javax.sql.RowSet[] rowset,
                      int[] columnIdx)
               throws java.sql.SQLException

Adds the given 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.

Specified by:: addRowSet in interface JoinRowSet

Parameters:: 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
Throws:: java.sql.SQLException - if the number of RowSet objects in rowset is not equal to the number of int values in columnIdx

addRowSet

public void addRowSet(javax.sql.RowSet[] rowset, java.lang.String[] columnName) throws java.sql.SQLException

Adds the given 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.

Specified by:
addRowSet in interface JoinRowSet

Parameters:
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
Throws:
java.sql.SQLException - if the number of RowSet objects in rowset is not equal to the number of String objects in columnName, an empty JdbcRowSet is added to the to the JoinRowSet, if a match column is not set, or one or the RowSet objects in rowset violates the active JOIN

getRowSets

public java.util.Collection getRowSets() throws java.sql.SQLException

Returns a Collection of the 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.

Specified by:
getRowSets in interface JoinRowSet

Returns:
A Collection of the added RowSet object instances
Throws:
java.sql.SQLException - if an error occours generating a collection of the originating RowSets contained within the JOIN.

getRowSetNames

public java.lang.String[] getRowSetNames() throws java.sql.SQLException

Returns a string array of the RowSet names currently residing with the JoinRowSet object instance.

Specified by:
getRowSetNames in interface JoinRowSet

Returns:
a string array of the RowSet names
Throws:
java.sql.SQLException - if an error occours retrieving the RowSet names
See Also:
CachedRowSet.setTableName(java.lang.String)

toCachedRowSet

public CachedRowSet toCachedRowSet() throws java.sql.SQLException

Creates a separate 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.

Specified by:
toCachedRowSet in interface JoinRowSet

Returns:
a CachedRowSet object containing the contents of this JoinRowSet object
Throws:
java.sql.SQLException - if an error occurs assembling the CachedRowSet object
See Also:
RowSet, CachedRowSet, SyncProvider

supportsCrossJoin

public boolean supportsCrossJoin()

Returns true if this JoinRowSet object supports an SQL CROSS_JOIN and false if it does not.

Specified by:
supportsCrossJoin in interface JoinRowSet

Returns:
true if the CROSS_JOIN is supported; false otherwise

supportsInnerJoin

public boolean supportsInnerJoin()

Returns true if this JoinRowSet object supports an SQL INNER_JOIN and false if it does not.

Specified by:
supportsInnerJoin in interface JoinRowSet

Returns:
true is the INNER_JOIN is supported; false otherwise

supportsLeftOuterJoin

public boolean supportsLeftOuterJoin()

Returns true if this JoinRowSet object supports an SQL LEFT_OUTER_JOIN and false if it does not.

Specified by:
supportsLeftOuterJoin in interface JoinRowSet

Returns:
true is the LEFT_OUTER_JOIN is supported; false otherwise

supportsRightOuterJoin

public boolean supportsRightOuterJoin()

Returns true if this JoinRowSet object supports an SQL RIGHT_OUTER_JOIN and false if it does not.

Specified by:
supportsRightOuterJoin in interface JoinRowSet

Returns:
true is the RIGHT_OUTER_JOIN is supported; false otherwise

supportsFullJoin

public boolean supportsFullJoin()

Returns true if this JoinRowSet object supports an SQL FULL_JOIN and false if it does not.

Specified by:
supportsFullJoin in interface JoinRowSet

Returns:
true is the FULL_JOIN is supported; false otherwise

setJoinType

public void setJoinType(int type) throws java.sql.SQLException

Sets the type of SQL 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.

Specified by:
setJoinType in interface JoinRowSet

Parameters:
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
Throws:
java.sql.SQLException - if an unsupported JOIN type is set
See Also:
JoinRowSet.getJoinType()

getWhereClause

public java.lang.String getWhereClause() throws java.sql.SQLException

Return a SQL-like description of the 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.

Specified by:
getWhereClause in interface JoinRowSet

Returns:
whereClause a textual or SQL descripition of the logical WHERE cluase used in the JoinRowSet instance
Throws:
java.sql.SQLException - if an error occurs in generating a representation of the WHERE clause.

next

public boolean next() throws java.sql.SQLException

Moves the cursor down one row from its current position and returns true if the new cursor position is a valid row. The cursor for a new ResultSet object is initially positioned before the first row. The first call to the method next moves the cursor to the first row, making it the current row; the second call makes the second row the current row, and so on.
If an input stream from the previous row is open, it is implicitly closed. The ResultSet object's warning chain is cleared when a new row is read.

Specified by:
next in interface java.sql.ResultSet
Overrides:
next in class CachedRowSetImpl

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

close

public void close() throws java.sql.SQLException

Releases the current contents of this rowset, discarding outstanding updates. The rowset contains no rows after the method release is called. This method sends a RowSetChangedEvent object to all registered listeners prior to returning.

Specified by:
close in interface java.sql.ResultSet
Overrides:
close in class CachedRowSetImpl

Throws:
java.sql.SQLException - if an error occurs

wasNull

public boolean wasNull() throws java.sql.SQLException

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

Specified by:
wasNull in interface java.sql.ResultSet
Overrides:
wasNull in class CachedRowSetImpl

Returns:
true if the value in the last column read was SQL NULL; false otherwise
Throws:
java.sql.SQLException - if an error occurs

getString

public java.lang.String getString(int columnIndex) throws java.sql.SQLException

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

Specified by:
getString in interface java.sql.ResultSet
Overrides:
getString in class CachedRowSetImpl

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

getBoolean

public boolean getBoolean(int columnIndex) throws java.sql.SQLException

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

Specified by:
getBoolean in interface java.sql.ResultSet
Overrides:
getBoolean in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns:
the column value; if the value is SQL NULL, the result is false
Throws:
java.sql.SQLException - if the given column index is out of bounds, the cursor is not on a valid row, or this method fails
See Also:
CachedRowSetImpl.getBoolean(String)

getByte

public byte getByte(int columnIndex) throws java.sql.SQLException

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

Specified by:
getByte in interface java.sql.ResultSet
Overrides:
getByte in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if the given column index is out of bounds, the cursor is not on a valid row, or this method fails
See Also:
CachedRowSetImpl.getByte(String)

getShort

public short getShort(int columnIndex) throws java.sql.SQLException

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

Specified by:
getShort in interface java.sql.ResultSet
Overrides:
getShort in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if the given column index is out of bounds, the cursor is not on a valid row, or this method fails
See Also:
CachedRowSetImpl.getShort(String)

getInt

public int getInt(int columnIndex) throws java.sql.SQLException

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

Specified by:
getInt in interface java.sql.ResultSet
Overrides:
getInt in class CachedRowSetImpl

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

getLong

public long getLong(int columnIndex) throws java.sql.SQLException

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

Specified by:
getLong in interface java.sql.ResultSet
Overrides:
getLong in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if the given column index is out of bounds, the cursor is not on a valid row, or this method fails
See Also:
CachedRowSetImpl.getLong(String)

getFloat

public float getFloat(int columnIndex) throws java.sql.SQLException

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

Specified by:
getFloat in interface java.sql.ResultSet
Overrides:
getFloat in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if the given column index is out of bounds, the cursor is not on a valid row, or this method fails
See Also:
CachedRowSetImpl.getFloat(String)

getDouble

public double getDouble(int columnIndex) throws java.sql.SQLException

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

Specified by:
getDouble in interface java.sql.ResultSet
Overrides:
getDouble in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if the given column index is out of bounds, the cursor is not on a valid row, or this method fails
See Also:
CachedRowSetImpl.getDouble(String)

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws java.sql.SQLException

Deprecated.

Retrieves the value of the designated column in the current row of this 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.

Specified by:
getBigDecimal in interface java.sql.ResultSet
Overrides:
getBigDecimal in class CachedRowSetImpl

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

getBytes

public byte[] getBytes(int columnIndex) throws java.sql.SQLException

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

Specified by:
getBytes in interface java.sql.ResultSet
Overrides:
getBytes in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if the given column index is out of bounds, the cursor is not on a valid row, or the the value to be retrieved is not binary
See Also:
CachedRowSetImpl.getBytes(String)

getDate

public java.sql.Date getDate(int columnIndex) throws java.sql.SQLException

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

Specified by:
getDate in interface java.sql.ResultSet
Overrides:
getDate in class CachedRowSetImpl

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

getTime

public java.sql.Time getTime(int columnIndex) throws java.sql.SQLException

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

Specified by:
getTime in interface java.sql.ResultSet
Overrides:
getTime in class CachedRowSetImpl

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

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException

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

Specified by:
getTimestamp in interface java.sql.ResultSet
Overrides:
getTimestamp in class CachedRowSetImpl

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

getAsciiStream

public java.io.InputStream getAsciiStream(int columnIndex) throws java.sql.SQLException

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

Specified by:
getAsciiStream in interface java.sql.ResultSet
Overrides:
getAsciiStream in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if the given column index is out of bounds, the cursor is not on a valid row, or this method fails
See Also:
CachedRowSetImpl.getAsciiStream(String)

getUnicodeStream

public java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLException

Deprecated.

A column value can be retrieved as a stream of Unicode characters and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into Unicode.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. . Also, a stream may return 0 for available() whether there is data available or not.

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Overrides:
getUnicodeStream in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in this rowset
Returns:
a Java input stream that delivers the database column value as a stream of two byte Unicode characters. If the value is SQL NULL then the result is null.
Throws:
java.sql.SQLException - if an error occurs

getBinaryStream

public java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLException

A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not.

Specified by:
getBinaryStream in interface java.sql.ResultSet
Overrides:
getBinaryStream in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns:
a Java input stream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL then the result is null.
Throws:
java.sql.SQLException - if an error occurs
See Also:
CachedRowSetImpl.getBinaryStream(String)

getString

public java.lang.String getString(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getString in interface java.sql.ResultSet
Overrides:
getString in class CachedRowSetImpl

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

getBoolean

public boolean getBoolean(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getBoolean in interface java.sql.ResultSet
Overrides:
getBoolean in class CachedRowSetImpl

Parameters:
columnName - a String object giving the SQL name of a column in this JoinRowSetImpl object
Returns:
the column value; if the value is SQL NULL, the result is false
Throws:
java.sql.SQLException - if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row
See Also:
CachedRowSetImpl.getBoolean(int)

getByte

public byte getByte(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getByte in interface java.sql.ResultSet
Overrides:
getByte in class CachedRowSetImpl

Parameters:
columnName - a String object giving the SQL name of a column in this JoinRowSetImpl object
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row

getShort

public short getShort(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getShort in interface java.sql.ResultSet
Overrides:
getShort in class CachedRowSetImpl

Parameters:
columnName - a String object giving the SQL name of a column in this JoinRowSetImpl object
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row
See Also:
CachedRowSetImpl.getShort(int)

getInt

public int getInt(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getInt in interface java.sql.ResultSet
Overrides:
getInt in class CachedRowSetImpl

Parameters:
columnName - a String object giving the SQL name of a column in this JoinRowSetImpl object
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row

getLong

public long getLong(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getLong in interface java.sql.ResultSet
Overrides:
getLong in class CachedRowSetImpl

Parameters:
columnName - a String object giving the SQL name of a column in this JoinRowSetImpl object
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row
See Also:
CachedRowSetImpl.getLong(int)

getFloat

public float getFloat(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getFloat in interface java.sql.ResultSet
Overrides:
getFloat in class CachedRowSetImpl

Parameters:
columnName - a String object giving the SQL name of a column in this JoinRowSetImpl object
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row
See Also:
CachedRowSetImpl.getFloat(String)

getDouble

public double getDouble(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getDouble in interface java.sql.ResultSet
Overrides:
getDouble in class CachedRowSetImpl

Parameters:
columnName - a String object giving the SQL name of a column in this JoinRowSetImpl object
Returns:
the column value; if the value is SQL NULL, the result is 0
Throws:
java.sql.SQLException - if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row
See Also:
CachedRowSetImpl.getDouble(int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws java.sql.SQLException

Deprecated. use the method getBigDecimal(String columnName) instead

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

Specified by:
getBigDecimal in interface java.sql.ResultSet
Overrides:
getBigDecimal in class CachedRowSetImpl

Parameters:
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
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row

getBytes

public byte[] getBytes(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getBytes in interface java.sql.ResultSet
Overrides:
getBytes in class CachedRowSetImpl

Parameters:
columnName - a String object giving the SQL name of a column in this JoinRowSetImpl object
Returns:
the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row
See Also:
CachedRowSetImpl.getBytes(int)

getDate

public java.sql.Date getDate(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getDate in interface java.sql.ResultSet
Overrides:
getDate in class CachedRowSetImpl

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

getTime

public java.sql.Time getTime(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getTime in interface java.sql.ResultSet
Overrides:
getTime in class CachedRowSetImpl

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

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getTimestamp in interface java.sql.ResultSet
Overrides:
getTimestamp in class CachedRowSetImpl

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

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String columnName) throws java.sql.SQLException

This method is not supported, and it will throw an 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.

Specified by:
getAsciiStream in interface java.sql.ResultSet
Overrides:
getAsciiStream in class CachedRowSetImpl

Parameters:
columnName - a String object giving the SQL name of a column in this JoinRowSetImpl object
Returns:
a Java input stream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQL NULL, the result is null.
Throws:
java.lang.UnsupportedOperationException - if this method is called
java.sql.SQLException - if (1) the given column name is not the name of a column in this rowset (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL CHAR, VARCHAR, LONGVARCHAR BINARY, VARBINARY or LONGVARBINARY value. The bold SQL type designates the recommended return types that this method is used to retrieve.
See Also:
CachedRowSetImpl.getAsciiStream(int)

getUnicodeStream

public java.io.InputStream getUnicodeStream(java.lang.String columnName) throws java.sql.SQLException

Deprecated. use the method getCharacterStream instead

Retrieves the value stored in the designated column of the current row as a 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.

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Overrides:
getUnicodeStream in class CachedRowSetImpl

Parameters:
columnName - a String object giving the SQL name of a column in this JoinRowSetImpl object
Returns:
a Java input stream that delivers the database column value as a stream of two-byte Unicode characters. If the value is SQL NULL, the result is null.
Throws:
java.sql.SQLException - if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String columnName) throws java.sql.SQLException

Retrieves the value stored in the designated column of the current row as a java.io.InputStream object. A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.

Specified by:
getBinaryStream in interface java.sql.ResultSet
Overrides:
getBinaryStream in class CachedRowSetImpl

Parameters:
columnName - a String object giving the SQL name of a column in this JoinRowSetImpl object
Returns:
a Java input stream that delivers the database column value as a stream of uninterpreted bytes. If the value is SQL NULL, the result is null.
Throws:
java.sql.SQLException - if the given column name does not match one of this rowset's column names or the cursor is not on one of this rowset's rows or its insert row
See Also:
CachedRowSetImpl.getBinaryStream(int)

getWarnings

public java.sql.SQLWarning getWarnings()

Description copied from class: CachedRowSetImpl

The first warning reported by calls on this CachedRowSetImpl object is returned. Subsequent CachedRowSetImpl warnings will be chained to this SQLWarning.
The warning chain is automatically cleared each time a new row is read.
Note: This warning chain only covers warnings caused by ResultSet methods. Any warning caused by statement methods (such as reading OUT parameters) will be chained on the Statement object.

Specified by:
getWarnings in interface java.sql.ResultSet
Overrides:
getWarnings in class CachedRowSetImpl

Returns:
the first SQLWarning or null

clearWarnings

public void clearWarnings()

Throws an UnsupportedOperationException if called.
After a call to this method, the getWarnings method returns null until a new warning is reported for this JoinRowSetImpl object.

Specified by:
clearWarnings in interface java.sql.ResultSet
Overrides:
clearWarnings in class CachedRowSetImpl

Throws:
java.lang.UnsupportedOperationException - if this method is called

getCursorName

public java.lang.String getCursorName() throws java.sql.SQLException

Retrieves the name of the SQL cursor used by this 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.

Specified by:
getCursorName in interface java.sql.ResultSet
Overrides:
getCursorName in class CachedRowSetImpl

Returns:
the SQL cursor name for this JoinRowSetImpl object's cursor
Throws:
java.sql.SQLException - if an error occurs

getMetaData

public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException

Retrieves the 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.

Specified by:
getMetaData in interface java.sql.ResultSet
Overrides:
getMetaData in class CachedRowSetImpl

Returns:
the ResultSetMetaData object that describes this JoinRowSetImpl object's columns
Throws:
java.sql.SQLException - if an error occurs
See Also:
RowSetMetaData

getObject

public java.lang.Object getObject(int columnIndex) throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this 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()).

Specified by:
getObject in interface java.sql.ResultSet
Overrides:
getObject in class CachedRowSetImpl

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

1.2

See Also:
CachedRowSetImpl.getObject(String)

getObject

public java.lang.Object getObject(int columnIndex, java.util.Map map) throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this 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()).

Specified by:
getObject in interface java.sql.ResultSet
Overrides:
getObject in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
map - a java.util.Map object showing the mapping from SQL type names to classes in the Java programming language
Returns:
a java.lang.Object holding the column value; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if (1) the given column name does not match one of this rowset's column names, (2) the cursor is not on a valid row, or (3) there is a problem getting the Class object for a custom mapping

getObject

public java.lang.Object getObject(java.lang.String columnName) throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this 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()).

Specified by:
getObject in interface java.sql.ResultSet
Overrides:
getObject in class CachedRowSetImpl

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

getObject

public java.lang.Object getObject(java.lang.String columnName, java.util.Map map) throws java.sql.SQLException

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.

Specified by:
getObject in interface java.sql.ResultSet
Overrides:
getObject in class CachedRowSetImpl

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

getCharacterStream

public java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException

Retrieves the value stored in the designated column of the current row as a java.io.Reader object.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX method implicitly closes the stream.

Specified by:
getCharacterStream in interface java.sql.ResultSet
Overrides:
getCharacterStream in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns:
a Java character stream that delivers the database column value as a java.io.Reader object. If the value is SQL NULL, the result is null.
Throws:
java.sql.SQLException - if the given column index is out of bounds, the cursor is not on a valid row, or there is a type mismatch
See Also:
CachedRowSetImpl.getCharacterStream(String)

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String columnName) throws java.sql.SQLException

Retrieves the value stored in the designated column of the current row as a java.io.Reader object.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX method implicitly closes the stream.

Specified by:
getCharacterStream in interface java.sql.ResultSet
Overrides:
getCharacterStream in class CachedRowSetImpl

Parameters:
columnName - a String object giving the SQL name of a column in this JoinRowSetImpl object
Returns:
a Java input stream that delivers the database column value as a stream of two-byte Unicode characters. If the value is SQL NULL, the result is null.
Throws:
java.sql.SQLException - if the given column index is out of bounds, the cursor is not on a valid row, or there is a type mismatch

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException

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

Specified by:
getBigDecimal in interface java.sql.ResultSet
Overrides:
getBigDecimal in class CachedRowSetImpl

Parameters:
columnIndex - the first column is 1, the second is 2, and so on; must be 1 or larger and equal to or less than the number of columns in the rowset
Returns:
a java.math.BigDecimal value with full precision; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if the given column index is out of bounds, the cursor is not on a valid row, or this method fails
See Also:
CachedRowSetImpl.getBigDecimal(String)

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws java.sql.SQLException

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

Specified by:
getBigDecimal in interface java.sql.ResultSet
Overrides:
getBigDecimal in class CachedRowSetImpl

Parameters:
columnName - a String object that must match the SQL name of a column in this rowset, ignoring case
Returns:
a java.math.BigDecimal value with full precision; if the value is SQL NULL, the result is null
Throws:
java.sql.SQLException - if the given column index is out of bounds, the cursor is not on a valid row, or this method fails
See Also:
CachedRowSetImpl.getBigDecimal(int)

size

public int size()

Returns the number of rows in this JoinRowSetImpl object.

Specified by:
size in interface CachedRowSet
Overrides:
size in class CachedRowSetImpl

Returns:
number of rows in the rowset

isBeforeFirst

public boolean isBeforeFirst() throws java.sql.SQLException

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

Specified by:
isBeforeFirst in interface java.sql.ResultSet
Overrides:
isBeforeFirst in class CachedRowSetImpl

Returns:
true if the cursor is before the first row; false otherwise or if the rowset contains no rows
Throws:
java.sql.SQLException - if an error occurs

isAfterLast

public boolean isAfterLast() throws java.sql.SQLException

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

Specified by:
isAfterLast in interface java.sql.ResultSet
Overrides:
isAfterLast in class CachedRowSetImpl

Returns:
true if the cursor is after the last row; false otherwise or if the rowset contains no rows
Throws:
java.sql.SQLException - if an error occurs

isFirst

public boolean isFirst() throws java.sql.SQLException

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

Specified by:
isFirst in interface java.sql.ResultSet
Overrides:
isFirst in class CachedRowSetImpl

Returns:
true if the cursor is on the first row; false otherwise or if the rowset contains no rows
Throws:
java.sql.SQLException - if an error occurs

isLast

public boolean isLast() throws java.sql.SQLException

Indicates whether the cursor is on the last row in this 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.

Specified by:
isLast in interface java.sql.ResultSet
Overrides:
isLast in class CachedRowSetImpl

Returns:
true if the cursor is on the last row; false otherwise or if this rowset contains no rows
Throws:
java.sql.SQLException - if an error occurs

beforeFirst

public void beforeFirst() throws java.sql.SQLException

Moves this 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.

Specified by:
beforeFirst in interface java.sql.ResultSet
Overrides:
beforeFirst in class CachedRowSetImpl

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

afterLast

public void afterLast() throws java.sql.SQLException

Moves this 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.

Specified by:
afterLast in interface java.sql.ResultSet
Overrides:
afterLast in class CachedRowSetImpl

Throws:
java.sql.SQLException - if an error occurs

first

public boolean first() throws java.sql.SQLException

Moves this 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.

Specified by:
first in interface java.sql.ResultSet
Overrides:
first in class CachedRowSetImpl

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

last

public boolean last() throws java.sql.SQLException

Moves this 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.

Specified by:
last in interface java.sql.ResultSet
Overrides:
last in class CachedRowSetImpl

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

getRow

public int getRow() throws java.sql.SQLException

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

Specified by:
getRow in interface java.sql.ResultSet
Overrides:
getRow in class CachedRowSetImpl

Returns:
the number of the current row; 0 if there is no current row
Throws:
java.sql.SQLException - if an error occurs

absolute

public boolean absolute(int row) throws java.sql.SQLException

Moves this 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().

Specified by:
absolute in interface java.sql.ResultSet
Overrides:
absolute in class CachedRowSetImpl

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

relative

public boolean relative(int rows) throws java.sql.SQLException

Moves the cursor the specified number of rows from the current position, with a positive number moving it forward and a negative number moving it backward.
If the number is positive, the cursor moves the specified number of rows toward the end of the rowset, starting at the current row. For example, the following command, in which crs is a 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.

Specified by:
relative in interface java.sql.ResultSet
Overrides:
relative in class CachedRowSetImpl

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

previous

public boolean previous() throws java.sql.SQLException

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. 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.

Specified by:
previous in interface java.sql.ResultSet
Overrides:
previous in class CachedRowSetImpl

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

findColumn

public int findColumn(java.lang.String columnName) throws java.sql.SQLException

Returns the index of the column whose name is columnName.

Specified by:
findColumn in interface java.sql.ResultSet
Overrides:
findColumn in class CachedRowSetImpl

Parameters:
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
Returns:
the column index of the given column name
Throws:
java.sql.SQLException - if the given column name does not match one of the column names for this JoinRowSet object

rowUpdated

public boolean rowUpdated() throws java.sql.SQLException

Indicates whether the current row of this 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.

Specified by:
rowUpdated in interface java.sql.ResultSet
Overrides:
rowUpdated in class CachedRowSetImpl

Returns:
true if the row has been visibly updated by the owner or another and updates are detected; false otherwise
Throws:
java.sql.SQLException - if the cursor is on the insert row or not on a valid row
See Also:
DatabaseMetaData.updatesAreDetected(int)

columnUpdated

public boolean columnUpdated(int indexColumn) throws java.sql.SQLException

Indicates whether the designated column of the current row of this 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.

Specified by:
columnUpdated in interface CachedRowSet
Overrides:
columnUpdated in class CachedRowSetImpl

Parameters:
indexColumn - the index identifier of the column that may be have been updated.
Returns:
true if the column updated false otherwse
Throws:
java.sql.SQLException - if the cursor is on the insert row or not on a valid row
See Also:
DatabaseMetaData.updatesAreDetected(int)

rowInserted

public boolean rowInserted() throws java.sql.SQLException

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

Specified by:
rowInserted in interface java.sql.ResultSet
Overrides:
rowInserted in class CachedRowSetImpl

Returns:
true if a row has been inserted and inserts are detected; false otherwise
Throws:
java.sql.SQLException - if the cursor is on the insert row or not not on a valid row
See Also:
DatabaseMetaData.insertsAreDetected(int)

rowDeleted

public boolean rowDeleted() throws java.sql.SQLException

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

Specified by:
rowDeleted in interface java.sql.ResultSet
Overrides:
rowDeleted in class CachedRowSetImpl

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

updateNull

public void updateNull(int columnIndex) throws java.sql.SQLException

Sets the designated nullable column in the current row or the insert row of this 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.

Specified by:
updateNull in interface java.sql.ResultSet
Overrides:
updateNull in class CachedRowSetImpl

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

updateBoolean

public void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateBoolean in interface java.sql.ResultSet
Overrides:
updateBoolean in class CachedRowSetImpl

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

updateByte

public void updateByte(int columnIndex, byte x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateByte in interface java.sql.ResultSet
Overrides:
updateByte in class CachedRowSetImpl

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

updateShort

public void updateShort(int columnIndex, short x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateShort in interface java.sql.ResultSet
Overrides:
updateShort in class CachedRowSetImpl

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

updateInt

public void updateInt(int columnIndex, int x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateInt in interface java.sql.ResultSet
Overrides:
updateInt in class CachedRowSetImpl

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

updateLong

public void updateLong(int columnIndex, long x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateLong in interface java.sql.ResultSet
Overrides:
updateLong in class CachedRowSetImpl

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

updateFloat

public void updateFloat(int columnIndex, float x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateFloat in interface java.sql.ResultSet
Overrides:
updateFloat in class CachedRowSetImpl

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

updateDouble

public void updateDouble(int columnIndex, double x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateDouble in interface java.sql.ResultSet
Overrides:
updateDouble in class CachedRowSetImpl

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

updateBigDecimal

public void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateBigDecimal in interface java.sql.ResultSet
Overrides:
updateBigDecimal in class CachedRowSetImpl

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

updateString

public void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateString in interface java.sql.ResultSet
Overrides:
updateString in class CachedRowSetImpl

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

updateBytes

public void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateBytes in interface java.sql.ResultSet
Overrides:
updateBytes in class CachedRowSetImpl

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

updateDate

public void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateDate in interface java.sql.ResultSet
Overrides:
updateDate in class CachedRowSetImpl

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

updateTime

public void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateTime in interface java.sql.ResultSet
Overrides:
updateTime in class CachedRowSetImpl

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

updateTimestamp

public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateTimestamp in interface java.sql.ResultSet
Overrides:
updateTimestamp in class CachedRowSetImpl

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

updateAsciiStream

public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException

Description copied from class: CachedRowSetImpl

Sets the designated column in either the current row or the insert row of this CachedRowSetImpl object with the given ASCII stream value.
This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method 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.

Specified by:
updateAsciiStream in interface java.sql.ResultSet
Overrides:
updateAsciiStream in class CachedRowSetImpl

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

updateBinaryStream

public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateBinaryStream in interface java.sql.ResultSet
Overrides:
updateBinaryStream in class CachedRowSetImpl

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

updateCharacterStream

public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateCharacterStream in interface java.sql.ResultSet
Overrides:
updateCharacterStream in class CachedRowSetImpl

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

updateObject

public void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateObject in interface java.sql.ResultSet
Overrides:
updateObject in class CachedRowSetImpl

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

updateObject

public void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateObject in interface java.sql.ResultSet
Overrides:
updateObject in class CachedRowSetImpl

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

updateNull

public void updateNull(java.lang.String columnName) throws java.sql.SQLException

Sets the designated nullable column in the current row or the insert row of this 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.

Specified by:
updateNull in interface java.sql.ResultSet
Overrides:
updateNull in class CachedRowSetImpl

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

updateBoolean

public void updateBoolean(java.lang.String columnName, boolean x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateBoolean in interface java.sql.ResultSet
Overrides:
updateBoolean in class CachedRowSetImpl

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

updateByte

public void updateByte(java.lang.String columnName, byte x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateByte in interface java.sql.ResultSet
Overrides:
updateByte in class CachedRowSetImpl

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

updateShort

public void updateShort(java.lang.String columnName, short x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateShort in interface java.sql.ResultSet
Overrides:
updateShort in class CachedRowSetImpl

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

updateInt

public void updateInt(java.lang.String columnName, int x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateInt in interface java.sql.ResultSet
Overrides:
updateInt in class CachedRowSetImpl

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

updateLong

public void updateLong(java.lang.String columnName, long x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateLong in interface java.sql.ResultSet
Overrides:
updateLong in class CachedRowSetImpl

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

updateFloat

public void updateFloat(java.lang.String columnName, float x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateFloat in interface java.sql.ResultSet
Overrides:
updateFloat in class CachedRowSetImpl

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

updateDouble

public void updateDouble(java.lang.String columnName, double x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateDouble in interface java.sql.ResultSet
Overrides:
updateDouble in class CachedRowSetImpl

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

updateBigDecimal

public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateBigDecimal in interface java.sql.ResultSet
Overrides:
updateBigDecimal in class CachedRowSetImpl

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

updateString

public void updateString(java.lang.String columnName, java.lang.String x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateString in interface java.sql.ResultSet
Overrides:
updateString in class CachedRowSetImpl

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

updateBytes

public void updateBytes(java.lang.String columnName, byte[] x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateBytes in interface java.sql.ResultSet
Overrides:
updateBytes in class CachedRowSetImpl

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

updateDate

public void updateDate(java.lang.String columnName, java.sql.Date x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateDate in interface java.sql.ResultSet
Overrides:
updateDate in class CachedRowSetImpl

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

updateTime

public void updateTime(java.lang.String columnName, java.sql.Time x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateTime in interface java.sql.ResultSet
Overrides:
updateTime in class CachedRowSetImpl

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

updateTimestamp

public void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateTimestamp in interface java.sql.ResultSet
Overrides:
updateTimestamp in class CachedRowSetImpl

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

updateAsciiStream

public void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException

Unsupported; throws an 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.

Specified by:
updateAsciiStream in interface java.sql.ResultSet
Overrides:
updateAsciiStream in class CachedRowSetImpl

Parameters:
columnName - a String object that must match the SQL name of a column in this rowset, ignoring case
x - the new column value
length - the number of one-byte ASCII characters in the stream
Throws:
java.lang.UnsupportedOperationException - if this method is invoked
java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateBinaryStream in interface java.sql.ResultSet
Overrides:
updateBinaryStream in class CachedRowSetImpl

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

updateCharacterStream

public void updateCharacterStream(java.lang.String columnName, java.io.Reader x, int length) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateCharacterStream in interface java.sql.ResultSet
Overrides:
updateCharacterStream in class CachedRowSetImpl

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

updateObject

public void updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateObject in interface java.sql.ResultSet
Overrides:
updateObject in class CachedRowSetImpl

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

updateObject

public void updateObject(java.lang.String columnName, java.lang.Object x) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateObject in interface java.sql.ResultSet
Overrides:
updateObject in class CachedRowSetImpl

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

insertRow

public void insertRow() throws java.sql.SQLException

Inserts the contents of this 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.

Specified by:
insertRow in interface java.sql.ResultSet
Overrides:
insertRow in class CachedRowSetImpl

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

updateRow

public void updateRow() throws java.sql.SQLException

Marks the current row of this 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.

Specified by:
updateRow in interface java.sql.ResultSet
Overrides:
updateRow in class CachedRowSetImpl

Throws:
java.sql.SQLException - if the cursor is on the insert row or this rowset is ResultSet.CONCUR_READ_ONLY

deleteRow

public void deleteRow() throws java.sql.SQLException

Deletes the current row from this 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.

Specified by:
deleteRow in interface java.sql.ResultSet
Overrides:
deleteRow in class CachedRowSetImpl

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

refreshRow

public void refreshRow() throws java.sql.SQLException

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

Specified by:
refreshRow in interface java.sql.ResultSet
Overrides:
refreshRow in class CachedRowSetImpl

Throws:
java.sql.SQLException - if the cursor is on the insert row, before the first row, or after the last row

cancelRowUpdates

public void cancelRowUpdates() throws java.sql.SQLException

Rolls back any updates made to the current row of this 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.

Specified by:
cancelRowUpdates in interface java.sql.ResultSet
Overrides:
cancelRowUpdates in class CachedRowSetImpl

Throws:
java.sql.SQLException - if the cursor is on the insert row, before the first row, or after the last row

moveToInsertRow

public void moveToInsertRow() throws java.sql.SQLException

Moves the cursor for this 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.

Specified by:
moveToInsertRow in interface java.sql.ResultSet
Overrides:
moveToInsertRow in class CachedRowSetImpl

Throws:
java.sql.SQLException - if this JoinRowSetImpl object is ResultSet.CONCUR_READ_ONLY

moveToCurrentRow

public void moveToCurrentRow() throws java.sql.SQLException

Moves the cursor for this 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.

Specified by:
moveToCurrentRow in interface java.sql.ResultSet
Overrides:
moveToCurrentRow in class CachedRowSetImpl

Throws:
java.sql.SQLException - if an error occurs

getStatement

public java.sql.Statement getStatement() throws java.sql.SQLException

Returns null.

Specified by:
getStatement in interface java.sql.ResultSet
Overrides:
getStatement in class CachedRowSetImpl

Returns:
null
Throws:
java.sql.SQLException - if an error occurs

getRef

public java.sql.Ref getRef(int columnIndex) throws java.sql.SQLException

Retrieves the value of the designated column in this JoinRowSetImpl object as a Ref object in the Java programming lanugage.

Specified by:
getRef in interface java.sql.ResultSet
Overrides:
getRef in class CachedRowSetImpl

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

getBlob

public java.sql.Blob getBlob(int columnIndex) throws java.sql.SQLException

Retrieves the value of the designated column in this JoinRowSetImpl object as a Blob object in the Java programming lanugage.

Specified by:
getBlob in interface java.sql.ResultSet
Overrides:
getBlob in class CachedRowSetImpl

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

getClob

public java.sql.Clob getClob(int columnIndex) throws java.sql.SQLException

Retrieves the value of the designated column in this JoinRowSetImpl object as a Clob object in the Java programming lanugage.

Specified by:
getClob in interface java.sql.ResultSet
Overrides:
getClob in class CachedRowSetImpl

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

getArray

public java.sql.Array getArray(int columnIndex) throws java.sql.SQLException

Retrieves the value of the designated column in this JoinRowSetImpl object as an Array object in the Java programming lanugage.

Specified by:
getArray in interface java.sql.ResultSet
Overrides:
getArray in class CachedRowSetImpl

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

getRef

public java.sql.Ref getRef(java.lang.String columnName) throws java.sql.SQLException

Retrieves the value of the designated column in this JoinRowSetImpl object as a Ref object in the Java programming lanugage.

Specified by:
getRef in interface java.sql.ResultSet
Overrides:
getRef in class CachedRowSetImpl

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

getBlob

public java.sql.Blob getBlob(java.lang.String columnName) throws java.sql.SQLException

Retrieves the value of the designated column in this JoinRowSetImpl object as a Blob object in the Java programming lanugage.

Specified by:
getBlob in interface java.sql.ResultSet
Overrides:
getBlob in class CachedRowSetImpl

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

getClob

public java.sql.Clob getClob(java.lang.String columnName) throws java.sql.SQLException

Retrieves the value of the designated column in this JoinRowSetImpl object as a Clob object in the Java programming lanugage.

Specified by:
getClob in interface java.sql.ResultSet
Overrides:
getClob in class CachedRowSetImpl

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

getArray

public java.sql.Array getArray(java.lang.String columnName) throws java.sql.SQLException

Retrieves the value of the designated column in this JoinRowSetImpl object as an Array object in the Java programming lanugage.

Specified by:
getArray in interface java.sql.ResultSet
Overrides:
getArray in class CachedRowSetImpl

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

getDate

public java.sql.Date getDate(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException

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.

Specified by:
getDate in interface java.sql.ResultSet
Overrides:
getDate in class CachedRowSetImpl

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

getDate

public java.sql.Date getDate(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException

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.

Specified by:
getDate in interface java.sql.ResultSet
Overrides:
getDate in class CachedRowSetImpl

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

getTime

public java.sql.Time getTime(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException

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.

Specified by:
getTime in interface java.sql.ResultSet
Overrides:
getTime in class CachedRowSetImpl

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

getTime

public java.sql.Time getTime(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException

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.

Specified by:
getTime in interface java.sql.ResultSet
Overrides:
getTime in class CachedRowSetImpl

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

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException

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.

Specified by:
getTimestamp in interface java.sql.ResultSet
Overrides:
getTimestamp in class CachedRowSetImpl

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

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException

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.

Specified by:
getTimestamp in interface java.sql.ResultSet
Overrides:
getTimestamp in class CachedRowSetImpl

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

setMetaData

public void setMetaData(javax.sql.RowSetMetaData md) throws java.sql.SQLException

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

Specified by:
setMetaData in interface CachedRowSet
Overrides:
setMetaData in class CachedRowSetImpl

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

getOriginal

public java.sql.ResultSet getOriginal() throws java.sql.SQLException

Description copied from interface: CachedRowSet

Returns a ResultSet object containing the original value of this CachedRowSet object.
The cursor for the ResultSet object should be positioned before the first row. In addition, the returned ResultSet object should have the following properties:

ResultSet.TYPE_SCROLL_INSENSITIVE
ResultSet.CONCUR_UPDATABLE

The original value for a RowSet object is the value it had before the last synchronization with the underlying data source. If there have been no synchronizations, the original value will be the value with which the RowSet object was populated. This method is called internally when an aplication calls the method acceptChanges and the SyncProvider object has been implemented to check for conflicts. If this is the case, the writer compares the original value with the value currently in the data source to check for conflicts.

Specified by:
getOriginal in interface CachedRowSet
Overrides:
getOriginal in class CachedRowSetImpl

Returns:
the original result set of the rowset
Throws:
java.sql.SQLException - if an error occurs produce the ResultSet object

getOriginalRow

public java.sql.ResultSet getOriginalRow() throws java.sql.SQLException

Returns a result set containing the original value of the rowset. 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.

Specified by:
getOriginalRow in interface CachedRowSet
Overrides:
getOriginalRow in class CachedRowSetImpl

Returns:
the original result set of the rowset
Throws:
java.sql.SQLException - if an error occurs produce the ResultSet object
See Also:
CachedRowSetImpl.setOriginalRow()

setOriginalRow

public void setOriginalRow() throws java.sql.SQLException

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

Specified by:
setOriginalRow in interface CachedRowSet
Overrides:
setOriginalRow in class CachedRowSetImpl

Returns:
the original result set of the row
Throws:
java.sql.SQLException - if there is no current row
See Also:
setOriginalRow()

getKeyColumns

public int[] getKeyColumns() throws java.sql.SQLException

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

Specified by:
getKeyColumns in interface CachedRowSet
Overrides:
getKeyColumns in class CachedRowSetImpl

Returns:
an array of column number that constites a primary key for this rowset. This array should be empty if no columns is representitive of a primary key
Throws:
java.sql.SQLException - if the rowset is empty or no columns are designated as primary keys
See Also:
setKeyColumns(int[])

setKeyColumns

public void setKeyColumns(int[] cols) throws java.sql.SQLException

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.

Specified by:
setKeyColumns in interface CachedRowSet
Overrides:
setKeyColumns in class CachedRowSetImpl

Parameters:
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
Throws:
java.sql.SQLException - if any of the numbers in the given array is not valid for this rowset
See Also:
getKeyColumns()

updateRef

public void updateRef(int columnIndex, java.sql.Ref ref) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateRef in interface java.sql.ResultSet
Overrides:
updateRef in class CachedRowSetImpl

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

updateRef

public void updateRef(java.lang.String columnName, java.sql.Ref ref) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateRef in interface java.sql.ResultSet
Overrides:
updateRef in class CachedRowSetImpl

Parameters:
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
Throws:
java.sql.SQLException - if (1) the given column name is not valid, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

updateClob

public void updateClob(int columnIndex, java.sql.Clob c) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateClob in interface java.sql.ResultSet
Overrides:
updateClob in class CachedRowSetImpl

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

updateClob

public void updateClob(java.lang.String columnName, java.sql.Clob c) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateClob in interface java.sql.ResultSet
Overrides:
updateClob in class CachedRowSetImpl

Parameters:
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
Throws:
java.sql.SQLException - if (1) the given column name is not valid, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

updateBlob

public void updateBlob(int columnIndex, java.sql.Blob b) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateBlob in interface java.sql.ResultSet
Overrides:
updateBlob in class CachedRowSetImpl

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

updateBlob

public void updateBlob(java.lang.String columnName, java.sql.Blob b) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateBlob in interface java.sql.ResultSet
Overrides:
updateBlob in class CachedRowSetImpl

Parameters:
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
Throws:
java.sql.SQLException - if (1) the given column name is not valid, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

updateArray

public void updateArray(int columnIndex, java.sql.Array a) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateArray in interface java.sql.ResultSet
Overrides:
updateArray in class CachedRowSetImpl

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

updateArray

public void updateArray(java.lang.String columnName, java.sql.Array a) throws java.sql.SQLException

Sets the designated column in either the current row or the insert row of this 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.

Specified by:
updateArray in interface java.sql.ResultSet
Overrides:
updateArray in class CachedRowSetImpl

Parameters:
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
Throws:
java.sql.SQLException - if (1) the given column name is not valid, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY

execute

public void execute() throws java.sql.SQLException

Populates this 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.

Specified by:
execute in interface javax.sql.RowSet
Overrides:
execute in class CachedRowSetImpl

Throws:
java.sql.SQLException - if an error occurs or the necessary properties have not been set

execute

public void execute(java.sql.Connection conn) throws java.sql.SQLException

Populates this 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.

Specified by:
execute in interface CachedRowSet
Overrides:
execute in class CachedRowSetImpl

Parameters:
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
Throws:
java.sql.SQLException - if an invalid Connection is supplied or an error occurs in establishing the connection to the data soure
See Also:
Connection

getURL

public java.net.URL getURL(int columnIndex) throws java.sql.SQLException

Provide interface coverage for getURL(int) in ResultSet->RowSet

Specified by:
getURL in interface java.sql.ResultSet
Overrides:
getURL in class CachedRowSetImpl

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

getURL

public java.net.URL getURL(java.lang.String columnName) throws java.sql.SQLException

Provide interface coverage for getURL(String) in ResultSet->RowSet

Specified by:
getURL in interface java.sql.ResultSet
Overrides:
getURL in class CachedRowSetImpl

Returns:
a java.net.URL object containing the resource reference described by the URL
Throws:
java.sql.SQLException - if (1) the given column name not the name of a column in this rowset, or (2) the cursor is not on one of this rowset's rows or its insert row, or (3) the designated column does not store an SQL DATALINK value.
See Also:
CachedRowSetImpl.getURL(int)

writeXml

public void writeXml(java.sql.ResultSet rs, java.io.Writer writer) throws java.sql.SQLException

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.

Specified by:
writeXml in interface WebRowSet
Overrides:
writeXml in class WebRowSetImpl

Throws:
java.sql.SQLException - if an error occurs writing out the rowset contents to XML

writeXml

public void writeXml(java.io.Writer writer) throws java.sql.SQLException

Writes this 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.

Specified by:
writeXml in interface WebRowSet
Overrides:
writeXml in class WebRowSetImpl

Throws:
java.sql.SQLException - if an error occurs writing out the rowset contents to XML

readXml

public void readXml(java.io.Reader reader) throws java.sql.SQLException

Reads this JoinRowSet object in its XML format.

Specified by:
readXml in interface WebRowSet
Overrides:
readXml in class WebRowSetImpl

Throws:
java.sql.SQLException - if a database access error occurs

readXml

public void readXml(java.io.InputStream iStream) throws java.sql.SQLException, java.io.IOException

Reads a stream based XML input to populate an WebRowSet

Specified by:
readXml in interface WebRowSet
Overrides:
readXml in class WebRowSetImpl

Throws:
java.sql.SQLException - if a data source access occurs
java.io.IOException - if a IO exception occurs

writeXml

public void writeXml(java.io.OutputStream oStream) throws java.sql.SQLException, java.io.IOException

Creates an an output stream of the internal state and contents of a WebRowSet for XML proceessing

Specified by:
writeXml in interface WebRowSet
Overrides:
writeXml in class WebRowSetImpl

Throws:
java.sql.SQLException - if a datasource access occurs
java.io.IOException - if an IO exception occurs

writeXml

public void writeXml(java.sql.ResultSet rs, java.io.OutputStream oStream) throws java.sql.SQLException, java.io.IOException

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.

Specified by:
writeXml in interface WebRowSet
Overrides:
writeXml in class WebRowSetImpl

Throws:
java.sql.SQLException - if a datasource access occurs
java.io.IOException - if an IO exception occurs

getJoinType

public int getJoinType() throws java.sql.SQLException

Returns the last set SQL JOIN type in this JoinRowSetImpl object

Specified by:
getJoinType in interface JoinRowSet

Returns:
joinType One of the standard JoinRowSet static field JOIN types
Throws:
java.sql.SQLException - if an error occurs determining the current join type
See Also:
JoinRowSet.setJoinType(int)

Overview Package Class Tree Deprecated Index Help

PREV CLASS NEXT CLASS FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

com.sun.rowset Class JoinRowSetImpl

JoinRowSetImpl

addRowSet

addRowSet

addRowSet

addRowSet

addRowSet

getRowSets

getRowSetNames

toCachedRowSet

supportsCrossJoin

supportsInnerJoin

supportsLeftOuterJoin

supportsRightOuterJoin

supportsFullJoin

setJoinType

getWhereClause

next

close

wasNull

getString

getBoolean

getByte

getShort

getInt

getLong

getFloat

getDouble

getBigDecimal

getBytes

getDate

getTime

getTimestamp

getAsciiStream

getUnicodeStream

getBinaryStream

getString

getBoolean

getByte

getShort

getInt

getLong

getFloat

getDouble

getBigDecimal

getBytes

getDate

getTime

getTimestamp

getAsciiStream

getUnicodeStream

getBinaryStream

getWarnings

clearWarnings

getCursorName

getMetaData

getObject

getObject

getObject

getObject

getCharacterStream

getCharacterStream

getBigDecimal

getBigDecimal

size

isBeforeFirst

isAfterLast

isFirst

isLast

beforeFirst

afterLast

first

last

getRow

absolute

relative

previous

findColumn

rowUpdated

columnUpdated

com.sun.rowset
Class JoinRowSetImpl