# Interface JoinRowSet

All Superinterfaces:
  `AutoCloseable, CachedRowSet, Joinable, ResultSet, RowSet, WebRowSet, Wrapper`

public interface JoinRowSet extends WebRowSet
The `JoinRowSet` interface provides a mechanism for combining related data from different `RowSet` objects into one `JoinRowSet` object, which represents an SQL `JOIN`. In other words, a `JoinRowSet` object acts as a container for the data from `RowSet` objects that form an SQL `JOIN` relationship.

The `Joinable` interface provides the methods for setting, retrieving, and unsetting a match column, the basis for establishing an SQL `JOIN` relationship. The match column may alternatively be set by supplying it to the appropriate version of the `JointRowSet` method `addRowSet`.

## 1.0 Overview

Disconnected `RowSet` objects (`CachedRowSet` objects and implementations extending the `CachedRowSet` interface) do not have a standard way to establish an SQL `JOIN` between `RowSet` objects without the expensive operation of reconnecting to the data source. The `JoinRowSet` interface is specifically designed to address this need.

Any `RowSet` object can be added to a `JoinRowSet` object to become part of an SQL `JOIN` relationship. This means that both connected and disconnected `RowSet` objects can be part of a `JOIN`. `RowSet` objects operating in a connected environment (`JdbcRowSet` objects) are encouraged to use the database to which they are already connected to establish SQL `JOIN` relationships between tables directly. However, it is possible for a `JdbcRowSet` object to be added to a `JoinRowSet` object if necessary.

Any number of `RowSet` objects can be added to an instance of `JoinRowSet` provided that they can be related in an SQL `JOIN`. By definition, the SQL `JOIN` statement is used to combine the data contained in two or more relational database tables based upon a common attribute. The `Joinable` interface provides the methods for establishing a common attribute, which is done by setting a match column. The match column commonly coincides with the primary key, but there is no requirement that the match column be the same as the primary key. By establishing and then enforcing column matches, a `JoinRowSet` object establishes `JOIN` relationships between `RowSet` objects without the assistance of an available relational database.

The type of `JOIN` to be established is determined by setting one of the `JoinRowSet` constants using the method `setJoinType`. The following SQL `JOIN` types can be set:

- `CROSS_JOIN`
- `FULL_JOIN`
- `INNER_JOIN` - the default if no `JOIN` type has been set
- `LEFT_OUTER_JOIN`
- `RIGHT_OUTER_JOIN`

Note that if no type is set, the `JOIN` will automatically be an inner join. The comments for the fields in the `JoinRowSet` interface explain these `JOIN` types, which are standard SQL `JOIN` types.

## 2.0 Using a `JoinRowSet` Object for Creating a `JOIN`

When a `JoinRowSet` object is created, it is empty. The first `RowSet` object to be added becomes the basis for the `JOIN` relationship. Applications must determine which column in each of the `RowSet` objects to be added to the `JoinRowSet` object should be the match column. All of the `RowSet` objects must contain a match column, and the values in each match column must be ones that can be compared to values in the other match columns. The columns do not have to have the same name, though they often do, and they do not have to store the exact same data type as long as the data types can be compared.

A match column can be set in two ways:

- By calling the `Joinable` method `setMatchColumn`
  This is the only method that can set the match column before a `RowSet` object is added to a `JoinRowSet` object. The `RowSet` object must have implemented the `Joinable` interface in order to use the method `setMatchColumn`. Once the match column value has been set, this method can be used to reset the match column at any time.
- By calling one of the versions of the `JoinRowSet` method `addRowSet` that takes a column name or number (or an array of column names or numbers)
  Four of the five `addRowSet` methods take a match column as a parameter. These four methods set or reset the match column at the time a `RowSet` object is being added to a `JoinRowSet` object.

## 3.0 Sample Usage

The following code fragment adds two `CachedRowSet` objects to a `JoinRowSet` object. Note that in this example, no SQL `JOIN` type is set, so the default `JOIN` type, which is INNER_JOIN, is established.

In the following code fragment, the table `EMPLOYEES`, whose match column is set to the first column (`EMP_ID`), is added to the `JoinRowSet` object jrs. Then the table `ESSP_BONUS_PLAN`, whose match column is likewise the `EMP_ID` column, is added. When this second table is added to jrs, only the rows in `ESSP_BONUS_PLAN` whose `EMP_ID` value matches an `EMP_ID` value in the `EMPLOYEES` table are added. In this case, everyone in the bonus plan is an employee, so all of the rows in the table `ESSP_BONUS_PLAN` are added to the `JoinRowSet` object. In this example, both `CachedRowSet` objects being added have implemented the `Joinable` interface and can therefore call the `Joinable` method `setMatchColumn`.

        JoinRowSet jrs = new JoinRowSetImpl();

        ResultSet rs1 = stmt.executeQuery("SELECT * FROM EMPLOYEES");
        CachedRowSet empl = new CachedRowSetImpl();
        empl.populate(rs1);
        empl.setMatchColumn(1);
        jrs.addRowSet(empl);

        ResultSet rs2 = stmt.executeQuery("SELECT * FROM ESSP_BONUS_PLAN");
        CachedRowSet bonus = new CachedRowSetImpl();
        bonus.populate(rs2);
        bonus.setMatchColumn(1); // EMP_ID is the first column
        jrs.addRowSet(bonus);

At this point, jrs is an inside JOIN of the two `RowSet` objects based on their `EMP_ID` columns. The application can now browse the combined data as if it were browsing one single `RowSet` object. Because jrs is itself a `RowSet` object, an application can navigate or modify it using `RowSet` methods.

        jrs.first();
        int employeeID = jrs.getInt(1);
        String employeeName = jrs.getString(2);

Note that because the SQL `JOIN` must be enforced when an application adds a second or subsequent `RowSet` object, there may be an initial degradation in performance while the `JOIN` is being performed.

The following code fragment adds an additional `CachedRowSet` object. In this case, the match column (`EMP_ID`) is set when the `CachedRowSet` object is added to the `JoinRowSet` object.

        ResultSet rs3 = stmt.executeQuery("SELECT * FROM 401K_CONTRIB");
        CachedRowSet fourO1k = new CachedRowSetImpl();
        four01k.populate(rs3);
        jrs.addRowSet(four01k, 1);

The `JoinRowSet` object jrs now contains values from all three tables. The data in each row in four01k in which the value for the `EMP_ID` column matches a value for the `EMP_ID` column in jrs has been added to jrs.

## 4.0 `JoinRowSet` Methods

The `JoinRowSet` interface supplies several methods for adding `RowSet` objects and for getting information about the `JoinRowSet` object.

- Methods for adding one or more `RowSet` objects
  These methods allow an application to add one `RowSet` object at a time or to add multiple `RowSet` objects at one time. In either case, the methods may specify the match column for each `RowSet` object being added.
