Class SQLServerResultSet

    • Field Detail

      • loggerExternal

        protected static final Logger loggerExternal
    • Method Detail

      • getServerCursorId

        protected int getServerCursorId()
      • getTDSReader

        protected com.microsoft.sqlserver.jdbc.TDSReader getTDSReader()
      • getSensitivityClassification

        public SensitivityClassification getSensitivityClassification()
        Description copied from interface: ISQLServerResultSet
        Returns the Data Classification information for the current ResultSet For SQL Servers that do not support Data Classification or results that do not fetch any classified columns, this data can be null.
        Specified by:
        getSensitivityClassification in interface ISQLServerResultSet
        Returns:
        SensitivityClassification
      • isForwardOnly

        protected boolean isForwardOnly()
      • findColumn

        public int findColumn​(String userProvidedColumnName)
                       throws SQLServerException
        Finds a column index given a column name.
        Specified by:
        findColumn in interface ResultSet
        Parameters:
        userProvidedColumnName - the name of the column
        Returns:
        the column index
        Throws:
        SQLServerException - If any errors occur.
      • next

        public boolean next()
                     throws SQLServerException
        Moves the cursor to the first row of this ResultSet object initially, then subsequent calls move the cursor to the second row, the third row, and so on.
        Specified by:
        next in interface ResultSet
        Returns:
        false when there are no more rows to read
        Throws:
        SQLServerException
      • isBeforeFirst

        public boolean isBeforeFirst()
                              throws SQLException
        Returns if the cursor is before the first row in this result set.
        Specified by:
        isBeforeFirst in interface ResultSet
        Returns:
        true if the cursor is before the first row in this result set, returns false otherwise or if the result set contains no rows.
        Throws:
        SQLException
      • isFirst

        public boolean isFirst()
                        throws SQLException
        Returns whether the cursor is on the first row of this ResultSet object. This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.

        Note:Support for the isFirst method is optional for ResultSets with a result set type of TYPE_FORWARD_ONLY

        Specified by:
        isFirst in interface ResultSet
        Returns:
        true if the cursor is on the first row; false otherwise
        Throws:
        SQLException - if a database access error occurs or this method is called on a closed result set
        Since:
        1.2
      • isLast

        public boolean isLast()
                       throws SQLException
        Returns whether the cursor is on the last row of this ResultSet object. Note: Calling the method isLast may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.

        This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.

        Note: Support for the isLast method is optional for ResultSets with a result set type of TYPE_FORWARD_ONLY
        Specified by:
        isLast in interface ResultSet
        Returns:
        true if the cursor is on the last row; false otherwise
        Throws:
        SQLException - if a database access error occurs or this method is called on a closed result set
        Since:
        1.2
      • first

        public boolean first()
                      throws SQLException
        Moves the cursor to the first row in this ResultSet object.

        This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.

        Specified by:
        first in interface ResultSet
        Returns:
        true if the cursor is on a valid row; false if there are no rows in the result set
        Throws:
        SQLException - if a database access error occurs; this method is called on a closed result set or the result set type is TYPE_FORWARD_ONLY
        Since:
        1.2
      • last

        public boolean last()
                     throws SQLException
        Moves the cursor to the last row in this ResultSet object. This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.
        Specified by:
        last in interface ResultSet
        Returns:
        true if the cursor is on a valid row; false if there are no rows in the result set
        Throws:
        SQLException - if a database access error occurs; this method is called on a closed result set or the result set type is TYPE_FORWARD_ONLY
        Since:
        1.2
      • absolute

        public boolean absolute​(int row)
                         throws SQLException
        Moves the cursor to the given row number in this ResultSet object.

        This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.

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

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

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

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

        Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().

        Specified by:
        absolute in interface ResultSet
        Parameters:
        row - the number of the row to which the cursor should move. A value of zero indicates that the cursor will be positioned before the first row; a positive number indicates the row number counting from the beginning of the result set; a negative number indicates the row number counting from the end of the result set
        Returns:
        true if the cursor is moved to a position in this ResultSet object; false if the cursor is before the first row or after the last row
        Throws:
        SQLException - if a database access error occurs; this method is called on a closed result set or the result set type is TYPE_FORWARD_ONLY
        Since:
        1.2
      • previous

        public boolean previous()
                         throws SQLException
        Moves the cursor to the previous row in this ResultSet object. This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.
        Specified by:
        previous in interface ResultSet
        Returns:
        true if the cursor is now positioned on a valid row; false if the cursor is positioned before the first row
        Throws:
        SQLException - if a database access error occurs; this method is called on a closed result set or the result set type is TYPE_FORWARD_ONLY
        Since:
        1.2
      • getGeometry

        public Geometry getGeometry​(int columnIndex)
                             throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geometry object in the Java programming language.
        Specified by:
        getGeometry in interface ISQLServerResultSet
        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:
        SQLServerException - when an error occurs
      • getGeometry

        public Geometry getGeometry​(String columnName)
                             throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geometry object in the Java programming language.
        Specified by:
        getGeometry in interface ISQLServerResultSet
        Parameters:
        columnName - the name of the column
        Returns:
        the column value; if the value is SQL NULL, the value returned is null
        Throws:
        SQLServerException - when an error occurs
      • getGeography

        public Geography getGeography​(int columnIndex)
                               throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geography object in the Java programming language.
        Specified by:
        getGeography in interface ISQLServerResultSet
        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:
        SQLServerException - when an error occurs
      • getGeography

        public Geography getGeography​(String columnName)
                               throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geography object in the Java programming language.
        Specified by:
        getGeography in interface ISQLServerResultSet
        Parameters:
        columnName - the name of the column
        Returns:
        the column value; if the value is SQL NULL, the value returned is null
        Throws:
        SQLServerException - when an error occurs
      • getUniqueIdentifier

        public String getUniqueIdentifier​(int columnIndex)
                                   throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a String object in the Java programming language.
        Specified by:
        getUniqueIdentifier in interface ISQLServerResultSet
        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:
        SQLServerException - when an error occurs
      • getUniqueIdentifier

        public String getUniqueIdentifier​(String columnLabel)
                                   throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a String object in the Java programming language.
        Specified by:
        getUniqueIdentifier in interface ISQLServerResultSet
        Parameters:
        columnLabel - the name of the column
        Returns:
        the column value; if the value is SQL NULL, the value returned is null
        Throws:
        SQLServerException - when an error occurs
      • getDateTime

        public Timestamp getDateTime​(int columnIndex)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
        Specified by:
        getDateTime in interface ISQLServerResultSet
        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:
        SQLServerException - when an error occurs
      • getDateTime

        public Timestamp getDateTime​(String columnName)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
        Specified by:
        getDateTime in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        Returns:
        the column value; if the value is SQL NULL, the value returned is null
        Throws:
        SQLServerException - If any errors occur.
      • getDateTime

        public Timestamp getDateTime​(int columnIndex,
                                     Calendar cal)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.
        Specified by:
        getDateTime in interface ISQLServerResultSet
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        cal - the java.util.Calendar object to use in constructing the dateTime
        Returns:
        the column value; if the value is SQL NULL, the value returned is null
        Throws:
        SQLServerException - If any errors occur.
      • getDateTime

        public Timestamp getDateTime​(String colName,
                                     Calendar cal)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.
        Specified by:
        getDateTime in interface ISQLServerResultSet
        Parameters:
        colName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        cal - the java.util.Calendar object to use in constructing the dateTime
        Returns:
        the column value; if the value is SQL NULL, the value returned is null
        Throws:
        SQLServerException - If any errors occur.
      • getSmallDateTime

        public Timestamp getSmallDateTime​(int columnIndex)
                                   throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
        Specified by:
        getSmallDateTime in interface ISQLServerResultSet
        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:
        SQLServerException - when an error occurs
      • getSmallDateTime

        public Timestamp getSmallDateTime​(String columnName)
                                   throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
        Specified by:
        getSmallDateTime in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of a column.
        Returns:
        the column value; if the value is SQL NULL, the value returned is null
        Throws:
        SQLServerException - If any errors occur.
      • getSmallDateTime

        public Timestamp getSmallDateTime​(int columnIndex,
                                          Calendar cal)
                                   throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
        Specified by:
        getSmallDateTime in interface ISQLServerResultSet
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        cal - the java.util.Calendar object to use in constructing the smalldateTime
        Returns:
        the column value; if the value is SQL NULL, the value returned is null
        Throws:
        SQLServerException - If any errors occur.
      • getSmallDateTime

        public Timestamp getSmallDateTime​(String colName,
                                          Calendar cal)
                                   throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
        Specified by:
        getSmallDateTime in interface ISQLServerResultSet
        Parameters:
        colName - The name of a column
        cal - the java.util.Calendar object to use in constructing the smalldateTime
        Returns:
        the column value; if the value is SQL NULL, the value returned is null
        Throws:
        SQLServerException - If any errors occur.
      • getMoney

        public BigDecimal getMoney​(int columnIndex)
                            throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Returns the value of the column specified as a java.math.BigDecimal object.
        Specified by:
        getMoney in interface ISQLServerResultSet
        Parameters:
        columnIndex - The zero-based ordinal of a column.
        Returns:
        the column value; if the value is SQL NULL, the value returned is null
        Throws:
        SQLServerException - when an error occurs
      • updateBoolean

        public void updateBoolean​(int index,
                                  boolean x,
                                  boolean forceEncrypt)
                           throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a boolean value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateBoolean in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateByte

        public void updateByte​(int index,
                               byte x,
                               boolean forceEncrypt)
                        throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a byte value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateByte in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateShort

        public void updateShort​(int index,
                                short x,
                                boolean forceEncrypt)
                         throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a short value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateShort in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateInt

        public void updateInt​(int index,
                              int x,
                              boolean forceEncrypt)
                       throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with an int value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateInt in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateLong

        public void updateLong​(int index,
                               long x,
                               boolean forceEncrypt)
                        throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a long value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateLong in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateFloat

        public void updateFloat​(int index,
                                float x,
                                boolean forceEncrypt)
                         throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a float value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateFloat in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateDouble

        public void updateDouble​(int index,
                                 double x,
                                 boolean forceEncrypt)
                          throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a double value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateDouble in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateMoney

        public void updateMoney​(int index,
                                BigDecimal x)
                         throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a money 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.
        Specified by:
        updateMoney in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        Throws:
        SQLServerException - when an error occurs
      • updateMoney

        public void updateMoney​(int index,
                                BigDecimal x,
                                boolean forceEncrypt)
                         throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a money 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.
        Specified by:
        updateMoney in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateMoney

        public void updateMoney​(String columnName,
                                BigDecimal x)
                         throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a money 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.
        Specified by:
        updateMoney in interface ISQLServerResultSet
        Parameters:
        columnName - the column name
        x - the new column value
        Throws:
        SQLServerException - If any errors occur.
      • updateMoney

        public void updateMoney​(String columnName,
                                BigDecimal x,
                                boolean forceEncrypt)
                         throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a money 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.
        Specified by:
        updateMoney in interface ISQLServerResultSet
        Parameters:
        columnName - the column name
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateSmallMoney

        public void updateSmallMoney​(int index,
                                     BigDecimal x)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a smallmoney 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.
        Specified by:
        updateSmallMoney in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        Throws:
        SQLServerException - when an error occurs
      • updateSmallMoney

        public void updateSmallMoney​(int index,
                                     BigDecimal x,
                                     boolean forceEncrypt)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a smallmoney 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.
        Specified by:
        updateSmallMoney in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateSmallMoney

        public void updateSmallMoney​(String columnName,
                                     BigDecimal x)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a smallmoney 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.
        Specified by:
        updateSmallMoney in interface ISQLServerResultSet
        Parameters:
        columnName - the column name
        x - the new column value
        Throws:
        SQLServerException - If any errors occur.
      • updateSmallMoney

        public void updateSmallMoney​(String columnName,
                                     BigDecimal x,
                                     boolean forceEncrypt)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a smallmoney 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.
        Specified by:
        updateSmallMoney in interface ISQLServerResultSet
        Parameters:
        columnName - the column name
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateBigDecimal

        public void updateBigDecimal​(int index,
                                     BigDecimal x,
                                     Integer precision,
                                     Integer scale)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.math.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateBigDecimal in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        precision - the precision of the column
        scale - the scale of the column
        Throws:
        SQLServerException - when an error occurs
      • updateBigDecimal

        public void updateBigDecimal​(int index,
                                     BigDecimal x,
                                     Integer precision,
                                     Integer scale,
                                     boolean forceEncrypt)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.math.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateBigDecimal in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        precision - the precision of the column
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateString

        public void updateString​(int columnIndex,
                                 String stringValue,
                                 boolean forceEncrypt)
                          throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a String value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateString in interface ISQLServerResultSet
        Parameters:
        columnIndex - the first column is 1, the second is 2, ...
        stringValue - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateNString

        public void updateNString​(int columnIndex,
                                  String nString,
                                  boolean forceEncrypt)
                           throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        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.
        Specified by:
        updateNString in interface ISQLServerResultSet
        Parameters:
        columnIndex - the first column is 1, the second 2, ...
        nString - the value for the column to be updated
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateNString

        public void updateNString​(String columnLabel,
                                  String nString,
                                  boolean forceEncrypt)
                           throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        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.
        Specified by:
        updateNString in interface ISQLServerResultSet
        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
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateBytes

        public void updateBytes​(int index,
                                byte[] x,
                                boolean forceEncrypt)
                         throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a byte array value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateBytes in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateDate

        public void updateDate​(int index,
                               Date x,
                               boolean forceEncrypt)
                        throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Date value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateDate in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateTime

        public void updateTime​(int index,
                               Time x,
                               Integer scale)
                        throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Time value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateTime in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        scale - the scale of the column
        Throws:
        SQLServerException - when an error occurs
      • updateTime

        public void updateTime​(int index,
                               Time x,
                               Integer scale,
                               boolean forceEncrypt)
                        throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Time value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateTime in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateTimestamp

        public void updateTimestamp​(int index,
                                    Timestamp x,
                                    int scale)
                             throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateTimestamp in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        scale - the scale of the column
        Throws:
        SQLServerException - when an error occurs
      • updateTimestamp

        public void updateTimestamp​(int index,
                                    Timestamp x,
                                    int scale,
                                    boolean forceEncrypt)
                             throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateTimestamp in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateDateTime

        public void updateDateTime​(int index,
                                   Timestamp x)
                            throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateDateTime in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        Throws:
        SQLServerException - when an error occurs
      • updateDateTime

        public void updateDateTime​(int index,
                                   Timestamp x,
                                   Integer scale)
                            throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateDateTime in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        scale - the scale of the column
        Throws:
        SQLServerException - when an error occurs
      • updateDateTime

        public void updateDateTime​(int index,
                                   Timestamp x,
                                   Integer scale,
                                   boolean forceEncrypt)
                            throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateDateTime in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateSmallDateTime

        public void updateSmallDateTime​(int index,
                                        Timestamp x)
                                 throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateSmallDateTime in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        Throws:
        SQLServerException - when an error occurs
      • updateSmallDateTime

        public void updateSmallDateTime​(int index,
                                        Timestamp x,
                                        Integer scale)
                                 throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateSmallDateTime in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        scale - the scale of the column
        Throws:
        SQLServerException - when an error occurs
      • updateSmallDateTime

        public void updateSmallDateTime​(int index,
                                        Timestamp x,
                                        Integer scale,
                                        boolean forceEncrypt)
                                 throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateSmallDateTime in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateDateTimeOffset

        public void updateDateTimeOffset​(int index,
                                         DateTimeOffset x,
                                         Integer scale,
                                         boolean forceEncrypt)
                                  throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.
        Specified by:
        updateDateTimeOffset in interface ISQLServerResultSet
        Parameters:
        index - The zero-based ordinal of a column.
        x - A DateTimeOffset Class object.
        scale - scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateUniqueIdentifier

        public void updateUniqueIdentifier​(int index,
                                           String x)
                                    throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a String value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateUniqueIdentifier in interface ISQLServerResultSet
        Parameters:
        index - The zero-based ordinal of a column.
        x - the new column value
        Throws:
        SQLServerException - when an error occurs
      • updateUniqueIdentifier

        public void updateUniqueIdentifier​(int index,
                                           String x,
                                           boolean forceEncrypt)
                                    throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a String value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateUniqueIdentifier in interface ISQLServerResultSet
        Parameters:
        index - The zero-based ordinal of a column.
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateObject

        public void updateObject​(int index,
                                 Object x,
                                 int precision,
                                 int scale)
                          throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateObject in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        precision - the precision of the column
        scale - the scale of the column
        Throws:
        SQLServerException - when an error occurs
      • updateObject

        public void updateObject​(int index,
                                 Object x,
                                 int precision,
                                 int scale,
                                 boolean forceEncrypt)
                          throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateObject in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        precision - the precision of the column
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateBoolean

        public void updateBoolean​(String columnName,
                                  boolean x,
                                  boolean forceEncrypt)
                           throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a boolean value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateBoolean in interface ISQLServerResultSet
        Parameters:
        columnName - the name of the column
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - when an error occurs
      • updateByte

        public void updateByte​(String columnName,
                               byte x,
                               boolean forceEncrypt)
                        throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a byte value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateByte in interface ISQLServerResultSet
        Parameters:
        columnName - the name of the column
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateShort

        public void updateShort​(String columnName,
                                short x,
                                boolean forceEncrypt)
                         throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a short value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateShort in interface ISQLServerResultSet
        Parameters:
        columnName - the name of the column
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateInt

        public void updateInt​(String columnName,
                              int x,
                              boolean forceEncrypt)
                       throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with an int value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateInt in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateLong

        public void updateLong​(String columnName,
                               long x,
                               boolean forceEncrypt)
                        throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a long value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateLong in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateFloat

        public void updateFloat​(String columnName,
                                float x,
                                boolean forceEncrypt)
                         throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a float value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateFloat in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateDouble

        public void updateDouble​(String columnName,
                                 double x,
                                 boolean forceEncrypt)
                          throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a double value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateDouble in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateBigDecimal

        public void updateBigDecimal​(String columnName,
                                     BigDecimal x,
                                     boolean forceEncrypt)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateBigDecimal in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateBigDecimal

        public void updateBigDecimal​(String columnName,
                                     BigDecimal x,
                                     Integer precision,
                                     Integer scale)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateBigDecimal in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        x - BigDecimal value
        precision - the precision of the column
        scale - the scale of the column
        Throws:
        SQLServerException - If any errors occur.
      • updateBigDecimal

        public void updateBigDecimal​(String columnName,
                                     BigDecimal x,
                                     Integer precision,
                                     Integer scale,
                                     boolean forceEncrypt)
                              throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateBigDecimal in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        x - BigDecimal value
        precision - the precision of the column
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateString

        public void updateString​(String columnName,
                                 String x,
                                 boolean forceEncrypt)
                          throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a String value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateString in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateBytes

        public void updateBytes​(String columnName,
                                byte[] x,
                                boolean forceEncrypt)
                         throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a byte array value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateBytes in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateDate

        public void updateDate​(String columnName,
                               Date x,
                               boolean forceEncrypt)
                        throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Date value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateDate in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateTime

        public void updateTime​(String columnName,
                               Time x,
                               int scale)
                        throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Time value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateTime in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        scale - the scale of the column
        Throws:
        SQLServerException - If any errors occur.
      • updateTime

        public void updateTime​(String columnName,
                               Time x,
                               int scale,
                               boolean forceEncrypt)
                        throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Time value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateTime in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateTimestamp

        public void updateTimestamp​(String columnName,
                                    Timestamp x,
                                    int scale)
                             throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateTimestamp in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        scale - the scale of the column
        Throws:
        SQLServerException - If any errors occur.
      • updateTimestamp

        public void updateTimestamp​(String columnName,
                                    Timestamp x,
                                    int scale,
                                    boolean forceEncrypt)
                             throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateTimestamp in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateDateTime

        public void updateDateTime​(String columnName,
                                   Timestamp x)
                            throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateDateTime in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        Throws:
        SQLServerException - If any errors occur.
      • updateDateTime

        public void updateDateTime​(String columnName,
                                   Timestamp x,
                                   int scale)
                            throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateDateTime in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        scale - the scale of the column
        Throws:
        SQLServerException - If any errors occur.
      • updateDateTime

        public void updateDateTime​(String columnName,
                                   Timestamp x,
                                   int scale,
                                   boolean forceEncrypt)
                            throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateDateTime in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateSmallDateTime

        public void updateSmallDateTime​(String columnName,
                                        Timestamp x)
                                 throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateSmallDateTime in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        Throws:
        SQLServerException - If any errors occur.
      • updateSmallDateTime

        public void updateSmallDateTime​(String columnName,
                                        Timestamp x,
                                        int scale)
                                 throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateSmallDateTime in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        scale - the scale of the column
        Throws:
        SQLServerException - If any errors occur.
      • updateSmallDateTime

        public void updateSmallDateTime​(String columnName,
                                        Timestamp x,
                                        int scale,
                                        boolean forceEncrypt)
                                 throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateSmallDateTime in interface ISQLServerResultSet
        Parameters:
        columnName - is the name of the column
        x - the new column value
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateDateTimeOffset

        public void updateDateTimeOffset​(String columnName,
                                         DateTimeOffset x,
                                         int scale,
                                         boolean forceEncrypt)
                                  throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the value of the column specified to the DateTimeOffset Class value, given a column name.
        Specified by:
        updateDateTimeOffset in interface ISQLServerResultSet
        Parameters:
        columnName - The name of a column.
        x - A DateTimeOffset Class object.
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateUniqueIdentifier

        public void updateUniqueIdentifier​(String columnName,
                                           String x)
                                    throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a Stringvalue. 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.
        Specified by:
        updateUniqueIdentifier in interface ISQLServerResultSet
        Parameters:
        columnName - The name of a column.
        x - the new column value
        Throws:
        SQLServerException - If any errors occur.
      • updateUniqueIdentifier

        public void updateUniqueIdentifier​(String columnName,
                                           String x,
                                           boolean forceEncrypt)
                                    throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with a Stringvalue. 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.
        Specified by:
        updateUniqueIdentifier in interface ISQLServerResultSet
        Parameters:
        columnName - The name of a column.
        x - the new column value
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateObject

        public void updateObject​(String columnName,
                                 Object x,
                                 int precision,
                                 int scale)
                          throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateObject in interface ISQLServerResultSet
        Parameters:
        columnName - The name of a column.
        x - the new column value
        precision - the precision of the column
        scale - the scale of the column
        Throws:
        SQLServerException - If any errors occur.
      • updateObject

        public void updateObject​(String columnName,
                                 Object x,
                                 int precision,
                                 int scale,
                                 boolean forceEncrypt)
                          throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Specified by:
        updateObject in interface ISQLServerResultSet
        Parameters:
        columnName - The name of a column.
        x - the new column value
        precision - the precision of the column
        scale - the scale of the column
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateObject

        public void updateObject​(int index,
                                 Object obj,
                                 SQLType targetSqlType,
                                 int scale,
                                 boolean forceEncrypt)
                          throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. If the second argument is an InputStream then the stream must contain the number of bytes specified by scaleOrLength. If the second argument is a Reader then the reader must contain the number of characters specified by scaleOrLength. If these conditions are not true the driver will generate a SQLServerException when the statement is executed. The default implementation will throw SQLFeatureNotSupportedException
        Specified by:
        updateObject in interface ISQLServerResultSet
        Parameters:
        index - the first column is 1, the second is 2, ...
        obj - the new column value
        targetSqlType - the SQL type to be sent to the database
        scale - 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.
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement.If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.
      • updateObject

        public void updateObject​(String columnName,
                                 Object obj,
                                 SQLType targetSqlType,
                                 int scale,
                                 boolean forceEncrypt)
                          throws SQLServerException
        Description copied from interface: ISQLServerResultSet
        Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. If the second argument is an InputStream then the stream must contain the number of bytes specified by scaleOrLength. If the second argument is a Reader then the reader must contain the number of characters specified by scaleOrLength. If these conditions are not true the driver will generate a SQLServerException when the statement is executed. The default implementation will throw SQLFeatureNotSupportedException.
        Specified by:
        updateObject in interface ISQLServerResultSet
        Parameters:
        columnName - 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
        obj - the new column value
        targetSqlType - the SQL type to be sent to the database
        scale - 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.
        forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement.If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.
        Throws:
        SQLServerException - If any errors occur.