Java Doc for ResultSet.java in  » 6.0-JDK-Core » sql » java » sql » Java Source Code / Java DocumentationJava Source Code and Java Documentation

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
 

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 (Java^TM 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 ResulSetMetaData object returned by the ResultSet.getMetaData method.
See Also:   Statement.executeQuery
See Also:   
See Also:   Statement.getResultSet
See Also:   
See Also:   ResultSetMetaData
See Also:   

If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set.

The closing of a ResultSet object does not close the Blob, Clob or NClob objects created by the ResultSet.

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.

In SQL, a result table is retrieved through a cursor that is named.

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.

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 warning chain is automatically cleared each time a new row is read.

When a call to the previous method returns false, the cursor is positioned before the first row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

The updater methods are used to update column values in the current row or the insert row.

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

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

An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before the first row or after the last row.

Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().
Parameters:
  row - the number of the row to which the cursor should move.A positive number indicates the row number counting from thebeginning of the result set; a negative number indicates therow number counting from the end of the result set true if the cursor is moved to a position in thisResultSet object; false if the cursor is before the first row or after thelast row
exception:
  SQLException - if a database access erroroccurs; 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 supportthis method
since:
   1.2

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

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.
Parameters:
  columnIndex - the first column is 1, the second is 2, ... a Java input stream that delivers the database column valueas a stream of one-byte ASCII characters;if the value is SQL NULL, thevalue 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

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.
Parameters:
  columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column a Java input stream that delivers the database column valueas 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

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.
Parameters:
  columnIndex - the first column is 1, the second is 2, ... a Java input stream that delivers the database column valueas 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

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.
Parameters:
  columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column a Java input stream that delivers the database column valueas 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

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.
Parameters:
  columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, thevalue 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

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.
Parameters:
  columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column the column value; if the value is SQL NULL, thevalue 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

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. 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 supportthis method

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.
Parameters:
  columnIndex - the first column is 1, the second is 2, ... 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

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()).
Parameters:
  columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column 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

Note:Support for the getRow method is optional for ResultSets with a result set type of TYPE_FORWARD_ONLY 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 supportthis method
since:
   1.2

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.
Parameters:
  columnIndex - the first column is 1, the second is 2, ... a Java input stream that delivers the database column valueas 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 supportthis method

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.
Parameters:
  columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column a Java input stream that delivers the database column valueas 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 supportthis method

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

Note:Support for the isAfterLast method is optional for ResultSets with a result set type of TYPE_FORWARD_ONLY true if the cursor is after the last row;false if the cursor is at any other position or theresult 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 supportthis method
since:
   1.2

Note:Support for the isBeforeFirst method is optional for ResultSets with a result set type of TYPE_FORWARD_ONLY true if the cursor is before the first row;false if the cursor is at any other position or theresult 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 supportthis method
since:
   1.2

Note:Support for the isFirst method is optional for ResultSets with a result set type of TYPE_FORWARD_ONLY 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 supportthis method
since:
   1.2

Note: Support for the isLast method is optional for ResultSets with a result set type of TYPE_FORWARD_ONLY 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 supportthis method
since:
   1.2

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

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.

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 erroroccurs; this method is called on a closed result setor the result set type is TYPE_FORWARD_ONLY
exception:
  SQLFeatureNotSupportedException - if the JDBC driver does not supportthis method
since:
   1.2

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 erroroccurs; 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 supportthis method or this method is not supported for the specified result set type and result set concurrency.
since:
   1.2

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().
Parameters:
  rows - an int specifying the number of rows tomove from the current row; a positive number moves the cursorforward; a negative number moves the cursor backward 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 supportthis method
since:
   1.2

Note: Support for the rowDeleted method is optional with a result set concurrency of CONCUR_READ_ONLY 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 supportthis method
See Also:   DatabaseMetaData.deletesAreDetected
since:
   1.2

Note: Support for the rowInserted method is optional with a result set concurrency of CONCUR_READ_ONLY 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 supportthis method
See Also:   DatabaseMetaData.insertsAreDetected
since:
   1.2

Note: Support for the rowUpdated method is optional with a result set concurrency of CONCUR_READ_ONLY 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 supportthis method
See Also:   DatabaseMetaData.updatesAreDetected
since:
   1.2

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.
Parameters:
  columnIndex - the first column is 1, the second is 2, ...
Parameters:
  x - the new column value
Parameters:
  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 supportthis method
since:
   1.6

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.
Parameters:
  columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Parameters:
  x - the new column value
Parameters:
  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 supportthis method
since:
   1.6

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.
Parameters:
  columnIndex - the first column is 1, the second is 2, ...
Parameters:
  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 supportthis method
since:
   1.6

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.
Parameters:
  columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Parameters:
  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 supportthis method
since:
   1.6

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.
Parameters:
  columnIndex - the first column is 1, the second is 2, ...
Parameters:
  x - the new column value
Parameters:
  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 supportthis method
since:
   1.6

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.
Parameters:
  columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Parameters:
  x - the new column value
Parameters:
  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 supportthis method
since:
   1.6

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.
Parameters:
  columnIndex - the first column is 1, the second is 2, ...
Parameters:
  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 supportthis method
since:
   1.6

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.
Parameters:
  columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Parameters:
  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 supportthis method
since:
   1.6

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.
Parameters:
  columnIndex - the first column is 1, the second is 2, ...
Parameters:
  inputStream - An object that contains the data to set the parametervalue to.
Parameters:
  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 supportthis method
since:
   1.6

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.
Parameters:
  columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Parameters:
  inputStream - An object that contains the data to set the parametervalue to.
Parameters:
  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 supportthis method
since:
   1.6

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.
Parameters:
  columnIndex - the first column is 1, the second is 2, ...
Parameters:
  inputStream - An object that contains the data to set the parametervalue 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 supportthis method
since:
   1.6

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.
Parameters:
  columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Parameters:
  inputStream - An object that contains the data to set the parametervalue 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 supportthis method
since:
   1.6