Package com.microsoft.sqlserver.jdbc

Interface ISQLServerResultSet42

All Superinterfaces:

AutoCloseable, ISQLServerResultSet, ResultSet, Wrapper

All Known Implementing Classes:

SQLServerResultSet42

public interface ISQLServerResultSet42
extends ISQLServerResultSet

This interface requires all the ResultSet methods including those are specific to JDBC 4.2

Field Summary

Fields inherited from interface com.microsoft.sqlserver.jdbc.ISQLServerResultSet

CONCUR_SS_OPTIMISTIC_CC, CONCUR_SS_OPTIMISTIC_CCVAL, CONCUR_SS_SCROLL_LOCKS, TYPE_SS_DIRECT_FORWARD_ONLY, TYPE_SS_SCROLL_DYNAMIC, TYPE_SS_SCROLL_KEYSET, TYPE_SS_SCROLL_STATIC, TYPE_SS_SERVER_CURSOR_FORWARD_ONLY

Fields inherited from interface java.sql.ResultSet

CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Method Summary

Modifier and Type	Method	Description
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 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.

Methods inherited from interface com.microsoft.sqlserver.jdbc.ISQLServerResultSet

getDateTimeOffset, getDateTimeOffset, updateDateTimeOffset, updateDateTimeOffset

Methods inherited from interface java.sql.ResultSet

absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Method Detail

updateObject

void updateObject(int index,
                  Object obj,
                  SQLType targetSqlType)
           throws SQLServerException

Specified by:

updateObject in interface ResultSet

Throws:

SQLServerException

updateObject

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

Specified by:

updateObject in interface ResultSet

Throws:

SQLServerException

updateObject

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

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

Parameters:

index - the first column is 1, the second is 2, ...

obj - the new column value

targetSqlType - the SQL type to be sent to the database

scale - for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.

forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement.If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.

Throws:

SQLServerException - If any errors occur.

updateObject

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

Specified by:

updateObject in interface ResultSet

Throws:

SQLServerException

updateObject

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

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

Parameters:

columnName - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

obj - the new column value

targetSqlType - the SQL type to be sent to the database

scale - for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.

forceEncrypt - If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always Encrypted is enabled on the connection or on the statement.If the boolean forceEncrypt is set to false, the driver will not force encryption on parameters.

Throws:

SQLServerException - If any errors occur.

updateObject

void updateObject(String columnName,
                  Object obj,
                  SQLType targetSqlType)
           throws SQLServerException

Specified by:

updateObject in interface ResultSet

Throws:

SQLServerException