Module com.microsoft.sqlserver.jdbc
Package com.microsoft.sqlserver.jdbc
Interface ISQLServerResultSet
- All Superinterfaces:
AutoCloseable
,ResultSet
,Wrapper
- All Known Implementing Classes:
SQLServerResultSet
Provides an interface to the
SQLServerResultSet
class.-
Field Summary
Modifier and TypeFieldDescriptionstatic final int
CONCUR_UPDATABLEstatic final int
CONCUR_UPDATABLE + 2static final int
CONCUR_UPDATABLE + 1static final int
TYPE_FORWARD_ONLY + 1000static final int
TYPE_SCROLL_SENSITIVE + 1static final int
TYPE_SCROLL_SENSITIVEstatic final int
TYPE_SCROLL_INSENSITIVEstatic final int
TYPE_FORWARD_ONLY + 1001Fields 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 TypeMethodDescriptiongetDateTime
(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.getDateTime
(int columnIndex, 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.getDateTime
(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.getDateTime
(String colName, 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.getDateTimeOffset
(int columnIndex) Returns the value of the designated column as a microsoft.sql.DateTimeOffset object, given a zero-based column ordinal.getDateTimeOffset
(String columnName) Returns the value of the column specified as a microsoft.sql.DateTimeOffset object, given a column name.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.getGeography
(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.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.getGeometry
(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.getMoney
(int columnIndex) Returns the value of the column specified as a java.math.BigDecimal object.Returns the value of the column specified as a java.math.BigDecimal object.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.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.getSmallDateTime
(int columnIndex, 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.getSmallDateTime
(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.getSmallDateTime
(String colName, 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.getSmallMoney
(int columnIndex) Returns the value of the column specified as a java.math.BigDecimal object.getSmallMoney
(String columnName) Returns the value of the column specified as a java.math.BigDecimal object.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.getUniqueIdentifier
(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, BigDecimal x, Integer precision, Integer scale) Updates the designated column with ajava.math.BigDecimal
value.void
updateBigDecimal
(int index, BigDecimal x, Integer precision, Integer scale, boolean forceEncrypt) Updates the designated column with ajava.math.BigDecimal
value.void
updateBigDecimal
(String columnName, BigDecimal x, boolean forceEncrypt) Updates the designated column with ajava.sql.BigDecimal
value.void
updateBigDecimal
(String columnName, BigDecimal x, Integer precision, Integer scale) Updates the designated column with ajava.sql.BigDecimal
value.void
updateBigDecimal
(String columnName, BigDecimal x, Integer precision, Integer scale, boolean forceEncrypt) Updates the designated column with ajava.sql.BigDecimal
value.void
updateBoolean
(int index, boolean x, boolean forceEncrypt) Updates the designated column with aboolean
value.void
updateBoolean
(String columnName, boolean x, boolean forceEncrypt) Updates the designated column with aboolean
value.void
updateByte
(int index, byte x, boolean forceEncrypt) Updates the designated column with abyte
value.void
updateByte
(String columnName, byte x, boolean forceEncrypt) Updates the designated column with abyte
value.void
updateBytes
(int index, byte[] x, boolean forceEncrypt) Updates the designated column with abyte
array value.void
updateBytes
(String columnName, byte[] x, boolean forceEncrypt) Updates the designated column with a byte array value.void
updateDate
(int index, Date x, boolean forceEncrypt) Updates the designated column with ajava.sql.Date
value.void
updateDate
(String columnName, Date x, boolean forceEncrypt) Updates the designated column with ajava.sql.Date
value.void
updateDateTime
(int index, Timestamp x) Updates the designated column with ajava.sql.Timestamp
value.void
updateDateTime
(int index, Timestamp x, Integer scale) Updates the designated column with ajava.sql.Timestamp
value.void
updateDateTime
(int index, Timestamp x, Integer scale, boolean forceEncrypt) Updates the designated column with ajava.sql.Timestamp
value.void
updateDateTime
(String columnName, Timestamp x) Updates the designated column with ajava.sql.Timestamp
value.void
updateDateTime
(String columnName, Timestamp x, int scale) Updates the designated column with ajava.sql.Timestamp
value.void
updateDateTime
(String columnName, Timestamp x, int scale, boolean forceEncrypt) Updates the designated column with ajava.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, 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, Integer scale, boolean forceEncrypt) Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.void
updateDateTimeOffset
(String columnName, DateTimeOffset x) Updates the value of the column specified to the DateTimeOffset Class value, given a column name.void
updateDateTimeOffset
(String columnName, DateTimeOffset x, int scale) Updates the value of the column specified to the DateTimeOffset Class value, given a column name.void
updateDateTimeOffset
(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 adouble
value.void
updateDouble
(String columnName, double x, boolean forceEncrypt) Updates the designated column with adouble
value.void
updateFloat
(int index, float x, boolean forceEncrypt) Updates the designated column with afloat
value.void
updateFloat
(String columnName, float x, boolean forceEncrypt) Updates the designated column with afloat
value.void
updateInt
(int index, int x, boolean forceEncrypt) Updates the designated column with anint
value.void
Updates the designated column with anint
value.void
updateLong
(int index, long x, boolean forceEncrypt) Updates the designated column with along
value.void
updateLong
(String columnName, long x, boolean forceEncrypt) Updates the designated column with along
value.void
updateMoney
(int index, BigDecimal x) Updates the designated column with amoney
value.void
updateMoney
(int index, BigDecimal x, boolean forceEncrypt) Updates the designated column with amoney
value.void
updateMoney
(String columnName, BigDecimal x) Updates the designated column with amoney
value.void
updateMoney
(String columnName, BigDecimal x, boolean forceEncrypt) Updates the designated column with amoney
value.void
updateNString
(int columnIndex, String nString, boolean forceEncrypt) Updates the designated column with aString
value.void
updateNString
(String columnLabel, String nString, boolean forceEncrypt) Updates the designated column with aString
value.void
updateObject
(int index, Object x, int precision, int scale) Updates the designated column with anObject
value.void
updateObject
(int index, Object x, int precision, int scale, boolean forceEncrypt) Updates the designated column with anObject
value.void
updateObject
(int index, Object obj, SQLType targetSqlType, int scale, boolean forceEncrypt) Updates the designated column with an Object value.void
updateObject
(String columnName, Object x, int precision, int scale) Updates the designated column with anObject
value.void
updateObject
(String columnName, Object x, int precision, int scale, boolean forceEncrypt) Updates the designated column with anObject
value.void
updateObject
(String columnName, Object obj, 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 ashort
value.void
updateShort
(String columnName, short x, boolean forceEncrypt) Updates the designated column with ashort
value.void
updateSmallDateTime
(int index, Timestamp x) Updates the designated column with ajava.sql.Timestamp
value.void
updateSmallDateTime
(int index, Timestamp x, Integer scale) Updates the designated column with ajava.sql.Timestamp
value.void
updateSmallDateTime
(int index, Timestamp x, Integer scale, boolean forceEncrypt) Updates the designated column with ajava.sql.Timestamp
value.void
updateSmallDateTime
(String columnName, Timestamp x) Updates the designated column with ajava.sql.Timestamp
value.void
updateSmallDateTime
(String columnName, Timestamp x, int scale) Updates the designated column with ajava.sql.Timestamp
value.void
updateSmallDateTime
(String columnName, Timestamp x, int scale, boolean forceEncrypt) Updates the designated column with ajava.sql.Timestamp
value.void
updateSmallMoney
(int index, BigDecimal x) Updates the designated column with asmallmoney
value.void
updateSmallMoney
(int index, BigDecimal x, boolean forceEncrypt) Updates the designated column with asmallmoney
value.void
updateSmallMoney
(String columnName, BigDecimal x) Updates the designated column with asmallmoney
value.void
updateSmallMoney
(String columnName, BigDecimal x, boolean forceEncrypt) Updates the designated column with asmallmoney
value.void
updateString
(int columnIndex, String stringValue, boolean forceEncrypt) Updates the designated column with aString
value.void
updateString
(String columnName, String x, boolean forceEncrypt) Updates the designated column with aString
value.void
updateTime
(int index, Time x, Integer scale) Updates the designated column with ajava.sql.Time
value.void
updateTime
(int index, Time x, Integer scale, boolean forceEncrypt) Updates the designated column with ajava.sql.Time
value.void
updateTime
(String columnName, Time x, int scale) Updates the designated column with ajava.sql.Time
value.void
updateTime
(String columnName, Time x, int scale, boolean forceEncrypt) Updates the designated column with ajava.sql.Time
value.void
updateTimestamp
(int index, Timestamp x, int scale) Updates the designated column with ajava.sql.Timestamp
value.void
updateTimestamp
(int index, Timestamp x, int scale, boolean forceEncrypt) Updates the designated column with ajava.sql.Timestamp
value.void
updateTimestamp
(String columnName, Timestamp x, int scale) Updates the designated column with ajava.sql.Timestamp
value.void
updateTimestamp
(String columnName, Timestamp x, int scale, boolean forceEncrypt) Updates the designated column with ajava.sql.Timestamp
value.void
updateUniqueIdentifier
(int index, String x) Updates the designated column with aString
value.void
updateUniqueIdentifier
(int index, String x, boolean forceEncrypt) Updates the designated column with aString
value.void
updateUniqueIdentifier
(String columnName, String x) Updates the designated column with aString
value.void
updateUniqueIdentifier
(String columnName, String x, boolean forceEncrypt) Updates the designated column with aString
value.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
-
TYPE_SS_DIRECT_FORWARD_ONLY
static final int TYPE_SS_DIRECT_FORWARD_ONLYTYPE_FORWARD_ONLY + 1000- See Also:
-
TYPE_SS_SERVER_CURSOR_FORWARD_ONLY
static final int TYPE_SS_SERVER_CURSOR_FORWARD_ONLYTYPE_FORWARD_ONLY + 1001- See Also:
-
TYPE_SS_SCROLL_STATIC
static final int TYPE_SS_SCROLL_STATICTYPE_SCROLL_INSENSITIVE- See Also:
-
TYPE_SS_SCROLL_KEYSET
static final int TYPE_SS_SCROLL_KEYSETTYPE_SCROLL_SENSITIVE- See Also:
-
TYPE_SS_SCROLL_DYNAMIC
static final int TYPE_SS_SCROLL_DYNAMICTYPE_SCROLL_SENSITIVE + 1- See Also:
-
CONCUR_SS_OPTIMISTIC_CC
static final int CONCUR_SS_OPTIMISTIC_CCCONCUR_UPDATABLE- See Also:
-
CONCUR_SS_SCROLL_LOCKS
static final int CONCUR_SS_SCROLL_LOCKSCONCUR_UPDATABLE + 1- See Also:
-
CONCUR_SS_OPTIMISTIC_CCVAL
static final int CONCUR_SS_OPTIMISTIC_CCVALCONCUR_UPDATABLE + 2- See Also:
-
-
Method Details
-
getGeometry
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
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
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
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
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
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
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
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
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
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 columncal
- 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
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
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
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
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 columncal
- 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
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
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
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
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
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
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
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
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
Updates the designated column with anObject
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueprecision
- the precision of the columnscale
- the scale of the column- Throws:
SQLServerException
- when an error occurs
-
updateObject
void updateObject(int index, Object obj, 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 valuetargetSqlType
- the SQL type to be sent to the databasescale
- 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(String columnName, Object obj, 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 columnobj
- the new column valuetargetSqlType
- the SQL type to be sent to the databasescale
- 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
Updates the designated column with aboolean
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- 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
Updates the designated column with abyte
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- 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
Updates the designated column with ashort
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- 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
Updates the designated column with anint
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- 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
Updates the designated column with along
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- 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
Updates the designated column with afloat
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- 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
Updates the designated column with adouble
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- 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
Updates the designated column with amoney
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 theupdateRow
orinsertRow
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
Updates the designated column with amoney
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- 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
Updates the designated column with amoney
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- the column namex
- the new column value- Throws:
SQLServerException
- If any errors occur.
-
updateMoney
Updates the designated column with amoney
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- the column namex
- the new column valueforceEncrypt
- 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
Updates the designated column with asmallmoney
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 theupdateRow
orinsertRow
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
Updates the designated column with asmallmoney
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- 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
Updates the designated column with asmallmoney
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- the column namex
- the new column value- Throws:
SQLServerException
- If any errors occur.
-
updateSmallMoney
void updateSmallMoney(String columnName, BigDecimal x, boolean forceEncrypt) throws SQLServerException Updates the designated column with asmallmoney
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- the column namex
- the new column valueforceEncrypt
- 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, BigDecimal x, Integer precision, Integer scale) throws SQLServerException Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueprecision
- the precision of the columnscale
- the scale of the column- Throws:
SQLServerException
- when an error occurs
-
updateBigDecimal
void updateBigDecimal(int index, BigDecimal x, Integer precision, Integer scale, boolean forceEncrypt) throws SQLServerException Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueprecision
- the precision of the columnscale
- the scale of the columnforceEncrypt
- 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, String stringValue, boolean forceEncrypt) throws SQLServerException Updates the designated column with aString
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnIndex
- the first column is 1, the second is 2, ...stringValue
- the new column valueforceEncrypt
- 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
Updates the designated column with aString
value. It is intended for use when updatingNCHAR
,NVARCHAR
andLONGNVARCHAR
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 theupdateRow
orinsertRow
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 updatedforceEncrypt
- 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(String columnLabel, String nString, boolean forceEncrypt) throws SQLServerException Updates the designated column with aString
value. It is intended for use when updatingNCHAR
,NVARCHAR
andLONGNVARCHAR
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 theupdateRow
orinsertRow
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 columnnString
- the value for the column to be updatedforceEncrypt
- 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
Updates the designated column with abyte
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- 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
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueforceEncrypt
- 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
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the column- Throws:
SQLServerException
- when an error occurs
-
updateTime
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the columnforceEncrypt
- 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
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the column- Throws:
SQLServerException
- when an error occurs
-
updateTimestamp
void updateTimestamp(int index, Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the columnforceEncrypt
- 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
Updates the designated column with ajava.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 theupdateRow
orinsertRow
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
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the column- Throws:
SQLServerException
- when an error occurs
-
updateDateTime
void updateDateTime(int index, Timestamp x, Integer scale, boolean forceEncrypt) throws SQLServerException Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the columnforceEncrypt
- 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
Updates the designated column with ajava.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 theupdateRow
orinsertRow
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
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the column- Throws:
SQLServerException
- when an error occurs
-
updateSmallDateTime
void updateSmallDateTime(int index, Timestamp x, Integer scale, boolean forceEncrypt) throws SQLServerException Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valuescale
- the scale of the columnforceEncrypt
- 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
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, 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 columnforceEncrypt
- 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
Updates the designated column with aString
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 theupdateRow
orinsertRow
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
Updates the designated column with aString
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- The zero-based ordinal of a column.x
- the new column valueforceEncrypt
- 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, Object x, int precision, int scale, boolean forceEncrypt) throws SQLServerException Updates the designated column with anObject
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column valueprecision
- the precision of the columnscale
- the scale of the columnforceEncrypt
- 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
Updates the designated column with aboolean
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- the name of the columnx
- the new column valueforceEncrypt
- 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
Updates the designated column with abyte
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- the name of the columnx
- the new column valueforceEncrypt
- 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
Updates the designated column with ashort
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- the name of the columnx
- the new column valueforceEncrypt
- 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
Updates the designated column with anint
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- 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
Updates the designated column with along
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- 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
Updates the designated column with afloat
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- 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
Updates the designated column with adouble
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- 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(String columnName, BigDecimal x, boolean forceEncrypt) throws SQLServerException Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- 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(String columnName, BigDecimal x, Integer precision, Integer scale) throws SQLServerException Updates the designated column with ajava.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 theupdateRow
orinsertRow
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 valueprecision
- the precision of the columnscale
- the scale of the column- Throws:
SQLServerException
- If any errors occur.
-
updateBigDecimal
void updateBigDecimal(String columnName, BigDecimal x, Integer precision, Integer scale, boolean forceEncrypt) throws SQLServerException Updates the designated column with ajava.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 theupdateRow
orinsertRow
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 valueprecision
- the precision of the columnscale
- the scale of the columnforceEncrypt
- 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
Updates the designated column with aString
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- 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
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- 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
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valueforceEncrypt
- 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
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the column- Throws:
SQLServerException
- If any errors occur.
-
updateTime
void updateTime(String columnName, Time x, int scale, boolean forceEncrypt) throws SQLServerException Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the columnforceEncrypt
- 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
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the column- Throws:
SQLServerException
- If any errors occur.
-
updateTimestamp
void updateTimestamp(String columnName, Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the columnforceEncrypt
- 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
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column value- Throws:
SQLServerException
- If any errors occur.
-
updateDateTime
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the column- Throws:
SQLServerException
- If any errors occur.
-
updateDateTime
void updateDateTime(String columnName, Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the columnforceEncrypt
- 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
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column value- Throws:
SQLServerException
- If any errors occur.
-
updateSmallDateTime
Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the column- Throws:
SQLServerException
- If any errors occur.
-
updateSmallDateTime
void updateSmallDateTime(String columnName, Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException Updates the designated column with ajava.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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the columnforceEncrypt
- 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
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(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 columnforceEncrypt
- 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
Updates the designated column with aString
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 theupdateRow
orinsertRow
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(String columnName, String x, boolean forceEncrypt) throws SQLServerException Updates the designated column with aString
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- The name of a column.x
- the new column valueforceEncrypt
- 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
Updates the designated column with anObject
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- The name of a column.x
- the new column valueprecision
- the precision of the columnscale
- the scale of the column- Throws:
SQLServerException
- If any errors occur.
-
updateObject
void updateObject(String columnName, Object x, int precision, int scale, boolean forceEncrypt) throws SQLServerException Updates the designated column with anObject
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 theupdateRow
orinsertRow
methods are called to update the database.- Parameters:
columnName
- The name of a column.x
- the new column valueprecision
- the precision of the columnscale
- the scale of the columnforceEncrypt
- 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
-