SQLServerResultSet Class

Package:

com.microsoft.sqlserver.jdbc

Maven Artifact:

com.microsoft.sqlserver:mssql-jdbc:12.2.0.jre11

• java.lang.Object
• • com.microsoft.sqlserver.jdbc.SQLServerResultSet

Implements

ISQLServerResultSet java.io.Serializable

public class SQLServerResultSet
implements ISQLServerResultSet, java.io.Serializable

Defines the Top-level JDBC ResultSet implementation.

Method Summary

Modifier and Type	Method and Description
T	getObject(int columnIndex, Class<T> type)
T	getObject(String columnName, Class<T> type)
T	unwrap(Class<T> iface)
boolean	absolute(int row) Moves the cursor to the given row number in this ResultSet 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 this ResultSet object.
java.sql.Array	getArray(int i)
java.sql.Array	getArray(String colName)
java.io.InputStream	getAsciiStream(int columnIndex)
java.io.InputStream	getAsciiStream(String columnName)
java.math.BigDecimal	getBigDecimal(int columnIndex)
java.math.BigDecimal	getBigDecimal(int columnIndex, int scale) Deprecated
java.math.BigDecimal	getBigDecimal(String columnName)
java.math.BigDecimal	getBigDecimal(String columnName, int scale) Deprecated
java.io.InputStream	getBinaryStream(int columnIndex)
java.io.InputStream	getBinaryStream(String columnName)
java.sql.Blob	getBlob(int i)
java.sql.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)
java.io.Reader	getCharacterStream(int columnIndex)
java.io.Reader	getCharacterStream(String columnName)
java.sql.Clob	getClob(int columnIndex)
java.sql.Clob	getClob(String colName)
int	getConcurrency()
java.lang.String	getCursorName()
java.sql.Date	getDate(int columnIndex)
java.sql.Date	getDate(int columnIndex, Calendar cal)
java.sql.Date	getDate(String columnName)
java.sql.Date	getDate(String colName, Calendar cal)
java.sql.Timestamp	getDateTime(int columnIndex) Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
java.sql.Timestamp	getDateTime(int columnIndex, Calendar cal) Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
java.sql.Timestamp	getDateTime(String columnName) Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
java.sql.Timestamp	getDateTime(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.
microsoft.sql.DateTimeOffset	getDateTimeOffset(int columnIndex) Returns the value of the designated column as a microsoft.sql.DateTimeOffset object, given a zero-based column ordinal.
microsoft.sql.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)
java.sql.ResultSetMetaData	getMetaData()
java.math.BigDecimal	getMoney(int columnIndex) Returns the value of the column specified as a java.math.BigDecimal object.
java.math.BigDecimal	getMoney(String columnName) Returns the value of the column specified as a java.math.BigDecimal object.
java.io.Reader	getNCharacterStream(int columnIndex)
java.io.Reader	getNCharacterStream(String columnLabel)
java.sql.NClob	getNClob(int columnIndex)
java.sql.NClob	getNClob(String columnLabel)
java.lang.String	getNString(int columnIndex)
java.lang.String	getNString(String columnLabel)
java.lang.Object	getObject(int columnIndex)
java.lang.Object	getObject(int i, Map<String,Class<?>> map)
java.lang.Object	getObject(String columnName)
java.lang.Object	getObject(String colName, Map<String,Class<?>> map)
java.sql.Ref	getRef(int i)
java.sql.Ref	getRef(String colName)
int	getRow()
java.sql.RowId	getRowId(int columnIndex)
java.sql.RowId	getRowId(String columnLabel)
java.sql.SQLXML	getSQLXML(int columnIndex)
java.sql.SQLXML	getSQLXML(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 id
short	getShort(int columnIndex)
short	getShort(String columnName)
java.sql.Timestamp	getSmallDateTime(int columnIndex) Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
java.sql.Timestamp	getSmallDateTime(int columnIndex, Calendar cal) Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
java.sql.Timestamp	getSmallDateTime(String columnName) Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
java.sql.Timestamp	getSmallDateTime(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.
java.math.BigDecimal	getSmallMoney(int columnIndex) Returns the value of the column specified as a java.math.BigDecimal object.
java.math.BigDecimal	getSmallMoney(String columnName) Returns the value of the column specified as a java.math.BigDecimal object.
java.sql.Statement	getStatement()
java.lang.String	getString(int columnIndex)
java.lang.String	getString(String columnName)
java.sql.Time	getTime(int columnIndex)
java.sql.Time	getTime(int columnIndex, Calendar cal)
java.sql.Time	getTime(String columnName)
java.sql.Time	getTime(String colName, Calendar cal)
java.sql.Timestamp	getTimestamp(int columnIndex)
java.sql.Timestamp	getTimestamp(int columnIndex, Calendar cal)
java.sql.Timestamp	getTimestamp(String columnName)
java.sql.Timestamp	getTimestamp(String colName, Calendar cal)
int	getType()
java.net.URL	getURL(int columnIndex)
java.net.URL	getURL(String sColumn)
java.io.InputStream	getUnicodeStream(int columnIndex) Deprecated
java.io.InputStream	getUnicodeStream(String columnName) Deprecated
java.lang.String	getUniqueIdentifier(int columnIndex) Returns the value of the designated column in the current row of this ResultSet object as a String object in the Java programming language.
java.lang.String	getUniqueIdentifier(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.
java.sql.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 this ResultSet object.
protected boolean	isForwardOnly() Check if type is ForwardOnly
boolean	isLast() Returns whether the cursor is on the last row of this ResultSet object.
boolean	isWrapperFor(Class<?> iface)
boolean	last() Moves the cursor to the last row in this ResultSet 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 this ResultSet object.
void	refreshRow()
boolean	relative(int rows)
boolean	rowDeleted()
boolean	rowInserted()
boolean	rowUpdated()
void	setFetchDirection(int direction)
void	setFetchSize(int rows)
java.lang.String	toString()
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 a java.math.BigDecimal value.
void	updateBigDecimal(int index, BigDecimal x, Integer precision, Integer scale, boolean forceEncrypt) Updates the designated column with a java.math.BigDecimal value.
void	updateBigDecimal(String columnName, BigDecimal x)
void	updateBigDecimal(String columnName, BigDecimal x, boolean forceEncrypt) Updates the designated column with a java.sql.BigDecimal value.
void	updateBigDecimal(String columnName, BigDecimal x, Integer precision, Integer scale) Updates the designated column with a java.sql.BigDecimal value.
void	updateBigDecimal(String columnName, BigDecimal x, Integer precision, Integer scale, boolean forceEncrypt) Updates the designated column with a java.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 a boolean value.
void	updateBoolean(String columnName, boolean x)
void	updateBoolean(String columnName, boolean x, boolean forceEncrypt) Updates the designated column with a boolean value.
void	updateByte(int index, byte x)
void	updateByte(int index, byte x, boolean forceEncrypt) Updates the designated column with a byte value.
void	updateByte(String columnName, byte x)
void	updateByte(String columnName, byte x, boolean forceEncrypt) Updates the designated column with a byte value.
void	updateBytes(int index, byte[] x)
void	updateBytes(int index, byte[] x, boolean forceEncrypt) Updates the designated column with a byte 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 a java.sql.Date value.
void	updateDate(String columnName, Date x)
void	updateDate(String columnName, Date x, boolean forceEncrypt) Updates the designated column with a java.sql.Date value.
void	updateDateTime(int index, Timestamp x) Updates the designated column with a java.sql.Timestamp value.
void	updateDateTime(int index, Timestamp x, Integer scale) Updates the designated column with a java.sql.Timestamp value.
void	updateDateTime(int index, Timestamp x, Integer scale, boolean forceEncrypt) Updates the designated column with a java.sql.Timestamp value.
void	updateDateTime(String columnName, Timestamp x) Updates the designated column with a java.sql.Timestamp value.
void	updateDateTime(String columnName, Timestamp x, int scale) Updates the designated column with a java.sql.Timestamp value.
void	updateDateTime(String columnName, Timestamp x, int scale, boolean forceEncrypt) Updates the designated column with a java.sql.Timestamp value.
void	updateDateTimeOffset(int index, DateTimeOffset x) Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.
void	updateDateTimeOffset(int index, DateTimeOffset x, 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 a double value.
void	updateDouble(String columnName, double x)
void	updateDouble(String columnName, double x, boolean forceEncrypt) Updates the designated column with a double value.
void	updateFloat(int index, float x)
void	updateFloat(int index, float x, boolean forceEncrypt) Updates the designated column with a float value.
void	updateFloat(String columnName, float x)
void	updateFloat(String columnName, float x, boolean forceEncrypt) Updates the designated column with a float value.
void	updateInt(int index, int x)
void	updateInt(int index, int x, boolean forceEncrypt) Updates the designated column with an int value.
void	updateInt(String columnName, int x)
void	updateInt(String columnName, int x, boolean forceEncrypt) Updates the designated column with an int value.
void	updateLong(int index, long x)
void	updateLong(int index, long x, boolean forceEncrypt) Updates the designated column with a long value.
void	updateLong(String columnName, long x)
void	updateLong(String columnName, long x, boolean forceEncrypt) Updates the designated column with a long value.
void	updateMoney(int index, BigDecimal x) Updates the designated column with a money value.
void	updateMoney(int index, BigDecimal x, boolean forceEncrypt) Updates the designated column with a money value.
void	updateMoney(String columnName, BigDecimal x) Updates the designated column with a money value.
void	updateMoney(String columnName, BigDecimal x, boolean forceEncrypt) Updates the designated column with a money 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 a String value.
void	updateNString(String columnLabel, String nString)
void	updateNString(String columnLabel, String nString, boolean forceEncrypt) Updates the designated column with a String 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 an Object value.
void	updateObject(int index, Object x, int precision, int scale, boolean forceEncrypt) Updates the designated column with an Object 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 an Object value.
void	updateObject(String columnName, Object x, int precision, int scale, boolean forceEncrypt) Updates the designated column with an Object 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	updateSQLXML(int columnIndex, SQLXML xmlObject)
void	updateSQLXML(String columnLabel, SQLXML x)
void	updateShort(int index, short x)
void	updateShort(int index, short x, boolean forceEncrypt) Updates the designated column with a short value.
void	updateShort(String columnName, short x)
void	updateShort(String columnName, short x, boolean forceEncrypt) Updates the designated column with a short value.
void	updateSmallDateTime(int index, Timestamp x) Updates the designated column with a java.sql.Timestamp value.
void	updateSmallDateTime(int index, Timestamp x, Integer scale) Updates the designated column with a java.sql.Timestamp value.
void	updateSmallDateTime(int index, Timestamp x, Integer scale, boolean forceEncrypt) Updates the designated column with a java.sql.Timestamp value.
void	updateSmallDateTime(String columnName, Timestamp x) Updates the designated column with a java.sql.Timestamp value.
void	updateSmallDateTime(String columnName, Timestamp x, int scale) Updates the designated column with a java.sql.Timestamp value.
void	updateSmallDateTime(String columnName, Timestamp x, int scale, boolean forceEncrypt) Updates the designated column with a java.sql.Timestamp value.
void	updateSmallMoney(int index, BigDecimal x) Updates the designated column with a smallmoney value.
void	updateSmallMoney(int index, BigDecimal x, boolean forceEncrypt) Updates the designated column with a smallmoney value.
void	updateSmallMoney(String columnName, BigDecimal x) Updates the designated column with a smallmoney value.
void	updateSmallMoney(String columnName, BigDecimal x, boolean forceEncrypt) Updates the designated column with a smallmoney value.
void	updateString(int columnIndex, String stringValue)
void	updateString(int columnIndex, String stringValue, boolean forceEncrypt) Updates the designated column with a String value.
void	updateString(String columnName, String x)
void	updateString(String columnName, String x, boolean forceEncrypt) Updates the designated column with a String value.
void	updateTime(int index, Time x)
void	updateTime(int index, Time x, Integer scale) Updates the designated column with a java.sql.Time value.
void	updateTime(int index, Time x, Integer scale, boolean forceEncrypt) Updates the designated column with a java.sql.Time value.
void	updateTime(String columnName, Time x)
void	updateTime(String columnName, Time x, int scale) Updates the designated column with a java.sql.Time value.
void	updateTime(String columnName, Time x, int scale, boolean forceEncrypt) Updates the designated column with a java.sql.Time value.
void	updateTimestamp(int index, Timestamp x)
void	updateTimestamp(int index, Timestamp x, int scale) Updates the designated column with a java.sql.Timestamp value.
void	updateTimestamp(int index, Timestamp x, int scale, boolean forceEncrypt) Updates the designated column with a java.sql.Timestamp value.
void	updateTimestamp(String columnName, Timestamp x)
void	updateTimestamp(String columnName, Timestamp x, int scale) Updates the designated column with a java.sql.Timestamp value.
void	updateTimestamp(String columnName, Timestamp x, int scale, boolean forceEncrypt) Updates the designated column with a java.sql.Timestamp value.
void	updateUniqueIdentifier(int index, String x) Updates the designated column with a String value.
void	updateUniqueIdentifier(int index, String x, boolean forceEncrypt) Updates the designated column with a String value.
void	updateUniqueIdentifier(String columnName, String x) Updates the designated column with a Stringvalue.
void	updateUniqueIdentifier(String columnName, String x, boolean forceEncrypt) Updates the designated column with a Stringvalue.
boolean	wasNull()

Methods inherited from java.lang.Object

java.lang.Object.clone java.lang.Object.equals java.lang.Object.finalize java.lang.Object.getClass java.lang.Object.hashCode java.lang.Object.notify java.lang.Object.notifyAll java.lang.Object.toString java.lang.Object.wait java.lang.Object.wait java.lang.Object.wait

Method Details

getObject

public T getObject(int columnIndex, Class type)

Parameters:

columnIndex

type

Throws:

java.sql.SQLException

getObject

public T getObject(String columnName, Class type)

Parameters:

columnName

type

Throws:

java.sql.SQLException

unwrap

public T unwrap(Class iface)

Parameters:

iface

Throws:

java.sql.SQLException

absolute

public boolean absolute(int row)

Moves the cursor to the given row number in this ResultSet 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 method absolute(-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 calling first(). Calling absolute(-1) is the same as calling last().

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 this ResultSet object; false if the cursor is before the first row or after the last row

Throws:

java.sql.SQLException

afterLast

public void afterLast()

Throws:

java.sql.SQLException

beforeFirst

public void beforeFirst()

Throws:

java.sql.SQLException

cancelRowUpdates

public void cancelRowUpdates()

Throws:

SQLServerException

clearWarnings

public void clearWarnings()

Clears result set warnings.

Throws:

SQLServerException - when an error occurs

close

public void close()

Throws:

SQLServerException

deleteRow

public void deleteRow()

Throws:

java.sql.SQLException

findColumn

public int findColumn(String userProvidedColumnName)

Finds a column index given a column name.

Parameters:

userProvidedColumnName - the name of the column

Returns:

the column index

Throws:

SQLServerException - If any errors occur.

first

public boolean first()

Moves the cursor to the first row in this ResultSet 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.

Returns:

true if the cursor is on a valid row; false if there are no rows in the result set

Throws:

java.sql.SQLException

getArray

public Array getArray(int i)

Parameters:

i

Throws:

java.sql.SQLException

getArray

public Array getArray(String colName)

Parameters:

colName

Throws:

java.sql.SQLException

getAsciiStream

public InputStream getAsciiStream(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getAsciiStream

public InputStream getAsciiStream(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex)

Parameters:

columnIndex

Throws:

java.sql.SQLException

getBigDecimal

(=6.5.4)
public BigDecimal getBigDecimal(int columnIndex, int scale)

Deprecated

Parameters:

columnIndex

scale

Throws:

SQLServerException

getBigDecimal

public BigDecimal getBigDecimal(String columnName)

Parameters:

columnName

Throws:

java.sql.SQLException

getBigDecimal

(=6.5.4)
public BigDecimal getBigDecimal(String columnName, int scale)

Deprecated

Parameters:

columnName

scale

Throws:

SQLServerException

getBinaryStream

public InputStream getBinaryStream(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getBinaryStream

public InputStream getBinaryStream(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getBlob

public Blob getBlob(int i)

Parameters:

i

Throws:

SQLServerException

getBlob

public Blob getBlob(String colName)

Parameters:

colName

Throws:

SQLServerException

getBoolean

public boolean getBoolean(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getBoolean

public boolean getBoolean(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getByte

public byte getByte(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getByte

public byte getByte(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getBytes

public byte[] getBytes(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getBytes

public byte[] getBytes(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getCharacterStream

public Reader getCharacterStream(int columnIndex)

Parameters:

columnIndex

Throws:

java.sql.SQLException

getCharacterStream

public Reader getCharacterStream(String columnName)

Parameters:

columnName

Throws:

java.sql.SQLException

getClob

public Clob getClob(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getClob

public Clob getClob(String colName)

Parameters:

colName

Throws:

SQLServerException

getConcurrency

public int getConcurrency()

Throws:

SQLServerException

getCursorName

public String getCursorName()

Throws:

java.sql.SQLException

getDate

public Date getDate(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getDate

public Date getDate(int columnIndex, Calendar cal)

Parameters:

columnIndex

cal

Throws:

SQLServerException

getDate

public Date getDate(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getDate

public Date getDate(String colName, Calendar cal)

Parameters:

colName

cal

Throws:

SQLServerException

getDateTime

public 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.

Parameters:

columnIndex

Throws:

SQLServerException

getDateTime

public 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. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.

Parameters:

columnIndex

cal

Throws:

SQLServerException

getDateTime

public 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.

Parameters:

columnName

Throws:

SQLServerException

getDateTime

public 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. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.

Parameters:

colName

cal

Throws:

SQLServerException

getDateTimeOffset

public DateTimeOffset getDateTimeOffset(int columnIndex)

Returns the value of the designated column as a microsoft.sql.DateTimeOffset object, given a zero-based column ordinal.

Parameters:

columnIndex

Throws:

SQLServerException

getDateTimeOffset

public DateTimeOffset getDateTimeOffset(String columnName)

Returns the value of the column specified as a microsoft.sql.DateTimeOffset object, given a column name.

Parameters:

columnName

Throws:

SQLServerException

getDouble

public double getDouble(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getDouble

public double getDouble(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getFetchDirection

public int getFetchDirection()

Throws:

java.sql.SQLException

getFetchSize

public int getFetchSize()

Throws:

java.sql.SQLException

getFloat

public float getFloat(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getFloat

public float getFloat(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getGeography

public 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.

Parameters:

columnIndex

Throws:

SQLServerException

getGeography

public 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.

Parameters:

columnName

Throws:

SQLServerException

getGeometry

public 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.

Parameters:

columnIndex

Throws:

SQLServerException

getGeometry

public 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.

Parameters:

columnName

Throws:

SQLServerException

getHoldability

public int getHoldability()

Throws:

java.sql.SQLException

getInt

public int getInt(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getInt

public int getInt(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getLong

public long getLong(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getLong

public long getLong(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getMetaData

public ResultSetMetaData getMetaData()

Throws:

SQLServerException

getMoney

public BigDecimal getMoney(int columnIndex)

Returns the value of the column specified as a java.math.BigDecimal object.

Parameters:

columnIndex

Throws:

SQLServerException

getMoney

public BigDecimal getMoney(String columnName)

Returns the value of the column specified as a java.math.BigDecimal object.

Parameters:

columnName

Throws:

SQLServerException

getNCharacterStream

public Reader getNCharacterStream(int columnIndex)

Parameters:

columnIndex

Throws:

java.sql.SQLException

getNCharacterStream

public Reader getNCharacterStream(String columnLabel)

Parameters:

columnLabel

Throws:

java.sql.SQLException

getNClob

public NClob getNClob(int columnIndex)

Parameters:

columnIndex

Throws:

java.sql.SQLException

getNClob

public NClob getNClob(String columnLabel)

Parameters:

columnLabel

Throws:

java.sql.SQLException

getNString

public String getNString(int columnIndex)

Parameters:

columnIndex

Throws:

java.sql.SQLException

getNString

public String getNString(String columnLabel)

Parameters:

columnLabel

Throws:

java.sql.SQLException

getObject

public Object getObject(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getObject

public Object getObject(int i, Map> map)

Parameters:

i

map

Throws:

java.sql.SQLException

getObject

public Object getObject(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getObject

public Object getObject(String colName, Map> map)

Parameters:

colName

map

Throws:

java.sql.SQLException

getRef

public Ref getRef(int i)

Parameters:

i

Throws:

java.sql.SQLException

getRef

public Ref getRef(String colName)

Parameters:

colName

Throws:

java.sql.SQLException

getRow

public int getRow()

Throws:

java.sql.SQLException

getRowId

public RowId getRowId(int columnIndex)

Parameters:

columnIndex

Throws:

java.sql.SQLException

getRowId

public RowId getRowId(String columnLabel)

Parameters:

columnLabel

Throws:

java.sql.SQLException

getSQLXML

public SQLXML getSQLXML(int columnIndex)

Parameters:

columnIndex

Throws:

java.sql.SQLException

getSQLXML

public SQLXML getSQLXML(String columnLabel)

Parameters:

columnLabel

Throws:

java.sql.SQLException

getSensitivityClassification

public 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.

getServerCursorId

protected int getServerCursorId()

Returns the server cursor id

Returns:

server cursor id

getShort

public short getShort(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getShort

public short getShort(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getSmallDateTime

public 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.

Parameters:

columnIndex

Throws:

SQLServerException

getSmallDateTime

public 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.

Parameters:

columnIndex

cal

Throws:

SQLServerException

getSmallDateTime

public 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.

Parameters:

columnName

Throws:

SQLServerException

getSmallDateTime

public 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.

Parameters:

colName

cal

Throws:

SQLServerException

getSmallMoney

public BigDecimal getSmallMoney(int columnIndex)

Returns the value of the column specified as a java.math.BigDecimal object.

Parameters:

columnIndex

Throws:

SQLServerException

getSmallMoney

public BigDecimal getSmallMoney(String columnName)

Returns the value of the column specified as a java.math.BigDecimal object.

Parameters:

columnName

Throws:

SQLServerException

getStatement

public Statement getStatement()

Throws:

SQLServerException

getString

public String getString(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getString

public String getString(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getTime

public Time getTime(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getTime

public Time getTime(int columnIndex, Calendar cal)

Parameters:

columnIndex

cal

Throws:

SQLServerException

getTime

public Time getTime(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getTime

public Time getTime(String colName, Calendar cal)

Parameters:

colName

cal

Throws:

SQLServerException

getTimestamp

public Timestamp getTimestamp(int columnIndex)

Parameters:

columnIndex

Throws:

SQLServerException

getTimestamp

public Timestamp getTimestamp(int columnIndex, Calendar cal)

Parameters:

columnIndex

cal

Throws:

SQLServerException

getTimestamp

public Timestamp getTimestamp(String columnName)

Parameters:

columnName

Throws:

SQLServerException

getTimestamp

public Timestamp getTimestamp(String colName, Calendar cal)

Parameters:

colName

cal

Throws:

SQLServerException

getType

public int getType()

Throws:

SQLServerException

getURL

public URL getURL(int columnIndex)

Parameters:

columnIndex

Throws:

java.sql.SQLException

getURL

public URL getURL(String sColumn)

Parameters:

sColumn

Throws:

java.sql.SQLException

getUnicodeStream

(=6.5.4)
public InputStream getUnicodeStream(int columnIndex)

Deprecated

Parameters:

columnIndex

Throws:

java.sql.SQLException

getUnicodeStream

(=6.5.4)
public InputStream getUnicodeStream(String columnName)

Deprecated

Parameters:

columnName

Throws:

java.sql.SQLException

getUniqueIdentifier

public 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.

Parameters:

columnIndex

Throws:

SQLServerException

getUniqueIdentifier

public 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.

Parameters:

columnLabel

Throws:

SQLServerException

getWarnings

public SQLWarning getWarnings()

Throws:

java.sql.SQLException

insertRow

public void insertRow()

Throws:

java.sql.SQLException

isAfterLast

public boolean isAfterLast()

Throws:

java.sql.SQLException

isBeforeFirst

public boolean isBeforeFirst()

Returns if the cursor is before the first row in this result set.

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:

java.sql.SQLException

isClosed

public boolean isClosed()

Throws:

java.sql.SQLException

isFirst

public boolean isFirst()

Returns whether the cursor is on the first row of this ResultSet 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 for ResultSets with a result set type of TYPE_FORWARD_ONLY

Returns:

true if the cursor is on the first row; false otherwise

Throws:

java.sql.SQLException

isForwardOnly

protected boolean isForwardOnly()

Check if type is ForwardOnly

Returns:

if type is ForwardOnly

isLast

public boolean isLast()

Returns whether the cursor is on the last row of this ResultSet object. Note: Calling the method isLast 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 the isLast method is optional for ResultSets with a result set type of TYPE_FORWARD_ONLY

Returns:

true if the cursor is on the last row; false otherwise

Throws:

java.sql.SQLException

isWrapperFor

public boolean isWrapperFor(Class iface)

Parameters:

iface

Throws:

java.sql.SQLException

last

public boolean last()

Moves the cursor to the last row in this ResultSet 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.

Returns:

true if the cursor is on a valid row; false if there are no rows in the result set

Throws:

java.sql.SQLException

moveToCurrentRow

public void moveToCurrentRow()

Throws:

SQLServerException

moveToInsertRow

public void moveToInsertRow()

Throws:

SQLServerException

next

public 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.

Returns:

false when there are no more rows to read

Throws:

SQLServerException

previous

public boolean previous()

Moves the cursor to the previous row in this ResultSet 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.

Returns:

true if the cursor is now positioned on a valid row; false if the cursor is positioned before the first row

Throws:

java.sql.SQLException

refreshRow

public void refreshRow()

Throws:

java.sql.SQLException

relative

public boolean relative(int rows)

Parameters:

rows

Throws:

java.sql.SQLException

rowDeleted

public boolean rowDeleted()

Throws:

SQLServerException

rowInserted

public boolean rowInserted()

Throws:

SQLServerException

rowUpdated

public boolean rowUpdated()

Throws:

SQLServerException

setFetchDirection

public void setFetchDirection(int direction)

Parameters:

direction

Throws:

java.sql.SQLException

setFetchSize

public void setFetchSize(int rows)

Parameters:

rows

Throws:

SQLServerException

toString

public String toString()

Overrides:

SQLServerResultSet.toString()

updateArray

public void updateArray(int columnIndex, Array x)

Parameters:

columnIndex

x

Throws:

java.sql.SQLException

updateArray

public void updateArray(String columnName, Array x)

Parameters:

columnName

x

Throws:

java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int columnIndex, InputStream x)

Parameters:

columnIndex

x

Throws:

java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(int index, InputStream x, int length)

Parameters:

index

x

length

Throws:

SQLServerException

updateAsciiStream

public void updateAsciiStream(int columnIndex, InputStream x, long length)

Parameters:

columnIndex

x

length

Throws:

java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(String columnLabel, InputStream x)

Parameters:

columnLabel

x

Throws:

java.sql.SQLException

updateAsciiStream

public void updateAsciiStream(String columnName, InputStream x, int length)

Parameters:

columnName

x

length

Throws:

SQLServerException

updateAsciiStream

public void updateAsciiStream(String columnName, InputStream streamValue, long length)

Parameters:

columnName

streamValue

length

Throws:

java.sql.SQLException

updateBigDecimal

public void updateBigDecimal(int index, BigDecimal x)

Parameters:

index

x

Throws:

SQLServerException

updateBigDecimal

public void updateBigDecimal(int index, BigDecimal x, Integer precision, Integer scale)

Updates the designated column with a java.math.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

precision

scale

Throws:

SQLServerException

updateBigDecimal

public void updateBigDecimal(int index, BigDecimal x, Integer precision, Integer scale, boolean forceEncrypt)

Updates the designated column with a java.math.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

precision

scale

forceEncrypt

Throws:

SQLServerException

updateBigDecimal

public void updateBigDecimal(String columnName, BigDecimal x)

Parameters:

columnName

x

Throws:

SQLServerException

updateBigDecimal

public void updateBigDecimal(String columnName, BigDecimal x, boolean forceEncrypt)

Updates the designated column with a java.sql.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateBigDecimal

public void updateBigDecimal(String columnName, BigDecimal x, Integer precision, Integer scale)

Updates the designated column with a java.sql.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

precision

scale

Throws:

SQLServerException

updateBigDecimal

public void updateBigDecimal(String columnName, BigDecimal x, Integer precision, Integer scale, boolean forceEncrypt)

Updates the designated column with a java.sql.BigDecimal value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

precision

scale

forceEncrypt

Throws:

SQLServerException

updateBinaryStream

public void updateBinaryStream(int columnIndex, InputStream x)

Parameters:

columnIndex

x

Throws:

java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex, InputStream streamValue, int length)

Parameters:

columnIndex

streamValue

length

Throws:

java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(int columnIndex, InputStream x, long length)

Parameters:

columnIndex

x

length

Throws:

java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(String columnLabel, InputStream x)

Parameters:

columnLabel

x

Throws:

java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(String columnName, InputStream streamValue, int length)

Parameters:

columnName

streamValue

length

Throws:

java.sql.SQLException

updateBinaryStream

public void updateBinaryStream(String columnLabel, InputStream x, long length)

Parameters:

columnLabel

x

length

Throws:

java.sql.SQLException

updateBlob

public void updateBlob(int columnIndex, InputStream inputStream)

Parameters:

columnIndex

inputStream

Throws:

java.sql.SQLException

updateBlob

public void updateBlob(int columnIndex, InputStream inputStream, long length)

Parameters:

columnIndex

inputStream

length

Throws:

java.sql.SQLException

updateBlob

public void updateBlob(int columnIndex, Blob blobValue)

Parameters:

columnIndex

blobValue

Throws:

java.sql.SQLException

updateBlob

public void updateBlob(String columnLabel, InputStream inputStream)

Parameters:

columnLabel

inputStream

Throws:

java.sql.SQLException

updateBlob

public void updateBlob(String columnLabel, InputStream inputStream, long length)

Parameters:

columnLabel

inputStream

length

Throws:

java.sql.SQLException

updateBlob

public void updateBlob(String columnName, Blob blobValue)

Parameters:

columnName

blobValue

Throws:

java.sql.SQLException

updateBoolean

public void updateBoolean(int index, boolean x)

Parameters:

index

x

Throws:

java.sql.SQLException

updateBoolean

public void updateBoolean(int index, boolean x, boolean forceEncrypt)

Updates the designated column with a boolean value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

forceEncrypt

Throws:

SQLServerException

updateBoolean

public void updateBoolean(String columnName, boolean x)

Parameters:

columnName

x

Throws:

SQLServerException

updateBoolean

public void updateBoolean(String columnName, boolean x, boolean forceEncrypt)

Updates the designated column with a boolean value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateByte

public void updateByte(int index, byte x)

Parameters:

index

x

Throws:

java.sql.SQLException

updateByte

public void updateByte(int index, byte x, boolean forceEncrypt)

Updates the designated column with a byte value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

forceEncrypt

Throws:

SQLServerException

updateByte

public void updateByte(String columnName, byte x)

Parameters:

columnName

x

Throws:

SQLServerException

updateByte

public void updateByte(String columnName, byte x, boolean forceEncrypt)

Updates the designated column with a byte value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateBytes

public void updateBytes(int index, byte[] x)

Parameters:

index

x

Throws:

java.sql.SQLException

updateBytes

public void updateBytes(int index, byte[] x, boolean forceEncrypt)

Updates the designated column with a byte array value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

forceEncrypt

Throws:

SQLServerException

updateBytes

public void updateBytes(String columnName, byte[] x)

Parameters:

columnName

x

Throws:

SQLServerException

updateBytes

public void updateBytes(String columnName, byte[] x, boolean forceEncrypt)

Updates the designated column with a byte array value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateCharacterStream

public void updateCharacterStream(int columnIndex, Reader x)

Parameters:

columnIndex

x

Throws:

java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(int columnIndex, Reader readerValue, int length)

Parameters:

columnIndex

readerValue

length

Throws:

SQLServerException

updateCharacterStream

public void updateCharacterStream(int columnIndex, Reader x, long length)

Parameters:

columnIndex

x

length

Throws:

java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(String columnLabel, Reader reader)

Parameters:

columnLabel

reader

Throws:

java.sql.SQLException

updateCharacterStream

public void updateCharacterStream(String columnName, Reader readerValue, int length)

Parameters:

columnName

readerValue

length

Throws:

SQLServerException

updateCharacterStream

public void updateCharacterStream(String columnLabel, Reader reader, long length)

Parameters:

columnLabel

reader

length

Throws:

java.sql.SQLException

updateClob

public void updateClob(int columnIndex, Reader reader)

Parameters:

columnIndex

reader

Throws:

java.sql.SQLException

updateClob

public void updateClob(int columnIndex, Reader reader, long length)

Parameters:

columnIndex

reader

length

Throws:

java.sql.SQLException

updateClob

public void updateClob(int columnIndex, Clob clobValue)

Parameters:

columnIndex

clobValue

Throws:

java.sql.SQLException

updateClob

public void updateClob(String columnLabel, Reader reader)

Parameters:

columnLabel

reader

Throws:

java.sql.SQLException

updateClob

public void updateClob(String columnLabel, Reader reader, long length)

Parameters:

columnLabel

reader

length

Throws:

java.sql.SQLException

updateClob

public void updateClob(String columnName, Clob clobValue)

Parameters:

columnName

clobValue

Throws:

java.sql.SQLException

updateDate

public void updateDate(int index, Date x)

Parameters:

index

x

Throws:

SQLServerException

updateDate

public void updateDate(int index, Date x, boolean forceEncrypt)

Updates the designated column with a java.sql.Date value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

forceEncrypt

Throws:

SQLServerException

updateDate

public void updateDate(String columnName, Date x)

Parameters:

columnName

x

Throws:

SQLServerException

updateDate

public void updateDate(String columnName, Date x, boolean forceEncrypt)

Updates the designated column with a java.sql.Date value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateDateTime

public void updateDateTime(int index, Timestamp x)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

Throws:

SQLServerException

updateDateTime

public void updateDateTime(int index, Timestamp x, Integer scale)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

scale

Throws:

SQLServerException

updateDateTime

public void updateDateTime(int index, Timestamp x, Integer scale, boolean forceEncrypt)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

scale

forceEncrypt

Throws:

SQLServerException

updateDateTime

public void updateDateTime(String columnName, Timestamp x)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

Throws:

SQLServerException

updateDateTime

public void updateDateTime(String columnName, Timestamp x, int scale)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

scale

Throws:

SQLServerException

updateDateTime

public void updateDateTime(String columnName, Timestamp x, int scale, boolean forceEncrypt)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

scale

forceEncrypt

Throws:

SQLServerException

updateDateTimeOffset

public void updateDateTimeOffset(int index, DateTimeOffset x)

Updates the value of the column specified to the DateTimeOffset Class value, given a zero-based column ordinal.

Parameters:

index

x

Throws:

SQLServerException

updateDateTimeOffset

public 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.

Parameters:

index

x

scale

Throws:

SQLServerException

updateDateTimeOffset

public 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.

Parameters:

index

x

scale

forceEncrypt

Throws:

SQLServerException

updateDateTimeOffset

public void updateDateTimeOffset(String columnName, DateTimeOffset x)

Updates the value of the column specified to the DateTimeOffset Class value, given a column name.

Parameters:

columnName

x

Throws:

SQLServerException

updateDateTimeOffset

public void updateDateTimeOffset(String columnName, DateTimeOffset x, int scale)

Updates the value of the column specified to the DateTimeOffset Class value, given a column name.

Parameters:

columnName

x

scale

Throws:

SQLServerException

updateDateTimeOffset

public 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.

Parameters:

columnName

x

scale

forceEncrypt

Throws:

SQLServerException

updateDouble

public void updateDouble(int index, double x)

Parameters:

index

x

Throws:

java.sql.SQLException

updateDouble

public void updateDouble(int index, double x, boolean forceEncrypt)

Updates the designated column with a double value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

forceEncrypt

Throws:

SQLServerException

updateDouble

public void updateDouble(String columnName, double x)

Parameters:

columnName

x

Throws:

SQLServerException

updateDouble

public void updateDouble(String columnName, double x, boolean forceEncrypt)

Updates the designated column with a double value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateFloat

public void updateFloat(int index, float x)

Parameters:

index

x

Throws:

java.sql.SQLException

updateFloat

public void updateFloat(int index, float x, boolean forceEncrypt)

Updates the designated column with a float value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

forceEncrypt

Throws:

SQLServerException

updateFloat

public void updateFloat(String columnName, float x)

Parameters:

columnName

x

Throws:

SQLServerException

updateFloat

public void updateFloat(String columnName, float x, boolean forceEncrypt)

Updates the designated column with a float value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateInt

public void updateInt(int index, int x)

Parameters:

index

x

Throws:

java.sql.SQLException

updateInt

public void updateInt(int index, int x, boolean forceEncrypt)

Updates the designated column with an int value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

forceEncrypt

Throws:

SQLServerException

updateInt

public void updateInt(String columnName, int x)

Parameters:

columnName

x

Throws:

SQLServerException

updateInt

public void updateInt(String columnName, int x, boolean forceEncrypt)

Updates the designated column with an int value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateLong

public void updateLong(int index, long x)

Parameters:

index

x

Throws:

java.sql.SQLException

updateLong

public void updateLong(int index, long x, boolean forceEncrypt)

Updates the designated column with a long value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

forceEncrypt

Throws:

SQLServerException

updateLong

public void updateLong(String columnName, long x)

Parameters:

columnName

x

Throws:

SQLServerException

updateLong

public void updateLong(String columnName, long x, boolean forceEncrypt)

Updates the designated column with a long value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateMoney

public void updateMoney(int index, BigDecimal x)

Updates the designated column with a money value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

Throws:

SQLServerException

updateMoney

public void updateMoney(int index, BigDecimal x, boolean forceEncrypt)

Updates the designated column with a money value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

forceEncrypt

Throws:

SQLServerException

updateMoney

public void updateMoney(String columnName, BigDecimal x)

Updates the designated column with a money value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

Throws:

SQLServerException

updateMoney

public void updateMoney(String columnName, BigDecimal x, boolean forceEncrypt)

Updates the designated column with a money value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex, Reader x)

Parameters:

columnIndex

x

Throws:

java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(int columnIndex, Reader x, long length)

Parameters:

columnIndex

x

length

Throws:

java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(String columnLabel, Reader reader)

Parameters:

columnLabel

reader

Throws:

java.sql.SQLException

updateNCharacterStream

public void updateNCharacterStream(String columnLabel, Reader reader, long length)

Parameters:

columnLabel

reader

length

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex, Reader reader)

Parameters:

columnIndex

reader

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex, Reader reader, long length)

Parameters:

columnIndex

reader

length

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(int columnIndex, NClob nClob)

Parameters:

columnIndex

nClob

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(String columnLabel, Reader reader)

Parameters:

columnLabel

reader

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(String columnLabel, Reader reader, long length)

Parameters:

columnLabel

reader

length

Throws:

java.sql.SQLException

updateNClob

public void updateNClob(String columnLabel, NClob nClob)

Parameters:

columnLabel

nClob

Throws:

java.sql.SQLException

updateNString

public void updateNString(int columnIndex, String nString)

Parameters:

columnIndex

nString

Throws:

java.sql.SQLException

updateNString

public void updateNString(int columnIndex, String nString, boolean forceEncrypt)

Updates the designated column with a String value. It is intended for use when updating NCHAR,NVARCHAR and LONGNVARCHAR columns. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnIndex

nString

forceEncrypt

Throws:

SQLServerException

updateNString

public void updateNString(String columnLabel, String nString)

Parameters:

columnLabel

nString

Throws:

java.sql.SQLException

updateNString

public void updateNString(String columnLabel, String nString, boolean forceEncrypt)

Updates the designated column with a String value. It is intended for use when updating NCHAR,NVARCHAR and LONGNVARCHAR columns. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnLabel

nString

forceEncrypt

Throws:

SQLServerException

updateNull

public void updateNull(int index)

Parameters:

index

Throws:

SQLServerException

updateNull

public void updateNull(String columnName)

Parameters:

columnName

Throws:

SQLServerException

updateObject

public void updateObject(int index, Object obj)

Parameters:

index

obj

Throws:

SQLServerException

updateObject

public void updateObject(int index, Object x, int scale)

Parameters:

index

x

scale

Throws:

SQLServerException

updateObject

public void updateObject(int index, Object x, int precision, int scale)

Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

precision

scale

Throws:

SQLServerException

updateObject

public void updateObject(int index, Object x, int precision, int scale, boolean forceEncrypt)

Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

precision

scale

forceEncrypt

Throws:

SQLServerException

updateObject

public void updateObject(int index, Object obj, SQLType targetSqlType)

Parameters:

index

obj

targetSqlType

Throws:

SQLServerException

updateObject

public void updateObject(int index, Object obj, SQLType targetSqlType, int scale)

Parameters:

index

obj

targetSqlType

scale

Throws:

SQLServerException

updateObject

public void updateObject(int index, Object obj, SQLType targetSqlType, int scale, boolean forceEncrypt)

Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. If the second argument is an InputStream then the stream must contain the number of bytes specified by scaleOrLength. If the second argument is a Reader then the reader must contain the number of characters specified by scaleOrLength. If these conditions are not true the driver will generate a SQLServerException when the statement is executed. The default implementation will throw SQLFeatureNotSupportedException

Parameters:

index

obj

targetSqlType

scale

forceEncrypt

Throws:

SQLServerException

updateObject

public void updateObject(String columnName, Object x)

Parameters:

columnName

x

Throws:

SQLServerException

updateObject

public void updateObject(String columnName, Object x, int scale)

Parameters:

columnName

x

scale

Throws:

SQLServerException

updateObject

public void updateObject(String columnName, Object x, int precision, int scale)

Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

precision

scale

Throws:

SQLServerException

updateObject

public void updateObject(String columnName, Object x, int precision, int scale, boolean forceEncrypt)

Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

precision

scale

forceEncrypt

Throws:

SQLServerException

updateObject

public void updateObject(String columnName, Object obj, SQLType targetSqlType)

Parameters:

columnName

obj

targetSqlType

Throws:

SQLServerException

updateObject

public void updateObject(String columnName, Object obj, SQLType targetSqlType, int scale)

Parameters:

columnName

obj

targetSqlType

scale

Throws:

SQLServerException

updateObject

public void updateObject(String columnName, Object obj, SQLType targetSqlType, int scale, boolean forceEncrypt)

Updates the designated column with an Object value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database. If the second argument is an InputStream then the stream must contain the number of bytes specified by scaleOrLength. If the second argument is a Reader then the reader must contain the number of characters specified by scaleOrLength. If these conditions are not true the driver will generate a SQLServerException when the statement is executed. The default implementation will throw SQLFeatureNotSupportedException.

Parameters:

columnName

obj

targetSqlType

scale

forceEncrypt

Throws:

SQLServerException

updateRef

public void updateRef(int columnIndex, Ref x)

Parameters:

columnIndex

x

Throws:

java.sql.SQLException

updateRef

public void updateRef(String columnName, Ref x)

Parameters:

columnName

x

Throws:

java.sql.SQLException

updateRow

public void updateRow()

Throws:

java.sql.SQLException

updateRowId

public void updateRowId(int columnIndex, RowId x)

Parameters:

columnIndex

x

Throws:

java.sql.SQLException

updateRowId

public void updateRowId(String columnLabel, RowId x)

Parameters:

columnLabel

x

Throws:

java.sql.SQLException

updateSQLXML

public void updateSQLXML(int columnIndex, SQLXML xmlObject)

Parameters:

columnIndex

xmlObject

Throws:

java.sql.SQLException

updateSQLXML

public void updateSQLXML(String columnLabel, SQLXML x)

Parameters:

columnLabel

x

Throws:

java.sql.SQLException

updateShort

public void updateShort(int index, short x)

Parameters:

index

x

Throws:

java.sql.SQLException

updateShort

public void updateShort(int index, short x, boolean forceEncrypt)

Updates the designated column with a short value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

forceEncrypt

Throws:

SQLServerException

updateShort

public void updateShort(String columnName, short x)

Parameters:

columnName

x

Throws:

SQLServerException

updateShort

public void updateShort(String columnName, short x, boolean forceEncrypt)

Updates the designated column with a short value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateSmallDateTime

public void updateSmallDateTime(int index, Timestamp x)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

Throws:

SQLServerException

updateSmallDateTime

public void updateSmallDateTime(int index, Timestamp x, Integer scale)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

scale

Throws:

SQLServerException

updateSmallDateTime

public void updateSmallDateTime(int index, Timestamp x, Integer scale, boolean forceEncrypt)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

scale

forceEncrypt

Throws:

SQLServerException

updateSmallDateTime

public void updateSmallDateTime(String columnName, Timestamp x)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

Throws:

SQLServerException

updateSmallDateTime

public void updateSmallDateTime(String columnName, Timestamp x, int scale)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

scale

Throws:

SQLServerException

updateSmallDateTime

public void updateSmallDateTime(String columnName, Timestamp x, int scale, boolean forceEncrypt)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

scale

forceEncrypt

Throws:

SQLServerException

updateSmallMoney

public void updateSmallMoney(int index, BigDecimal x)

Updates the designated column with a smallmoney value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

Throws:

SQLServerException

updateSmallMoney

public void updateSmallMoney(int index, BigDecimal x, boolean forceEncrypt)

Updates the designated column with a smallmoney value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

forceEncrypt

Throws:

SQLServerException

updateSmallMoney

public void updateSmallMoney(String columnName, BigDecimal x)

Updates the designated column with a smallmoney value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

Throws:

SQLServerException

updateSmallMoney

public void updateSmallMoney(String columnName, BigDecimal x, boolean forceEncrypt)

Updates the designated column with a smallmoney value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateString

public void updateString(int columnIndex, String stringValue)

Parameters:

columnIndex

stringValue

Throws:

SQLServerException

updateString

public void updateString(int columnIndex, String stringValue, boolean forceEncrypt)

Updates the designated column with a String value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnIndex

stringValue

forceEncrypt

Throws:

SQLServerException

updateString

public void updateString(String columnName, String x)

Parameters:

columnName

x

Throws:

SQLServerException

updateString

public void updateString(String columnName, String x, boolean forceEncrypt)

Updates the designated column with a String value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

updateTime

public void updateTime(int index, Time x)

Parameters:

index

x

Throws:

SQLServerException

updateTime

public void updateTime(int index, Time x, Integer scale)

Updates the designated column with a java.sql.Time value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

scale

Throws:

SQLServerException

updateTime

public void updateTime(int index, Time x, Integer scale, boolean forceEncrypt)

Updates the designated column with a java.sql.Time value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

scale

forceEncrypt

Throws:

SQLServerException

updateTime

public void updateTime(String columnName, Time x)

Parameters:

columnName

x

Throws:

SQLServerException

updateTime

public void updateTime(String columnName, Time x, int scale)

Updates the designated column with a java.sql.Time value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

scale

Throws:

SQLServerException

updateTime

public void updateTime(String columnName, Time x, int scale, boolean forceEncrypt)

Updates the designated column with a java.sql.Time value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

scale

forceEncrypt

Throws:

SQLServerException

updateTimestamp

public void updateTimestamp(int index, Timestamp x)

Parameters:

index

x

Throws:

SQLServerException

updateTimestamp

public void updateTimestamp(int index, Timestamp x, int scale)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

scale

Throws:

SQLServerException

updateTimestamp

public void updateTimestamp(int index, Timestamp x, int scale, boolean forceEncrypt)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

scale

forceEncrypt

Throws:

SQLServerException

updateTimestamp

public void updateTimestamp(String columnName, Timestamp x)

Parameters:

columnName

x

Throws:

SQLServerException

updateTimestamp

public void updateTimestamp(String columnName, Timestamp x, int scale)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

scale

Throws:

SQLServerException

updateTimestamp

public void updateTimestamp(String columnName, Timestamp x, int scale, boolean forceEncrypt)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

scale

forceEncrypt

Throws:

SQLServerException

updateUniqueIdentifier

public void updateUniqueIdentifier(int index, String x)

Updates the designated column with a String value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

Throws:

SQLServerException

updateUniqueIdentifier

public void updateUniqueIdentifier(int index, String x, boolean forceEncrypt)

Updates the designated column with a String value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

index

x

forceEncrypt

Throws:

SQLServerException

updateUniqueIdentifier

public void updateUniqueIdentifier(String columnName, String x)

Updates the designated column with a Stringvalue. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

Throws:

SQLServerException

updateUniqueIdentifier

public void updateUniqueIdentifier(String columnName, String x, boolean forceEncrypt)

Updates the designated column with a Stringvalue. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:

columnName

x

forceEncrypt

Throws:

SQLServerException

wasNull

public boolean wasNull()

Throws:

SQLServerException