Interface ISQLServerResultSet

  • All Superinterfaces:
    java.lang.AutoCloseable, java.sql.ResultSet, java.sql.Wrapper
    All Known Implementing Classes:
    SQLServerResultSet

    public interface ISQLServerResultSet
    extends java.sql.ResultSet
    Provides an interface to the SQLServerResultSet class.
    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      java.sql.Timestamp getDateTime​(int columnIndex)
      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.
      java.sql.Timestamp getDateTime​(int columnIndex, java.util.Calendar cal)
      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.
      java.sql.Timestamp getDateTime​(java.lang.String columnName)
      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.
      java.sql.Timestamp getDateTime​(java.lang.String colName, java.util.Calendar cal)
      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.
      DateTimeOffset getDateTimeOffset​(int columnIndex)
      Returns the value of the designated column as a microsoft.sql.DateTimeOffset object, given a zero-based column ordinal.
      DateTimeOffset getDateTimeOffset​(java.lang.String columnName)
      Returns the value of the column specified as a microsoft.sql.DateTimeOffset object, given a column name.
      Geography getGeography​(int columnIndex)
      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.
      Geography getGeography​(java.lang.String columnName)
      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.
      Geometry getGeometry​(int columnIndex)
      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.
      Geometry getGeometry​(java.lang.String columnName)
      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.
      java.math.BigDecimal getMoney​(int columnIndex)
      Returns the value of the column specified as a java.math.BigDecimal object.
      java.math.BigDecimal getMoney​(java.lang.String columnName)
      Returns the value of the column specified as a java.math.BigDecimal object.
      SensitivityClassification getSensitivityClassification()
      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.
      java.sql.Timestamp getSmallDateTime​(int columnIndex)
      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.
      java.sql.Timestamp getSmallDateTime​(int columnIndex, java.util.Calendar cal)
      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.
      java.sql.Timestamp getSmallDateTime​(java.lang.String columnName)
      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.
      java.sql.Timestamp getSmallDateTime​(java.lang.String colName, java.util.Calendar cal)
      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.
      java.math.BigDecimal getSmallMoney​(int columnIndex)
      Returns the value of the column specified as a java.math.BigDecimal object.
      java.math.BigDecimal getSmallMoney​(java.lang.String columnName)
      Returns the value of the column specified as a java.math.BigDecimal object.
      java.lang.String getUniqueIdentifier​(int columnIndex)
      Returns the value of the designated column in the current row of this ResultSet object as a String object in the Java programming language.
      java.lang.String getUniqueIdentifier​(java.lang.String columnLabel)
      Returns the value of the designated column in the current row of this ResultSet object as a String object in the Java programming language.
      void updateBigDecimal​(int index, java.math.BigDecimal x, java.lang.Integer precision, java.lang.Integer scale)
      Updates the designated column with a java.math.BigDecimal value.
      void updateBigDecimal​(int index, java.math.BigDecimal x, java.lang.Integer precision, java.lang.Integer scale, boolean forceEncrypt)
      Updates the designated column with a java.math.BigDecimal value.
      void updateBigDecimal​(java.lang.String columnName, java.math.BigDecimal x, boolean forceEncrypt)
      Updates the designated column with a java.sql.BigDecimal value.
      void updateBigDecimal​(java.lang.String columnName, java.math.BigDecimal x, java.lang.Integer precision, java.lang.Integer scale)
      Updates the designated column with a java.sql.BigDecimal value.
      void updateBigDecimal​(java.lang.String columnName, java.math.BigDecimal x, java.lang.Integer precision, java.lang.Integer scale, boolean forceEncrypt)
      Updates the designated column with a java.sql.BigDecimal value.
      void updateBoolean​(int index, boolean x, boolean forceEncrypt)
      Updates the designated column with a boolean value.
      void updateBoolean​(java.lang.String columnName, boolean x, boolean forceEncrypt)
      Updates the designated column with a boolean value.
      void updateByte​(int index, byte x, boolean forceEncrypt)
      Updates the designated column with a byte value.
      void updateByte​(java.lang.String columnName, byte x, boolean forceEncrypt)
      Updates the designated column with a byte value.
      void updateBytes​(int index, byte[] x, boolean forceEncrypt)
      Updates the designated column with a byte array value.
      void updateBytes​(java.lang.String columnName, byte[] x, boolean forceEncrypt)
      Updates the designated column with a byte array value.
      void updateDate​(int index, java.sql.Date x, boolean forceEncrypt)
      Updates the designated column with a java.sql.Date value.
      void updateDate​(java.lang.String columnName, java.sql.Date x, boolean forceEncrypt)
      Updates the designated column with a java.sql.Date value.
      void updateDateTime​(int index, java.sql.Timestamp x)
      Updates the designated column with a java.sql.Timestamp value.
      void updateDateTime​(int index, java.sql.Timestamp x, java.lang.Integer scale)
      Updates the designated column with a java.sql.Timestamp value.
      void updateDateTime​(int index, java.sql.Timestamp x, java.lang.Integer scale, boolean forceEncrypt)
      Updates the designated column with a java.sql.Timestamp value.
      void updateDateTime​(java.lang.String columnName, java.sql.Timestamp x)
      Updates the designated column with a java.sql.Timestamp value.
      void updateDateTime​(java.lang.String columnName, java.sql.Timestamp x, int scale)
      Updates the designated column with a java.sql.Timestamp value.
      void updateDateTime​(java.lang.String columnName, java.sql.Timestamp x, int scale, boolean forceEncrypt)
      Updates the designated column with a java.sql.Timestamp value.
      void updateDateTimeOffset​(int index, DateTimeOffset x)
      Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.
      void updateDateTimeOffset​(int index, DateTimeOffset x, java.lang.Integer scale)
      Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.
      void updateDateTimeOffset​(int index, DateTimeOffset x, java.lang.Integer scale, boolean forceEncrypt)
      Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.
      void updateDateTimeOffset​(java.lang.String columnName, DateTimeOffset x)
      Updates the value of the column specified to the DateTimeOffset Class value, given a column name.
      void updateDateTimeOffset​(java.lang.String columnName, DateTimeOffset x, int scale)
      Updates the value of the column specified to the DateTimeOffset Class value, given a column name.
      void updateDateTimeOffset​(java.lang.String columnName, DateTimeOffset x, int scale, boolean forceEncrypt)
      Updates the value of the column specified to the DateTimeOffset Class value, given a column name.
      void updateDouble​(int index, double x, boolean forceEncrypt)
      Updates the designated column with a double value.
      void updateDouble​(java.lang.String columnName, double x, boolean forceEncrypt)
      Updates the designated column with a double value.
      void updateFloat​(int index, float x, boolean forceEncrypt)
      Updates the designated column with a float value.
      void updateFloat​(java.lang.String columnName, float x, boolean forceEncrypt)
      Updates the designated column with a float value.
      void updateInt​(int index, int x, boolean forceEncrypt)
      Updates the designated column with an int value.
      void updateInt​(java.lang.String columnName, int x, boolean forceEncrypt)
      Updates the designated column with an int value.
      void updateLong​(int index, long x, boolean forceEncrypt)
      Updates the designated column with a long value.
      void updateLong​(java.lang.String columnName, long x, boolean forceEncrypt)
      Updates the designated column with a long value.
      void updateMoney​(int index, java.math.BigDecimal x)
      Updates the designated column with a money value.
      void updateMoney​(int index, java.math.BigDecimal x, boolean forceEncrypt)
      Updates the designated column with a money value.
      void updateMoney​(java.lang.String columnName, java.math.BigDecimal x)
      Updates the designated column with a money value.
      void updateMoney​(java.lang.String columnName, java.math.BigDecimal x, boolean forceEncrypt)
      Updates the designated column with a money value.
      void updateNString​(int columnIndex, java.lang.String nString, boolean forceEncrypt)
      Updates the designated column with a String value.
      void updateNString​(java.lang.String columnLabel, java.lang.String nString, boolean forceEncrypt)
      Updates the designated column with a String value.
      void updateObject​(int index, java.lang.Object x, int precision, int scale)
      Updates the designated column with an Object value.
      void updateObject​(int index, java.lang.Object x, int precision, int scale, boolean forceEncrypt)
      Updates the designated column with an Object value.
      void updateObject​(int index, java.lang.Object obj, java.sql.SQLType targetSqlType, int scale, boolean forceEncrypt)
      Updates the designated column with an Object value.
      void updateObject​(java.lang.String columnName, java.lang.Object x, int precision, int scale)
      Updates the designated column with an Object value.
      void updateObject​(java.lang.String columnName, java.lang.Object x, int precision, int scale, boolean forceEncrypt)
      Updates the designated column with an Object value.
      void updateObject​(java.lang.String columnName, java.lang.Object obj, java.sql.SQLType targetSqlType, int scale, boolean forceEncrypt)
      Updates the designated column with an Object value.
      void updateShort​(int index, short x, boolean forceEncrypt)
      Updates the designated column with a short value.
      void updateShort​(java.lang.String columnName, short x, boolean forceEncrypt)
      Updates the designated column with a short value.
      void updateSmallDateTime​(int index, java.sql.Timestamp x)
      Updates the designated column with a java.sql.Timestamp value.
      void updateSmallDateTime​(int index, java.sql.Timestamp x, java.lang.Integer scale)
      Updates the designated column with a java.sql.Timestamp value.
      void updateSmallDateTime​(int index, java.sql.Timestamp x, java.lang.Integer scale, boolean forceEncrypt)
      Updates the designated column with a java.sql.Timestamp value.
      void updateSmallDateTime​(java.lang.String columnName, java.sql.Timestamp x)
      Updates the designated column with a java.sql.Timestamp value.
      void updateSmallDateTime​(java.lang.String columnName, java.sql.Timestamp x, int scale)
      Updates the designated column with a java.sql.Timestamp value.
      void updateSmallDateTime​(java.lang.String columnName, java.sql.Timestamp x, int scale, boolean forceEncrypt)
      Updates the designated column with a java.sql.Timestamp value.
      void updateSmallMoney​(int index, java.math.BigDecimal x)
      Updates the designated column with a smallmoney value.
      void updateSmallMoney​(int index, java.math.BigDecimal x, boolean forceEncrypt)
      Updates the designated column with a smallmoney value.
      void updateSmallMoney​(java.lang.String columnName, java.math.BigDecimal x)
      Updates the designated column with a smallmoney value.
      void updateSmallMoney​(java.lang.String columnName, java.math.BigDecimal x, boolean forceEncrypt)
      Updates the designated column with a smallmoney value.
      void updateString​(int columnIndex, java.lang.String stringValue, boolean forceEncrypt)
      Updates the designated column with a String value.
      void updateString​(java.lang.String columnName, java.lang.String x, boolean forceEncrypt)
      Updates the designated column with a String value.
      void updateTime​(int index, java.sql.Time x, java.lang.Integer scale)
      Updates the designated column with a java.sql.Time value.
      void updateTime​(int index, java.sql.Time x, java.lang.Integer scale, boolean forceEncrypt)
      Updates the designated column with a java.sql.Time value.
      void updateTime​(java.lang.String columnName, java.sql.Time x, int scale)
      Updates the designated column with a java.sql.Time value.
      void updateTime​(java.lang.String columnName, java.sql.Time x, int scale, boolean forceEncrypt)
      Updates the designated column with a java.sql.Time value.
      void updateTimestamp​(int index, java.sql.Timestamp x, int scale)
      Updates the designated column with a java.sql.Timestamp value.
      void updateTimestamp​(int index, java.sql.Timestamp x, int scale, boolean forceEncrypt)
      Updates the designated column with a java.sql.Timestamp value.
      void updateTimestamp​(java.lang.String columnName, java.sql.Timestamp x, int scale)
      Updates the designated column with a java.sql.Timestamp value.
      void updateTimestamp​(java.lang.String columnName, java.sql.Timestamp x, int scale, boolean forceEncrypt)
      Updates the designated column with a java.sql.Timestamp value.
      void updateUniqueIdentifier​(int index, java.lang.String x)
      Updates the designated column with a String value.
      void updateUniqueIdentifier​(int index, java.lang.String x, boolean forceEncrypt)
      Updates the designated column with a String value.
      void updateUniqueIdentifier​(java.lang.String columnName, java.lang.String x)
      Updates the designated column with a Stringvalue.
      void updateUniqueIdentifier​(java.lang.String columnName, java.lang.String x, boolean forceEncrypt)
      Updates the designated column with a Stringvalue.
      • Methods inherited from interface java.sql.ResultSet

        absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull
      • Methods inherited from interface java.sql.Wrapper

        isWrapperFor, unwrap
    • Method Detail

      • getGeometry

        Geometry getGeometry​(int columnIndex)
                      throws SQLServerException
        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.
        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

        Geometry getGeometry​(java.lang.String columnName)
                      throws SQLServerException
        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.
        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

        Geography getGeography​(int columnIndex)
                        throws SQLServerException
        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.
        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

        Geography getGeography​(java.lang.String columnName)
                        throws SQLServerException
        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.
        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

        java.lang.String getUniqueIdentifier​(int columnIndex)
                                      throws SQLServerException
        Returns the value of the designated column in the current row of this ResultSet object as a String object in the Java programming language.
        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

        java.lang.String getUniqueIdentifier​(java.lang.String columnLabel)
                                      throws SQLServerException
        Returns the value of the designated column in the current row of this ResultSet object as a String object in the Java programming language.
        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

        java.sql.Timestamp getDateTime​(int columnIndex)
                                throws SQLServerException
        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.
        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

        java.sql.Timestamp getDateTime​(java.lang.String columnName)
                                throws SQLServerException
        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.
        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

        java.sql.Timestamp getDateTime​(int columnIndex,
                                       java.util.Calendar cal)
                                throws SQLServerException
        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.
        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

        java.sql.Timestamp getDateTime​(java.lang.String colName,
                                       java.util.Calendar cal)
                                throws SQLServerException
        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.
        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

        java.sql.Timestamp getSmallDateTime​(int columnIndex)
                                     throws SQLServerException
        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.
        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

        java.sql.Timestamp getSmallDateTime​(java.lang.String columnName)
                                     throws SQLServerException
        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.
        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

        java.sql.Timestamp getSmallDateTime​(int columnIndex,
                                            java.util.Calendar cal)
                                     throws SQLServerException
        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.
        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

        java.sql.Timestamp getSmallDateTime​(java.lang.String colName,
                                            java.util.Calendar cal)
                                     throws SQLServerException
        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.
        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.
      • getDateTimeOffset

        DateTimeOffset getDateTimeOffset​(int columnIndex)
                                  throws SQLServerException
        Returns the value of the designated column as a microsoft.sql.DateTimeOffset object, given a zero-based column ordinal.
        Parameters:
        columnIndex - The zero-based ordinal of a column.
        Returns:
        A DateTimeOffset Class object.
        Throws:
        SQLServerException - when an error occurs
      • getDateTimeOffset

        DateTimeOffset getDateTimeOffset​(java.lang.String columnName)
                                  throws SQLServerException
        Returns the value of the column specified as a microsoft.sql.DateTimeOffset object, given a column name.
        Parameters:
        columnName - The name of a column.
        Returns:
        A DateTimeOffset Class object.
        Throws:
        SQLServerException - when an error occurs
      • getMoney

        java.math.BigDecimal getMoney​(int columnIndex)
                               throws SQLServerException
        Returns the value of the column specified as a java.math.BigDecimal object.
        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
      • getMoney

        java.math.BigDecimal getMoney​(java.lang.String columnName)
                               throws SQLServerException
        Returns the value of the column specified as a java.math.BigDecimal object.
        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.
      • getSmallMoney

        java.math.BigDecimal getSmallMoney​(int columnIndex)
                                    throws SQLServerException
        Returns the value of the column specified as a java.math.BigDecimal object.
        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 - If any errors occur.
      • getSmallMoney

        java.math.BigDecimal getSmallMoney​(java.lang.String columnName)
                                    throws SQLServerException
        Returns the value of the column specified as a java.math.BigDecimal object.
        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.
      • updateDateTimeOffset

        void updateDateTimeOffset​(int index,
                                  DateTimeOffset x)
                           throws SQLServerException
        Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.
        Parameters:
        index - The zero-based ordinal of a column.
        x - A DateTimeOffset Class object.
        Throws:
        SQLServerException - when an error occurs
      • updateDateTimeOffset

        void updateDateTimeOffset​(java.lang.String columnName,
                                  DateTimeOffset x)
                           throws SQLServerException
        Updates the value of the column specified to the DateTimeOffset Class value, given a column name.
        Parameters:
        columnName - The name of a column.
        x - A DateTimeOffset Class object.
        Throws:
        SQLServerException - when an error occurs
      • updateObject

        void updateObject​(int index,
                          java.lang.Object x,
                          int precision,
                          int scale)
                   throws SQLServerException
        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.
        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

        void updateObject​(int index,
                          java.lang.Object obj,
                          java.sql.SQLType targetSqlType,
                          int scale,
                          boolean forceEncrypt)
                   throws SQLServerException
        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
        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

        void updateObject​(java.lang.String columnName,
                          java.lang.Object obj,
                          java.sql.SQLType targetSqlType,
                          int scale,
                          boolean forceEncrypt)
                   throws SQLServerException
        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.
        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.
      • updateBoolean

        void updateBoolean​(int index,
                           boolean x,
                           boolean forceEncrypt)
                    throws SQLServerException
        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.
        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

        void updateByte​(int index,
                        byte x,
                        boolean forceEncrypt)
                 throws SQLServerException
        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.
        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

        void updateShort​(int index,
                         short x,
                         boolean forceEncrypt)
                  throws SQLServerException
        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.
        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

        void updateInt​(int index,
                       int x,
                       boolean forceEncrypt)
                throws SQLServerException
        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.
        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

        void updateLong​(int index,
                        long x,
                        boolean forceEncrypt)
                 throws SQLServerException
        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.
        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

        void updateFloat​(int index,
                         float x,
                         boolean forceEncrypt)
                  throws SQLServerException
        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.
        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

        void updateDouble​(int index,
                          double x,
                          boolean forceEncrypt)
                   throws SQLServerException
        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.
        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

        void updateMoney​(int index,
                         java.math.BigDecimal x)
                  throws SQLServerException
        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.
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        Throws:
        SQLServerException - when an error occurs
      • updateMoney

        void updateMoney​(int index,
                         java.math.BigDecimal x,
                         boolean forceEncrypt)
                  throws SQLServerException
        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.
        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

        void updateMoney​(java.lang.String columnName,
                         java.math.BigDecimal x)
                  throws SQLServerException
        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.
        Parameters:
        columnName - the column name
        x - the new column value
        Throws:
        SQLServerException - If any errors occur.
      • updateMoney

        void updateMoney​(java.lang.String columnName,
                         java.math.BigDecimal x,
                         boolean forceEncrypt)
                  throws SQLServerException
        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.
        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

        void updateSmallMoney​(int index,
                              java.math.BigDecimal x)
                       throws SQLServerException
        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.
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        Throws:
        SQLServerException - when an error occurs
      • updateSmallMoney

        void updateSmallMoney​(int index,
                              java.math.BigDecimal x,
                              boolean forceEncrypt)
                       throws SQLServerException
        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.
        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

        void updateSmallMoney​(java.lang.String columnName,
                              java.math.BigDecimal x)
                       throws SQLServerException
        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.
        Parameters:
        columnName - the column name
        x - the new column value
        Throws:
        SQLServerException - If any errors occur.
      • updateSmallMoney

        void updateSmallMoney​(java.lang.String columnName,
                              java.math.BigDecimal x,
                              boolean forceEncrypt)
                       throws SQLServerException
        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.
        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

        void updateBigDecimal​(int index,
                              java.math.BigDecimal x,
                              java.lang.Integer precision,
                              java.lang.Integer scale)
                       throws SQLServerException
        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.
        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

        void updateBigDecimal​(int index,
                              java.math.BigDecimal x,
                              java.lang.Integer precision,
                              java.lang.Integer scale,
                              boolean forceEncrypt)
                       throws SQLServerException
        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.
        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

        void updateString​(int columnIndex,
                          java.lang.String stringValue,
                          boolean forceEncrypt)
                   throws SQLServerException
        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.
        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

        void updateNString​(int columnIndex,
                           java.lang.String nString,
                           boolean forceEncrypt)
                    throws SQLServerException
        Updates the designated column with a String value. It is intended for use when updating NCHAR,NVARCHAR and LONGNVARCHAR columns. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Parameters:
        columnIndex - the first column is 1, the second 2, ...
        nString - the value for the column to be updated
        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

        void updateNString​(java.lang.String columnLabel,
                           java.lang.String nString,
                           boolean forceEncrypt)
                    throws SQLServerException
        Updates the designated column with a String value. It is intended for use when updating NCHAR,NVARCHAR and LONGNVARCHAR columns. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
        Parameters:
        columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
        nString - the value for the column to be updated
        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

        void updateBytes​(int index,
                         byte[] x,
                         boolean forceEncrypt)
                  throws SQLServerException
        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.
        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

        void updateDate​(int index,
                        java.sql.Date x,
                        boolean forceEncrypt)
                 throws SQLServerException
        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.
        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

        void updateTime​(int index,
                        java.sql.Time x,
                        java.lang.Integer scale)
                 throws SQLServerException
        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.
        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

        void updateTime​(int index,
                        java.sql.Time x,
                        java.lang.Integer scale,
                        boolean forceEncrypt)
                 throws SQLServerException
        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.
        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

        void updateTimestamp​(int index,
                             java.sql.Timestamp x,
                             int scale)
                      throws SQLServerException
        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.
        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

        void updateTimestamp​(int index,
                             java.sql.Timestamp x,
                             int scale,
                             boolean forceEncrypt)
                      throws SQLServerException
        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.
        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

        void updateDateTime​(int index,
                            java.sql.Timestamp x)
                     throws SQLServerException
        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.
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        Throws:
        SQLServerException - when an error occurs
      • updateDateTime

        void updateDateTime​(int index,
                            java.sql.Timestamp x,
                            java.lang.Integer scale)
                     throws SQLServerException
        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.
        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

        void updateDateTime​(int index,
                            java.sql.Timestamp x,
                            java.lang.Integer scale,
                            boolean forceEncrypt)
                     throws SQLServerException
        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.
        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

        void updateSmallDateTime​(int index,
                                 java.sql.Timestamp x)
                          throws SQLServerException
        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.
        Parameters:
        index - the first column is 1, the second is 2, ...
        x - the new column value
        Throws:
        SQLServerException - when an error occurs
      • updateSmallDateTime

        void updateSmallDateTime​(int index,
                                 java.sql.Timestamp x,
                                 java.lang.Integer scale)
                          throws SQLServerException
        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.
        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

        void updateSmallDateTime​(int index,
                                 java.sql.Timestamp x,
                                 java.lang.Integer scale,
                                 boolean forceEncrypt)
                          throws SQLServerException
        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.
        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

        void updateDateTimeOffset​(int index,
                                  DateTimeOffset x,
                                  java.lang.Integer scale)
                           throws SQLServerException
        Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.
        Parameters:
        index - The zero-based ordinal of a column.
        x - A DateTimeOffset Class object.
        scale - scale of the column
        Throws:
        SQLServerException - when an error occurs
      • updateDateTimeOffset

        void updateDateTimeOffset​(int index,
                                  DateTimeOffset x,
                                  java.lang.Integer scale,
                                  boolean forceEncrypt)
                           throws SQLServerException
        Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.
        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

        void updateUniqueIdentifier​(int index,
                                    java.lang.String x)
                             throws SQLServerException
        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.
        Parameters:
        index - The zero-based ordinal of a column.
        x - the new column value
        Throws:
        SQLServerException - when an error occurs
      • updateUniqueIdentifier

        void updateUniqueIdentifier​(int index,
                                    java.lang.String x,
                                    boolean forceEncrypt)
                             throws SQLServerException
        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.
        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

        void updateObject​(int index,
                          java.lang.Object x,
                          int precision,
                          int scale,
                          boolean forceEncrypt)
                   throws SQLServerException
        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.
        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

        void updateBoolean​(java.lang.String columnName,
                           boolean x,
                           boolean forceEncrypt)
                    throws SQLServerException
        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.
        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

        void updateByte​(java.lang.String columnName,
                        byte x,
                        boolean forceEncrypt)
                 throws SQLServerException
        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.
        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

        void updateShort​(java.lang.String columnName,
                         short x,
                         boolean forceEncrypt)
                  throws SQLServerException
        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.
        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

        void updateInt​(java.lang.String columnName,
                       int x,
                       boolean forceEncrypt)
                throws SQLServerException
        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.
        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

        void updateLong​(java.lang.String columnName,
                        long x,
                        boolean forceEncrypt)
                 throws SQLServerException
        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.
        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

        void updateFloat​(java.lang.String columnName,
                         float x,
                         boolean forceEncrypt)
                  throws SQLServerException
        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.
        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

        void updateDouble​(java.lang.String columnName,
                          double x,
                          boolean forceEncrypt)
                   throws SQLServerException
        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.
        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

        void updateBigDecimal​(java.lang.String columnName,
                              java.math.BigDecimal x,
                              boolean forceEncrypt)
                       throws SQLServerException
        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.
        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

        void updateBigDecimal​(java.lang.String columnName,
                              java.math.BigDecimal x,
                              java.lang.Integer precision,
                              java.lang.Integer scale)
                       throws SQLServerException
        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.
        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

        void updateBigDecimal​(java.lang.String columnName,
                              java.math.BigDecimal x,
                              java.lang.Integer precision,
                              java.lang.Integer scale,
                              boolean forceEncrypt)
                       throws SQLServerException
        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.
        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

        void updateString​(java.lang.String columnName,
                          java.lang.String x,
                          boolean forceEncrypt)
                   throws SQLServerException
        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.
        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

        void updateBytes​(java.lang.String columnName,
                         byte[] x,
                         boolean forceEncrypt)
                  throws SQLServerException
        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.
        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

        void updateDate​(java.lang.String columnName,
                        java.sql.Date x,
                        boolean forceEncrypt)
                 throws SQLServerException
        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.
        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

        void updateTime​(java.lang.String columnName,
                        java.sql.Time x,
                        int scale)
                 throws SQLServerException
        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.
        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

        void updateTime​(java.lang.String columnName,
                        java.sql.Time x,
                        int scale,
                        boolean forceEncrypt)
                 throws SQLServerException
        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.
        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

        void updateTimestamp​(java.lang.String columnName,
                             java.sql.Timestamp x,
                             int scale)
                      throws SQLServerException
        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.
        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

        void updateTimestamp​(java.lang.String columnName,
                             java.sql.Timestamp x,
                             int scale,
                             boolean forceEncrypt)
                      throws SQLServerException
        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.
        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

        void updateDateTime​(java.lang.String columnName,
                            java.sql.Timestamp x)
                     throws SQLServerException
        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.
        Parameters:
        columnName - is the name of the column
        x - the new column value
        Throws:
        SQLServerException - If any errors occur.
      • updateDateTime

        void updateDateTime​(java.lang.String columnName,
                            java.sql.Timestamp x,
                            int scale)
                     throws SQLServerException
        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.
        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

        void updateDateTime​(java.lang.String columnName,
                            java.sql.Timestamp x,
                            int scale,
                            boolean forceEncrypt)
                     throws SQLServerException
        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.
        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

        void updateSmallDateTime​(java.lang.String columnName,
                                 java.sql.Timestamp x)
                          throws SQLServerException
        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.
        Parameters:
        columnName - is the name of the column
        x - the new column value
        Throws:
        SQLServerException - If any errors occur.
      • updateSmallDateTime

        void updateSmallDateTime​(java.lang.String columnName,
                                 java.sql.Timestamp x,
                                 int scale)
                          throws SQLServerException
        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.
        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

        void updateSmallDateTime​(java.lang.String columnName,
                                 java.sql.Timestamp x,
                                 int scale,
                                 boolean forceEncrypt)
                          throws SQLServerException
        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.
        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

        void updateDateTimeOffset​(java.lang.String columnName,
                                  DateTimeOffset x,
                                  int scale)
                           throws SQLServerException
        Updates the value of the column specified to the DateTimeOffset Class value, given a column name.
        Parameters:
        columnName - The name of a column.
        x - A DateTimeOffset Class object.
        scale - the scale of the column
        Throws:
        SQLServerException - If any errors occur.
      • updateDateTimeOffset

        void updateDateTimeOffset​(java.lang.String columnName,
                                  DateTimeOffset x,
                                  int scale,
                                  boolean forceEncrypt)
                           throws SQLServerException
        Updates the value of the column specified to the DateTimeOffset Class value, given a column name.
        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

        void updateUniqueIdentifier​(java.lang.String columnName,
                                    java.lang.String x)
                             throws SQLServerException
        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.
        Parameters:
        columnName - The name of a column.
        x - the new column value
        Throws:
        SQLServerException - If any errors occur.
      • updateUniqueIdentifier

        void updateUniqueIdentifier​(java.lang.String columnName,
                                    java.lang.String x,
                                    boolean forceEncrypt)
                             throws SQLServerException
        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.
        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

        void updateObject​(java.lang.String columnName,
                          java.lang.Object x,
                          int precision,
                          int scale)
                   throws SQLServerException
        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.
        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

        void updateObject​(java.lang.String columnName,
                          java.lang.Object x,
                          int precision,
                          int scale,
                          boolean forceEncrypt)
                   throws SQLServerException
        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.
        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.
      • getSensitivityClassification

        SensitivityClassification getSensitivityClassification()
        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.
        Returns:
        SensitivityClassification