Field Summary

Method Summary

Field Details

• FETCH_FORWARD

  static final int FETCH_FORWARD

  The constant indicating that the rows in a result set will be processed in a forward direction; first-to-last. This constant is used by the methodsetFetchDirection as a hint to the driver, which the driver may ignore.

  Since:

  1.2

  See Also:

  • Constant Field Values

• FETCH_REVERSE

  static final int FETCH_REVERSE

  The constant indicating that the rows in a result set will be processed in a reverse direction; last-to-first. This constant is used by the methodsetFetchDirection as a hint to the driver, which the driver may ignore.

  Since:

  1.2

  See Also:

  • Constant Field Values

• FETCH_UNKNOWN

  static final int FETCH_UNKNOWN

  The constant indicating that the order in which rows in a result set will be processed is unknown. This constant is used by the methodsetFetchDirection as a hint to the driver, which the driver may ignore.

  See Also:

  • Constant Field Values

• TYPE_FORWARD_ONLY

  static final int TYPE_FORWARD_ONLY

  The constant indicating the type for aResultSet object whose cursor may move only forward.

  Since:

  1.2

  See Also:

  • Constant Field Values

• TYPE_SCROLL_INSENSITIVE

  static final int TYPE_SCROLL_INSENSITIVE

  The constant indicating the type for aResultSet object that is scrollable but generally not sensitive to changes to the data that underlies theResultSet.

  Since:

  1.2

  See Also:

  • Constant Field Values

• TYPE_SCROLL_SENSITIVE

  static final int TYPE_SCROLL_SENSITIVE

  The constant indicating the type for aResultSet object that is scrollable and generally sensitive to changes to the data that underlies theResultSet.

  Since:

  1.2

  See Also:

  • Constant Field Values

• CONCUR_READ_ONLY

  static final int CONCUR_READ_ONLY

  The constant indicating the concurrency mode for aResultSet object that may NOT be updated.

  Since:

  1.2

  See Also:

  • Constant Field Values

• CONCUR_UPDATABLE

  static final int CONCUR_UPDATABLE

  The constant indicating the concurrency mode for aResultSet object that may be updated.

  Since:

  1.2

  See Also:

  • Constant Field Values

• HOLD_CURSORS_OVER_COMMIT

  static final int HOLD_CURSORS_OVER_COMMIT

  The constant indicating that openResultSet objects with this holdability will remain open when the current transaction is committed.

  Since:

  1.4

  See Also:

  • Constant Field Values

• CLOSE_CURSORS_AT_COMMIT

  static final int CLOSE_CURSORS_AT_COMMIT

  The constant indicating that openResultSet objects with this holdability will be closed when the current transaction is committed.

  Since:

  1.4

  See Also:

  • Constant Field Values

Method Details

• next

  boolean next() throwsSQLException

  Moves the cursor forward one row from its current position. AResultSet cursor is initially positioned before the first row; the first call to the methodnext makes the first row the current row; the second call makes the second row the current row, and so on.

  When a call to thenext method returnsfalse, the cursor is positioned after the last row. Any invocation of aResultSet method which requires a current row will result in aSQLException being thrown. If the result set type isTYPE_FORWARD_ONLY, it is vendor specified whether their JDBC driver implementation will returnfalse or throw anSQLException on a subsequent call tonext.

  If an input stream is open for the current row, a call to the methodnext will implicitly close it. AResultSet object's warning chain is cleared when a new row is read.

  Returns:

  true if the new current row is valid;false if there are no more rows

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

• close

  void close() throwsSQLException

  Releases thisResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

  The closing of aResultSet object doesnot close theBlob,Clob orNClob objects created by theResultSet.Blob,Clob orNClob objects remain valid for at least the duration of the transaction in which they are created, unless theirfree method is invoked.

  When aResultSet is closed, anyResultSetMetaData instances that were created by calling thegetMetaData method remain accessible.

  Note: AResultSet object is automatically closed by theStatement object that generated it when thatStatement object is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results.

  Calling the methodclose on aResultSet object that is already closed is a no-op.

  Specified by:

  close in interface AutoCloseable

  Throws:

  SQLException - if a database access error occurs

• wasNull

  boolean wasNull() throwsSQLException

  Reports whether the last column read had a value of SQLNULL. Note that you must first call one of the getter methods on a column to try to read its value and then call the methodwasNull to see if the value read was SQLNULL.

  Returns:

  true if the last column value read was SQLNULL andfalse otherwise

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

