Class SQLServerResultSet
- All Implemented Interfaces:
ISQLServerResultSet
,Serializable
,AutoCloseable
,ResultSet
,Wrapper
- See Also:
-
Field Summary
Fields inherited from interface com.microsoft.sqlserver.jdbc.ISQLServerResultSet
CONCUR_SS_OPTIMISTIC_CC, CONCUR_SS_OPTIMISTIC_CCVAL, CONCUR_SS_SCROLL_LOCKS, TYPE_SS_DIRECT_FORWARD_ONLY, TYPE_SS_SCROLL_DYNAMIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_STATIC, 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 TypeMethodDescriptionboolean
absolute
(int row) Moves the cursor to the given row number in thisResultSet
object.void
void
void
void
Clears result set warnings.void
close()
void
int
findColumn
(String userProvidedColumnName) Finds a column index given a column name.boolean
first()
Moves the cursor to the first row in thisResultSet
object.getArray
(int i) getAsciiStream
(int columnIndex) getAsciiStream
(String columnName) getBigDecimal
(int columnIndex) getBigDecimal
(int columnIndex, int scale) Deprecated.getBigDecimal
(String columnName) getBigDecimal
(String columnName, int scale) Deprecated.getBinaryStream
(int columnIndex) getBinaryStream
(String columnName) getBlob
(int i) boolean
getBoolean
(int columnIndex) boolean
getBoolean
(String columnName) byte
getByte
(int columnIndex) byte
byte[]
getBytes
(int columnIndex) byte[]
getCharacterStream
(int columnIndex) getCharacterStream
(String columnName) getClob
(int columnIndex) int
getDate
(int columnIndex) 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.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.double
getDouble
(int columnIndex) double
int
int
float
getFloat
(int columnIndex) float
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.int
int
getInt
(int columnIndex) int
long
getLong
(int columnIndex) long
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.getNCharacterStream
(int columnIndex) getNCharacterStream
(String columnLabel) getNClob
(int columnIndex) getNString
(int columnIndex) getNString
(String columnLabel) getObject
(int columnIndex) <T> T
<T> T
getRef
(int i) int
getRow()
getRowId
(int columnIndex) 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.protected int
Returns the server cursor idshort
getShort
(int columnIndex) short
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.getSQLXML
(int columnIndex) getString
(int columnIndex) getTime
(int columnIndex) getTimestamp
(int columnIndex) getTimestamp
(int columnIndex, Calendar cal) getTimestamp
(String columnName) getTimestamp
(String colName, Calendar cal) int
getType()
getUnicodeStream
(int columnIndex) Deprecated.getUnicodeStream
(String columnName) Deprecated.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.getURL
(int columnIndex) void
boolean
boolean
Returns if the cursor is before the first row in this result set.boolean
isClosed()
boolean
isFirst()
Returns whether the cursor is on the first row of thisResultSet
object.protected boolean
Check if type is ForwardOnlyboolean
isLast()
Returns whether the cursor is on the last row of thisResultSet
object.boolean
isWrapperFor
(Class<?> iface) boolean
last()
Moves the cursor to the last row in thisResultSet
object.void
void
boolean
next()
Moves the cursor to the first row of this ResultSet object initially, then subsequent calls move the cursor to the second row, the third row, and so on.boolean
previous()
Moves the cursor to the previous row in thisResultSet
object.void
boolean
relative
(int rows) boolean
boolean
boolean
void
setFetchDirection
(int direction) void
setFetchSize
(int rows) toString()
<T> T
void
updateArray
(int columnIndex, Array x) void
updateArray
(String columnName, Array x) void
updateAsciiStream
(int columnIndex, InputStream x) void
updateAsciiStream
(int index, InputStream x, int length) void
updateAsciiStream
(int columnIndex, InputStream x, long length) void
updateAsciiStream
(String columnLabel, InputStream x) void
updateAsciiStream
(String columnName, InputStream x, int length) void
updateAsciiStream
(String columnName, InputStream streamValue, long length) void
updateBigDecimal
(int index, BigDecimal x) 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) 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
updateBinaryStream
(int columnIndex, InputStream x) void
updateBinaryStream
(int columnIndex, InputStream streamValue, int length) void
updateBinaryStream
(int columnIndex, InputStream x, long length) void
updateBinaryStream
(String columnLabel, InputStream x) void
updateBinaryStream
(String columnName, InputStream streamValue, int length) void
updateBinaryStream
(String columnLabel, InputStream x, long length) void
updateBlob
(int columnIndex, InputStream inputStream) void
updateBlob
(int columnIndex, InputStream inputStream, long length) void
updateBlob
(int columnIndex, Blob blobValue) void
updateBlob
(String columnLabel, InputStream inputStream) void
updateBlob
(String columnLabel, InputStream inputStream, long length) void
updateBlob
(String columnName, Blob blobValue) void
updateBoolean
(int index, boolean x) void
updateBoolean
(int index, boolean x, boolean forceEncrypt) Updates the designated column with aboolean
value.void
updateBoolean
(String columnName, boolean x) void
updateBoolean
(String columnName, boolean x, boolean forceEncrypt) Updates the designated column with aboolean
value.void
updateByte
(int index, byte x) void
updateByte
(int index, byte x, boolean forceEncrypt) Updates the designated column with abyte
value.void
updateByte
(String columnName, byte x) void
updateByte
(String columnName, byte x, boolean forceEncrypt) Updates the designated column with abyte
value.void
updateBytes
(int index, byte[] x) void
updateBytes
(int index, byte[] x, boolean forceEncrypt) Updates the designated column with abyte
array value.void
updateBytes
(String columnName, byte[] x) void
updateBytes
(String columnName, byte[] x, boolean forceEncrypt) Updates the designated column with a byte array value.void
updateCharacterStream
(int columnIndex, Reader x) void
updateCharacterStream
(int columnIndex, Reader readerValue, int length) void
updateCharacterStream
(int columnIndex, Reader x, long length) void
updateCharacterStream
(String columnLabel, Reader reader) void
updateCharacterStream
(String columnName, Reader readerValue, int length) void
updateCharacterStream
(String columnLabel, Reader reader, long length) void
updateClob
(int columnIndex, Reader reader) void
updateClob
(int columnIndex, Reader reader, long length) void
updateClob
(int columnIndex, Clob clobValue) void
updateClob
(String columnLabel, Reader reader) void
updateClob
(String columnLabel, Reader reader, long length) void
updateClob
(String columnName, Clob clobValue) void
updateDate
(int index, Date x) void
updateDate
(int index, Date x, boolean forceEncrypt) Updates the designated column with ajava.sql.Date
value.void
updateDate
(String columnName, Date x) 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) void
updateDouble
(int index, double x, boolean forceEncrypt) Updates the designated column with adouble
value.void
updateDouble
(String columnName, double x) void
updateDouble
(String columnName, double x, boolean forceEncrypt) Updates the designated column with adouble
value.void
updateFloat
(int index, float x) void
updateFloat
(int index, float x, boolean forceEncrypt) Updates the designated column with afloat
value.void
updateFloat
(String columnName, float x) void
updateFloat
(String columnName, float x, boolean forceEncrypt) Updates the designated column with afloat
value.void
updateInt
(int index, int x) void
updateInt
(int index, int x, boolean forceEncrypt) Updates the designated column with anint
value.void
void
Updates the designated column with anint
value.void
updateLong
(int index, long x) void
updateLong
(int index, long x, boolean forceEncrypt) Updates the designated column with along
value.void
updateLong
(String columnName, long x) 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
updateNCharacterStream
(int columnIndex, Reader x) void
updateNCharacterStream
(int columnIndex, Reader x, long length) void
updateNCharacterStream
(String columnLabel, Reader reader) void
updateNCharacterStream
(String columnLabel, Reader reader, long length) void
updateNClob
(int columnIndex, Reader reader) void
updateNClob
(int columnIndex, Reader reader, long length) void
updateNClob
(int columnIndex, NClob nClob) void
updateNClob
(String columnLabel, Reader reader) void
updateNClob
(String columnLabel, Reader reader, long length) void
updateNClob
(String columnLabel, NClob nClob) void
updateNString
(int columnIndex, String nString) void
updateNString
(int columnIndex, String nString, boolean forceEncrypt) Updates the designated column with aString
value.void
updateNString
(String columnLabel, String nString) void
updateNString
(String columnLabel, String nString, boolean forceEncrypt) Updates the designated column with aString
value.void
updateNull
(int index) void
updateNull
(String columnName) void
updateObject
(int index, Object obj) void
updateObject
(int index, Object x, int scale) 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) void
updateObject
(int index, Object obj, SQLType targetSqlType, int scale) 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) void
updateObject
(String columnName, Object x, int scale) 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) void
updateObject
(String columnName, Object obj, SQLType targetSqlType, int scale) void
updateObject
(String columnName, Object obj, SQLType targetSqlType, int scale, boolean forceEncrypt) Updates the designated column with an Object value.void
void
void
void
updateRowId
(int columnIndex, RowId x) void
updateRowId
(String columnLabel, RowId x) void
updateShort
(int index, short x) void
updateShort
(int index, short x, boolean forceEncrypt) Updates the designated column with ashort
value.void
updateShort
(String columnName, short x) 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
updateSQLXML
(int columnIndex, SQLXML xmlObject) void
updateSQLXML
(String columnLabel, SQLXML x) void
updateString
(int columnIndex, String stringValue) void
updateString
(int columnIndex, String stringValue, boolean forceEncrypt) Updates the designated column with aString
value.void
updateString
(String columnName, String x) void
updateString
(String columnName, String x, boolean forceEncrypt) Updates the designated column with aString
value.void
updateTime
(int index, Time x) 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) 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) 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) 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.boolean
wasNull()
-
Method Details
-
toString
-
getServerCursorId
protected int getServerCursorId()Returns the server cursor id- Returns:
- server cursor id
-
getSensitivityClassification
Description copied from interface:ISQLServerResultSet
Returns the Data Classification information for the current ResultSet For SQL Servers that do not support Data Classification or results that do not fetch any classified columns, this data can be null.- Specified by:
getSensitivityClassification
in interfaceISQLServerResultSet
- Returns:
- SensitivityClassification
-
isWrapperFor
- Specified by:
isWrapperFor
in interfaceWrapper
- Throws:
SQLException
-
unwrap
- Specified by:
unwrap
in interfaceWrapper
- Throws:
SQLException
-
isClosed
- Specified by:
isClosed
in interfaceResultSet
- Throws:
SQLException
-
isForwardOnly
protected boolean isForwardOnly()Check if type is ForwardOnly- Returns:
- if type is ForwardOnly
-
close
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceResultSet
- Throws:
SQLServerException
-
findColumn
Finds a column index given a column name.- Specified by:
findColumn
in interfaceResultSet
- Parameters:
userProvidedColumnName
- the name of the column- Returns:
- the column index
- Throws:
SQLServerException
- If any errors occur.
-
clearWarnings
Clears result set warnings.- Specified by:
clearWarnings
in interfaceResultSet
- Throws:
SQLServerException
- when an error occurs
-
relative
- Specified by:
relative
in interfaceResultSet
- Throws:
SQLException
-
next
Moves the cursor to the first row of this ResultSet object initially, then subsequent calls move the cursor to the second row, the third row, and so on.- Specified by:
next
in interfaceResultSet
- Returns:
- false when there are no more rows to read
- Throws:
SQLServerException
-
wasNull
- Specified by:
wasNull
in interfaceResultSet
- Throws:
SQLServerException
-
isBeforeFirst
Returns if the cursor is before the first row in this result set.- Specified by:
isBeforeFirst
in interfaceResultSet
- Returns:
- true if the cursor is before the first row in this result set, returns false otherwise or if the result set contains no rows.
- Throws:
SQLException
-
isAfterLast
- Specified by:
isAfterLast
in interfaceResultSet
- Throws:
SQLException
-
isFirst
Returns whether the cursor is on the first row of thisResultSet
object. This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.Note:Support for the
isFirst
method is optional forResultSet
s with a result set type ofTYPE_FORWARD_ONLY
- Specified by:
isFirst
in interfaceResultSet
- Returns:
true
if the cursor is on the first row;false
otherwise- Throws:
SQLException
- if a database access error occurs or this method is called on a closed result set- Since:
- 1.2
-
isLast
Returns whether the cursor is on the last row of thisResultSet
object. Note: Calling the methodisLast
may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.
Note: Support for theisLast
method is optional forResultSet
s with a result set type ofTYPE_FORWARD_ONLY
- Specified by:
isLast
in interfaceResultSet
- Returns:
true
if the cursor is on the last row;false
otherwise- Throws:
SQLException
- if a database access error occurs or this method is called on a closed result set- Since:
- 1.2
-
beforeFirst
- Specified by:
beforeFirst
in interfaceResultSet
- Throws:
SQLException
-
afterLast
- Specified by:
afterLast
in interfaceResultSet
- Throws:
SQLException
-
first
Moves the cursor to the first row in thisResultSet
object.This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.
- Specified by:
first
in interfaceResultSet
- Returns:
true
if the cursor is on a valid row;false
if there are no rows in the result set- Throws:
SQLException
- if a database access error occurs; this method is called on a closed result set or the result set type isTYPE_FORWARD_ONLY
- Since:
- 1.2
-
last
Moves the cursor to the last row in thisResultSet
object. This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.- Specified by:
last
in interfaceResultSet
- Returns:
true
if the cursor is on a valid row;false
if there are no rows in the result set- Throws:
SQLException
- if a database access error occurs; this method is called on a closed result set or the result set type isTYPE_FORWARD_ONLY
- Since:
- 1.2
-
getRow
- Specified by:
getRow
in interfaceResultSet
- Throws:
SQLException
-
absolute
Moves the cursor to the given row number in thisResultSet
object.This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.
If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.
If the given row number is negative, the cursor moves to an absolute row position with respect to the end of the result set. For example, calling the method
absolute(-1)
positions the cursor on the last row; calling the methodabsolute(-2)
moves the cursor to the next-to-last row, and so on.If the row number specified is zero, the cursor is moved to before the first row.
An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before the first row or after the last row.
Note: Calling
absolute(1)
is the same as callingfirst()
. Callingabsolute(-1)
is the same as callinglast()
.- Specified by:
absolute
in interfaceResultSet
- Parameters:
row
- the number of the row to which the cursor should move. A value of zero indicates that the cursor will be positioned before the first row; a positive number indicates the row number counting from the beginning of the result set; a negative number indicates the row number counting from the end of the result set- Returns:
true
if the cursor is moved to a position in thisResultSet
object;false
if the cursor is before the first row or after the last row- Throws:
SQLException
- if a database access error occurs; this method is called on a closed result set or the result set type isTYPE_FORWARD_ONLY
- Since:
- 1.2
-
previous
Moves the cursor to the previous row in thisResultSet
object. This method should be called only on ResultSet objects that are scrollable: TYPE_SCROLL_SENSITIVE, TYPE_SCROLL_INSENSITIVE, TYPE_SS_SCROLL_STATIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_DYNAMIC.- Specified by:
previous
in interfaceResultSet
- Returns:
true
if the cursor is now positioned on a valid row;false
if the cursor is positioned before the first row- Throws:
SQLException
- if a database access error occurs; this method is called on a closed result set or the result set type isTYPE_FORWARD_ONLY
- Since:
- 1.2
-
getWarnings
- Specified by:
getWarnings
in interfaceResultSet
- Throws:
SQLException
-
setFetchDirection
- Specified by:
setFetchDirection
in interfaceResultSet
- Throws:
SQLException
-
getFetchDirection
- Specified by:
getFetchDirection
in interfaceResultSet
- Throws:
SQLException
-
setFetchSize
- Specified by:
setFetchSize
in interfaceResultSet
- Throws:
SQLServerException
-
getFetchSize
- Specified by:
getFetchSize
in interfaceResultSet
- Throws:
SQLException
-
getType
- Specified by:
getType
in interfaceResultSet
- Throws:
SQLServerException
-
getConcurrency
- Specified by:
getConcurrency
in interfaceResultSet
- Throws:
SQLServerException
-
getAsciiStream
- Specified by:
getAsciiStream
in interfaceResultSet
- Throws:
SQLServerException
-
getAsciiStream
- Specified by:
getAsciiStream
in interfaceResultSet
- Throws:
SQLServerException
-
getBigDecimal
Deprecated.- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
SQLServerException
-
getBigDecimal
Deprecated.- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
SQLServerException
-
getBinaryStream
- Specified by:
getBinaryStream
in interfaceResultSet
- Throws:
SQLServerException
-
getBinaryStream
- Specified by:
getBinaryStream
in interfaceResultSet
- Throws:
SQLServerException
-
getBoolean
- Specified by:
getBoolean
in interfaceResultSet
- Throws:
SQLServerException
-
getBoolean
- Specified by:
getBoolean
in interfaceResultSet
- Throws:
SQLServerException
-
getByte
- Specified by:
getByte
in interfaceResultSet
- Throws:
SQLServerException
-
getByte
- Specified by:
getByte
in interfaceResultSet
- Throws:
SQLServerException
-
getBytes
- Specified by:
getBytes
in interfaceResultSet
- Throws:
SQLServerException
-
getBytes
- Specified by:
getBytes
in interfaceResultSet
- Throws:
SQLServerException
-
getDate
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLServerException
-
getDate
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLServerException
-
getDate
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLServerException
-
getDate
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLServerException
-
getDouble
- Specified by:
getDouble
in interfaceResultSet
- Throws:
SQLServerException
-
getDouble
- Specified by:
getDouble
in interfaceResultSet
- Throws:
SQLServerException
-
getFloat
- Specified by:
getFloat
in interfaceResultSet
- Throws:
SQLServerException
-
getFloat
- Specified by:
getFloat
in interfaceResultSet
- Throws:
SQLServerException
-
getGeometry
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geometry object in the Java programming language.- Specified by:
getGeometry
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geometry object in the Java programming language.- Specified by:
getGeometry
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geography object in the Java programming language.- Specified by:
getGeography
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geography object in the Java programming language.- Specified by:
getGeography
in interfaceISQLServerResultSet
- 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
-
getInt
- Specified by:
getInt
in interfaceResultSet
- Throws:
SQLServerException
-
getInt
- Specified by:
getInt
in interfaceResultSet
- Throws:
SQLServerException
-
getLong
- Specified by:
getLong
in interfaceResultSet
- Throws:
SQLServerException
-
getLong
- Specified by:
getLong
in interfaceResultSet
- Throws:
SQLServerException
-
getMetaData
- Specified by:
getMetaData
in interfaceResultSet
- Throws:
SQLServerException
-
getObject
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLServerException
-
getObject
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLServerException
-
getObject
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getShort
- Specified by:
getShort
in interfaceResultSet
- Throws:
SQLServerException
-
getShort
- Specified by:
getShort
in interfaceResultSet
- Throws:
SQLServerException
-
getString
- Specified by:
getString
in interfaceResultSet
- Throws:
SQLServerException
-
getString
- Specified by:
getString
in interfaceResultSet
- Throws:
SQLServerException
-
getNString
- Specified by:
getNString
in interfaceResultSet
- Throws:
SQLException
-
getNString
- Specified by:
getNString
in interfaceResultSet
- Throws:
SQLException
-
getUniqueIdentifier
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a String object in the Java programming language.- Specified by:
getUniqueIdentifier
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a String object in the Java programming language.- Specified by:
getUniqueIdentifier
in interfaceISQLServerResultSet
- 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
-
getTime
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLServerException
-
getTime
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLServerException
-
getTime
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLServerException
-
getTime
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLServerException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLServerException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLServerException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLServerException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLServerException
-
getDateTime
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getDateTime
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getDateTime
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.- Specified by:
getDateTime
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.- Specified by:
getDateTime
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getSmallDateTime
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getSmallDateTime
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getSmallDateTime
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getSmallDateTime
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column as a microsoft.sql.DateTimeOffset object, given a zero-based column ordinal.- Specified by:
getDateTimeOffset
in interfaceISQLServerResultSet
- Parameters:
columnIndex
- The zero-based ordinal of a column.- Returns:
- A DateTimeOffset Class object.
- Throws:
SQLServerException
- when an error occurs
-
getDateTimeOffset
Description copied from interface:ISQLServerResultSet
Returns the value of the column specified as a microsoft.sql.DateTimeOffset object, given a column name.- Specified by:
getDateTimeOffset
in interfaceISQLServerResultSet
- Parameters:
columnName
- The name of a column.- Returns:
- A DateTimeOffset Class object.
- Throws:
SQLServerException
- when an error occurs
-
getUnicodeStream
Deprecated.- Specified by:
getUnicodeStream
in interfaceResultSet
- Throws:
SQLException
-
getUnicodeStream
Deprecated.- Specified by:
getUnicodeStream
in interfaceResultSet
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getRef
- Specified by:
getRef
in interfaceResultSet
- Throws:
SQLException
-
getBlob
- Specified by:
getBlob
in interfaceResultSet
- Throws:
SQLServerException
-
getBlob
- Specified by:
getBlob
in interfaceResultSet
- Throws:
SQLServerException
-
getClob
- Specified by:
getClob
in interfaceResultSet
- Throws:
SQLServerException
-
getClob
- Specified by:
getClob
in interfaceResultSet
- Throws:
SQLServerException
-
getNClob
- Specified by:
getNClob
in interfaceResultSet
- Throws:
SQLException
-
getNClob
- Specified by:
getNClob
in interfaceResultSet
- Throws:
SQLException
-
getArray
- Specified by:
getArray
in interfaceResultSet
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getRef
- Specified by:
getRef
in interfaceResultSet
- Throws:
SQLException
-
getArray
- Specified by:
getArray
in interfaceResultSet
- Throws:
SQLException
-
getCursorName
- Specified by:
getCursorName
in interfaceResultSet
- Throws:
SQLException
-
getCharacterStream
- Specified by:
getCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getCharacterStream
- Specified by:
getCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getNCharacterStream
- Specified by:
getNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getNCharacterStream
- Specified by:
getNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getBigDecimal
- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
SQLException
-
getBigDecimal
- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
SQLException
-
getMoney
Description copied from interface:ISQLServerResultSet
Returns the value of the column specified as a java.math.BigDecimal object.- Specified by:
getMoney
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the column specified as a java.math.BigDecimal object.- Specified by:
getMoney
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the column specified as a java.math.BigDecimal object.- Specified by:
getSmallMoney
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Returns the value of the column specified as a java.math.BigDecimal object.- Specified by:
getSmallMoney
in interfaceISQLServerResultSet
- 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.
-
getRowId
- Specified by:
getRowId
in interfaceResultSet
- Throws:
SQLException
-
getRowId
- Specified by:
getRowId
in interfaceResultSet
- Throws:
SQLException
-
getSQLXML
- Specified by:
getSQLXML
in interfaceResultSet
- Throws:
SQLException
-
getSQLXML
- Specified by:
getSQLXML
in interfaceResultSet
- Throws:
SQLException
-
rowUpdated
- Specified by:
rowUpdated
in interfaceResultSet
- Throws:
SQLServerException
-
rowInserted
- Specified by:
rowInserted
in interfaceResultSet
- Throws:
SQLServerException
-
rowDeleted
- Specified by:
rowDeleted
in interfaceResultSet
- Throws:
SQLServerException
-
updateNull
- Specified by:
updateNull
in interfaceResultSet
- Throws:
SQLServerException
-
updateBoolean
- Specified by:
updateBoolean
in interfaceResultSet
- Throws:
SQLException
-
updateBoolean
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateBoolean
in interfaceISQLServerResultSet
- 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
- Specified by:
updateByte
in interfaceResultSet
- Throws:
SQLException
-
updateByte
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateByte
in interfaceISQLServerResultSet
- 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
- Specified by:
updateShort
in interfaceResultSet
- Throws:
SQLException
-
updateShort
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateShort
in interfaceISQLServerResultSet
- 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
- Specified by:
updateInt
in interfaceResultSet
- Throws:
SQLException
-
updateInt
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateInt
in interfaceISQLServerResultSet
- 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
- Specified by:
updateLong
in interfaceResultSet
- Throws:
SQLException
-
updateLong
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateLong
in interfaceISQLServerResultSet
- 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
- Specified by:
updateFloat
in interfaceResultSet
- Throws:
SQLException
-
updateFloat
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateFloat
in interfaceISQLServerResultSet
- 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
- Specified by:
updateDouble
in interfaceResultSet
- Throws:
SQLException
-
updateDouble
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateDouble
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateMoney
in interfaceISQLServerResultSet
- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
SQLServerException
- when an error occurs
-
updateMoney
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateMoney
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateMoney
in interfaceISQLServerResultSet
- Parameters:
columnName
- the column namex
- the new column value- Throws:
SQLServerException
- If any errors occur.
-
updateMoney
public void updateMoney(String columnName, BigDecimal x, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateMoney
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateSmallMoney
in interfaceISQLServerResultSet
- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
SQLServerException
- when an error occurs
-
updateSmallMoney
public void updateSmallMoney(int index, BigDecimal x, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateSmallMoney
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateSmallMoney
in interfaceISQLServerResultSet
- Parameters:
columnName
- the column namex
- the new column value- Throws:
SQLServerException
- If any errors occur.
-
updateSmallMoney
public void updateSmallMoney(String columnName, BigDecimal x, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateSmallMoney
in interfaceISQLServerResultSet
- 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
- Specified by:
updateBigDecimal
in interfaceResultSet
- Throws:
SQLServerException
-
updateBigDecimal
public void updateBigDecimal(int index, BigDecimal x, Integer precision, Integer scale) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateBigDecimal
in interfaceISQLServerResultSet
- 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
public void updateBigDecimal(int index, BigDecimal x, Integer precision, Integer scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateBigDecimal
in interfaceISQLServerResultSet
- 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
- Specified by:
updateString
in interfaceResultSet
- Throws:
SQLServerException
-
updateString
public void updateString(int columnIndex, String stringValue, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateString
in interfaceISQLServerResultSet
- 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
- Specified by:
updateNString
in interfaceResultSet
- Throws:
SQLException
-
updateNString
public void updateNString(int columnIndex, String nString, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateNString
in interfaceISQLServerResultSet
- 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
- Specified by:
updateNString
in interfaceResultSet
- Throws:
SQLException
-
updateNString
public void updateNString(String columnLabel, String nString, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateNString
in interfaceISQLServerResultSet
- 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
- Specified by:
updateBytes
in interfaceResultSet
- Throws:
SQLException
-
updateBytes
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateBytes
in interfaceISQLServerResultSet
- 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
- Specified by:
updateDate
in interfaceResultSet
- Throws:
SQLServerException
-
updateDate
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateDate
in interfaceISQLServerResultSet
- 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
- Specified by:
updateTime
in interfaceResultSet
- Throws:
SQLServerException
-
updateTime
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateTime
in interfaceISQLServerResultSet
- 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
public void updateTime(int index, Time x, Integer scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateTime
in interfaceISQLServerResultSet
- 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
- Specified by:
updateTimestamp
in interfaceResultSet
- Throws:
SQLServerException
-
updateTimestamp
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateTimestamp
in interfaceISQLServerResultSet
- 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
public void updateTimestamp(int index, Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateTimestamp
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateDateTime
in interfaceISQLServerResultSet
- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
SQLServerException
- when an error occurs
-
updateDateTime
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateDateTime
in interfaceISQLServerResultSet
- 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
public void updateDateTime(int index, Timestamp x, Integer scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateDateTime
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateSmallDateTime
in interfaceISQLServerResultSet
- Parameters:
index
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
SQLServerException
- when an error occurs
-
updateSmallDateTime
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateSmallDateTime
in interfaceISQLServerResultSet
- 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
public void updateSmallDateTime(int index, Timestamp x, Integer scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateSmallDateTime
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.- Specified by:
updateDateTimeOffset
in interfaceISQLServerResultSet
- Parameters:
index
- The zero-based ordinal of a column.x
- A DateTimeOffset Class object.- Throws:
SQLServerException
- when an error occurs
-
updateDateTimeOffset
public void updateDateTimeOffset(int index, DateTimeOffset x, Integer scale) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.- Specified by:
updateDateTimeOffset
in interfaceISQLServerResultSet
- 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
public void updateDateTimeOffset(int index, DateTimeOffset x, Integer scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.- Specified by:
updateDateTimeOffset
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateUniqueIdentifier
in interfaceISQLServerResultSet
- Parameters:
index
- The zero-based ordinal of a column.x
- the new column value- Throws:
SQLServerException
- when an error occurs
-
updateUniqueIdentifier
public void updateUniqueIdentifier(int index, String x, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateUniqueIdentifier
in interfaceISQLServerResultSet
- 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
-
updateAsciiStream
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLServerException
-
updateAsciiStream
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLServerException - Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLServerException
-
updateAsciiStream
public void updateAsciiStream(String columnName, InputStream streamValue, long length) throws SQLException - Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, InputStream streamValue, int length) throws SQLException - Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(String columnName, InputStream streamValue, int length) throws SQLException - Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, Reader readerValue, int length) throws SQLServerException - Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLServerException
-
updateCharacterStream
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(String columnName, Reader readerValue, int length) throws SQLServerException - Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLServerException
-
updateCharacterStream
public void updateCharacterStream(String columnLabel, Reader reader, long length) throws SQLException - Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
- Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
- Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
- Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
public void updateNCharacterStream(String columnLabel, Reader reader, long length) throws SQLException - Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateObject
- Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLServerException
-
updateObject
- Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLServerException
-
updateObject
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateObject
in interfaceISQLServerResultSet
- 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
public void updateObject(int index, Object x, int precision, int scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateObject
in interfaceISQLServerResultSet
- 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
-
updateNull
- Specified by:
updateNull
in interfaceResultSet
- Throws:
SQLServerException
-
updateBoolean
- Specified by:
updateBoolean
in interfaceResultSet
- Throws:
SQLServerException
-
updateBoolean
public void updateBoolean(String columnName, boolean x, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateBoolean
in interfaceISQLServerResultSet
- 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
- Specified by:
updateByte
in interfaceResultSet
- Throws:
SQLServerException
-
updateByte
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateByte
in interfaceISQLServerResultSet
- 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
- Specified by:
updateShort
in interfaceResultSet
- Throws:
SQLServerException
-
updateShort
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateShort
in interfaceISQLServerResultSet
- 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
- Specified by:
updateInt
in interfaceResultSet
- Throws:
SQLServerException
-
updateInt
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateInt
in interfaceISQLServerResultSet
- 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
- Specified by:
updateLong
in interfaceResultSet
- Throws:
SQLServerException
-
updateLong
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateLong
in interfaceISQLServerResultSet
- 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
- Specified by:
updateFloat
in interfaceResultSet
- Throws:
SQLServerException
-
updateFloat
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateFloat
in interfaceISQLServerResultSet
- 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
- Specified by:
updateDouble
in interfaceResultSet
- Throws:
SQLServerException
-
updateDouble
public void updateDouble(String columnName, double x, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateDouble
in interfaceISQLServerResultSet
- 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
- Specified by:
updateBigDecimal
in interfaceResultSet
- Throws:
SQLServerException
-
updateBigDecimal
public void updateBigDecimal(String columnName, BigDecimal x, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateBigDecimal
in interfaceISQLServerResultSet
- 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
public void updateBigDecimal(String columnName, BigDecimal x, Integer precision, Integer scale) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateBigDecimal
in interfaceISQLServerResultSet
- 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
public void updateBigDecimal(String columnName, BigDecimal x, Integer precision, Integer scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateBigDecimal
in interfaceISQLServerResultSet
- 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
- Specified by:
updateString
in interfaceResultSet
- Throws:
SQLServerException
-
updateString
public void updateString(String columnName, String x, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateString
in interfaceISQLServerResultSet
- 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
- Specified by:
updateBytes
in interfaceResultSet
- Throws:
SQLServerException
-
updateBytes
public void updateBytes(String columnName, byte[] x, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with a byte array value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead theupdateRow
orinsertRow
methods are called to update the database.- Specified by:
updateBytes
in interfaceISQLServerResultSet
- 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
- Specified by:
updateDate
in interfaceResultSet
- Throws:
SQLServerException
-
updateDate
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateDate
in interfaceISQLServerResultSet
- 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
- Specified by:
updateTime
in interfaceResultSet
- Throws:
SQLServerException
-
updateTime
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateTime
in interfaceISQLServerResultSet
- Parameters:
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the column- Throws:
SQLServerException
- If any errors occur.
-
updateTime
public void updateTime(String columnName, Time x, int scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateTime
in interfaceISQLServerResultSet
- 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
- Specified by:
updateTimestamp
in interfaceResultSet
- Throws:
SQLServerException
-
updateTimestamp
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateTimestamp
in interfaceISQLServerResultSet
- Parameters:
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the column- Throws:
SQLServerException
- If any errors occur.
-
updateTimestamp
public void updateTimestamp(String columnName, Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateTimestamp
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateDateTime
in interfaceISQLServerResultSet
- Parameters:
columnName
- is the name of the columnx
- the new column value- Throws:
SQLServerException
- If any errors occur.
-
updateDateTime
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateDateTime
in interfaceISQLServerResultSet
- Parameters:
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the column- Throws:
SQLServerException
- If any errors occur.
-
updateDateTime
public void updateDateTime(String columnName, Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateDateTime
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateSmallDateTime
in interfaceISQLServerResultSet
- Parameters:
columnName
- is the name of the columnx
- the new column value- Throws:
SQLServerException
- If any errors occur.
-
updateSmallDateTime
public void updateSmallDateTime(String columnName, Timestamp x, int scale) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateSmallDateTime
in interfaceISQLServerResultSet
- Parameters:
columnName
- is the name of the columnx
- the new column valuescale
- the scale of the column- Throws:
SQLServerException
- If any errors occur.
-
updateSmallDateTime
public void updateSmallDateTime(String columnName, Timestamp x, int scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateSmallDateTime
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
Updates the value of the column specified to the DateTimeOffset Class value, given a column name.- Specified by:
updateDateTimeOffset
in interfaceISQLServerResultSet
- Parameters:
columnName
- The name of a column.x
- A DateTimeOffset Class object.- Throws:
SQLServerException
- when an error occurs
-
updateDateTimeOffset
public void updateDateTimeOffset(String columnName, DateTimeOffset x, int scale) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the value of the column specified to the DateTimeOffset Class value, given a column name.- Specified by:
updateDateTimeOffset
in interfaceISQLServerResultSet
- 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
public void updateDateTimeOffset(String columnName, DateTimeOffset x, int scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the value of the column specified to the DateTimeOffset Class value, given a column name.- Specified by:
updateDateTimeOffset
in interfaceISQLServerResultSet
- 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
Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateUniqueIdentifier
in interfaceISQLServerResultSet
- Parameters:
columnName
- The name of a column.x
- the new column value- Throws:
SQLServerException
- If any errors occur.
-
updateUniqueIdentifier
public void updateUniqueIdentifier(String columnName, String x, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateUniqueIdentifier
in interfaceISQLServerResultSet
- 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
- Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLServerException
-
updateObject
public void updateObject(String columnName, Object x, int precision, int scale) throws SQLServerException Description copied from interface:ISQLServerResultSet
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.- Specified by:
updateObject
in interfaceISQLServerResultSet
- 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
public void updateObject(String columnName, Object x, int precision, int scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with 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.- Specified by:
updateObject
in interfaceISQLServerResultSet
- 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.
-
updateObject
- Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLServerException
-
updateRowId
- Specified by:
updateRowId
in interfaceResultSet
- Throws:
SQLException
-
updateRowId
- Specified by:
updateRowId
in interfaceResultSet
- Throws:
SQLException
-
updateSQLXML
- Specified by:
updateSQLXML
in interfaceResultSet
- Throws:
SQLException
-
updateSQLXML
- Specified by:
updateSQLXML
in interfaceResultSet
- Throws:
SQLException
-
getHoldability
- Specified by:
getHoldability
in interfaceResultSet
- Throws:
SQLException
-
insertRow
- Specified by:
insertRow
in interfaceResultSet
- Throws:
SQLException
-
updateRow
- Specified by:
updateRow
in interfaceResultSet
- Throws:
SQLException
-
deleteRow
- Specified by:
deleteRow
in interfaceResultSet
- Throws:
SQLException
-
refreshRow
- Specified by:
refreshRow
in interfaceResultSet
- Throws:
SQLException
-
cancelRowUpdates
- Specified by:
cancelRowUpdates
in interfaceResultSet
- Throws:
SQLServerException
-
moveToInsertRow
- Specified by:
moveToInsertRow
in interfaceResultSet
- Throws:
SQLServerException
-
moveToCurrentRow
- Specified by:
moveToCurrentRow
in interfaceResultSet
- Throws:
SQLServerException
-
getStatement
- Specified by:
getStatement
in interfaceResultSet
- Throws:
SQLServerException
-
updateClob
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(String columnLabel, InputStream inputStream, long length) throws SQLException - Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateArray
- Specified by:
updateArray
in interfaceResultSet
- Throws:
SQLException
-
updateArray
- Specified by:
updateArray
in interfaceResultSet
- Throws:
SQLException
-
updateRef
- Specified by:
updateRef
in interfaceResultSet
- Throws:
SQLException
-
updateRef
- Specified by:
updateRef
in interfaceResultSet
- Throws:
SQLException
-
getURL
- Specified by:
getURL
in interfaceResultSet
- Throws:
SQLException
-
getURL
- Specified by:
getURL
in interfaceResultSet
- Throws:
SQLException
-
updateObject
- Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLServerException
-
updateObject
public void updateObject(int index, Object obj, SQLType targetSqlType, int scale) throws SQLServerException - Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLServerException
-
updateObject
public void updateObject(int index, Object obj, SQLType targetSqlType, int scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. If the second argument is an InputStream then the stream must contain the number of bytes specified by scaleOrLength. If the second argument is a Reader then the reader must contain the number of characters specified by scaleOrLength. If these conditions are not true the driver will generate a SQLServerException when the statement is executed. The default implementation will throw SQLFeatureNotSupportedException- Specified by:
updateObject
in interfaceISQLServerResultSet
- 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
public void updateObject(String columnName, Object obj, SQLType targetSqlType, int scale) throws SQLServerException - Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLServerException
-
updateObject
public void updateObject(String columnName, Object obj, SQLType targetSqlType, int scale, boolean forceEncrypt) throws SQLServerException Description copied from interface:ISQLServerResultSet
Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. If the second argument is an InputStream then the stream must contain the number of bytes specified by scaleOrLength. If the second argument is a Reader then the reader must contain the number of characters specified by scaleOrLength. If these conditions are not true the driver will generate a SQLServerException when the statement is executed. The default implementation will throw SQLFeatureNotSupportedException.- Specified by:
updateObject
in interfaceISQLServerResultSet
- 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.
-
updateObject
public void updateObject(String columnName, Object obj, SQLType targetSqlType) throws SQLServerException - Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLServerException
-