WebRowSet

Class Overview

The standard interface that all implementations of a WebRowSet must implement.

1.0 Overview

The WebRowSetImpl provides the standard reference implementation, which may be extended if required.

The standard WebRowSet XML Schema definition is available at the following URI:

 http://java.sun.com/xml/ns/jdbc/webrowset.xsd
 

It describes the standard XML document format required when describing a RowSet object in XML and must be used be all standard implementations of the WebRowSet interface to ensure interoperability. In addition, the WebRowSet schema uses specific SQL/XML Schema annotations, thus ensuring greater cross platform inter-operability. This is an effort currently under way at the ISO organization. The SQL/XML definition is available at the following URI:

 http://standards.iso.org/iso/9075/2002/12/sqlxml
 

The schema definition describes the internal data of a RowSet object in three distinct areas:

• properties
These properties describe the standard synchronization provider properties in addition to the more general RowSet properties.
• metadata
This describes the metadata associated with the tabular structure governed by a WebRowSet object. The metadata described is closely aligned with the metadata accessible in the underlying java.sql.ResultSet interface.
• data
This describes the original data (the state of data since the last population or last synchronization of the WebRowSet object) and the current data. By keeping track of the delta between the original data and the current data, a WebRowSet maintains the ability to synchronize changes in its data back to the originating data source.

2.0 WebRowSet States

The following sections demonstrates how a WebRowSet implementation should use the XML Schema to describe update, insert, and delete operations and to describe the state of a WebRowSet object in XML.

2.1 State 1 - Outputting a WebRowSet Object to XML

In this example, a WebRowSet object is created and populated with a simple 2 column, 5 row table from a data source. Having the 5 rows in a WebRowSet object makes it possible to describe them in XML. The metadata describing the various standard JavaBeans properties as defined in the RowSet interface plus the standard properties defined in the CachedRowSet^TM interface provide key details that describe WebRowSet properties. Outputting the WebRowSet object to XML using the standard writeXml methods describes the internal properties as follows:

 <properties>
       <command>select co1, col2 from test_table</command>
      <concurrency>1</concurrency>
      <datasource/>
      <escape-processing>true</escape-processing>
      <fetch-direction>0</fetch-direction>
      <fetch-size>0</fetch-size>
      <isolation-level>1</isolation-level>
      <key-columns/>
      <map/>
      <max-field-size>0</max-field-size>
      <max-rows>0</max-rows>
      <query-timeout>0</query-timeout>
      <read-only>false</read-only>
      <rowset-type>TRANSACTION_READ_UNCOMMITED</rowset-type>
      <show-deleted>false</show-deleted>
      <table-name/>
      <url>jdbc:thin:oracle</url>
      <sync-provider>
              <sync-provider-name>.com.rowset.provider.RIOptimisticProvider</sync-provider-name>
              <sync-provider-vendor>Sun Microsystems</sync-provider-vendor>
              <sync-provider-version>1.0</sync-provider-name>
              <sync-provider-grade>LOW</sync-provider-grade>
              <data-source-lock>NONE</data-source-lock>
      </sync-provider>
 </properties>
 

The meta-data describing the make up of the WebRowSet is described in XML as detailed below. Note both columns are described between the column-definition tags.

 <metadata>
      <column-count>2</column-count>
      <column-definition>
              <column-index>1</column-index>
              <auto-increment>false</auto-increment>
              <case-sensitive>true</case-sensitive>
              <currency>false</currency>
              <nullable>1</nullable>
              <signed>false</signed>
              <searchable>true</searchable>
              <column-display-size>10</column-display-size>
              <column-label>COL1</column-label>
              <column-name>COL1</column-name>
              <schema-name/>
              <column-precision>10</column-precision>
              <column-scale>0</column-scale>
              <table-name/>
              <catalog-name/>
              <column-type>1</column-type>
              <column-type-name>CHAR</column-type-name>
      </column-definition>
      <column-definition>
              <column-index>2</column-index>
              <auto-increment>false</auto-increment>
              <case-sensitive>false</case-sensitive>
              <currency>false</currency>
              <nullable>1</nullable>
              <signed>true</signed>
              <searchable>true</searchable>
              <column-display-size>39</column-display-size>
              <column-label>COL2</column-label>
              <column-name>COL2</column-name>
              <schema-name/>
              <column-precision>38</column-precision>
              <column-scale>0</column-scale>
              <table-name/>
              <catalog-name/>
              <column-type>3</column-type>
              <column-type-name>NUMBER</column-type-name>
      </column-definition>
 </metadata>
 

Having detailed how the properties and metadata are described, the following details how the contents of a WebRowSet object is described in XML. Note, that this describes a WebRowSet object that has not undergone any modifications since its instantiation. A currentRow tag is mapped to each row of the table structure that the WebRowSet object provides. A columnValue tag may contain either the stringData or binaryData tag, according to the SQL type that the XML value is mapping back to. The binaryData tag contains data in the Base64 encoding and is typically used for BLOB and CLOB type data.

 <data>
      <currentRow>
              <columnValue>
                      firstrow
              </columnValue>
              <columnValue>
                      1
              </columnValue>
      </currentRow>
      <currentRow>
              <columnValue>
                      secondrow
              </columnValue>
              <columnValue>
                      2
              </columnValue>
      </currentRow>
      <currentRow>
              <columnValue>
                      thirdrow
              </columnValue>
              <columnValue>
                      3
              </columnValue>
      </currentRow>
      <currentRow>
              <columnValue>
                      fourthrow
              </columnValue>
              <columnValue>
                      4
              </columnValue>
      </currentRow>
 </data>
 

2.2 State 2 - Deleting a Row