• getString

  String getString(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aString in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getBoolean

  boolean getBoolean(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aboolean in the Java programming language.

  If the designated column has a datatype of CHAR or VARCHAR and contains a "0" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT and contains a 0, a value offalse is returned. If the designated column has a datatype of CHAR or VARCHAR and contains a "1" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT and contains a 1, a value oftrue is returned.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned isfalse

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getByte

  byte getByte(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as abyte in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned is0

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getShort

  short getShort(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ashort in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned is0

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getInt

  int getInt(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as anint in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned is0

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getLong

  long getLong(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as along in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned is0

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getFloat

  float getFloat(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as afloat in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned is0

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getDouble

  double getDouble(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as adouble in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned is0

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getBigDecimal

  @Deprecated(since="1.2")BigDecimal getBigDecimal(int columnIndex, int scale) throwsSQLException

  Deprecated.

  UsegetBigDecimal(int columnIndex) orgetBigDecimal(String columnLabel)

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.BigDecimal in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  scale - the number of digits to the right of the decimal point

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

• getBytes

  byte[] getBytes(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as abyte array in the Java programming language. The bytes represent the raw values returned by the driver.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getDate

  Date getDate(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.Date object in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getTime

  Time getTime(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.Time object in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getTimestamp

  Timestamp getTimestamp(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.Timestamp object in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getAsciiStream

  InputStream getAsciiStream(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet 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 largeLONGVARCHAR 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 getter method implicitly closes the stream. Also, a stream may return0 when the methodInputStream.available is called whether there is data available or not.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  a Java input stream that delivers the database column value as a stream of one-byte ASCII characters; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getUnicodeStream

  @Deprecated(since="1.2")InputStream getUnicodeStream(int columnIndex) throwsSQLException

  Deprecated.

  usegetCharacterStream in place ofgetUnicodeStream

  Retrieves the value of the designated column in the current row of thisResultSet object as as a stream of two-byte 3 characters. The first byte is the high byte; the second byte is the low byte. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving largeLONGVARCHARvalues. The JDBC driver will do any necessary conversion from the database format into Unicode.

  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 getter method implicitly closes the stream. Also, a stream may return0 when the methodInputStream.available is called, whether there is data available or not.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  a Java input stream that delivers the database column value as a stream of two-byte Unicode characters; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

• getBinaryStream

  InputStream getBinaryStream(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as a stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving largeLONGVARBINARY 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 getter method implicitly closes the stream. Also, a stream may return0 when the methodInputStream.available is called whether there is data available or not.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getString

  String getString(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aString in the Java programming language.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getBoolean

  boolean getBoolean(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aboolean in the Java programming language.

  If the designated column has a datatype of CHAR or VARCHAR and contains a "0" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT and contains a 0, a value offalse is returned. If the designated column has a datatype of CHAR or VARCHAR and contains a "1" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT and contains a 1, a value oftrue is returned.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned isfalse

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getByte

  byte getByte(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as abyte in the Java programming language.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned is0

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getShort

  short getShort(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ashort in the Java programming language.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned is0

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getInt

  int getInt(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as anint in the Java programming language.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned is0

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getLong

  long getLong(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as along in the Java programming language.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned is0

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getFloat

  float getFloat(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as afloat in the Java programming language.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned is0

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getDouble

  double getDouble(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as adouble in the Java programming language.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned is0

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getBigDecimal

  @Deprecated(since="1.2")BigDecimal getBigDecimal(String columnLabel, int scale) throwsSQLException

  Deprecated.

  UsegetBigDecimal(int columnIndex) orgetBigDecimal(String columnLabel)

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.math.BigDecimal in the Java programming language.

  Parameters:

  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

  scale - the number of digits to the right of the decimal point

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

• getBytes

  byte[] getBytes(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as abyte array in the Java programming language. The bytes represent the raw values returned by the driver.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getDate

  Date getDate(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.Date object in the Java programming language.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getTime

  Time getTime(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.Time object in the Java programming language.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getTimestamp

  Timestamp getTimestamp(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.Timestamp object in the Java programming language.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getAsciiStream

  InputStream getAsciiStream(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet 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 largeLONGVARCHAR 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 getter method implicitly closes the stream. Also, a stream may return0 when the methodavailable is called whether there is data available or not.

  Parameters:

  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

  Returns:

  a Java input stream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQLNULL, the value returned isnull.

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getUnicodeStream

  @Deprecated(since="1.2")InputStream getUnicodeStream(String columnLabel) throwsSQLException

  Deprecated.

  usegetCharacterStream instead

  Retrieves the value of the designated column in the current row of thisResultSet object as a stream of two-byte Unicode characters. The first byte is the high byte; the second byte is the low byte. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving largeLONGVARCHAR values. The JDBC technology-enabled driver will do any necessary conversion from the database format into Unicode.

  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 getter method implicitly closes the stream. Also, a stream may return0 when the methodInputStream.available is called, whether there is data available or not.

  Parameters:

  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

  Returns:

  a Java input stream that delivers the database column value as a stream of two-byte Unicode characters. If the value is SQLNULL, the value returned isnull.

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

• getBinaryStream

  InputStream getBinaryStream(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as a stream of uninterpretedbytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving largeLONGVARBINARY 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 getter method implicitly closes the stream. Also, a stream may return0 when the methodavailable is called whether there is data available or not.

  Parameters:

  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

  Returns:

  a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQLNULL, the result isnull

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• getWarnings

  SQLWarning getWarnings() throwsSQLException

  Retrieves the first warning reported by calls on thisResultSet object. Subsequent warnings on thisResultSet object will be chained to theSQLWarning object that this method returns.

  The warning chain is automatically cleared each time a new row is read. This method may not be called on aResultSet object that has been closed; doing so will cause anSQLException to be thrown.

  Note: This warning chain only covers warnings caused byResultSet methods. Any warning caused byStatement methods (such as reading OUT parameters) will be chained on theStatement object.

  Returns:

  the firstSQLWarning object reported ornull if there are none

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

• clearWarnings

  void clearWarnings() throwsSQLException

  Clears all warnings reported on thisResultSet object. After this method is called, the methodgetWarnings returnsnull until a new warning is reported for thisResultSet object.

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

• getCursorName

  String getCursorName() throwsSQLException

  Retrieves the name of the SQL cursor used by thisResultSet 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'sSELECT statement should be of the formSELECT FOR UPDATE. IfFOR UPDATE is omitted, the positioned updates may fail.

  The JDBC API supports this SQL feature by providing the name of the SQL cursor used by aResultSet object. The current row of aResultSet object is also the current row of this SQL cursor.

  Returns:

  the SQL name for thisResultSet object's cursor

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

• getMetaData

  ResultSetMetaData getMetaData() throwsSQLException

  Retrieves the number, types and properties of thisResultSet object's columns.

  Returns:

  the description of thisResultSet object's columns

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

• getObject

  Object getObject(int columnIndex) throwsSQLException

  Gets the value of the designated column in the current row of thisResultSet object as anObject in the Java programming language.

  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. If the value is an SQLNULL, the driver returns a Javanull.

  This method may also be used to read database-specific abstract data types. In the JDBC 2.0 API, the behavior of methodgetObject is extended to materialize data of SQL user-defined types.

  IfConnection.getTypeMap does not throw aSQLFeatureNotSupportedException, then 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()). IfConnection.getTypeMap does throw aSQLFeatureNotSupportedException, then structured values are not supported, and distinct values are mapped to the default Java class as determined by the underlying SQL type of the DISTINCT type.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  ajava.lang.Object holding the column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

• getObject

  Object getObject(String columnLabel) throwsSQLException

  Gets the value of the designated column in the current row of thisResultSet object as anObject in the Java programming language.

  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. If the value is an SQLNULL, the driver returns a Javanull.

  This method may also be used to read database-specific abstract data types.

  In the JDBC 2.0 API, the behavior of the methodgetObject 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()).

  Parameters:

  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

  Returns:

  ajava.lang.Object holding the column value

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

• findColumn

  int findColumn(String columnLabel) throwsSQLException

  Maps the givenResultSet column label to itsResultSet column index.

  Parameters:

  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

  Returns:

  the column index of the given column name

  Throws:

  SQLException - if theResultSet object does not contain a column labeledcolumnLabel, a database access error occurs or this method is called on a closed result set

• getCharacterStream

  Reader getCharacterStream(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.io.Reader object.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  ajava.io.Reader object that contains the column value; if the value is SQLNULL, the value returned isnull in the Java programming language.

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• getCharacterStream

  Reader getCharacterStream(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.io.Reader object.

  Parameters:

  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

  Returns:

  ajava.io.Reader object that contains the column value; if the value is SQLNULL, the value returned isnull in the Java programming language

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• getBigDecimal

  BigDecimal getBigDecimal(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.math.BigDecimal with full precision.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value (full precision); if the value is SQLNULL, the value returned isnull in the Java programming language.

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• getBigDecimal

  BigDecimal getBigDecimal(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.math.BigDecimal with full precision.

  Parameters:

  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

  Returns:

  the column value (full precision); if the value is SQLNULL, the value returned isnull in the Java programming language.

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• isBeforeFirst

  boolean isBeforeFirst() throwsSQLException

  Retrieves whether the cursor is before the first row in thisResultSet object.

  Note:Support for theisBeforeFirst method is optional forResultSets with a result set type ofTYPE_FORWARD_ONLY

  Returns:

  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

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• isAfterLast

  boolean isAfterLast() throwsSQLException

  Retrieves whether the cursor is after the last row in thisResultSet object.

  Note:Support for theisAfterLast method is optional forResultSets with a result set type ofTYPE_FORWARD_ONLY

  Returns:

  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

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• isFirst

  boolean isFirst() throwsSQLException

  Retrieves whether the cursor is on the first row of thisResultSet object.

  Note:Support for theisFirst method is optional forResultSets with a result set type ofTYPE_FORWARD_ONLY

  Returns:

  true if the cursor is on the first row;false otherwise

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• isLast

  boolean isLast() throwsSQLException

  Retrieves whether the cursor is on the last row of thisResultSet object.Note: Calling the methodisLast 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.

  Note: Support for theisLast method is optional forResultSets with a result set type ofTYPE_FORWARD_ONLY

  Returns:

  true if the cursor is on the last row;false otherwise

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• beforeFirst

  void beforeFirst() throwsSQLException

  Moves the cursor to the front of thisResultSet object, just before the first row. This method has no effect if the result set contains no rows.

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set or the result set type isTYPE_FORWARD_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• afterLast

  void afterLast() throwsSQLException

  Moves the cursor to the end of thisResultSet object, just after the last row. This method has no effect if the result set contains no rows.

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set or the result set type isTYPE_FORWARD_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• first

  boolean first() throwsSQLException

  Moves the cursor to the first row in thisResultSet object.

  Returns:

  true if the cursor is on a valid row;false if there are no rows in the result set

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set or the result set type isTYPE_FORWARD_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• last

  boolean last() throwsSQLException

  Moves the cursor to the last row in thisResultSet object.

  Returns:

  true if the cursor is on a valid row;false if there are no rows in the result set

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set or the result set type isTYPE_FORWARD_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• getRow

  int getRow() throwsSQLException

  Retrieves the current row number. The first row is number 1, the second number 2, and so on.

  Note:Support for thegetRow method is optional forResultSets with a result set type ofTYPE_FORWARD_ONLY

  Returns:

  the current row number;0 if there is no current row

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• absolute

  boolean absolute(int row) throwsSQLException

  Moves the cursor to the given row number in thisResultSet 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 methodabsolute(-1) positions the cursor on the last row; calling the methodabsolute(-2) moves the cursor to the next-to-last row, and so on.

  If the row number specified is zero, the cursor is moved to before the first row.

  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: Callingabsolute(1) is the same as callingfirst(). Callingabsolute(-1) is the same as callinglast().

  Parameters:

  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

  Returns:

  true if the cursor is moved to a position in thisResultSet object;false if the cursor is before the first row or after the last row

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set or the result set type isTYPE_FORWARD_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• relative

  boolean relative(int rows) throwsSQLException

  Moves the cursor a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the result set positions the cursor before/after the the first/last row. Callingrelative(0) is valid, but does not change the cursor position.

  Note: Calling the methodrelative(1) is identical to calling the methodnext() and calling the methodrelative(-1) is identical to calling the methodprevious().

  Parameters:

  rows - anint 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

  Returns:

  true if the cursor is on a row;false otherwise

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set or the result set type isTYPE_FORWARD_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• previous

  boolean previous() throwsSQLException

  Moves the cursor to the previous row in thisResultSet object.

  When a call to theprevious method returnsfalse, the cursor is positioned before the first row. Any invocation of aResultSet method which requires a current row will result in aSQLException being thrown.

  If an input stream is open for the current row, a call to the methodprevious will implicitly close it. AResultSet object's warning change is cleared when a new row is read.

  Returns:

  true if the cursor is now positioned on a valid row;false if the cursor is positioned before the first row

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set or the result set type isTYPE_FORWARD_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• setFetchDirection

  void setFetchDirection(int direction) throwsSQLException

  Gives a hint as to the direction in which the rows in thisResultSet object will be processed. The initial value is determined by theStatement object that produced thisResultSet object. The fetch direction may be changed at any time.

  Parameters:

  direction - anint specifying the suggested fetch direction; one ofResultSet.FETCH_FORWARD,ResultSet.FETCH_REVERSE, orResultSet.FETCH_UNKNOWN

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set or the result set type isTYPE_FORWARD_ONLY and the fetch direction is notFETCH_FORWARD

  Since:

  1.2

  See Also:

  • Statement.setFetchDirection(int)
  • getFetchDirection()

• getFetchDirection

  int getFetchDirection() throwsSQLException

  Retrieves the fetch direction for thisResultSet object.

  Returns:

  the current fetch direction for thisResultSet object

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

  See Also:

  • setFetchDirection(int)

• setFetchSize

  void setFetchSize(int rows) throwsSQLException

  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 thisResultSet 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 theStatement object that created the result set. The fetch size may be changed at any time.

  Parameters:

  rows - the number of rows to fetch

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set or the conditionrows >= 0 is not satisfied

  Since:

  1.2

  See Also:

  • getFetchSize()

• getFetchSize

  int getFetchSize() throwsSQLException

  Retrieves the fetch size for thisResultSet object.

  Returns:

  the current fetch size for thisResultSet object

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

  See Also:

  • setFetchSize(int)

• getType

  int getType() throwsSQLException

  Retrieves the type of thisResultSet object. The type is determined by theStatement object that created the result set.

  Returns:

  ResultSet.TYPE_FORWARD_ONLY,ResultSet.TYPE_SCROLL_INSENSITIVE, orResultSet.TYPE_SCROLL_SENSITIVE

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• getConcurrency

  int getConcurrency() throwsSQLException

  Retrieves the concurrency mode of thisResultSet object. The concurrency used is determined by theStatement object that created the result set.

  Returns:

  the concurrency type, eitherResultSet.CONCUR_READ_ONLY orResultSet.CONCUR_UPDATABLE

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• rowUpdated

  boolean rowUpdated() throwsSQLException

  Retrieves whether the current row has been updated. The value returned depends on whether or not the result set can detect updates.

  Note: Support for therowUpdated method is optional with a result set concurrency ofCONCUR_READ_ONLY

  Returns:

  true if the current row is detected to have been visibly updated by the owner or another;false otherwise

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

  See Also:

  • DatabaseMetaData.updatesAreDetected(int)

• rowInserted

  boolean rowInserted() throwsSQLException

  Retrieves whether the current row has had an insertion. The value returned depends on whether or not thisResultSet object can detect visible inserts.

  Note: Support for therowInserted method is optional with a result set concurrency ofCONCUR_READ_ONLY

  Returns:

  true if the current row is detected to have been inserted;false otherwise

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

  See Also:

  • DatabaseMetaData.insertsAreDetected(int)

• rowDeleted

  boolean rowDeleted() throwsSQLException

  Retrieves whether a row has been deleted. A deleted row may leave a visible "hole" in a result set. This method can be used to detect holes in a result set. The value returned depends on whether or not thisResultSet object can detect deletions.

  Note: Support for therowDeleted method is optional with a result set concurrency ofCONCUR_READ_ONLY

  Returns:

  true if the current row is detected to have been deleted by the owner or another;false otherwise

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

  See Also:

  • DatabaseMetaData.deletesAreDetected(int)

• updateNull

  void updateNull(int columnIndex) throwsSQLException

  Updates the designated column with anull 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateBoolean

  void updateBoolean(int columnIndex, boolean x) throwsSQLException

  Updates the designated column with aboolean 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateByte

  void updateByte(int columnIndex, byte x) throwsSQLException

  Updates the designated column with abyte 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateShort

  void updateShort(int columnIndex, short x) throwsSQLException

  Updates the designated column with ashort 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateInt

  void updateInt(int columnIndex, int x) throwsSQLException

  Updates the designated column with anint 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateLong

  void updateLong(int columnIndex, long x) throwsSQLException

  Updates the designated column with along 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateFloat

  void updateFloat(int columnIndex, float x) throwsSQLException

  Updates the designated column with afloat 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateDouble

  void updateDouble(int columnIndex, double x) throwsSQLException

  Updates the designated column with adouble 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateBigDecimal

  void updateBigDecimal(int columnIndex,BigDecimal x) throwsSQLException

  Updates the designated column with ajava.math.BigDecimal 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateString

  void updateString(int columnIndex,String x) throwsSQLException

  Updates the designated column with aString 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateBytes

  void updateBytes(int columnIndex, byte[] x) throwsSQLException

  Updates the designated column with abyte array 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateDate

  void updateDate(int columnIndex,Date x) throwsSQLException

  Updates the designated column with ajava.sql.Date 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateTime

  void updateTime(int columnIndex,Time x) throwsSQLException

  Updates the designated column with ajava.sql.Time 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateTimestamp

  void updateTimestamp(int columnIndex,Timestamp x) throwsSQLException

  Updates the designated column with ajava.sql.Timestamp 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateAsciiStream

  void updateAsciiStream(int columnIndex,InputStream x, int length) throwsSQLException

  Updates the designated column with an ascii stream value, which will have the specified number of bytes. 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  length - the length of the stream

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateBinaryStream

  void updateBinaryStream(int columnIndex,InputStream x, int length) throwsSQLException

  Updates the designated column with a binary stream value, which will have the specified number of bytes. 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  length - the length of the stream

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateCharacterStream

  void updateCharacterStream(int columnIndex,Reader x, int length) throwsSQLException

  Updates the designated column with a character stream value, which will have the specified number of bytes. 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  length - the length of the stream

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateObject

  void updateObject(int columnIndex,Object x, int scaleOrLength) throwsSQLException

  Updates the designated column with anObject 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 theupdateRow orinsertRow methods are called to update the database.

  If the second argument is anInputStream then the stream must contain the number of bytes specified by scaleOrLength. If the second argument is aReader then the reader must contain the number of characters specified by scaleOrLength. If these conditions are not true the driver will generate aSQLException when the statement is executed.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  scaleOrLength - for an object ofjava.math.BigDecimal , this is the number of digits after the decimal point. For Java Object typesInputStream andReader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateObject

  void updateObject(int columnIndex,Object x) throwsSQLException

  Updates the designated column with anObject 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateNull

  void updateNull(String columnLabel) throwsSQLException

  Updates the designated column with anull 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateBoolean

  void updateBoolean(String columnLabel, boolean x) throwsSQLException

  Updates the designated column with aboolean 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateByte

  void updateByte(String columnLabel, byte x) throwsSQLException

  Updates the designated column with abyte 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateShort

  void updateShort(String columnLabel, short x) throwsSQLException

  Updates the designated column with ashort 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateInt

  void updateInt(String columnLabel, int x) throwsSQLException

  Updates the designated column with anint 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateLong

  void updateLong(String columnLabel, long x) throwsSQLException

  Updates the designated column with along 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateFloat

  void updateFloat(String columnLabel, float x) throwsSQLException

  Updates the designated column with afloat 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateDouble

  void updateDouble(String columnLabel, double x) throwsSQLException

  Updates the designated column with adouble 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateBigDecimal

  void updateBigDecimal(String columnLabel,BigDecimal x) throwsSQLException

  Updates the designated column with ajava.sql.BigDecimal 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateString

  void updateString(String columnLabel,String x) throwsSQLException

  Updates the designated column with aString 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateBytes

  void updateBytes(String columnLabel, byte[] x) throwsSQLException

  Updates the designated column with a byte array 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateDate

  void updateDate(String columnLabel,Date x) throwsSQLException

  Updates the designated column with ajava.sql.Date 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateTime

  void updateTime(String columnLabel,Time x) throwsSQLException

  Updates the designated column with ajava.sql.Time 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateTimestamp

  void updateTimestamp(String columnLabel,Timestamp x) throwsSQLException

  Updates the designated column with ajava.sql.Timestamp 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateAsciiStream

  void updateAsciiStream(String columnLabel,InputStream x, int length) throwsSQLException

  Updates the designated column with an ascii stream value, which will have the specified number of bytes. 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateBinaryStream

  void updateBinaryStream(String columnLabel,InputStream x, int length) throwsSQLException

  Updates the designated column with a binary stream value, which will have the specified number of bytes. 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateCharacterStream

  void updateCharacterStream(String columnLabel,Reader reader, int length) throwsSQLException

  Updates the designated column with a character stream value, which will have the specified number of bytes. 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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 - thejava.io.Reader object containing the new column value

  length - the length of the stream

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateObject

  void updateObject(String columnLabel,Object x, int scaleOrLength) throwsSQLException

  Updates the designated column with anObject 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 theupdateRow orinsertRow methods are called to update the database.

  If the second argument is anInputStream then the stream must contain the number of bytes specified by scaleOrLength. If the second argument is aReader then the reader must contain the number of characters specified by scaleOrLength. If these conditions are not true the driver will generate aSQLException when the statement is executed.

  Parameters:

  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

  scaleOrLength - for an object ofjava.math.BigDecimal , this is the number of digits after the decimal point. For Java Object typesInputStream andReader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateObject

  void updateObject(String columnLabel,Object x) throwsSQLException

  Updates the designated column with anObject 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• insertRow

  void insertRow() throwsSQLException

  Inserts the contents of the insert row into thisResultSet object and into the database. The cursor must be on the insert row when this method is called.

  Throws:

  SQLException - if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY, this method is called on a closed result set, if this method is called when the cursor is not on the insert row, or if not all of non-nullable columns in the insert row have been given a non-null value

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• updateRow

  void updateRow() throwsSQLException

  Updates the underlying database with the new contents of the current row of thisResultSet object. This method cannot be called when the cursor is on the insert row.

  Throws:

  SQLException - if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY; this method is called on a closed result set or if this method is called when the cursor is on the insert row

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• deleteRow

  void deleteRow() throwsSQLException

  Deletes the current row from thisResultSet object and from the underlying database. This method cannot be called when the cursor is on the insert row.

  Throws:

  SQLException - if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY; this method is called on a closed result set or if this method is called when the cursor is on the insert row

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• refreshRow

  void refreshRow() throwsSQLException

  Refreshes the current row with its most recent value in the database. This method cannot be called when the cursor is on the insert row.

  TherefreshRow 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 callrefreshRow 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. IfrefreshRow is called after calling an updater method, but before calling the methodupdateRow, then the updates made to the row are lost. Calling the methodrefreshRow frequently will likely slow performance.

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set; the result set type isTYPE_FORWARD_ONLY or if this method is called when the cursor is on the insert row

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method or this method is not supported for the specified result set type and result set concurrency.

  Since:

  1.2

• cancelRowUpdates

  void cancelRowUpdates() throwsSQLException

  Cancels the updates made to the current row in thisResultSet object. This method may be called after calling an updater method(s) and before calling the methodupdateRow to roll back the updates made to a row. If no updates have been made orupdateRow has already been called, this method has no effect.

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set; the result set concurrency isCONCUR_READ_ONLY or if this method is called when the cursor is on the insert row

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• moveToInsertRow

  void moveToInsertRow() throwsSQLException

  Moves the cursor to the insert row. The current cursor position is remembered while the cursor is positioned on the insert row. The insert row is a special row associated with an updatable result set. It is essentially a buffer where a new row may be constructed by calling the updater methods prior to inserting the row into the result set. Only the updater, getter, andinsertRow 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 callinginsertRow. An updater method must be called before a getter method can be called on a column value.

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set or the result set concurrency isCONCUR_READ_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• moveToCurrentRow

  void moveToCurrentRow() throwsSQLException

  Moves the cursor to the remembered cursor position, usually the current row. This method has no effect if the cursor is not on the insert row.

  Throws:

  SQLException - if a database access error occurs; this method is called on a closed result set or the result set concurrency isCONCUR_READ_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• getStatement

  Statement getStatement() throwsSQLException

  Retrieves theStatement object that produced thisResultSet object. If the result set was generated some other way, such as by aDatabaseMetaData method, this method may returnnull.

  Returns:

  theStatement object that produced thisResultSet object ornull if the result set was produced some other way

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• getObject

  Object getObject(int columnIndex,Map<String,Class<?>> map) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as anObject in the Java programming language. If the value is an SQLNULL, the driver returns a Javanull. This method uses the givenMap object for the custom mapping of the SQL structured or distinct type that is being retrieved.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  map - ajava.util.Map object that contains the mapping from SQL type names to classes in the Java programming language

  Returns:

  anObject in the Java programming language representing the SQL value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• getRef

  Ref getRef(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aRef object in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  aRef object representing an SQLREF value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• getBlob

  Blob getBlob(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aBlob object in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  aBlob object representing the SQLBLOB value in the specified column

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• getClob

  Clob getClob(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aClob object in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  aClob object representing the SQLCLOB value in the specified column

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• getArray

  Array getArray(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as anArray object in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  anArray object representing the SQLARRAY value in the specified column

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• getObject

  Object getObject(String columnLabel,Map<String,Class<?>> map) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as anObject in the Java programming language. If the value is an SQLNULL, the driver returns a Javanull. This method uses the specifiedMap object for custom mapping if appropriate.

  Parameters:

  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

  map - ajava.util.Map object that contains the mapping from SQL type names to classes in the Java programming language

  Returns:

  anObject representing the SQL value in the specified column

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• getRef

  Ref getRef(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aRef object in the Java programming language.

  Parameters:

  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

  Returns:

  aRef object representing the SQLREF value in the specified column

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• getBlob

  Blob getBlob(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aBlob object in the Java programming language.

  Parameters:

  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

  Returns:

  aBlob object representing the SQLBLOB value in the specified column

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• getClob

  Clob getClob(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aClob object in the Java programming language.

  Parameters:

  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

  Returns:

  aClob object representing the SQLCLOB value in the specified column

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• getArray

  Array getArray(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as anArray object in the Java programming language.

  Parameters:

  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

  Returns:

  anArray object representing the SQLARRAY value in the specified column

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.2

• getDate

  Date getDate(int columnIndex,Calendar cal) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.Date object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  cal - thejava.util.Calendar object to use in constructing the date

  Returns:

  the column value as ajava.sql.Date object; if the value is SQLNULL, the value returned isnull in the Java programming language

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• getDate

  Date getDate(String columnLabel,Calendar cal) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.Date object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the date if the underlying database does not store timezone information.

  Parameters:

  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

  cal - thejava.util.Calendar object to use in constructing the date

  Returns:

  the column value as ajava.sql.Date object; if the value is SQLNULL, the value returned isnull in the Java programming language

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• getTime

  Time getTime(int columnIndex,Calendar cal) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.Time object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the time if the underlying database does not store timezone information.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  cal - thejava.util.Calendar object to use in constructing the time

  Returns:

  the column value as ajava.sql.Time object; if the value is SQLNULL, the value returned isnull in the Java programming language

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• getTime

  Time getTime(String columnLabel,Calendar cal) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.Time object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the time if the underlying database does not store timezone information.

  Parameters:

  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

  cal - thejava.util.Calendar object to use in constructing the time

  Returns:

  the column value as ajava.sql.Time object; if the value is SQLNULL, the value returned isnull in the Java programming language

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• getTimestamp

  Timestamp getTimestamp(int columnIndex,Calendar cal) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  cal - thejava.util.Calendar object to use in constructing the timestamp

  Returns:

  the column value as ajava.sql.Timestamp object; if the value is SQLNULL, the value returned isnull in the Java programming language

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• getTimestamp

  Timestamp getTimestamp(String columnLabel,Calendar cal) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.

  Parameters:

  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

  cal - thejava.util.Calendar object to use in constructing the date

  Returns:

  the column value as ajava.sql.Timestamp object; if the value is SQLNULL, the value returned isnull in the Java programming language

  Throws:

  SQLException - if the columnLabel is not valid or if a database access error occurs or this method is called on a closed result set

  Since:

  1.2

• getURL

  URL getURL(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.net.URL object in the Java programming language.

  Parameters:

  columnIndex - the index of the column 1 is the first, 2 is the second,...

  Returns:

  the column value as ajava.net.URL object; if the value is SQLNULL, the value returned isnull in the Java programming language

  Throws:

  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

  Since:

  1.4

• getURL

  URL getURL(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.net.URL object in the Java programming language.

  Parameters:

  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

  Returns:

  the column value as ajava.net.URL object; if the value is SQLNULL, the value returned isnull in the Java programming language

  Throws:

  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

  Since:

  1.4

• updateRef

  void updateRef(int columnIndex,Ref x) throwsSQLException

  Updates the designated column with ajava.sql.Ref 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.4

• updateRef

  void updateRef(String columnLabel,Ref x) throwsSQLException

  Updates the designated column with ajava.sql.Ref 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.4

• updateBlob

  void updateBlob(int columnIndex,Blob x) throwsSQLException

  Updates the designated column with ajava.sql.Blob 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.4

• updateBlob

  void updateBlob(String columnLabel,Blob x) throwsSQLException

  Updates the designated column with ajava.sql.Blob 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.4

• updateClob

  void updateClob(int columnIndex,Clob x) throwsSQLException

  Updates the designated column with ajava.sql.Clob 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.4

• updateClob

  void updateClob(String columnLabel,Clob x) throwsSQLException

  Updates the designated column with ajava.sql.Clob 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.4

• updateArray

  void updateArray(int columnIndex,Array x) throwsSQLException

  Updates the designated column with ajava.sql.Array 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.4

• updateArray

  void updateArray(String columnLabel,Array x) throwsSQLException

  Updates the designated column with ajava.sql.Array 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.4

• getRowId

  RowId getRowId(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.RowId object in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second 2, ...

  Returns:

  the column value; if the value is a SQLNULL the value returned isnull

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• getRowId

  RowId getRowId(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.sql.RowId object in the Java programming language.

  Parameters:

  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

  Returns:

  the column value ; if the value is a SQLNULL the value returned isnull

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateRowId

  void updateRowId(int columnIndex,RowId x) throwsSQLException

  Updates the designated column with aRowId 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second 2, ...

  x - the column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateRowId

  void updateRowId(String columnLabel,RowId x) throwsSQLException

  Updates the designated column with aRowId 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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 column value

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• getHoldability

  int getHoldability() throwsSQLException

  Retrieves the holdability of thisResultSet object

  Returns:

  eitherResultSet.HOLD_CURSORS_OVER_COMMIT orResultSet.CLOSE_CURSORS_AT_COMMIT

  Throws:

  SQLException - if a database access error occurs or this method is called on a closed result set

  Since:

  1.6

• isClosed

  boolean isClosed() throwsSQLException

  Retrieves whether thisResultSet object has been closed. AResultSet is closed if the method close has been called on it, or if it is automatically closed.

  Returns:

  true if thisResultSet object is closed; false if it is still open

  Throws:

  SQLException - if a database access error occurs

  Since:

  1.6

• updateNString

  void updateNString(int columnIndex,String nString) throwsSQLException

  Updates the designated column with aString value. It is intended for use when updatingNCHAR,NVARCHAR andLONGNVARCHAR 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second 2, ...

  nString - the value for the column to be updated

  Throws:

  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; the result set concurrency isCONCUR_READ_ONLY or if a database access error occurs

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateNString

  void updateNString(String columnLabel,String nString) throwsSQLException

  Updates the designated column with aString value. It is intended for use when updatingNCHAR,NVARCHAR andLONGNVARCHAR 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  nString - the value for the column to be updated

  Throws:

  SQLException - if the columnLabel 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; the result set concurrency isCONCUR_READ_ONLY or if a database access error occurs

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateNClob

  void updateNClob(int columnIndex,NClob nClob) throwsSQLException

  Updates the designated column with ajava.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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second 2, ...

  nClob - the value for the column to be updated

  Throws:

  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 isCONCUR_READ_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateNClob

  void updateNClob(String columnLabel,NClob nClob) throwsSQLException

  Updates the designated column with ajava.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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  nClob - the value for the column to be updated

  Throws:

  SQLException - if the columnLabel 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 isCONCUR_READ_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• getNClob

  NClob getNClob(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aNClob object in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  aNClob object representing the SQLNCLOB value in the specified column

  Throws:

  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 or if a database access error occurs

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• getNClob

  NClob getNClob(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aNClob object in the Java programming language.

  Parameters:

  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

  Returns:

  aNClob object representing the SQLNCLOB value in the specified column

  Throws:

  SQLException - if the columnLabel 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 or if a database access error occurs

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• getSQLXML

  SQLXML getSQLXML(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet as ajava.sql.SQLXML object in the Java programming language.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  aSQLXML object that maps anSQL XML value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• getSQLXML

  SQLXML getSQLXML(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet as ajava.sql.SQLXML object in the Java programming language.

  Parameters:

  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

  Returns:

  aSQLXML object that maps anSQL XML value

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateSQLXML

  void updateSQLXML(int columnIndex,SQLXML xmlObject) throwsSQLException

  Updates the designated column with ajava.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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second 2, ...

  xmlObject - the value for the column to be updated

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; this method is called on a closed result set; thejava.xml.transform.Result,Writer orOutputStream has not been closed for theSQLXML object; if there is an error processing the XML value or the result set concurrency isCONCUR_READ_ONLY. ThegetCause method of the exception may provide a more detailed exception, for example, if the stream does not contain valid XML.

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateSQLXML

  void updateSQLXML(String columnLabel,SQLXML xmlObject) throwsSQLException

  Updates the designated column with ajava.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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  xmlObject - the column value

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; this method is called on a closed result set; thejava.xml.transform.Result,Writer orOutputStream has not been closed for theSQLXML object; if there is an error processing the XML value or the result set concurrency isCONCUR_READ_ONLY. ThegetCause method of the exception may provide a more detailed exception, for example, if the stream does not contain valid XML.

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• getNString

  String getNString(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aString in the Java programming language. It is intended for use when accessingNCHAR,NVARCHAR andLONGNVARCHAR columns.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• getNString

  String getNString(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as aString in the Java programming language. It is intended for use when accessingNCHAR,NVARCHAR andLONGNVARCHAR columns.

  Parameters:

  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

  Returns:

  the column value; if the value is SQLNULL, the value returned isnull

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• getNCharacterStream

  Reader getNCharacterStream(int columnIndex) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.io.Reader object. It is intended for use when accessingNCHAR,NVARCHAR andLONGNVARCHAR columns.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  Returns:

  ajava.io.Reader object that contains the column value; if the value is SQLNULL, the value returned isnull in the Java programming language.

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• getNCharacterStream

  Reader getNCharacterStream(String columnLabel) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet object as ajava.io.Reader object. It is intended for use when accessingNCHAR,NVARCHAR andLONGNVARCHAR columns.

  Parameters:

  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

  Returns:

  ajava.io.Reader object that contains the column value; if the value is SQLNULL, the value returned isnull in the Java programming language

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateNCharacterStream

  void updateNCharacterStream(int columnIndex,Reader x, long length) throwsSQLException

  Updates the designated column with a character stream value, which will have the specified number of bytes. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updatingNCHAR,NVARCHAR andLONGNVARCHAR 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  length - the length of the stream

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateNCharacterStream

  void updateNCharacterStream(String columnLabel,Reader reader, long length) throwsSQLException

  Updates the designated column with a character stream value, which will have the specified number of bytes. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updatingNCHAR,NVARCHAR andLONGNVARCHAR 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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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 - thejava.io.Reader object containing the new column value

  length - the length of the stream

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateAsciiStream

  void updateAsciiStream(int columnIndex,InputStream x, long length) throwsSQLException

  Updates the designated column with an ascii stream value, which will have the specified number of bytes.

  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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  length - the length of the stream

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateBinaryStream

  void updateBinaryStream(int columnIndex,InputStream x, long length) throwsSQLException

  Updates the designated column with a binary stream value, which will have the specified number of bytes.

  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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  length - the length of the stream

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateCharacterStream

  void updateCharacterStream(int columnIndex,Reader x, long length) throwsSQLException

  Updates the designated column with a character stream value, which will have the specified number of bytes.

  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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  length - the length of the stream

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateAsciiStream

  void updateAsciiStream(String columnLabel,InputStream x, long length) throwsSQLException

  Updates the designated column with an ascii stream value, which will have the specified number of bytes.

  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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateBinaryStream

  void updateBinaryStream(String columnLabel,InputStream x, long length) throwsSQLException

  Updates the designated column with a binary stream value, which will have the specified number of bytes.

  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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateCharacterStream

  void updateCharacterStream(String columnLabel,Reader reader, long length) throwsSQLException

  Updates the designated column with a character stream value, which will have the specified number of bytes.

  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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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 - thejava.io.Reader object containing the new column value

  length - the length of the stream

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateBlob

  void updateBlob(int columnIndex,InputStream inputStream, long length) throwsSQLException

  Updates the designated column using the given input stream, which will have the specified number of bytes.

  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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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.

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateBlob

  void updateBlob(String columnLabel,InputStream inputStream, long length) throwsSQLException

  Updates the designated column using the given input stream, which will have the specified number of bytes.

  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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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.

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateClob

  void updateClob(int columnIndex,Reader reader, long length) throwsSQLException

  Updates the designated column using the givenReader object, which is the given number of characters long. When a very large UNICODE value is input to aLONGVARCHAR parameter, it may be more practical to send it via ajava.io.Reader object. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

  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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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.

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateClob

  void updateClob(String columnLabel,Reader reader, long length) throwsSQLException

  Updates the designated column using the givenReader object, which is the given number of characters long. When a very large UNICODE value is input to aLONGVARCHAR parameter, it may be more practical to send it via ajava.io.Reader object. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

  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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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.

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateNClob

  void updateNClob(int columnIndex,Reader reader, long length) throwsSQLException

  Updates the designated column using the givenReader object, which is the given number of characters long. When a very large UNICODE value is input to aLONGVARCHAR parameter, it may be more practical to send it via ajava.io.Reader object. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

  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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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.

  Throws:

  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 isCONCUR_READ_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateNClob

  void updateNClob(String columnLabel,Reader reader, long length) throwsSQLException

  Updates the designated column using the givenReader object, which is the given number of characters long. When a very large UNICODE value is input to aLONGVARCHAR parameter, it may be more practical to send it via ajava.io.Reader object. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

  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 theupdateRow orinsertRow methods are called to update the database.

  Parameters:

  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.

  Throws:

  SQLException - if the columnLabel 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 isCONCUR_READ_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateNCharacterStream

  void updateNCharacterStream(int columnIndex,Reader x) throwsSQLException

  Updates the designated column with a character stream value. The data will be read from the stream as needed until end-of-stream is reached. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updatingNCHAR,NVARCHAR andLONGNVARCHAR 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 theupdateRow orinsertRow 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 ofupdateNCharacterStream which takes a length parameter.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateNCharacterStream

  void updateNCharacterStream(String columnLabel,Reader reader) throwsSQLException

  Updates the designated column with a character stream value. The data will be read from the stream as needed until end-of-stream is reached. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updatingNCHAR,NVARCHAR andLONGNVARCHAR 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 theupdateRow orinsertRow 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 ofupdateNCharacterStream which takes a length parameter.

  Parameters:

  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 - thejava.io.Reader object containing the new column value

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateAsciiStream

  void updateAsciiStream(int columnIndex,InputStream x) throwsSQLException

  Updates the designated column with an ascii stream value. The data will be read from the stream as needed until end-of-stream is reached.

  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 theupdateRow orinsertRow 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 ofupdateAsciiStream which takes a length parameter.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateBinaryStream

  void updateBinaryStream(int columnIndex,InputStream x) throwsSQLException

  Updates the designated column with a binary stream value. The data will be read from the stream as needed until end-of-stream is reached.

  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 theupdateRow orinsertRow 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 ofupdateBinaryStream which takes a length parameter.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateCharacterStream

  void updateCharacterStream(int columnIndex,Reader x) throwsSQLException

  Updates the designated column with a character stream value. The data will be read from the stream as needed until end-of-stream is reached.

  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 theupdateRow orinsertRow 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 ofupdateCharacterStream which takes a length parameter.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateAsciiStream

  void updateAsciiStream(String columnLabel,InputStream x) throwsSQLException

  Updates the designated column with an ascii stream value. The data will be read from the stream as needed until end-of-stream is reached.

  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 theupdateRow orinsertRow 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 ofupdateAsciiStream which takes a length parameter.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateBinaryStream

  void updateBinaryStream(String columnLabel,InputStream x) throwsSQLException

  Updates the designated column with a binary stream value. The data will be read from the stream as needed until end-of-stream is reached.

  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 theupdateRow orinsertRow 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 ofupdateBinaryStream which takes a length parameter.

  Parameters:

  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

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateCharacterStream

  void updateCharacterStream(String columnLabel,Reader reader) throwsSQLException

  Updates the designated column with a character stream value. The data will be read from the stream as needed until end-of-stream is reached.

  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 theupdateRow orinsertRow 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 ofupdateCharacterStream which takes a length parameter.

  Parameters:

  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 - thejava.io.Reader object containing the new column value

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateBlob

  void updateBlob(int columnIndex,InputStream inputStream) throwsSQLException

  Updates the designated column using the given input stream. The data will be read from the stream as needed until end-of-stream is reached.

  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 theupdateRow orinsertRow 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 ofupdateBlob which takes a length parameter.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  inputStream - An object that contains the data to set the parameter value to.

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateBlob

  void updateBlob(String columnLabel,InputStream inputStream) throwsSQLException

  Updates the designated column using the given input stream. The data will be read from the stream as needed until end-of-stream is reached.

  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 theupdateRow orinsertRow 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 ofupdateBlob which takes a length parameter.

  Parameters:

  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.

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateClob

  void updateClob(int columnIndex,Reader reader) throwsSQLException

  Updates the designated column using the givenReader object. The data will be read from the stream as needed until end-of-stream is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

  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 theupdateRow orinsertRow 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 ofupdateClob which takes a length parameter.

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  reader - An object that contains the data to set the parameter value to.

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateClob

  void updateClob(String columnLabel,Reader reader) throwsSQLException

  Updates the designated column using the givenReader object. The data will be read from the stream as needed until end-of-stream is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

  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 theupdateRow orinsertRow 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 ofupdateClob which takes a length parameter.

  Parameters:

  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.

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateNClob

  void updateNClob(int columnIndex,Reader reader) throwsSQLException

  Updates the designated column using the givenReader The data will be read from the stream as needed until end-of-stream is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

  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 theupdateRow orinsertRow 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 ofupdateNClob which takes a length parameter.

  Parameters:

  columnIndex - the first column is 1, the second 2, ...

  reader - An object that contains the data to set the parameter value to.

  Throws:

  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 isCONCUR_READ_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• updateNClob

  void updateNClob(String columnLabel,Reader reader) throwsSQLException

  Updates the designated column using the givenReader object. The data will be read from the stream as needed until end-of-stream is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

  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 theupdateRow orinsertRow 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 ofupdateNClob which takes a length parameter.

  Parameters:

  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.

  Throws:

  SQLException - if the columnLabel 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 isCONCUR_READ_ONLY

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method

  Since:

  1.6

• getObject

  <T> T getObject(int columnIndex,Class<T> type) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet 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, aSQLException 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 implementsSQLData, orStruct. Additional conversions may be supported and are vendor defined.

  Type Parameters:

  T - the type of the class modeled by this Class object

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  type - Class representing the Java data type to convert the designated column to.

  Returns:

  an instance oftype holding the column value

  Throws:

  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

  Since:

  1.7

• getObject

  <T> T getObject(String columnLabel,Class<T> type) throwsSQLException

  Retrieves the value of the designated column in the current row of thisResultSet 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, aSQLException 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 implementsSQLData, orStruct. Additional conversions may be supported and are vendor defined.

  Type Parameters:

  T - the type of the class modeled by this Class object

  Parameters:

  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.

  Returns:

  an instance oftype holding the column value

  Throws:

  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

  Since:

  1.7

• updateObject

  default void updateObject(int columnIndex,Object x,SQLType targetSqlType, int scaleOrLength) throwsSQLException

  Updates the designated column with anObject 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 theupdateRow orinsertRow methods are called to update the database.

  If the second argument is anInputStream then the stream must contain the number of bytes specified by scaleOrLength. If the second argument is aReader then the reader must contain the number of characters specified by scaleOrLength. If these conditions are not true the driver will generate aSQLException when the statement is executed.

  The default implementation will throwSQLFeatureNotSupportedException

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  targetSqlType - the SQL type to be sent to the database

  scaleOrLength - for an object ofjava.math.BigDecimal , this is the number of digits after the decimal point. For Java Object typesInputStream andReader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method; if the JDBC driver does not support the specified targetSqlType

  Since:

  1.8

  See Also:

  • JDBCType
  • SQLType

• updateObject

  default void updateObject(String columnLabel,Object x,SQLType targetSqlType, int scaleOrLength) throwsSQLException

  Updates the designated column with anObject 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 theupdateRow orinsertRow methods are called to update the database.

  If the second argument is anInputStream then the stream must contain number of bytes specified by scaleOrLength. If the second argument is aReader then the reader must contain the number of characters specified by scaleOrLength. If these conditions are not true the driver will generate aSQLException when the statement is executed.

  The default implementation will throwSQLFeatureNotSupportedException

  Parameters:

  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

  targetSqlType - the SQL type to be sent to the database

  scaleOrLength - for an object ofjava.math.BigDecimal , this is the number of digits after the decimal point. For Java Object typesInputStream andReader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method; if the JDBC driver does not support the specified targetSqlType

  Since:

  1.8

  See Also:

  • JDBCType
  • SQLType

• updateObject

  default void updateObject(int columnIndex,Object x,SQLType targetSqlType) throwsSQLException

  Updates the designated column with anObject 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 theupdateRow orinsertRow methods are called to update the database.

  The default implementation will throwSQLFeatureNotSupportedException

  Parameters:

  columnIndex - the first column is 1, the second is 2, ...

  x - the new column value

  targetSqlType - the SQL type to be sent to the database

  Throws:

  SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method; if the JDBC driver does not support the specified targetSqlType

  Since:

  1.8

  See Also:

  • JDBCType
  • SQLType

• updateObject

  default void updateObject(String columnLabel,Object x,SQLType targetSqlType) throwsSQLException

  Updates the designated column with anObject 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 theupdateRow orinsertRow methods are called to update the database.

  The default implementation will throwSQLFeatureNotSupportedException

  Parameters:

  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

  targetSqlType - the SQL type to be sent to the database

  Throws:

  SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency isCONCUR_READ_ONLY or this method is called on a closed result set

  SQLFeatureNotSupportedException - if the JDBC driver does not support this method; if the JDBC driver does not support the specified targetSqlType

  Since:

  1.8

  See Also:

  • JDBCType
  • SQLType