RowSet (moe.ios.core API)

All Superinterfaces:

AutoCloseable, ResultSet, Wrapper
```
public interface RowSet
extends ResultSet
```
An interface which provides means to access data which persists on a database. It extends the functionality of ResultSet into a form that it can be used as a JavaBean component, suited for a visual programming environment.
RowSet provides getters and setters for properties relating to the general database environment together with the getters and setters for distinct data values which constitute the row set. The RowSet class supports JavaBean events so that other components in an application can be informed when changes happen such as changes in data values.
RowSet is a facility implemented on top of the remainder of the JDBC API. It may be connected, maintaining a connection to the database throughout its lifecycle. The changes made on a disconnected RowSet on the other hand can be persisted only establishing a new connection with the database each time.
Disconnected RowSets make use of RowSetReaders to populate the RowSet with data, possibly from a non-relational database source. They may also use RowSetWriters to send data back to the underlying data store. There is considerable freedom in the way that RowSetReaders and RowSetWriters may be implemented to retrieve and store data.

See Also:

RowSetReader, RowSetWriter

Field Summary
- Fields inherited from interface java.sql.ResultSet
  CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`void`	`addRowSetListener(RowSetListener theListener)` Registers the supplied `RowSetListener` with this `RowSet`.
`void`	`clearParameters()` Clears the parameters previously set for this `RowSet`.
`void`	`execute()` Fetches data for this `RowSet` from the database.
`String`	`getCommand()` Gets the `RowSet`'s command property.
`String`	`getDataSourceName()` Gets the ODBC Data Source Name property associated with this `RowSet`.
`boolean`	`getEscapeProcessing()` Reports if escape processing is enabled for this `RowSet`.
`int`	`getMaxFieldSize()` Gets the maximum number of bytes that can be returned for column values which are of type `BINARY`, `VARBINARY`, `LONGVARBINARYBINARY`, `CHAR`, `VARCHAR`, or `LONGVARCHAR`.
`int`	`getMaxRows()` Gets the maximum number of rows for this `RowSet`.
`String`	`getPassword()` Gets the value of the password property for this `RowSet`.
`int`	`getQueryTimeout()` Gets the timeout for the driver when a query operation is executed.
`int`	`getTransactionIsolation()` Gets the transaction isolation level property set for this `RowSet`.
`Map<String,Class<?>>`	`getTypeMap()` Gets the custom mapping of SQL User-Defined Types (UDTs) and Java classes for this `RowSet`, if applicable.
`String`	`getUrl()` Gets the URL property value for this `RowSet`.
`String`	`getUsername()` Gets the value of the `username` property for this `RowSet`.
`boolean`	`isReadOnly()` Indicates if this `RowSet` is read-only.
`void`	`removeRowSetListener(RowSetListener theListener)` Removes a specified `RowSetListener` object from the set of listeners which will be notified of events by this `RowSet`.
`void`	`setArray(int parameterIndex, Array theArray)` Sets the specified `ARRAY` parameter in the `RowSet` command with the supplied `java.sql.Array` value.
`void`	`setAsciiStream(int parameterIndex, InputStream theInputStream)` Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value.
`void`	`setAsciiStream(int parameterIndex, InputStream theInputStream, int length)` Sets the value of the specified parameter in the `RowSet` command with the ASCII data in the supplied `java.io.InputStream` value.
`void`	`setAsciiStream(String parameterName, InputStream theInputStream)` Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value.
`void`	`setAsciiStream(String parameterName, InputStream theInputStream, int length)` Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value.
`void`	`setBigDecimal(int parameterIndex, BigDecimal theBigDecimal)` Sets the value of the specified SQL `NUMERIC` parameter in the `RowSet` command with the data in the supplied `java.math.BigDecimal` value.
`void`	`setBigDecimal(String parameterName, BigDecimal theBigDecimal)` Sets the value of the specified SQL NUMERIC parameter in the RowSet command with the data in the supplied java.math.BigDecimal value.
`void`	`setBinaryStream(int parameterIndex, InputStream theInputStream)` Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value.
`void`	`setBinaryStream(int parameterIndex, InputStream theInputStream, int length)` Sets the value of the specified parameter in the `RowSet` command to the binary data in the supplied input stream.
`void`	`setBinaryStream(String parameterName, InputStream theInputStream)` Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value.
`void`	`setBinaryStream(String parameterName, InputStream theInputStream, int length)` Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value.
`void`	`setBlob(int parameterIndex, Blob theBlob)` Sets the value of the specified parameter in the `RowSet` command to the supplied `Blob` value.
`void`	`setBlob(int parameterIndex, InputStream theInputStream)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream.
`void`	`setBlob(int parameterIndex, InputStream theInputStream, long length)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream.
`void`	`setBlob(String parameterName, Blob theBlob)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Blob.
`void`	`setBlob(String parameterName, InputStream theInputStream)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream.
`void`	`setBlob(String parameterName, InputStream theInputStream, long length)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream.
`void`	`setBoolean(int parameterIndex, boolean theBoolean)` Sets the value of the specified parameter in the `RowSet` command to the supplied boolean.
`void`	`setBoolean(String parameterName, boolean theBoolean)` Sets the value of the specified parameter in the RowSet command to the supplied boolean.
`void`	`setByte(int parameterIndex, byte theByte)` Sets the value of the specified parameter in the `RowSet` command to the supplied byte value.
`void`	`setByte(String parameterName, byte theByte)` Sets the value of the specified parameter in the RowSet command to the supplied byte value.
`void`	`setBytes(int parameterIndex, byte[] theByteArray)` Sets the value of the specified parameter in the `RowSet` command to the supplied byte array value.
`void`	`setBytes(String parameterName, byte[] theByteArray)` Sets the value of the specified parameter in the RowSet command to the supplied byte array value.
`void`	`setCharacterStream(int parameterIndex, Reader theReader)` Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
`void`	`setCharacterStream(int parameterIndex, Reader theReader, int length)` Sets the value of the specified parameter in the `RowSet` command to the sequence of Unicode characters carried by the supplied `java.io.Reader`.
`void`	`setCharacterStream(String parameterName, Reader theReader)` Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
`void`	`setCharacterStream(String parameterName, Reader theReader, int length)` Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
`void`	`setClob(int parameterIndex, Clob theClob)` Sets the value of the specified parameter in the `RowSet` command with the value of a supplied `java.sql.Clob`.
`void`	`setClob(int parameterIndex, Reader theReader)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
`void`	`setClob(int parameterIndex, Reader theReader, long length)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
`void`	`setClob(String parameterName, Clob theClob)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Clob.
`void`	`setClob(String parameterName, Reader theReader)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
`void`	`setClob(String parameterName, Reader theReader, long length)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
`void`	`setCommand(String cmd)` Sets the Command property for this `RowSet` - the command is an SQL query which runs when the `execute` method is invoked.
`void`	`setConcurrency(int concurrency)` Sets the concurrency property of this `RowSet`.
`void`	`setDataSourceName(String name)` Sets the database name property for the `RowSet`.
`void`	`setDate(int parameterIndex, Date theDate)` Sets the value of the specified parameter in the `RowSet` command with the value of a supplied `java.sql.Date`.
`void`	`setDate(int parameterIndex, Date theDate, Calendar theCalendar)` Sets the value of the specified parameter in the `RowSet` command with the value of a supplied `java.sql.Date`, where the conversion of the date to an SQL `DATE` value is calculated using a supplied `Calendar`.
`void`	`setDate(String parameterName, Date theDate)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date, where the conversion of the Date to an SQL DATE value is calculated using a supplied Calendar.
`void`	`setDate(String parameterName, Date theDate, Calendar theCalendar)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date, where the conversion of the Date to an SQL DATE value is calculated using a supplied Calendar.
`void`	`setDouble(int parameterIndex, double theDouble)` Sets the value of the specified parameter in the `RowSet` command with the supplied `double`.
`void`	`setDouble(String parameterName, double theDouble)` Sets the value of the specified parameter in the RowSet command with the supplied double.
`void`	`setEscapeProcessing(boolean enable)` Sets the escape processing status for this `RowSet`.
`void`	`setFloat(int parameterIndex, float theFloat)` Sets the value of the specified parameter in the `RowSet` command with the supplied `float`.
`void`	`setFloat(String parameterName, float theFloat)` Sets the value of the specified parameter in the RowSet command with the supplied float.
`void`	`setInt(int parameterIndex, int theInteger)` Sets the value of the specified parameter in the `RowSet` command with the supplied `integer`.
`void`	`setInt(String parameterName, int theInteger)` Sets the value of the specified parameter in the RowSet command with the supplied integer.
`void`	`setLong(int parameterIndex, long theLong)` Sets the value of the specified parameter in the `RowSet` command with the supplied `long`.
`void`	`setLong(String parameterName, long theLong)` Sets the value of the specified parameter in the RowSet command with the supplied long.
`void`	`setMaxFieldSize(int max)` Sets the maximum number of bytes which can be returned for a column value where the column type is one of `BINARY`, `VARBINARY`, `LONGVARBINARYBINARY`, `CHAR`, `VARCHAR`, or `LONGVARCHAR`.
`void`	`setMaxRows(int max)` Sets the maximum number of rows which can be held by the `RowSet`.
`void`	`setNCharacterStream(int parameterIndex, Reader theReader)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
`void`	`setNCharacterStream(int parameterIndex, Reader theReader, long length)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
`void`	`setNCharacterStream(String parameterName, Reader theReader)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
`void`	`setNCharacterStream(String parameterName, Reader theReader, long length)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
`void`	`setNClob(int parameterIndex, NClob theNClob)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.NClob.
`void`	`setNClob(int parameterIndex, Reader theReader)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
`void`	`setNClob(int parameterIndex, Reader theReader, long length)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
`void`	`setNClob(String parameterName, NClob theNClob)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.NClob.
`void`	`setNClob(String parameterName, Reader theReader)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
`void`	`setNClob(String parameterName, Reader theReader, long length)` Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
`void`	`setNString(int parameterIndex, String theNString)` Sets the value of the specified parameter in the RowSet command to the supplied NString
`void`	`setNString(String parameterName, String theNString)` Sets the value of the specified parameter in the RowSet command to the supplied NString.
`void`	`setNull(int parameterIndex, int sqlType)` Sets the value of the specified parameter in the `RowSet` command to SQL `NULL`.
`void`	`setNull(int parameterIndex, int sqlType, String typeName)` Sets the value of the specified parameter in the `RowSet` command to SQL `NULL`.
`void`	`setNull(String parameterName, int sqlType)` Sets the value of the specified parameter in the RowSet command to SQL NULL.
`void`	`setNull(String parameterName, int sqlType, String typeName)` Sets the value of the specified parameter in the RowSet command to SQL NULL.
`void`	`setObject(int parameterIndex, Object theObject)` Sets the value of the specified parameter in the `RowSet` command to a supplied Java object.
`void`	`setObject(int parameterIndex, Object theObject, int targetSqlType)` Sets the value of the specified parameter in the `RowSet` command to a supplied Java object.
`void`	`setObject(int parameterIndex, Object theObject, int targetSqlType, int scale)` Sets the value of the specified parameter in the `RowSet` command to a supplied Java object.
`void`	`setObject(String parameterName, Object theObject)` Sets the value of the specified parameter in the RowSet command to a supplied Java object.
`void`	`setObject(String parameterName, Object theObject, int targetSqlType)` Sets the value of the specified parameter in the RowSet command to a supplied Java object.
`void`	`setObject(String parameterName, Object theObject, int targetSqlType, int scale)` Sets the value of the specified parameter in the RowSet command to a supplied Java object.
`void`	`setPassword(String password)` Sets the database Password for this `RowSet`.
`void`	`setQueryTimeout(int seconds)` Gets the timeout for the driver when a query operation is executed.
`void`	`setReadOnly(boolean readOnly)` Sets whether the `RowSet` is read-only or updatable.
`void`	`setRef(int parameterIndex, Ref theRef)` Sets the value of the specified parameter in the `RowSet` command to a supplied `java.sql.Ref`.
`void`	`setRowId(int parameterIndex, RowId theRowId)` Sets the value of the specified parameter in the RowSet command to the supplied RowId
`void`	`setRowId(String parameterName, RowId theRowId)` Sets the value of the specified parameter in the RowSet command to the supplied RowId.
`void`	`setShort(int parameterIndex, short theShort)` Sets the value of the specified parameter in the `RowSet` command to a supplied `short integer`.
`void`	`setShort(String parameterName, short theShort)` Sets the value of the specified parameter in the RowSet command to a supplied short integer.
`void`	`setSQLXML(int parameterIndex, SQLXML theSQLXML)` Sets the value of the specified parameter in the RowSet command to the supplied SQLXML
`void`	`setSQLXML(String parameterName, SQLXML theSQLXML)` Sets the value of the specified parameter in the RowSet command to the supplied SQLXML.
`void`	`setString(int parameterIndex, String theString)` Sets the value of the specified parameter in the `RowSet` command to a supplied `String`.
`void`	`setString(String parameterName, String theString)` Sets the value of the specified parameter in the RowSet command to a supplied String.
`void`	`setTime(int parameterIndex, Time theTime)` Sets the value of the specified parameter in the `RowSet` command to a supplied `java.sql.Time`, converting it to an SQL `TIME` value using the system default `Calendar`.
`void`	`setTime(int parameterIndex, Time theTime, Calendar theCalendar)` Sets the value of the specified parameter in the `RowSet` command to a supplied `java.sql.Time`, converting it to an SQL `TIME` value using a supplied `Calendar`.
`void`	`setTime(String parameterName, Time theTime)` Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting to an SQL TIME value using a supplied Calendar.
`void`	`setTime(String parameterName, Time theTime, Calendar theCalendar)` Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting to an SQL TIME value using a supplied Calendar.
`void`	`setTimestamp(int parameterIndex, Timestamp theTimestamp)` Sets the value of the specified parameter in the `RowSet` command to a supplied `java.sql.Timestamp`, converting it to an SQL `TIMESTAMP` value using the system default `Calendar`.
`void`	`setTimestamp(int parameterIndex, Timestamp theTimestamp, Calendar theCalendar)` Sets the value of the specified parameter in the `RowSet` command to a supplied `java.sql.Timestamp`, converting it to an SQL `TIMESTAMP` value using a supplied `Calendar`.
`void`	`setTimestamp(String parameterName, Timestamp theTimestamp)` Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using the system default `Calendar`.
`void`	`setTimestamp(String parameterName, Timestamp theTimestamp, Calendar theCalendar)` Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using a supplied Calendar.
`void`	`setTransactionIsolation(int level)` Sets the target instance's transaction isolation level to one of a discrete set of possible values.
`void`	`setType(int type)` Sets the type of this `RowSet`.
`void`	`setTypeMap(Map<String,Class<?>> theTypeMap)` Sets the mapping of SQL User Defined Types (UDTs) to Java classes.
`void`	`setURL(int parameterIndex, URL theURL)` Sets the URL used by this RowSet to access the database via a `DriverManager`.
`void`	`setUrl(String theURL)` Sets the URL used by this `RowSet` to access the database via a `DriverManager`.
`void`	`setUsername(String theUsername)` Sets the `Username` property for the `RowSet`, used to authenticate a connection to the database.

Methods inherited from interface java.sql.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, 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, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

- Method Detail
  - addRowSetListener
```
void addRowSetListener(RowSetListener theListener)
```
    Registers the supplied RowSetListener with this RowSet. Once registered, the RowSetListener is notified of events generated by the RowSet.
    
    Parameters:
    
    theListener - an object which implements the rowSetListener interface.
  - clearParameters
```
void clearParameters()
              throws SQLException