- Methods for getting information
  One method retrieves the `RowSet` objects in the `JoinRowSet` object, and another method retrieves the `RowSet` names. A third method retrieves either the SQL `WHERE` clause used behind the scenes to form the `JOIN` or a text description of what the `WHERE` clause does.
- Methods related to the type of `JOIN`
  One method sets the `JOIN` type, and five methods find out whether the `JoinRowSet` object supports a given type.
- A method to make a separate copy of the `JoinRowSet` object
  This method creates a copy that can be persisted to the data source.

Since:
  1.5

## Field Summary

Fields
Modifier and Type
Field
Description
`static final int`
`CROSS_JOIN`
An ANSI-style `JOIN` providing a cross product of two tables
`static final int`
`FULL_JOIN`
An ANSI-style `JOIN` providing a full JOIN.
`static final int`
`INNER_JOIN`
An ANSI-style `JOIN` providing a inner join between two tables.
`static final int`
`LEFT_OUTER_JOIN`
An ANSI-style `JOIN` providing a left outer join between two tables.
`static final int`
`RIGHT_OUTER_JOIN`
An ANSI-style `JOIN` providing a right outer join between two tables.

### Fields declared in interface CachedRowSet

`COMMIT_ON_ACCEPT_CHANGES`
Modifier and Type
Field
Description
`static final boolean`
`COMMIT_ON_ACCEPT_CHANGES`
Deprecated.
Because this field is final (it is part of an interface), its value cannot be changed.

### Fields declared in interface 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`
Modifier and Type
Field
Description
`static final int`
`CLOSE_CURSORS_AT_COMMIT`
The constant indicating that open `ResultSet` objects with this holdability will be closed when the current transaction is committed.
`static final int`
`CONCUR_READ_ONLY`
The constant indicating the concurrency mode for a `ResultSet` object that may NOT be updated.
`static final int`
`CONCUR_UPDATABLE`
The constant indicating the concurrency mode for a `ResultSet` object that may be updated.
`static final int`
`FETCH_FORWARD`
The constant indicating that the rows in a result set will be processed in a forward direction; first-to-last.
`static final int`
`FETCH_REVERSE`
The constant indicating that the rows in a result set will be processed in a reverse direction; last-to-first.
`static final int`
`FETCH_UNKNOWN`
The constant indicating that the order in which rows in a result set will be processed is unknown.
`static final int`
`HOLD_CURSORS_OVER_COMMIT`
The constant indicating that open `ResultSet` objects with this holdability will remain open when the current transaction is committed.
`static final int`
`TYPE_FORWARD_ONLY`
The constant indicating the type for a `ResultSet` object whose cursor may move only forward.
`static final 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`.
`static final 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`.

### Fields declared in interface WebRowSet

`PUBLIC_XML_SCHEMA, SCHEMA_SYSTEM_ID`
Modifier and Type
Field
Description
`static final 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.
`static final 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.

## Method Summary

Modifier and Type
Method
Description
`void`
`addRowSet(RowSet[] rowset, int[] columnIdx)`
Adds one or more `RowSet` objects contained in the given array of `RowSet` objects to this `JoinRowSet` object and sets the match column for each of the `RowSet` objects to the match columns in the given array of column indexes.
`void`
`addRowSet(RowSet[] rowset, String[] columnName)`
Adds one or more `RowSet` objects contained in the given array of `RowSet` objects to this `JoinRowSet` object and sets the match column for each of the `RowSet` objects to the match columns in the given array of column names.
`void`
`addRowSet(Joinable rowset)`
Adds the given `RowSet` object to this `JoinRowSet` object.
`void`
`addRowSet(RowSet rowset, int columnIdx)`
Adds the given `RowSet` object to this `JoinRowSet` object and sets the designated column as the match column for the `RowSet` object.
`void`
`addRowSet(RowSet rowset, String columnName)`
Adds rowset to this `JoinRowSet` object and sets the designated column as the match column.
`int`
`getJoinType()`
Returns a `int` describing the set SQL `JOIN` type governing this JoinRowSet instance.
`String[]`
`getRowSetNames()`
Returns a `String` array containing the names of the `RowSet` objects added to this `JoinRowSet` object.
`Collection<?>`
`getRowSets()`
Returns a `Collection` object containing the `RowSet` objects that have been added to this `JoinRowSet` object.
`String`
`getWhereClause()`
Return a SQL-like description of the WHERE clause being used in a JoinRowSet object.
`void`
`setJoinType(int joinType)`
Allow the application to adjust the type of `JOIN` imposed on tables contained within the JoinRowSet object instance.
`boolean`
`supportsCrossJoin()`
Indicates if CROSS_JOIN is supported by a JoinRowSet implementation
`boolean`
`supportsFullJoin()`
Indicates if FULL_JOIN is supported by a JoinRowSet implementation
`boolean`
`supportsInnerJoin()`
Indicates if INNER_JOIN is supported by a JoinRowSet implementation
`boolean`
`supportsLeftOuterJoin()`
Indicates if LEFT_OUTER_JOIN is supported by a JoinRowSet implementation
`boolean`
`supportsRightOuterJoin()`
Indicates if RIGHT_OUTER_JOIN is supported by a JoinRowSet implementation
`CachedRowSet`
`toCachedRowSet()`
Creates a new `CachedRowSet` object containing the data in this `JoinRowSet` object, which can be saved to a data source using the `SyncProvider` object for the `CachedRowSet` object.

### Methods declared in interface CachedRowSet