Deleting a row in a WebRowSet object involves simply moving to the row to be deleted and then calling the method deleteRow, as in any other RowSet object. The following two lines of code, in which wrs is a WebRowSet object, delete the third row.

     wrs.absolute(3);
     wrs.deleteRow();
 

The XML description shows the third row is marked as a deleteRow, which eliminates the third row in the WebRowSet object.

 <data>
      <currentRow>
              <columnValue>
                      firstrow
              </columnValue>
              <columnValue>
                      1
              </columnValue>
      </currentRow>
      <currentRow>
              <columnValue>
                      secondrow
              </columnValue>
              <columnValue>
                      2
              </columnValue>
      </currentRow>
      <deleteRow>
              <columnValue>
                      thirdrow
              </columnValue>
              <columnValue>
                      3
              </columnValue>
      </deleteRow>
      <currentRow>
              <columnValue>
                      fourthrow
              </columnValue>
              <columnValue>
                      4
              </columnValue>
      </currentRow>
 </data>
 

2.3 State 3 - Inserting a Row

A WebRowSet object can insert a new row by moving to the insert row, calling the appropriate updater methods for each column in the row, and then calling the method insertRow.

 wrs.moveToInsertRow();
 wrs.updateString(1, "fifththrow");
 wrs.updateString(2, "5");
 wrs.insertRow();
 

The following code fragment changes the second column value in the row just inserted. Note that this code applies when new rows are inserted right after the current row, which is why the method next moves the cursor to the correct row. Calling the method acceptChanges writes the change to the data source.

 wrs.moveToCurrentRow();
 wrs.next();
 wrs.updateString(2, "V");
 wrs.acceptChanges();
 :
 

Describing this in XML demonstrates where the Java code inserts a new row and then performs an update on the newly inserted row on an individual field.

 <data>
      <currentRow>
              <columnValue>
                      firstrow
              </columnValue>
              <columnValue>
                      1
              </columnValue>
      </currentRow>
      <currentRow>
              <columnValue>
                      secondrow
              </columnValue>
              <columnValue>
                      2
              </columnValue>
      </currentRow>
      <currentRow>
              <columnValue>
                      newthirdrow
              </columnValue>
              <columnValue>
                      III
              </columnValue>
      </currentRow>
      <insertRow>
              <columnValue>
                      fifthrow
              </columnValue>
              <columnValue>
                      5
              </columnValue>
              <updateValue>
                      V
              </updateValue>
      </insertRow>
      <currentRow>
              <columnValue>
                      fourthrow
              </columnValue>
              <columnValue>
                      4
              </columnValue>
      </currentRow>
 </date>
 

2.4 State 4 - Modifying a Row

Modifying a row produces specific XML that records both the new value and the value that was replaced. The value that was replaced becomes the original value, and the new value becomes the current value. The following code moves the cursor to a specific row, performs some modifications, and updates the row when complete.

 wrs.absolute(5);
 wrs.updateString(1, "new4thRow");
 wrs.updateString(2, "IV");
 wrs.updateRow();
 

In XML, this is described by the modifyRow tag. Both the original and new values are contained within the tag for original row tracking purposes.

 <data>
      <currentRow>
              <columnValue>
                      firstrow
              </columnValue>
              <columnValue>
                      1
              </columnValue>
      </currentRow>
      <currentRow>
              <columnValue>
                      secondrow
              </columnValue>
              <columnValue>
                      2
              </columnValue>
      </currentRow>
      <currentRow>
              <columnValue>
                      newthirdrow
              </columnValue>
              <columnValue>
                      III
              </columnValue>
      </currentRow>
      <currentRow>
              <columnValue>
                      fifthrow
              </columnValue>
              <columnValue>
                      5
              </columnValue>
      </currentRow>
      <modifyRow>
              <columnValue>
                      fourthrow
              </columnValue>
              <updateValue>
                      new4thRow
              </updateValue>
              <columnValue>
                      4
              </columnValue>
              <updateValue>
                      IV
              </updateValue>
      </modifyRow>
 </data>
 

Summary

Constants
String	PUBLIC_XML_SCHEMA	The public identifier for the XML Schema definition that defines the XML tags and their valid values for a WebRowSet implementation.
String	SCHEMA_SYSTEM_ID	The URL for the XML Schema definition file that defines the XML tags and their valid values for a WebRowSet implementation.

[Expand] Inherited Constants
From interface java.sql.ResultSet int CLOSE_CURSORS_AT_COMMIT The constant indicating that open ResultSet objects with this holdability will be closed when the current transaction is commited. int CONCUR_READ_ONLY The constant indicating the concurrency mode for a ResultSet object that may NOT be updated. int CONCUR_UPDATABLE The constant indicating the concurrency mode for a ResultSet object that may be updated. int FETCH_FORWARD The constant indicating that the rows in a result set will be processed in a forward direction; first-to-last. int FETCH_REVERSE The constant indicating that the rows in a result set will be processed in a reverse direction; last-to-first. int FETCH_UNKNOWN The constant indicating that the order in which rows in a result set will be processed is unknown. int HOLD_CURSORS_OVER_COMMIT The constant indicating that open ResultSet objects with this holdability will remain open when the current transaction is commited. int TYPE_FORWARD_ONLY The constant indicating the type for a ResultSet object whose cursor may move only forward. int TYPE_SCROLL_INSENSITIVE The constant indicating the type for a ResultSet object that is scrollable but generally not sensitive to changes to the data that underlies the ResultSet. int TYPE_SCROLL_SENSITIVE The constant indicating the type for a ResultSet object that is scrollable and generally sensitive to changes to the data that underlies the ResultSet.
From interface javax.sql.rowset.CachedRowSet boolean COMMIT_ON_ACCEPT_CHANGES Causes the CachedRowSet object's SyncProvider to commit the changes when acceptChanges() is called.

