# Interface JdbcRowSet

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

public interface JdbcRowSet extends RowSet, Joinable
The standard interface that all standard implementations of `JdbcRowSet` must implement.

## 1.0 Overview

A wrapper around a `ResultSet` object that makes it possible to use the result set as a JavaBeans component. Thus, a `JdbcRowSet` object can be one of the Beans that a tool makes available for composing an application. Because a `JdbcRowSet` is a connected rowset, that is, it continually maintains its connection to a database using a JDBC technology-enabled driver, it also effectively makes the driver a JavaBeans component.

Because it is always connected to its database, an instance of `JdbcRowSet` can simply take calls invoked on it and in turn call them on its `ResultSet` object. As a consequence, a result set can, for example, be a component in a Swing application.

Another advantage of a `JdbcRowSet` object is that it can be used to make a `ResultSet` object scrollable and updatable. All `RowSet` objects are by default scrollable and updatable. If the driver and database being used do not support scrolling and/or updating of result sets, an application can populate a `JdbcRowSet` object with the data of a `ResultSet` object and then operate on the `JdbcRowSet` object as if it were the `ResultSet` object.

## 2.0 Creating a `JdbcRowSet` Object

The reference implementation of the `JdbcRowSet` interface, `JdbcRowSetImpl`, provides an implementation of the default constructor. A new instance is initialized with default values, which can be set with new values as needed. A new instance is not really functional until its `execute` method is called. In general, this method does the following:

- establishes a connection with a database
- creates a `PreparedStatement` object and sets any of its placeholder parameters
- executes the statement to create a `ResultSet` object

If the `execute` method is successful, it will set the appropriate private `JdbcRowSet` fields with the following:

- a `Connection` object -- the connection between the rowset and the database
- a `PreparedStatement` object -- the query that produces the result set
- a `ResultSet` object -- the result set that the rowset's command produced and that is being made, in effect, a JavaBeans component

If these fields have not been set, meaning that the `execute` method has not executed successfully, no methods other than `execute` and `close` may be called on the rowset. All other public methods will throw an exception.

Before calling the `execute` method, however, the command and properties needed for establishing a connection must be set. The following code fragment creates a `JdbcRowSetImpl` object, sets the command and connection properties, sets the placeholder parameter, and then invokes the method `execute`.

        JdbcRowSetImpl jrs = new JdbcRowSetImpl();
        jrs.setCommand("SELECT * FROM TITLES WHERE TYPE = ?");
        jrs.setURL("jdbc:myDriver:myAttribute");
        jrs.setUsername("cervantes");
        jrs.setPassword("sancho");
        jrs.setString(1, "BIOGRAPHY");
        jrs.execute();

The variable `jrs` now represents an instance of `JdbcRowSetImpl` that is a thin wrapper around the `ResultSet` object containing all the rows in the table `TITLES` where the type of book is biography. At this point, operations called on `jrs` will affect the rows in the result set, which is effectively a JavaBeans component.

The implementation of the `RowSet` method `execute` in the `JdbcRowSet` reference implementation differs from that in the `CachedRowSet` reference implementation to account for the different requirements of connected and disconnected `RowSet` objects.

Since:
  1.5

## Field Summary

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

## Method Summary

Modifier and Type
Method
Description
`void`
`commit()`
Each `JdbcRowSet` contains a `Connection` object from the `ResultSet` or JDBC properties passed to it's constructors.
`boolean`
`getAutoCommit()`
Each `JdbcRowSet` contains a `Connection` object from the original `ResultSet` or JDBC properties passed to it.
`RowSetWarning`
`getRowSetWarnings()`
Retrieves the first warning reported by calls on this `JdbcRowSet` object.
`boolean`
`getShowDeleted()`
Retrieves a `boolean` indicating whether rows marked for deletion appear in the set of current rows.
`void`
`rollback()`
Each `JdbcRowSet` contains a `Connection` object from the original `ResultSet` or JDBC properties passed to it.
`void`
`rollback(Savepoint s)`
Each `JdbcRowSet` contains a `Connection` object from the original `ResultSet` or JDBC properties passed to it.
`void`
`setAutoCommit(boolean autoCommit)`
Each `JdbcRowSet` contains a `Connection` object from the original `ResultSet` or JDBC properties passed to it.
`void`
`setShowDeleted(boolean b)`
Sets the property `showDeleted` to the given `boolean` value.

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

## Method Details

### getShowDeleted

boolean getShowDeleted() throws SQLException
Retrieves a `boolean` indicating whether rows marked for deletion appear in the set of current rows. If `true` is returned, deleted rows are visible with the current rows. If `false` is returned, rows are not visible with the set of current rows. The default value is `false`.

Standard rowset implementations may choose to restrict this behavior for security considerations or for certain deployment scenarios. The visibility of deleted rows is implementation-defined and does not represent standard behavior.

Note: Allowing deleted rows to remain visible complicates the behavior of some standard JDBC `RowSet` implementations methods. However, most rowset users can simply ignore this extra detail because only very specialized applications will likely want to take advantage of this feature.