```
    Clears the parameters previously set for this RowSet.
    The RowSet object retains its value until either a new value for a parameter is set or its value is actively reset. clearParameters provides a facility to clear the values for all parameters with one method call.
    
    Throws:
    
    SQLException - if a problem occurs accessing the database.
  - execute
```
void execute()
      throws SQLException
```
    Fetches data for this RowSet from the database. If successful, any existing data for the RowSet is discarded and its metadata is overwritten.
    Data is retrieved connecting to the database and executing an according SQL statement. This requires some or all of the following properties to be set: URL, database name, user name, password, transaction isolation, type map; plus some or all of the properties: command, read only, maximum field size, maximum rows, escape processing, and query timeout.
    The RowSet may use a RowSetReader to access the database it will then invoke the RowSetReader.readData(javax.sql.RowSetInternal) method on the reader to fetch the data. When the new data is fetched all the listeners are notified to take appropriate measures.
    
    Throws:
    
    SQLException - if a problem occurs accessing the database or if the properties needed to access the database have not been set.
    
    See Also:
    
    RowSetMetaData, RowSetReader
  - getCommand
```
String getCommand()
```
    Gets the RowSet's command property.
    
    Returns:
    
    a string containing the RowSet's command property. A command is a SQL statement which is executed to fetch required data into the RowSet.
  - getDataSourceName
```
String getDataSourceName()
```
    Gets the ODBC Data Source Name property associated with this RowSet. The database name can be used to find a DataSource which has been registered with a naming service - the DataSource can then be used to create a connection to the database.
    
    Returns:
    
    the name of the database.
  - getEscapeProcessing
```
boolean getEscapeProcessing()
                     throws SQLException