`acceptChanges, acceptChanges, columnUpdated, columnUpdated, commit, createCopy, createCopyNoConstraints, createCopySchema, createShared, execute, getKeyColumns, getOriginal, getOriginalRow, getPageSize, getRowSetWarnings, getShowDeleted, getSyncProvider, getTableName, nextPage, populate, populate, previousPage, release, restoreOriginal, rollback, rollback, rowSetPopulated, setKeyColumns, setMetaData, setOriginalRow, setPageSize, setShowDeleted, setSyncProvider, setTableName, size, toCollection, toCollection, toCollection, undoDelete, undoInsert, undoUpdate`
Modifier and Type
Method
Description
`void`
`acceptChanges()`
Propagates row update, insert and delete changes made to this `CachedRowSet` object to the underlying data source.
`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.
`boolean`
`columnUpdated(int idx)`
Indicates whether the designated column in the current row of this `CachedRowSet` object has been updated.
`boolean`
`columnUpdated(String columnName)`
Indicates whether the designated column in the current row of this `CachedRowSet` object has been updated.
`void`
`commit()`
Each `CachedRowSet` object's `SyncProvider` contains a `Connection` object from the `ResultSet` or JDBC properties passed to it's constructors.
`CachedRowSet`
`createCopy()`
Creates a `RowSet` object that is a deep copy of the data in this `CachedRowSet` object.
`CachedRowSet`
`createCopyNoConstraints()`
Creates a `CachedRowSet` object that is a deep copy of this `CachedRowSet` object's data but is independent of it.
`CachedRowSet`
`createCopySchema()`
Creates a `CachedRowSet` object that is an empty copy of this `CachedRowSet` object.
`RowSet`
`createShared()`
Returns a new `RowSet` object backed by the same data as that of this `CachedRowSet` object.
`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.
`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.
`ResultSet`
`getOriginal()`
Returns a `ResultSet` object containing the original value of this `CachedRowSet` object.
`ResultSet`
`getOriginalRow()`
Returns a `ResultSet` object containing the original value for the current row only of this `CachedRowSet` object.
`int`
`getPageSize()`
Returns the page-size for the `CachedRowSet` object
`RowSetWarning`
`getRowSetWarnings()`
Retrieves the first warning reported by calls on this `RowSet` object.
`boolean`
`getShowDeleted()`
Retrieves a `boolean` indicating whether rows marked for deletion appear in the set of current rows.
`SyncProvider`
`getSyncProvider()`
Retrieves the `SyncProvider` implementation for this `CachedRowSet` object.
`String`
`getTableName()`
Returns an identifier for the object (table) that was used to create this `CachedRowSet` object.
`boolean`
`nextPage()`
Increments the current page of the `CachedRowSet`.
`void`
`populate(ResultSet data)`
Populates this `CachedRowSet` object with data from the given `ResultSet` object.
`void`
`populate(ResultSet rs, int startRow)`
Populates this `CachedRowSet` object with data from the given `ResultSet` object.
`boolean`
`previousPage()`
Decrements the current page of the `CachedRowSet`.
`void`
`release()`
Releases the current contents of this `CachedRowSet` object and sends a `rowSetChanged` event to all registered listeners.
`void`
`restoreOriginal()`
Restores this `CachedRowSet` object to its original value, that is, its value before the last set of changes.
`void`
`rollback()`
Each `CachedRowSet` object's `SyncProvider` contains a `Connection` object from the original `ResultSet` or JDBC properties passed to it.
`void`
`rollback(Savepoint s)`
Each `CachedRowSet` object's `SyncProvider` contains a `Connection` object from the original `ResultSet` or JDBC properties passed to it.
`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.
`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.
`void`
`setMetaData(RowSetMetaData md)`
Sets the metadata for this `CachedRowSet` object with the given `RowSetMetaData` object.
`void`
`setOriginalRow()`
Sets the current row in this `CachedRowSet` object as the original row.
`void`
`setPageSize(int size)`
Sets the `CachedRowSet` object's page-size.
`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.
`void`
`setSyncProvider(String provider)`
Sets the `SyncProvider` object for this `CachedRowSet` object to the one specified.
`void`
`setTableName(String tabName)`
Sets the identifier for the table from which this `CachedRowSet` object was derived to the given table name.
`int`
`size()`
Returns the number of rows in this `CachedRowSet` object.
`Collection<?>`
`toCollection()`
Converts this `CachedRowSet` object to a `Collection` object that contains all of this `CachedRowSet` object's data.
`Collection<?>`
`toCollection(int column)`
Converts the designated column in this `CachedRowSet` object to a `Collection` object.
`Collection<?>`
`toCollection(String column)`
Converts the designated column in this `CachedRowSet` object to a `Collection` object.
`void`
`undoDelete()`
Cancels the deletion of the current row and notifies listeners that a row has changed.
`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.
`void`
`undoUpdate()`
Immediately reverses the last update operation if the row has been modified.

### Methods declared in interface Joinable

`getMatchColumnIndexes, getMatchColumnNames, setMatchColumn, setMatchColumn, setMatchColumn, setMatchColumn, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn, unsetMatchColumn`
Modifier and Type
Method
Description
`int[]`
`getMatchColumnIndexes()`
Retrieves the indexes of the match columns that were set for this `RowSet` object with the method `setMatchColumn(int[] columnIdxes)`.
`String[]`
`getMatchColumnNames()`
Retrieves the names of the match columns that were set for this `RowSet` object with the method `setMatchColumn(String [] columnNames)`.
`void`
`setMatchColumn(int columnIdx)`
Sets the designated column as the match column for this `RowSet` object.
`void`
`setMatchColumn(int[] columnIdxes)`
Sets the designated columns as the match column for this `RowSet` object.
`void`
`setMatchColumn(String columnName)`
Sets the designated column as the match column for this `RowSet` object.
`void`
`setMatchColumn(String[] columnNames)`
Sets the designated columns as the match column for this `RowSet` object.
`void`
`unsetMatchColumn(int columnIdx)`
Unsets the designated column as the match column for this `RowSet` object.
`void`
`unsetMatchColumn(int[] columnIdxes)`
Unsets the designated columns as the match column for this `RowSet` object.
`void`
`unsetMatchColumn(String columnName)`
Unsets the designated column as the match column for this `RowSet` object.
`void`
`unsetMatchColumn(String[] columnName)`
Unsets the designated columns as the match columns for this `RowSet` object.

### Methods declared in interface ResultSet

`absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull`
Modifier and Type
Method
Description
`boolean`
`absolute(int row)`
Moves the cursor to the given row number in this `ResultSet` object.
`void`
`afterLast()`
Moves the cursor to the end of this `ResultSet` object, just after the last row.
`void`
`beforeFirst()`
Moves the cursor to the front of this `ResultSet` object, just before the first row.
`void`
`cancelRowUpdates()`
Cancels the updates made to the current row in this `ResultSet` object.
`void`
`clearWarnings()`
Clears all warnings reported on this `ResultSet` object.
`void`
`close()`
Releases this `ResultSet` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
`void`
`deleteRow()`
Deletes the current row from this `ResultSet` object and from the underlying database.
`int`
`findColumn(String columnLabel)`
Maps the given `ResultSet` column label to its `ResultSet` column index.
`boolean`
`first()`
Moves the cursor to the first row in this `ResultSet` object.
`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.
`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.
`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.
`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.
`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.
`BigDecimal`
`getBigDecimal(int columnIndex, int scale)`
Deprecated.
Use `getBigDecimal(int columnIndex)` or `getBigDecimal(String columnLabel)`
`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.
`BigDecimal`
`getBigDecimal(String columnLabel, int scale)`
Deprecated.
Use `getBigDecimal(int columnIndex)` or `getBigDecimal(String columnLabel)`
`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.
`InputStream`
`getBinaryStream(String columnLabel)`
Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of uninterpreted `byte`s.
`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.
`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.
`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.
`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.
`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.
`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.
`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.
`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.
`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.
`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.
`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.
`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.
`int`
`getConcurrency()`
Retrieves the concurrency mode of this `ResultSet` object.
`String`
`getCursorName()`
Retrieves the name of the SQL cursor used by this `ResultSet` object.
`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.
`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.
`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.
`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.
`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.
`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.
`int`
`getFetchDirection()`
Retrieves the fetch direction for this `ResultSet` object.
`int`
`getFetchSize()`
Retrieves the fetch size for this `ResultSet` object.
`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.
`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.
`int`
`getHoldability()`
Retrieves the holdability of this `ResultSet` object
`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.
`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.
`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.
`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.
`ResultSetMetaData`
`getMetaData()`
Retrieves the number, types and properties of this `ResultSet` object's columns.
`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.
`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.
`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.
`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.
`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.
`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.
`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.
`<T> T`
`getObject(int columnIndex, Class<T> type)`
Retrieves the value of the designated column in the current row of this `ResultSet` object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.
`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.
`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.
`<T> T`
`getObject(String columnLabel, Class<T> type)`
Retrieves the value of the designated column in the current row of this `ResultSet` object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.
`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.
`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.
`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.
`int`
`getRow()`
Retrieves the current row number.
`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.
`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.
`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.
`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.
`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.
`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.
`Statement`
`getStatement()`
Retrieves the `Statement` object that produced this `ResultSet` object.
`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.
`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.
`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.
`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.
`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.
`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.
`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.
`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.
`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.
`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.
`int`
`getType()`
Retrieves the type of this `ResultSet` object.
`InputStream`
`getUnicodeStream(int columnIndex)`
Deprecated.
use `getCharacterStream` in place of `getUnicodeStream`
`InputStream`
`getUnicodeStream(String columnLabel)`
Deprecated.
use `getCharacterStream` instead
`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.
`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.
`SQLWarning`
`getWarnings()`
Retrieves the first warning reported by calls on this `ResultSet` object.
`void`
`insertRow()`
Inserts the contents of the insert row into this `ResultSet` object and into the database.
`boolean`
`isAfterLast()`
Retrieves whether the cursor is after the last row in this `ResultSet` object.
`boolean`
`isBeforeFirst()`
Retrieves whether the cursor is before the first row in this `ResultSet` object.
`boolean`
`isClosed()`
Retrieves whether this `ResultSet` object has been closed.
`boolean`
`isFirst()`
Retrieves whether the cursor is on the first row of this `ResultSet` object.
`boolean`
`isLast()`
Retrieves whether the cursor is on the last row of this `ResultSet` object.
`boolean`
`last()`
Moves the cursor to the last row in this `ResultSet` object.
`void`
`moveToCurrentRow()`
Moves the cursor to the remembered cursor position, usually the current row.
`void`
`moveToInsertRow()`
Moves the cursor to the insert row.
`boolean`
`next()`
Moves the cursor forward one row from its current position.
`boolean`
`previous()`
Moves the cursor to the previous row in this `ResultSet` object.
`void`
`refreshRow()`
Refreshes the current row with its most recent value in the database.
`boolean`
`relative(int rows)`
Moves the cursor a relative number of rows, either positive or negative.
`boolean`
`rowDeleted()`
Retrieves whether a row has been deleted.
`boolean`
`rowInserted()`
Retrieves whether the current row has had an insertion.
`boolean`
`rowUpdated()`
Retrieves whether the current row has been updated.
`void`
`setFetchDirection(int direction)`
Gives a hint as to the direction in which the rows in this `ResultSet` object will be processed.
`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.
`void`
`updateArray(int columnIndex, Array x)`
Updates the designated column with a `java.sql.Array` value.
`void`
`updateArray(String columnLabel, Array x)`
Updates the designated column with a `java.sql.Array` value.
`void`
`updateAsciiStream(int columnIndex, InputStream x)`
Updates the designated column with an ascii stream value.
`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.
`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.
`void`
`updateAsciiStream(String columnLabel, InputStream x)`
Updates the designated column with an ascii stream value.
`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.
`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.
`void`
`updateBigDecimal(int columnIndex, BigDecimal x)`
Updates the designated column with a `java.math.BigDecimal` value.
`void`
`updateBigDecimal(String columnLabel, BigDecimal x)`
Updates the designated column with a `java.sql.BigDecimal` value.
`void`
`updateBinaryStream(int columnIndex, InputStream x)`
Updates the designated column with a binary stream value.
`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.
`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.
`void`
`updateBinaryStream(String columnLabel, InputStream x)`
Updates the designated column with a binary stream value.
`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.
`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.
`void`
`updateBlob(int columnIndex, InputStream inputStream)`
Updates the designated column using the given input stream.
`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.
`void`
`updateBlob(int columnIndex, Blob x)`
Updates the designated column with a `java.sql.Blob` value.
`void`
`updateBlob(String columnLabel, InputStream inputStream)`
Updates the designated column using the given input stream.
`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.
`void`
`updateBlob(String columnLabel, Blob x)`
Updates the designated column with a `java.sql.Blob` value.
`void`
`updateBoolean(int columnIndex, boolean x)`
Updates the designated column with a `boolean` value.
`void`
`updateBoolean(String columnLabel, boolean x)`
Updates the designated column with a `boolean` value.
`void`
`updateByte(int columnIndex, byte x)`
Updates the designated column with a `byte` value.
`void`
`updateByte(String columnLabel, byte x)`
Updates the designated column with a `byte` value.
`void`
`updateBytes(int columnIndex, byte[] x)`
Updates the designated column with a `byte` array value.
`void`
`updateBytes(String columnLabel, byte[] x)`
Updates the designated column with a byte array value.
`void`
`updateCharacterStream(int columnIndex, Reader x)`
Updates the designated column with a character stream value.
`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.
`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.
`void`
`updateCharacterStream(String columnLabel, Reader reader)`
Updates the designated column with a character stream value.
`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.
`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.
`void`
`updateClob(int columnIndex, Reader reader)`
Updates the designated column using the given `Reader` object.
`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.
`void`
`updateClob(int columnIndex, Clob x)`
Updates the designated column with a `java.sql.Clob` value.
`void`
`updateClob(String columnLabel, Reader reader)`
Updates the designated column using the given `Reader` object.
`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.
`void`
`updateClob(String columnLabel, Clob x)`
Updates the designated column with a `java.sql.Clob` value.
`void`
`updateDate(int columnIndex, Date x)`
Updates the designated column with a `java.sql.Date` value.
`void`
`updateDate(String columnLabel, Date x)`
Updates the designated column with a `java.sql.Date` value.
`void`
`updateDouble(int columnIndex, double x)`
Updates the designated column with a `double` value.
`void`
`updateDouble(String columnLabel, double x)`
Updates the designated column with a `double` value.
`void`
`updateFloat(int columnIndex, float x)`
Updates the designated column with a `float` value.
`void`
`updateFloat(String columnLabel, float x)`
Updates the designated column with a `float` value.
`void`
`updateInt(int columnIndex, int x)`
Updates the designated column with an `int` value.
`void`
`updateInt(String columnLabel, int x)`
Updates the designated column with an `int` value.
`void`
`updateLong(int columnIndex, long x)`
Updates the designated column with a `long` value.
`void`
`updateLong(String columnLabel, long x)`
Updates the designated column with a `long` value.
`void`
`updateNCharacterStream(int columnIndex, Reader x)`
Updates the designated column with a character stream value.
`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.
`void`
`updateNCharacterStream(String columnLabel, Reader reader)`
Updates the designated column with a character stream value.
`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.
`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.
`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.
`void`
`updateNClob(int columnIndex, NClob nClob)`
Updates the designated column with a `java.sql.NClob` value.
`void`
`updateNClob(String columnLabel, Reader reader)`
Updates the designated column using the given `Reader` object.
`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.
`void`
`updateNClob(String columnLabel, NClob nClob)`
Updates the designated column with a `java.sql.NClob` value.
`void`
`updateNString(int columnIndex, String nString)`
Updates the designated column with a `String` value.
`void`
`updateNString(String columnLabel, String nString)`
Updates the designated column with a `String` value.
`void`
`updateNull(int columnIndex)`
Updates the designated column with a `null` value.
`void`
`updateNull(String columnLabel)`
Updates the designated column with a `null` value.
`void`
`updateObject(int columnIndex, Object x)`
Updates the designated column with an `Object` value.
`void`
`updateObject(int columnIndex, Object x, int scaleOrLength)`
Updates the designated column with an `Object` value.
`default void`
`updateObject(int columnIndex, Object x, SQLType targetSqlType)`
Updates the designated column with an `Object` value.
`default void`
`updateObject(int columnIndex, Object x, SQLType targetSqlType, int scaleOrLength)`
Updates the designated column with an `Object` value.
`void`
`updateObject(String columnLabel, Object x)`
Updates the designated column with an `Object` value.
`void`
`updateObject(String columnLabel, Object x, int scaleOrLength)`
Updates the designated column with an `Object` value.
`default void`
`updateObject(String columnLabel, Object x, SQLType targetSqlType)`
Updates the designated column with an `Object` value.
`default void`
`updateObject(String columnLabel, Object x, SQLType targetSqlType, int scaleOrLength)`
Updates the designated column with an `Object` value.
`void`
`updateRef(int columnIndex, Ref x)`
Updates the designated column with a `java.sql.Ref` value.
`void`
`updateRef(String columnLabel, Ref x)`
Updates the designated column with a `java.sql.Ref` value.
`void`
`updateRow()`
Updates the underlying database with the new contents of the current row of this `ResultSet` object.
`void`
`updateRowId(int columnIndex, RowId x)`
Updates the designated column with a `RowId` value.
`void`
`updateRowId(String columnLabel, RowId x)`
Updates the designated column with a `RowId` value.
`void`
`updateShort(int columnIndex, short x)`
Updates the designated column with a `short` value.
`void`
`updateShort(String columnLabel, short x)`
Updates the designated column with a `short` value.
`void`
`updateSQLXML(int columnIndex, SQLXML xmlObject)`
Updates the designated column with a `java.sql.SQLXML` value.
`void`
`updateSQLXML(String columnLabel, SQLXML xmlObject)`
Updates the designated column with a `java.sql.SQLXML` value.
`void`
`updateString(int columnIndex, String x)`
Updates the designated column with a `String` value.
`void`
`updateString(String columnLabel, String x)`
Updates the designated column with a `String` value.
`void`
`updateTime(int columnIndex, Time x)`
Updates the designated column with a `java.sql.Time` value.
`void`
`updateTime(String columnLabel, Time x)`
Updates the designated column with a `java.sql.Time` value.
`void`
`updateTimestamp(int columnIndex, Timestamp x)`
Updates the designated column with a `java.sql.Timestamp` value.
`void`
`updateTimestamp(String columnLabel, Timestamp x)`
Updates the designated column with a `java.sql.Timestamp` value.
`boolean`
`wasNull()`
Reports whether the last column read had a value of SQL `NULL`.

