FileDocCategorySizeDatePackage
ResultSetWrapper40.javaAPI DocGlassfish v2 API65323Fri May 04 22:36:06 BST 2007com.sun.gjc.spi.jdbc40

ResultSetWrapper40

public class ResultSetWrapper40 extends com.sun.gjc.spi.base.ResultSetWrapper
Wrapper for ResultSet

Fields Summary
protected static final com.sun.enterprise.util.i18n.StringManager
localStrings
Constructors Summary
public ResultSetWrapper40(Statement stmt, ResultSet rs)
Creates a new instance of ResultSetWrapper for JDBC 4.0

param
stmt Statement that is to be wrapped
param
rs ResultSet that is to be wraped
*


                                  
         
        super(stmt, rs);
    
Methods Summary
public intgetHoldability()
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

        return resultSet.getHoldability();
    
public java.io.ReadergetNCharacterStream(int columnIndex)
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

        return resultSet.getNCharacterStream(columnIndex);
    
public java.io.ReadergetNCharacterStream(java.lang.String columnLabel)
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

        return resultSet.getNCharacterStream(columnLabel);
    
public java.sql.NClobgetNClob(int columnIndex)
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

        return resultSet.getNClob(columnIndex);
    
public java.sql.NClobgetNClob(java.lang.String columnLabel)
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

        return resultSet.getNClob(columnLabel);
    
