Class ResultSetWrapper40

    • Field Detail

      • localStrings

        protected static final StringManager localStrings
    • Constructor Detail

      • ResultSetWrapper40

        public ResultSetWrapper40​(Statement stmt,
                                  ResultSet rs)
        Creates a new instance of ResultSetWrapper for JDBC 4.0
        Parameters:
        stmt - Statement that is to be wrapped
        rs - ResultSet that is to be wraped
        *
    • Method Detail

      • getRowId

        public 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.
        Parameters:
        columnIndex - the first column is 1, the second 2, ...
        Returns:
        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
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • getRowId

        public RowId getRowId​(String columnLabel)
                       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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        Returns:
        the column value ; if the value is a 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
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateRowId

        public 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.
        Parameters:
        columnIndex - the first column is 1, the second 2, ...
        x - the column value
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateRowId

        public void updateRowId​(String columnLabel,
                                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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        x - the column value
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • getHoldability

        public int getHoldability()
                           throws SQLException
        Retrieves the holdability of this ResultSet object
        Returns:
        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
      • isClosed

        public boolean isClosed()
                         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.
        Returns:
        true if this ResultSet object is closed; false if it is still open
        Throws:
        SQLException - if a database access error occurs
        Since:
        1.6
      • updateNString

        public 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.
        Parameters:
        columnIndex - the first column is 1, the second 2, ...
        nString - the value for the column to be updated
        Throws:
        SQLException - if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; the result set concurrency is CONCUR_READ_ONLY or if a database access error occurs
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateNString

        public void updateNString​(String columnLabel,
                                  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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        nString - the value for the column to be updated
        Throws:
        SQLException - if the columnLabel is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; the result set concurrency is CONCUR_READ_ONLY or if a database access error occurs
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateNClob

        public 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.
        Parameters:
        columnIndex - the first column is 1, the second 2, ...
        nClob - the value for the column to be updated
        Throws:
        SQLException - if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateNClob

        public void updateNClob​(String columnLabel,
                                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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        nClob - the value for the column to be updated
        Throws:
        SQLException - if the columnLabel is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • getNClob

        public 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.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        Returns:
        a NClob object representing the SQL NCLOB value in the specified column
        Throws:
        SQLException - if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set or if a database access error occurs
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • getNClob

        public NClob getNClob​(String columnLabel)
                       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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        Returns:
        a NClob object representing the SQL NCLOB value in the specified column
        Throws:
        SQLException - if the columnLabel is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set or if a database access error occurs
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • getSQLXML

        public 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.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        Returns:
        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
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • getSQLXML

        public SQLXML getSQLXML​(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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        Returns:
        a 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
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateSQLXML

        public 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.
        Parameters:
        columnIndex - the first column is 1, the second 2, ...
        xmlObject - the value for the column to be updated
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; this method is called on a closed result set; 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.
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateSQLXML

        public void updateSQLXML​(String columnLabel,
                                 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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        xmlObject - the column value
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; this method is called on a closed result set; 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.
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • getNString

        public 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.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        Returns:
        the column value; if the value is 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
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • getNString

        public String getNString​(String columnLabel)
                          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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        Returns:
        the column value; if the value is 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
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • getNCharacterStream

        public 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.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        Returns:
        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.
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • getNCharacterStream

        public Reader getNCharacterStream​(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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        Returns:
        a java.io.Reader object that contains the column value; if the value is SQL NULL, the value returned is null in the Java programming language
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateNCharacterStream

        public void updateNCharacterStream​(int columnIndex,
                                           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.

        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        x - the new column value
        length - the length of the stream
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateNCharacterStream

        public void updateNCharacterStream​(String columnLabel,
                                           Reader reader,
                                           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.

        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        reader - the java.io.Reader object containing the new column value
        length - the length of the stream
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateAsciiStream

        public void updateAsciiStream​(int columnIndex,
                                      InputStream 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.

        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        x - the new column value
        length - the length of the stream
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateBinaryStream

        public void updateBinaryStream​(int columnIndex,
                                       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.

        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        x - the new column value
        length - the length of the stream
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateCharacterStream

        public void updateCharacterStream​(int columnIndex,
                                          Reader 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.

        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        x - the new column value
        length - the length of the stream
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateAsciiStream

        public void updateAsciiStream​(String columnLabel,
                                      InputStream 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.

        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        x - the new column value
        length - the length of the stream
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateBinaryStream

        public void updateBinaryStream​(String columnLabel,
                                       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.

        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        x - the new column value
        length - the length of the stream
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateCharacterStream

        public void updateCharacterStream​(String columnLabel,
                                          Reader reader,
                                          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.

        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        reader - the java.io.Reader object containing the new column value
        length - the length of the stream
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateBlob

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

        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        inputStream - An object that contains the data to set the parameter value to.
        length - the number of bytes in the parameter data.
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateBlob

        public void updateBlob​(String columnLabel,
                               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.

        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        inputStream - An object that contains the data to set the parameter value to.
        length - the number of bytes in the parameter data.
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateClob

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

        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        reader - An object that contains the data to set the parameter value to.
        length - the number of characters in the parameter data.
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateClob

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

        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        reader - An object that contains the data to set the parameter value to.
        length - the number of characters in the parameter data.
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateNClob

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

        Parameters:
        columnIndex - the first column is 1, the second 2, ...
        reader - An object that contains the data to set the parameter value to.
        length - the number of characters in the parameter data.
        Throws:
        SQLException - if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateNClob

        public void updateNClob​(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.

        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        reader - An object that contains the data to set the parameter value to.
        length - the number of characters in the parameter data.
        Throws:
        SQLException - if the columnLabel is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateNCharacterStream

        public void updateNCharacterStream​(int columnIndex,
                                           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.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        x - the new column value
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateNCharacterStream

        public void updateNCharacterStream​(String columnLabel,
                                           Reader reader)
                                    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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        reader - the java.io.Reader object containing the new column value
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateAsciiStream

        public void updateAsciiStream​(int columnIndex,
                                      InputStream 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.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        x - the new column value
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateBinaryStream

        public void updateBinaryStream​(int columnIndex,
                                       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.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        x - the new column value
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateCharacterStream

        public void updateCharacterStream​(int columnIndex,
                                          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 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.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        x - the new column value
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateAsciiStream

        public void updateAsciiStream​(String columnLabel,
                                      InputStream 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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        x - the new column value
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateBinaryStream

        public void updateBinaryStream​(String columnLabel,
                                       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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        x - the new column value
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateCharacterStream

        public void updateCharacterStream​(String columnLabel,
                                          Reader reader)
                                   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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        reader - the java.io.Reader object containing the new column value
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateBlob

        public 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.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        inputStream - An object that contains the data to set the parameter value to.
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateBlob

        public void updateBlob​(String columnLabel,
                               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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        inputStream - An object that contains the data to set the parameter value to.
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateClob

        public 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.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        reader - An object that contains the data to set the parameter value to.
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateClob

        public void updateClob​(String columnLabel,
                               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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        reader - An object that contains the data to set the parameter value to.
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateNClob

        public void updateNClob​(int columnIndex,
                                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.

        Parameters:
        columnIndex - the first column is 1, the second 2, ...
        reader - An object that contains the data to set the parameter value to.
        Throws:
        SQLException - if the columnIndex is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set, if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • updateNClob

        public void updateNClob​(String columnLabel,
                                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.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        reader - An object that contains the data to set the parameter value to.
        Throws:
        SQLException - if the columnLabel is not valid; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; this method is called on a closed result set; if a database access error occurs or the result set concurrency is CONCUR_READ_ONLY
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method
        Since:
        1.6
      • unwrap

        public <T> T unwrap​(Class<T> iface)
                     throws SQLException
        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.

        Parameters:
        iface - A Class defining an interface that the result must implement.
        Returns:
        an object that implements the interface. May be a proxy for the actual implementing object.
        Throws:
        SQLException - If no object found that implements the interface
        Since:
        1.6
      • isWrapperFor

        public boolean isWrapperFor​(Class<?> iface)
                             throws SQLException
        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.
        Parameters:
        iface - a Class defining an interface.
        Returns:
        true if this implements the interface or directly or indirectly wraps an object that does.
        Throws:
        SQLException - if an error occurs while determining whether this is a wrapper for an object with the given interface.
        Since:
        1.6
      • updateObject

        public void updateObject​(int columnIndex,
                                 Object columnValue,
                                 SQLType targetSqlType,
                                 int scaleOrLength)
                          throws SQLException
        Updates the designated column with an Object value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        columnValue - the new column value
        targetSqlType - the SQL type to be sent to the database
        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.
        Throws:
        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
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method; if the JDBC driver does not support the specified targetSqlType
      • updateObject

        public void updateObject​(String columnLabel,
                                 Object columnValue,
                                 SQLType targetSqlType,
                                 int scaleOrLength)
                          throws SQLException
        Updates the designated column with an Object value.
        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
        columnValue - the new column value
        targetSqlType - the SQL type to be sent to the database
        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.
        Throws:
        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
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method; if the JDBC driver does not support the specified targetSqlType
      • updateObject

        public void updateObject​(int columnIndex,
                                 Object columnValue,
                                 SQLType targetSqlType)
                          throws SQLException
        Updates the designated column with an Object value.
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        columnValue - the new column value
        targetSqlType - the SQL type to be sent to the database
        Throws:
        SQLException - if the columnIndex is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method; if the JDBC driver does not support the specified targetSqlType
      • updateObject

        public void updateObject​(String columnLabel,
                                 Object columnValue,
                                 SQLType targetSqlType)
                          throws SQLException
        Updates the designated column with an Object value.
        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
        columnValue - the new column value
        targetSqlType - the SQL type to be sent to the database
        Throws:
        SQLException - if the columnLabel is not valid; if a database access error occurs; the result set concurrency is CONCUR_READ_ONLY or this method is called on a closed result set
        SQLFeatureNotSupportedException - if the JDBC driver does not support this method; if the JDBC driver does not support the specified targetSqlType