Public Methods
abstract void	readXml(InputStream iStream) Reads a stream based XML input to populate this WebRowSet object.
abstract void	readXml(Reader reader) Reads a WebRowSet object in its XML format from the given Reader object.
abstract void	writeXml(OutputStream oStream) Writes the data, properties, and metadata for this WebRowSet object to the given OutputStream object in XML format.
abstract void	writeXml(ResultSet rs, Writer writer) Populates this WebRowSet object with the contents of the given ResultSet object and writes its data, properties, and metadata to the given Writer object in XML format.
abstract void	writeXml(Writer writer) Writes the data, properties, and metadata for this WebRowSet object to the given Writer object in XML format.
abstract void	writeXml(ResultSet rs, OutputStream oStream) Populates this WebRowSet object with the contents of the given ResultSet object and writes its data, properties, and metadata to the given OutputStream object in XML format.

[Expand] Inherited Methods
From interface java.sql.ResultSet abstract boolean absolute(int row) Moves the cursor to the given row number in this ResultSet object. abstract void afterLast() Moves the cursor to the end of this ResultSet object, just after the last row. abstract void beforeFirst() Moves the cursor to the front of this ResultSet object, just before the first row. abstract void cancelRowUpdates() Cancels the updates made to the current row in this ResultSet object. abstract void clearWarnings() Clears all warnings reported on this ResultSet object. abstract void close() Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. abstract void deleteRow() Deletes the current row from this ResultSet object and from the underlying database. abstract int findColumn(String columnLabel) Maps the given ResultSet column label to its ResultSet column index. abstract boolean first() Moves the cursor to the first row in this ResultSet object. abstract Array getArray(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language. abstract Array getArray(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language. abstract InputStream getAsciiStream(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. abstract InputStream getAsciiStream(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. abstract BigDecimal getBigDecimal(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision. abstract BigDecimal getBigDecimal(int columnIndex, int scale) This method is deprecated. No replacement. abstract BigDecimal getBigDecimal(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision. abstract BigDecimal getBigDecimal(String columnLabel, int scale) This method is deprecated. No replacement. abstract InputStream getBinaryStream(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes. abstract InputStream getBinaryStream(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes. abstract Blob getBlob(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language. abstract Blob getBlob(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language. abstract boolean getBoolean(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language. abstract boolean getBoolean(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language. abstract byte getByte(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language. abstract byte getByte(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language. abstract byte[] getBytes(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language. abstract byte[] getBytes(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language. abstract Reader getCharacterStream(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. abstract Reader getCharacterStream(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. abstract Clob getClob(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language. abstract Clob getClob(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object in the Java programming language. abstract int getConcurrency() Retrieves the concurrency mode of this ResultSet object. abstract String getCursorName() Retrieves the name of the SQL cursor used by this ResultSet object. abstract Date getDate(int columnIndex, Calendar cal) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language. abstract Date getDate(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language. abstract Date getDate(String columnLabel, Calendar cal) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language. abstract Date getDate(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language. abstract double getDouble(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language. abstract double getDouble(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language. abstract int getFetchDirection() Retrieves the fetch direction for this ResultSet object. abstract int getFetchSize() Retrieves the fetch size for this ResultSet object. abstract float getFloat(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language. abstract float getFloat(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language. abstract int getHoldability() Retrieves the holdability of this ResultSet object abstract int getInt(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language. abstract int getInt(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language. abstract long getLong(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language. abstract long getLong(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language. abstract ResultSetMetaData getMetaData() Retrieves the number, types and properties of this ResultSet object's columns. abstract Reader getNCharacterStream(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. abstract Reader getNCharacterStream(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. abstract NClob getNClob(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language. abstract NClob getNClob(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language. abstract String getNString(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. abstract String getNString(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. abstract Object getObject(String columnLabel, Map<String, Class<?>> map) Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. abstract Object getObject(int columnIndex, Map<String, Class<?>> map) Retrieves the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. abstract Object getObject(String columnLabel) Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. abstract Object getObject(int columnIndex) Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language. abstract Ref getRef(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language. abstract Ref getRef(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object in the Java programming language. abstract int getRow() Retrieves the current row number. abstract RowId getRowId(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language. abstract RowId getRowId(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language. abstract SQLXML getSQLXML(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language. abstract SQLXML getSQLXML(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language. abstract short getShort(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language. abstract short getShort(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language. abstract Statement getStatement() Retrieves the Statement object that produced this ResultSet object. abstract String getString(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. abstract String getString(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. abstract Time getTime(String columnLabel, Calendar cal) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language. abstract Time getTime(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language. abstract Time getTime(int columnIndex, Calendar cal) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language. abstract Time getTime(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language. abstract Timestamp getTimestamp(int columnIndex, Calendar cal) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. abstract Timestamp getTimestamp(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. abstract Timestamp getTimestamp(String columnLabel, Calendar cal) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. abstract Timestamp getTimestamp(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. abstract int getType() Retrieves the type of this ResultSet object. abstract URL getURL(int columnIndex) Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language. abstract URL getURL(String columnLabel) Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL object in the Java programming language. abstract InputStream getUnicodeStream(int columnIndex) This method is deprecated. use getCharacterStream in place of getUnicodeStream abstract InputStream getUnicodeStream(String columnLabel) This method is deprecated. use getCharacterStream instead abstract SQLWarning getWarnings() Retrieves the first warning reported by calls on this ResultSet object. abstract void insertRow() Inserts the contents of the insert row into this ResultSet object and into the database. abstract boolean isAfterLast() Retrieves whether the cursor is after the last row in this ResultSet object. abstract boolean isBeforeFirst() Retrieves whether the cursor is before the first row in this ResultSet object. abstract boolean isClosed() Retrieves whether this ResultSet object has been closed. abstract boolean isFirst() Retrieves whether the cursor is on the first row of this ResultSet object. abstract boolean isLast() Retrieves whether the cursor is on the last row of this ResultSet object. abstract boolean last() Moves the cursor to the last row in this ResultSet object. abstract void moveToCurrentRow() Moves the cursor to the remembered cursor position, usually the current row. abstract void moveToInsertRow() Moves the cursor to the insert row. abstract boolean next() Moves the cursor froward one row from its current position. abstract boolean previous() Moves the cursor to the previous row in this ResultSet object. abstract void refreshRow() Refreshes the current row with its most recent value in the database. abstract boolean relative(int rows) Moves the cursor a relative number of rows, either positive or negative. abstract boolean rowDeleted() Retrieves whether a row has been deleted. abstract boolean rowInserted() Retrieves whether the current row has had an insertion. abstract boolean rowUpdated() Retrieves whether the current row has been updated. abstract void setFetchDirection(int direction) Gives a hint as to the direction in which the rows in this ResultSet object will be processed. abstract void setFetchSize(int rows) Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object. abstract void updateArray(int columnIndex, Array x) Updates the designated column with a java.sql.Array value. abstract void updateArray(String columnLabel, Array x) Updates the designated column with a java.sql.Array value. abstract void updateAsciiStream(String columnLabel, InputStream x, int length) Updates the designated column with an ascii stream value, which will have the specified number of bytes. abstract void updateAsciiStream(int columnIndex, InputStream x, long length) Updates the designated column with an ascii stream value, which will have the specified number of bytes. abstract void updateAsciiStream(String columnLabel, InputStream x, long length) Updates the designated column with an ascii stream value, which will have the specified number of bytes. abstract void updateAsciiStream(String columnLabel, InputStream x) Updates the designated column with an ascii stream value. abstract void updateAsciiStream(int columnIndex, InputStream x) Updates the designated column with an ascii stream value. abstract void updateAsciiStream(int columnIndex, InputStream x, int length) Updates the designated column with an ascii stream value, which will have the specified number of bytes. abstract void updateBigDecimal(int columnIndex, BigDecimal x) Updates the designated column with a java.math.BigDecimal value. abstract void updateBigDecimal(String columnLabel, BigDecimal x) Updates the designated column with a java.sql.BigDecimal value. abstract void updateBinaryStream(int columnIndex, InputStream x) Updates the designated column with a binary stream value. abstract void updateBinaryStream(int columnIndex, InputStream x, long length) Updates the designated column with a binary stream value, which will have the specified number of bytes. abstract void updateBinaryStream(String columnLabel, InputStream x, long length) Updates the designated column with a binary stream value, which will have the specified number of bytes. abstract void updateBinaryStream(int columnIndex, InputStream x, int length) Updates the designated column with a binary stream value, which will have the specified number of bytes. abstract void updateBinaryStream(String columnLabel, InputStream x) Updates the designated column with a binary stream value. abstract void updateBinaryStream(String columnLabel, InputStream x, int length) Updates the designated column with a binary stream value, which will have the specified number of bytes. abstract void updateBlob(int columnIndex, Blob x) Updates the designated column with a java.sql.Blob value. abstract void updateBlob(String columnLabel, InputStream inputStream) Updates the designated column using the given input stream. abstract void updateBlob(String columnLabel, InputStream inputStream, long length) Updates the designated column using the given input stream, which will have the specified number of bytes. abstract void updateBlob(int columnIndex, InputStream inputStream) Updates the designated column using the given input stream. abstract void updateBlob(int columnIndex, InputStream inputStream, long length) Updates the designated column using the given input stream, which will have the specified number of bytes. abstract void updateBlob(String columnLabel, Blob x) Updates the designated column with a java.sql.Blob value. abstract void updateBoolean(int columnIndex, boolean x) Updates the designated column with a boolean value. abstract void updateBoolean(String columnLabel, boolean x) Updates the designated column with a boolean value. abstract void updateByte(String columnLabel, byte x) Updates the designated column with a byte value. abstract void updateByte(int columnIndex, byte x) Updates the designated column with a byte value. abstract void updateBytes(int columnIndex, byte[] x) Updates the designated column with a byte array value. abstract void updateBytes(String columnLabel, byte[] x) Updates the designated column with a byte array value. abstract void updateCharacterStream(String columnLabel, Reader reader) Updates the designated column with a character stream value. abstract void updateCharacterStream(String columnLabel, Reader reader, int length) Updates the designated column with a character stream value, which will have the specified number of bytes. abstract void updateCharacterStream(int columnIndex, Reader x, long length) Updates the designated column with a character stream value, which will have the specified number of bytes. abstract void updateCharacterStream(String columnLabel, Reader reader, long length) Updates the designated column with a character stream value, which will have the specified number of bytes. abstract void updateCharacterStream(int columnIndex, Reader x) Updates the designated column with a character stream value. abstract void updateCharacterStream(int columnIndex, Reader x, int length) Updates the designated column with a character stream value, which will have the specified number of bytes. abstract void updateClob(String columnLabel, Reader reader) Updates the designated column using the given Reader object. abstract void updateClob(int columnIndex, Clob x) Updates the designated column with a java.sql.Clob value. abstract void updateClob(String columnLabel, Reader reader, long length) Updates the designated column using the given Reader object, which is the given number of characters long. abstract void updateClob(int columnIndex, Reader reader, long length) Updates the designated column using the given Reader object, which is the given number of characters long. abstract void updateClob(int columnIndex, Reader reader) Updates the designated column using the given Reader object. abstract void updateClob(String columnLabel, Clob x) Updates the designated column with a java.sql.Clob value. abstract void updateDate(String columnLabel, Date x) Updates the designated column with a java.sql.Date value. abstract void updateDate(int columnIndex, Date x) Updates the designated column with a java.sql.Date value. abstract void updateDouble(String columnLabel, double x) Updates the designated column with a double value. abstract void updateDouble(int columnIndex, double x) Updates the designated column with a double value. abstract void updateFloat(String columnLabel, float x) Updates the designated column with a float value. abstract void updateFloat(int columnIndex, float x) Updates the designated column with a float value. abstract void updateInt(String columnLabel, int x) Updates the designated column with an int value. abstract void updateInt(int columnIndex, int x) Updates the designated column with an int value. abstract void updateLong(String columnLabel, long x) Updates the designated column with a long value. abstract void updateLong(int columnIndex, long x) Updates the designated column with a long value. abstract void updateNCharacterStream(String columnLabel, Reader reader) Updates the designated column with a character stream value. abstract void updateNCharacterStream(int columnIndex, Reader x) Updates the designated column with a character stream value. abstract void updateNCharacterStream(String columnLabel, Reader reader, long length) Updates the designated column with a character stream value, which will have the specified number of bytes. abstract void updateNCharacterStream(int columnIndex, Reader x, long length) Updates the designated column with a character stream value, which will have the specified number of bytes. abstract void updateNClob(int columnIndex, NClob nClob) Updates the designated column with a java.sql.NClob value. abstract void updateNClob(String columnLabel, NClob nClob) Updates the designated column with a java.sql.NClob value. abstract void updateNClob(String columnLabel, Reader reader) Updates the designated column using the given Reader object. abstract void updateNClob(int columnIndex, Reader reader) Updates the designated column using the given Reader The data will be read from the stream as needed until end-of-stream is reached. abstract void updateNClob(int columnIndex, Reader reader, long length) Updates the designated column using the given Reader object, which is the given number of characters long. abstract void updateNClob(String columnLabel, Reader reader, long length) Updates the designated column using the given Reader object, which is the given number of characters long. abstract void updateNString(String columnLabel, String nString) Updates the designated column with a String value. abstract void updateNString(int columnIndex, String nString) Updates the designated column with a String value. abstract void updateNull(String columnLabel) Updates the designated column with a null value. abstract void updateNull(int columnIndex) Updates the designated column with a null value. abstract void updateObject(int columnIndex, Object x) Updates the designated column with an Object value. abstract void updateObject(int columnIndex, Object x, int scaleOrLength) Updates the designated column with an Object value. abstract void updateObject(String columnLabel, Object x, int scaleOrLength) Updates the designated column with an Object value. abstract void updateObject(String columnLabel, Object x) Updates the designated column with an Object value. abstract void updateRef(int columnIndex, Ref x) Updates the designated column with a java.sql.Ref value. abstract void updateRef(String columnLabel, Ref x) Updates the designated column with a java.sql.Ref value. abstract void updateRow() Updates the underlying database with the new contents of the current row of this ResultSet object. abstract void updateRowId(String columnLabel, RowId x) Updates the designated column with a RowId value. abstract void updateRowId(int columnIndex, RowId x) Updates the designated column with a RowId value. abstract void updateSQLXML(int columnIndex, SQLXML xmlObject) Updates the designated column with a java.sql.SQLXML value. abstract void updateSQLXML(String columnLabel, SQLXML xmlObject) Updates the designated column with a java.sql.SQLXML value. abstract void updateShort(int columnIndex, short x) Updates the designated column with a short value. abstract void updateShort(String columnLabel, short x) Updates the designated column with a short value. abstract void updateString(int columnIndex, String x) Updates the designated column with a String value. abstract void updateString(String columnLabel, String x) Updates the designated column with a String value. abstract void updateTime(int columnIndex, Time x) Updates the designated column with a java.sql.Time value. abstract void updateTime(String columnLabel, Time x) Updates the designated column with a java.sql.Time value. abstract void updateTimestamp(int columnIndex, Timestamp x) Updates the designated column with a java.sql.Timestamp value. abstract void updateTimestamp(String columnLabel, Timestamp x) Updates the designated column with a java.sql.Timestamp value. abstract boolean wasNull() Reports whether the last column read had a value of SQL NULL.
From interface java.sql.Wrapper abstract boolean isWrapperFor(Class<?> iface) Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. abstract <T> T unwrap(Class<T> iface) Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
From interface javax.sql.RowSet abstract void addRowSetListener(RowSetListener listener) Registers the given listener so that it will be notified of events that occur on this RowSet object. abstract void clearParameters() Clears the parameters set for this RowSet object's command. abstract void execute() Fills this RowSet object with data. abstract String getCommand() Retrieves this RowSet object's command property. abstract String getDataSourceName() Retrieves the logical name that identifies the data source for this RowSet object. abstract boolean getEscapeProcessing() Retrieves whether escape processing is enabled for this RowSet object. abstract int getMaxFieldSize() Retrieves the maximum number of bytes that may be returned for certain column values. abstract int getMaxRows() Retrieves the maximum number of rows that this RowSet object can contain. abstract String getPassword() Retrieves the password used to create a database connection. abstract int getQueryTimeout() Retrieves the maximum number of seconds the driver will wait for a statement to execute. abstract int getTransactionIsolation() Retrieves the transaction isolation level set for this RowSet object. abstract Map<String, Class<?>> getTypeMap() Retrieves the Map object associated with this RowSet object, which specifies the custom mapping of SQL user-defined types, if any. abstract String getUrl() Retrieves the url property this RowSet object will use to create a connection if it uses the DriverManager instead of a DataSource object to establish the connection. abstract String getUsername() Retrieves the username used to create a database connection for this RowSet object. abstract boolean isReadOnly() Retrieves whether this RowSet object is read-only. abstract void removeRowSetListener(RowSetListener listener) Removes the specified listener from the list of components that will be notified when an event occurs on this RowSet object. abstract void setArray(int i, Array x) Sets the designated parameter in this RowSet object's command with the given Array value. abstract void setAsciiStream(int parameterIndex, InputStream x, int length) Sets the designated parameter in this RowSet object's command to the given java.io.InputStream value. abstract void setAsciiStream(String parameterName, InputStream x, int length) Sets the designated parameter to the given input stream, which will have the specified number of bytes. abstract void setAsciiStream(String parameterName, InputStream x) Sets the designated parameter to the given input stream. abstract void setAsciiStream(int parameterIndex, InputStream x) Sets the designated parameter in this RowSet object's command to the given input stream. abstract void setBigDecimal(int parameterIndex, BigDecimal x) Sets the designated parameter in this RowSet object's command to the given java.math.BigDeciaml value. abstract void setBigDecimal(String parameterName, BigDecimal x) Sets the designated parameter to the given java.math.BigDecimal value. abstract void setBinaryStream(int parameterIndex, InputStream x) Sets the designated parameter in this RowSet object's command to the given input stream. abstract void setBinaryStream(String parameterName, InputStream x) Sets the designated parameter to the given input stream. abstract void setBinaryStream(int parameterIndex, InputStream x, int length) Sets the designated parameter in this RowSet object's command to the given java.io.InputStream value. abstract void setBinaryStream(String parameterName, InputStream x, int length) Sets the designated parameter to the given input stream, which will have the specified number of bytes. abstract void setBlob(int parameterIndex, InputStream inputStream, long length) Sets the designated parameter to a InputStream object. abstract void setBlob(int parameterIndex, InputStream inputStream) Sets the designated parameter to a InputStream object. abstract void setBlob(String parameterName, InputStream inputStream, long length) Sets the designated parameter to a InputStream object. abstract void setBlob(String parameterName, InputStream inputStream) Sets the designated parameter to a InputStream object. abstract void setBlob(String parameterName, Blob x) Sets the designated parameter to the given java.sql.Blob object. abstract void setBlob(int i, Blob x) Sets the designated parameter in this RowSet object's command with the given Blob value. abstract void setBoolean(String parameterName, boolean x) Sets the designated parameter to the given Java boolean value. abstract void setBoolean(int parameterIndex, boolean x) Sets the designated parameter in this RowSet object's command to the given Java boolean value. abstract void setByte(int parameterIndex, byte x) Sets the designated parameter in this RowSet object's command to the given Java byte value. abstract void setByte(String parameterName, byte x) Sets the designated parameter to the given Java byte value. abstract void setBytes(int parameterIndex, byte[] x) Sets the designated parameter in this RowSet object's command to the given Java array of byte values. abstract void setBytes(String parameterName, byte[] x) Sets the designated parameter to the given Java array of bytes. abstract void setCharacterStream(String parameterName, Reader reader, int length) Sets the designated parameter to the given Reader object, which is the given number of characters long. abstract void setCharacterStream(String parameterName, Reader reader) Sets the designated parameter to the given Reader object. abstract void setCharacterStream(int parameterIndex, Reader reader) Sets the designated parameter in this RowSet object's command to the given Reader object. abstract void setCharacterStream(int parameterIndex, Reader reader, int length) Sets the designated parameter in this RowSet object's command to the given java.io.Reader value. abstract void setClob(int parameterIndex, Reader reader, long length) Sets the designated parameter to a Reader object. abstract void setClob(String parameterName, Reader reader, long length) Sets the designated parameter to a Reader object. abstract void setClob(int i, Clob x) Sets the designated parameter in this RowSet object's command with the given Clob value. abstract void setClob(int parameterIndex, Reader reader) Sets the designated parameter to a Reader object. abstract void setClob(String parameterName, Clob x) Sets the designated parameter to the given java.sql.Clob object. abstract void setClob(String parameterName, Reader reader) Sets the designated parameter to a Reader object. abstract void setCommand(String cmd) Sets this RowSet object's command property to the given SQL query. abstract void setConcurrency(int concurrency) Sets the concurrency of this RowSet object to the given concurrency level. abstract void setDataSourceName(String name) Sets the data source name property for this RowSet object to the given String. abstract void setDate(int parameterIndex, Date x, Calendar cal) Sets the designated parameter in this RowSet object's command with the given java.sql.Date value. abstract void setDate(int parameterIndex, Date x) Sets the designated parameter in this RowSet object's command to the given java.sql.Date value. abstract void setDate(String parameterName, Date x, Calendar cal) Sets the designated parameter to the given java.sql.Date value, using the given Calendar object. abstract void setDate(String parameterName, Date x) Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application. abstract void setDouble(int parameterIndex, double x) Sets the designated parameter in this RowSet object's command to the given Java double value. abstract void setDouble(String parameterName, double x) Sets the designated parameter to the given Java double value. abstract void setEscapeProcessing(boolean enable) Sets escape processing for this RowSet object on or off. abstract void setFloat(int parameterIndex, float x) Sets the designated parameter in this RowSet object's command to the given Java float value. abstract void setFloat(String parameterName, float x) Sets the designated parameter to the given Java float value. abstract void setInt(int parameterIndex, int x) Sets the designated parameter in this RowSet object's command to the given Java int value. abstract void setInt(String parameterName, int x) Sets the designated parameter to the given Java int value. abstract void setLong(int parameterIndex, long x) Sets the designated parameter in this RowSet object's command to the given Java long value. abstract void setLong(String parameterName, long x) Sets the designated parameter to the given Java long value. abstract void setMaxFieldSize(int max) Sets the maximum number of bytes that can be returned for a column value to the given number of bytes. abstract void setMaxRows(int max) Sets the maximum number of rows that this RowSet object can contain to the specified number. abstract void setNCharacterStream(int parameterIndex, Reader value) Sets the designated parameter in this RowSet object's command to a Reader object. abstract void setNCharacterStream(String parameterName, Reader value) Sets the designated parameter to a Reader object. abstract void setNCharacterStream(String parameterName, Reader value, long length) Sets the designated parameter to a Reader object. abstract void setNCharacterStream(int parameterIndex, Reader value, long length) Sets the designated parameter to a Reader object. abstract void setNClob(String parameterName, Reader reader, long length) Sets the designated parameter to a Reader object. abstract void setNClob(String parameterName, NClob value) Sets the designated parameter to a java.sql.NClob object. abstract void setNClob(int parameterIndex, Reader reader) Sets the designated parameter to a Reader object. abstract void setNClob(String parameterName, Reader reader) Sets the designated parameter to a Reader object. abstract void setNClob(int parameterIndex, NClob value) Sets the designated parameter to a java.sql.NClob object. abstract void setNClob(int parameterIndex, Reader reader, long length) Sets the designated parameter to a Reader object. abstract void setNString(String parameterName, String value) Sets the designated paramter to the given String object. abstract void setNString(int parameterIndex, String value) Sets the designated paramter to the given String object. abstract void setNull(String parameterName, int sqlType) Sets the designated parameter to SQL NULL. abstract void setNull(String parameterName, int sqlType, String typeName) Sets the designated parameter to SQL NULL. abstract void setNull(int paramIndex, int sqlType, String typeName) Sets the designated parameter in this RowSet object's SQL command to SQL NULL. abstract void setNull(int parameterIndex, int sqlType) Sets the designated parameter in this RowSet object's SQL command to SQL NULL. abstract void setObject(String parameterName, Object x) Sets the value of the designated parameter with the given object. abstract void setObject(String parameterName, Object x, int targetSqlType) Sets the value of the designated parameter with the given object. abstract void setObject(String parameterName, Object x, int targetSqlType, int scale) Sets the value of the designated parameter with the given object. abstract void setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength) Sets the designated parameter in this RowSet object's command with the given Java Object. abstract void setObject(int parameterIndex, Object x) Sets the designated parameter in this RowSet object's command with a Java Object. abstract void setObject(int parameterIndex, Object x, int targetSqlType) Sets the designated parameter in this RowSet object's command with a Java Object. abstract void setPassword(String password) Sets the database password for this RowSet object to the given String. abstract void setQueryTimeout(int seconds) Sets the maximum time the driver will wait for a statement to execute to the given number of seconds. abstract void setReadOnly(boolean value) Sets whether this RowSet object is read-only to the given boolean. abstract void setRef(int i, Ref x) Sets the designated parameter in this RowSet object's command with the given Ref value. abstract void setRowId(int parameterIndex, RowId x) Sets the designated parameter to the given java.sql.RowId object. abstract void setRowId(String parameterName, RowId x) Sets the designated parameter to the given java.sql.RowId object. abstract void setSQLXML(String parameterName, SQLXML xmlObject) Sets the designated parameter to the given java.sql.SQLXML object. abstract void setSQLXML(int parameterIndex, SQLXML xmlObject) Sets the designated parameter to the given java.sql.SQLXML object. abstract void setShort(int parameterIndex, short x) Sets the designated parameter in this RowSet object's command to the given Java short value. abstract void setShort(String parameterName, short x) Sets the designated parameter to the given Java short value. abstract void setString(String parameterName, String x) Sets the designated parameter to the given Java String value. abstract void setString(int parameterIndex, String x) Sets the designated parameter in this RowSet object's command to the given Java String value. abstract void setTime(int parameterIndex, Time x) Sets the designated parameter in this RowSet object's command to the given java.sql.Time value. abstract void setTime(String parameterName, Time x, Calendar cal) Sets the designated parameter to the given java.sql.Time value, using the given Calendar object. abstract void setTime(int parameterIndex, Time x, Calendar cal) Sets the designated parameter in this RowSet object's command with the given java.sql.Time value. abstract void setTime(String parameterName, Time x) Sets the designated parameter to the given java.sql.Time value. abstract void setTimestamp(int parameterIndex, Timestamp x, Calendar cal) Sets the designated parameter in this RowSet object's command with the given java.sql.Timestamp value. abstract void setTimestamp(String parameterName, Timestamp x, Calendar cal) Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object. abstract void setTimestamp(String parameterName, Timestamp x) Sets the designated parameter to the given java.sql.Timestamp value. abstract void setTimestamp(int parameterIndex, Timestamp x) Sets the designated parameter in this RowSet object's command to the given java.sql.Timestamp value. abstract void setTransactionIsolation(int level) Sets the transaction isolation level for this RowSet obejct. abstract void setType(int type) Sets the type of this RowSet object to the given type. abstract void setTypeMap(Map<String, Class<?>> map) Installs the given java.util.Map object as the default type map for this RowSet object. abstract void setURL(int parameterIndex, URL x) Sets the designated parameter to the given java.net.URL value. abstract void setUrl(String url) Sets the URL this RowSet object will use when it uses the DriverManager to create a connection. abstract void setUsername(String name) Sets the username property for this RowSet object to the given String.
From interface javax.sql.rowset.CachedRowSet abstract void acceptChanges() Propagates row update, insert and delete changes made to this CachedRowSet object to the underlying data source. abstract void acceptChanges(Connection con) Propagates all row update, insert and delete changes to the data source backing this CachedRowSet object using the specified Connection object to establish a connection to the data source. abstract boolean columnUpdated(int idx) Indicates whether the designated column in the current row of this CachedRowSet object has been updated. abstract boolean columnUpdated(String columnName) Indicates whether the designated column in the current row of this CachedRowSet object has been updated. abstract void commit() Each CachedRowSet object's SyncProvider contains a Connection object from the ResultSet or JDBC properties passed to it's constructors. abstract CachedRowSet createCopy() Creates a RowSet object that is a deep copy of the data in this CachedRowSet object. abstract CachedRowSet createCopyNoConstraints() Creates a CachedRowSet object that is a deep copy of this CachedRowSet object's data but is independent of it. abstract CachedRowSet createCopySchema() Creates a CachedRowSet object that is an empty copy of this CachedRowSet object. abstract RowSet createShared() Returns a new RowSet object backed by the same data as that of this CachedRowSet object. abstract void execute(Connection conn) Populates this CachedRowSet object with data, using the given connection to produce the result set from which the data will be read. abstract int[] getKeyColumns() Returns an array containing one or more column numbers indicating the columns that form a key that uniquely identifies a row in this CachedRowSet object. abstract ResultSet getOriginal() Returns a ResultSet object containing the original value of this CachedRowSet object. abstract ResultSet getOriginalRow() Returns a ResultSet object containing the original value for the current row only of this CachedRowSet object. abstract int getPageSize() Returns the page-size for the CachedRowSet object abstract RowSetWarning getRowSetWarnings() Retrieves the first warning reported by calls on this RowSet object. abstract boolean getShowDeleted() Retrieves a boolean indicating whether rows marked for deletion appear in the set of current rows. abstract SyncProvider getSyncProvider() Retrieves the SyncProvider implementation for this CachedRowSet object. abstract String getTableName() Returns an identifier for the object (table) that was used to create this CachedRowSet object. abstract boolean nextPage() Increments the current page of the CachedRowSet. abstract void populate(ResultSet rs, int startRow) Populates this CachedRowSet object with data from the given ResultSet object. abstract void populate(ResultSet data) Populates this CachedRowSet object with data from the given ResultSet object. abstract boolean previousPage() Decrements the current page of the CachedRowSet. abstract void release() Releases the current contents of this CachedRowSet object and sends a rowSetChanged event to all registered listeners. abstract void restoreOriginal() Restores this CachedRowSet object to its original value, that is, its value before the last set of changes. abstract void rollback() Each CachedRowSet object's SyncProvider contains a Connection object from the original ResultSet or JDBC properties passed to it. abstract void rollback(Savepoint s) Each CachedRowSet object's SyncProvider contains a Connection object from the original ResultSet or JDBC properties passed to it. abstract void rowSetPopulated(RowSetEvent event, int numRows) Notifies registered listeners that a RowSet object in the given RowSetEvent object has populated a number of additional rows. abstract void setKeyColumns(int[] keys) Sets this CachedRowSet object's keyCols field with the given array of column numbers, which forms a key for uniquely identifying a row in this CachedRowSet object. abstract void setMetaData(RowSetMetaData md) Sets the metadata for this CachedRowSet object with the given RowSetMetaData object. abstract void setOriginalRow() Sets the current row in this CachedRowSet object as the original row. abstract void setPageSize(int size) Sets the CachedRowSet object's page-size. abstract void setShowDeleted(boolean b) Sets the property showDeleted to the given boolean value, which determines whether rows marked for deletion appear in the set of current rows. abstract void setSyncProvider(String provider) Sets the SyncProvider objec for this CachedRowSet object to the one specified. abstract void setTableName(String tabName) Sets the identifier for the table from which this CachedRowSet object was derived to the given table name. abstract int size() Returns the number of rows in this CachedRowSet object. abstract Collection<?> toCollection(int column) Converts the designated column in this CachedRowSet object to a Collection object. abstract Collection<?> toCollection() Converts this CachedRowSet object to a Collection object that contains all of this CachedRowSet object's data. abstract Collection<?> toCollection(String column) Converts the designated column in this CachedRowSet object to a Collection object. abstract void undoDelete() Cancels the deletion of the current row and notifies listeners that a row has changed. abstract void undoInsert() Immediately removes the current row from this CachedRowSet object if the row has been inserted, and also notifies listeners that a row has changed. abstract void undoUpdate() Immediately reverses the last update operation if the row has been modified.
From interface javax.sql.rowset.Joinable abstract int[] getMatchColumnIndexes() Retrieves the indexes of the match columns that were set for this RowSet object with the method setMatchColumn(int[] columnIdxes). abstract String[] getMatchColumnNames() Retrieves the names of the match columns that were set for this RowSet object with the method setMatchColumn(String [] columnNames). abstract void setMatchColumn(int columnIdx) Sets the designated column as the match column for this RowSet object. abstract void setMatchColumn(String[] columnNames) Sets the designated columns as the match column for this RowSet object. abstract void setMatchColumn(int[] columnIdxes) Sets the designated columns as the match column for this RowSet object. abstract void setMatchColumn(String columnName) Sets the designated column as the match column for this RowSet object. abstract void unsetMatchColumn(int[] columnIdxes) Unsets the designated columns as the match column for this RowSet object. abstract void unsetMatchColumn(int columnIdx) Unsets the designated column as the match column for this RowSet object. abstract void unsetMatchColumn(String columnName) Unsets the designated column as the match column for this RowSet object. abstract void unsetMatchColumn(String[] columnName) Unsets the designated columns as the match columns for this RowSet object.