Returns:
  `true` if deleted rows are visible; `false` otherwise
Throws:
  `SQLException` - if a rowset implementation is unable to to determine whether rows marked for deletion remain visible
See Also:
  - `setShowDeleted(boolean)`

### setShowDeleted

void setShowDeleted(boolean b) throws SQLException
Sets the property `showDeleted` to the given `boolean` value. This property determines whether rows marked for deletion continue to appear in the set of current rows. If the value is set to `true`, deleted rows are immediately visible with the set of current rows. If the value is set to `false`, the deleted rows are set as invisible with the current set of rows.

Standard rowset implementations may choose to restrict this behavior for security considerations or for certain deployment scenarios. This is left as implementation-defined and does not represent standard behavior.

Parameters:
  `b` - `true` if deleted rows should be shown; `false` otherwise
Throws:
  `SQLException` - if a rowset implementation is unable to to reset whether deleted rows should be visible
See Also:
  - `getShowDeleted()`

### getRowSetWarnings

RowSetWarning getRowSetWarnings() throws SQLException
Retrieves the first warning reported by calls on this `JdbcRowSet` object. If a second warning was reported on this `JdbcRowSet` object, it will be chained to the first warning and can be retrieved by calling the method `RowSetWarning.getNextWarning` on the first warning. Subsequent warnings on this `JdbcRowSet` object will be chained to the `RowSetWarning` objects returned by the method `RowSetWarning.getNextWarning`. The warning chain is automatically cleared each time a new row is read. This method may not be called on a `RowSet` object that has been closed; doing so will cause an `SQLException` to be thrown.

Because it is always connected to its data source, a `JdbcRowSet` object can rely on the presence of active `Statement`, `Connection`, and `ResultSet` instances. This means that applications can obtain additional `SQLWarning` notifications by calling the `getNextWarning` methods that they provide. Disconnected `Rowset` objects, such as a `CachedRowSet` object, do not have access to these `getNextWarning` methods.

Returns:
  the first `RowSetWarning` object reported on this `JdbcRowSet` object or `null` if there are none
Throws:
  `SQLException` - if this method is called on a closed `JdbcRowSet` object
See Also:
  - `RowSetWarning`

### commit

void commit() throws SQLException
Each `JdbcRowSet` contains a `Connection` object from the `ResultSet` or JDBC properties passed to it's constructors. This method wraps the `Connection` commit method to allow flexible auto commit or non auto commit transactional control support.

Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by this Connection object. This method should be used only when auto-commit mode has been disabled.

Throws:
  `SQLException` - if a database access error occurs or this Connection object within this `JdbcRowSet` is in auto-commit mode
See Also:
  - `Connection.setAutoCommit(boolean)`

### getAutoCommit

boolean getAutoCommit() throws SQLException
Each `JdbcRowSet` contains a `Connection` object from the original `ResultSet` or JDBC properties passed to it. This method wraps the `Connection`'s `getAutoCommit` method to allow an application to determine the `JdbcRowSet` transaction behavior.

Sets this connection's auto-commit mode to the given state. If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions. Otherwise, its SQL statements are grouped into transactions that are terminated by a call to either the method commit or the method rollback. By default, new connections are in auto-commit mode.

Returns:
  `true` if auto-commit is enabled; `false` otherwise
Throws:
  `SQLException` - if a database access error occurs
See Also:
  - `Connection.getAutoCommit()`

### setAutoCommit

void setAutoCommit(boolean autoCommit) throws SQLException
Each `JdbcRowSet` contains a `Connection` object from the original `ResultSet` or JDBC properties passed to it. This method wraps the `Connection`'s `getAutoCommit` method to allow an application to set the `JdbcRowSet` transaction behavior.

Sets the current auto-commit mode for this `Connection` object.

Parameters:
  `autoCommit` - `true` to enable auto-commit; `false` to disable auto-commit
Throws:
  `SQLException` - if a database access error occurs
See Also:
  - `Connection.setAutoCommit(boolean)`

### rollback

void rollback() throws SQLException
Each `JdbcRowSet` contains a `Connection` object from the original `ResultSet` or JDBC properties passed to it. Undoes all changes made in the current transaction and releases any database locks currently held by this `Connection` object. This method should be used only when auto-commit mode has been disabled.

Throws:
  `SQLException` - if a database access error occurs or this `Connection` object within this `JdbcRowSet` is in auto-commit mode.
See Also:
  - `rollback(Savepoint)`

### rollback

void rollback(Savepoint s) throws SQLException
Each `JdbcRowSet` contains a `Connection` object from the original `ResultSet` or JDBC properties passed to it. Undoes all changes made in the current transaction to the last set savepoint and releases any database locks currently held by this `Connection` object. This method should be used only when auto-commit mode has been disabled.

Parameters:
  `s` - The `Savepoint` to rollback to
Throws:
  `SQLException` - if a database access error occurs or this `Connection` object within this `JdbcRowSet` is in auto-commit mode.
See Also:
  - `rollback()`