```
    Reports if escape processing is enabled for this RowSet. If escape processing is on, the driver performs a substitution of the escape syntax with the applicable code before sending an SQL command to the database. The default value for escape processing is true.
    
    Returns:
    
    true if escape processing is enabled, false otherwise.
    
    Throws:
    
    SQLException - if a problem occurs accessing the database.
  - getMaxFieldSize
```
int getMaxFieldSize()
             throws SQLException
```
    Gets the maximum number of bytes that can be returned for column values which are of type BINARY, VARBINARY, LONGVARBINARYBINARY, CHAR, VARCHAR, or LONGVARCHAR. Excess data is silently discarded if the number is exceeded.
    
    Returns:
    
    the current maximum size in bytes. 0 implies no size limit.
    
    Throws:
    
    SQLException - if a problem occurs accessing the database.
  - getMaxRows
```
int getMaxRows()
        throws SQLException
```
    Gets the maximum number of rows for this RowSet. Excess rows are discarded silently if the limit is exceeded.
    
    Returns:
    
    the previous maximum number of rows. 0 implies no row limit.
    
    Throws:
    
    SQLException - if a problem occurs accessing the database.
  - getPassword
```
String getPassword()
```
    Gets the value of the password property for this RowSet. This property is used when a connection to the database is established. Therefore it should be set prior to invoking the execute() method.
    
    Returns:
    
    the value of the password property.
  - getQueryTimeout
```
int getQueryTimeout()
             throws SQLException
