Package Summary Overview Summary |
| ||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES All Classes | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectjavax.sql.rowset.BaseRowSet
com.sun.rowset.JdbcRowSetImpl
public class JdbcRowSetImpl
The standard implementation of the JdbcRowSet
interface. See the interface defintion for full behavior and implementation requirements.
Field Summary | |
---|---|
protected JdbcRowSetResourceBundle | resBundle
|
Fields inherited from class javax.sql.rowset.BaseRowSet |
---|
ASCII_STREAM_PARAM, asciiStream, BINARY_STREAM_PARAM, binaryStream, charStream, UNICODE_STREAM_PARAM, unicodeStream |
Fields inherited from interface java.sql.ResultSet |
---|
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
Constructor Summary | |
---|---|
JdbcRowSetImpl()
Constructs a default JdbcRowSet object. |
|
JdbcRowSetImpl(Connection con)
Constructs a default JdbcRowSet object given a valid Connection object. |
|
JdbcRowSetImpl(ResultSet res)
Constructs a JdbcRowSet object using the given valid ResultSet object. |
|
JdbcRowSetImpl(java.lang.String url, java.lang.String user, java.lang.String password)
Constructs a default JdbcRowSet object using the URL, username, and password arguments supplied. |
Method Summary | ||
---|---|---|
boolean | absolute(int row)
Moves the cursor to the given row number in this rowset's internal ResultSet object. |
|
void | afterLast()
Moves the cursor to the end of this rowset's ResultSet object, just after the last row. |
|
void | beforeFirst()
Moves the cursor to the front of this rowset's ResultSet object, just before the first row. |
|
void | cancelRowUpdates()
Cancels the updates made to the current row in this ResultSet object and notifies listeners that a row has changed. |
|
protected void | checkState()
|
|
void | clearWarnings()
Clears all warnings reported on this rowset's ResultSet object. |
|
void | close()
Releases this rowset's ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. |
|
void | commit()
Commits all updates in this JdbcRowSet object by wrapping the internal Connection object and calling its commit method. |
|
protected Connection | connect()
|
|
void | deleteRow()
Deletes the current row from this rowset's ResultSet object and from the underlying database and also notifies listeners that a row has changed. |
|
void | execute()
Creates the internal ResultSet object for which this JdbcRowSet object is a wrapper, effectively making the result set a JavaBeans component. |
|
int | findColumn(java.lang.String columnName)
Maps the given JdbcRowSetImpl column name to its JdbcRowSetImpl column index and reflects this on the internal ResultSet object. |
|
boolean | first()
Moves the cursor to the first row in this rowset's ResultSet object. |
|
Array | getArray(int i)
Returns the value of the designated column in the current row of this rowset's ResultSet object as an Array object. |
|
Array | getArray(java.lang.String colName)
Returns the value of the designated column in the current row of this rowset's ResultSet object as an Array object. |
|
java.io.InputStream | getAsciiStream(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a stream of ASCII characters. |
|
java.io.InputStream | getAsciiStream(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a stream of ASCII characters. |
|
boolean | getAutoCommit()
Returns the auto-commit status with this JdbcRowSet . |
|
java.math.BigDecimal | getBigDecimal(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a java.math.BigDecimal with full precision. |
|
java.math.BigDecimal | getBigDecimal(int columnIndex, int scale)
Deprecated. |
|
java.math.BigDecimal | getBigDecimal(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a java.math.BigDecimal with full precision. |
|
java.math.BigDecimal | getBigDecimal(java.lang.String columnName, int scale)
Deprecated. |
|
java.io.InputStream | getBinaryStream(int columnIndex)
Gets the value of a column in the current row as a stream of the value of the designated column in the current row of this rowset's ResultSet object as a binary stream of uninterpreted bytes. |
|
java.io.InputStream | getBinaryStream(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a stream of uninterpreted byte s. |
|
Blob | getBlob(int i)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a Blob object. |
|
Blob | getBlob(java.lang.String colName)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a Blob object. |
|
boolean | getBoolean(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a boolean . |
|
boolean | getBoolean(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a boolean . |
|
byte | getByte(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a byte . |
|
byte | getByte(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a byte . |
|
byte[] | getBytes(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a byte array in the Java programming language. |
|
byte[] | getBytes(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a byte array in the Java programming language. |
|
java.io.Reader | getCharacterStream(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a java.io.Reader object. |
|
java.io.Reader | getCharacterStream(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a java.io.Reader object. |
|
Clob | getClob(int i)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a Clob object. |
|
Clob | getClob(java.lang.String colName)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a Clob object. |
|
int | getConcurrency()
Returns the concurrency mode of this rowset's ResultSet object. |
|
protected Connection | getConnection()
Gets this JdbcRowSet object's Connection property |
|
java.lang.String | getCursorName()
Gets the name of the SQL cursor used by this rowset's ResultSet object. |
|
DatabaseMetaData | getDatabaseMetaData()
Retrieves the DatabaseMetaData associated with the connection handle associated this this JdbcRowSet object. |
|
Date | getDate(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Date object in the Java programming language. |
|
Date | getDate(int columnIndex, java.util.Calendar cal)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Date object. |
|
Date | getDate(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Date object in the Java programming language. |
|
Date | getDate(java.lang.String columnName, java.util.Calendar cal)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Date object. |
|
double | getDouble(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a double . |
|
double | getDouble(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a double . |
|
int | getFetchDirection()
Returns the fetch direction for this ResultSet object. |
|
float | getFloat(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a float . |
|
float | getFloat(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a float . |
|
int | getHoldability()
Retrieves the holdability of this ResultSet object |
|
int | getInt(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as an int . |
|
int | getInt(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as an int . |
|
long | getLong(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a long . |
|
long | getLong(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a long . |
|
int[] | getMatchColumnIndexes()
Retrieves the column id as int array that was set using setMatchColumn(int []) for this rowset. |
|
java.lang.String[] | getMatchColumnNames()
Retrieves the column name as String array that was set using setMatchColumn(String []) for this rowset. |
|
ResultSetMetaData | getMetaData()
Retrieves the number, types and properties of this rowset's ResultSet object's columns. |
|
java.io.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. |
|
java.io.Reader | getNCharacterStream(java.lang.String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. |
|
NClob | getNClob(int i)
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(java.lang.String colName)
Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language. |
|
java.lang.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. |
|
java.lang.String | getNString(java.lang.String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. |
|
java.lang.Object | getObject(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as an Object . |
|
| getObject(int columnIndex, java.lang.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. |
|
java.lang.Object | getObject(int i, java.util.Map<java.lang.String,java.lang.Class<?>> map)
Returns the value of the designated column in the current row of this rowset's ResultSet object as an Object . |
|
java.lang.Object | getObject(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as an Object . |
|
| getObject(java.lang.String columnLabel, java.lang.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. |
|
java.lang.Object | getObject(java.lang.String colName, java.util.Map<java.lang.String,java.lang.Class<?>> map)
Returns the value of the designated column in the current row of this rowset's ResultSet object as an Object . |
|
ParameterMetaData | getParameterMetaData()
Retrieves the ParameterMetaData associated with the connection handle associated this this JdbcRowSet object. |
|
protected PreparedStatement | getPreparedStatement()
Gets this JdbcRowSet object's PreparedStatement property |
|
Ref | getRef(int i)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a Ref object. |
|
Ref | getRef(java.lang.String colName)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a Ref object. |
|
protected ResultSet | getResultSet()
Gets this JdbcRowSet object's ResultSet property |
|
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(java.lang.String columnName)
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. |
|
RowSetWarning | getRowSetWarnings()
Return the RowSetWarning object for the current row of a JdbcRowSetImpl |
|
short | getShort(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a short . |
|
short | getShort(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a short . |
|
SQLXML | getSQLXML(int columnIndex)
Retrieves the value of the designated SQL XML parameter as a SQLXML object in the Java programming language. |
|
SQLXML | getSQLXML(java.lang.String colName)
Retrieves the value of the designated SQL XML parameter as a SQLXML object in the Java programming language. |
|
Statement | getStatement()
Returns the Statement object that produced this ResultSet object. |
|
java.lang.String | getString(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a String . |
|
java.lang.String | getString(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a String . |
|
Time | getTime(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Time object in the Java programming language. |
|
Time | getTime(int columnIndex, java.util.Calendar cal)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Time object. |
|
Time | getTime(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Time object in the Java programming language. |
|
Time | getTime(java.lang.String columnName, java.util.Calendar cal)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Time object. |
|
Timestamp | getTimestamp(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Timestamp object in the Java programming language. |
|
Timestamp | getTimestamp(int columnIndex, java.util.Calendar cal)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Timestamp object. |
|
Timestamp | getTimestamp(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Timestamp object. |
|
Timestamp | getTimestamp(java.lang.String columnName, java.util.Calendar cal)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Timestamp object. |
|
int | getType()
Returns the fetch size for this ResultSet object. |
|
java.io.InputStream | getUnicodeStream(int columnIndex)
Deprecated. use getCharacterStream in place of getUnicodeStream |
|
java.io.InputStream | getUnicodeStream(java.lang.String columnName)
Deprecated. |
|
java.net.URL | getURL(int columnIndex)
Provide interface coverage for getURL(int) in ResultSet->RowSet |
|
java.net.URL | getURL(java.lang.String columnName)
Provide interface coverage for getURL(String) in ResultSet->RowSet |
|
SQLWarning | getWarnings()
Returns the first warning reported by calls on this rowset's ResultSet object. |
|
protected void | initMetaData(RowSetMetaData md, ResultSetMetaData rsmd)
Initializes the given RowSetMetaData object with the values in the given ResultSetMetaData object. |
|
void | insertRow()
Inserts the contents of the insert row into this ResultSet object and into the database and also notifies listeners that a row has changed. |
|
boolean | isAfterLast()
Indicates whether the cursor is after the last row in this rowset's ResultSet object. |
|
boolean | isBeforeFirst()
Indicates whether the cursor is before the first row in this rowset's ResultSet object. |
|
boolean | isClosed()
Retrieves whether this ResultSet object has been closed. |
|
boolean | isFirst()
Indicates whether the cursor is on the first row of this rowset's ResultSet object. |
|
boolean | isLast()
Indicates whether the cursor is on the last row of this rowset's ResultSet object. |
|
boolean | isWrapperFor(java.lang.Class<?> interfaces)
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. |
|
boolean | last()
Moves the cursor to the last row in this rowset's 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 for this rowset's ResultSet object down one row from its current position. |
|
protected PreparedStatement | prepare()
|
|
boolean | previous()
Moves the cursor to the previous row in this ResultSet object. |
|
void | refreshRow()
Refreshes the current row of this rowset's ResultSet object with its most recent value in the database. |
|
boolean | relative(int rows)
Moves the cursor a relative number of rows, either positive or negative. |
|
void | rollback()
Rolls back all the updates in this JdbcRowSet object by wrapping the internal Connection object and calling its rollback method. |
|
void | rollback(Savepoint s)
Rollbacks all the updates in the JdbcRowSet back to the last Savepoint transaction marker. |
|
boolean | rowDeleted()
Indicates whether a row has been deleted. |
|
boolean | rowInserted()
Indicates whether the current row has had an insertion. |
|
boolean | rowUpdated()
Indicates whether the current row has been updated. |
|
void | setAsciiStream(java.lang.String parameterName, java.io.InputStream x)
Sets the designated parameter to the given input stream. |
|
void | setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
|
void | setAutoCommit(boolean autoCommit)
Sets auto-commit on the internal Connection object with this JdbcRowSet |
|
void | setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x)
Sets the designated parameter to the given java.math.BigDecimal value. |
|
void | setBinaryStream(java.lang.String parameterName, java.io.InputStream x)
Sets the designated parameter to the given input stream. |
|
void | setBinaryStream(java.lang.String parameterName, java.io.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, java.io.InputStream inputStream)
Sets the designated parameter to a InputStream object. |
|
void | setBlob(int parameterIndex, java.io.InputStream inputStream, long length)
Sets the designated parameter to a InputStream object. |
|
void | setBlob(java.lang.String parameterName, Blob x)
Sets the designated parameter to the given java.sql.Blob object. |
|
void | setBlob(java.lang.String parameterName, java.io.InputStream inputStream)
Sets the designated parameter to a InputStream object. |
|
void | setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length)
Sets the designated parameter to a InputStream object. |
|
void | setBoolean(java.lang.String parameterName, boolean x)
Sets the designated parameter to the given Java boolean value. |
|
void | setByte(java.lang.String parameterName, byte x)
Sets the designated parameter to the given Java byte value. |
|
void | setBytes(java.lang.String parameterName, byte[] x)
Sets the designated parameter to the given Java array of bytes. |
|
void | setCharacterStream(java.lang.String parameterName, java.io.Reader reader)
Sets the designated parameter to the given Reader object. |
|
void | setCharacterStream(java.lang.String parameterName, java.io.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, java.io.Reader reader)
Sets the designated parameter to a Reader object. |
|
void | setClob(int parameterIndex, java.io.Reader reader, long length)
Sets the designated parameter to a Reader object. |
|
void | setClob(java.lang.String parameterName, Clob x)
Sets the designated parameter to the given java.sql.Clob object. |
|
void | setClob(java.lang.String parameterName, java.io.Reader reader)
Sets the designated parameter to a Reader object. |
|
void | setClob(java.lang.String parameterName, java.io.Reader reader, long length)
Sets the designated parameter to a Reader object. |
|
void | setCommand(java.lang.String command)
Sets this JdbcRowSet object's command property to the given String object and clears the parameters, if any, that were set for the previous command. |
|
void | setConcurrency(int concur)
Sets the concurrency for this RowSet object to the specified concurrency. |
|
protected void | setConnection(Connection connection)
Sets this JdbcRowSet object's connection property to the given Connection object. |
|
void | setDataSourceName(java.lang.String dsName)
Sets the dataSourceName property for this JdbcRowSet object to the given logical name and sets this JdbcRowSet object's Url property to null . |
|
void | setDate(java.lang.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(java.lang.String parameterName, Date x, java.util.Calendar cal)
Sets the designated parameter to the given java.sql.Date value, using the given Calendar object. |
|
void | setDouble(java.lang.String parameterName, double x)
Sets the designated parameter to the given Java double value. |
|
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 | setFloat(java.lang.String parameterName, float x)
Sets the designated parameter to the given Java float value. |
|
void | setInt(java.lang.String parameterName, int x)
Sets the designated parameter to the given Java int value. |
|
void | setLong(java.lang.String parameterName, long x)
Sets the designated parameter to the given Java long value. |
|
void | setMatchColumn(int columnIdx)
Sets the designated parameter to the given int object. |
|
void | setMatchColumn(int[] columnIdxes)
Sets the designated parameter to the given int array. |
|
void | setMatchColumn(java.lang.String columnName)
Sets the designated parameter to the given String object. |
|
void | setMatchColumn(java.lang.String[] columnNames)
Sets the designated parameter to the given String array. |
|
void | setMaxRows(int mRows)
Sets the maximum number of rows that this RowSet object may contain to the given number. |
|
void | setNCharacterStream(int parameterIndex, java.io.Reader value)
Sets the designated parameter in this RowSet object's command to a Reader object. |
|
void | setNCharacterStream(int parameterIndex, java.io.Reader value, long length)
Sets the designated parameter to a Reader object. |
|
void | setNCharacterStream(java.lang.String parameterName, java.io.Reader value)
Sets the designated parameter to a Reader object. |
|
void | setNCharacterStream(java.lang.String parameterName, java.io.Reader value, 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(int parameterIndex, java.io.Reader reader)
Sets the designated parameter to a Reader object. |
|
void | setNClob(int parameterIndex, java.io.Reader reader, long length)
of characters specified by length otherwise a SQLException will becontain the number generated when the PreparedStatement is executed. |
|
void | setNClob(java.lang.String parameterName, NClob value)
Sets the designated parameter to a java.sql.NClob object. |
|
void | setNClob(java.lang.String parameterName, java.io.Reader reader)
Sets the designated parameter to a Reader object. |
|
void | setNClob(java.lang.String parameterName, java.io.Reader reader, long length)
Sets the designated parameter to a Reader object. |
|
void | setNString(int parameterIndex, java.lang.String value)
Sets the designated paramter to the given String object. |
|
void | setNString(java.lang.String parameterName, java.lang.String value)
Sets the designated paramter to the given String object. |
|
void | setNull(java.lang.String parameterName, int sqlType)
Sets the designated parameter to SQL NULL . |
|
void | setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName)
Sets the designated parameter to SQL NULL . |
|
void | setObject(java.lang.String parameterName, java.lang.Object x)
Sets the value of the designated parameter with the given object. |
|
void | setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType)
Sets the value of the designated parameter with the given object. |
|
void | setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale)
Sets the value of the designated parameter with the given object. |
|
protected void | setParams()
|
|
void | setPassword(java.lang.String password)
Sets the password property for this JdbcRowSet object to the given String object. |
|
protected void | setPreparedStatement(PreparedStatement preparedStatement)
Sets this JdbcRowSet object's preparedtsatement property to the given PreparedStatemennt object. |
|
protected void | setProperties(PreparedStatement ps)
|
|
protected void | setResultSet(ResultSet resultSet)
Sets this JdbcRowSet object's resultset property to the given ResultSet object. |
|
void | setRowId(int parameterIndex, RowId x)
Sets the designated parameter to the given java.sql.RowId object. |
|
void | setRowId(java.lang.String parameterName, RowId x)
Sets the designated parameter to the given java.sql.RowId object. |
|
void | setShort(java.lang.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(java.lang.String parameterName, SQLXML xmlObject)
Sets the designated parameter to the given java.sql.SQLXML object. |
|
void | setString(java.lang.String parameterName, java.lang.String x)
Sets the designated parameter to the given Java String value. |
|
void | setTime(java.lang.String parameterName, Time x)
Sets the designated parameter to the given java.sql.Time value. |
|
void | setTime(java.lang.String parameterName, Time x, java.util.Calendar cal)
Sets the designated parameter to the given java.sql.Time value, using the given Calendar object. |
|
void | setTimestamp(java.lang.String parameterName, Timestamp x)
Sets the designated parameter to the given java.sql.Timestamp value. |
|
void | setTimestamp(java.lang.String parameterName, Timestamp x, java.util.Calendar cal)
Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object. |
|
void | setTransactionIsolation(int transIso)
Sets the transaction isolation property for this JDBC RowSet object to the given constant. |
|
void | setType(int type)
Sets the type for this RowSet object to the specified type. |
|
void | setURL(int parameterIndex, java.net.URL x)
Sets the designated parameter to the given java.net.URL value. |
|
void | setUrl(java.lang.String url)
Sets the Url property for this JdbcRowSet object to the given String object and sets the dataSource name property to null . |
|
void | setUsername(java.lang.String uname)
Sets the username property for this JdbcRowSet object to the given user name. |
|
void | unsetMatchColumn(int columnIdx)
Unsets the designated parameter to the given int object. |
|
void | unsetMatchColumn(int[] columnIdxes)
Unsets the designated parameter to the given int array. |
|
void | unsetMatchColumn(java.lang.String columnName)
Unsets the designated parameter to the given String object. |
|
void | unsetMatchColumn(java.lang.String[] columnIdxes)
Unsets the designated parameter to the given String array. |
|
| unwrap(java.lang.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. |
|
void | updateArray(int columnIndex, Array a)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given java.sql.Array values. |
|
void | updateArray(java.lang.String columnName, Array a)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given java.sql.Array value. |
|
void | updateAsciiStream(int columnIndex, java.io.InputStream x)
Updates the designated column with an ascii stream value. |
|
void | updateAsciiStream(int columnIndex, java.io.InputStream x, int length)
Updates the designated column with an ascii stream value. |
|
void | updateAsciiStream(int columnIndex, java.io.InputStream x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes. |
|
void | updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x)
Updates the designated column with an ascii stream value. |
|
void | updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length)
Updates the designated column with an ascii stream value. |
|
void | updateAsciiStream(java.lang.String columnLabel, java.io.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, java.math.BigDecimal x)
Updates the designated column with a java.math.BigDecimal value. |
|
void | updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x)
Updates the designated column with a java.sql.BigDecimal value. |
|
void | updateBinaryStream(int columnIndex, java.io.InputStream x)
Updates the designated column with a binary stream value. |
|
void | updateBinaryStream(int columnIndex, java.io.InputStream x, int length)
Updates the designated column with a binary stream value. |
|
void | updateBinaryStream(int columnIndex, java.io.InputStream x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes. |
|
void | updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x)
Updates the designated column with a binary stream value. |
|
void | updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length)
Updates the designated column with a binary stream value. |
|
void | updateBinaryStream(java.lang.String columnLabel, java.io.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, Blob b)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given java.sql.Blob value. |
|
void | updateBlob(int columnIndex, java.io.InputStream inputStream)
Updates the designated column using the given input stream. |
|
void | updateBlob(int columnIndex, java.io.InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes. |
|
void | updateBlob(java.lang.String columnName, Blob b)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given java.sql.Blob value. |
|
void | updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream)
Updates the designated column using the given input stream. |
|
void | updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes. |
|
void | updateBoolean(int columnIndex, boolean x)
Updates the designated column with a boolean value. |
|
void | updateBoolean(java.lang.String columnName, 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(java.lang.String columnName, 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(java.lang.String columnName, byte[] x)
Updates the designated column with a boolean value. |
|
void | updateCharacterStream(int columnIndex, java.io.Reader x)
Updates the designated column with a character stream value. |
|
void | updateCharacterStream(int columnIndex, java.io.Reader x, int length)
Updates the designated column with a character stream value. |
|
void | updateCharacterStream(int columnIndex, java.io.Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void | updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
Updates the designated column with a character stream value. |
|
void | updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length)
Updates the designated column with a character stream value. |
|
void | updateCharacterStream(java.lang.String columnLabel, java.io.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, Clob c)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given double value. |
|
void | updateClob(int columnIndex, java.io.Reader reader)
Updates the designated column using the given Reader object. |
|
void | updateClob(int columnIndex, java.io.Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long. |
|
void | updateClob(java.lang.String columnName, Clob c)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given double value. |
|
void | updateClob(java.lang.String columnLabel, java.io.Reader reader)
Updates the designated column using the given Reader object. |
|
void | updateClob(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long. |
|
void | updateDate(int columnIndex, Date x)
Updates the designated column with a java.sql.Date value. |
|
void | updateDate(java.lang.String columnName, 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(java.lang.String columnName, 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(java.lang.String columnName, 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(java.lang.String columnName, 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(java.lang.String columnName, long x)
Updates the designated column with a long value. |
|
void | updateNCharacterStream(int columnIndex, java.io.Reader x)
Updates the designated column with a character stream value. |
|
void | updateNCharacterStream(int columnIndex, java.io.Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void | updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
Updates the designated column with a character stream value. |
|
void | updateNCharacterStream(java.lang.String columnName, java.io.Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. |
|
void | updateNClob(int columnIndex, NClob nClob)
Updates the designated column with a java.sql.NClob value. |
|
void | updateNClob(int columnIndex, java.io.Reader reader)
Updates the designated column using the given Reader object. |
|
void | updateNClob(int columnIndex, java.io.Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long. |
|
void | updateNClob(java.lang.String columnName, NClob nClob)
This method is used for updating SQL NCLOB type that maps to java.sql.Types.NCLOB |
|
void | updateNClob(java.lang.String columnLabel, java.io.Reader reader)
Updates the designated column using the given Reader object. |
|
void | updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long. |
|
void | updateNString(int columnIndex, java.lang.String nString)
This method is used for updating columns that support National Character sets. |
|
void | updateNString(java.lang.String columnName, java.lang.String nString)
This method is used for updating columns that support National Character sets. |
|
void | updateNull(int columnIndex)
Gives a nullable column a null value. |
|
void | updateNull(java.lang.String columnName)
Updates the designated column with a null value. |
|
void | updateObject(int columnIndex, java.lang.Object x)
Updates the designated column with an Object value. |
|
void | updateObject(int columnIndex, java.lang.Object x, int scale)
Updates the designated column with an Object value. |
|
void | updateObject(java.lang.String columnName, java.lang.Object x)
Updates the designated column with an Object value. |
|
void | updateObject(java.lang.String columnName, java.lang.Object x, int scale)
Updates the designated column with an Object value. |
|
void | updateRef(int columnIndex, Ref ref)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given double value. |
|
void | updateRef(java.lang.String columnName, Ref ref)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given double value. |
|
void | updateRow()
Updates the underlying database with the new contents of the current row of this rowset's ResultSet object and notifies listeners that a row has changed. |
|
void | updateRowId(int columnIndex, RowId x)
Updates the designated column with a RowId value. |
|
void | updateRowId(java.lang.String columnName, 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(java.lang.String columnName, 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(java.lang.String columnName, SQLXML xmlObject)
Updates the designated column with a java.sql.SQLXML value. |
|
void | updateString(int columnIndex, java.lang.String x)
Updates the designated column with a String value. |
|
void | updateString(java.lang.String columnName, java.lang.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(java.lang.String columnName, 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(java.lang.String columnName, Timestamp x)
Updates the designated column with a java.sql.Timestamp value. |
|
boolean | wasNull()
Reports whether the last column read from this rowset's ResultSet object had a value of SQL NULL . |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface javax.sql.rowset.JdbcRowSet |
---|
getShowDeleted, setShowDeleted |
Methods inherited from interface java.sql.ResultSet |
---|
getFetchSize |
Field Detail |
---|
protected transient JdbcRowSetResourceBundleresBundle
Constructor Detail |
---|
public JdbcRowSetImpl()
JdbcRowSet
object. The new instance of JdbcRowSet
will serve as a proxy for the ResultSet
object it creates, and by so doing, it will make it possible to use the result set as a JavaBeans component. The following is true of a default JdbcRowSet
instance:
null
Hashtable
object for storing any parameters that are set JdbcRowSet
object must have its execute
method invoked before other public methods are called on it; otherwise, such method calls will cause an exception to be thrown.
SQLException
- [1] if any of its public methods are called prior to calling the execute
method; [2] if invalid JDBC driver properties are set or [3] if no connection to a data source exists. public JdbcRowSetImpl(Connection con) throws SQLException
JdbcRowSet
object given a valid Connection
object. The new instance of JdbcRowSet
will serve as a proxy for the ResultSet
object it creates, and by so doing, it will make it possible to use the result set as a JavaBeans component. The following is true of a default JdbcRowSet
instance:
null
Hashtable
object for storing any parameters that are set JdbcRowSet
object must have its execute
method invoked before other public methods are called on it; otherwise, such method calls will cause an exception to be thrown.
SQLException
- [1] if any of its public methods are called prior to calling the execute
method, [2] if invalid JDBC driver properties are set, or [3] if no connection to a data source exists. public JdbcRowSetImpl(java.lang.String url, java.lang.String user, java.lang.String password) throws SQLException
JdbcRowSet
object using the URL, username, and password arguments supplied. The new instance of JdbcRowSet
will serve as a proxy for the ResultSet
object it creates, and by so doing, it will make it possible to use the result set as a JavaBeans component. The following is true of a default JdbcRowSet
instance:
null
Hashtable
object for storing any parameters that are set
url
- - a JDBC URL for the database to which this JdbcRowSet
object will be connected. The form for a JDBC URL is jdbc:subprotocol:subname
. user
- - the database user on whose behalf the connection is being made password
- - the user's password SQLException
- if a database access error occurs public JdbcRowSetImpl(ResultSet res) throws SQLException
JdbcRowSet
object using the given valid ResultSet
object. The new instance of JdbcRowSet
will serve as a proxy for the ResultSet
object, and by so doing, it will make it possible to use the result set as a JavaBeans component. The following is true of a default JdbcRowSet
instance:
null
Hashtable
object for storing any parameters that are set
res
- a valid ResultSet
object SQLException
- if a database access occurs due to a non valid ResultSet handle. Method Detail |
---|
protected void initMetaData(RowSetMetaData md, ResultSetMetaData rsmd) throws SQLException
RowSetMetaData
object with the values in the given ResultSetMetaData
object.
md
- the RowSetMetaData
object for this JdbcRowSetImpl
object, which will be set with values from rsmd rsmd
- the ResultSetMetaData
object from which new values for md will be read SQLException
- if an error occurs protected void checkState() throws SQLException
SQLException
public void execute() throws SQLException
ResultSet
object for which this JdbcRowSet
object is a wrapper, effectively making the result set a JavaBeans component. Certain properties must have been set before this method is called so that it can establish a connection to a database and execute the query that will create the result set. If a DataSource
object will be used to create the connection, properties for the data source name, user name, and password must be set. If the DriverManager
will be used, the properties for the URL, user name, and password must be set. In either case, the property for the command must be set. If the command has placeholder parameters, those must also be set. This method throws an exception if the required properties are not set.
Other properties have default values that may optionally be set to new values. The execute
method will use the value for the command property to create a PreparedStatement
object and set its properties (escape processing, maximum field size, maximum number of rows, and query timeout limit) to be those of this rowset.
execute
in interface RowSet
SQLException
- if (1) a database access error occurs, (2) any required JDBC properties are not set, or (3) if an invalid connection exists. protected void setProperties(PreparedStatement ps) throws SQLException
SQLException
protected Connectionconnect() throws SQLException
SQLException
protected PreparedStatementprepare() throws SQLException
SQLException
public boolean next() throws SQLException
ResultSet
object down one row from its current position. A ResultSet
cursor is initially positioned before the first row; the first call to the method next
makes the first row the current row; the second call makes the second row the current row, and so on.If an input stream is open for the current row, a call to the method next
will implicitly close it. A ResultSet
object's warning chain is cleared when a new row is read.
next
in interface ResultSet
true
if the new current row is valid; false
if there are no more rows SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void close() throws SQLException
ResultSet
object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
Note: A ResultSet
object is automatically closed by the Statement
object that generated it when that Statement
object is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results. A ResultSet
object is also automatically closed when it is garbage collected.
close
in interface java.lang.AutoCloseable
close
in interface ResultSet
SQLException
- if a database access error occurs public boolean wasNull() throws SQLException
ResultSet
object had a value of SQL NULL
. Note that you must first call one of the getXXX
methods on a column to try to read its value and then call the method wasNull
to see if the value read was SQL NULL
.
wasNull
in interface ResultSet
true
if the last column value read was SQL NULL
and false
otherwise SQLException
- if a database access error occurs or this rowset does not have a currently valid connection, prepared statement, and result set public java.lang.String getString(int columnIndex) throws SQLException
ResultSet
object as a String
.
getString
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public boolean getBoolean(int columnIndex) throws SQLException
ResultSet
object as a boolean
.
getBoolean
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is false
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public byte getByte(int columnIndex) throws SQLException
ResultSet
object as a byte
.
getByte
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is 0
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public short getShort(int columnIndex) throws SQLException
ResultSet
object as a short
.
getShort
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is 0
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public int getInt(int columnIndex) throws SQLException
ResultSet
object as an int
.
getInt
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is 0
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public long getLong(int columnIndex) throws SQLException
ResultSet
object as a long
.
getLong
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is 0
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public float getFloat(int columnIndex) throws SQLException
ResultSet
object as a float
.
getFloat
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is 0
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public double getDouble(int columnIndex) throws SQLException
ResultSet
object as a double
.
getDouble
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is 0
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException
ResultSet
object as a java.sql.BigDecimal
.
getBigDecimal
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on scale
- the number of digits to the right of the decimal point NULL
, the value returned is null
SQLException
- if (1) database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public byte[] getBytes(int columnIndex) throws SQLException
ResultSet
object as a byte
array in the Java programming language. The bytes represent the raw values returned by the driver.
getBytes
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public DategetDate(int columnIndex) throws SQLException
ResultSet
object as a java.sql.Date
object in the Java programming language.
getDate
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public TimegetTime(int columnIndex) throws SQLException
ResultSet
object as a java.sql.Time
object in the Java programming language.
getTime
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public TimestampgetTimestamp(int columnIndex) throws SQLException
ResultSet
object as a java.sql.Timestamp
object in the Java programming language.
getTimestamp
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public java.io.InputStream getAsciiStream(int columnIndex) throws SQLException
ResultSet
object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR
values. The JDBC driver will do any necessary conversion from the database format into ASCII.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX
method implicitly closes the stream. Also, a stream may return 0
when the method InputStream.available
is called whether there is data available or not.
getAsciiStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is null
SQLException
- if (1) database access error occurs (2) this rowset does not have a currently valid connection, prepared statement, and result set public java.io.InputStream getUnicodeStream(int columnIndex) throws SQLException
getCharacterStream
in place of getUnicodeStream
ResultSet
object as as a stream of Unicode characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving largeLONGVARCHAR
values. The JDBC driver will do any necessary conversion from the database format into Unicode. The byte format of the Unicode stream must be Java UTF-8, as specified in the Java virtual machine specification.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX
method implicitly closes the stream. Also, a stream may return 0
when the method InputStream.available
is called whether there is data available or not.
getUnicodeStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public java.io.InputStream getBinaryStream(int columnIndex) throws SQLException
ResultSet
object as a binary stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY
values.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX
method implicitly closes the stream. Also, a stream may return 0
when the method InputStream.available
is called whether there is data available or not.
getBinaryStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public java.lang.String getString(java.lang.String columnName) throws SQLException
ResultSet
object as a String
.
getString
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public boolean getBoolean(java.lang.String columnName) throws SQLException
ResultSet
object as a boolean
.
getBoolean
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is false
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public byte getByte(java.lang.String columnName) throws SQLException
ResultSet
object as a byte
.
getByte
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is 0
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public short getShort(java.lang.String columnName) throws SQLException
ResultSet
object as a short
.
getShort
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is 0
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public int getInt(java.lang.String columnName) throws SQLException
ResultSet
object as an int
.
getInt
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is 0
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public long getLong(java.lang.String columnName) throws SQLException
ResultSet
object as a long
.
getLong
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is 0
SQLException
- if a database access error occurs or this rowset does not have a currently valid connection, prepared statement, and result set public float getFloat(java.lang.String columnName) throws SQLException
ResultSet
object as a float
.
getFloat
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is 0
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public double getDouble(java.lang.String columnName) throws SQLException
ResultSet
object as a double
.
getDouble
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is 0
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws SQLException
ResultSet
object as a java.math.BigDecimal
.
getBigDecimal
in interface ResultSet
columnName
- the SQL name of the column scale
- the number of digits to the right of the decimal point NULL
, the value returned is null
SQLException
- if (1) adatabase access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public byte[] getBytes(java.lang.String columnName) throws SQLException
ResultSet
object as a byte
array in the Java programming language. The bytes represent the raw values returned by the driver.
getBytes
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public DategetDate(java.lang.String columnName) throws SQLException
ResultSet
object as a java.sql.Date
object in the Java programming language.
getDate
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public TimegetTime(java.lang.String columnName) throws SQLException
ResultSet
object as a java.sql.Time
object in the Java programming language.
getTime
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public TimestampgetTimestamp(java.lang.String columnName) throws SQLException
ResultSet
object as a java.sql.Timestamp
object.
getTimestamp
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public java.io.InputStream getAsciiStream(java.lang.String columnName) throws SQLException
ResultSet
object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR
values. The JDBC driver will do any necessary conversion from the database format into ASCII.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX
method implicitly closes the stream. Also, a stream may return 0
when the method available
is called whether there is data available or not.
getAsciiStream
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is null
. SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public java.io.InputStream getUnicodeStream(java.lang.String columnName) throws SQLException
ResultSet
object as a stream of Unicode characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR
values. The JDBC driver will do any necessary conversion from the database format into Unicode. The byte format of the Unicode stream must be Java UTF-8, as defined in the Java virtual machine specification.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX
method implicitly closes the stream. Also, a stream may return 0
when the method available
is called whether there is data available or not.
getUnicodeStream
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is null
. SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public java.io.InputStream getBinaryStream(java.lang.String columnName) throws SQLException
ResultSet
object as a stream of uninterpreted byte
s. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY
values.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX
method implicitly closes the stream. Also, a stream may return 0
when the method available
is called whether there is data available or not.
getBinaryStream
in interface ResultSet
columnName
- the SQL name of the column NULL
, the result is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public SQLWarninggetWarnings() throws SQLException
ResultSet
object. Subsequent warnings on this rowset's ResultSet
object will be chained to the SQLWarning
object that this method returns.The warning chain is automatically cleared each time a new row is read.
Note: This warning chain only covers warnings caused by ResultSet
methods. Any warning caused by Statement
methods (such as reading OUT parameters) will be chained on the Statement
object.
getWarnings
in interface ResultSet
SQLWarning
object reported or null
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public void clearWarnings() throws SQLException
ResultSet
object. After this method is called, the method getWarnings
returns null
until a new warning is reported for this rowset's ResultSet
object.
clearWarnings
in interface ResultSet
SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public java.lang.String getCursorName() throws SQLException
ResultSet
object.In SQL, a result table is retrieved through a cursor that is named. The current row of a result set can be updated or deleted using a positioned update/delete statement that references the cursor name. To insure that the cursor has the proper isolation level to support update, the cursor's select
statement should be of the form 'select for update'. If the 'for update' clause is omitted, the positioned updates may fail.
The JDBC API supports this SQL feature by providing the name of the SQL cursor used by a ResultSet
object. The current row of a ResultSet
object is also the current row of this SQL cursor.
Note: If positioned update is not supported, a SQLException
is thrown.
getCursorName
in interface ResultSet
ResultSet
object's cursor SQLException
- if (1) a database access error occurs or (2) xthis rowset does not have a currently valid connection, prepared statement, and result set public ResultSetMetaDatagetMetaData() throws SQLException
ResultSet
object's columns.
getMetaData
in interface ResultSet
ResultSet
object's columns SQLException
- if (1) a database access error occurs or (2) this rowset does not have a currently valid connection, prepared statement, and result set public java.lang.Object getObject(int columnIndex) throws SQLException
Gets the value of the designated column in the current row of this rowset's ResultSet
object as an Object
.
This method will return the value of the given column as a Java object. The type of the Java object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.
This method may also be used to read datatabase-specific abstract data types. In the JDBC 3.0 API, the behavior of method getObject
is extended to materialize data of SQL user-defined types. When a column contains a structured or distinct value, the behavior of this method is as if it were a call to: getObject(columnIndex, this.getStatement().getConnection().getTypeMap())
.
getObject
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on java.lang.Object
holding the column value SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public java.lang.Object getObject(java.lang.String columnName) throws SQLException
Gets the value of the designated column in the current row of this rowset's ResultSet
object as an Object
.
This method will return the value of the given column as a Java object. The type of the Java object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.
This method may also be used to read datatabase-specific abstract data types. In the JDBC 3.0 API, the behavior of the method getObject
is extended to materialize data of SQL user-defined types. When a column contains a structured or distinct value, the behavior of this method is as if it were a call to: getObject(columnIndex, this.getStatement().getConnection().getTypeMap())
.
getObject
in interface ResultSet
columnName
- the SQL name of the column java.lang.Object
holding the column value SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public int findColumn(java.lang.String columnName) throws SQLException
JdbcRowSetImpl
column name to its JdbcRowSetImpl
column index and reflects this on the internal ResultSet
object.
findColumn
in interface ResultSet
columnName
- the name of the column SQLException
- if (1) a database access error occurs (2) this rowset does not have a currently valid connection, prepared statement, and result set public java.io.Reader getCharacterStream(int columnIndex) throws SQLException
ResultSet
object as a java.io.Reader
object.
getCharacterStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on java.io.Reader
object that contains the column value; if the value is SQL NULL
, the value returned is null
. SQLException
- if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set public java.io.Reader getCharacterStream(java.lang.String columnName) throws SQLException
ResultSet
object as a java.io.Reader
object.
getCharacterStream
in interface ResultSet
columnName
- the name of the column java.io.Reader
object that contains the column value; if the value is SQL NULL
, the value returned is null
. SQLException
- if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set public java.math.BigDecimal getBigDecimal(int columnIndex) throws SQLException
ResultSet
object as a java.math.BigDecimal
with full precision.
getBigDecimal
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on NULL
, the value returned is null
. SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws SQLException
ResultSet
object as a java.math.BigDecimal
with full precision.
getBigDecimal
in interface ResultSet
columnName
- the column name NULL
, the value returned is null
. SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public boolean isBeforeFirst() throws SQLException
ResultSet
object.
isBeforeFirst
in interface ResultSet
true
if the cursor is before the first row; false
if the cursor is at any other position or the result set contains no rows SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public boolean isAfterLast() throws SQLException
ResultSet
object.
isAfterLast
in interface ResultSet
true
if the cursor is after the last row; false
if the cursor is at any other position or the result set contains no rows SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public boolean isFirst() throws SQLException
ResultSet
object.
isFirst
in interface ResultSet
true
if the cursor is on the first row; false
otherwise SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public boolean isLast() throws SQLException
ResultSet
object. Note: Calling the method isLast
may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.
isLast
in interface ResultSet
true
if the cursor is on the last row; false
otherwise SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void beforeFirst() throws SQLException
ResultSet
object, just before the first row. This method has no effect if the result set contains no rows.
beforeFirst
in interface ResultSet
SQLException
- if (1) a database access error occurs, (2) the result set type is TYPE_FORWARD_ONLY
, or (3) this rowset does not currently have a valid connection, prepared statement, and result set public void afterLast() throws SQLException
ResultSet
object, just after the last row. This method has no effect if the result set contains no rows.
afterLast
in interface ResultSet
SQLException
- if (1) a database access error occurs, (2) the result set type is TYPE_FORWARD_ONLY
, or (3) this rowset does not currently have a valid connection, prepared statement, and result set public boolean first() throws SQLException
ResultSet
object.
first
in interface ResultSet
true
if the cursor is on a valid row; false
if there are no rows in the result set SQLException
- if (1) a database access error occurs, (2) the result set type is TYPE_FORWARD_ONLY
, or (3) this rowset does not currently have a valid connection, prepared statement, and result set public boolean last() throws SQLException
ResultSet
object.
last
in interface ResultSet
true
if the cursor is on a valid row; false
if there are no rows in the result set SQLException
- if (1) a database access error occurs, (2) the result set type is TYPE_FORWARD_ONLY
, or (3) this rowset does not currently have a valid connection, prepared statement, and result set public int getRow() throws SQLException
getRow
in interface ResultSet
0
if there is no current row SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public boolean absolute(int row) throws SQLException
ResultSet
object.If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.
If the given row number is negative, the cursor moves to an absolute row position with respect to the end of the result set. For example, calling the method absolute(-1)
positions the cursor on the last row, calling the method absolute(-2)
moves the cursor to the next-to-last row, and so on.
An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before the first row or after the last row.
Note: Calling absolute(1)
is the same as calling first()
. Calling absolute(-1)
is the same as calling last()
.
absolute
in interface ResultSet
row
- the number of the row to which the cursor should move. A value of zero indicates that the cursor will be positioned before the first row; a positive number indicates the row number counting from the beginning of the result set; a negative number indicates the row number counting from the end of the result set true
if the cursor is on the result set; false
otherwise SQLException
- if (1) a database access error occurs, (2) the row is 0
, (3) the result set type is TYPE_FORWARD_ONLY
, or (4) this rowset does not currently have a valid connection, prepared statement, and result set public boolean relative(int rows) throws SQLException
relative(0)
is valid, but does not change the cursor position.Note: Calling the method relative(1)
is different from calling the method next()
because is makes sense to call next()
when there is no current row, for example, when the cursor is positioned before the first row or after the last row of the result set.
relative
in interface ResultSet
rows
- an int
specifying the number of rows to move from the current row; a positive number moves the cursor forward; a negative number moves the cursor backward true
if the cursor is on a row; false
otherwise SQLException
- if (1) a database access error occurs, (2) there is no current row, (3) the result set type is TYPE_FORWARD_ONLY
, or (4) this rowset does not currently have a valid connection, prepared statement, and result set public boolean previous() throws SQLException
ResultSet
object.
Note: Calling the method previous()
is not the same as calling the method relative(-1)
because it makes sense to call previous()
when there is no current row.
previous
in interface ResultSet
true
if the cursor is on a valid row; false
if it is off the result set SQLException
- if (1) a database access error occurs, (2) the result set type is TYPE_FORWARD_ONLY
, or (3) this rowset does not currently have a valid connection, prepared statement, and result set public void setFetchDirection(int direction) throws SQLException
ResultSet
object will be processed. The initial value is determined by the Statement
object that produced this rowset's ResultSet
object. The fetch direction may be changed at any time.
setFetchDirection
in interface ResultSet
setFetchDirection
in class BaseRowSet
direction
- one of ResultSet.FETCH_FORWARD
, ResultSet.FETCH_REVERSE
, or ResultSet.FETCH_UNKNOWN
SQLException
- if (1) a database access error occurs, (2) the result set type is TYPE_FORWARD_ONLY
and the fetch direction is not FETCH_FORWARD
, or (3) this rowset does not currently have a valid connection, prepared statement, and result set Statement.setFetchDirection(int)
public int getFetchDirection() throws SQLException
ResultSet
object.
getFetchDirection
in interface ResultSet
getFetchDirection
in class BaseRowSet
ResultSet
object SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set BaseRowSet.setFetchDirection(int)
public void setFetchSize(int rows) throws SQLException
ResultSet
object. If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the Statement
object that created the result set. The fetch size may be changed at any time.
setFetchSize
in interface ResultSet
setFetchSize
in class BaseRowSet
rows
- the number of rows to fetch SQLException
- if (1) a database access error occurs, (2) the condition 0 <= rows <= this.getMaxRows()
is not satisfied, or (3) this rowset does not currently have a valid connection, prepared statement, and result set BaseRowSet.getFetchSize()
public int getType() throws SQLException
ResultSet
object.
getType
in interface ResultSet
getType
in class BaseRowSet
ResultSet
object SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set BaseRowSet.setType(int)
public int getConcurrency() throws SQLException
ResultSet
object. The concurrency used is determined by the Statement
object that created the result set.
getConcurrency
in interface ResultSet
getConcurrency
in class BaseRowSet
CONCUR_READ_ONLY
or CONCUR_UPDATABLE
SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set BaseRowSet.setConcurrency(int)
, BaseRowSet.isReadOnly()
public boolean rowUpdated() throws SQLException
rowUpdated
in interface ResultSet
true
if the row has been visibly updated by the owner or another, and updates are detected SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set DatabaseMetaData.updatesAreDetected(int)
public boolean rowInserted() throws SQLException
ResultSet
object can detect visible inserts.
rowInserted
in interface ResultSet
true
if a row has had an insertion and insertions are detected; false
otherwise SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set DatabaseMetaData.insertsAreDetected(int)
public boolean rowDeleted() throws SQLException
ResultSet
object can detect deletions.
rowDeleted
in interface ResultSet
true
if a row was deleted and deletions are detected; false
otherwise SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set DatabaseMetaData.deletesAreDetected(int)
public void updateNull(int columnIndex) throws SQLException
updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateNull
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateBoolean(int columnIndex, boolean x) throws SQLException
boolean
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBoolean
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateByte(int columnIndex, byte x) throws SQLException
byte
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateByte
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateShort(int columnIndex, short x) throws SQLException
short
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateShort
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateInt(int columnIndex, int x) throws SQLException
int
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateInt
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateLong(int columnIndex, long x) throws SQLException
long
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateLong
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateFloat(int columnIndex, float x) throws SQLException
float
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateFloat
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateDouble(int columnIndex, double x) throws SQLException
double
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateDouble
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws SQLException
java.math.BigDecimal
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBigDecimal
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateString(int columnIndex, java.lang.String x) throws SQLException
String
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateString
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateBytes(int columnIndex, byte[] x) throws SQLException
byte
array value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBytes
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateDate(int columnIndex, Date x) throws SQLException
java.sql.Date
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateDate
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateTime(int columnIndex, Time x) throws SQLException
java.sql.Time
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateTime
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException
java.sql.Timestamp
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateTimestamp
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws SQLException
updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateAsciiStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value length
- the length of the stream SQLException
- if (1) a database access error occurs (2) or this rowset does not currently have a valid connection, prepared statement, and result set public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws SQLException
updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBinaryStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value length
- the length of the stream SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws SQLException
updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateCharacterStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value length
- the length of the stream SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateObject(int columnIndex, java.lang.Object x, int scale) throws SQLException
Object
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateObject
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value scale
- for java.sql.Types.DECIMAl
or java.sql.Types.NUMERIC
types, this is the number of digits after the decimal point. For all other types this value will be ignored. SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateObject(int columnIndex, java.lang.Object x) throws SQLException
Object
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateObject
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on x
- the new column value SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateNull(java.lang.String columnName) throws SQLException
null
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateNull
in interface ResultSet
columnName
- the name of the column SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateBoolean(java.lang.String columnName, boolean x) throws SQLException
boolean
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBoolean
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateByte(java.lang.String columnName, byte x) throws SQLException
byte
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateByte
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateShort(java.lang.String columnName, short x) throws SQLException
short
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateShort
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateInt(java.lang.String columnName, int x) throws SQLException
int
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateInt
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateLong(java.lang.String columnName, long x) throws SQLException
long
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateLong
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateFloat(java.lang.String columnName, float x) throws SQLException
float
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateFloat
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateDouble(java.lang.String columnName, double x) throws SQLException
double
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateDouble
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws SQLException
java.sql.BigDecimal
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBigDecimal
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateString(java.lang.String columnName, java.lang.String x) throws SQLException
String
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateString
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateBytes(java.lang.String columnName, byte[] x) throws SQLException
boolean
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database. JDBC 2.0 Updates a column with a byte array value. The updateXXX
methods are used to update column values in the current row, or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBytes
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateDate(java.lang.String columnName, Date x) throws SQLException
java.sql.Date
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateDate
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateTime(java.lang.String columnName, Time x) throws SQLException
java.sql.Time
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateTime
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateTimestamp(java.lang.String columnName, Timestamp x) throws SQLException
java.sql.Timestamp
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateTimestamp
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws SQLException
updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateAsciiStream
in interface ResultSet
columnName
- the name of the column x
- the new column value length
- the length of the stream SQLException
- if a database access error occurs public void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws SQLException
updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBinaryStream
in interface ResultSet
columnName
- the name of the column x
- the new column value length
- the length of the stream SQLException
- if a database access error occurs public void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length) throws SQLException
updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateCharacterStream
in interface ResultSet
columnName
- the name of the column reader
- the new column Reader
stream value length
- the length of the stream SQLException
- if a database access error occurs public void updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws SQLException
Object
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateObject
in interface ResultSet
columnName
- the name of the column x
- the new column value scale
- for java.sql.Types.DECIMAL
or java.sql.Types.NUMERIC
types, this is the number of digits after the decimal point. For all other types this value will be ignored. SQLException
- if a database access error occurs public void updateObject(java.lang.String columnName, java.lang.Object x) throws SQLException
Object
value. The updateXXX
methods are used to update column values in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateObject
in interface ResultSet
columnName
- the name of the column x
- the new column value SQLException
- if a database access error occurs public void insertRow() throws SQLException
ResultSet
object and into the database and also notifies listeners that a row has changed. The cursor must be on the insert row when this method is called.
insertRow
in interface ResultSet
SQLException
- if (1) a database access error occurs, (2) this method is called when the cursor is not on the insert row, (3) not all non-nullable columns in the insert row have been given a value, or (4) this rowset does not currently have a valid connection, prepared statement, and result set public void updateRow() throws SQLException
ResultSet
object and notifies listeners that a row has changed. This method cannot be called when the cursor is on the insert row.
updateRow
in interface ResultSet
SQLException
- if (1) a database access error occurs, (2) this method is called when the cursor is on the insert row, (3) the concurrency of the result set is ResultSet.CONCUR_READ_ONLY
, or (4) this rowset does not currently have a valid connection, prepared statement, and result set public void deleteRow() throws SQLException
ResultSet
object and from the underlying database and also notifies listeners that a row has changed. This method cannot be called when the cursor is on the insert row.
deleteRow
in interface ResultSet
SQLException
- if a database access error occurs or if this method is called when the cursor is on the insert row SQLException
- if (1) a database access error occurs, (2) this method is called when the cursor is before the first row, after the last row, or on the insert row, (3) the concurrency of this rowset's result set is ResultSet.CONCUR_READ_ONLY
, or (4) this rowset does not currently have a valid connection, prepared statement, and result set public void refreshRow() throws SQLException
ResultSet
object with its most recent value in the database. This method cannot be called when the cursor is on the insert row.The refreshRow
method provides a way for an application to explicitly tell the JDBC driver to refetch a row(s) from the database. An application may want to call refreshRow
when caching or prefetching is being done by the JDBC driver to fetch the latest value of a row from the database. The JDBC driver may actually refresh multiple rows at once if the fetch size is greater than one.
All values are refetched subject to the transaction isolation level and cursor sensitivity. If refreshRow
is called after calling an updateXXX
method, but before calling the method updateRow
, then the updates made to the row are lost. Calling the method refreshRow
frequently will likely slow performance.
refreshRow
in interface ResultSet
SQLException
- if (1) a database access error occurs, (2) this method is called when the cursor is on the insert row, or (3) this rowset does not currently have a valid connection, prepared statement, and result set public void cancelRowUpdates() throws SQLException
ResultSet
object and notifies listeners that a row has changed. This method may be called after calling an updateXXX
method(s) and before calling the method updateRow
to roll back the updates made to a row. If no updates have been made or updateRow
has already been called, this method has no effect.
cancelRowUpdates
in interface ResultSet
SQLException
- if (1) a database access error occurs, (2) this method is called when the cursor is on the insert row, or (3) this rowset does not currently have a valid connection, prepared statement, and result set public void moveToInsertRow() throws SQLException
updateXXX
methods prior to inserting the row into the result set. Only the updateXXX
, getXXX
, and insertRow
methods may be called when the cursor is on the insert row. All of the columns in a result set must be given a value each time this method is called before calling insertRow
. An updateXXX
method must be called before a getXXX
method can be called on a column value.
moveToInsertRow
in interface ResultSet
SQLException
- if (1) a database access error occurs, (2) this rowset's ResultSet
object is not updatable, or (3) this rowset does not currently have a valid connection, prepared statement, and result set public void moveToCurrentRow() throws SQLException
moveToCurrentRow
in interface ResultSet
SQLException
- if (1) a database access error occurs, (2) this rowset's ResultSet
object is not updatable, or (3) this rowset does not currently have a valid connection, prepared statement, and result set public StatementgetStatement() throws SQLException
Statement
object that produced this ResultSet
object. If the result set was generated some other way, such as by a DatabaseMetaData
method, this method returns null
.
getStatement
in interface ResultSet
Statment
object that produced this rowset's ResultSet
object or null
if the result set was produced some other way SQLException
- if a database access error occurs public java.lang.Object getObject(int i, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws SQLException
ResultSet
object as an Object
. This method uses the given Map
object for the custom mapping of the SQL structured or distinct type that is being retrieved.
getObject
in interface ResultSet
i
- the first column is 1, the second is 2, and so on map
- a java.util.Map
object that contains the mapping from SQL type names to classes in the Java programming language Object
in the Java programming language representing the SQL value SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public RefgetRef(int i) throws SQLException
ResultSet
object as a Ref
object.
getRef
in interface ResultSet
i
- the first column is 1, the second is 2, and so on Ref
object representing an SQL REF
value SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public BlobgetBlob(int i) throws SQLException
ResultSet
object as a Blob
object.
getBlob
in interface ResultSet
i
- the first column is 1, the second is 2, and so on Blob
object representing the SQL BLOB
value in the specified column SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public ClobgetClob(int i) throws SQLException
ResultSet
object as a Clob
object.
getClob
in interface ResultSet
i
- the first column is 1, the second is 2, and so on Clob
object representing the SQL CLOB
value in the specified column SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public ArraygetArray(int i) throws SQLException
ResultSet
object as an Array
object.
getArray
in interface ResultSet
i
- the first column is 1, the second is 2, and so on. Array
object representing the SQL ARRAY
value in the specified column SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public java.lang.Object getObject(java.lang.String colName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws SQLException
ResultSet
object as an Object
. This method uses the specified Map
object for custom mapping if appropriate.
getObject
in interface ResultSet
colName
- the name of the column from which to retrieve the value map
- a java.util.Map
object that contains the mapping from SQL type names to classes in the Java programming language Object
representing the SQL value in the specified column SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public RefgetRef(java.lang.String colName) throws SQLException
ResultSet
object as a Ref
object.
getRef
in interface ResultSet
colName
- the column name Ref
object representing the SQL REF
value in the specified column SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public BlobgetBlob(java.lang.String colName) throws SQLException
ResultSet
object as a Blob
object.
getBlob
in interface ResultSet
colName
- the name of the column from which to retrieve the value Blob
object representing the SQL BLOB
value in the specified column SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public ClobgetClob(java.lang.String colName) throws SQLException
ResultSet
object as a Clob
object.
getClob
in interface ResultSet
colName
- the name of the column from which to retrieve the value Clob
object representing the SQL CLOB
value in the specified column SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public ArraygetArray(java.lang.String colName) throws SQLException
ResultSet
object as an Array
object.
getArray
in interface ResultSet
colName
- the name of the column from which to retrieve the value Array
object representing the SQL ARRAY
value in the specified column SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public DategetDate(int columnIndex, java.util.Calendar cal) throws SQLException
ResultSet
object as a java.sql.Date
object. This method uses the given calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.
getDate
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on cal
- the java.util.Calendar
object to use in constructing the date java.sql.Date
object; if the value is SQL NULL
, the value returned is null
SQLException
- if (1) a database access error occurs or (2) this rowset does not currently have a valid connection, prepared statement, and result set public DategetDate(java.lang.String columnName, java.util.Calendar cal) throws SQLException
ResultSet
object as a java.sql.Date
object. This method uses the given calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.
getDate
in interface ResultSet
columnName
- the SQL name of the column from which to retrieve the value cal
- the java.util.Calendar
object to use in constructing the date java.sql.Date
object; if the value is SQL NULL
, the value returned is null
SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public TimegetTime(int columnIndex, java.util.Calendar cal) throws SQLException
ResultSet
object as a java.sql.Time
object. This method uses the given calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.
getTime
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on cal
- the java.util.Calendar
object to use in constructing the time java.sql.Time
object; if the value is SQL NULL
, the value returned is null
in the Java programming language SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public TimegetTime(java.lang.String columnName, java.util.Calendar cal) throws SQLException
ResultSet
object as a java.sql.Time
object. This method uses the given calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.
getTime
in interface ResultSet
columnName
- the SQL name of the column cal
- the java.util.Calendar
object to use in constructing the time java.sql.Time
object; if the value is SQL NULL
, the value returned is null
in the Java programming language SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public TimestampgetTimestamp(int columnIndex, java.util.Calendar cal) throws SQLException
ResultSet
object as a java.sql.Timestamp
object. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.
getTimestamp
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, and so on cal
- the java.util.Calendar
object to use in constructing the timestamp java.sql.Timestamp
object; if the value is SQL NULL
, the value returned is null
SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public TimestampgetTimestamp(java.lang.String columnName, java.util.Calendar cal) throws SQLException
ResultSet
object as a java.sql.Timestamp
object. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.
getTimestamp
in interface ResultSet
columnName
- the SQL name of the column cal
- the java.util.Calendar
object to use in constructing the timestamp java.sql.Timestamp
object; if the value is SQL NULL
, the value returned is null
SQLException
- if a database access error occurs or this rowset does not currently have a valid connection, prepared statement, and result set public void updateRef(int columnIndex, Ref ref) throws SQLException
JdbcRowSetImpl
object with the given double
value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow()
must be called to update the database. If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
updateRef
in interface ResultSet
columnIndex
- the first column is 1
, the second is 2
, and so on; must be 1
or larger and equal to or less than the number of columns in this rowset ref
- the new Ref
column value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateRef(java.lang.String columnName, Ref ref) throws SQLException
JdbcRowSetImpl
object with the given double
value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow()
must be called to update the database. If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
updateRef
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case ref
- the new column value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateClob(int columnIndex, Clob c) throws SQLException
JdbcRowSetImpl
object with the given double
value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow()
must be called to update the database. If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
updateClob
in interface ResultSet
columnIndex
- the first column is 1
, the second is 2
, and so on; must be 1
or larger and equal to or less than the number of columns in this rowset c
- the new column Clob
value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateClob(java.lang.String columnName, Clob c) throws SQLException
JdbcRowSetImpl
object with the given double
value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow()
must be called to update the database. If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
updateClob
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case c
- the new column Clob
value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateBlob(int columnIndex, Blob b) throws SQLException
JdbcRowSetImpl
object with the given java.sql.Blob
value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow()
must be called to update the database. If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
updateBlob
in interface ResultSet
columnIndex
- the first column is 1
, the second is 2
, and so on; must be 1
or larger and equal to or less than the number of columns in this rowset b
- the new column Blob
value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateBlob(java.lang.String columnName, Blob b) throws SQLException
JdbcRowSetImpl
object with the given java.sql.Blob
value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow()
must be called to update the database. If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
updateBlob
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case b
- the new column Blob
value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateArray(int columnIndex, Array a) throws SQLException
JdbcRowSetImpl
object with the given java.sql.Array
values. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow()
must be called to update the database. If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
updateArray
in interface ResultSet
columnIndex
- the first column is 1
, the second is 2
, and so on; must be 1
or larger and equal to or less than the number of columns in this rowset a
- the new column Array
value SQLException
- if (1) the given column index is out of bounds, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public void updateArray(java.lang.String columnName, Array a) throws SQLException
JdbcRowSetImpl
object with the given java.sql.Array
value. This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method updateRow()
must be called to update the database. If the cursor is on the insert row, the method insertRow()
must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
updateArray
in interface ResultSet
columnName
- a String
object that must match the SQL name of a column in this rowset, ignoring case a
- the new column Array
value SQLException
- if (1) the given column name does not match the name of a column in this rowset, (2) the cursor is not on one of this rowset's rows or its insert row, or (3) this rowset is ResultSet.CONCUR_READ_ONLY
public java.net.URL getURL(int columnIndex) throws SQLException
getURL
in interface ResultSet
columnIndex
- the index of the column 1 is the first, 2 is the second,... java.net.URL
object; if the value is SQL NULL
, the value returned is null
in the Java programming language SQLException
- if the columnIndex is not valid; if a database access error occurs; this method is called on a closed result set or if a URL is malformed SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public java.net.URL getURL(java.lang.String columnName) throws SQLException
getURL
in interface ResultSet
columnName
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column java.net.URL
object; if the value is SQL NULL
, the value returned is null
in the Java programming language SQLException
- if the columnLabel is not valid; if a database access error occurs; this method is called on a closed result set or if a URL is malformed SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public RowSetWarninggetRowSetWarnings() throws SQLException
JdbcRowSetImpl
getRowSetWarnings
in interface JdbcRowSet
RowSetWarning
object reported on this JdbcRowSet
object or null
if there are none SQLException
- if this method is called on a closed JdbcRowSet
object RowSetWarning
public void unsetMatchColumn(int[] columnIdxes) throws SQLException
setMatchColumn
as the column which will form the basis of the join.The parameter value unset by this method should be same as was set.
unsetMatchColumn
in interface Joinable
columnIdxes
- the index into this rowset object's internal representation of parameter values SQLException
- if an error occurs or the parameter index is out of bounds or if the columnIdx is not the same as set using setMatchColumn(int [])
Joinable.setMatchColumn(int)
public void unsetMatchColumn(java.lang.String[] columnIdxes) throws SQLException
setMatchColumn
as the column which will form the basis of the join.The parameter value unset by this method should be same as was set.
unsetMatchColumn
in interface Joinable
columnIdxes
- the index into this rowset object's internal representation of parameter values SQLException
- if an error occurs or the parameter index is out of bounds or if the columnName is not the same as set using setMatchColumn(String [])
Joinable.setMatchColumn(int)
public java.lang.String[] getMatchColumnNames() throws SQLException
String
array that was set using setMatchColumn(String [])
for this rowset.
getMatchColumnNames
in interface Joinable
String
array object that contains the column names for the rowset which has this the match columns SQLException
- if an error occurs or column name is not set Joinable.setMatchColumn(int)
, Joinable.unsetMatchColumn(int)
public int[] getMatchColumnIndexes() throws SQLException
int
array that was set using setMatchColumn(int [])
for this rowset.
getMatchColumnIndexes
in interface Joinable
int
array object that contains the column ids for the rowset which has this as the match columns. SQLException
- if an error occurs or column index is not set Joinable.setMatchColumn(int)
, Joinable.unsetMatchColumn(int)
public void setMatchColumn(int[] columnIdxes) throws SQLException
JoinRowSet
as the column which will form the basis of the join. The parameter value set by this method is stored internally and will be supplied as the appropriate parameter in this rowset's command when the method getMatchColumnIndexes
is called.
setMatchColumn
in interface Joinable
columnIdxes
- the indexes into this rowset object's internal representation of parameter values; the first parameter is 0, the second is 1, and so on; must be 0
or greater SQLException
- if an error occurs or the parameter index is out of bounds Joinable.setMatchColumn(int[])
, Joinable.unsetMatchColumn(int[])
public void setMatchColumn(java.lang.String[] columnNames) throws SQLException
JoinRowSet
as the column which will form the basis of the join. The parameter value set by this method is stored internally and will be supplied as the appropriate parameter in this rowset's command when the method getMatchColumn
is called.
setMatchColumn
in interface Joinable
columnNames
- the name of the column into this rowset object's internal representation of parameter values SQLException
- if an error occurs or the parameter index is out of bounds Joinable.unsetMatchColumn(int)
, Joinable.setMatchColumn(int[])
public void setMatchColumn(int columnIdx) throws SQLException
int
object. This forms the basis of the join for the JoinRowSet
as the column which will form the basis of the join. The parameter value set by this method is stored internally and will be supplied as the appropriate parameter in this rowset's command when the method getMatchColumn
is called.
setMatchColumn
in interface Joinable
columnIdx
- the index into this rowset object's internal representation of parameter values; the first parameter is 0, the second is 1, and so on; must be 0
or greater SQLException
- if an error occurs or the parameter index is out of bounds Joinable.setMatchColumn(int[])
, Joinable.unsetMatchColumn(int)
public void setMatchColumn(java.lang.String columnName) throws SQLException
String
object. This forms the basis of the join for the JoinRowSet
as the column which will form the basis of the join. The parameter value set by this method is stored internally and will be supplied as the appropriate parameter in this rowset's command when the method getMatchColumn
is called.
setMatchColumn
in interface Joinable
columnName
- the name of the column into this rowset object's internal representation of parameter values SQLException
- if an error occurs or the parameter index is out of bounds Joinable.unsetMatchColumn(int)
, Joinable.setMatchColumn(int[])
public void unsetMatchColumn(int columnIdx) throws SQLException
int
object. This was set using setMatchColumn
as the column which will form the basis of the join.The parameter value unset by this method should be same as was set.
unsetMatchColumn
in interface Joinable
columnIdx
- the index into this rowset object's internal representation of parameter values SQLException
- if an error occurs or the parameter index is out of bounds or if the columnIdx is not the same as set using setMatchColumn(int)
Joinable.setMatchColumn(int)
public void unsetMatchColumn(java.lang.String columnName) throws SQLException
String
object. This was set using setMatchColumn
as the column which will form the basis of the join.The parameter value unset by this method should be same as was set.
unsetMatchColumn
in interface Joinable
columnName
- the index into this rowset object's internal representation of parameter values SQLException
- if an error occurs or the parameter index is out of bounds or if the columnName is not the same as set using setMatchColumn(String)
Joinable.setMatchColumn(int)
public DatabaseMetaDatagetDatabaseMetaData() throws SQLException
DatabaseMetaData
associated with the connection handle associated this this JdbcRowSet
object.
DatabaseMetadata
associated with the rowset's connection. SQLException
- if a database access error occurs public ParameterMetaDatagetParameterMetaData() throws SQLException
ParameterMetaData
associated with the connection handle associated this this JdbcRowSet
object.
ParameterMetadata
associated with the rowset's connection. SQLException
- if a database access error occurs public void commit() throws SQLException
JdbcRowSet
object by wrapping the internal Connection
object and calling its commit
method. This method sets this JdbcRowSet
object's private field rs
to null
after saving its value to another object, but only if the ResultSet
constant HOLD_CURSORS_OVER_COMMIT
has not been set. (The field rs
is this JdbcRowSet
object's ResultSet
object.)
commit
in interface JdbcRowSet
SQLException
- if autoCommit is set to true or if a database access error occurs Connection.setAutoCommit(boolean)
public void setAutoCommit(boolean autoCommit) throws SQLException
Connection
object with this JdbcRowSet
setAutoCommit
in interface JdbcRowSet
SQLException
- if a database access error occurs Connection.setAutoCommit(boolean)
public boolean getAutoCommit() throws SQLException
JdbcRowSet
.
getAutoCommit
in interface JdbcRowSet
SQLException
- if a database access error occurs Connection.getAutoCommit()
public void rollback() throws SQLException
JdbcRowSet
object by wrapping the internal Connection
object and calling its rollback
method. This method sets this JdbcRowSet
object's private field rs
to null
after saving its value to another object. (The field rs
is this JdbcRowSet
object's internal ResultSet
object.)
rollback
in interface JdbcRowSet
SQLException
- if autoCommit is set to true or a database access error occurs JdbcRowSet.rollback(Savepoint)
public void rollback(Savepoint s) throws SQLException
JdbcRowSet
back to the last Savepoint
transaction marker. Wraps the internal Connection
object and call it's rollback method
rollback
in interface JdbcRowSet
s
- the Savepoint
transaction marker to roll the transaction to. SQLException
- if autoCommit is set to true; or ia a database access error occurs JdbcRowSet.rollback()
protected void setParams() throws SQLException
SQLException
protected ConnectiongetConnection()
JdbcRowSet
object's Connection property
Connection
object associated with this rowset; protected void setConnection(Connection connection)
JdbcRowSet
object's connection property to the given Connection
object.
connection
- the Connection
object. protected PreparedStatementgetPreparedStatement()
JdbcRowSet
object's PreparedStatement property
PreparedStatement
object associated with this rowset; protected void setPreparedStatement(PreparedStatement preparedStatement)
JdbcRowSet
object's preparedtsatement property to the given PreparedStatemennt
object.
preparedStatement
- the PreparedStatement
object protected ResultSetgetResultSet() throws SQLException
JdbcRowSet
object's ResultSet property
ResultSet
object associated with this rowset; SQLException
protected void setResultSet(ResultSet resultSet)
JdbcRowSet
object's resultset property to the given ResultSet
object.
resultSet
- the ResultSet
object public void setCommand(java.lang.String command) throws SQLException
JdbcRowSet
object's command
property to the given String
object and clears the parameters, if any, that were set for the previous command. In addition, if the command
property has previously been set to a non-null value and it is different from the String
object supplied, this method sets this JdbcRowSet
object's private fields ps
and rs
to null
. (The field ps
is its PreparedStatement
object, and the field rs
is its ResultSet
object.) The command
property may not be needed if the RowSet
object gets its data from a source that does not support commands, such as a spreadsheet or other tabular file. Thus, this property is optional and may be null
.
setCommand
in interface RowSet
setCommand
in class BaseRowSet
command
- a String
object containing an SQL query that will be set as this RowSet
object's command property; may be null
but may not be an empty string SQLException
- if an empty string is provided as the command value BaseRowSet.getCommand()
public void setDataSourceName(java.lang.String dsName) throws SQLException
dataSourceName
property for this JdbcRowSet
object to the given logical name and sets this JdbcRowSet
object's Url property to null
. In addition, if the dataSourceName
property has previously been set and is different from the one supplied, this method sets this JdbcRowSet
object's private fields ps
, rs
, and conn
to null
. (The field ps
is its PreparedStatement
object, the field rs
is its ResultSet
object, and the field conn
is its Connection
object.) The name supplied to this method must have been bound to a DataSource
object in a JNDI naming service so that an application can do a lookup using that name to retrieve the DataSource
object bound to it. The DataSource
object can then be used to establish a connection to the data source it represents.
Users should set either the Url property or the dataSourceName property. If both properties are set, the driver will use the property set most recently.
setDataSourceName
in interface RowSet
setDataSourceName
in class BaseRowSet
dsName
- a String
object with the name that can be supplied to a naming service based on JNDI technology to retrieve the DataSource
object that can be used to get a connection; may be null
SQLException
- if there is a problem setting the dataSourceName
property BaseRowSet.getDataSourceName()
public void setUrl(java.lang.String url) throws SQLException
JdbcRowSet
object to the given String
object and sets the dataSource name property to null
. In addition, if the Url property has previously been set to a non null
value and its value is different from the value to be set, this method sets this JdbcRowSet
object's private fields ps
, rs
, and conn
to null
. (The field ps
is its PreparedStatement
object, the field rs
is its ResultSet
object, and the field conn
is its Connection
object.) The Url property is a JDBC URL that is used when the connection is created using a JDBC technology-enabled driver ("JDBC driver") and the DriverManager
. The correct JDBC URL for the specific driver to be used can be found in the driver documentation. Although there are guidelines for for how a JDBC URL is formed, a driver vendor can specify any String
object except one with a length of 0
(an empty string).
Setting the Url property is optional if connections are established using a DataSource
object instead of the DriverManager
. The driver will use either the URL property or the dataSourceName property to create a connection, whichever was specified most recently. If an application uses a JDBC URL, it must load a JDBC driver that accepts the JDBC URL before it uses the RowSet
object to connect to a database. The RowSet
object will use the URL internally to create a database connection in order to read or write data.
setUrl
in interface RowSet
setUrl
in class BaseRowSet
url
- a String
object that contains the JDBC URL that will be used to establish the connection to a database for this RowSet
object; may be null
but must not be an empty string SQLException
- if an error occurs setting the Url property or the parameter supplied is a string with a length of 0
(an empty string) BaseRowSet.getUrl()
public void setUsername(java.lang.String uname)
JdbcRowSet
object to the given user name. Because it is not serialized, the username property is set at run time before calling the method execute
. In addition, if the username
property is already set with a non-null value and that value is different from the String
object to be set, this method sets this JdbcRowSet
object's private fields ps
, rs
, and conn
to null
. (The field ps
is its PreparedStatement
object, rs
is its ResultSet
object, and conn
is its Connection
object.) Setting these fields to null
ensures that only current values will be used.
setUsername
in interface RowSet
setUsername
in class BaseRowSet
uname
- the String
object containing the user name that is supplied to the data source to create a connection. It may be null. BaseRowSet.getUsername()
public void setPassword(java.lang.String password)
JdbcRowSet
object to the given String
object. Because it is not serialized, the password property is set at run time before calling the method execute
. Its default valus is null
. In addition, if the password
property is already set with a non-null value and that value is different from the one being set, this method sets this JdbcRowSet
object's private fields ps
, rs
, and conn
to null
. (The field ps
is its PreparedStatement
object, rs
is its ResultSet
object, and conn
is its Connection
object.) Setting these fields to null
ensures that only current values will be used.
setPassword
in interface RowSet
setPassword
in class BaseRowSet
password
- the String
object that represents the password that must be supplied to the database to create a connection BaseRowSet.getPassword()
public void setType(int type) throws SQLException
RowSet
object to the specified type. The default type is ResultSet.TYPE_SCROLL_INSENSITIVE
.
setType
in interface RowSet
setType
in class BaseRowSet
type
- one of the following constants: ResultSet.TYPE_FORWARD_ONLY
, ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
SQLException
- if the parameter supplied is not one of the following constants: ResultSet.TYPE_FORWARD_ONLY
or ResultSet.TYPE_SCROLL_INSENSITIVE
ResultSet.TYPE_SCROLL_SENSITIVE
getConcurrency()
, getType()
public void setConcurrency(int concur) throws SQLException
RowSet
object to the specified concurrency. The default concurrency for any RowSet
object (connected or disconnected) is ResultSet.CONCUR_UPDATABLE
, but this method may be called at any time to change the concurrency.
setConcurrency
in interface RowSet
setConcurrency
in class BaseRowSet
concur
- one of the following constants: ResultSet.CONCUR_READ_ONLY
or ResultSet.CONCUR_UPDATABLE
SQLException
- if the parameter supplied is not one of the following constants: ResultSet.CONCUR_UPDATABLE
or ResultSet.CONCUR_READ_ONLY
getConcurrency()
, BaseRowSet.isReadOnly()
public void setTransactionIsolation(int transIso) throws SQLException
RowSet
object to the given constant. The DBMS will use this transaction isolation level for transactions if it can. For RowSet
implementations such as the CachedRowSet
that operate in a disconnected environment, the SyncProvider
object being used offers complementary locking and data integrity options. The options described below are pertinent only to connected RowSet
objects (JdbcRowSet
objects).
setTransactionIsolation
in interface RowSet
setTransactionIsolation
in class BaseRowSet
transIso
- one of the following constants, listed in ascending order: Connection.TRANSACTION_NONE
, Connection.TRANSACTION_READ_UNCOMMITTED
, Connection.TRANSACTION_READ_COMMITTED
, Connection.TRANSACTION_REPEATABLE_READ
, or Connection.TRANSACTION_SERIALIZABLE
SQLException
- if the given parameter is not one of the Connection constants SyncFactory
, SyncProvider
, BaseRowSet.getTransactionIsolation()
public void setMaxRows(int mRows) throws SQLException
RowSet
object may contain to the given number. If this limit is exceeded, the excess rows are silently dropped.
setMaxRows
in interface RowSet
setMaxRows
in class BaseRowSet
mRows
- an int
indicating the current maximum number of rows; zero means that there is no limit SQLException
- if an error occurs internally setting the maximum limit on the number of rows that a JDBC RowSet
object can contain; or if max is less than 0
; or if max is less than the fetchSize
of the RowSet
RowSet.getMaxRows()
public SQLXMLgetSQLXML(int columnIndex) throws SQLException
SQL XML
parameter as a SQLXML
object in the Java programming language.
getSQLXML
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... SQLException
- if a database access error occurs public SQLXMLgetSQLXML(java.lang.String colName) throws SQLException
SQL XML
parameter as a SQLXML
object in the Java programming language.
getSQLXML
in interface ResultSet
colName
- the name of the column from which to retrieve the value SQLException
- if a database access error occurs public RowIdgetRowId(int columnIndex) throws SQLException
ResultSet
object as a java.sql.RowId object in the Java programming language.
getRowId
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... NULL
the value returned is null
SQLException
- if a database access error occurs public RowIdgetRowId(java.lang.String columnName) throws SQLException
ResultSet
object as a java.sql.RowId object in the Java programming language.
getRowId
in interface ResultSet
columnName
- the name of the column NULL
the value returned is null
SQLException
- if a database access error occurs public void updateRowId(int columnIndex, RowId x) throws SQLException
RowId
value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow
methods are called to update the database.
updateRowId
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... x
- the column value SQLException
- if a database access occurs public void updateRowId(java.lang.String columnName, RowId x) throws SQLException
RowId
value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow
methods are called to update the database.
updateRowId
in interface ResultSet
columnName
- the name of the column x
- the column value SQLException
- if a database access occurs public int getHoldability() throws SQLException
getHoldability
in interface ResultSet
SQLException
- if a database error occurs public boolean isClosed() throws SQLException
isClosed
in interface ResultSet
SQLException
- if a database access error occurs public void updateNString(int columnIndex, java.lang.String nString) throws SQLException
updateNString
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... nString
- the value for the column to be updated SQLException
- if a database access error occurs public void updateNString(java.lang.String columnName, java.lang.String nString) throws SQLException
updateNString
in interface ResultSet
columnName
- name of the Column nString
- the value for the column to be updated SQLException
- if a database access error occurs public void updateNClob(int columnIndex, NClob nClob) throws SQLException
ResultSet
java.sql.NClob
value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateNClob
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... nClob
- the value for the column to be updated SQLException
- if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateNClob(java.lang.String columnName, NClob nClob) throws SQLException
NCLOB
type that maps to java.sql.Types.NCLOB
updateNClob
in interface ResultSet
columnName
- name of the column nClob
- the value for the column to be updated SQLException
- if a database access error occurs public NClobgetNClob(int i) throws SQLException
ResultSet
object as a NClob
object in the Java programming language.
getNClob
in interface ResultSet
i
- the first column is 1, the second is 2, ... NClob
object representing the SQL NCLOB
value in the specified column SQLException
- if a database access error occurs public NClobgetNClob(java.lang.String colName) throws SQLException
ResultSet
object as a NClob
object in the Java programming language.
getNClob
in interface ResultSet
colName
- the name of the column from which to retrieve the value NClob
object representing the SQL NCLOB
value in the specified column SQLException
- if a database access error occurs public <T> T unwrap(java.lang.Class<T> iface) throws SQLException
Wrapper
unwrap
recursively on the wrapped object or a proxy for that result. If the receiver is not a wrapper and does not implement the interface, then an SQLException
is thrown.
unwrap
in interface Wrapper
iface
- A Class defining an interface that the result must implement. SQLException
- If no object found that implements the interface public boolean isWrapperFor(java.lang.Class<?> interfaces) throws SQLException
Wrapper
isWrapperFor
on the wrapped object. If this does not implement the interface and is not a wrapper, return false. This method should be implemented as a low-cost operation compared to unwrap
so that callers can use this method to avoid expensive unwrap
calls that may fail. If this method returns true then calling unwrap
with the same argument should succeed.
isWrapperFor
in interface Wrapper
interfaces
- a Class defining an interface. SQLException
- if an error occurs while determining whether this is a wrapper for an object with the given interface. public void setSQLXML(int parameterIndex, SQLXML xmlObject) throws SQLException
java.sql.SQLXML
object. The driver converts this to an SQL XML
value when it sends it to the database.
setSQLXML
in interface RowSet
setSQLXML
in class BaseRowSet
parameterIndex
- index of the first parameter is 1, the second is 2, ... xmlObject
- a SQLXML
object that maps an SQL XML
value SQLException
- if a database access error occurs public void setSQLXML(java.lang.String parameterName, SQLXML xmlObject) throws SQLException
java.sql.SQLXML
object. The driver converts this to an SQL XML
value when it sends it to the database.
setSQLXML
in interface RowSet
setSQLXML
in class BaseRowSet
parameterName
- the name of the parameter xmlObject
- a SQLXML
object that maps an SQL XML
value SQLException
- if a database access error occurs public void setRowId(int parameterIndex, RowId x) throws SQLException
java.sql.RowId
object. The driver converts this to a SQL ROWID
value when it sends it to the database
setRowId
in interface RowSet
setRowId
in class BaseRowSet
parameterIndex
- the first parameter is 1, the second is 2, ... x
- the parameter value SQLException
- if a database access error occurs public void setRowId(java.lang.String parameterName, RowId x) throws SQLException
java.sql.RowId
object. The driver converts this to a SQL ROWID
when it sends it to the database.
setRowId
in interface RowSet
setRowId
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs public void setNString(int parameterIndex, java.lang.String value) throws SQLException
String
object. The driver converts this to a SQL NCHAR
or NVARCHAR
or LONGNVARCHAR
value (depending on the argument's size relative to the driver's limits on NVARCHAR
values) when it sends it to the database.
setNString
in interface RowSet
setNString
in class BaseRowSet
parameterIndex
- of the first parameter is 1, the second is 2, ... value
- the parameter value SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; or if a database access error occurs public void setNCharacterStream(int parameterIndex, java.io.Reader value) throws SQLException
RowSet
object's command to a Reader
object. The Reader
reads the data till end-of-file is reached. The driver does the necessary conversion from Java character format to the national character set in the database.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setNCharacterStream
which takes a length parameter.
setNCharacterStream
in interface RowSet
setNCharacterStream
in class BaseRowSet
parameterIndex
- of the first parameter is 1, the second is 2, ... value
- the parameter value SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; if a database access error occurs; or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setNClob(java.lang.String parameterName, NClob value) throws SQLException
java.sql.NClob
object. The object implements the java.sql.NClob
interface. This NClob
object maps to a SQL NCLOB
.
setNClob
in interface RowSet
setNClob
in class BaseRowSet
parameterName
- the name of the column to be set value
- the parameter value SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs public java.io.Reader getNCharacterStream(int columnIndex) throws SQLException
ResultSet
object as a java.io.Reader
object. It is intended for use when accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNCharacterStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... java.io.Reader
object that contains the column value; if the value is SQL NULL
, the value returned is null
in the Java programming language. SQLException
- if a database access error occurs public java.io.Reader getNCharacterStream(java.lang.String columnName) throws SQLException
ResultSet
object as a java.io.Reader
object. It is intended for use when accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNCharacterStream
in interface ResultSet
columnName
- the name of the column java.io.Reader
object that contains the column value; if the value is SQL NULL
, the value returned is null
in the Java programming language SQLException
- if a database access error occurs public void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException
java.sql.SQLXML
value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateSQLXML
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... xmlObject
- the value for the column to be updated SQLException
- if a database access error occurs public void updateSQLXML(java.lang.String columnName, SQLXML xmlObject) throws SQLException
java.sql.SQLXML
value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateSQLXML
in interface ResultSet
columnName
- the name of the column xmlObject
- the column value SQLException
- if a database access occurs public java.lang.String getNString(int columnIndex) throws SQLException
ResultSet
object as a String
in the Java programming language. It is intended for use when accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNString
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... NULL
, the value returned is null
SQLException
- if a database access error occurs public java.lang.String getNString(java.lang.String columnName) throws SQLException
ResultSet
object as a String
in the Java programming language. It is intended for use when accessing NCHAR
,NVARCHAR
and LONGNVARCHAR
columns.
getNString
in interface ResultSet
columnName
- the SQL name of the column NULL
, the value returned is null
SQLException
- if a database access error occurs public void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws SQLException
updateNCharacterStream
in interface ResultSet
columnIndex
- - the first column is 1, the second is 2, ... x
- - the new column value length
- - the length of the stream SQLException
- if a database access error occurs public void updateNCharacterStream(java.lang.String columnName, java.io.Reader x, long length) throws SQLException
updateNCharacterStream
in interface ResultSet
columnName
- - name of the Column x
- - the new column value length
- - the length of the stream SQLException
- if a database access error occurs public void updateNCharacterStream(int columnIndex, java.io.Reader x) throws SQLException
NCHAR
,NVARCHAR
and LONGNVARCHAR
columns. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateNCharacterStream
which takes a length parameter.
updateNCharacterStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws SQLException
NCHAR
,NVARCHAR
and LONGNVARCHAR
columns. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateNCharacterStream
which takes a length parameter.
updateNCharacterStream
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column reader
- the java.io.Reader
object containing the new column value SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateBlob(int columnIndex, java.io.InputStream inputStream, long length) throws SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a java.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBlob
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... inputStream
- An object that contains the data to set the parameter value to. length
- the number of bytes in the parameter data. SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length) throws SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a java.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBlob
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column inputStream
- An object that contains the data to set the parameter value to. length
- the number of bytes in the parameter data. SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateBlob(int columnIndex, java.io.InputStream inputStream) throws SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a java.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateBlob
which takes a length parameter.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBlob
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... inputStream
- An object that contains the data to set the parameter value to. SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream) throws SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a java.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateBlob
which takes a length parameter.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBlob
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column inputStream
- An object that contains the data to set the parameter value to. SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateClob(int columnIndex, java.io.Reader reader, long length) throws SQLException
Reader
object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a java.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateClob
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... reader
- An object that contains the data to set the parameter value to. length
- the number of characters in the parameter data. SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws SQLException
Reader
object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a java.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateClob
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column reader
- An object that contains the data to set the parameter value to. length
- the number of characters in the parameter data. SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateClob(int columnIndex, java.io.Reader reader) throws SQLException
Reader
object. When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a java.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateClob
which takes a length parameter.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateClob
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... reader
- An object that contains the data to set the parameter value to. SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateClob(java.lang.String columnLabel, java.io.Reader reader) throws SQLException
Reader
object. When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a java.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateClob
which takes a length parameter.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateClob
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column reader
- An object that contains the data to set the parameter value to. SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateNClob(int columnIndex, java.io.Reader reader, long length) throws SQLException
Reader
object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a java.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateNClob
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... reader
- An object that contains the data to set the parameter value to. length
- the number of characters in the parameter data. SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateNClob(java.lang.String columnLabel, java.io.Reader reader, long length) throws SQLException
Reader
object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a java.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateNClob
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column reader
- An object that contains the data to set the parameter value to. length
- the number of characters in the parameter data. SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateNClob(int columnIndex, java.io.Reader reader) throws SQLException
Reader
object. When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a java.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateNClob
which takes a length parameter.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateNClob
in interface ResultSet
columnIndex
- the first column is 1, the second 2, ... reader
- An object that contains the data to set the parameter value to. SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateNClob(java.lang.String columnLabel, java.io.Reader reader) throws SQLException
Reader
object. When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a java.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateNClob
which takes a length parameter.
The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateNClob
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column reader
- An object that contains the data to set the parameter value to. SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws SQLException
updateRow
or insertRow
methods are called to update the database.
updateAsciiStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value length
- the length of the stream SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws SQLException
updateRow
or insertRow
methods are called to update the database.
updateBinaryStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value length
- the length of the stream SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws SQLException
updateRow
or insertRow
methods are called to update the database.
updateCharacterStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value length
- the length of the stream SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws SQLException
updateRow
or insertRow
methods are called to update the database.
updateAsciiStream
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column x
- the new column value length
- the length of the stream SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateAsciiStream(int columnIndex, java.io.InputStream x) throws SQLException
updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateAsciiStream
which takes a length parameter.
updateAsciiStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x) throws SQLException
updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateAsciiStream
which takes a length parameter.
updateAsciiStream
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column x
- the new column value SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length) throws SQLException
updateRow
or insertRow
methods are called to update the database.
updateBinaryStream
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column x
- the new column value length
- the length of the stream SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateBinaryStream(int columnIndex, java.io.InputStream x) throws SQLException
updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateBinaryStream
which takes a length parameter.
updateBinaryStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x) throws SQLException
updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateBinaryStream
which takes a length parameter.
updateBinaryStream
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column x
- the new column value SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length) throws SQLException
updateRow
or insertRow
methods are called to update the database.
updateCharacterStream
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column reader
- the java.io.Reader
object containing the new column value length
- the length of the stream SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateCharacterStream(int columnIndex, java.io.Reader x) throws SQLException
updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateCharacterStream
which takes a length parameter.
updateCharacterStream
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... x
- the new column value SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void updateCharacterStream(java.lang.String columnLabel, java.io.Reader reader) throws SQLException
updateRow
or insertRow
methods are called to update the database.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of updateCharacterStream
which takes a length parameter.
updateCharacterStream
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the la bel is the name of the column reader
- the java.io.Reader
object containing the new column value SQLException
- if a database access error occurs, the result set concurrency is CONCUR_READ_ONLY
or this method is called on a closed result set SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setURL(int parameterIndex, java.net.URL x) throws SQLException
java.net.URL
value. The driver converts this to an SQL DATALINK
value when it sends it to the database.
setURL
in interface RowSet
setURL
in class BaseRowSet
parameterIndex
- the first parameter is 1, the second is 2, ... x
- the java.net.URL
object to be set SQLException
- if a database access error occurs or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setNClob(int parameterIndex, java.io.Reader reader) throws SQLException
Reader
object. This method differs from the setCharacterStream (int, Reader)
method because it informs the driver that the parameter value should be sent to the server as a NCLOB
. When the setCharacterStream
method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGNVARCHAR
or a NCLOB
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setNClob
which takes a length parameter.
setNClob
in interface RowSet
setNClob
in class BaseRowSet
parameterIndex
- index of the first parameter is 1, the second is 2, ... reader
- An object that contains the data to set the parameter value to. SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws SQLException
Reader
object. The reader
must contain the number of characters specified by length otherwise a SQLException
will be generated when the CallableStatement
is executed. This method differs from the setCharacterStream (int, Reader, int)
method because it informs the driver that the parameter value should be sent to the server as a NCLOB
. When the setCharacterStream
method is used, the driver may have to do extra work to determine whether the parameter data should be send to the server as a LONGNVARCHAR
or a NCLOB
setNClob
in interface RowSet
setNClob
in class BaseRowSet
parameterName
- the name of the parameter to be set reader
- An object that contains the data to set the parameter value to. length
- the number of characters in the parameter data. SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if the length specified is less than zero; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setNClob(java.lang.String parameterName, java.io.Reader reader) throws SQLException
Reader
object. This method differs from the setCharacterStream (int, Reader)
method because it informs the driver that the parameter value should be sent to the server as a NCLOB
. When the setCharacterStream
method is used, the driver may have to do extra work to determine whether the parameter data should be send to the server as a LONGNVARCHAR
or a NCLOB
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setNClob
which takes a length parameter.
setNClob
in interface RowSet
setNClob
in class BaseRowSet
parameterName
- the name of the parameter reader
- An object that contains the data to set the parameter value to. SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setNClob(int parameterIndex, java.io.Reader reader, long length) throws SQLException
SQLException
will becontain the number generated when the PreparedStatement
is executed. This method differs from the setCharacterStream (int, Reader, int)
method because it informs the driver that the parameter value should be sent to the server as a NCLOB
. When the setCharacterStream
method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGNVARCHAR
or a NCLOB
setNClob
in interface RowSet
setNClob
in class BaseRowSet
parameterIndex
- index of the first parameter is 1, the second is 2, ... reader
- An object that contains the data to set the parameter value to. length
- the number of characters in the parameter data. SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if the length specified is less than zero; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs or this method is called on a closed PreparedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setNClob(int parameterIndex, NClob value) throws SQLException
java.sql.NClob
object. The driver converts this to a SQL NCLOB
value when it sends it to the database.
setNClob
in interface RowSet
setNClob
in class BaseRowSet
parameterIndex
- of the first parameter is 1, the second is 2, ... value
- the parameter value SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; or if a database access error occurs public void setNString(java.lang.String parameterName, java.lang.String value) throws SQLException
String
object. The driver converts this to a SQL NCHAR
or NVARCHAR
or LONGNVARCHAR
setNString
in interface RowSet
setNString
in class BaseRowSet
parameterName
- the name of the column to be set value
- the parameter value SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs public void setNCharacterStream(int parameterIndex, java.io.Reader value, long length) throws SQLException
Reader
object. The Reader
reads the data till end-of-file is reached. The driver does the necessary conversion from Java character format to the national character set in the database.
setNCharacterStream
in interface RowSet
setNCharacterStream
in class BaseRowSet
parameterIndex
- of the first parameter is 1, the second is 2, ... value
- the parameter value length
- the number of characters in the parameter data. SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; or if a database access error occurs public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws SQLException
Reader
object. The Reader
reads the data till end-of-file is reached. The driver does the necessary conversion from Java character format to the national character set in the database.
setNCharacterStream
in interface RowSet
setNCharacterStream
in class BaseRowSet
parameterName
- the name of the column to be set value
- the parameter value length
- the number of characters in the parameter data. SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; or if a database access error occurs public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws SQLException
Reader
object. The Reader
reads the data till end-of-file is reached. The driver does the necessary conversion from Java character format to the national character set in the database.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setNCharacterStream
which takes a length parameter.
setNCharacterStream
in interface RowSet
setNCharacterStream
in class BaseRowSet
parameterName
- the name of the parameter value
- the parameter value SQLException
- if the driver does not support national character sets; if the driver can detect that a data conversion error could occur ; if a database access error occurs; or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setTimestamp(java.lang.String parameterName, Timestamp x, java.util.Calendar cal) throws SQLException
java.sql.Timestamp
value, using the given Calendar
object. The driver uses the Calendar
object to construct an SQL TIMESTAMP
value, which the driver then sends to the database. With a a Calendar
object, the driver can calculate the timestamp taking into account a custom timezone. If no Calendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.
setTimestamp
in interface RowSet
setTimestamp
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value cal
- the Calendar
object the driver will use to construct the timestamp SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getTimestamp(int)
public void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws SQLException
Reader
object. The reader
must contain the number of characters specified by length otherwise a SQLException
will be generated when the CallableStatement
is executed. This method differs from the setCharacterStream (int, Reader, int)
method because it informs the driver that the parameter value should be sent to the server as a CLOB
. When the setCharacterStream
method is used, the driver may have to do extra work to determine whether the parameter data should be send to the server as a LONGVARCHAR
or a CLOB
setClob
in interface RowSet
setClob
in class BaseRowSet
parameterName
- the name of the parameter to be set reader
- An object that contains the data to set the parameter value to. length
- the number of characters in the parameter data. SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if the length specified is less than zero; a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setClob(java.lang.String parameterName, Clob x) throws SQLException
java.sql.Clob
object. The driver converts this to an SQL CLOB
value when it sends it to the database.
setClob
in interface RowSet
setClob
in class BaseRowSet
parameterName
- the name of the parameter x
- a Clob
object that maps an SQL CLOB
value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setClob(java.lang.String parameterName, java.io.Reader reader) throws SQLException
Reader
object. This method differs from the setCharacterStream (int, Reader)
method because it informs the driver that the parameter value should be sent to the server as a CLOB
. When the setCharacterStream
method is used, the driver may have to do extra work to determine whether the parameter data should be send to the server as a LONGVARCHAR
or a CLOB
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setClob
which takes a length parameter.
setClob
in interface RowSet
setClob
in class BaseRowSet
parameterName
- the name of the parameter reader
- An object that contains the data to set the parameter value to. SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setDate(java.lang.String parameterName, Date x) throws SQLException
java.sql.Date
value using the default time zone of the virtual machine that is running the application. The driver converts this to an SQL DATE
value when it sends it to the database.
setDate
in interface RowSet
setDate
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getDate(int)
public void setDate(java.lang.String parameterName, Date x, java.util.Calendar cal) throws SQLException
java.sql.Date
value, using the given Calendar
object. The driver uses the Calendar
object to construct an SQL DATE
value, which the driver then sends to the database. With a a Calendar
object, the driver can calculate the date taking into account a custom timezone. If no Calendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.
setDate
in interface RowSet
setDate
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value cal
- the Calendar
object the driver will use to construct the date SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getDate(int)
public void setTime(java.lang.String parameterName, Time x) throws SQLException
java.sql.Time
value. The driver converts this to an SQL TIME
value when it sends it to the database.
setTime
in interface RowSet
setTime
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getTime(int)
public void setTime(java.lang.String parameterName, Time x, java.util.Calendar cal) throws SQLException
java.sql.Time
value, using the given Calendar
object. The driver uses the Calendar
object to construct an SQL TIME
value, which the driver then sends to the database. With a a Calendar
object, the driver can calculate the time taking into account a custom timezone. If no Calendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.
setTime
in interface RowSet
setTime
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value cal
- the Calendar
object the driver will use to construct the time SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getTime(int)
public void setClob(int parameterIndex, java.io.Reader reader) throws SQLException
Reader
object. This method differs from the setCharacterStream (int, Reader)
method because it informs the driver that the parameter value should be sent to the server as a CLOB
. When the setCharacterStream
method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARCHAR
or a CLOB
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setClob
which takes a length parameter.
setClob
in interface RowSet
setClob
in class BaseRowSet
parameterIndex
- index of the first parameter is 1, the second is 2, ... reader
- An object that contains the data to set the parameter value to. SQLException
- if a database access error occurs, this method is called on a closed PreparedStatement
or if parameterIndex does not correspond to a parameter marker in the SQL statement SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setClob(int parameterIndex, java.io.Reader reader, long length) throws SQLException
Reader
object. The reader must contain the number of characters specified by length otherwise a SQLException
will be generated when the PreparedStatement
is executed. This method differs from the setCharacterStream (int, Reader, int)
method because it informs the driver that the parameter value should be sent to the server as a CLOB
. When the setCharacterStream
method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARCHAR
or a CLOB
setClob
in interface RowSet
setClob
in class BaseRowSet
parameterIndex
- index of the first parameter is 1, the second is 2, ... reader
- An object that contains the data to set the parameter value to. length
- the number of characters in the parameter data. SQLException
- if a database access error occurs, this method is called on a closed PreparedStatement
, if parameterIndex does not correspond to a parameter marker in the SQL statement, or if the length specified is less than zero. SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setBlob(int parameterIndex, java.io.InputStream inputStream, long length) throws SQLException
InputStream
object. The inputstream must contain the number of characters specified by length otherwise a SQLException
will be generated when the PreparedStatement
is executed. This method differs from the setBinaryStream (int, InputStream, int)
method because it informs the driver that the parameter value should be sent to the server as a BLOB
. When the setBinaryStream
method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARBINARY
or a BLOB
setBlob
in interface RowSet
setBlob
in class BaseRowSet
parameterIndex
- index of the first parameter is 1, the second is 2, ... inputStream
- An object that contains the data to set the parameter value to. length
- the number of bytes in the parameter data. SQLException
- if a database access error occurs, this method is called on a closed PreparedStatement
, if parameterIndex does not correspond to a parameter marker in the SQL statement, if the length specified is less than zero or if the number of bytes in the inputstream does not match the specfied length. SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setBlob(int parameterIndex, java.io.InputStream inputStream) throws SQLException
InputStream
object. This method differs from the setBinaryStream (int, InputStream)
This method differs from the setBinaryStream (int, InputStream)
method because it informs the driver that the parameter value should be sent to the server as a BLOB
. When the setBinaryStream
method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARBINARY
or a BLOB
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setBlob
which takes a length parameter.
setBlob
in interface RowSet
setBlob
in class BaseRowSet
parameterIndex
- index of the first parameter is 1, the second is 2, ... inputStream
- An object that contains the data to set the parameter value to. SQLException
- if a database access error occurs, this method is called on a closed PreparedStatement
or if parameterIndex does not correspond to a parameter marker in the SQL statement, SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws SQLException
InputStream
object. The inputstream
must contain the number of characters specified by length, otherwise a SQLException
will be generated when the CallableStatement
is executed. This method differs from the setBinaryStream (int, InputStream, int)
method because it informs the driver that the parameter value should be sent to the server as a BLOB
. When the setBinaryStream
method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARBINARY
or a BLOB
setBlob
in interface RowSet
setBlob
in class BaseRowSet
parameterName
- the name of the parameter to be set the second is 2, ... inputStream
- An object that contains the data to set the parameter value to. length
- the number of bytes in the parameter data. SQLException
- if parameterIndex does not correspond to a parameter marker in the SQL statement, or if the length specified is less than zero; if the number of bytes in the inputstream does not match the specfied length; if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setBlob(java.lang.String parameterName, Blob x) throws SQLException
java.sql.Blob
object. The driver converts this to an SQL BLOB
value when it sends it to the database.
setBlob
in interface RowSet
setBlob
in class BaseRowSet
parameterName
- the name of the parameter x
- a Blob
object that maps an SQL BLOB
value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws SQLException
InputStream
object. This method differs from the setBinaryStream (int, InputStream)
method because it informs the driver that the parameter value should be sent to the server as a BLOB
. When the setBinaryStream
method is used, the driver may have to do extra work to determine whether the parameter data should be send to the server as a LONGVARBINARY
or a BLOB
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setBlob
which takes a length parameter.
setBlob
in interface RowSet
setBlob
in class BaseRowSet
parameterName
- the name of the parameter inputStream
- An object that contains the data to set the parameter value to. SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws SQLException
java.lang
equivalent objects should be used.The given Java object will be converted to the given targetSqlType before being sent to the database. If the object has a custom mapping (is of a class implementing the interface SQLData
), the JDBC driver should call the method SQLData.writeSQL
to write it to the SQL data stream. If, on the other hand, the object is of a class implementing Ref
, Blob
, Clob
, NClob
, Struct
, java.net.URL
, or Array
, the driver should pass it to the database as a value of the corresponding SQL type.
Note that this method may be used to pass datatabase- specific abstract data types.
setObject
in interface RowSet
setObject
in class BaseRowSet
parameterName
- the name of the parameter x
- the object containing the input parameter value targetSqlType
- the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type. scale
- for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types, this value will be ignored. SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if targetSqlType
is a ARRAY
, BLOB
, CLOB
, DATALINK
, JAVA_OBJECT
, NCHAR
, NCLOB
, NVARCHAR
, LONGNVARCHAR
, REF
, ROWID
, SQLXML
or STRUCT
data type and the JDBC driver does not support this data type Types
, getObject(int)
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws SQLException
setObject
above, except that it assumes a scale of zero.
setObject
in interface RowSet
setObject
in class BaseRowSet
parameterName
- the name of the parameter x
- the object containing the input parameter value targetSqlType
- the SQL type (as defined in java.sql.Types) to be sent to the database SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if targetSqlType
is a ARRAY
, BLOB
, CLOB
, DATALINK
, JAVA_OBJECT
, NCHAR
, NCLOB
, NVARCHAR
, LONGNVARCHAR
, REF
, ROWID
, SQLXML
or STRUCT
data type and the JDBC driver does not support this data type getObject(int)
public void setObject(java.lang.String parameterName, java.lang.Object x) throws SQLException
Object
; therefore, the java.lang
equivalent objects should be used for built-in types.The JDBC specification specifies a standard mapping from Java Object
types to SQL types. The given argument will be converted to the corresponding SQL type before being sent to the database.
Note that this method may be used to pass datatabase- specific abstract data types, by using a driver-specific Java type. If the object is of a class implementing the interface SQLData
, the JDBC driver should call the method SQLData.writeSQL
to write it to the SQL data stream. If, on the other hand, the object is of a class implementing Ref
, Blob
, Clob
, NClob
, Struct
, java.net.URL
, or Array
, the driver should pass it to the database as a value of the corresponding SQL type.
This method throws an exception if there is an ambiguity, for example, if the object is of a class implementing more than one of the interfaces named above.
setObject
in interface RowSet
setObject
in class BaseRowSet
parameterName
- the name of the parameter x
- the object containing the input parameter value SQLException
- if a database access error occurs, this method is called on a closed CallableStatement
or if the given Object
parameter is ambiguous SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getObject(int)
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a java.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setAsciiStream
in interface RowSet
setAsciiStream
in class BaseRowSet
parameterName
- the name of the parameter x
- the Java input stream that contains the ASCII parameter value length
- the number of bytes in the stream SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length) throws SQLException
LONGVARBINARY
parameter, it may be more practical to send it via a java.io.InputStream
object. The data will be read from the stream as needed until end-of-file is reached.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setBinaryStream
in interface RowSet
setBinaryStream
in class BaseRowSet
parameterName
- the name of the parameter x
- the java input stream which contains the binary parameter value length
- the number of bytes in the stream SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws SQLException
Reader
object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a java.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setCharacterStream
in interface RowSet
setCharacterStream
in class BaseRowSet
parameterName
- the name of the parameter reader
- the java.io.Reader
object that contains the UNICODE data used as the designated parameter length
- the number of characters in the stream SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a java.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setAsciiStream
which takes a length parameter.
setAsciiStream
in interface RowSet
setAsciiStream
in class BaseRowSet
parameterName
- the name of the parameter x
- the Java input stream that contains the ASCII parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws SQLException
LONGVARBINARY
parameter, it may be more practical to send it via a java.io.InputStream
object. The data will be read from the stream as needed until end-of-file is reached.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setBinaryStream
which takes a length parameter.
setBinaryStream
in interface RowSet
setBinaryStream
in class BaseRowSet
parameterName
- the name of the parameter x
- the java input stream which contains the binary parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws SQLException
Reader
object. When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a java.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Note: Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setCharacterStream
which takes a length parameter.
setCharacterStream
in interface RowSet
setCharacterStream
in class BaseRowSet
parameterName
- the name of the parameter reader
- the java.io.Reader
object that contains the Unicode data SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws SQLException
java.math.BigDecimal
value. The driver converts this to an SQL NUMERIC
value when it sends it to the database.
setBigDecimal
in interface RowSet
setBigDecimal
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getBigDecimal(int, int)
public void setString(java.lang.String parameterName, java.lang.String x) throws SQLException
String
value. The driver converts this to an SQL VARCHAR
or LONGVARCHAR
value (depending on the argument's size relative to the driver's limits on VARCHAR
values) when it sends it to the database.
setString
in interface RowSet
setString
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getString(int)
public void setBytes(java.lang.String parameterName, byte[] x) throws SQLException
VARBINARY
or LONGVARBINARY
(depending on the argument's size relative to the driver's limits on VARBINARY
values) when it sends it to the database.
setBytes
in interface RowSet
setBytes
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getBytes(int)
public void setTimestamp(java.lang.String parameterName, Timestamp x) throws SQLException
java.sql.Timestamp
value. The driver converts this to an SQL TIMESTAMP
value when it sends it to the database.
setTimestamp
in interface RowSet
setTimestamp
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getTimestamp(int)
public void setNull(java.lang.String parameterName, int sqlType) throws SQLException
NULL
.Note: You must specify the parameter's SQL type.
setNull
in interface RowSet
setNull
in class BaseRowSet
parameterName
- the name of the parameter sqlType
- the SQL type code defined in java.sql.Types
SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws SQLException
NULL
. This version of the method setNull
should be used for user-defined types and REF type parameters. Examples of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types.Note: To be portable, applications must give the SQL type code and the fully-qualified SQL type name when specifying a NULL user-defined or REF parameter. In the case of a user-defined type the name is the type name of the parameter itself. For a REF parameter, the name is the type name of the referenced type. If a JDBC driver does not need the type code or type name information, it may ignore it. Although it is intended for user-defined and Ref parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the given typeName is ignored.
setNull
in interface RowSet
setNull
in class BaseRowSet
parameterName
- the name of the parameter sqlType
- a value from java.sql.Types
typeName
- the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQL REF
value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public void setBoolean(java.lang.String parameterName, boolean x) throws SQLException
boolean
value. The driver converts this to an SQL BIT
or BOOLEAN
value when it sends it to the database.
setBoolean
in interface RowSet
setBoolean
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getBoolean(int)
public void setByte(java.lang.String parameterName, byte x) throws SQLException
byte
value. The driver converts this to an SQL TINYINT
value when it sends it to the database.
setByte
in interface RowSet
setByte
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getByte(int)
public void setShort(java.lang.String parameterName, short x) throws SQLException
short
value. The driver converts this to an SQL SMALLINT
value when it sends it to the database.
setShort
in interface RowSet
setShort
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getShort(int)
public void setInt(java.lang.String parameterName, int x) throws SQLException
int
value. The driver converts this to an SQL INTEGER
value when it sends it to the database.
setInt
in interface RowSet
setInt
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getInt(int)
public void setLong(java.lang.String parameterName, long x) throws SQLException
long
value. The driver converts this to an SQL BIGINT
value when it sends it to the database.
setLong
in interface RowSet
setLong
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getLong(int)
public void setFloat(java.lang.String parameterName, float x) throws SQLException
float
value. The driver converts this to an SQL FLOAT
value when it sends it to the database.
setFloat
in interface RowSet
setFloat
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getFloat(int)
public void setDouble(java.lang.String parameterName, double x) throws SQLException
double
value. The driver converts this to an SQL DOUBLE
value when it sends it to the database.
setDouble
in interface RowSet
setDouble
in class BaseRowSet
parameterName
- the name of the parameter x
- the parameter value SQLException
- if a database access error occurs or this method is called on a closed CallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method getDouble(int)
public <T> T getObject(int columnIndex, java.lang.Class<T> type) throws SQLException
ResultSet
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. If the conversion is not supported or null is specified for the type, a SQLException
is thrown.
At a minimum, an implementation must support the conversions defined in Appendix B, Table B-3 and conversion of appropriate user defined SQL types to a Java type which implements SQLData
, or Struct
. Additional conversions may be supported and are vendor defined.
getObject
in interface ResultSet
columnIndex
- the first column is 1, the second is 2, ... type
- Class representing the Java data type to convert the designated column to. type
holding the column value SQLException
- if conversion is not supported, type is null or another error occurs. The getCause() method of the exception may provide a more detailed exception, for example, if a conversion error occurs SQLFeatureNotSupportedException
- if the JDBC driver does not support this method public <T> T getObject(java.lang.String columnLabel, java.lang.Class<T> type) throws SQLException
ResultSet
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. If the conversion is not supported or null is specified for the type, a SQLException
is thrown.
At a minimum, an implementation must support the conversions defined in Appendix B, Table B-3 and conversion of appropriate user defined SQL types to a Java type which implements SQLData
, or Struct
. Additional conversions may be supported and are vendor defined.
getObject
in interface ResultSet
columnLabel
- the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column type
- Class representing the Java data type to convert the designated column to. type
holding the column value SQLException
- if conversion is not supported, type is null or another error occurs. The getCause() method of the exception may provide a more detailed exception, for example, if a conversion error occurs SQLFeatureNotSupportedException
- if the JDBC driver does not support this method
| ||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES All Classes | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |