ISQLServerCallableStatement
, ISQLServerPreparedStatement
, ISQLServerStatement
, java.lang.AutoCloseable
, java.sql.CallableStatement
, java.sql.PreparedStatement
, java.sql.Statement
, java.sql.Wrapper
public class SQLServerCallableStatement extends SQLServerPreparedStatement implements ISQLServerCallableStatement
The API javadoc for JDBC API methods that this class implements are not repeated here. Please see Sun's JDBC API interfaces javadoc for those details.
stmtColumnEncriptionSetting
Modifier and Type | Method | Description |
---|---|---|
java.sql.Array |
getArray(int parameterIndex) |
|
java.sql.Array |
getArray(java.lang.String parameterName) |
|
java.io.InputStream |
getAsciiStream(int parameterIndex) |
Returns the value of the designated column in the current row of this
ResultSet object as a stream
of ASCII characters. |
java.io.InputStream |
getAsciiStream(java.lang.String parameterName) |
Returns the value of the designated column in the current row of this
ResultSet object as a stream
of ASCII characters. |
java.math.BigDecimal |
getBigDecimal(int parameterIndex) |
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale) |
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String parameterName) |
|
java.math.BigDecimal |
getBigDecimal(java.lang.String parameterName,
int scale) |
Deprecated.
|
java.io.InputStream |
getBinaryStream(int parameterIndex) |
Returns the value of the designated column in the current row of this
ResultSet object as a stream
of uninterpreted bytes. |
java.io.InputStream |
getBinaryStream(java.lang.String parameterName) |
Returns the value of the designated column in the current row of this
ResultSet object as a stream
of uninterpreted byte s. |
java.sql.Blob |
getBlob(int parameterIndex) |
|
java.sql.Blob |
getBlob(java.lang.String parameterName) |
|
boolean |
getBoolean(int index) |
|
boolean |
getBoolean(java.lang.String parameterName) |
|
byte |
getByte(int index) |
|
byte |
getByte(java.lang.String parameterName) |
|
byte[] |
getBytes(int index) |
|
byte[] |
getBytes(java.lang.String parameterName) |
|
java.io.Reader |
getCharacterStream(int parameterIndex) |
|
java.io.Reader |
getCharacterStream(java.lang.String parameterName) |
|
java.sql.Clob |
getClob(int parameterIndex) |
|
java.sql.Clob |
getClob(java.lang.String parameterName) |
|
java.sql.Date |
getDate(int index) |
|
java.sql.Date |
getDate(int index,
java.util.Calendar cal) |
|
java.sql.Date |
getDate(java.lang.String parameterName) |
|
java.sql.Date |
getDate(java.lang.String parameterName,
java.util.Calendar cal) |
|
java.sql.Timestamp |
getDateTime(int index) |
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 index,
java.util.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(java.lang.String parameterName) |
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(java.lang.String name,
java.util.Calendar cal) |
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp
object in the Java programming language.
|
DateTimeOffset |
getDateTimeOffset(int index) |
Returns the DateTimeOffset value of parameter with index parameterIndex.
|
DateTimeOffset |
getDateTimeOffset(java.lang.String parameterName) |
Returns the DateTimeOffset value of parameter with name parameterName.
|
double |
getDouble(int index) |
|
double |
getDouble(java.lang.String parameterName) |
|
float |
getFloat(int index) |
|
float |
getFloat(java.lang.String parameterName) |
|
int |
getInt(int index) |
|
int |
getInt(java.lang.String parameterName) |
|
long |
getLong(int index) |
|
long |
getLong(java.lang.String parameterName) |
|
java.math.BigDecimal |
getMoney(int parameterIndex) |
Returns the value of the column specified as a java.math.BigDecimal object.
|
java.math.BigDecimal |
getMoney(java.lang.String parameterName) |
Returns the value of the column specified as a java.math.BigDecimal object.
|
java.io.Reader |
getNCharacterStream(int parameterIndex) |
|
java.io.Reader |
getNCharacterStream(java.lang.String parameterName) |
|
java.sql.NClob |
getNClob(int parameterIndex) |
|
java.sql.NClob |
getNClob(java.lang.String parameterName) |
|
java.lang.String |
getNString(int parameterIndex) |
|
java.lang.String |
getNString(java.lang.String parameterName) |
|
java.lang.Object |
getObject(int index) |
|
<T> T |
getObject(int index,
java.lang.Class<T> type) |
|
java.lang.Object |
getObject(int parameterIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
|
java.lang.Object |
getObject(java.lang.String parameterName) |
|
<T> T |
getObject(java.lang.String parameterName,
java.lang.Class<T> type) |
|
java.lang.Object |
getObject(java.lang.String parameterName,
java.util.Map<java.lang.String,java.lang.Class<?>> m) |
|
java.sql.Ref |
getRef(int parameterIndex) |
|
java.sql.Ref |
getRef(java.lang.String parameterName) |
|
java.sql.RowId |
getRowId(int parameterIndex) |
|
java.sql.RowId |
getRowId(java.lang.String parameterName) |
|
short |
getShort(int index) |
|
short |
getShort(java.lang.String parameterName) |
|
java.sql.Timestamp |
getSmallDateTime(int index) |
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 index,
java.util.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(java.lang.String parameterName) |
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(java.lang.String name,
java.util.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 parameterIndex) |
Returns the value of the column specified as a java.math.BigDecimal object.
|
java.math.BigDecimal |
getSmallMoney(java.lang.String parameterName) |
Returns the value of the column specified as a java.math.BigDecimal object.
|
java.sql.SQLXML |
getSQLXML(int parameterIndex) |
|
java.sql.SQLXML |
getSQLXML(java.lang.String parameterName) |
|
java.lang.String |
getString(int index) |
|
java.lang.String |
getString(java.lang.String parameterName) |
|
java.sql.Time |
getTime(int index) |
|
java.sql.Time |
getTime(int index,
java.util.Calendar cal) |
|
java.sql.Time |
getTime(java.lang.String parameterName) |
|
java.sql.Time |
getTime(java.lang.String parameterName,
java.util.Calendar cal) |
|
java.sql.Timestamp |
getTimestamp(int index) |
|
java.sql.Timestamp |
getTimestamp(int index,
java.util.Calendar cal) |
|
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName) |
|
java.sql.Timestamp |
getTimestamp(java.lang.String name,
java.util.Calendar cal) |
|
java.net.URL |
getURL(int parameterIndex) |
|
java.net.URL |
getURL(java.lang.String parameterName) |
|
void |
registerOutParameter(int index,
int sqlType) |
|
void |
registerOutParameter(int index,
int sqlType,
int scale) |
|
void |
registerOutParameter(int index,
int sqlType,
int precision,
int scale) |
Registers the parameter in ordinal position index to be of JDBC type sqlType.
|
void |
registerOutParameter(int index,
int sqlType,
java.lang.String typeName) |
|
void |
registerOutParameter(int paramterIndex,
java.sql.SQLType sqlType) |
|
void |
registerOutParameter(int paramterIndex,
java.sql.SQLType sqlType,
int scale) |
|
void |
registerOutParameter(int paramterIndex,
java.sql.SQLType sqlType,
int precision,
int scale) |
Registers the parameter in ordinal position index to be of JDBC type sqlType.
|
void |
registerOutParameter(int paramterIndex,
java.sql.SQLType sqlType,
java.lang.String typeName) |
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType) |
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale) |
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int precision,
int scale) |
Registers the parameter in ordinal position index to be of JDBC type sqlType.
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName) |
|
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType) |
|
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType,
int scale) |
|
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType,
int precision,
int scale) |
Registers the parameter in ordinal position index to be of JDBC type sqlType.
|
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType,
java.lang.String typeName) |
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream value) |
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream value,
int length) |
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream value,
long length) |
|
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal value) |
|
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal value,
int precision,
int scale) |
Sets the designated parameter to the given
java.math.BigDecimal value. |
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal value,
int precision,
int scale,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.math.BigDecimal value. |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream value) |
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream value,
int length) |
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream value,
long length) |
|
void |
setBlob(java.lang.String parameterName,
java.io.InputStream value) |
|
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length) |
|
void |
setBlob(java.lang.String parameterName,
java.sql.Blob inputStream) |
|
void |
setBoolean(java.lang.String parameterName,
boolean value) |
|
void |
setBoolean(java.lang.String parameterName,
boolean value,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
boolean value. |
void |
setByte(java.lang.String parameterName,
byte value) |
|
void |
setByte(java.lang.String parameterName,
byte value,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
byte value. |
void |
setBytes(java.lang.String parameterName,
byte[] value) |
|
void |
setBytes(java.lang.String parameterName,
byte[] value,
boolean forceEncrypt) |
Sets the designated parameter to the given Java array of bytes.
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader) |
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader value,
int length) |
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
long length) |
|
void |
setClob(java.lang.String parameterName,
java.io.Reader reader) |
|
void |
setClob(java.lang.String parameterName,
java.io.Reader value,
long length) |
|
void |
setClob(java.lang.String parameterName,
java.sql.Clob value) |
|
void |
setDate(java.lang.String parameterName,
java.sql.Date value) |
|
void |
setDate(java.lang.String parameterName,
java.sql.Date value,
java.util.Calendar calendar) |
|
void |
setDate(java.lang.String parameterName,
java.sql.Date value,
java.util.Calendar calendar,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Date value, using the given
Calendar object. |
void |
setDateTime(java.lang.String parameterName,
java.sql.Timestamp value) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setDateTime(java.lang.String parameterName,
java.sql.Timestamp value,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setDateTimeOffset(java.lang.String parameterName,
DateTimeOffset value) |
Sets parameter parameterName to DateTimeOffset value.
|
void |
setDateTimeOffset(java.lang.String parameterName,
DateTimeOffset value,
int scale) |
Sets parameter parameterName to DateTimeOffset value.
|
void |
setDateTimeOffset(java.lang.String parameterName,
DateTimeOffset value,
int scale,
boolean forceEncrypt) |
Sets parameter parameterName to DateTimeOffset value.
|
void |
setDouble(java.lang.String parameterName,
double value) |
|
void |
setDouble(java.lang.String parameterName,
double value,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
double value. |
void |
setFloat(java.lang.String parameterName,
float value) |
|
void |
setFloat(java.lang.String parameterName,
float value,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
float value. |
void |
setInt(java.lang.String parameterName,
int value) |
|
void |
setInt(java.lang.String parameterName,
int value,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
int value. |
void |
setLong(java.lang.String parameterName,
long value) |
|
void |
setLong(java.lang.String parameterName,
long value,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
long value. |
void |
setMoney(java.lang.String parameterName,
java.math.BigDecimal value) |
Sets the designated parameter to the given Java
java.math.BigDecimal value. |
void |
setMoney(java.lang.String parameterName,
java.math.BigDecimal value,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
java.math.BigDecimal value. |
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value) |
|
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length) |
|
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader) |
|
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader,
long length) |
|
void |
setNClob(java.lang.String parameterName,
java.sql.NClob value) |
|
void |
setNString(java.lang.String parameterName,
java.lang.String value) |
|
void |
setNString(java.lang.String parameterName,
java.lang.String value,
boolean forceEncrypt) |
Sets the designated parameter to the given
String object. |
void |
setNull(java.lang.String parameterName,
int nType) |
|
void |
setNull(java.lang.String parameterName,
int nType,
java.lang.String sTypeName) |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object value) |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object value,
int sqlType) |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object value,
int sqlType,
int decimals) |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object value,
int sqlType,
int decimals,
boolean forceEncrypt) |
Sets the value of the designated parameter with the given object.
|
void |
setObject(java.lang.String parameterName,
java.lang.Object value,
int targetSqlType,
java.lang.Integer precision,
int scale) |
Sets the value of the designated parameter with the given object.
|
void |
setObject(java.lang.String parameterName,
java.lang.Object value,
java.sql.SQLType jdbcType) |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object value,
java.sql.SQLType jdbcType,
int scale) |
|
void |
setObject(java.lang.String parameterName,
java.lang.Object value,
java.sql.SQLType jdbcType,
int scale,
boolean forceEncrypt) |
Sets the value of the designated parameter with the given object.
|
void |
setRowId(java.lang.String parameterName,
java.sql.RowId value) |
|
void |
setShort(java.lang.String parameterName,
short value) |
|
void |
setShort(java.lang.String parameterName,
short value,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
short value. |
void |
setSmallDateTime(java.lang.String parameterName,
java.sql.Timestamp value) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setSmallDateTime(java.lang.String parameterName,
java.sql.Timestamp value,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setSmallMoney(java.lang.String parameterName,
java.math.BigDecimal value) |
Sets the designated parameter to the given Java
java.math.BigDecimal value. |
void |
setSmallMoney(java.lang.String parameterName,
java.math.BigDecimal value,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
java.math.BigDecimal value. |
void |
setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject) |
|
void |
setString(java.lang.String parameterName,
java.lang.String value) |
|
void |
setString(java.lang.String parameterName,
java.lang.String value,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
String value. |
void |
setStructured(java.lang.String parameterName,
java.lang.String tvpName,
ISQLServerDataRecord tvpDataRecord) |
Populates a table valued parameter passed to a stored procedure with an ISQLServerDataRecord object.
|
void |
setStructured(java.lang.String parameterName,
java.lang.String tvpName,
SQLServerDataTable tvpDataTable) |
Populates a table valued parameter passed to a stored procedure with a data table.
|
void |
setStructured(java.lang.String parameterName,
java.lang.String tvpName,
java.sql.ResultSet tvpResultSet) |
Populates a table valued parameter passed to a stored procedure with a ResultSet retrieved from another table
|
void |
setTime(java.lang.String parameterName,
java.sql.Time value) |
|
void |
setTime(java.lang.String parameterName,
java.sql.Time value,
int scale) |
Sets the designated parameter to the given
java.sql.Time value. |
void |
setTime(java.lang.String parameterName,
java.sql.Time value,
int scale,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Time value. |
void |
setTime(java.lang.String parameterName,
java.sql.Time value,
java.util.Calendar calendar) |
|
void |
setTime(java.lang.String parameterName,
java.sql.Time value,
java.util.Calendar calendar,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Time value, using the given
Calendar object. |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp value) |
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp value,
int scale) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp value,
int scale,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp value,
java.util.Calendar calendar) |
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp value,
java.util.Calendar calendar,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setUniqueIdentifier(java.lang.String parameterName,
java.lang.String guid) |
Sets the designated parameter to the given
String value. |
void |
setUniqueIdentifier(java.lang.String parameterName,
java.lang.String guid,
boolean forceEncrypt) |
Sets the designated parameter to the given
String value. |
void |
setURL(java.lang.String parameterName,
java.net.URL url) |
|
boolean |
wasNull() |
getParameterMetaData, getPreparedStatementHandle, setBigDecimal, setBigDecimal, setBoolean, setByte, setBytes, setDate, setDateTime, setDateTime, setDateTimeOffset, setDateTimeOffset, setDateTimeOffset, setDouble, setFloat, setGeography, setGeometry, setInt, setLong, setMoney, setMoney, setNString, setObject, setObject, setObject, setObject, setShort, setSmallDateTime, setSmallDateTime, setSmallMoney, setSmallMoney, setString, setStructured, setStructured, setStructured, setTime, setTime, setTime, setTimestamp, setTimestamp, setTimestamp, setUniqueIdentifier, setUniqueIdentifier
getCancelQueryTimeout, getResponseBuffering, setCancelQueryTimeout, setResponseBuffering
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
addBatch, clearParameters, execute, executeLargeUpdate, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
addBatch, addBatch, clearBatch, clearParameters, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeQuery, executeQuery, executeUpdate, executeUpdate, getMetaData, getParameterMetaData, getParameterMetaData, getPreparedStatementHandle, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBigDecimal, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setBoolean, setByte, setByte, setBytes, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDate, setDateTime, setDateTime, setDateTimeOffset, setDateTimeOffset, setDateTimeOffset, setDouble, setDouble, setFloat, setFloat, setGeography, setGeometry, setInt, setInt, setLong, setLong, setMoney, setMoney, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setShort, setSmallDateTime, setSmallDateTime, setSmallMoney, setSmallMoney, setSQLXML, setString, setString, setStructured, setStructured, setStructured, setTime, setTime, setTime, setTime, setTime, setTimestamp, setTimestamp, setTimestamp, setTimestamp, setTimestamp, setUnicodeStream, setUniqueIdentifier, setUniqueIdentifier, setURL
cancel, clearWarnings, close, closeOnCompletion, execute, execute, execute, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeUpdate, executeUpdate, executeUpdate, getCancelQueryTimeout, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResponseBuffering, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getStmtColumnEncriptionSetting, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setCancelQueryTimeout, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, setResponseBuffering, toString, unwrap
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
public void registerOutParameter(int index, int sqlType) throws SQLServerException
registerOutParameter
in interface java.sql.CallableStatement
SQLServerException
public void registerOutParameter(int index, int sqlType, java.lang.String typeName) throws SQLServerException
registerOutParameter
in interface java.sql.CallableStatement
SQLServerException
public void registerOutParameter(int index, int sqlType, int scale) throws SQLServerException
registerOutParameter
in interface java.sql.CallableStatement
SQLServerException
public void registerOutParameter(int index, int sqlType, int precision, int scale) throws SQLServerException
ISQLServerCallableStatement
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.
registerOutParameter
in interface ISQLServerCallableStatement
index
- the first column is 1, the second is 2, ...sqlType
- the JDBC type code defined by SQLType to use to register the OUT Parameter.precision
- the sum of the desired number of digits to the left and right of the decimal point. It must be greater
than or equal to zero.scale
- the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.SQLServerException
- If any errors occur.public int getInt(int index) throws SQLServerException
getInt
in interface java.sql.CallableStatement
SQLServerException
public int getInt(java.lang.String parameterName) throws SQLServerException
getInt
in interface java.sql.CallableStatement
SQLServerException
public java.lang.String getString(int index) throws SQLServerException
getString
in interface java.sql.CallableStatement
SQLServerException
public java.lang.String getString(java.lang.String parameterName) throws SQLServerException
getString
in interface java.sql.CallableStatement
SQLServerException
public final java.lang.String getNString(int parameterIndex) throws java.sql.SQLException
getNString
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.lang.String getNString(java.lang.String parameterName) throws java.sql.SQLException
getNString
in interface java.sql.CallableStatement
java.sql.SQLException
@Deprecated public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
@Deprecated public java.math.BigDecimal getBigDecimal(java.lang.String parameterName, int scale) throws SQLServerException
getBigDecimal
in interface ISQLServerCallableStatement
SQLServerException
public boolean getBoolean(int index) throws SQLServerException
getBoolean
in interface java.sql.CallableStatement
SQLServerException
public boolean getBoolean(java.lang.String parameterName) throws SQLServerException
getBoolean
in interface java.sql.CallableStatement
SQLServerException
public byte getByte(int index) throws SQLServerException
getByte
in interface java.sql.CallableStatement
SQLServerException
public byte getByte(java.lang.String parameterName) throws SQLServerException
getByte
in interface java.sql.CallableStatement
SQLServerException
public byte[] getBytes(int index) throws SQLServerException
getBytes
in interface java.sql.CallableStatement
SQLServerException
public byte[] getBytes(java.lang.String parameterName) throws SQLServerException
getBytes
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Date getDate(int index) throws SQLServerException
getDate
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Date getDate(java.lang.String parameterName) throws SQLServerException
getDate
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Date getDate(int index, java.util.Calendar cal) throws SQLServerException
getDate
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar cal) throws SQLServerException
getDate
in interface java.sql.CallableStatement
SQLServerException
public double getDouble(int index) throws SQLServerException
getDouble
in interface java.sql.CallableStatement
SQLServerException
public double getDouble(java.lang.String parameterName) throws SQLServerException
getDouble
in interface java.sql.CallableStatement
SQLServerException
public float getFloat(int index) throws SQLServerException
getFloat
in interface java.sql.CallableStatement
SQLServerException
public float getFloat(java.lang.String parameterName) throws SQLServerException
getFloat
in interface java.sql.CallableStatement
SQLServerException
public long getLong(int index) throws SQLServerException
getLong
in interface java.sql.CallableStatement
SQLServerException
public long getLong(java.lang.String parameterName) throws SQLServerException
getLong
in interface java.sql.CallableStatement
SQLServerException
public java.lang.Object getObject(int index) throws SQLServerException
getObject
in interface java.sql.CallableStatement
SQLServerException
public <T> T getObject(int index, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(java.lang.String parameterName) throws SQLServerException
getObject
in interface java.sql.CallableStatement
SQLServerException
public <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public short getShort(int index) throws SQLServerException
getShort
in interface java.sql.CallableStatement
SQLServerException
public short getShort(java.lang.String parameterName) throws SQLServerException
getShort
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Time getTime(int index) throws SQLServerException
getTime
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Time getTime(java.lang.String parameterName) throws SQLServerException
getTime
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Time getTime(int index, java.util.Calendar cal) throws SQLServerException
getTime
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar cal) throws SQLServerException
getTime
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Timestamp getTimestamp(int index) throws SQLServerException
getTimestamp
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws SQLServerException
getTimestamp
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Timestamp getTimestamp(int index, java.util.Calendar cal) throws SQLServerException
getTimestamp
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Timestamp getTimestamp(java.lang.String name, java.util.Calendar cal) throws SQLServerException
getTimestamp
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Timestamp getDateTime(int index) throws SQLServerException
ISQLServerCallableStatement
getDateTime
in interface ISQLServerCallableStatement
index
- the first column is 1, the second is 2, ...SQLServerException
- when an error occurspublic java.sql.Timestamp getDateTime(java.lang.String parameterName) throws SQLServerException
ISQLServerCallableStatement
getDateTime
in interface ISQLServerCallableStatement
parameterName
- 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 columnSQLServerException
- when an error occurspublic java.sql.Timestamp getDateTime(int index, java.util.Calendar cal) throws SQLServerException
ISQLServerCallableStatement
getDateTime
in interface ISQLServerCallableStatement
index
- the first column is 1, the second is 2, ...cal
- the java.util.Calendar object to use in constructing the dateTimeSQLServerException
- when an error occurspublic java.sql.Timestamp getDateTime(java.lang.String name, java.util.Calendar cal) throws SQLServerException
ISQLServerCallableStatement
getDateTime
in interface ISQLServerCallableStatement
name
- the name of the columncal
- the java.util.Calendar object to use in constructing the dateTimeSQLServerException
- when an error occurspublic java.sql.Timestamp getSmallDateTime(int index) throws SQLServerException
ISQLServerCallableStatement
getSmallDateTime
in interface ISQLServerCallableStatement
index
- the first column is 1, the second is 2, ...SQLServerException
- when an error occurspublic java.sql.Timestamp getSmallDateTime(java.lang.String parameterName) throws SQLServerException
ISQLServerCallableStatement
getSmallDateTime
in interface ISQLServerCallableStatement
parameterName
- The name of a column.SQLServerException
- when an error occurspublic java.sql.Timestamp getSmallDateTime(int index, java.util.Calendar cal) throws SQLServerException
ISQLServerCallableStatement
getSmallDateTime
in interface ISQLServerCallableStatement
index
- the first column is 1, the second is 2, ...cal
- the java.util.Calendar object to use in constructing the smalldateTimeSQLServerException
- when an error occurspublic java.sql.Timestamp getSmallDateTime(java.lang.String name, java.util.Calendar cal) throws SQLServerException
ISQLServerCallableStatement
getSmallDateTime
in interface ISQLServerCallableStatement
name
- The name of a columncal
- the java.util.Calendar object to use in constructing the smalldateTimeSQLServerException
- when an error occurspublic DateTimeOffset getDateTimeOffset(int index) throws SQLServerException
ISQLServerCallableStatement
getDateTimeOffset
in interface ISQLServerCallableStatement
index
- the first parameter is 1, the second is 2, and so onSQLServerException
- if parameterIndex is out of range; if a database access error occurs or this method is called on a closed
CallableStatement
public DateTimeOffset getDateTimeOffset(java.lang.String parameterName) throws SQLServerException
ISQLServerCallableStatement
getDateTimeOffset
in interface ISQLServerCallableStatement
parameterName
- the name of the parameterSQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public boolean wasNull() throws SQLServerException
wasNull
in interface java.sql.CallableStatement
SQLServerException
public final java.io.InputStream getAsciiStream(int parameterIndex) throws SQLServerException
ISQLServerCallableStatement
ResultSet
object as a stream
of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable
for retrieving large LONGVARCHAR
values. The JDBC driver will do any necessary conversion from the
database format into ASCII.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The
next call to a getter method implicitly closes the stream. Also, a stream may return 0
when the
method InputStream.available
is called whether there is data available or not.
getAsciiStream
in interface ISQLServerCallableStatement
parameterIndex
- the first column is 1, the second is 2, ...NULL
, the value returned is null
SQLServerException
- if the columnIndex is not valid; if a database access error occurs or this method is called on a closed
result setpublic final java.io.InputStream getAsciiStream(java.lang.String parameterName) throws SQLServerException
ISQLServerCallableStatement
ResultSet
object as a stream
of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable
for retrieving large LONGVARCHAR
values. The JDBC driver will do any necessary conversion from the
database format into ASCII.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The
next call to a getter method implicitly closes the stream. Also, a stream may return 0
when the
method available
is called whether there is data available or not.
getAsciiStream
in interface ISQLServerCallableStatement
parameterName
- the name of the parameterNULL
, the value returned is null
.SQLServerException
- if the columnLabel is not valid; if a database access error occurs or this method is called on a closed
result setpublic java.math.BigDecimal getBigDecimal(int parameterIndex) throws SQLServerException
getBigDecimal
in interface java.sql.CallableStatement
SQLServerException
public java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws SQLServerException
getBigDecimal
in interface java.sql.CallableStatement
SQLServerException
public java.math.BigDecimal getMoney(int parameterIndex) throws SQLServerException
ISQLServerCallableStatement
getMoney
in interface ISQLServerCallableStatement
parameterIndex
- The zero-based ordinal of a column.SQLServerException
- when an error occurspublic java.math.BigDecimal getMoney(java.lang.String parameterName) throws SQLServerException
ISQLServerCallableStatement
getMoney
in interface ISQLServerCallableStatement
parameterName
- The name of a column.SQLServerException
- when an error occurspublic java.math.BigDecimal getSmallMoney(int parameterIndex) throws SQLServerException
ISQLServerCallableStatement
getSmallMoney
in interface ISQLServerCallableStatement
parameterIndex
- The zero-based ordinal of a column.SQLServerException
- when an error occurspublic java.math.BigDecimal getSmallMoney(java.lang.String parameterName) throws SQLServerException
ISQLServerCallableStatement
getSmallMoney
in interface ISQLServerCallableStatement
parameterName
- The name of a column.SQLServerException
- when an error occurspublic final java.io.InputStream getBinaryStream(int parameterIndex) throws SQLServerException
ISQLServerCallableStatement
ResultSet
object as a stream
of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly
suitable for retrieving large LONGVARBINARY
values.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The
next call to a getter method implicitly closes the stream. Also, a stream may return 0
when the
method InputStream.available
is called whether there is data available or not.
getBinaryStream
in interface ISQLServerCallableStatement
parameterIndex
- the first column is 1, the second is 2, ...NULL
, the value returned is null
SQLServerException
- if the columnIndex is not valid; if a database access error occurs or this method is called on a closed
result setpublic final java.io.InputStream getBinaryStream(java.lang.String parameterName) throws SQLServerException
ISQLServerCallableStatement
ResultSet
object as a stream
of uninterpreted byte
s. The value can then be read in chunks from the stream. This method is
particularly suitable for retrieving large LONGVARBINARY
values.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The
next call to a getter method implicitly closes the stream. Also, a stream may return 0
when the
method available
is called whether there is data available or not.
getBinaryStream
in interface ISQLServerCallableStatement
parameterName
- the name of the parameterNULL
, the result is null
SQLServerException
- if the columnLabel is not valid; if a database access error occurs or this method is called on a closed
result setpublic java.sql.Blob getBlob(int parameterIndex) throws SQLServerException
getBlob
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Blob getBlob(java.lang.String parameterName) throws SQLServerException
getBlob
in interface java.sql.CallableStatement
SQLServerException
public final java.io.Reader getCharacterStream(int parameterIndex) throws SQLServerException
getCharacterStream
in interface java.sql.CallableStatement
SQLServerException
public final java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
getCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Clob getClob(int parameterIndex) throws SQLServerException
getClob
in interface java.sql.CallableStatement
SQLServerException
public java.sql.Clob getClob(java.lang.String parameterName) throws SQLServerException
getClob
in interface java.sql.CallableStatement
SQLServerException
public java.sql.NClob getNClob(int parameterIndex) throws java.sql.SQLException
getNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLException
getNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(int parameterIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(java.lang.String parameterName, java.util.Map<java.lang.String,java.lang.Class<?>> m) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Ref getRef(int parameterIndex) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Array getArray(int parameterIndex) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp value, java.util.Calendar calendar) throws SQLServerException
setTimestamp
in interface java.sql.CallableStatement
SQLServerException
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp value, java.util.Calendar calendar, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
java.sql.Timestamp
value. The driver converts this to an
SQL TIMESTAMP
value when it sends it to the database.setTimestamp
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valuecalendar
- a java.util.CalendarforceEncrypt
- 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.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
CallableStatement.getTimestamp(int)
public void setTime(java.lang.String parameterName, java.sql.Time value, java.util.Calendar calendar) throws SQLServerException
setTime
in interface java.sql.CallableStatement
SQLServerException
public void setTime(java.lang.String parameterName, java.sql.Time value, java.util.Calendar calendar, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
java.sql.Time
value, using the given
Calendar
object. The driver uses the Calendar
object to construct an SQL
TIME
value, which the driver then sends to the database. With a a Calendar
object, the
driver can calculate the time taking into account a custom timezone. If no Calendar
object is
specified, the driver uses the default timezone, which is that of the virtual machine running the application.setTime
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valuecalendar
- the Calendar
object the driver will use to construct the timeforceEncrypt
- 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.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
CallableStatement.getTime(int)
public void setDate(java.lang.String parameterName, java.sql.Date value, java.util.Calendar calendar) throws SQLServerException
setDate
in interface java.sql.CallableStatement
SQLServerException
public void setDate(java.lang.String parameterName, java.sql.Date value, java.util.Calendar calendar, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
java.sql.Date
value, using the given
Calendar
object. The driver uses the Calendar
object to construct an SQL
DATE
value, which the driver then sends to the database. With a a Calendar
object, the
driver can calculate the date taking into account a custom timezone. If no Calendar
object is
specified, the driver uses the default timezone, which is that of the virtual machine running the application.setDate
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valuecalendar
- the Calendar
object the driver will use to construct the dateforceEncrypt
- 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.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
CallableStatement.getDate(int)
public final void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setCharacterStream(java.lang.String parameterName, java.io.Reader value, int length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setClob(java.lang.String parameterName, java.sql.Clob value) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setClob(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException
setNString
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setNString(java.lang.String parameterName, java.lang.String value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
String
object. The driver converts this to a SQL
NCHAR
or NVARCHAR
or LONGNVARCHAR
setNString
in interface ISQLServerCallableStatement
parameterName
- the name of the parameter to be setvalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if the driver does not support national
character sets; if the driver can detect that a data conversion error could occur; if a database access
error occurs or this method is called on a closed CallableStatement
public void setObject(java.lang.String parameterName, java.lang.Object value) throws SQLServerException
setObject
in interface java.sql.CallableStatement
SQLServerException
public void setObject(java.lang.String parameterName, java.lang.Object value, int sqlType) throws SQLServerException
setObject
in interface java.sql.CallableStatement
SQLServerException
public void setObject(java.lang.String parameterName, java.lang.Object value, int sqlType, int decimals) throws SQLServerException
setObject
in interface java.sql.CallableStatement
SQLServerException
public void setObject(java.lang.String parameterName, java.lang.Object value, int sqlType, int decimals, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
The given Java object will be converted to the given targetSqlType before being sent to the database.
If the object has a custom mapping (is of a class implementing the interface SQLData
), the JDBC
driver should call the method SQLData.writeSQL
to write it to the SQL data stream. If, on the other
hand, the object is of a class implementing Ref
, Blob
, Clob
,
NClob
, Struct
, java.net.URL
, or Array
, the driver should pass
it to the database as a value of the corresponding SQL type.
Note that this method may be used to pass database- specific abstract data types.
setObject
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the object containing the input parameter valuesqlType
- the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further
qualify this type.decimals
- for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal
point. 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.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
Types
,
CallableStatement.getObject(int)
public final void setObject(java.lang.String parameterName, java.lang.Object value, int targetSqlType, java.lang.Integer precision, int scale) throws SQLServerException
ISQLServerCallableStatement
The given Java object will be converted to the given targetSqlType before being sent to the database.
If the object has a custom mapping (is of a class implementing the interface SQLData
), the JDBC
driver should call the method SQLData.writeSQL
to write it to the SQL data stream. If, on the other
hand, the object is of a class implementing Ref
, Blob
, Clob
,
NClob
, Struct
, java.net.URL
, or Array
, the driver should pass
it to the database as a value of the corresponding SQL type.
Note that this method may be used to pass datatabase- specific abstract data types.
setObject
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the object containing the input parameter valuetargetSqlType
- the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further
qualify this type.precision
- the precision of the column.scale
- the scale of the column.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
Types
,
CallableStatement.getObject(int)
public final void setAsciiStream(java.lang.String parameterName, java.io.InputStream value) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setAsciiStream(java.lang.String parameterName, java.io.InputStream value, int length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setAsciiStream(java.lang.String parameterName, java.io.InputStream value, long length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setBinaryStream(java.lang.String parameterName, java.io.InputStream value) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setBinaryStream(java.lang.String parameterName, java.io.InputStream value, int length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setBinaryStream(java.lang.String parameterName, java.io.InputStream value, long length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setBlob(java.lang.String parameterName, java.sql.Blob inputStream) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setBlob(java.lang.String parameterName, java.io.InputStream value) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp value) throws SQLServerException
setTimestamp
in interface java.sql.CallableStatement
SQLServerException
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp value, int scale) throws SQLServerException
ISQLServerCallableStatement
java.sql.Timestamp
value. The driver converts this to an
SQL TIMESTAMP
value when it sends it to the database.setTimestamp
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valuescale
- the scale of the parameterSQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
CallableStatement.getTimestamp(int)
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp value, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
java.sql.Timestamp
value. The driver converts this to an
SQL TIMESTAMP
value when it sends it to the database.setTimestamp
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valuescale
- the scale of the parameterforceEncrypt
- 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.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
CallableStatement.getTimestamp(int)
public void setDateTimeOffset(java.lang.String parameterName, DateTimeOffset value) throws SQLServerException
ISQLServerCallableStatement
setDateTimeOffset
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- DateTimeOffset valueSQLServerException
- if an error occurspublic void setDateTimeOffset(java.lang.String parameterName, DateTimeOffset value, int scale) throws SQLServerException
ISQLServerCallableStatement
setDateTimeOffset
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- DateTimeOffset valuescale
- the scale of the parameterSQLServerException
- if an error occurspublic void setDateTimeOffset(java.lang.String parameterName, DateTimeOffset value, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
setDateTimeOffset
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- DateTimeOffset valuescale
- the scale of the parameterforceEncrypt
- 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.SQLServerException
- if an error occurspublic void setDate(java.lang.String parameterName, java.sql.Date value) throws SQLServerException
setDate
in interface java.sql.CallableStatement
SQLServerException
public void setTime(java.lang.String parameterName, java.sql.Time value) throws SQLServerException
setTime
in interface java.sql.CallableStatement
SQLServerException
public void setTime(java.lang.String parameterName, java.sql.Time value, int scale) throws SQLServerException
ISQLServerCallableStatement
java.sql.Time
value. The driver converts this to an SQL
TIME
value when it sends it to the database.setTime
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valuescale
- the scale of the columnSQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
CallableStatement.getTime(int)
public void setTime(java.lang.String parameterName, java.sql.Time value, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
java.sql.Time
value. The driver converts this to an SQL
TIME
value when it sends it to the database.setTime
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valuescale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
CallableStatement.getTime(int)
public void setDateTime(java.lang.String parameterName, java.sql.Timestamp value) throws SQLServerException
ISQLServerCallableStatement
java.sql.Timestamp
value. The driver converts this to an
SQL DATETIME
value when it sends it to the database.setDateTime
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueSQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setDateTime(java.lang.String parameterName, java.sql.Timestamp value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
java.sql.Timestamp
value. The driver converts this to an
SQL DATETIME
value when it sends it to the database.setDateTime
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setSmallDateTime(java.lang.String parameterName, java.sql.Timestamp value) throws SQLServerException
ISQLServerCallableStatement
java.sql.Timestamp
value. The driver converts this to an
SQL SMALLDATETIME
value when it sends it to the database.setSmallDateTime
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueSQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setSmallDateTime(java.lang.String parameterName, java.sql.Timestamp value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
java.sql.Timestamp
value. The driver converts this to an
SQL SMALLDATETIME
value when it sends it to the database.setSmallDateTime
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setUniqueIdentifier(java.lang.String parameterName, java.lang.String guid) throws SQLServerException
ISQLServerCallableStatement
String
value. The driver converts this to an SQL
uniqueIdentifier
value when it sends it to the database.setUniqueIdentifier
in interface ISQLServerCallableStatement
parameterName
- the name of the parameterguid
- the parameter valueSQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setUniqueIdentifier(java.lang.String parameterName, java.lang.String guid, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
String
value. The driver converts this to an SQL
uniqueIdentifier
value when it sends it to the database.setUniqueIdentifier
in interface ISQLServerCallableStatement
parameterName
- the name of the parameterguid
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setBytes(java.lang.String parameterName, byte[] value) throws SQLServerException
setBytes
in interface java.sql.CallableStatement
SQLServerException
public void setBytes(java.lang.String parameterName, byte[] value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
VARBINARY
or LONGVARBINARY
(depending on the argument's size relative to the driver's
limits on VARBINARY
values) when it sends it to the database.setBytes
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setByte(java.lang.String parameterName, byte value) throws SQLServerException
setByte
in interface java.sql.CallableStatement
SQLServerException
public void setByte(java.lang.String parameterName, byte value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
byte
value. The driver converts this to an SQL
TINYINT
value when it sends it to the database.setByte
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setString(java.lang.String parameterName, java.lang.String value) throws SQLServerException
setString
in interface java.sql.CallableStatement
SQLServerException
public void setString(java.lang.String parameterName, java.lang.String value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
String
value. The driver converts this to an SQL
VARCHAR
or LONGVARCHAR
value (depending on the argument's size relative to the driver's
limits on VARCHAR
values) when it sends it to the database.setString
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setMoney(java.lang.String parameterName, java.math.BigDecimal value) throws SQLServerException
ISQLServerCallableStatement
java.math.BigDecimal
value. The driver converts this
to an SQL Money
value.setMoney
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueSQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setMoney(java.lang.String parameterName, java.math.BigDecimal value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
java.math.BigDecimal
value. The driver converts this
to an SQL Money
value.setMoney
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setSmallMoney(java.lang.String parameterName, java.math.BigDecimal value) throws SQLServerException
ISQLServerCallableStatement
java.math.BigDecimal
value. The driver converts this
to an SQL smallMoney
value.setSmallMoney
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueSQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setSmallMoney(java.lang.String parameterName, java.math.BigDecimal value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
java.math.BigDecimal
value. The driver converts this
to an SQL smallMoney
value.setSmallMoney
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal value) throws SQLServerException
setBigDecimal
in interface java.sql.CallableStatement
SQLServerException
public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal value, int precision, int scale) throws SQLServerException
ISQLServerCallableStatement
java.math.BigDecimal
value. The driver converts this to
an SQL NUMERIC
value when it sends it to the database.setBigDecimal
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueprecision
- the precision of the columnscale
- the scale of the columnSQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal value, int precision, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
java.math.BigDecimal
value. The driver converts this to
an SQL NUMERIC
value when it sends it to the database.setBigDecimal
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueprecision
- the precision of the columnscale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setDouble(java.lang.String parameterName, double value) throws SQLServerException
setDouble
in interface java.sql.CallableStatement
SQLServerException
public void setDouble(java.lang.String parameterName, double value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
double
value. The driver converts this to an SQL
DOUBLE
value when it sends it to the database.setDouble
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setFloat(java.lang.String parameterName, float value) throws SQLServerException
setFloat
in interface java.sql.CallableStatement
SQLServerException
public void setFloat(java.lang.String parameterName, float value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
float
value. The driver converts this to an SQL
FLOAT
value when it sends it to the database.setFloat
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setInt(java.lang.String parameterName, int value) throws SQLServerException
setInt
in interface java.sql.CallableStatement
SQLServerException
public void setInt(java.lang.String parameterName, int value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
int
value. The driver converts this to an SQL
INTEGER
value when it sends it to the database.setInt
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setLong(java.lang.String parameterName, long value) throws SQLServerException
setLong
in interface java.sql.CallableStatement
SQLServerException
public void setLong(java.lang.String parameterName, long value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
long
value. The driver converts this to an SQL
BIGINT
value when it sends it to the database.setLong
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setShort(java.lang.String parameterName, short value) throws SQLServerException
setShort
in interface java.sql.CallableStatement
SQLServerException
public void setShort(java.lang.String parameterName, short value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
short
value. The driver converts this to an SQL
SMALLINT
value when it sends it to the database.setShort
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setBoolean(java.lang.String parameterName, boolean value) throws SQLServerException
setBoolean
in interface java.sql.CallableStatement
SQLServerException
public void setBoolean(java.lang.String parameterName, boolean value, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
boolean
value. The driver converts this to an SQL
BIT
or BOOLEAN
value when it sends it to the database.setBoolean
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the parameter valueforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column
is encrypted and Always Encrypted is enabled on the connection or on the statement. If the boolean
forceEncrypt is set to false, the driver will not force encryption on parameters.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
public void setNull(java.lang.String parameterName, int nType) throws SQLServerException
setNull
in interface java.sql.CallableStatement
SQLServerException
public void setNull(java.lang.String parameterName, int nType, java.lang.String sTypeName) throws SQLServerException
setNull
in interface java.sql.CallableStatement
SQLServerException
public void setURL(java.lang.String parameterName, java.net.URL url) throws java.sql.SQLException
setURL
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setStructured(java.lang.String parameterName, java.lang.String tvpName, SQLServerDataTable tvpDataTable) throws SQLServerException
ISQLServerCallableStatement
setStructured
in interface ISQLServerCallableStatement
parameterName
- the name of the parametertvpName
- the name of the type TVPtvpDataTable
- the data table objectSQLServerException
- when an error occurspublic final void setStructured(java.lang.String parameterName, java.lang.String tvpName, java.sql.ResultSet tvpResultSet) throws SQLServerException
ISQLServerCallableStatement
setStructured
in interface ISQLServerCallableStatement
parameterName
- the name of the parametertvpName
- the name of the type TVPtvpResultSet
- the source result set objectSQLServerException
- when an error occurspublic final void setStructured(java.lang.String parameterName, java.lang.String tvpName, ISQLServerDataRecord tvpDataRecord) throws SQLServerException
ISQLServerCallableStatement
setStructured
in interface ISQLServerCallableStatement
parameterName
- the name of the parametertvpName
- the name of the type TVPtvpDataRecord
- ISQLServerDataRecord is used for streaming data and the user decides how to use it. tvpDataRecord is an
ISQLServerDataRecord object.the source result set objectSQLServerException
- when an error occurspublic java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
setSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException
getSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.sql.SQLXML getSQLXML(java.lang.String parameterName) throws java.sql.SQLException
getSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public final void setRowId(java.lang.String parameterName, java.sql.RowId value) throws java.sql.SQLException
setRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException
getRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public final java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException
getRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws SQLServerException
registerOutParameter
in interface java.sql.CallableStatement
SQLServerException
public void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws SQLServerException
registerOutParameter
in interface java.sql.CallableStatement
SQLServerException
public void registerOutParameter(java.lang.String parameterName, int sqlType, int precision, int scale) throws SQLServerException
ISQLServerCallableStatement
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.
registerOutParameter
in interface ISQLServerCallableStatement
parameterName
- the name of the parametersqlType
- the JDBC type code defined by SQLType to use to register the OUT Parameter.precision
- the sum of the desired number of digits to the left and right of the decimal point. It must be greater
than or equal to zero.scale
- the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.SQLServerException
- If any errors occur.public void registerOutParameter(java.lang.String parameterName, int sqlType) throws SQLServerException
registerOutParameter
in interface java.sql.CallableStatement
SQLServerException
public void registerOutParameter(int paramterIndex, java.sql.SQLType sqlType) throws SQLServerException
registerOutParameter
in interface java.sql.CallableStatement
SQLServerException
public void registerOutParameter(int paramterIndex, java.sql.SQLType sqlType, java.lang.String typeName) throws SQLServerException
registerOutParameter
in interface java.sql.CallableStatement
SQLServerException
public void registerOutParameter(int paramterIndex, java.sql.SQLType sqlType, int scale) throws SQLServerException
registerOutParameter
in interface java.sql.CallableStatement
SQLServerException
public void registerOutParameter(int paramterIndex, java.sql.SQLType sqlType, int precision, int scale) throws SQLServerException
ISQLServerCallableStatement
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.
registerOutParameter
in interface ISQLServerCallableStatement
paramterIndex
- the first column is 1, the second is 2, ...sqlType
- the JDBC type code defined by SQLType to use to register the OUT Parameter.precision
- the sum of the desired number of digits to the left and right of the decimal point. It must be greater
than or equal to zero.scale
- the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.SQLServerException
- If any errors occur.public void setObject(java.lang.String parameterName, java.lang.Object value, java.sql.SQLType jdbcType) throws SQLServerException
setObject
in interface java.sql.CallableStatement
SQLServerException
public void setObject(java.lang.String parameterName, java.lang.Object value, java.sql.SQLType jdbcType, int scale) throws SQLServerException
setObject
in interface java.sql.CallableStatement
SQLServerException
public void setObject(java.lang.String parameterName, java.lang.Object value, java.sql.SQLType jdbcType, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement
The given Java object will be converted to the given targetSqlType before being sent to the database.
If the object has a custom mapping (is of a class implementing the interface SQLData
), the JDBC
driver should call the method SQLData.writeSQL
to write it to the SQL data stream. If, on the other
hand, the object is of a class implementing Ref
, Blob
, Clob
,
NClob
, Struct
, java.net.URL
, or Array
, the driver should pass
it to the database as a value of the corresponding SQL type.
Note that this method may be used to pass datatabase- specific abstract data types.
setObject
in interface ISQLServerCallableStatement
parameterName
- the name of the parametervalue
- the object containing the input parameter valuejdbcType
- the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further
qualify this type.scale
- the scale of the column.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.SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this
method is called on a closed CallableStatement
Types
,
CallableStatement.getObject(int)
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, java.lang.String typeName) throws SQLServerException
registerOutParameter
in interface java.sql.CallableStatement
SQLServerException
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, int scale) throws SQLServerException
registerOutParameter
in interface java.sql.CallableStatement
SQLServerException
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, int precision, int scale) throws SQLServerException
ISQLServerCallableStatement
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.
registerOutParameter
in interface ISQLServerCallableStatement
parameterName
- the name of the parametersqlType
- the JDBC type code defined by SQLType to use to register the OUT Parameter.precision
- the sum of the desired number of digits to the left and right of the decimal point. It must be greater
than or equal to zero.scale
- the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.SQLServerException
- If any errors occur.public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType) throws SQLServerException
registerOutParameter
in interface java.sql.CallableStatement
SQLServerException
Copyright © 2018 Microsoft Corporation. All rights reserved.