```
    Gets the timeout for the driver when a query operation is executed. If a query takes longer than the timeout then a SQLException is thrown.
    
    Returns:
    
    the timeout value in seconds.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - getTransactionIsolation
```
int getTransactionIsolation()
```
    Gets the transaction isolation level property set for this RowSet. The transaction isolation level defines the policy implemented on the database for maintaining the data values consistent.
    Returns:
    the current transaction isolation level. Must be one of:
    
    Connection.TRANSACTION_READ_UNCOMMITTED
    
    Connection.TRANSACTION_READ_COMMITTED
    
    Connection.TRANSACTION_REPEATABLE_READ
    
    Connection.TRANSACTION_SERIALIZABLE
    See Also:
    
    Connection
  - getTypeMap
```
Map<String,Class<?>> getTypeMap()
                         throws SQLException
```
    Gets the custom mapping of SQL User-Defined Types (UDTs) and Java classes for this RowSet, if applicable.
    
    Returns:
    
    the custom mappings of SQL types to Java classes.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - getUrl
```
String getUrl()
       throws SQLException
```
    Gets the URL property value for this RowSet. If there is no DataSource object specified, the RowSet uses the URL to establish a connection to the database. The default value for the URL is null.
    
    Returns:
    
    a String holding the value of the URL property.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - getUsername
```
String getUsername()
```
    Gets the value of the username property for this RowSet. The username is used when establishing a connection to the database and should be set before the execute method is invoked.
    
    Returns:
    
    a String holding the value of the username property.
  - isReadOnly
```
boolean isReadOnly()
```
    Indicates if this RowSet is read-only.
    
    Returns:
    
    true if this RowSet is read-only, false if it is updatable.
  - removeRowSetListener
```
void removeRowSetListener(RowSetListener theListener)
```
    Removes a specified RowSetListener object from the set of listeners which will be notified of events by this RowSet.
    
    Parameters:
    
    theListener - the RowSetListener to remove from the set of listeners for this RowSet.
  - setArray
```
void setArray(int parameterIndex,
              Array theArray)
       throws SQLException
```
    Sets the specified ARRAY parameter in the RowSet command with the supplied java.sql.Array value.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theArray - the Array data value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setAsciiStream
```
void setAsciiStream(int parameterIndex,
                    InputStream theInputStream,
                    int length)
             throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theInputStream - the ASCII data value to which the parameter is set.
    
    length - the length of the data in bytes.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setAsciiStream
```
void setAsciiStream(int parameterIndex,
                    InputStream theInputStream)
             throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theInputStream - an InputStream containing the ASCII data to set into the parameter value
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setAsciiStream
```
void setAsciiStream(String parameterName,
                    InputStream theInputStream)
             throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
    
    Parameters:
    
    parameterName - the name for parameter
    
    theInputStream - an InputStream containing the ASCII data to set into the parameter value
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setAsciiStream
```
void setAsciiStream(String parameterName,
                    InputStream theInputStream,
                    int length)
             throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the ASCII data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
    
    Parameters:
    
    parameterName - the name for parameter
    
    theInputStream - an InputStream containing the ASCII data to set into the parameter value
    
    length - the length of the data in bytes
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBigDecimal
```
void setBigDecimal(int parameterIndex,
                   BigDecimal theBigDecimal)
            throws SQLException
```
    Sets the value of the specified SQL NUMERIC parameter in the RowSet command with the data in the supplied java.math.BigDecimal value.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theBigDecimal - the big decimal value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBigDecimal
```
void setBigDecimal(String parameterName,
                   BigDecimal theBigDecimal)
            throws SQLException
