Class SQLServerResultSet
- java.lang.Object
-
- com.microsoft.sqlserver.jdbc.SQLServerResultSet
-
- All Implemented Interfaces:
ISQLServerResultSet
,Serializable
,AutoCloseable
,ResultSet
,Wrapper
public class SQLServerResultSet extends Object implements ISQLServerResultSet, Serializable
Defines the Top-level JDBC ResultSet implementation.- See Also:
- Serialized Form
-
-
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
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description boolean
absolute(int row)
Moves the cursor to the given row number in thisResultSet
object.void
afterLast()
void
beforeFirst()
void
cancelRowUpdates()
void
clearWarnings()
Clears result set warnings.void
close()
void
deleteRow()
int
findColumn(String userProvidedColumnName)
Finds a column index given a column name.boolean
first()
Moves the cursor to the first row in thisResultSet
object.Array
getArray(int i)
Array
getArray(String colName)
InputStream
getAsciiStream(int columnIndex)
InputStream
getAsciiStream(String columnName)
BigDecimal
getBigDecimal(int columnIndex)
BigDecimal
getBigDecimal(int columnIndex, int scale)
Deprecated.BigDecimal
getBigDecimal(String columnName)
BigDecimal
getBigDecimal(String columnName, int scale)
Deprecated.InputStream
getBinaryStream(int columnIndex)
InputStream
getBinaryStream(String columnName)
Blob
getBlob(int i)
Blob
getBlob(String colName)
boolean
getBoolean(int columnIndex)
boolean
getBoolean(String columnName)
byte
getByte(int columnIndex)
byte
getByte(String columnName)
byte[]
getBytes(int columnIndex)
byte[]
getBytes(String columnName)
Reader
getCharacterStream(int columnIndex)
Reader
getCharacterStream(String columnName)
Clob
getClob(int columnIndex)
Clob
getClob(String colName)
int
getConcurrency()
String
getCursorName()
Date
getDate(int columnIndex)
Date
getDate(int columnIndex, Calendar cal)
Date
getDate(String columnName)
Date
getDate(String colName, Calendar cal)
Timestamp
getDateTime(int columnIndex)
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.Timestamp
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.Timestamp
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.Timestamp
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.DateTimeOffset
getDateTimeOffset(int columnIndex)
Returns the value of the designated column as a microsoft.sql.DateTimeOffset object, given a zero-based column ordinal.DateTimeOffset
getDateTimeOffset(String columnName)
Returns the value of the column specified as a microsoft.sql.DateTimeOffset object, given a column name.double
getDouble(int columnIndex)
double
getDouble(String columnName)
int
getFetchDirection()
int
getFetchSize()
float
getFloat(int columnIndex)
float
getFloat(String columnName)
Geography
getGeography(int columnIndex)
Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geography object in the Java programming language.Geography
getGeography(String columnName)
Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geography object in the Java programming language.Geometry
getGeometry(int columnIndex)
Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geometry object in the Java programming language.Geometry
getGeometry(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
getHoldability()
int
getInt(int columnIndex)
int
getInt(String columnName)
long
getLong(int columnIndex)
long
getLong(String columnName)
ResultSetMetaData
getMetaData()
BigDecimal
getMoney(int columnIndex)
Returns the value of the column specified as a java.math.BigDecimal object.BigDecimal
getMoney(String columnName)
Returns the value of the column specified as a java.math.BigDecimal object.Reader
getNCharacterStream(int columnIndex)
Reader
getNCharacterStream(String columnLabel)
NClob
getNClob(int columnIndex)
NClob
getNClob(String columnLabel)
String
getNString(int columnIndex)
String
getNString(String columnLabel)
Object
getObject(int columnIndex)
<T> T
getObject(int columnIndex, Class<T> type)
Object
getObject(int i, Map<String,Class<?>> map)
Object
getObject(String columnName)
<T> T
getObject(String columnName, Class<T> type)
Object
getObject(String colName, Map<String,Class<?>> map)
Ref
getRef(int i)
Ref
getRef(String colName)
int
getRow()
RowId
getRowId(int columnIndex)
RowId
getRowId(String columnLabel)
SensitivityClassification
getSensitivityClassification()
Returns the Data Classification information for the current ResultSet For SQL Servers that do not support Data Classification or results that do not fetch any classified columns, this data can be null.protected int
getServerCursorId()
Returns the server cursor idshort
getShort(int columnIndex)
short
getShort(String columnName)
Timestamp
getSmallDateTime(int columnIndex)
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.Timestamp
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.Timestamp
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.Timestamp
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.BigDecimal
getSmallMoney(int columnIndex)
Returns the value of the column specified as a java.math.BigDecimal object.BigDecimal
getSmallMoney(String columnName)
Returns the value of the column specified as a java.math.BigDecimal object.SQLXML
getSQLXML(int columnIndex)
SQLXML
getSQLXML(String columnLabel)
Statement
getStatement()
String
getString(int columnIndex)
String
getString(String columnName)
Time
getTime(int columnIndex)
Time
getTime(int columnIndex, Calendar cal)
Time
getTime(String columnName)
Time
getTime(String colName, Calendar cal)
Timestamp
getTimestamp(int columnIndex)
Timestamp
getTimestamp(int columnIndex, Calendar cal)
Timestamp
getTimestamp(String columnName)
Timestamp
getTimestamp(String colName, Calendar cal)
int
getType()
InputStream
getUnicodeStream(int columnIndex)
Deprecated.InputStream
getUnicodeStream(String columnName)
Deprecated.String
getUniqueIdentifier(int columnIndex)
Returns the value of the designated column in the current row of this ResultSet object as a String object in the Java programming language.String
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.URL
getURL(int columnIndex)
URL
getURL(String sColumn)
SQLWarning
getWarnings()
void
insertRow()
boolean
isAfterLast()
boolean
isBeforeFirst()
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
isForwardOnly()
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
moveToCurrentRow()
void
moveToInsertRow()
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
refreshRow()
boolean
relative(int rows)
boolean
rowDeleted()
boolean
rowInserted()
boolean
rowUpdated()
void
setFetchDirection(int direction)
void
setFetchSize(int rows)
String
toString()
<T> T
unwrap(Class<T> iface)
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
updateInt(String columnName, int x)
void
updateInt(String columnName, int x, boolean forceEncrypt)
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
updateRef(int columnIndex, Ref x)
void
updateRef(String columnName, Ref x)
void
updateRow()
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 Detail
-
getServerCursorId
protected int getServerCursorId()
Returns the server cursor id- Returns:
- server cursor id
-
getSensitivityClassification
public SensitivityClassification getSensitivityClassification()
Description copied from interface:ISQLServerResultSet
Returns the Data Classification information for the current ResultSet For SQL Servers that do not support Data Classification or results that do not fetch any classified columns, this data can be null.- Specified by:
getSensitivityClassification
in interfaceISQLServerResultSet
- Returns:
- SensitivityClassification
-
isWrapperFor
public boolean isWrapperFor(Class<?> iface) throws SQLException
- Specified by:
isWrapperFor
in interfaceWrapper
- Throws:
SQLException
-
unwrap
public <T> T unwrap(Class<T> iface) throws SQLException
- Specified by:
unwrap
in interfaceWrapper
- Throws:
SQLException
-
isClosed
public boolean isClosed() throws SQLException
- Specified by:
isClosed
in interfaceResultSet
- Throws:
SQLException
-
isForwardOnly
protected boolean isForwardOnly()
Check if type is ForwardOnly- Returns:
- if type is ForwardOnly
-
close
public void close() throws SQLServerException
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceResultSet
- Throws:
SQLServerException
-
findColumn
public int findColumn(String userProvidedColumnName) throws SQLServerException
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
public void clearWarnings() throws SQLServerException
Clears result set warnings.- Specified by:
clearWarnings
in interfaceResultSet
- Throws:
SQLServerException
- when an error occurs
-
relative
public boolean relative(int rows) throws SQLException
- Specified by:
relative
in interfaceResultSet
- Throws:
SQLException
-
next
public boolean next() throws SQLServerException
Moves the cursor to the first row of this ResultSet object initially, then subsequent calls move the cursor to the second row, the third row, and so on.- Specified by:
next
in interfaceResultSet
- Returns:
- false when there are no more rows to read
- Throws:
SQLServerException
-
wasNull
public boolean wasNull() throws SQLServerException
- Specified by:
wasNull
in interfaceResultSet
- Throws:
SQLServerException
-
isBeforeFirst
public boolean isBeforeFirst() throws SQLException
Returns if the cursor is before the first row in this result set.- Specified by:
isBeforeFirst
in 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
public boolean isAfterLast() throws SQLException
- Specified by:
isAfterLast
in interfaceResultSet
- Throws:
SQLException
-
isFirst
public boolean isFirst() throws SQLException
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
public boolean isLast() throws SQLException
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
public void beforeFirst() throws SQLException
- Specified by:
beforeFirst
in interfaceResultSet
- Throws:
SQLException
-
afterLast
public void afterLast() throws SQLException
- Specified by:
afterLast
in interfaceResultSet
- Throws:
SQLException
-
first
public boolean first() throws SQLException
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
public boolean last() throws SQLException
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
public int getRow() throws SQLException
- Specified by:
getRow
in interfaceResultSet
- Throws:
SQLException
-
absolute
public boolean absolute(int row) throws SQLException
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
public boolean previous() throws SQLException
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
public SQLWarning getWarnings() throws SQLException
- Specified by:
getWarnings
in interfaceResultSet
- Throws:
SQLException
-
setFetchDirection
public void setFetchDirection(int direction) throws SQLException
- Specified by:
setFetchDirection
in interfaceResultSet
- Throws:
SQLException
-
getFetchDirection
public int getFetchDirection() throws SQLException
- Specified by:
getFetchDirection
in interfaceResultSet
- Throws:
SQLException
-
setFetchSize
public void setFetchSize(int rows) throws SQLServerException
- Specified by:
setFetchSize
in interfaceResultSet
- Throws:
SQLServerException
-
getFetchSize
public int getFetchSize() throws SQLException
- Specified by:
getFetchSize
in interfaceResultSet
- Throws:
SQLException
-
getType
public int getType() throws SQLServerException
- Specified by:
getType
in interfaceResultSet
- Throws:
SQLServerException
-
getConcurrency
public int getConcurrency() throws SQLServerException
- Specified by:
getConcurrency
in interfaceResultSet
- Throws:
SQLServerException
-
getAsciiStream
public InputStream getAsciiStream(int columnIndex) throws SQLServerException
- Specified by:
getAsciiStream
in interfaceResultSet
- Throws:
SQLServerException
-
getAsciiStream
public InputStream getAsciiStream(String columnName) throws SQLServerException
- Specified by:
getAsciiStream
in interfaceResultSet
- Throws:
SQLServerException
-
getBigDecimal
@Deprecated(since="6.5.4") public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLServerException
Deprecated.- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
SQLServerException
-
getBigDecimal
@Deprecated(since="6.5.4") public BigDecimal getBigDecimal(String columnName, int scale) throws SQLServerException
Deprecated.- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
SQLServerException
-
getBinaryStream
public InputStream getBinaryStream(int columnIndex) throws SQLServerException
- Specified by:
getBinaryStream
in interfaceResultSet
- Throws:
SQLServerException
-
getBinaryStream
public InputStream getBinaryStream(String columnName) throws SQLServerException
- Specified by:
getBinaryStream
in interfaceResultSet
- Throws:
SQLServerException
-
getBoolean
public boolean getBoolean(int columnIndex) throws SQLServerException
- Specified by:
getBoolean
in interfaceResultSet
- Throws:
SQLServerException
-
getBoolean
public boolean getBoolean(String columnName) throws SQLServerException
- Specified by:
getBoolean
in interfaceResultSet
- Throws:
SQLServerException
-
getByte
public byte getByte(int columnIndex) throws SQLServerException
- Specified by:
getByte
in interfaceResultSet
- Throws:
SQLServerException
-
getByte
public byte getByte(String columnName) throws SQLServerException
- Specified by:
getByte
in interfaceResultSet
- Throws:
SQLServerException
-
getBytes
public byte[] getBytes(int columnIndex) throws SQLServerException
- Specified by:
getBytes
in interfaceResultSet
- Throws:
SQLServerException
-
getBytes
public byte[] getBytes(String columnName) throws SQLServerException
- Specified by:
getBytes
in interfaceResultSet
- Throws:
SQLServerException
-
getDate
public Date getDate(int columnIndex) throws SQLServerException
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLServerException
-
getDate
public Date getDate(String columnName) throws SQLServerException
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLServerException
-
getDate
public Date getDate(int columnIndex, Calendar cal) throws SQLServerException
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLServerException
-
getDate
public Date getDate(String colName, Calendar cal) throws SQLServerException
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLServerException
-
getDouble
public double getDouble(int columnIndex) throws SQLServerException
- Specified by:
getDouble
in interfaceResultSet
- Throws:
SQLServerException
-
getDouble
public double getDouble(String columnName) throws SQLServerException
- Specified by:
getDouble
in interfaceResultSet
- Throws:
SQLServerException
-
getFloat
public float getFloat(int columnIndex) throws SQLServerException
- Specified by:
getFloat
in interfaceResultSet
- Throws:
SQLServerException
-
getFloat
public float getFloat(String columnName) throws SQLServerException
- Specified by:
getFloat
in interfaceResultSet
- Throws:
SQLServerException
-
getGeometry
public Geometry getGeometry(int columnIndex) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geometry object in the Java programming language.- Specified by:
getGeometry
in 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
public Geometry getGeometry(String columnName) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geometry object in the Java programming language.- Specified by:
getGeometry
in 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
public Geography getGeography(int columnIndex) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geography object in the Java programming language.- Specified by:
getGeography
in 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
public Geography getGeography(String columnName) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a com.microsoft.sqlserver.jdbc.Geography object in the Java programming language.- Specified by:
getGeography
in 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
public int getInt(int columnIndex) throws SQLServerException
- Specified by:
getInt
in interfaceResultSet
- Throws:
SQLServerException
-
getInt
public int getInt(String columnName) throws SQLServerException
- Specified by:
getInt
in interfaceResultSet
- Throws:
SQLServerException
-
getLong
public long getLong(int columnIndex) throws SQLServerException
- Specified by:
getLong
in interfaceResultSet
- Throws:
SQLServerException
-
getLong
public long getLong(String columnName) throws SQLServerException
- Specified by:
getLong
in interfaceResultSet
- Throws:
SQLServerException
-
getMetaData
public ResultSetMetaData getMetaData() throws SQLServerException
- Specified by:
getMetaData
in interfaceResultSet
- Throws:
SQLServerException
-
getObject
public Object getObject(int columnIndex) throws SQLServerException
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLServerException
-
getObject
public <T> T getObject(int columnIndex, Class<T> type) throws SQLException
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getObject
public Object getObject(String columnName) throws SQLServerException
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLServerException
-
getObject
public <T> T getObject(String columnName, Class<T> type) throws SQLException
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getShort
public short getShort(int columnIndex) throws SQLServerException
- Specified by:
getShort
in interfaceResultSet
- Throws:
SQLServerException
-
getShort
public short getShort(String columnName) throws SQLServerException
- Specified by:
getShort
in interfaceResultSet
- Throws:
SQLServerException
-
getString
public String getString(int columnIndex) throws SQLServerException
- Specified by:
getString
in interfaceResultSet
- Throws:
SQLServerException
-
getString
public String getString(String columnName) throws SQLServerException
- Specified by:
getString
in interfaceResultSet
- Throws:
SQLServerException
-
getNString
public String getNString(int columnIndex) throws SQLException
- Specified by:
getNString
in interfaceResultSet
- Throws:
SQLException
-
getNString
public String getNString(String columnLabel) throws SQLException
- Specified by:
getNString
in interfaceResultSet
- Throws:
SQLException
-
getUniqueIdentifier
public String getUniqueIdentifier(int columnIndex) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a String object in the Java programming language.- Specified by:
getUniqueIdentifier
in 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
public String getUniqueIdentifier(String columnLabel) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a String object in the Java programming language.- Specified by:
getUniqueIdentifier
in 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
public Time getTime(int columnIndex) throws SQLServerException
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLServerException
-
getTime
public Time getTime(String columnName) throws SQLServerException
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLServerException
-
getTime
public Time getTime(int columnIndex, Calendar cal) throws SQLServerException
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLServerException
-
getTime
public Time getTime(String colName, Calendar cal) throws SQLServerException
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLServerException
-
getTimestamp
public Timestamp getTimestamp(int columnIndex) throws SQLServerException
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLServerException
-
getTimestamp
public Timestamp getTimestamp(String columnName) throws SQLServerException
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLServerException
-
getTimestamp
public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLServerException
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLServerException
-
getTimestamp
public Timestamp getTimestamp(String colName, Calendar cal) throws SQLServerException
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLServerException
-
getDateTime
public Timestamp getDateTime(int columnIndex) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getDateTime
in 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
public Timestamp getDateTime(String columnName) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getDateTime
in 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
public Timestamp getDateTime(int columnIndex, Calendar cal) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.- Specified by:
getDateTime
in 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
public Timestamp getDateTime(String colName, Calendar cal) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.- Specified by:
getDateTime
in 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
public Timestamp getSmallDateTime(int columnIndex) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getSmallDateTime
in 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
public Timestamp getSmallDateTime(String columnName) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getSmallDateTime
in 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
public Timestamp getSmallDateTime(int columnIndex, Calendar cal) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getSmallDateTime
in 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
public Timestamp getSmallDateTime(String colName, Calendar cal) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getSmallDateTime
in 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
public DateTimeOffset getDateTimeOffset(int columnIndex) throws SQLServerException
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
public DateTimeOffset getDateTimeOffset(String columnName) throws SQLServerException
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(since="6.5.4") public InputStream getUnicodeStream(int columnIndex) throws SQLException
Deprecated.- Specified by:
getUnicodeStream
in interfaceResultSet
- Throws:
SQLException
-
getUnicodeStream
@Deprecated(since="6.5.4") public InputStream getUnicodeStream(String columnName) throws SQLException
Deprecated.- Specified by:
getUnicodeStream
in interfaceResultSet
- Throws:
SQLException
-
getObject
public Object getObject(int i, Map<String,Class<?>> map) throws SQLException
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getRef
public Ref getRef(int i) throws SQLException
- Specified by:
getRef
in interfaceResultSet
- Throws:
SQLException
-
getBlob
public Blob getBlob(int i) throws SQLServerException
- Specified by:
getBlob
in interfaceResultSet
- Throws:
SQLServerException
-
getBlob
public Blob getBlob(String colName) throws SQLServerException
- Specified by:
getBlob
in interfaceResultSet
- Throws:
SQLServerException
-
getClob
public Clob getClob(int columnIndex) throws SQLServerException
- Specified by:
getClob
in interfaceResultSet
- Throws:
SQLServerException
-
getClob
public Clob getClob(String colName) throws SQLServerException
- Specified by:
getClob
in interfaceResultSet
- Throws:
SQLServerException
-
getNClob
public NClob getNClob(int columnIndex) throws SQLException
- Specified by:
getNClob
in interfaceResultSet
- Throws:
SQLException
-
getNClob
public NClob getNClob(String columnLabel) throws SQLException
- Specified by:
getNClob
in interfaceResultSet
- Throws:
SQLException
-
getArray
public Array getArray(int i) throws SQLException
- Specified by:
getArray
in interfaceResultSet
- Throws:
SQLException
-
getObject
public Object getObject(String colName, Map<String,Class<?>> map) throws SQLException
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getRef
public Ref getRef(String colName) throws SQLException
- Specified by:
getRef
in interfaceResultSet
- Throws:
SQLException
-
getArray
public Array getArray(String colName) throws SQLException
- Specified by:
getArray
in interfaceResultSet
- Throws:
SQLException
-
getCursorName
public String getCursorName() throws SQLException
- Specified by:
getCursorName
in interfaceResultSet
- Throws:
SQLException
-
getCharacterStream
public Reader getCharacterStream(int columnIndex) throws SQLException
- Specified by:
getCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getCharacterStream
public Reader getCharacterStream(String columnName) throws SQLException
- Specified by:
getCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getNCharacterStream
public Reader getNCharacterStream(int columnIndex) throws SQLException
- Specified by:
getNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getNCharacterStream
public Reader getNCharacterStream(String columnLabel) throws SQLException
- Specified by:
getNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getBigDecimal
public BigDecimal getBigDecimal(int columnIndex) throws SQLException
- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
SQLException
-
getBigDecimal
public BigDecimal getBigDecimal(String columnName) throws SQLException
- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
SQLException
-
getMoney
public BigDecimal getMoney(int columnIndex) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Returns the value of the column specified as a java.math.BigDecimal object.- Specified by:
getMoney
in 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
public BigDecimal getMoney(String columnName) throws SQLServerException
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
public BigDecimal getSmallMoney(int columnIndex) throws SQLServerException
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
public BigDecimal getSmallMoney(String columnName) throws SQLServerException
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
public RowId getRowId(int columnIndex) throws SQLException
- Specified by:
getRowId
in interfaceResultSet
- Throws:
SQLException
-
getRowId
public RowId getRowId(String columnLabel) throws SQLException
- Specified by:
getRowId
in interfaceResultSet
- Throws:
SQLException
-
getSQLXML
public SQLXML getSQLXML(int columnIndex) throws SQLException
- Specified by:
getSQLXML
in interfaceResultSet
- Throws:
SQLException
-
getSQLXML
public SQLXML getSQLXML(String columnLabel) throws SQLException
- Specified by:
getSQLXML
in interfaceResultSet
- Throws:
SQLException
-
rowUpdated
public boolean rowUpdated() throws SQLServerException
- Specified by:
rowUpdated
in interfaceResultSet
- Throws:
SQLServerException
-
rowInserted
public boolean rowInserted() throws SQLServerException
- Specified by:
rowInserted
in interfaceResultSet
- Throws:
SQLServerException
-
rowDeleted
public boolean rowDeleted() throws SQLServerException
- Specified by:
rowDeleted
in interfaceResultSet
- Throws:
SQLServerException
-
updateNull
public void updateNull(int index) throws SQLServerException
- Specified by:
updateNull
in interfaceResultSet
- Throws:
SQLServerException
-
updateBoolean
public void updateBoolean(int index, boolean x) throws SQLException
- Specified by:
updateBoolean
in interfaceResultSet
- Throws:
SQLException
-
updateBoolean
public void updateBoolean(int index, 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:
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
public void updateByte(int index, byte x) throws SQLException
- Specified by:
updateByte
in interfaceResultSet
- Throws:
SQLException
-
updateByte
public void updateByte(int index, byte x, boolean forceEncrypt) throws SQLServerException
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
public void updateShort(int index, short x) throws SQLException
- Specified by:
updateShort
in interfaceResultSet
- Throws:
SQLException
-
updateShort
public void updateShort(int index, short x, boolean forceEncrypt) throws SQLServerException
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
public void updateInt(int index, int x) throws SQLException
- Specified by:
updateInt
in interfaceResultSet
- Throws:
SQLException
-
updateInt
public void updateInt(int index, int x, boolean forceEncrypt) throws SQLServerException
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
public void updateLong(int index, long x) throws SQLException
- Specified by:
updateLong
in interfaceResultSet
- Throws:
SQLException
-
updateLong
public void updateLong(int index, long x, boolean forceEncrypt) throws SQLServerException
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
public void updateFloat(int index, float x) throws SQLException
- Specified by:
updateFloat
in interfaceResultSet
- Throws:
SQLException
-
updateFloat
public void updateFloat(int index, float x, boolean forceEncrypt) throws SQLServerException
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
public void updateDouble(int index, double x) throws SQLException
- Specified by:
updateDouble
in interfaceResultSet
- Throws:
SQLException
-
updateDouble
public void updateDouble(int index, 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:
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
public void updateMoney(int index, BigDecimal x) 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:
index
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
SQLServerException
- when an error occurs
-
updateMoney
public void updateMoney(int index, BigDecimal x, boolean forceEncrypt) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Updates the designated column with 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
public void updateMoney(String columnName, BigDecimal x) 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 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
public void updateSmallMoney(int index, BigDecimal x) 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 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
public void updateSmallMoney(String columnName, BigDecimal x) 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 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
public void updateBigDecimal(int index, BigDecimal x) throws SQLServerException
- 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
public void updateString(int columnIndex, String stringValue) throws SQLServerException
- 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
public void updateNString(int columnIndex, String nString) throws SQLException
- 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
public void updateNString(String columnLabel, String nString) throws SQLException
- 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
public void updateBytes(int index, byte[] x) throws SQLException
- Specified by:
updateBytes
in interfaceResultSet
- Throws:
SQLException
-
updateBytes
public void updateBytes(int index, byte[] x, boolean forceEncrypt) throws SQLServerException
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
public void updateDate(int index, Date x) throws SQLServerException
- Specified by:
updateDate
in interfaceResultSet
- Throws:
SQLServerException
-
updateDate
public void updateDate(int index, Date x, boolean forceEncrypt) throws SQLServerException
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
public void updateTime(int index, Time x) throws SQLServerException
- Specified by:
updateTime
in interfaceResultSet
- Throws:
SQLServerException
-
updateTime
public void updateTime(int index, Time x, Integer scale) 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 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
public void updateTimestamp(int index, Timestamp x) throws SQLServerException
- Specified by:
updateTimestamp
in interfaceResultSet
- Throws:
SQLServerException
-
updateTimestamp
public void updateTimestamp(int index, 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:
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
public void updateDateTime(int index, Timestamp x) 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 value- Throws:
SQLServerException
- when an error occurs
-
updateDateTime
public void updateDateTime(int index, Timestamp x, Integer scale) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Updates the designated column with 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
public void updateSmallDateTime(int index, Timestamp x) 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 value- Throws:
SQLServerException
- when an error occurs
-
updateSmallDateTime
public void updateSmallDateTime(int index, Timestamp x, Integer scale) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Updates the designated column with 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
public void updateDateTimeOffset(int index, DateTimeOffset x) 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.- 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
public void updateUniqueIdentifier(int index, String x) 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 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
public void updateAsciiStream(int columnIndex, InputStream x) throws SQLException
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(int index, InputStream x, int length) throws SQLServerException
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLServerException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, InputStream x, long length) throws SQLException
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(String columnLabel, InputStream x) throws SQLException
- 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
public void updateBinaryStream(int columnIndex, InputStream x) throws SQLException
- 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
public void updateBinaryStream(int columnIndex, InputStream x, long length) throws SQLException
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(String columnLabel, InputStream x) throws SQLException
- 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
public void updateBinaryStream(String columnLabel, InputStream x, long length) throws SQLException
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(int columnIndex, Reader x) throws SQLException
- 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
public void updateCharacterStream(int columnIndex, Reader x, long length) throws SQLException
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(String columnLabel, Reader reader) throws SQLException
- 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
public void updateNCharacterStream(int columnIndex, Reader x) throws SQLException
- Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
public void updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException
- Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
public void updateNCharacterStream(String columnLabel, Reader reader) throws SQLException
- 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
public void updateObject(int index, Object obj) throws SQLServerException
- Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLServerException
-
updateObject
public void updateObject(int index, Object x, int scale) throws SQLServerException
- Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLServerException
-
updateObject
public void updateObject(int index, 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:
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
public void updateNull(String columnName) throws SQLServerException
- Specified by:
updateNull
in interfaceResultSet
- Throws:
SQLServerException
-
updateBoolean
public void updateBoolean(String columnName, boolean x) throws SQLServerException
- 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
public void updateByte(String columnName, byte x) throws SQLServerException
- Specified by:
updateByte
in interfaceResultSet
- Throws:
SQLServerException
-
updateByte
public void updateByte(String columnName, byte x, boolean forceEncrypt) throws SQLServerException
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
public void updateShort(String columnName, short x) throws SQLServerException
- Specified by:
updateShort
in interfaceResultSet
- Throws:
SQLServerException
-
updateShort
public void updateShort(String columnName, short x, boolean forceEncrypt) throws SQLServerException
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
public void updateInt(String columnName, int x) throws SQLServerException
- Specified by:
updateInt
in interfaceResultSet
- Throws:
SQLServerException
-
updateInt
public void updateInt(String columnName, int x, boolean forceEncrypt) throws SQLServerException
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
public void updateLong(String columnName, long x) throws SQLServerException
- Specified by:
updateLong
in interfaceResultSet
- Throws:
SQLServerException
-
updateLong
public void updateLong(String columnName, long x, boolean forceEncrypt) throws SQLServerException
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
public void updateFloat(String columnName, float x) throws SQLServerException
- Specified by:
updateFloat
in interfaceResultSet
- Throws:
SQLServerException
-
updateFloat
public void updateFloat(String columnName, float x, boolean forceEncrypt) throws SQLServerException
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
public void updateDouble(String columnName, double x) throws SQLServerException
- 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
public void updateBigDecimal(String columnName, BigDecimal x) throws SQLServerException
- 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
public void updateString(String columnName, String x) throws SQLServerException
- 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
public void updateBytes(String columnName, byte[] x) throws SQLServerException
- 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
public void updateDate(String columnName, Date x) throws SQLServerException
- Specified by:
updateDate
in interfaceResultSet
- Throws:
SQLServerException
-
updateDate
public void updateDate(String columnName, Date x, boolean forceEncrypt) throws SQLServerException
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
public void updateTime(String columnName, Time x) throws SQLServerException
- Specified by:
updateTime
in interfaceResultSet
- Throws:
SQLServerException
-
updateTime
public void updateTime(String columnName, Time x, int scale) 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 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
public void updateTimestamp(String columnName, Timestamp x) throws SQLServerException
- Specified by:
updateTimestamp
in interfaceResultSet
- Throws:
SQLServerException
-
updateTimestamp
public void updateTimestamp(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:
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
public void updateDateTime(String columnName, Timestamp x) 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 value- Throws:
SQLServerException
- If any errors occur.
-
updateDateTime
public void updateDateTime(String columnName, Timestamp x, int scale) throws SQLServerException
Description copied from interface:ISQLServerResultSet
Updates the designated column with 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
public void updateSmallDateTime(String columnName, Timestamp x) 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 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
public void updateDateTimeOffset(String columnName, DateTimeOffset x) 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.- 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
public void updateUniqueIdentifier(String columnName, String x) 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 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
public void updateObject(String columnName, Object x, int scale) throws SQLServerException
- 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
public void updateObject(String columnName, Object x) throws SQLServerException
- Specified by:
updateObject
in interfaceResultSet
- Throws:
SQLServerException
-
updateRowId
public void updateRowId(int columnIndex, RowId x) throws SQLException
- Specified by:
updateRowId
in interfaceResultSet
- Throws:
SQLException
-
updateRowId
public void updateRowId(String columnLabel, RowId x) throws SQLException
- Specified by:
updateRowId
in interfaceResultSet
- Throws:
SQLException
-
updateSQLXML
public void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException
- Specified by:
updateSQLXML
in interfaceResultSet
- Throws:
SQLException
-
updateSQLXML
public void updateSQLXML(String columnLabel, SQLXML x) throws SQLException
- Specified by:
updateSQLXML
in interfaceResultSet
- Throws:
SQLException
-
getHoldability
public int getHoldability() throws SQLException
- Specified by:
getHoldability
in interfaceResultSet
- Throws:
SQLException
-
insertRow
public void insertRow() throws SQLException
- Specified by:
insertRow
in interfaceResultSet
- Throws:
SQLException
-
updateRow
public void updateRow() throws SQLException
- Specified by:
updateRow
in interfaceResultSet
- Throws:
SQLException
-
deleteRow
public void deleteRow() throws SQLException
- Specified by:
deleteRow
in interfaceResultSet
- Throws:
SQLException
-
refreshRow
public void refreshRow() throws SQLException
- Specified by:
refreshRow
in interfaceResultSet
- Throws:
SQLException
-
cancelRowUpdates
public void cancelRowUpdates() throws SQLServerException
- Specified by:
cancelRowUpdates
in interfaceResultSet
- Throws:
SQLServerException
-
moveToInsertRow
public void moveToInsertRow() throws SQLServerException
- Specified by:
moveToInsertRow
in interfaceResultSet
- Throws:
SQLServerException
-
moveToCurrentRow
public void moveToCurrentRow() throws SQLServerException
- Specified by:
moveToCurrentRow
in interfaceResultSet
- Throws:
SQLServerException
-
getStatement
public Statement getStatement() throws SQLServerException
- Specified by:
getStatement
in interfaceResultSet
- Throws:
SQLServerException
-
updateClob
public void updateClob(int columnIndex, Clob clobValue) throws SQLException
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
public void updateClob(int columnIndex, Reader reader) throws SQLException
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
public void updateClob(int columnIndex, Reader reader, long length) throws SQLException
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
public void updateClob(String columnName, Clob clobValue) throws SQLException
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
public void updateClob(String columnLabel, Reader reader) throws SQLException
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
public void updateClob(String columnLabel, Reader reader, long length) throws SQLException
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
public void updateNClob(int columnIndex, NClob nClob) throws SQLException
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
public void updateNClob(int columnIndex, Reader reader) throws SQLException
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
public void updateNClob(int columnIndex, Reader reader, long length) throws SQLException
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
public void updateNClob(String columnLabel, NClob nClob) throws SQLException
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
public void updateNClob(String columnLabel, Reader reader) throws SQLException
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
public void updateNClob(String columnLabel, Reader reader, long length) throws SQLException
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(int columnIndex, Blob blobValue) throws SQLException
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(int columnIndex, InputStream inputStream) throws SQLException
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(int columnIndex, InputStream inputStream, long length) throws SQLException
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(String columnName, Blob blobValue) throws SQLException
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(String columnLabel, InputStream inputStream) throws SQLException
- 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
public void updateArray(int columnIndex, Array x) throws SQLException
- Specified by:
updateArray
in interfaceResultSet
- Throws:
SQLException
-
updateArray
public void updateArray(String columnName, Array x) throws SQLException
- Specified by:
updateArray
in interfaceResultSet
- Throws:
SQLException
-
updateRef
public void updateRef(int columnIndex, Ref x) throws SQLException
- Specified by:
updateRef
in interfaceResultSet
- Throws:
SQLException
-
updateRef
public void updateRef(String columnName, Ref x) throws SQLException
- Specified by:
updateRef
in interfaceResultSet
- Throws:
SQLException
-
getURL
public URL getURL(int columnIndex) throws SQLException
- Specified by:
getURL
in interfaceResultSet
- Throws:
SQLException
-
getURL
public URL getURL(String sColumn) throws SQLException
- Specified by:
getURL
in interfaceResultSet
- Throws:
SQLException
-
updateObject
public void updateObject(int index, Object obj, SQLType targetSqlType) throws SQLServerException
- 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
-
-