/* * Copyright (c) 1996, 2011, Oracle and/or its affiliates. All rights reserved. * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * This code is free software; you can redistribute it and/or modify it * under the terms of the GNU General Public License version 2 only, as * published by the Free Software Foundation. Oracle designates this * particular file as subject to the "Classpath" exception as provided * by Oracle in the LICENSE file that accompanied this code. * * This code is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License * version 2 for more details (a copy is included in the LICENSE file that * accompanied this code). * * You should have received a copy of the GNU General Public License version * 2 along with this work; if not, write to the Free Software Foundation, * Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA. * * Please contact Oracle, 500 Oracle Parkway, Redwood Shores, CA 94065 USA * or visit www.oracle.com if you need additional information or have any * questions. */ package java.sql; import java.math.BigDecimal; import java.util.Calendar; import java.io.Reader; import java.io.InputStream; /** * A table of data representing a database result set, which * is usually generated by executing a statement that queries the database. * *

A ResultSet object maintains a cursor pointing * to its current row of data. Initially the cursor is positioned * before the first row. The next method moves the * cursor to the next row, and because it returns false * when there are no more rows in the ResultSet object, * it can be used in a while loop to iterate through * the result set. *

* A default ResultSet object is not updatable and * has a cursor that moves forward only. Thus, you can * iterate through it only once and only from the first row to the * last row. It is possible to * produce ResultSet objects that are scrollable and/or * updatable. The following code fragment, in which con * is a valid Connection object, illustrates how to make * a result set that is scrollable and insensitive to updates by others, and * that is updatable. See ResultSet fields for other * options. * 

 *
 *       Statement stmt = con.createStatement(
 *                                      ResultSet.TYPE_SCROLL_INSENSITIVE,
 *                                      ResultSet.CONCUR_UPDATABLE);
 *       ResultSet rs = stmt.executeQuery("SELECT a, b FROM TABLE2");
 *       // rs will be scrollable, will not show changes made by others,
 *       // and will be updatable
 *
 *
* The ResultSet interface provides * getter methods (getBoolean, getLong, and so on) * for retrieving column values from the current row. * Values can be retrieved using either the index number of the * column or the name of the column. In general, using the * column index will be more efficient. Columns are numbered from 1. * For maximum portability, result set columns within each row should be * read in left-to-right order, and each column should be read only once. * *

For the getter methods, a JDBC driver attempts * to convert the underlying data to the Java type specified in the * getter method and returns a suitable Java value. The JDBC specification * has a table showing the allowable mappings from SQL types to Java types * that can be used by the ResultSet getter methods. *

*

Column names used as input to getter methods are case * insensitive. When a getter method is called with * a column name and several columns have the same name, * the value of the first matching column will be returned. * The column name option is * designed to be used when column names are used in the SQL * query that generated the result set. * For columns that are NOT explicitly named in the query, it * is best to use column numbers. If column names are used, the * programmer should take care to guarantee that they uniquely refer to * the intended columns, which can be assured with the SQL AS clause. *

* A set of updater methods were added to this interface * in the JDBC 2.0 API (JavaTM 2 SDK, * Standard Edition, version 1.2). The comments regarding parameters * to the getter methods also apply to parameters to the * updater methods. *

* The updater methods may be used in two ways: *

    *
  1. to update a column value in the current row. In a scrollable * ResultSet object, the cursor can be moved backwards * and forwards, to an absolute position, or to a position * relative to the current row. * The following code fragment updates the NAME column * in the fifth row of the ResultSet object * rs and then uses the method updateRow * to update the data source table from which rs was derived. * 
     *
 *       rs.absolute(5); // moves the cursor to the fifth row of rs
 *       rs.updateString("NAME", "AINSWORTH"); // updates the
 *          // NAME column of row 5 to be AINSWORTH
 *       rs.updateRow(); // updates the row in the data source
 *
 *
    *
  2. to insert column values into the insert row. An updatable * ResultSet object has a special row associated with * it that serves as a staging area for building a row to be inserted. * The following code fragment moves the cursor to the insert row, builds * a three-column row, and inserts it into rs and into * the data source table using the method insertRow. * 
     *
 *       rs.moveToInsertRow(); // moves cursor to the insert row
 *       rs.updateString(1, "AINSWORTH"); // updates the
 *          // first column of the insert row to be AINSWORTH
 *       rs.updateInt(2,35); // updates the second column to be 35
 *       rs.updateBoolean(3, true); // updates the third column to true
 *       rs.insertRow();
 *       rs.moveToCurrentRow();
 *
 *
    *
*

A ResultSet object is automatically closed when the * Statement object that * generated it is closed, re-executed, or used * to retrieve the next result from a sequence of multiple results. * *

The number, types and properties of a ResultSet * object's columns are provided by the ResultSetMetaData * object returned by the ResultSet.getMetaData method. * * @see Statement#executeQuery * @see Statement#getResultSet * @see ResultSetMetaData */ public interface ResultSet extends Wrapper, AutoCloseable { /** * Moves the cursor froward one row from its current position. * A ResultSet cursor is initially positioned * before the first row; the first call to the method * next makes the first row the current row; the * second call makes the second row the current row, and so on. *

* When a call to the next method returns false, * the cursor is positioned after the last row. Any * invocation of a ResultSet method which requires a * current row will result in a SQLException being thrown. * If the result set type is TYPE_FORWARD_ONLY, it is vendor specified * whether their JDBC driver implementation will return false or * throw an SQLException on a * subsequent call to next. * *

If an input stream is open for the current row, a call * to the method next will * implicitly close it. A ResultSet object's * warning chain is cleared when a new row is read. * * @return true if the new current row is valid; * false if there are no more rows * @exception SQLException if a database access error occurs or this method is * called on a closed result set */ boolean next() throws SQLException; /** * Releases this ResultSet object's database and * JDBC resources immediately instead of waiting for * this to happen when it is automatically closed. * *

The closing of a ResultSet object does not close the Blob, * Clob or NClob objects created by the ResultSet. Blob, * Clob or NClob objects remain valid for at least the duration of the * transaction in which they are creataed, unless their free method is invoked. *

* When a ResultSet is closed, any ResultSetMetaData * instances that were created by calling the getMetaData * method remain accessible. * *

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

* Calling the method close on a ResultSet * object that is already closed is a no-op. *

*

* * @exception SQLException if a database access error occurs */ void close() throws SQLException; /** * Reports whether * the last column read had a value of SQL NULL. * Note that you must first call one of the getter methods * on a column to try to read its value and then call * the method wasNull to see if the value read was * SQL NULL. * * @return true if the last column value read was SQL * NULL and false otherwise * @exception SQLException if a database access error occurs or this method is * called on a closed result set */ boolean wasNull() throws SQLException; // Methods for accessing results by column index /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a String in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ String getString(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a boolean 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 of false 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 of true is returned. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is false * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ boolean getBoolean(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a byte in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is 0 * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ byte getByte(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a short in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is 0 * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ short getShort(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * an int in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is 0 * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ int getInt(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a long in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is 0 * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ long getLong(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a float in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is 0 * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ float getFloat(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a double in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is 0 * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ double getDouble(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.BigDecimal in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @param scale the number of digits to the right of the decimal point * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @deprecated */ BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a byte array in the Java programming language. * The bytes represent the raw values returned by the driver. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ byte[] getBytes(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.Date object in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ java.sql.Date getDate(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.Time object in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ java.sql.Time getTime(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.Timestamp object in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ java.sql.Timestamp getTimestamp(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a stream of ASCII characters. The value can then be read in chunks from the * stream. This method is particularly * suitable for retrieving large LONGVARCHAR values. * The JDBC driver will * do any necessary conversion from the database format into ASCII. * *

Note: All the data in the returned stream must be * read prior to getting the value of any other column. The next * call to a getter method implicitly closes the stream. Also, a * stream may return 0 when the method * InputStream.available * is called whether there is data available or not. * * @param columnIndex the first column is 1, the second is 2, ... * @return a Java input stream that delivers the database column value * as a stream of one-byte ASCII characters; * if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ java.io.InputStream getAsciiStream(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet 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 large LONGVARCHARvalues. 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 return 0 when the method * InputStream.available * is called, whether there is data available or not. * * @param columnIndex the first column is 1, the second is 2, ... * @return a Java input stream that delivers the database column value * as a stream of two-byte Unicode characters; * if the value is SQL NULL, the value returned is * null * * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @deprecated use getCharacterStream in place of * getUnicodeStream */ java.io.InputStream getUnicodeStream(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet 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 large LONGVARBINARY values. * *

Note: All the data in the returned stream must be * read prior to getting the value of any other column. The next * call to a getter method implicitly closes the stream. Also, a * stream may return 0 when the method * InputStream.available * is called whether there is data available or not. * * @param columnIndex the first column is 1, the second is 2, ... * @return a Java input stream that delivers the database column value * as a stream of uninterpreted bytes; * if the value is SQL NULL, the value returned is * null * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ java.io.InputStream getBinaryStream(int columnIndex) throws SQLException; // Methods for accessing results by column label /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a String in the Java programming language. * * @param 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 * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ String getString(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a boolean 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 of false 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 of true is returned. * * @param 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 * @return the column value; if the value is SQL NULL, the * value returned is false * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ boolean getBoolean(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a byte in the Java programming language. * * @param 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 * @return the column value; if the value is SQL NULL, the * value returned is 0 * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ byte getByte(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a short in the Java programming language. * * @param 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 * @return the column value; if the value is SQL NULL, the * value returned is 0 * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ short getShort(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * an int in the Java programming language. * * @param 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 * @return the column value; if the value is SQL NULL, the * value returned is 0 * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ int getInt(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a long in the Java programming language. * * @param 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 * @return the column value; if the value is SQL NULL, the * value returned is 0 * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ long getLong(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a float in the Java programming language. * * @param 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 * @return the column value; if the value is SQL NULL, the * value returned is 0 * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ float getFloat(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a double in the Java programming language. * * @param 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 * @return the column value; if the value is SQL NULL, the * value returned is 0 * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ double getDouble(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.math.BigDecimal in the Java programming language. * * @param 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 * @param scale the number of digits to the right of the decimal point * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @deprecated */ BigDecimal getBigDecimal(String columnLabel, int scale) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a byte array in the Java programming language. * The bytes represent the raw values returned by the driver. * * @param 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 * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ byte[] getBytes(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.Date object in the Java programming language. * * @param 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 * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ java.sql.Date getDate(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.Time object in the Java programming language. * * @param 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 * @return the column value; * if the value is SQL NULL, * the value returned is null * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ java.sql.Time getTime(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a java.sql.Timestamp object in the Java programming language. * * @param 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 * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ java.sql.Timestamp getTimestamp(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a stream of * ASCII characters. The value can then be read in chunks from the * stream. This method is particularly * suitable for retrieving large LONGVARCHAR values. * The JDBC driver will * do any necessary conversion from the database format into ASCII. * *

Note: All the data in the returned stream must be * read prior to getting the value of any other column. The next * call to a getter method implicitly closes the stream. Also, a * stream may return 0 when the method available * is called whether there is data available or not. * * @param 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 * @return a Java input stream that delivers the database column value * as a stream of one-byte ASCII characters. * If the value is SQL NULL, * the value returned is null. * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ java.io.InputStream getAsciiStream(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet 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 large LONGVARCHAR 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 return 0 when the method * InputStream.available is called, whether there * is data available or not. * * @param 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 * @return a Java input stream that delivers the database column value * as a stream of two-byte Unicode characters. * If the value is SQL NULL, the value returned * is null. * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @deprecated use getCharacterStream instead */ java.io.InputStream getUnicodeStream(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet 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 large LONGVARBINARY * values. * *

Note: All the data in the returned stream must be * read prior to getting the value of any other column. The next * call to a getter method implicitly closes the stream. Also, a * stream may return 0 when the method available * is called whether there is data available or not. * * @param 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 * @return a Java input stream that delivers the database column value * as a stream of uninterpreted bytes; * if the value is SQL NULL, the result is null * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ java.io.InputStream getBinaryStream(String columnLabel) throws SQLException; // Advanced features: /** * Retrieves the first warning reported by calls on this * ResultSet object. * Subsequent warnings on this ResultSet object * will be chained to the SQLWarning object that * this method returns. * *

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

* Note: This warning chain only covers warnings caused * by ResultSet methods. Any warning caused by * Statement methods * (such as reading OUT parameters) will be chained on the * Statement object. * * @return the first SQLWarning object reported or * null if there are none * @exception SQLException if a database access error occurs or this method is * called on a closed result set */ SQLWarning getWarnings() throws SQLException; /** * Clears all warnings reported on this ResultSet object. * After this method is called, the method getWarnings * returns null until a new warning is * reported for this ResultSet object. * * @exception SQLException if a database access error occurs or this method is * called on a closed result set */ void clearWarnings() throws SQLException; /** * Retrieves the name of the SQL cursor used by this ResultSet * object. * *

In SQL, a result table is retrieved through a cursor that is * named. The current row of a result set can be updated or deleted * using a positioned update/delete statement that references the * cursor name. To insure that the cursor has the proper isolation * level to support update, the cursor's SELECT statement * should be of the form SELECT FOR UPDATE. If * FOR 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 a ResultSet object. * The current row of a ResultSet object * is also the current row of this SQL cursor. * * @return the SQL name for this ResultSet object's cursor * @exception SQLException if a database access error occurs or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method */ String getCursorName() throws SQLException; /** * Retrieves the number, types and properties of * this ResultSet object's columns. * * @return the description of this ResultSet object's columns * @exception SQLException if a database access error occurs or this method is * called on a closed result set */ ResultSetMetaData getMetaData() throws SQLException; /** *

Gets the value of the designated column in the current row * of this ResultSet object as * an Object 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 SQL NULL, * the driver returns a Java null. * *

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

* If Connection.getTypeMap does not throw a * SQLFeatureNotSupportedException, * 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()). * * If Connection.getTypeMap does throw a * SQLFeatureNotSupportedException, * 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. * * @param columnIndex the first column is 1, the second is 2, ... * @return a java.lang.Object holding the column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs or this method is * called on a closed result set */ Object getObject(int columnIndex) throws SQLException; /** *

Gets the value of the designated column in the current row * of this ResultSet object as * an Object 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 SQL NULL, * the driver returns a Java null. *

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

* In the JDBC 2.0 API, the behavior of the method * getObject is extended to materialize * data of SQL user-defined types. When a column contains * a structured or distinct value, the behavior of this method is as * if it were a call to: getObject(columnIndex, * this.getStatement().getConnection().getTypeMap()). * * @param 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 * @return a java.lang.Object holding the column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs or this method is * called on a closed result set */ Object getObject(String columnLabel) throws SQLException; //---------------------------------------------------------------- /** * Maps the given ResultSet column label to its * ResultSet column index. * * @param 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 * @return the column index of the given column name * @exception SQLException if the ResultSet object * does not contain a column labeled columnLabel, a database access error occurs * or this method is called on a closed result set */ int findColumn(String columnLabel) throws SQLException; //--------------------------JDBC 2.0----------------------------------- //--------------------------------------------------------------------- // Getters and Setters //--------------------------------------------------------------------- /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a * java.io.Reader object. * @return a java.io.Reader object that contains the column * value; if the value is SQL NULL, the value returned is * null in the Java programming language. * @param columnIndex the first column is 1, the second is 2, ... * @exception 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 */ java.io.Reader getCharacterStream(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a * java.io.Reader object. * * @param 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 * @return a java.io.Reader object that contains the column * value; if the value is SQL NULL, the value returned is * null in the Java programming language * @exception 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 */ java.io.Reader getCharacterStream(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a * java.math.BigDecimal with full precision. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value (full precision); * if the value is SQL NULL, the value returned is * null in the Java programming language. * @exception 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 */ BigDecimal getBigDecimal(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a * java.math.BigDecimal with full precision. * * @param 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 * @return the column value (full precision); * if the value is SQL NULL, the value returned is * null in the Java programming language. * @exception 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 * */ BigDecimal getBigDecimal(String columnLabel) throws SQLException; //--------------------------------------------------------------------- // Traversal/Positioning //--------------------------------------------------------------------- /** * Retrieves whether the cursor is before the first row in * this ResultSet object. *

* Note:Support for the isBeforeFirst method * is optional for ResultSets with a result * set type of TYPE_FORWARD_ONLY * * @return 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 * @exception SQLException if a database access error occurs or this method is * called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ boolean isBeforeFirst() throws SQLException; /** * Retrieves whether the cursor is after the last row in * this ResultSet object. *

* Note:Support for the isAfterLast method * is optional for ResultSets with a result * set type of TYPE_FORWARD_ONLY * * @return 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 * @exception SQLException if a database access error occurs or this method is * called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ boolean isAfterLast() throws SQLException; /** * Retrieves whether the cursor is on the first row of * this ResultSet object. *

* Note:Support for the isFirst method * is optional for ResultSets with a result * set type of TYPE_FORWARD_ONLY * * @return true if the cursor is on the first row; * false otherwise * @exception SQLException if a database access error occurs or this method is * called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ boolean isFirst() throws SQLException; /** * Retrieves whether the cursor is on the last row of * this ResultSet object. * Note: Calling the method isLast may be expensive * because the JDBC driver * might need to fetch ahead one row in order to determine * whether the current row is the last row in the result set. *

* Note: Support for the isLast method * is optional for ResultSets with a result * set type of TYPE_FORWARD_ONLY * @return true if the cursor is on the last row; * false otherwise * @exception SQLException if a database access error occurs or this method is * called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ boolean isLast() throws SQLException; /** * Moves the cursor to the front of * this ResultSet object, just before the * first row. This method has no effect if the result set contains no rows. * * @exception SQLException if a database access error * occurs; this method is called on a closed result set or the * result set type is TYPE_FORWARD_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void beforeFirst() throws SQLException; /** * Moves the cursor to the end of * this ResultSet object, just after the * last row. This method has no effect if the result set contains no rows. * @exception SQLException if a database access error * occurs; this method is called on a closed result set * or the result set type is TYPE_FORWARD_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void afterLast() throws SQLException; /** * Moves the cursor to the first row in * this ResultSet object. * * @return true if the cursor is on a valid row; * false if there are no rows in the result set * @exception SQLException if a database access error * occurs; this method is called on a closed result set * or the result set type is TYPE_FORWARD_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ boolean first() throws SQLException; /** * Moves the cursor to the last row in * this ResultSet object. * * @return true if the cursor is on a valid row; * false if there are no rows in the result set * @exception SQLException if a database access error * occurs; this method is called on a closed result set * or the result set type is TYPE_FORWARD_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ boolean last() throws SQLException; /** * Retrieves the current row number. The first row is number 1, the * second number 2, and so on. *

* Note:Support for the getRow method * is optional for ResultSets with a result * set type of TYPE_FORWARD_ONLY * * @return the current row number; 0 if there is no current row * @exception SQLException if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ int getRow() throws SQLException; /** * Moves the cursor to the given row number in * this ResultSet object. * *

If the row number is positive, the cursor moves to * the given row number with respect to the * beginning of the result set. The first row is row 1, the second * is row 2, and so on. * *

If the given row number is negative, the cursor moves to * an absolute row position with respect to * the end of the result set. For example, calling the method * absolute(-1) positions the * cursor on the last row; calling the method absolute(-2) * moves the cursor to the next-to-last row, and so on. * *

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: Calling absolute(1) is the same * as calling first(). Calling absolute(-1) * is the same as calling last(). * * @param 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 * @return true if the cursor is moved to a position in this * ResultSet object; * false if the cursor is before the first row or after the * last row * @exception SQLException if a database access error * occurs; this method is called on a closed result set * or the result set type is TYPE_FORWARD_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ boolean absolute( int row ) throws SQLException; /** * 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. Calling relative(0) is valid, but does * not change the cursor position. * *

Note: Calling the method relative(1) * is identical to calling the method next() and * calling the method relative(-1) is identical * to calling the method previous(). * * @param rows an int specifying the number of rows to * move from the current row; a positive number moves the cursor * forward; a negative number moves the cursor backward * @return true if the cursor is on a row; * false otherwise * @exception SQLException if a database access error occurs; this method * is called on a closed result set or the result set type is * TYPE_FORWARD_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ boolean relative( int rows ) throws SQLException; /** * Moves the cursor to the previous row in this * ResultSet object. *

* When a call to the previous method returns false, * the cursor is positioned before the first row. Any invocation of a * ResultSet method which requires a current row will result in a * SQLException being thrown. *

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

* * @return true if the cursor is now positioned on a valid row; * false if the cursor is positioned before the first row * @exception SQLException if a database access error * occurs; this method is called on a closed result set * or the result set type is TYPE_FORWARD_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ boolean previous() throws SQLException; //--------------------------------------------------------------------- // Properties //--------------------------------------------------------------------- /** * 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 method setFetchDirection * as a hint to the driver, which the driver may ignore. * @since 1.2 */ int FETCH_FORWARD = 1000; /** * 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 method setFetchDirection * as a hint to the driver, which the driver may ignore. * @since 1.2 */ int FETCH_REVERSE = 1001; /** * The constant indicating that the order in which rows in a * result set will be processed is unknown. * This constant is used by the method setFetchDirection * as a hint to the driver, which the driver may ignore. */ int FETCH_UNKNOWN = 1002; /** * Gives a hint as to the direction in which the rows in this * ResultSet object will be processed. * The initial value is determined by the * Statement object * that produced this ResultSet object. * The fetch direction may be changed at any time. * * @param direction an int specifying the suggested * fetch direction; one of ResultSet.FETCH_FORWARD, * ResultSet.FETCH_REVERSE, or * ResultSet.FETCH_UNKNOWN * @exception SQLException if a database access error occurs; this * method is called on a closed result set or * the result set type is TYPE_FORWARD_ONLY and the fetch * direction is not FETCH_FORWARD * @since 1.2 * @see Statement#setFetchDirection * @see #getFetchDirection */ void setFetchDirection(int direction) throws SQLException; /** * Retrieves the fetch direction for this * ResultSet object. * * @return the current fetch direction for this ResultSet object * @exception SQLException if a database access error occurs * or this method is called on a closed result set * @since 1.2 * @see #setFetchDirection */ int getFetchDirection() throws SQLException; /** * Gives the JDBC driver a hint as to the number of rows that should * be fetched from the database when more rows are needed for this * ResultSet object. * If the fetch size specified is zero, the JDBC driver * ignores the value and is free to make its own best guess as to what * the fetch size should be. The default value is set by the * Statement object * that created the result set. The fetch size may be changed at any time. * * @param rows the number of rows to fetch * @exception SQLException if a database access error occurs; this method * is called on a closed result set or the * condition rows >= 0 is not satisfied * @since 1.2 * @see #getFetchSize */ void setFetchSize(int rows) throws SQLException; /** * Retrieves the fetch size for this * ResultSet object. * * @return the current fetch size for this ResultSet object * @exception SQLException if a database access error occurs * or this method is called on a closed result set * @since 1.2 * @see #setFetchSize */ int getFetchSize() throws SQLException; /** * The constant indicating the type for a ResultSet object * whose cursor may move only forward. * @since 1.2 */ int TYPE_FORWARD_ONLY = 1003; /** * The constant indicating the type for a ResultSet object * that is scrollable but generally not sensitive to changes to the data * that underlies the ResultSet. * @since 1.2 */ int TYPE_SCROLL_INSENSITIVE = 1004; /** * The constant indicating the type for a ResultSet object * that is scrollable and generally sensitive to changes to the data * that underlies the ResultSet. * @since 1.2 */ int TYPE_SCROLL_SENSITIVE = 1005; /** * Retrieves the type of this ResultSet object. * The type is determined by the Statement object * that created the result set. * * @return ResultSet.TYPE_FORWARD_ONLY, * ResultSet.TYPE_SCROLL_INSENSITIVE, * or ResultSet.TYPE_SCROLL_SENSITIVE * @exception SQLException if a database access error occurs * or this method is called on a closed result set * @since 1.2 */ int getType() throws SQLException; /** * The constant indicating the concurrency mode for a * ResultSet object that may NOT be updated. * @since 1.2 */ int CONCUR_READ_ONLY = 1007; /** * The constant indicating the concurrency mode for a * ResultSet object that may be updated. * @since 1.2 */ int CONCUR_UPDATABLE = 1008; /** * Retrieves the concurrency mode of this ResultSet object. * The concurrency used is determined by the * Statement object that created the result set. * * @return the concurrency type, either * ResultSet.CONCUR_READ_ONLY * or ResultSet.CONCUR_UPDATABLE * @exception SQLException if a database access error occurs * or this method is called on a closed result set * @since 1.2 */ int getConcurrency() throws SQLException; //--------------------------------------------------------------------- // Updates //--------------------------------------------------------------------- /** * 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 the rowUpdated method is optional with a result set * concurrency of CONCUR_READ_ONLY * @return true if the current row is detected to * have been visibly updated by the owner or another; false otherwise * @exception SQLException if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @see DatabaseMetaData#updatesAreDetected * @since 1.2 */ boolean rowUpdated() throws SQLException; /** * Retrieves whether the current row has had an insertion. * The value returned depends on whether or not this * ResultSet object can detect visible inserts. *

* Note: Support for the rowInserted method is optional with a result set * concurrency of CONCUR_READ_ONLY * @return true if the current row is detected to * have been inserted; false otherwise * @exception SQLException if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * * @see DatabaseMetaData#insertsAreDetected * @since 1.2 */ boolean rowInserted() throws SQLException; /** * 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 this ResultSet object can detect deletions. *

* Note: Support for the rowDeleted method is optional with a result set * concurrency of CONCUR_READ_ONLY * @return true if the current row is detected to * have been deleted by the owner or another; false otherwise * @exception SQLException if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * * @see DatabaseMetaData#deletesAreDetected * @since 1.2 */ boolean rowDeleted() throws SQLException; /** * Updates the designated column with a null value. * * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow * or insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateNull(int columnIndex) throws SQLException; /** * Updates the designated column with a boolean value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateBoolean(int columnIndex, boolean x) throws SQLException; /** * Updates the designated column with a byte value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateByte(int columnIndex, byte x) throws SQLException; /** * Updates the designated column with a short value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateShort(int columnIndex, short x) throws SQLException; /** * Updates the designated column with an int value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateInt(int columnIndex, int x) throws SQLException; /** * Updates the designated column with a long value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateLong(int columnIndex, long x) throws SQLException; /** * Updates the designated column with a float value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateFloat(int columnIndex, float x) throws SQLException; /** * Updates the designated column with a double value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateDouble(int columnIndex, double x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException; /** * Updates the designated column with a String value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateString(int columnIndex, String x) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateBytes(int columnIndex, byte x[]) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateDate(int columnIndex, java.sql.Date x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateTime(int columnIndex, java.sql.Time x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @param length the length of the stream * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @param length the length of the stream * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @param length the length of the stream * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws SQLException; /** * Updates the designated column with an Object value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. *

* If the second argument is an InputStream then the stream must contain * the number of bytes specified by scaleOrLength. If the second argument is a * Reader then the reader must contain the number of characters specified * by scaleOrLength. If these conditions are not true the driver will generate a * SQLException when the statement is executed. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @param scaleOrLength for an object of java.math.BigDecimal , * this is the number of digits after the decimal point. For * Java Object types InputStream and Reader, * this is the length * of the data in the stream or reader. For all other types, * this value will be ignored. * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateObject(int columnIndex, Object x, int scaleOrLength) throws SQLException; /** * Updates the designated column with an Object value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateObject(int columnIndex, Object x) throws SQLException; /** * Updates the designated column with a null value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateNull(String columnLabel) throws SQLException; /** * Updates the designated column with a boolean value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateBoolean(String columnLabel, boolean x) throws SQLException; /** * Updates the designated column with a byte value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateByte(String columnLabel, byte x) throws SQLException; /** * Updates the designated column with a short value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateShort(String columnLabel, short x) throws SQLException; /** * Updates the designated column with an int value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateInt(String columnLabel, int x) throws SQLException; /** * Updates the designated column with a long value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateLong(String columnLabel, long x) throws SQLException; /** * Updates the designated column with a float value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateFloat(String columnLabel, float x) throws SQLException; /** * Updates the designated column with a double value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateDouble(String columnLabel, double x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateBigDecimal(String columnLabel, BigDecimal x) throws SQLException; /** * Updates the designated column with a String value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateString(String columnLabel, String x) throws SQLException; /** * 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 the updateRow * or insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateBytes(String columnLabel, byte x[]) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateDate(String columnLabel, java.sql.Date x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateTime(String columnLabel, java.sql.Time x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateTimestamp(String columnLabel, java.sql.Timestamp x) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @param length the length of the stream * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateAsciiStream(String columnLabel, java.io.InputStream x, int length) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @param length the length of the stream * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateBinaryStream(String columnLabel, java.io.InputStream x, int length) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param reader the java.io.Reader object containing * the new column value * @param length the length of the stream * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateCharacterStream(String columnLabel, java.io.Reader reader, int length) throws SQLException; /** * Updates the designated column with an Object value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. *

* If the second argument is an InputStream then the stream must contain * the number of bytes specified by scaleOrLength. If the second argument is a * Reader then the reader must contain the number of characters specified * by scaleOrLength. If these conditions are not true the driver will generate a * SQLException when the statement is executed. * * @param 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 * @param x the new column value * @param scaleOrLength for an object of java.math.BigDecimal , * this is the number of digits after the decimal point. For * Java Object types InputStream and Reader, * this is the length * of the data in the stream or reader. For all other types, * this value will be ignored. * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateObject(String columnLabel, Object x, int scaleOrLength) throws SQLException; /** * Updates the designated column with an Object value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateObject(String columnLabel, Object x) throws SQLException; /** * Inserts the contents of the insert row into this * ResultSet object and into the database. * The cursor must be on the insert row when this method is called. * * @exception SQLException if a database access error occurs; * the result set concurrency is CONCUR_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 * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void insertRow() throws SQLException; /** * Updates the underlying database with the new contents of the * current row of this ResultSet object. * This method cannot be called when the cursor is on the insert row. * * @exception SQLException if a database access error occurs; * the result set concurrency is CONCUR_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 * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void updateRow() throws SQLException; /** * Deletes the current row from this ResultSet object * and from the underlying database. This method cannot be called when * the cursor is on the insert row. * * @exception SQLException if a database access error occurs; * the result set concurrency is CONCUR_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 * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void deleteRow() throws SQLException; /** * 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. * *

The refreshRow method provides a way for an * application to * explicitly tell the JDBC driver to refetch a row(s) from the * database. An application may want to call refreshRow when * caching or prefetching is being done by the JDBC driver to * fetch the latest value of a row from the database. The JDBC driver * may actually refresh multiple rows at once if the fetch size is * greater than one. * *

All values are refetched subject to the transaction isolation * level and cursor sensitivity. If refreshRow is called after * calling an updater method, but before calling * the method updateRow, then the * updates made to the row are lost. Calling the method * refreshRow frequently will likely slow performance. * * @exception SQLException if a database access error * occurs; this method is called on a closed result set; * the result set type is TYPE_FORWARD_ONLY or if this * method is called when the cursor is on the insert row * @exception 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 */ void refreshRow() throws SQLException; /** * Cancels the updates made to the current row in this * ResultSet object. * This method may be called after calling an * updater method(s) and before calling * the method updateRow to roll back * the updates made to a row. If no updates have been made or * updateRow has already been called, this method has no * effect. * * @exception SQLException if a database access error * occurs; this method is called on a closed result set; * the result set concurrency is CONCUR_READ_ONLY * or if this method is called when the cursor is * on the insert row * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void cancelRowUpdates() throws SQLException; /** * 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, * and insertRow methods may be * called when the cursor is on the insert row. All of the columns in * a result set must be given a value each time this method is * called before calling insertRow. * An updater method must be called before a * getter method can be called on a column value. * * @exception SQLException if a database access error occurs; this * method is called on a closed result set * or the result set concurrency is CONCUR_READ_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void moveToInsertRow() throws SQLException; /** * 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. * * @exception SQLException if a database access error occurs; this * method is called on a closed result set * or the result set concurrency is CONCUR_READ_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ void moveToCurrentRow() throws SQLException; /** * Retrieves the Statement object that produced this * ResultSet object. * If the result set was generated some other way, such as by a * DatabaseMetaData method, this method may return * null. * * @return the Statment object that produced * this ResultSet object or null * if the result set was produced some other way * @exception SQLException if a database access error occurs * or this method is called on a closed result set * @since 1.2 */ Statement getStatement() throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as an Object * in the Java programming language. * If the value is an SQL NULL, * the driver returns a Java null. * This method uses the given Map object * for the custom mapping of the * SQL structured or distinct type that is being retrieved. * * @param columnIndex the first column is 1, the second is 2, ... * @param map a java.util.Map object that contains the mapping * from SQL type names to classes in the Java programming language * @return an Object in the Java programming language * representing the SQL value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ Object getObject(int columnIndex, java.util.Map> map) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a Ref object * in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return a Ref object representing an SQL REF * value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ Ref getRef(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a Blob object * in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return a Blob object representing the SQL * BLOB value in the specified column * @exception SQLException if the columnIndex is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ Blob getBlob(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a Clob object * in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return a Clob object representing the SQL * CLOB value in the specified column * @exception SQLException if the columnIndex is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ Clob getClob(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as an Array object * in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return an Array object representing the SQL * ARRAY value in the specified column * @exception SQLException if the columnIndex is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ Array getArray(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as an Object * in the Java programming language. * If the value is an SQL NULL, * the driver returns a Java null. * This method uses the specified Map object for * custom mapping if appropriate. * * @param 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 * @param map a java.util.Map object that contains the mapping * from SQL type names to classes in the Java programming language * @return an Object representing the SQL value in the * specified column * @exception SQLException if the columnLabel is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ Object getObject(String columnLabel, java.util.Map> map) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a Ref object * in the Java programming language. * * @param 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 * @return a Ref object representing the SQL REF * value in the specified column * @exception SQLException if the columnLabel is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ Ref getRef(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a Blob object * in the Java programming language. * * @param 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 * @return a Blob object representing the SQL BLOB * value in the specified column * @exception SQLException if the columnLabel is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ Blob getBlob(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a Clob object * in the Java programming language. * * @param 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 * @return a Clob object representing the SQL CLOB * value in the specified column * @exception SQLException if the columnLabel is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ Clob getClob(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as an Array object * in the Java programming language. * * @param 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 * @return an Array object representing the SQL ARRAY value in * the specified column * @exception SQLException if the columnLabel is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.2 */ Array getArray(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a java.sql.Date object * in the Java programming language. * This method uses the given calendar to construct an appropriate millisecond * value for the date if the underlying database does not store * timezone information. * * @param columnIndex the first column is 1, the second is 2, ... * @param cal the java.util.Calendar object * to use in constructing the date * @return the column value as a java.sql.Date object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @exception 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 */ java.sql.Date getDate(int columnIndex, Calendar cal) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a java.sql.Date object * in the Java programming language. * This method uses the given calendar to construct an appropriate millisecond * value for the date if the underlying database does not store * timezone information. * * @param 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 * @param cal the java.util.Calendar object * to use in constructing the date * @return the column value as a java.sql.Date object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @exception 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 */ java.sql.Date getDate(String columnLabel, Calendar cal) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a java.sql.Time object * in the Java programming language. * This method uses the given calendar to construct an appropriate millisecond * value for the time if the underlying database does not store * timezone information. * * @param columnIndex the first column is 1, the second is 2, ... * @param cal the java.util.Calendar object * to use in constructing the time * @return the column value as a java.sql.Time object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @exception 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 */ java.sql.Time getTime(int columnIndex, Calendar cal) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a java.sql.Time object * in the Java programming language. * This method uses the given calendar to construct an appropriate millisecond * value for the time if the underlying database does not store * timezone information. * * @param 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 * @param cal the java.util.Calendar object * to use in constructing the time * @return the column value as a java.sql.Time object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @exception 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 */ java.sql.Time getTime(String columnLabel, Calendar cal) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a java.sql.Timestamp object * in the Java programming language. * This method uses the given calendar to construct an appropriate millisecond * value for the timestamp if the underlying database does not store * timezone information. * * @param columnIndex the first column is 1, the second is 2, ... * @param cal the java.util.Calendar object * to use in constructing the timestamp * @return the column value as a java.sql.Timestamp object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @exception 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 */ java.sql.Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a java.sql.Timestamp object * in the Java programming language. * This method uses the given calendar to construct an appropriate millisecond * value for the timestamp if the underlying database does not store * timezone information. * * @param 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 * @param cal the java.util.Calendar object * to use in constructing the date * @return the column value as a java.sql.Timestamp object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @exception 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 */ java.sql.Timestamp getTimestamp(String columnLabel, Calendar cal) throws SQLException; //-------------------------- JDBC 3.0 ---------------------------------------- /** * The constant indicating that open ResultSet objects with this * holdability will remain open when the current transaction is commited. * * @since 1.4 */ int HOLD_CURSORS_OVER_COMMIT = 1; /** * The constant indicating that open ResultSet objects with this * holdability will be closed when the current transaction is commited. * * @since 1.4 */ int CLOSE_CURSORS_AT_COMMIT = 2; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a java.net.URL * object in the Java programming language. * * @param columnIndex the index of the column 1 is the first, 2 is the second,... * @return the column value as a java.net.URL object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @exception 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 * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.4 */ java.net.URL getURL(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a java.net.URL * object in the Java programming language. * * @param 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 * @return the column value as a java.net.URL object; * if the value is SQL NULL, * the value returned is null in the Java programming language * @exception 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 * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.4 */ java.net.URL getURL(String columnLabel) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.4 */ void updateRef(int columnIndex, java.sql.Ref x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.4 */ void updateRef(String columnLabel, java.sql.Ref x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.4 */ void updateBlob(int columnIndex, java.sql.Blob x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.4 */ void updateBlob(String columnLabel, java.sql.Blob x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.4 */ void updateClob(int columnIndex, java.sql.Clob x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.4 */ void updateClob(String columnLabel, java.sql.Clob x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.4 */ void updateArray(int columnIndex, java.sql.Array x) throws SQLException; /** * Updates the designated column with a java.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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.4 */ void updateArray(String columnLabel, java.sql.Array x) throws SQLException; //------------------------- JDBC 4.0 ----------------------------------- /** * Retrieves the value of the designated column in the current row of this * ResultSet object as a java.sql.RowId object in the Java * programming language. * * @param columnIndex the first column is 1, the second 2, ... * @return the column value; if the value is a SQL NULL the * value returned is null * @throws SQLException if the columnIndex is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ RowId getRowId(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row of this * ResultSet object as a java.sql.RowId object in the Java * programming language. * * @param 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 * @return the column value ; if the value is a SQL NULL the * value returned is null * @throws SQLException if the columnLabel is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ RowId getRowId(String columnLabel) throws SQLException; /** * Updates the designated column with a RowId value. The updater * methods are used to update column values in the current row or the insert * row. The updater methods do not update the underlying database; instead * the updateRow or insertRow methods are called * to update the database. * * @param columnIndex the first column is 1, the second 2, ... * @param x the column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateRowId(int columnIndex, RowId x) throws SQLException; /** * Updates the designated column with a RowId value. The updater * methods are used to update column values in the current row or the insert * row. The updater methods do not update the underlying database; instead * the updateRow or insertRow methods are called * to update the database. * * @param 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 * @param x the column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateRowId(String columnLabel, RowId x) throws SQLException; /** * Retrieves the holdability of this ResultSet object * @return either ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.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 */ int getHoldability() throws SQLException; /** * Retrieves whether this ResultSet object has been closed. A ResultSet is closed if the * method close has been called on it, or if it is automatically closed. * * @return true if this ResultSet object is closed; false if it is still open * @throws SQLException if a database access error occurs * @since 1.6 */ boolean isClosed() throws SQLException; /** * Updates the designated column with a String value. * It is intended for use when updating NCHAR,NVARCHAR * and LONGNVARCHAR columns. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second 2, ... * @param 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 is CONCUR_READ_ONLY * or if a database access error occurs * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateNString(int columnIndex, String nString) throws SQLException; /** * Updates the designated column with a String value. * It is intended for use when updating NCHAR,NVARCHAR * and LONGNVARCHAR columns. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param 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 is CONCUR_READ_ONLY * or if a database access error occurs * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateNString(String columnLabel, String nString) throws SQLException; /** * Updates the designated column with a java.sql.NClob value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second 2, ... * @param 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 is CONCUR_READ_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateNClob(int columnIndex, NClob nClob) throws SQLException; /** * Updates the designated column with a java.sql.NClob value. * The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param 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 is CONCUR_READ_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateNClob(String columnLabel, NClob nClob) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a NClob object * in the Java programming language. * * @param columnIndex the first column is 1, the second is 2, ... * @return a NClob object representing the SQL * NCLOB value in the specified column * @exception 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 * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ NClob getNClob(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a NClob object * in the Java programming language. * * @param 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 * @return a NClob object representing the SQL NCLOB * value in the specified column * @exception 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 * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ NClob getNClob(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row of * this ResultSet as a * java.sql.SQLXML object in the Java programming language. * @param columnIndex the first column is 1, the second is 2, ... * @return a SQLXML object that maps an SQL 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 * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ SQLXML getSQLXML(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row of * this ResultSet as a * java.sql.SQLXML object in the Java programming language. * @param 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 * @return a SQLXML object that maps an SQL 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 * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ SQLXML getSQLXML(String columnLabel) throws SQLException; /** * Updates the designated column with a java.sql.SQLXML value. * The updater * methods are used to update column values in the current row or the insert * row. The updater methods do not update the underlying database; instead * the updateRow or insertRow methods are called * to update the database. *

* * @param columnIndex the first column is 1, the second 2, ... * @param 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; * the java.xml.transform.Result, * Writer or OutputStream has not been closed * for the SQLXML object; * if there is an error processing the XML value or * the result set concurrency is CONCUR_READ_ONLY. The getCause method * of the exception may provide a more detailed exception, for example, if the * stream does not contain valid XML. * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException; /** * Updates the designated column with a java.sql.SQLXML value. * The updater * methods are used to update column values in the current row or the insert * row. The updater methods do not update the underlying database; instead * the updateRow or insertRow methods are called * to update the database. *

* * @param 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 * @param 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; * the java.xml.transform.Result, * Writer or OutputStream has not been closed * for the SQLXML object; * if there is an error processing the XML value or * the result set concurrency is CONCUR_READ_ONLY. The getCause method * of the exception may provide a more detailed exception, for example, if the * stream does not contain valid XML. * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a String in the Java programming language. * It is intended for use when * accessing NCHAR,NVARCHAR * and LONGNVARCHAR columns. * * @param columnIndex the first column is 1, the second is 2, ... * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnIndex is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ String getNString(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as * a String in the Java programming language. * It is intended for use when * accessing NCHAR,NVARCHAR * and LONGNVARCHAR columns. * * @param 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 * @return the column value; if the value is SQL NULL, the * value returned is null * @exception SQLException if the columnLabel is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ String getNString(String columnLabel) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a * java.io.Reader object. * It is intended for use when * accessing NCHAR,NVARCHAR * and LONGNVARCHAR columns. * * @return a java.io.Reader object that contains the column * value; if the value is SQL NULL, the value returned is * null in the Java programming language. * @param columnIndex the first column is 1, the second is 2, ... * @exception SQLException if the columnIndex is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ java.io.Reader getNCharacterStream(int columnIndex) throws SQLException; /** * Retrieves the value of the designated column in the current row * of this ResultSet object as a * java.io.Reader object. * It is intended for use when * accessing NCHAR,NVARCHAR * and LONGNVARCHAR columns. * * @param 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 * @return a java.io.Reader object that contains the column * value; if the value is SQL NULL, the value returned is * null in the Java programming language * @exception SQLException if the columnLabel is not valid; * if a database access error occurs * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ java.io.Reader getNCharacterStream(String columnLabel) throws SQLException; /** * 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 * updating NCHAR,NVARCHAR * and LONGNVARCHAR columns. *

* The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @param length the length of the stream * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateNCharacterStream(int columnIndex, java.io.Reader x, long length) throws SQLException; /** * 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 * updating NCHAR,NVARCHAR * and LONGNVARCHAR columns. *

* The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param reader the java.io.Reader object containing * the new column value * @param length the length of the stream * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateNCharacterStream(String columnLabel, java.io.Reader reader, long length) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @param length the length of the stream * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateAsciiStream(int columnIndex, java.io.InputStream x, long length) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @param length the length of the stream * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateBinaryStream(int columnIndex, java.io.InputStream x, long length) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @param length the length of the stream * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateCharacterStream(int columnIndex, java.io.Reader x, long length) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @param length the length of the stream * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateAsciiStream(String columnLabel, java.io.InputStream x, long length) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param x the new column value * @param length the length of the stream * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateBinaryStream(String columnLabel, java.io.InputStream x, long length) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param reader the java.io.Reader object containing * the new column value * @param length the length of the stream * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateCharacterStream(String columnLabel, java.io.Reader reader, long length) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param inputStream An object that contains the data to set the parameter * value to. * @param length the number of bytes in the parameter data. * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateBlob(int columnIndex, InputStream inputStream, long length) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param inputStream An object that contains the data to set the parameter * value to. * @param length the number of bytes in the parameter data. * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateBlob(String columnLabel, InputStream inputStream, long length) throws SQLException; /** * Updates the designated column using the given Reader * object, which is the given number of characters long. * When a very large UNICODE value is input to a LONGVARCHAR * parameter, it may be more practical to send it via a * java.io.Reader object. The 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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second is 2, ... * @param reader An object that contains the data to set the parameter value to. * @param length the number of characters in the parameter data. * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateClob(int columnIndex, Reader reader, long length) throws SQLException; /** * Updates the designated column using the given Reader * object, which is the given number of characters long. * When a very large UNICODE value is input to a LONGVARCHAR * parameter, it may be more practical to send it via a * java.io.Reader object. The 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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param reader An object that contains the data to set the parameter value to. * @param length the number of characters in the parameter data. * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateClob(String columnLabel, Reader reader, long length) throws SQLException; /** * Updates the designated column using the given Reader * object, which is the given number of characters long. * When a very large UNICODE value is input to a LONGVARCHAR * parameter, it may be more practical to send it via a * java.io.Reader object. The 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 the updateRow or * insertRow methods are called to update the database. * * @param columnIndex the first column is 1, the second 2, ... * @param reader An object that contains the data to set the parameter value to. * @param 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 is CONCUR_READ_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateNClob(int columnIndex, Reader reader, long length) throws SQLException; /** * Updates the designated column using the given Reader * object, which is the given number of characters long. * When a very large UNICODE value is input to a LONGVARCHAR * parameter, it may be more practical to send it via a * java.io.Reader object. The 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 the updateRow or * insertRow methods are called to update the database. * * @param 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 * @param reader An object that contains the data to set the parameter value to. * @param 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 is CONCUR_READ_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateNClob(String columnLabel, Reader reader, long length) throws SQLException; //--- /** * 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 * updating NCHAR,NVARCHAR * and LONGNVARCHAR columns. *

* The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateNCharacterStream which takes a length parameter. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateNCharacterStream(int columnIndex, java.io.Reader x) throws SQLException; /** * 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 * updating NCHAR,NVARCHAR * and LONGNVARCHAR columns. *

* The updater methods are used to update column values in the * current row or the insert row. The updater methods do not * update the underlying database; instead the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateNCharacterStream which takes a length parameter. * * @param 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 * @param reader the java.io.Reader object containing * the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateNCharacterStream(String columnLabel, java.io.Reader reader) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateAsciiStream which takes a length parameter. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateAsciiStream(int columnIndex, java.io.InputStream x) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateBinaryStream which takes a length parameter. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateBinaryStream(int columnIndex, java.io.InputStream x) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateCharacterStream which takes a length parameter. * * @param columnIndex the first column is 1, the second is 2, ... * @param x the new column value * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateCharacterStream(int columnIndex, java.io.Reader x) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateAsciiStream which takes a length parameter. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateAsciiStream(String columnLabel, java.io.InputStream x) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateBinaryStream which takes a length parameter. * * @param 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 * @param x the new column value * @exception SQLException if the columnLabel is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateBinaryStream(String columnLabel, java.io.InputStream x) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateCharacterStream which takes a length parameter. * * @param 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 * @param reader the java.io.Reader object containing * the new column value * @exception SQLException if the columnLabel is not valid; if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateCharacterStream(String columnLabel, java.io.Reader reader) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateBlob which takes a length parameter. * * @param columnIndex the first column is 1, the second is 2, ... * @param inputStream An object that contains the data to set the parameter * value to. * @exception SQLException if the columnIndex is not valid; if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateBlob(int columnIndex, InputStream inputStream) throws SQLException; /** * 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 the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateBlob which takes a length parameter. * * @param 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 * @param inputStream An object that contains the data to set the parameter * value to. * @exception SQLException if the columnLabel is not valid; if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateBlob(String columnLabel, InputStream inputStream) throws SQLException; /** * Updates the designated column using the given Reader * 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 the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateClob which takes a length parameter. * * @param columnIndex the first column is 1, the second is 2, ... * @param reader An object that contains the data to set the parameter value to. * @exception SQLException if the columnIndex is not valid; * if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateClob(int columnIndex, Reader reader) throws SQLException; /** * Updates the designated column using the given Reader * 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 the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateClob which takes a length parameter. * * @param 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 * @param reader An object that contains the data to set the parameter value to. * @exception SQLException if the columnLabel is not valid; if a database access error occurs; * the result set concurrency is CONCUR_READ_ONLY * or this method is called on a closed result set * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateClob(String columnLabel, Reader reader) throws SQLException; /** * Updates the designated column using the given Reader * * 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 the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateNClob which takes a length parameter. * * @param columnIndex the first column is 1, the second 2, ... * @param 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 is CONCUR_READ_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateNClob(int columnIndex, Reader reader) throws SQLException; /** * Updates the designated column using the given Reader * 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 the updateRow or * insertRow methods are called to update the database. * *

Note: Consult your JDBC driver documentation to determine if * it might be more efficient to use a version of * updateNClob which takes a length parameter. * * @param 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 * @param 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 is CONCUR_READ_ONLY * @exception SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.6 */ void updateNClob(String columnLabel, Reader reader) throws SQLException; //------------------------- JDBC 4.1 ----------------------------------- /** *

Retrieves the value of the designated column in the current row * of this ResultSet object and will convert from the * SQL type of the column to the requested Java data type, if the * conversion is supported. If the conversion is not * supported or null is specified for the type, a * SQLException is thrown. *

* At a minimum, an implementation must support the conversions defined in * Appendix B, Table B-3 and conversion of appropriate user defined SQL * types to a Java type which implements {@code SQLData}, or {@code Struct}. * Additional conversions may be supported and are vendor defined. * * @param columnIndex the first column is 1, the second is 2, ... * @param type Class representing the Java data type to convert the designated * column to. * @return an instance of {@code type} 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 * @throws SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.7 */ public T getObject(int columnIndex, Class type) throws SQLException; /** *

Retrieves the value of the designated column in the current row * of this ResultSet object and will convert from the * SQL type of the column to the requested Java data type, if the * conversion is supported. If the conversion is not * supported or null is specified for the type, a * SQLException is thrown. *

* At a minimum, an implementation must support the conversions defined in * Appendix B, Table B-3 and conversion of appropriate user defined SQL * types to a Java type which implements {@code SQLData}, or {@code Struct}. * Additional conversions may be supported and are vendor defined. * * @param 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 * @param type Class representing the Java data type to convert the designated * column to. * @return an instance of {@code type} 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 * @throws SQLFeatureNotSupportedException if the JDBC driver does not support * this method * @since 1.7 */ public T getObject(String columnLabel, Class type) throws SQLException; }