public java.lang.StringgetNString(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. 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

        return resultSet.getNString(columnIndex);
    
public java.lang.StringgetNString(java.lang.String columnLabel)
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

        return resultSet.getNString(columnLabel);
    
public java.sql.RowIdgetRowId(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.

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

        return resultSet.getRowId(columnIndex);
    
public java.sql.RowIdgetRowId(java.lang.String columnLabel)
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

        return resultSet.getRowId(columnLabel);
    
public java.sql.SQLXMLgetSQLXML(int columnIndex)
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

        return resultSet.getSQLXML(columnIndex);
    
public java.sql.SQLXMLgetSQLXML(java.lang.String columnLabel)
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

        return resultSet.getSQLXML(columnLabel);
    
public booleanisClosed()
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

        return resultSet.isClosed();
    
public booleanisWrapperFor(java.lang.Class iface)
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. Returns false otherwise. If this implements the interface then return true, else if this is a wrapper then return the result of recursively calling isWrapperFor on the wrapped object. If this does not implement the interface and is not a wrapper, return false. This method should be implemented as a low-cost operation compared to unwrap so that callers can use this method to avoid expensive unwrap calls that may fail. If this method returns true then calling unwrap with the same argument should succeed.

param
iface a Class defining an interface.
return
true if this implements the interface or directly or indirectly wraps an object that does.
throws
java.sql.SQLException if an error occurs while determining whether this is a wrapper for an object with the given interface.
since
1.6

        boolean result ;
        if (iface.isInstance(this)) {
            result = true;
        }else{
            result = resultSet.isWrapperFor(iface);
        }
        return result;
    
public Tunwrap(java.lang.Class iface)
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. If the receiver implements the interface then the result is the receiver or a proxy for the receiver. If the receiver is a wrapper and the wrapped object implements the interface then the result is the wrapped object or a proxy for the wrapped object. Otherwise return the the result of calling unwrap recursively on the wrapped object or a proxy for that result. If the receiver is not a wrapper and does not implement the interface, then an SQLException is thrown.

param
iface A Class defining an interface that the result must implement.
return
an object that implements the interface. May be a proxy for the actual implementing object.
throws
java.sql.SQLException If no object found that implements the interface
since
1.6

        T result ;
        if (iface.isInstance(this)) {
            result = iface.cast(this);
        } else {
            result = resultSet.unwrap(iface);
        }
        return result;
    
public voidupdateAsciiStream(int columnIndex, java.io.InputStream x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.

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

        resultSet.updateAsciiStream(columnIndex, x, length);
    
public voidupdateAsciiStream(java.lang.String columnLabel, java.io.InputStream x, long length)
Updates the designated column with an ascii stream value, which will have the specified number of bytes.

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

        resultSet.updateAsciiStream(columnLabel, x, length);
    
public voidupdateAsciiStream(int columnIndex, java.io.InputStream x)
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

        resultSet.updateAsciiStream(columnIndex, x);
    
public voidupdateAsciiStream(java.lang.String columnLabel, java.io.InputStream x)
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

        resultSet.updateAsciiStream(columnLabel, x);
    
public voidupdateBinaryStream(int columnIndex, java.io.InputStream x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.

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

        resultSet.updateBinaryStream(columnIndex, x, length);
    
public voidupdateBinaryStream(java.lang.String columnLabel, java.io.InputStream x, long length)
Updates the designated column with a binary stream value, which will have the specified number of bytes.

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

        resultSet.updateBinaryStream(columnLabel, x, length);
    
public voidupdateBinaryStream(int columnIndex, java.io.InputStream x)
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

        resultSet.updateBinaryStream(columnIndex, x);
    
public voidupdateBinaryStream(java.lang.String columnLabel, java.io.InputStream x)
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

        resultSet.updateBinaryStream(columnLabel, x);
    
public voidupdateBlob(int columnIndex, java.io.InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes.

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

        resultSet.updateBlob(columnIndex, inputStream, length);
    
public voidupdateBlob(java.lang.String columnLabel, java.io.InputStream inputStream, long length)
Updates the designated column using the given input stream, which will have the specified number of bytes.

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

        resultSet.updateBlob(columnLabel, inputStream, length);
    
public voidupdateBlob(int columnIndex, java.io.InputStream inputStream)
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

        resultSet.updateBlob(columnIndex, inputStream);
    
public voidupdateBlob(java.lang.String columnLabel, java.io.InputStream inputStream)
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

        resultSet.updateBlob(columnLabel, inputStream);
    
public voidupdateCharacterStream(int columnIndex, java.io.Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.

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

        resultSet.updateCharacterStream(columnIndex, x, length);
    
public voidupdateCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes.

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

        resultSet.updateCharacterStream(columnLabel, reader, length);
    
public voidupdateCharacterStream(int columnIndex, java.io.Reader x)
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

        resultSet.updateCharacterStream(columnIndex, x);
    
public voidupdateCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
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

        resultSet.updateCharacterStream(columnLabel, reader);
    
public voidupdateClob(int columnIndex, java.io.Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long. 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

        resultSet.updateClob(columnIndex, reader, length);
    
public voidupdateClob(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long. 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

        resultSet.updateClob(columnLabel, reader, length);
    
public voidupdateClob(int columnIndex, java.io.Reader reader)
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

        resultSet.updateClob(columnIndex, reader);
    
public voidupdateClob(java.lang.String columnLabel, java.io.Reader reader)
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

        resultSet.updateClob(columnLabel, reader);
    
public voidupdateNCharacterStream(int columnIndex, java.io.Reader x, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. 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

        resultSet.updateNCharacterStream(columnIndex, x, length);
    
public voidupdateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column with a character stream value, which will have the specified number of bytes. 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

        resultSet.updateNCharacterStream(columnLabel, reader, length);
    
public voidupdateNCharacterStream(int columnIndex, java.io.Reader x)
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

        resultSet.updateNCharacterStream(columnIndex, x);
    
public voidupdateNCharacterStream(java.lang.String columnLabel, java.io.Reader reader)
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

        resultSet.updateNCharacterStream(columnLabel, reader);
    
public voidupdateNClob(int columnIndex, java.sql.NClob nClob)
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

        resultSet.updateNClob(columnIndex, nClob);
    
public voidupdateNClob(java.lang.String columnLabel, java.sql.NClob nClob)
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

        resultSet.updateNClob(columnLabel, nClob);
    
public voidupdateNClob(int columnIndex, java.io.Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long. 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

        resultSet.updateNClob(columnIndex, reader, length);
    
public voidupdateNClob(java.lang.String columnLabel, java.io.Reader reader, long length)
Updates the designated column using the given Reader object, which is the given number of characters long. 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

        resultSet.updateNClob(columnLabel, reader, length);
    
public voidupdateNClob(int columnIndex, java.io.Reader reader)
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

        resultSet.updateNClob(columnIndex, reader);
    
public voidupdateNClob(java.lang.String columnLabel, java.io.Reader reader)
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

        resultSet.updateNClob(columnLabel, reader);
    
public voidupdateNString(int columnIndex, java.lang.String nString)
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

        resultSet.updateNString(columnIndex, nString);
    
public voidupdateNString(java.lang.String columnLabel, java.lang.String nString)
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

        resultSet.updateNString(columnLabel, nString);
    
public voidupdateRowId(int columnIndex, java.sql.RowId x)
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

        resultSet.updateRowId(columnIndex, x);
    
public voidupdateRowId(java.lang.String columnLabel, java.sql.RowId x)
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

        resultSet.updateRowId(columnLabel, x);
    
public voidupdateSQLXML(int columnIndex, java.sql.SQLXML xmlObject)
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

        resultSet.updateSQLXML(columnIndex, xmlObject);
    
public voidupdateSQLXML(java.lang.String columnLabel, java.sql.SQLXML xmlObject)
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

        resultSet.updateSQLXML(columnLabel, xmlObject);