### Methods declared in interface RowSet

`addRowSetListener, clearParameters, execute, getCommand, getDataSourceName, getEscapeProcessing, getMaxFieldSize, getMaxRows, getPassword, getQueryTimeout, getTransactionIsolation, getTypeMap, getUrl, getUsername, isReadOnly, removeRowSetListener, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBlob, setBlob, setBlob, setBoolean, setBoolean, setByte, setByte, setBytes, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setClob, setClob, setClob, setCommand, setConcurrency, setDataSourceName, setDate, setDate, setDate, setDate, setDouble, setDouble, setEscapeProcessing, setFloat, setFloat, setInt, setInt, setLong, setLong, setMaxFieldSize, setMaxRows, setNCharacterStream, setNCharacterStream, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNClob, setNClob, setNClob, setNString, setNString, setNull, setNull, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setObject, setPassword, setQueryTimeout, setReadOnly, setRef, setRowId, setRowId, setShort, setShort, setSQLXML, setSQLXML, setString, setString, setTime, setTime, setTime, setTime, setTimestamp, setTimestamp, setTimestamp, setTimestamp, setTransactionIsolation, setType, setTypeMap, setUrl, setURL, setUsername`
Modifier and Type
Method
Description
`void`
`addRowSetListener(RowSetListener listener)`
Registers the given listener so that it will be notified of events that occur on this `RowSet` object.
`void`
`clearParameters()`
Clears the parameters set for this `RowSet` object's command.
`void`
`execute()`
Fills this `RowSet` object with data.
`String`
`getCommand()`
Retrieves this `RowSet` object's command property.
`String`
`getDataSourceName()`
Retrieves the logical name that identifies the data source for this `RowSet` object.
`boolean`
`getEscapeProcessing()`
Retrieves whether escape processing is enabled for this `RowSet` object.
`int`
`getMaxFieldSize()`
Retrieves the maximum number of bytes that may be returned for certain column values.
`int`
`getMaxRows()`
Retrieves the maximum number of rows that this `RowSet` object can contain.
`String`
`getPassword()`
Retrieves the password used to create a database connection.
`int`
`getQueryTimeout()`
Retrieves the maximum number of seconds the driver will wait for a statement to execute.
`int`
`getTransactionIsolation()`
Retrieves the transaction isolation level set for this `RowSet` object.
`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.
`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.
`String`
`getUsername()`
Retrieves the username used to create a database connection for this `RowSet` object.
`boolean`
`isReadOnly()`
Retrieves whether this `RowSet` object is read-only.
`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.
`void`
`setArray(int i, Array x)`
Sets the designated parameter in this `RowSet` object's command with the given `Array` value.
`void`
`setAsciiStream(int parameterIndex, InputStream x)`
Sets the designated parameter in this `RowSet` object's command to the given input stream.
`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.
`void`
`setAsciiStream(String parameterName, InputStream x)`
Sets the designated parameter to the given input stream.
`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.
`void`
`setBigDecimal(int parameterIndex, BigDecimal x)`
Sets the designated parameter in this `RowSet` object's command to the given `java.math.BigDecimal` value.
`void`
`setBigDecimal(String parameterName, BigDecimal x)`
Sets the designated parameter to the given `java.math.BigDecimal` value.
`void`
`setBinaryStream(int parameterIndex, InputStream x)`
Sets the designated parameter in this `RowSet` object's command to the given input stream.
`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.
`void`
`setBinaryStream(String parameterName, InputStream x)`
Sets the designated parameter to the given input stream.
`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.
`void`
`setBlob(int parameterIndex, InputStream inputStream)`
Sets the designated parameter to a `InputStream` object.
`void`
`setBlob(int parameterIndex, InputStream inputStream, long length)`
Sets the designated parameter to a `InputStream` object.
`void`
`setBlob(int i, Blob x)`
Sets the designated parameter in this `RowSet` object's command with the given `Blob` value.
`void`
`setBlob(String parameterName, InputStream inputStream)`
Sets the designated parameter to a `InputStream` object.
`void`
`setBlob(String parameterName, InputStream inputStream, long length)`
Sets the designated parameter to a `InputStream` object.
`void`
`setBlob(String parameterName, Blob x)`
Sets the designated parameter to the given `java.sql.Blob` object.
`void`
`setBoolean(int parameterIndex, boolean x)`
Sets the designated parameter in this `RowSet` object's command to the given Java `boolean` value.
`void`
`setBoolean(String parameterName, boolean x)`
Sets the designated parameter to the given Java `boolean` value.
`void`
`setByte(int parameterIndex, byte x)`
Sets the designated parameter in this `RowSet` object's command to the given Java `byte` value.
`void`
`setByte(String parameterName, byte x)`
Sets the designated parameter to the given Java `byte` value.
`void`
`setBytes(int parameterIndex, byte[] x)`
Sets the designated parameter in this `RowSet` object's command to the given Java array of `byte` values.
`void`
`setBytes(String parameterName, byte[] x)`
Sets the designated parameter to the given Java array of bytes.
`void`
`setCharacterStream(int parameterIndex, Reader reader)`
Sets the designated parameter in this `RowSet` object's command to the given `Reader` object.
`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.
`void`
`setCharacterStream(String parameterName, Reader reader)`
Sets the designated parameter to the given `Reader` object.
`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.
`void`
`setClob(int parameterIndex, Reader reader)`
Sets the designated parameter to a `Reader` object.
`void`
`setClob(int parameterIndex, Reader reader, long length)`
Sets the designated parameter to a `Reader` object.
`void`
`setClob(int i, Clob x)`
Sets the designated parameter in this `RowSet` object's command with the given `Clob` value.
`void`
`setClob(String parameterName, Reader reader)`
Sets the designated parameter to a `Reader` object.
`void`
`setClob(String parameterName, Reader reader, long length)`
Sets the designated parameter to a `Reader` object.
`void`
`setClob(String parameterName, Clob x)`
Sets the designated parameter to the given `java.sql.Clob` object.
`void`
`setCommand(String cmd)`
Sets this `RowSet` object's command property to the given SQL query.
`void`
`setConcurrency(int concurrency)`
Sets the concurrency of this `RowSet` object to the given concurrency level.
`void`
`setDataSourceName(String name)`
Sets the data source name property for this `RowSet` object to the given `String`.
`void`
`setDate(int parameterIndex, Date x)`
Sets the designated parameter in this `RowSet` object's command to the given `java.sql.Date` value.
`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.
`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.
`void`
`setDate(String parameterName, Date x, Calendar cal)`
Sets the designated parameter to the given `java.sql.Date` value, using the given `Calendar` object.
`void`
`setDouble(int parameterIndex, double x)`
Sets the designated parameter in this `RowSet` object's command to the given Java `double` value.
`void`
`setDouble(String parameterName, double x)`
Sets the designated parameter to the given Java `double` value.
`void`
`setEscapeProcessing(boolean enable)`
Sets escape processing for this `RowSet` object on or off.
`void`
`setFloat(int parameterIndex, float x)`
Sets the designated parameter in this `RowSet` object's command to the given Java `float` value.
`void`
`setFloat(String parameterName, float x)`
Sets the designated parameter to the given Java `float` value.
`void`
`setInt(int parameterIndex, int x)`
Sets the designated parameter in this `RowSet` object's command to the given Java `int` value.
`void`
`setInt(String parameterName, int x)`
Sets the designated parameter to the given Java `int` value.
`void`
`setLong(int parameterIndex, long x)`
Sets the designated parameter in this `RowSet` object's command to the given Java `long` value.
`void`
`setLong(String parameterName, long x)`
Sets the designated parameter to the given Java `long` value.
`void`
`setMaxFieldSize(int max)`
Sets the maximum number of bytes that can be returned for a column value to the given number of bytes.
`void`
`setMaxRows(int max)`
Sets the maximum number of rows that this `RowSet` object can contain to the specified number.
`void`
`setNCharacterStream(int parameterIndex, Reader value)`
Sets the designated parameter in this `RowSet` object's command to a `Reader` object.
`void`
`setNCharacterStream(int parameterIndex, Reader value, long length)`
Sets the designated parameter to a `Reader` object.
`void`
`setNCharacterStream(String parameterName, Reader value)`
Sets the designated parameter to a `Reader` object.
`void`
`setNCharacterStream(String parameterName, Reader value, long length)`
Sets the designated parameter to a `Reader` object.
`void`
`setNClob(int parameterIndex, Reader reader)`
Sets the designated parameter to a `Reader` object.
`void`
`setNClob(int parameterIndex, Reader reader, long length)`
Sets the designated parameter to a `Reader` object.
`void`
`setNClob(int parameterIndex, NClob value)`
Sets the designated parameter to a `java.sql.NClob` object.
`void`
`setNClob(String parameterName, Reader reader)`
Sets the designated parameter to a `Reader` object.
`void`
`setNClob(String parameterName, Reader reader, long length)`
Sets the designated parameter to a `Reader` object.
`void`
`setNClob(String parameterName, NClob value)`
Sets the designated parameter to a `java.sql.NClob` object.
`void`
`setNString(int parameterIndex, String value)`
Sets the designated parameter to the given `String` object.
`void`
`setNString(String parameterName, String value)`
Sets the designated parameter to the given `String` object.
`void`
`setNull(int parameterIndex, int sqlType)`
Sets the designated parameter in this `RowSet` object's SQL command to SQL `NULL`.
`void`
`setNull(int paramIndex, int sqlType, String typeName)`
Sets the designated parameter in this `RowSet` object's SQL command to SQL `NULL`.
`void`
`setNull(String parameterName, int sqlType)`
Sets the designated parameter to SQL `NULL`.
`void`
`setNull(String parameterName, int sqlType, String typeName)`
Sets the designated parameter to SQL `NULL`.
`void`
`setObject(int parameterIndex, Object x)`
Sets the designated parameter in this `RowSet` object's command with a Java `Object`.
`void`
`setObject(int parameterIndex, Object x, int targetSqlType)`
Sets the designated parameter in this `RowSet` object's command with a Java `Object`.
`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`.
`void`
`setObject(String parameterName, Object x)`
Sets the value of the designated parameter with the given object.
`void`
`setObject(String parameterName, Object x, int targetSqlType)`
Sets the value of the designated parameter with the given object.
`void`
`setObject(String parameterName, Object x, int targetSqlType, int scale)`
Sets the value of the designated parameter with the given object.
`void`
`setPassword(String password)`
Sets the database password for this `RowSet` object to the given `String`.
`void`
`setQueryTimeout(int seconds)`
Sets the maximum time the driver will wait for a statement to execute to the given number of seconds.
`void`
`setReadOnly(boolean value)`
Sets whether this `RowSet` object is read-only to the given `boolean`.
`void`
`setRef(int i, Ref x)`
Sets the designated parameter in this `RowSet` object's command with the given `Ref` value.
`void`
`setRowId(int parameterIndex, RowId x)`
Sets the designated parameter to the given `java.sql.RowId` object.
`void`
`setRowId(String parameterName, RowId x)`
Sets the designated parameter to the given `java.sql.RowId` object.
`void`
`setShort(int parameterIndex, short x)`
Sets the designated parameter in this `RowSet` object's command to the given Java `short` value.
`void`
`setShort(String parameterName, short x)`
Sets the designated parameter to the given Java `short` value.
`void`
`setSQLXML(int parameterIndex, SQLXML xmlObject)`
Sets the designated parameter to the given `java.sql.SQLXML` object.
`void`
`setSQLXML(String parameterName, SQLXML xmlObject)`
Sets the designated parameter to the given `java.sql.SQLXML` object.
`void`
`setString(int parameterIndex, String x)`
Sets the designated parameter in this `RowSet` object's command to the given Java `String` value.
`void`
`setString(String parameterName, String x)`
Sets the designated parameter to the given Java `String` value.
`void`
`setTime(int parameterIndex, Time x)`
Sets the designated parameter in this `RowSet` object's command to the given `java.sql.Time` value.
`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.
`void`
`setTime(String parameterName, Time x)`
Sets the designated parameter to the given `java.sql.Time` value.
`void`
`setTime(String parameterName, Time x, Calendar cal)`
Sets the designated parameter to the given `java.sql.Time` value, using the given `Calendar` object.
`void`
`setTimestamp(int parameterIndex, Timestamp x)`
Sets the designated parameter in this `RowSet` object's command to the given `java.sql.Timestamp` value.
`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.
`void`
`setTimestamp(String parameterName, Timestamp x)`
Sets the designated parameter to the given `java.sql.Timestamp` value.
`void`
`setTimestamp(String parameterName, Timestamp x, Calendar cal)`
Sets the designated parameter to the given `java.sql.Timestamp` value, using the given `Calendar` object.
`void`
`setTransactionIsolation(int level)`
Sets the transaction isolation level for this `RowSet` object.
`void`
`setType(int type)`
Sets the type of this `RowSet` object to the given type.
`void`
`setTypeMap(Map<String,Class<?>> map)`
Installs the given `java.util.Map` object as the default type map for this `RowSet` object.
`void`
`setUrl(String url)`
Sets the URL this `RowSet` object will use when it uses the `DriverManager` to create a connection.
`void`
`setURL(int parameterIndex, URL x)`
Sets the designated parameter to the given `java.net.URL` value.
`void`
`setUsername(String name)`
Sets the username property for this `RowSet` object to the given `String`.

### Methods declared in interface WebRowSet

`readXml, readXml, writeXml, writeXml, writeXml, writeXml`
Modifier and Type
Method
Description
`void`
`readXml(InputStream iStream)`
Reads a stream based XML input to populate this `WebRowSet` object.
`void`
`readXml(Reader reader)`
Reads a `WebRowSet` object in its XML format from the given `Reader` object.
`void`
`writeXml(OutputStream oStream)`
Writes the data, properties, and metadata for this `WebRowSet` object to the given `OutputStream` object in XML format.
`void`
`writeXml(Writer writer)`
Writes the data, properties, and metadata for this `WebRowSet` object to the given `Writer` object in XML format.
`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.
`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.

### Methods declared in interface Wrapper

`isWrapperFor, unwrap`
Modifier and Type
Method
Description
`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.
`<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.

## Field Details

### CROSS_JOIN

static final int CROSS_JOIN
An ANSI-style `JOIN` providing a cross product of two tables

See Also:
  - Constant Field Values

### INNER_JOIN

static final int INNER_JOIN
An ANSI-style `JOIN` providing a inner join between two tables. Any unmatched rows in either table of the join should be discarded.

See Also:
  - Constant Field Values

### LEFT_OUTER_JOIN

static final int LEFT_OUTER_JOIN
An ANSI-style `JOIN` providing a left outer join between two tables. In SQL, this is described where all records should be returned from the left side of the JOIN statement.

See Also:
  - Constant Field Values

### RIGHT_OUTER_JOIN

static final int RIGHT_OUTER_JOIN
An ANSI-style `JOIN` providing a right outer join between two tables. In SQL, this is described where all records from the table on the right side of the JOIN statement even if the table on the left has no matching record.

See Also:
  - Constant Field Values

### FULL_JOIN

static final int FULL_JOIN
An ANSI-style `JOIN` providing a full JOIN. Specifies that all rows from either table be returned regardless of matching records on the other table.

See Also:
  - Constant Field Values

## Method Details

### addRowSet

void addRowSet(Joinable rowset) throws SQLException
Adds the given `RowSet` object to this `JoinRowSet` object. If the `RowSet` object is the first to be added to this `JoinRowSet` object, it forms the basis of the `JOIN` relationship to be established.

This method should be used only when the given `RowSet` object already has a match column that was set with the `Joinable` method `setMatchColumn`.

Note: A `Joinable` object is any `RowSet` object that has implemented the `Joinable` interface.

Parameters:
  `rowset` - the `RowSet` object that is to be added to this `JoinRowSet` object; it must implement the `Joinable` interface and have a match column set
Throws:
  `SQLException` - if (1) an empty rowset is added to the to this `JoinRowSet` object, (2) a match column has not been set for rowset, or (3) rowset violates the active `JOIN`
See Also:
  - `Joinable.setMatchColumn(int)`

### addRowSet

void addRowSet(RowSet rowset, int columnIdx) throws SQLException
Adds the given `RowSet` object to this `JoinRowSet` object and sets the designated column as the match column for the `RowSet` object. If the `RowSet` object is the first to be added to this `JoinRowSet` object, it forms the basis of the `JOIN` relationship to be established.

This method should be used when RowSet does not already have a match column set.

Parameters:
  `rowset` - the `RowSet` object that is to be added to this `JoinRowSet` object; it may implement the `Joinable` interface
  `columnIdx` - an `int` that identifies the column to become the match column
Throws:
  `SQLException` - if (1) rowset is an empty rowset or (2) rowset violates the active `JOIN`
See Also:
  - `Joinable.unsetMatchColumn(int)`

### addRowSet

void addRowSet(RowSet rowset, String columnName) throws SQLException
Adds rowset to this `JoinRowSet` object and sets the designated column as the match column. If rowset is the first to be added to this `JoinRowSet` object, it forms the basis for the `JOIN` relationship to be established.

This method should be used when the given `RowSet` object does not already have a match column.

Parameters:
  `rowset` - the `RowSet` object that is to be added to this `JoinRowSet` object; it may implement the `Joinable` interface
  `columnName` - the `String` object giving the name of the column to be set as the match column
Throws:
  `SQLException` - if (1) rowset is an empty rowset or (2) the match column for rowset does not satisfy the conditions of the `JOIN`

### addRowSet

void addRowSet(RowSet[] rowset, int[] columnIdx) throws SQLException
Adds one or more `RowSet` objects contained in the given array of `RowSet` objects to this `JoinRowSet` object and sets the match column for each of the `RowSet` objects to the match columns in the given array of column indexes. The first element in columnIdx is set as the match column for the first `RowSet` object in rowset, the second element of columnIdx is set as the match column for the second element in rowset, and so on.

The first `RowSet` object added to this `JoinRowSet` object forms the basis for the `JOIN` relationship.

This method should be used when the given `RowSet` object does not already have a match column.

Parameters:
  `rowset` - an array of one or more `RowSet` objects to be added to the `JOIN`; it may implement the `Joinable` interface
  `columnIdx` - an array of `int` values indicating the index(es) of the columns to be set as the match columns for the `RowSet` objects in rowset
Throws:
  `SQLException` - if (1) an empty rowset is added to this `JoinRowSet` object, (2) a match column is not set for a `RowSet` object in rowset, or (3) a `RowSet` object being added violates the active `JOIN`

### addRowSet

void addRowSet(RowSet[] rowset, String[] columnName) throws SQLException
Adds one or more `RowSet` objects contained in the given array of `RowSet` objects to this `JoinRowSet` object and sets the match column for each of the `RowSet` objects to the match columns in the given array of column names. The first element in columnName is set as the match column for the first `RowSet` object in rowset, the second element of columnName is set as the match column for the second element in rowset, and so on.

The first `RowSet` object added to this `JoinRowSet` object forms the basis for the `JOIN` relationship.

This method should be used when the given `RowSet` object(s) does not already have a match column.

Parameters:
  `rowset` - an array of one or more `RowSet` objects to be added to the `JOIN`; it may implement the `Joinable` interface
  `columnName` - an array of `String` values indicating the names of the columns to be set as the match columns for the `RowSet` objects in rowset
Throws:
  `SQLException` - if (1) an empty rowset is added to this `JoinRowSet` object, (2) a match column is not set for a `RowSet` object in rowset, or (3) a `RowSet` object being added violates the active `JOIN`

### getRowSets

Collection<?> getRowSets() throws SQLException
Returns a `Collection` object containing the `RowSet` objects that have been added to this `JoinRowSet` object. This should return the 'n' number of RowSet contained within the `JOIN` and maintain any updates that have occurred while in this union.

Returns:
  a `Collection` object consisting of the `RowSet` objects added to this `JoinRowSet` object
Throws:
  `SQLException` - if an error occurs generating the `Collection` object to be returned

### getRowSetNames

String[] getRowSetNames() throws SQLException
Returns a `String` array containing the names of the `RowSet` objects added to this `JoinRowSet` object.

Returns:
  a `String` array of the names of the `RowSet` objects in this `JoinRowSet` object
Throws:
  `SQLException` - if an error occurs retrieving the names of the `RowSet` objects
See Also:
  - `CachedRowSet.setTableName(String)`

### toCachedRowSet

CachedRowSet toCachedRowSet() throws SQLException
Creates a new `CachedRowSet` object containing the data in this `JoinRowSet` object, which can be saved to a data source using the `SyncProvider` object for the `CachedRowSet` object.

If any updates or modifications have been applied to the JoinRowSet the CachedRowSet returned by the method will not be able to persist it's changes back to the originating rows and tables in the in the datasource. The CachedRowSet instance returned should not contain modification data and it should clear all properties of it's originating SQL statement. An application should reset the SQL statement using the `RowSet.setCommand` method.

In order to allow changes to be persisted back to the datasource to the originating tables, the `acceptChanges` method should be used and called on a JoinRowSet object instance. Implementations can leverage the internal data and update tracking in their implementations to interact with the SyncProvider to persist any changes.

Returns:
  a CachedRowSet containing the contents of the JoinRowSet
Throws:
  `SQLException` - if an error occurs assembling the CachedRowSet object
See Also:
  - `RowSet`
  - `CachedRowSet`
  - `SyncProvider`

### supportsCrossJoin

boolean supportsCrossJoin()
Indicates if CROSS_JOIN is supported by a JoinRowSet implementation

Returns:
  true if the CROSS_JOIN is supported; false otherwise

### supportsInnerJoin

boolean supportsInnerJoin()
Indicates if INNER_JOIN is supported by a JoinRowSet implementation

Returns:
  true is the INNER_JOIN is supported; false otherwise

### supportsLeftOuterJoin

boolean supportsLeftOuterJoin()
Indicates if LEFT_OUTER_JOIN is supported by a JoinRowSet implementation

Returns:
  true is the LEFT_OUTER_JOIN is supported; false otherwise

### supportsRightOuterJoin

boolean supportsRightOuterJoin()
Indicates if RIGHT_OUTER_JOIN is supported by a JoinRowSet implementation

Returns:
  true is the RIGHT_OUTER_JOIN is supported; false otherwise

### supportsFullJoin

boolean supportsFullJoin()
Indicates if FULL_JOIN is supported by a JoinRowSet implementation

Returns:
  true is the FULL_JOIN is supported; false otherwise

### setJoinType

void setJoinType(int joinType) throws SQLException
Allow the application to adjust the type of `JOIN` imposed on tables contained within the JoinRowSet object instance. Implementations should throw a SQLException if they do not support a given `JOIN` type.

Parameters:
  `joinType` - the standard JoinRowSet.XXX static field definition of a SQL `JOIN` to re-configure a JoinRowSet instance on the fly.
Throws:
  `SQLException` - if an unsupported `JOIN` type is set
See Also:
  - `getJoinType()`

### getWhereClause

String getWhereClause() throws SQLException
Return a SQL-like description of the WHERE clause being used in a JoinRowSet object. 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`

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

### getJoinType

int getJoinType() throws SQLException
Returns a `int` describing the set SQL `JOIN` type governing this JoinRowSet instance. The returned type will be one of standard JoinRowSet types: `CROSS_JOIN`, `INNER_JOIN`, `LEFT_OUTER_JOIN`, `RIGHT_OUTER_JOIN` or `FULL_JOIN`.

Returns:
  joinType one of the standard JoinRowSet static field definitions of a SQL `JOIN`. `JoinRowSet.INNER_JOIN` is returned as the default `JOIN` type is no type has been explicitly set.
Throws:
  `SQLException` - if an error occurs determining the SQL `JOIN` type supported by the JoinRowSet instance.
See Also:
  - `setJoinType(int)`