```
    Sets the value of the specified SQL NUMERIC parameter in the RowSet command with the data in the supplied java.math.BigDecimal value.
    
    Parameters:
    
    parameterName - the name for parameter
    
    theBigDecimal - the BigDecimal containing the value
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBinaryStream
```
void setBinaryStream(int parameterIndex,
                     InputStream theInputStream,
                     int length)
              throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the binary data in the supplied input stream. Data is read from the input stream until end-of-file is reached.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theInputStream - the binary data stream to which the parameter is set.
    
    length - the length of the data in bytes.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBinaryStream
```
void setBinaryStream(int parameterIndex,
                     InputStream theInputStream)
              throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theInputStream - an InputStream containing the binary data to set into the parameter value
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBinaryStream
```
void setBinaryStream(String parameterName,
                     InputStream theInputStream)
              throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
    
    Parameters:
    
    parameterName - the name for parameter
    
    theInputStream - an InputStream containing the binary data to set into the parameter value
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBinaryStream
```
void setBinaryStream(String parameterName,
                     InputStream theInputStream,
                     int length)
              throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the binary data in the supplied java.io.InputStream value. Data is read from the InputStream until end-of-file is reached.
    
    Parameters:
    
    parameterName - the name for parameter
    
    theInputStream - an InputStream containing the binary data to set into the parameter value
    
    length - the length of the data in bytes
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBlob
```
void setBlob(int parameterIndex,
             Blob theBlob)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied Blob value.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theBlob - the Blob value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBlob
```
void setBlob(int parameterIndex,
             InputStream theInputStream)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream. Data is read from the InputStream until end-of-file is reached.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theInputStream - an InputStream containing the binary data to set into the parameter value
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBlob
```
void setBlob(int parameterIndex,
             InputStream theInputStream,
             long length)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream. Data is read from the InputStream until end-of-file is reached.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theInputStream - an InputStream containing the binary data to set into the parameter value
    
    length - the length of the data in bytes
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBlob
```
void setBlob(String parameterName,
             InputStream theInputStream)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream. Data is read from the InputStream until end-of-file is reached.
    
    Parameters:
    
    parameterName - the name for parameter
    
    theInputStream - an InputStream containing the binary data to set into the parameter value
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBlob
```
void setBlob(String parameterName,
             InputStream theInputStream,
             long length)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.InputStream. Data is read from the InputStream until end-of-file is reached.
    
    Parameters:
    
    parameterName - the name for parameter
    
    theInputStream - an InputStream containing the binary data to set into the parameter value
    
    length - the length of the data in bytes
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBlob
```
void setBlob(String parameterName,
             Blob theBlob)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Blob.
    
    Parameters:
    
    parameterName - the name for parameter
    
    theBlob - the Blob value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBoolean
```
void setBoolean(int parameterIndex,
                boolean theBoolean)
         throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied boolean.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theBoolean - the boolean value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBoolean
```
void setBoolean(String parameterName,
                boolean theBoolean)
         throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied boolean.
    
    Parameters:
    
    parameterName - name for parameter
    
    theBoolean - the boolean value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setByte
```
void setByte(int parameterIndex,
             byte theByte)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied byte value.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theByte - the byte value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setByte
```
void setByte(String parameterName,
             byte theByte)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied byte value.
    
    Parameters:
    
    parameterName - name for parameter
    
    theByte - the byte value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBytes
```
void setBytes(int parameterIndex,
              byte[] theByteArray)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied byte array value.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theByteArray - the Array of bytes to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setBytes
```
void setBytes(String parameterName,
              byte[] theByteArray)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied byte array value.
    
    Parameters:
    
    parameterName - name for parameter
    
    theByteArray - the array of bytes to set into the parameter.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setCharacterStream
```
void setCharacterStream(int parameterIndex,
                        Reader theReader,
                        int length)
                 throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theReader - the Reader which contains the Unicode data to set the parameter.
    
    length - the length of the data in the Reader in characters.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setCharacterStream
```
void setCharacterStream(int parameterIndex,
                        Reader theReader)
                 throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setCharacterStream
```
void setCharacterStream(String parameterName,
                        Reader theReader)
                 throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
    
    Parameters:
    
    parameterName - name for parameter
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setCharacterStream
```
void setCharacterStream(String parameterName,
                        Reader theReader,
                        int length)
                 throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the sequence of Unicode characters carried by the supplied java.io.Reader.
    
    Parameters:
    
    parameterName - name for parameter
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    length - the length of the data in the Reader in characters
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setClob
```
void setClob(int parameterIndex,
             Clob theClob)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Clob.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theClob - the Clob value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setClob
```
void setClob(int parameterIndex,
             Reader theReader)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setClob
```
void setClob(int parameterIndex,
             Reader theReader,
             long length)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    length - the length of the data in the Reader in characters
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setClob
```
void setClob(String parameterName,
             Clob theClob)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Clob.
    
    Parameters:
    
    parameterName - name for parameter
    
    theClob - the specific Clob object
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setClob
```
void setClob(String parameterName,
             Reader theReader)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
    
    Parameters:
    
    parameterName - name for parameter
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setClob
```
void setClob(String parameterName,
             Reader theReader,
             long length)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
    
    Parameters:
    
    parameterName - name for parameter
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    length - the length of the data in the Reader in characters
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setCommand
```
void setCommand(String cmd)
         throws SQLException
