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.
  • Field Summary

    Fields
    Modifier and Type Field Description
    static int CONCUR_SS_OPTIMISTIC_CC  
    static int CONCUR_SS_OPTIMISTIC_CCVAL  
    static int CONCUR_SS_SCROLL_LOCKS  
    static int TYPE_SS_DIRECT_FORWARD_ONLY  
    static int TYPE_SS_SCROLL_DYNAMIC  
    static int TYPE_SS_SCROLL_KEYSET  
    static int TYPE_SS_SCROLL_STATIC  
    static int TYPE_SS_SERVER_CURSOR_FORWARD_ONLY  

    Fields inherited from interface java.sql.ResultSet

    CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE
  • Method Summary

    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
  • Field Details

  • Method Details

    • 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