```
    Sets the Command property for this RowSet - the command is an SQL query which runs when the execute method is invoked. This property is optional for databases that do not support commands.
    
    Parameters:
    
    cmd - the SQL query. Can be null.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setConcurrency
```
void setConcurrency(int concurrency)
             throws SQLException
```
    Sets the concurrency property of this RowSet. The default value is ResultSet.CONCUR_READ_ONLY.
    Parameters:
    concurrency - the concurrency value. One of:
    
    ResultSet.CONCUR_READ_ONLY
    
    ResultSet.CONCUR_UPDATABLE
    Throws:
    
    SQLException - if an error occurs accessing the database.
    
    See Also:
    
    ResultSet
  - setDataSourceName
```
void setDataSourceName(String name)
                throws SQLException
```
    Sets the database name property for the RowSet.
    The database name can be used to find a DataSource which has been registered with a naming service - the DataSource can then be used to create a connection to the database.
    
    Parameters:
    
    name - the database name.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setDate
```
void setDate(int parameterIndex,
             Date theDate)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theDate - the date value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setDate
```
void setDate(int parameterIndex,
             Date theDate,
             Calendar theCalendar)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date, where the conversion of the date to an SQL DATE value is calculated using a supplied Calendar.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theDate - the date to which the parameter is set.
    
    theCalendar - the Calendar to use in converting the Date to an SQL DATE value.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setDate
```
void setDate(String parameterName,
             Date theDate)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date, where the conversion of the Date to an SQL DATE value is calculated using a supplied Calendar.
    
    Parameters:
    
    parameterName - name for parameter
    
    theDate - the Date to use
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setDate
```
void setDate(String parameterName,
             Date theDate,
             Calendar theCalendar)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.Date, where the conversion of the Date to an SQL DATE value is calculated using a supplied Calendar.
    
    Parameters:
    
    parameterName - name for parameter
    
    theDate - the Date to use
    
    theCalendar - the Calendar to use in converting the Date to an SQL DATE value
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setDouble
```
void setDouble(int parameterIndex,
               double theDouble)
        throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the supplied double.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theDouble - the double value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setDouble
```
void setDouble(String parameterName,
               double theDouble)
        throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the supplied double.
    
    Parameters:
    
    parameterName - name for parameter
    
    theDouble - the double value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setEscapeProcessing
```
void setEscapeProcessing(boolean enable)
                  throws SQLException
```
    Sets the escape processing status for this RowSet. If escape processing is on, the driver performs a substitution of the escape syntax with the applicable code before sending an SQL command to the database. The default value for escape processing is true.
    
    Parameters:
    
    enable - true to enable escape processing, false to turn it off.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setFloat
```
void setFloat(int parameterIndex,
              float theFloat)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the supplied float.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theFloat - the float value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setFloat
```
void setFloat(String parameterName,
              float theFloat)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the supplied float.
    
    Parameters:
    
    parameterName - name for parameter
    
    theFloat - the float value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setInt
```
void setInt(int parameterIndex,
            int theInteger)
     throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the supplied integer.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theInteger - the integer value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setInt
```
void setInt(String parameterName,
            int theInteger)
     throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the supplied integer.
    
    Parameters:
    
    parameterName - name for parameter
    
    theInteger - the integer value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setLong
```
void setLong(int parameterIndex,
             long theLong)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the supplied long.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theLong - the long value value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setLong
```
void setLong(String parameterName,
             long theLong)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the supplied long.
    
    Parameters:
    
    parameterName - name for parameter
    
    theLong - the long value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setMaxFieldSize
```
void setMaxFieldSize(int max)
              throws SQLException
```
    Sets the maximum number of bytes which can be returned for a column value where the column type is one of BINARY, VARBINARY, LONGVARBINARYBINARY, CHAR, VARCHAR, or LONGVARCHAR. Data which exceeds this limit is silently discarded. For portability, a value greater than 256 is recommended.
    
    Parameters:
    
    max - the maximum size of the returned column value in bytes. 0 implies no size limit.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setMaxRows
```
void setMaxRows(int max)
         throws SQLException
```
    Sets the maximum number of rows which can be held by the RowSet. Any additional rows are silently discarded.
    
    Parameters:
    
    max - the maximum number of rows which can be held in the RowSet. 0 means no limit.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNCharacterStream
```
void setNCharacterStream(int parameterIndex,
                         Reader theReader)
                  throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNCharacterStream
```
void setNCharacterStream(int parameterIndex,
                         Reader theReader,
                         long length)
                  throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    length - the length of the data in the Reader in characters
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNCharacterStream
```
void setNCharacterStream(String parameterName,
                         Reader theReader)
                  throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
    
    Parameters:
    
    parameterName - name for parameter
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNCharacterStream
```
void setNCharacterStream(String parameterName,
                         Reader theReader,
                         long length)
                  throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
    
    Parameters:
    
    parameterName - name for parameter
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    length - the length of the data in the Reader in characters
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNClob
```
void setNClob(int parameterIndex,
              NClob theNClob)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.NClob.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theNClob - the NClob value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNClob
```
void setNClob(int parameterIndex,
              Reader theReader)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNClob
```
void setNClob(int parameterIndex,
              Reader theReader,
              long length)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    length - the length of the data in the Reader in characters
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNClob
```
void setNClob(String parameterName,
              NClob theNClob)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.sql.NClob.
    
    Parameters:
    
    parameterName - name for parameter
    
    theNClob - the NClob value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNClob
```
void setNClob(String parameterName,
              Reader theReader)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
    
    Parameters:
    
    parameterName - name for parameter
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNClob
```
void setNClob(String parameterName,
              Reader theReader,
              long length)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command with the value of a supplied java.io.Reader.
    
    Parameters:
    
    parameterName - name for parameter
    
    theReader - the Reader which contains the Unicode data to set into the parameter
    
    length - the length of the data in the Reader in characters
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNString
```
void setNString(int parameterIndex,
                String theNString)
         throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied NString
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theNString - the NString value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNString
```
void setNString(String parameterName,
                String theNString)
         throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied NString.
    
    Parameters:
    
    parameterName - name for parameter
    
    theNString - the NString value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNull
```
void setNull(int parameterIndex,
             int sqlType)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to SQL NULL.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    sqlType - the type of the parameter, as defined by java.sql.Types.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNull
```
void setNull(int parameterIndex,
             int sqlType,
             String typeName)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to SQL NULL. This form of the setNull method should be used for User Defined Types and REF parameters.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    sqlType - the type of the parameter, as defined by java.sql.Types.
    
    typeName - the fully qualified name of an SQL user defined type or the name of the SQL structured type referenced by a REF type. Ignored if the sqlType is not a UDT or REF type.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNull
```
void setNull(String parameterName,
             int sqlType)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to SQL NULL. This form of the setNull method should be used for User Defined Types and REF parameters.
    
    Parameters:
    
    parameterName - name for parameter
    
    sqlType - the type of the parameter, as defined by java.sql.Types.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setNull
```
void setNull(String parameterName,
             int sqlType,
             String typeName)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to SQL NULL. This form of the setNull method should be used for User Defined Types and REF parameters.
    
    Parameters:
    
    parameterName - name for parameter
    
    sqlType - the type of the parameter, as defined by java.sql.Types.
    
    typeName - the fully qualified name of an SQL User Defined Type or the name of the SQL structured type referenced by a REF type. Ignored if the sqlType is not a UDT or REF type.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setObject
```
void setObject(int parameterIndex,
               Object theObject)
        throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied Java object.
    The JDBC specification provides a standard mapping for Java objects to SQL data types. Database specific types can be mapped by JDBC driver specific Java types.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theObject - the Java object containing the data value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setObject
```
void setObject(int parameterIndex,
               Object theObject,
               int targetSqlType)
        throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied Java object.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theObject - the Java object containing the data value.
    
    targetSqlType - the SQL type to send to the database, as defined in java.sql.Types.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setObject
```
void setObject(int parameterIndex,
               Object theObject,
               int targetSqlType,
               int scale)
        throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied Java object.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theObject - the Java object containing the data value.
    
    targetSqlType - the SQL type to send to the database, as defined in java.sql.Types.
    
    scale - the number of digits after the decimal point, for java.sql.Types.DECIMAL and java.sql.Types.NUMERIC types. Ignored for all other types.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setObject
```
void setObject(String parameterName,
               Object theObject)
        throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied Java object.
    
    Parameters:
    
    parameterName - name for parameter
    
    theObject - the Java object containing the data value.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setObject
```
void setObject(String parameterName,
               Object theObject,
               int targetSqlType)
        throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied Java object.
    
    Parameters:
    
    parameterName - name for parameter
    
    theObject - the Java object containing the data value.
    
    targetSqlType - the SQL type to send to the database, as defined in java.sql.Types.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setObject
```
void setObject(String parameterName,
               Object theObject,
               int targetSqlType,
               int scale)
        throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied Java object.
    
    Parameters:
    
    parameterName - name for parameter
    
    theObject - the Java object containing the data value.
    
    targetSqlType - the SQL type to send to the database, as defined in java.sql.Types.
    
    scale - the number of digits after the decimal point, for java.sql.Types.DECIMAL and java.sql.Types.NUMERIC types. Ignored for all other types.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setPassword
```
void setPassword(String password)
          throws SQLException
```
    Sets the database Password for this RowSet. This property is used when a connection to the database is established. Therefore it should be set prior to invoking the execute() method.
    
    Parameters:
    
    password - a String holding the password.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setQueryTimeout
```
void setQueryTimeout(int seconds)
              throws SQLException
```
    Gets the timeout for the driver when a query operation is executed. If a query takes longer than the timeout, a SQLException is thrown.
    
    Parameters:
    
    seconds - the number of seconds for the timeout.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setReadOnly
```
void setReadOnly(boolean readOnly)
          throws SQLException
```
    Sets whether the RowSet is read-only or updatable.
    
    Parameters:
    
    readOnly - true to set the RowSet to read-only state, false to allow updates.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setRef
```
void setRef(int parameterIndex,
            Ref theRef)
     throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Ref. This is sent to the database as an SQL REF value.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theRef - the value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
    
    See Also:
    
    Ref
  - setShort
```
void setShort(int parameterIndex,
              short theShort)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied short integer.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theShort - the value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setShort
```
void setShort(String parameterName,
              short theShort)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied short integer.
    
    Parameters:
    
    parameterName - name for parameter
    
    theShort - the short value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setString
```
void setString(int parameterIndex,
               String theString)
        throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied String. The string is placed into the database as a VARCHAR or LONGVARCHAR SQL value, depending on the database limits for the length of VARCHAR values.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theString - the value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setString
```
void setString(String parameterName,
               String theString)
        throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied String. The String is placed into the database as a VARCHAR or LONGVARCHAR SQL value, depending on the database limits for the length of VARCHAR values.
    
    Parameters:
    
    parameterName - name for parameter
    
    theString -
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setRowId
```
void setRowId(int parameterIndex,
              RowId theRowId)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied RowId
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theRowId - the RowId value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setRowId
```
void setRowId(String parameterName,
              RowId theRowId)
       throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied RowId.
    
    Parameters:
    
    parameterName - name for parameter
    
    theRowId - the RowId value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setSQLXML
```
void setSQLXML(int parameterIndex,
               SQLXML theSQLXML)
        throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied SQLXML
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theSQLXML - the SQLXML value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setSQLXML
```
void setSQLXML(String parameterName,
               SQLXML theSQLXML)
        throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to the supplied SQLXML.
    
    Parameters:
    
    parameterName - name for parameter
    
    theSQLXML - the SQLXML value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setTime
```
void setTime(int parameterIndex,
             Time theTime)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting it to an SQL TIME value using the system default Calendar.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theTime - the value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
    
    See Also:
    
    Calendar, Time
  - setTime
```
void setTime(int parameterIndex,
             Time theTime,
             Calendar theCalendar)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting it to an SQL TIME value using a supplied Calendar.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theTime - the value to which the parameter is set.
    
    theCalendar - the Calendar to use in the conversion operation.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
    
    See Also:
    
    Calendar, Time
  - setTime
```
void setTime(String parameterName,
             Time theTime)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting to an SQL TIME value using a supplied Calendar.
    
    Parameters:
    
    parameterName - name for parameter
    
    theTime - the Time value to set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setTime
```
void setTime(String parameterName,
             Time theTime,
             Calendar theCalendar)
      throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Time, converting to an SQL TIME value using a supplied Calendar.
    
    Parameters:
    
    parameterName - name for parameter
    
    theTime - the Time value to set
    
    theCalendar - the Calendar to use in the conversion operation
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setTimestamp
```
void setTimestamp(int parameterIndex,
                  Timestamp theTimestamp)
           throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp, converting it to an SQL TIMESTAMP value using the system default Calendar.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theTimestamp - the value to which the parameter is set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
    
    See Also:
    
    Calendar, Timestamp
  - setTimestamp
```
void setTimestamp(int parameterIndex,
                  Timestamp theTimestamp,
                  Calendar theCalendar)
           throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp, converting it to an SQL TIMESTAMP value using a supplied Calendar.
    
    Parameters:
    
    parameterIndex - the index of the parameter to set; the first parameter's index is 1.
    
    theTimestamp - the value to which the parameter is set.
    
    theCalendar - the Calendar to use in the conversion operation
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
    
    See Also:
    
    Calendar, Timestamp
  - setTimestamp
```
void setTimestamp(String parameterName,
                  Timestamp theTimestamp)
           throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using the system default Calendar.
    
    Parameters:
    
    parameterName - name for parameter
    
    theTimestamp - the value to which the parameter is set
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setTimestamp
```
void setTimestamp(String parameterName,
                  Timestamp theTimestamp,
                  Calendar theCalendar)
           throws SQLException
```
    Sets the value of the specified parameter in the RowSet command to a supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using a supplied Calendar.
    
    Parameters:
    
    parameterName - name for parameter
    
    theTimestamp - the value to which the parameter is set
    
    theCalendar - the Calendar to use in the conversion operation
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setTransactionIsolation
```
void setTransactionIsolation(int level)
                      throws SQLException
```
    Sets the target instance's transaction isolation level to one of a discrete set of possible values. The transaction isolation level defines the policy implemented on the database for maintaining the data values consistent.
    Keep in mind that setting a transaction isolation level has no effect unless your driver and DBMS support it.
    Parameters:
    level - the transaction isolation level. One of:
    
    Connection.TRANSACTION_READ_UNCOMMITTED
    
    Connection.TRANSACTION_READ_COMMITTED
    
    Connection.TRANSACTION_REPEATABLE_READ
    
    Connection.TRANSACTION_SERIALIZABLE
    Throws:
    
    SQLException - if an error occurs accessing the database.
    
    See Also:
    
    Connection
  - setType
```
void setType(int type)
      throws SQLException
```
    Sets the type of this RowSet. By default, the type is non-scrollable.
    Parameters:
    type - the type for the RowSet. One of:
    
    ResultSet.TYPE_FORWARD_ONLY
    
    ResultSet.TYPE_SCROLL_INSENSITIVE
    
    ResultSet.TYPE_SCROLL_SENSITIVE
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setTypeMap
```
void setTypeMap(Map<String,Class<?>> theTypeMap)
         throws SQLException
```
    Sets the mapping of SQL User Defined Types (UDTs) to Java classes. The Java classes must all implement the SQLData interface.
    
    Parameters:
    
    theTypeMap - the names of SQL UDTs and the Java classes to which they are mapped.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setUrl
```
void setUrl(String theURL)
     throws SQLException
```
    Sets the URL used by this RowSet to access the database via a DriverManager. The URL is optional - an alternative is to use a database name to create a connection.
    
    Parameters:
    
    theURL - the URL for the database. Can be null.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setURL
```
void setURL(int parameterIndex,
            URL theURL)
     throws SQLException
```
    Sets the URL used by this RowSet to access the database via a DriverManager. The URL is optional - an alternative is to use a Data Source Name to create a connection.
    
    Parameters:
    
    parameterIndex - index of the parameter to set, where the first parameter has index = 1.
    
    theURL - a java.net.URL containing the URL for the database.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.
  - setUsername
```
void setUsername(String theUsername)
          throws SQLException
```
    Sets the Username property for the RowSet, used to authenticate a connection to the database.
    
    Parameters:
    
    theUsername - the new user name for this row set.
    
    Throws:
    
    SQLException - if an error occurs accessing the database.

Interface RowSet

Field Summary

Fields inherited from interface java.sql.ResultSet

Method Summary

Methods inherited from interface java.sql.ResultSet

Methods inherited from interface java.sql.Wrapper

Method Detail

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