ISQLServerCallableStatement
, ISQLServerPreparedStatement
, ISQLServerStatement
, AutoCloseable
, CallableStatement
, PreparedStatement
, Statement
, Wrapper
SQLServerCallableStatement42
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
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
Modifier and Type | Method | Description |
---|---|---|
Array |
getArray(int i) |
|
Array |
getArray(String sCol) |
|
InputStream |
getAsciiStream(int paramIndex) |
Retrieves the value of the designated column in the current row of this
ResultSet object as a stream of ASCII characters. |
InputStream |
getAsciiStream(String paramName) |
Retrieves the value of the designated column in the current row of this
ResultSet object as a stream of ASCII characters. |
BigDecimal |
getBigDecimal(int index) |
|
BigDecimal |
getBigDecimal(int parameterIndex,
int scale) |
Deprecated.
|
BigDecimal |
getBigDecimal(String sCol) |
|
BigDecimal |
getBigDecimal(String parameterName,
int scale) |
Deprecated.
|
InputStream |
getBinaryStream(int paramIndex) |
Retrieves the value of the designated column in the current row of this
ResultSet object as a stream of uninterpreted bytes. |
InputStream |
getBinaryStream(String paramName) |
Retrieves the value of the designated column in the current row of this
ResultSet object as a stream of uninterpreted
byte s. |
Blob |
getBlob(int index) |
|
Blob |
getBlob(String sCol) |
|
boolean |
getBoolean(int index) |
|
boolean |
getBoolean(String sCol) |
|
byte |
getByte(int index) |
|
byte |
getByte(String sCol) |
|
byte[] |
getBytes(int index) |
|
byte[] |
getBytes(String sCol) |
|
Reader |
getCharacterStream(int paramIndex) |
|
Reader |
getCharacterStream(String parameterName) |
|
Clob |
getClob(int index) |
|
Clob |
getClob(String sCol) |
|
Date |
getDate(int index) |
|
Date |
getDate(int index,
Calendar cal) |
|
Date |
getDate(String sCol) |
|
Date |
getDate(String sCol,
Calendar cal) |
|
Timestamp |
getDateTime(int index) |
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming
language.
|
Timestamp |
getDateTime(int index,
Calendar cal) |
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming
language.
|
Timestamp |
getDateTime(String sCol) |
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming
language.
|
Timestamp |
getDateTime(String name,
Calendar cal) |
Retrieves 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) |
Gets the DateTimeOffset value of parameter with index parameterIndex
|
DateTimeOffset |
getDateTimeOffset(String sCol) |
Gets the DateTimeOffset value of parameter with name parameterName
|
double |
getDouble(int index) |
|
double |
getDouble(String sCol) |
|
float |
getFloat(int index) |
|
float |
getFloat(String sCol) |
|
int |
getInt(int index) |
|
int |
getInt(String sCol) |
|
long |
getLong(int index) |
|
long |
getLong(String sCol) |
|
BigDecimal |
getMoney(int index) |
Retrieves the value of the column specified as a java.math.BigDecimal object.
|
BigDecimal |
getMoney(String sCol) |
Retrieves the value of the column specified as a java.math.BigDecimal object.
|
Reader |
getNCharacterStream(int parameterIndex) |
|
Reader |
getNCharacterStream(String parameterName) |
|
NClob |
getNClob(int parameterIndex) |
|
NClob |
getNClob(String parameterName) |
|
String |
getNString(int parameterIndex) |
|
String |
getNString(String parameterName) |
|
Object |
getObject(int index) |
|
<T> T |
getObject(int index,
Class<T> type) |
|
Object |
getObject(int index,
Map<String,Class<?>> map) |
|
Object |
getObject(String sCol) |
|
<T> T |
getObject(String sCol,
Class<T> type) |
|
Object |
getObject(String sCol,
Map<String,Class<?>> m) |
|
Ref |
getRef(int i) |
|
Ref |
getRef(String sCol) |
|
RowId |
getRowId(int parameterIndex) |
|
RowId |
getRowId(String parameterName) |
|
short |
getShort(int index) |
|
short |
getShort(String sCol) |
|
Timestamp |
getSmallDateTime(int index) |
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming
language.
|
Timestamp |
getSmallDateTime(int index,
Calendar cal) |
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming
language.
|
Timestamp |
getSmallDateTime(String sCol) |
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming
language.
|
Timestamp |
getSmallDateTime(String name,
Calendar cal) |
|
BigDecimal |
getSmallMoney(int index) |
Retrieves the value of the column specified as a java.math.BigDecimal object.
|
BigDecimal |
getSmallMoney(String sCol) |
Retrieves the value of the column specified as a java.math.BigDecimal object.
|
SQLXML |
getSQLXML(int parameterIndex) |
|
SQLXML |
getSQLXML(String parameterName) |
|
String |
getString(int index) |
|
String |
getString(String sCol) |
|
Time |
getTime(int index) |
|
Time |
getTime(int index,
Calendar cal) |
|
Time |
getTime(String sCol) |
|
Time |
getTime(String sCol,
Calendar cal) |
|
Timestamp |
getTimestamp(int index) |
|
Timestamp |
getTimestamp(int index,
Calendar cal) |
|
Timestamp |
getTimestamp(String sCol) |
|
Timestamp |
getTimestamp(String name,
Calendar cal) |
|
URL |
getURL(int n) |
|
URL |
getURL(String s) |
|
void |
registerOutParameter(int index,
int sqlType) |
|
void |
registerOutParameter(int index,
int sqlType,
int scale) |
|
void |
registerOutParameter(int index,
int sqlType,
int precision,
int scale) |
|
void |
registerOutParameter(int index,
int sqlType,
String typeName) |
|
void |
registerOutParameter(String s,
int n) |
|
void |
registerOutParameter(String parameterName,
int sqlType,
int scale) |
|
void |
registerOutParameter(String parameterName,
int sqlType,
int precision,
int scale) |
|
void |
registerOutParameter(String s,
int n,
String s1) |
|
void |
setAsciiStream(String parameterName,
InputStream x) |
|
void |
setAsciiStream(String parameterName,
InputStream value,
int length) |
|
void |
setAsciiStream(String parameterName,
InputStream x,
long length) |
|
void |
setBigDecimal(String sCol,
BigDecimal bd) |
|
void |
setBigDecimal(String sCol,
BigDecimal bd,
int precision,
int scale) |
Sets the designated parameter to the given
java.math.BigDecimal value. |
void |
setBigDecimal(String sCol,
BigDecimal bd,
int precision,
int scale,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.math.BigDecimal value. |
void |
setBinaryStream(String parameterName,
InputStream x) |
|
void |
setBinaryStream(String parameterName,
InputStream value,
int length) |
|
void |
setBinaryStream(String parameterName,
InputStream x,
long length) |
|
void |
setBlob(String parameterName,
InputStream value) |
|
void |
setBlob(String parameterName,
InputStream inputStream,
long length) |
|
void |
setBlob(String parameterName,
Blob inputStream) |
|
void |
setBoolean(String sCol,
boolean b) |
|
void |
setBoolean(String sCol,
boolean b,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
boolean value. |
void |
setByte(String sCol,
byte b) |
|
void |
setByte(String sCol,
byte b,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
byte value. |
void |
setBytes(String sCol,
byte[] b) |
|
void |
setBytes(String sCol,
byte[] b,
boolean forceEncrypt) |
Sets the designated parameter to the given Java array of bytes.
|
void |
setCharacterStream(String parameterName,
Reader reader) |
|
void |
setCharacterStream(String parameterName,
Reader value,
int length) |
|
void |
setCharacterStream(String parameterName,
Reader reader,
long length) |
|
void |
setClob(String parameterName,
Reader reader) |
|
void |
setClob(String parameterName,
Reader value,
long length) |
|
void |
setClob(String parameterName,
Clob x) |
|
void |
setDate(String sCol,
Date d) |
|
void |
setDate(String sCol,
Date x,
Calendar c) |
|
void |
setDate(String sCol,
Date x,
Calendar c,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Date value, using the given Calendar object. |
void |
setDateTime(String sCol,
Timestamp x) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setDateTime(String sCol,
Timestamp x,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setDateTimeOffset(String sCol,
DateTimeOffset t) |
Sets parameter parameterName to DateTimeOffset x
|
void |
setDateTimeOffset(String sCol,
DateTimeOffset t,
int scale) |
Sets parameter parameterName to DateTimeOffset x
|
void |
setDateTimeOffset(String sCol,
DateTimeOffset t,
int scale,
boolean forceEncrypt) |
Sets parameter parameterName to DateTimeOffset x
|
void |
setDouble(String sCol,
double d) |
|
void |
setDouble(String sCol,
double d,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
double value. |
void |
setFloat(String sCol,
float f) |
|
void |
setFloat(String sCol,
float f,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
float value. |
void |
setInt(String sCol,
int i) |
|
void |
setInt(String sCol,
int i,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
int value. |
void |
setLong(String sCol,
long l) |
|
void |
setLong(String sCol,
long l,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
long value. |
void |
setMoney(String sCol,
BigDecimal bd) |
Sets the designated parameter to the given Java
java.math.BigDecimal value. |
void |
setMoney(String sCol,
BigDecimal bd,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
java.math.BigDecimal value. |
void |
setNCharacterStream(String parameterName,
Reader value) |
|
void |
setNCharacterStream(String parameterName,
Reader value,
long length) |
|
void |
setNClob(String parameterName,
Reader reader) |
|
void |
setNClob(String parameterName,
Reader reader,
long length) |
|
void |
setNClob(String parameterName,
NClob value) |
|
void |
setNString(String parameterName,
String value) |
|
void |
setNString(String parameterName,
String value,
boolean forceEncrypt) |
Sets the designated parameter to the given
String object. |
void |
setNull(String sCol,
int nType) |
|
void |
setNull(String sCol,
int nType,
String sTypeName) |
|
void |
setObject(String sCol,
Object o) |
|
void |
setObject(String sCol,
Object o,
int n) |
|
void |
setObject(String sCol,
Object o,
int n,
int m) |
|
void |
setObject(String sCol,
Object o,
int n,
int m,
boolean forceEncrypt) |
Sets the value of the designated parameter with the given object.
|
void |
setObject(String sCol,
Object x,
int targetSqlType,
Integer precision,
int scale) |
Sets the value of the designated parameter with the given object.
|
void |
setRowId(String parameterName,
RowId x) |
|
void |
setShort(String sCol,
short s) |
|
void |
setShort(String sCol,
short s,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
short value. |
void |
setSmallDateTime(String sCol,
Timestamp x) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setSmallDateTime(String sCol,
Timestamp x,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setSmallMoney(String sCol,
BigDecimal bd) |
Sets the designated parameter to the given Java
java.math.BigDecimal value. |
void |
setSmallMoney(String sCol,
BigDecimal bd,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
java.math.BigDecimal value. |
void |
setSQLXML(String parameterName,
SQLXML xmlObject) |
|
void |
setString(String sCol,
String s) |
|
void |
setString(String sCol,
String s,
boolean forceEncrypt) |
Sets the designated parameter to the given Java
String value. |
void |
setStructured(String sCol,
String tvpName,
ISQLServerDataRecord tvpDataRecord) |
Populates a table valued parameter passed to a stored procedure with an ISQLServerDataRecord object.
|
void |
setStructured(String sCol,
String tvpName,
SQLServerDataTable tvpDataTable) |
Populates a table valued parameter passed to a stored procedure with a data table.
|
void |
setStructured(String sCol,
String tvpName,
ResultSet tvpResultSet) |
Populates a table valued parameter passed to a stored procedure with a ResultSet retrieved from another table
|
void |
setTime(String sCol,
Time t) |
|
void |
setTime(String sCol,
Time t,
int scale) |
Sets the designated parameter to the given
java.sql.Time value. |
void |
setTime(String sCol,
Time t,
int scale,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Time value. |
void |
setTime(String sCol,
Time x,
Calendar c) |
|
void |
setTime(String sCol,
Time x,
Calendar c,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Time value, using the given Calendar object. |
void |
setTimestamp(String sCol,
Timestamp t) |
|
void |
setTimestamp(String sCol,
Timestamp t,
int scale) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setTimestamp(String sCol,
Timestamp t,
int scale,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setTimestamp(String sCol,
Timestamp x,
Calendar c) |
|
void |
setTimestamp(String sCol,
Timestamp x,
Calendar c,
boolean forceEncrypt) |
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setUniqueIdentifier(String sCol,
String guid) |
Sets the designated parameter to the given
String value. |
void |
setUniqueIdentifier(String sCol,
String guid,
boolean forceEncrypt) |
Sets the designated parameter to the given
String value. |
void |
setURL(String sCol,
URL u) |
|
boolean |
wasNull() |
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObject
setDateTimeOffset
getResponseBuffering, 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, 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, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResponseBuffering, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, 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
isWrapperFor, unwrap
public void registerOutParameter(int index, int sqlType) throws SQLServerException
registerOutParameter
in interface CallableStatement
SQLServerException
public void registerOutParameter(int index, int sqlType, String typeName) throws SQLServerException
registerOutParameter
in interface CallableStatement
SQLServerException
public void registerOutParameter(int index, int sqlType, int scale) throws SQLServerException
registerOutParameter
in interface CallableStatement
SQLServerException
public void registerOutParameter(int index, int sqlType, int precision, int scale) throws SQLServerException
SQLServerException
public int getInt(int index) throws SQLServerException
getInt
in interface CallableStatement
SQLServerException
public int getInt(String sCol) throws SQLServerException
getInt
in interface CallableStatement
SQLServerException
public String getString(int index) throws SQLServerException
getString
in interface CallableStatement
SQLServerException
public String getString(String sCol) throws SQLServerException
getString
in interface CallableStatement
SQLServerException
public final String getNString(int parameterIndex) throws SQLException
getNString
in interface CallableStatement
SQLException
public final String getNString(String parameterName) throws SQLException
getNString
in interface CallableStatement
SQLException
@Deprecated public BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException
getBigDecimal
in interface CallableStatement
SQLException
@Deprecated public BigDecimal getBigDecimal(String parameterName, int scale) throws SQLException
SQLException
public boolean getBoolean(int index) throws SQLServerException
getBoolean
in interface CallableStatement
SQLServerException
public boolean getBoolean(String sCol) throws SQLServerException
getBoolean
in interface CallableStatement
SQLServerException
public byte getByte(int index) throws SQLServerException
getByte
in interface CallableStatement
SQLServerException
public byte getByte(String sCol) throws SQLServerException
getByte
in interface CallableStatement
SQLServerException
public byte[] getBytes(int index) throws SQLServerException
getBytes
in interface CallableStatement
SQLServerException
public byte[] getBytes(String sCol) throws SQLServerException
getBytes
in interface CallableStatement
SQLServerException
public Date getDate(int index) throws SQLServerException
getDate
in interface CallableStatement
SQLServerException
public Date getDate(String sCol) throws SQLServerException
getDate
in interface CallableStatement
SQLServerException
public Date getDate(int index, Calendar cal) throws SQLServerException
getDate
in interface CallableStatement
SQLServerException
public Date getDate(String sCol, Calendar cal) throws SQLServerException
getDate
in interface CallableStatement
SQLServerException
public double getDouble(int index) throws SQLServerException
getDouble
in interface CallableStatement
SQLServerException
public double getDouble(String sCol) throws SQLServerException
getDouble
in interface CallableStatement
SQLServerException
public float getFloat(int index) throws SQLServerException
getFloat
in interface CallableStatement
SQLServerException
public float getFloat(String sCol) throws SQLServerException
getFloat
in interface CallableStatement
SQLServerException
public long getLong(int index) throws SQLServerException
getLong
in interface CallableStatement
SQLServerException
public long getLong(String sCol) throws SQLServerException
getLong
in interface CallableStatement
SQLServerException
public Object getObject(int index) throws SQLServerException
getObject
in interface CallableStatement
SQLServerException
public <T> T getObject(int index, Class<T> type) throws SQLException
getObject
in interface CallableStatement
SQLException
public Object getObject(String sCol) throws SQLServerException
getObject
in interface CallableStatement
SQLServerException
public <T> T getObject(String sCol, Class<T> type) throws SQLException
getObject
in interface CallableStatement
SQLException
public short getShort(int index) throws SQLServerException
getShort
in interface CallableStatement
SQLServerException
public short getShort(String sCol) throws SQLServerException
getShort
in interface CallableStatement
SQLServerException
public Time getTime(int index) throws SQLServerException
getTime
in interface CallableStatement
SQLServerException
public Time getTime(String sCol) throws SQLServerException
getTime
in interface CallableStatement
SQLServerException
public Time getTime(int index, Calendar cal) throws SQLServerException
getTime
in interface CallableStatement
SQLServerException
public Time getTime(String sCol, Calendar cal) throws SQLServerException
getTime
in interface CallableStatement
SQLServerException
public Timestamp getTimestamp(int index) throws SQLServerException
getTimestamp
in interface CallableStatement
SQLServerException
public Timestamp getTimestamp(String sCol) throws SQLServerException
getTimestamp
in interface CallableStatement
SQLServerException
public Timestamp getTimestamp(int index, Calendar cal) throws SQLServerException
getTimestamp
in interface CallableStatement
SQLServerException
public Timestamp getTimestamp(String name, Calendar cal) throws SQLServerException
getTimestamp
in interface CallableStatement
SQLServerException
public Timestamp getDateTime(int index) throws SQLServerException
index
- the first column is 1, the second is 2, ...SQLServerException
- when an error occurspublic Timestamp getDateTime(String sCol) throws SQLServerException
sCol
- 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 Timestamp getDateTime(int index, Calendar cal) throws SQLServerException
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 Timestamp getDateTime(String name, Calendar cal) throws SQLServerException
name
- the name of the columncal
- the java.util.Calendar object to use in constructing the dateTimeSQLServerException
- when an error occurspublic Timestamp getSmallDateTime(int index) throws SQLServerException
index
- the first column is 1, the second is 2, ...SQLServerException
- when an error occurspublic Timestamp getSmallDateTime(String sCol) throws SQLServerException
sCol
- The name of a column.SQLServerException
- when an error occurspublic Timestamp getSmallDateTime(int index, Calendar cal) throws SQLServerException
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 Timestamp getSmallDateTime(String name, Calendar cal) throws SQLServerException
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 SQLException
ISQLServerCallableStatement
getDateTimeOffset
in interface ISQLServerCallableStatement
index
- the first parameter is 1, the second is 2, and so onSQLException
- if parameterIndex is out of range; if a database access error occurs or this method is called on a closed
CallableStatement
public DateTimeOffset getDateTimeOffset(String sCol) throws SQLException
ISQLServerCallableStatement
getDateTimeOffset
in interface ISQLServerCallableStatement
sCol
- the name of the parameterSQLException
- 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 CallableStatement
SQLServerException
public final InputStream getAsciiStream(int paramIndex) throws SQLServerException
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.
paramIndex
- 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 InputStream getAsciiStream(String paramName) throws SQLServerException
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.
paramName
- 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 BigDecimal getBigDecimal(int index) throws SQLServerException
getBigDecimal
in interface CallableStatement
SQLServerException
public BigDecimal getBigDecimal(String sCol) throws SQLServerException
getBigDecimal
in interface CallableStatement
SQLServerException
public BigDecimal getMoney(int index) throws SQLServerException
index
- The zero-based ordinal of a column.SQLServerException
- when an error occurspublic BigDecimal getMoney(String sCol) throws SQLServerException
sCol
- The name of a column.SQLServerException
- when an error occurspublic BigDecimal getSmallMoney(int index) throws SQLServerException
index
- The zero-based ordinal of a column.SQLServerException
- when an error occurspublic BigDecimal getSmallMoney(String sCol) throws SQLServerException
sCol
- The name of a column.SQLServerException
- when an error occurspublic final InputStream getBinaryStream(int paramIndex) throws SQLServerException
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.
paramIndex
- 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 InputStream getBinaryStream(String paramName) throws SQLServerException
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.
paramName
- 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 Blob getBlob(int index) throws SQLServerException
getBlob
in interface CallableStatement
SQLServerException
public Blob getBlob(String sCol) throws SQLServerException
getBlob
in interface CallableStatement
SQLServerException
public final Reader getCharacterStream(int paramIndex) throws SQLServerException
getCharacterStream
in interface CallableStatement
SQLServerException
public final Reader getCharacterStream(String parameterName) throws SQLException
getCharacterStream
in interface CallableStatement
SQLException
public final Reader getNCharacterStream(int parameterIndex) throws SQLException
getNCharacterStream
in interface CallableStatement
SQLException
public final Reader getNCharacterStream(String parameterName) throws SQLException
getNCharacterStream
in interface CallableStatement
SQLException
public Clob getClob(int index) throws SQLServerException
getClob
in interface CallableStatement
SQLServerException
public Clob getClob(String sCol) throws SQLServerException
getClob
in interface CallableStatement
SQLServerException
public NClob getNClob(int parameterIndex) throws SQLException
getNClob
in interface CallableStatement
SQLException
public NClob getNClob(String parameterName) throws SQLException
getNClob
in interface CallableStatement
SQLException
public Object getObject(int index, Map<String,Class<?>> map) throws SQLServerException
getObject
in interface CallableStatement
SQLServerException
public Object getObject(String sCol, Map<String,Class<?>> m) throws SQLServerException
getObject
in interface CallableStatement
SQLServerException
public Ref getRef(int i) throws SQLServerException
getRef
in interface CallableStatement
SQLServerException
public Ref getRef(String sCol) throws SQLServerException
getRef
in interface CallableStatement
SQLServerException
public Array getArray(int i) throws SQLServerException
getArray
in interface CallableStatement
SQLServerException
public Array getArray(String sCol) throws SQLServerException
getArray
in interface CallableStatement
SQLServerException
public void setTimestamp(String sCol, Timestamp x, Calendar c) throws SQLServerException
setTimestamp
in interface CallableStatement
SQLServerException
public void setTimestamp(String sCol, Timestamp x, Calendar c, boolean forceEncrypt) throws SQLServerException
java.sql.Timestamp
value. The driver converts this to an SQL TIMESTAMP
value when it sends it to the database.sCol
- the name of the parameterx
- the parameter valuec
- 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
getTimestamp(int)
public void setTime(String sCol, Time x, Calendar c) throws SQLServerException
setTime
in interface CallableStatement
SQLServerException
public void setTime(String sCol, Time x, Calendar c, boolean forceEncrypt) throws SQLServerException
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.sCol
- the name of the parameterx
- the parameter valuec
- 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
getTime(int)
public void setDate(String sCol, Date x, Calendar c) throws SQLServerException
setDate
in interface CallableStatement
SQLServerException
public void setDate(String sCol, Date x, Calendar c, boolean forceEncrypt) throws SQLServerException
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.sCol
- the name of the parameterx
- the parameter valuec
- 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
getDate(int)
public final void setCharacterStream(String parameterName, Reader reader) throws SQLException
setCharacterStream
in interface CallableStatement
SQLException
public final void setCharacterStream(String parameterName, Reader value, int length) throws SQLException
setCharacterStream
in interface CallableStatement
SQLException
public final void setCharacterStream(String parameterName, Reader reader, long length) throws SQLException
setCharacterStream
in interface CallableStatement
SQLException
public final void setNCharacterStream(String parameterName, Reader value) throws SQLException
setNCharacterStream
in interface CallableStatement
SQLException
public final void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException
setNCharacterStream
in interface CallableStatement
SQLException
public final void setClob(String parameterName, Clob x) throws SQLException
setClob
in interface CallableStatement
SQLException
public final void setClob(String parameterName, Reader reader) throws SQLException
setClob
in interface CallableStatement
SQLException
public final void setClob(String parameterName, Reader value, long length) throws SQLException
setClob
in interface CallableStatement
SQLException
public final void setNClob(String parameterName, NClob value) throws SQLException
setNClob
in interface CallableStatement
SQLException
public final void setNClob(String parameterName, Reader reader) throws SQLException
setNClob
in interface CallableStatement
SQLException
public final void setNClob(String parameterName, Reader reader, long length) throws SQLException
setNClob
in interface CallableStatement
SQLException
public final void setNString(String parameterName, String value) throws SQLException
setNString
in interface CallableStatement
SQLException
public final void setNString(String parameterName, String value, boolean forceEncrypt) throws SQLException
String
object. The driver converts this to a SQL NCHAR
or
NVARCHAR
or LONGNVARCHAR
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.SQLException
- 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(String sCol, Object o) throws SQLServerException
setObject
in interface CallableStatement
SQLServerException
public void setObject(String sCol, Object o, int n) throws SQLServerException
setObject
in interface CallableStatement
SQLServerException
public void setObject(String sCol, Object o, int n, int m) throws SQLServerException
setObject
in interface CallableStatement
SQLServerException
public void setObject(String sCol, Object o, int n, int m, boolean forceEncrypt) throws SQLServerException
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.
sCol
- the name of the parametero
- the object containing the input parameter valuen
- the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.m
- 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
,
getObject(int)
public final void setObject(String sCol, Object x, int targetSqlType, Integer precision, int scale) throws SQLServerException
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.
sCol
- the name of the parameterx
- 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
,
getObject(int)
public final void setAsciiStream(String parameterName, InputStream x) throws SQLException
setAsciiStream
in interface CallableStatement
SQLException
public final void setAsciiStream(String parameterName, InputStream value, int length) throws SQLException
setAsciiStream
in interface CallableStatement
SQLException
public final void setAsciiStream(String parameterName, InputStream x, long length) throws SQLException
setAsciiStream
in interface CallableStatement
SQLException
public final void setBinaryStream(String parameterName, InputStream x) throws SQLException
setBinaryStream
in interface CallableStatement
SQLException
public final void setBinaryStream(String parameterName, InputStream value, int length) throws SQLException
setBinaryStream
in interface CallableStatement
SQLException
public final void setBinaryStream(String parameterName, InputStream x, long length) throws SQLException
setBinaryStream
in interface CallableStatement
SQLException
public final void setBlob(String parameterName, Blob inputStream) throws SQLException
setBlob
in interface CallableStatement
SQLException
public final void setBlob(String parameterName, InputStream value) throws SQLException
setBlob
in interface CallableStatement
SQLException
public final void setBlob(String parameterName, InputStream inputStream, long length) throws SQLException
setBlob
in interface CallableStatement
SQLException
public void setTimestamp(String sCol, Timestamp t) throws SQLServerException
setTimestamp
in interface CallableStatement
SQLServerException
public void setTimestamp(String sCol, Timestamp t, int scale) throws SQLServerException
java.sql.Timestamp
value. The driver converts this to an SQL TIMESTAMP
value when it sends it to the database.sCol
- the name of the parametert
- 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
getTimestamp(int)
public void setTimestamp(String sCol, Timestamp t, int scale, boolean forceEncrypt) throws SQLServerException
java.sql.Timestamp
value. The driver converts this to an SQL TIMESTAMP
value when it sends it to the database.sCol
- the name of the parametert
- 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
getTimestamp(int)
public void setDateTimeOffset(String sCol, DateTimeOffset t) throws SQLException
ISQLServerCallableStatement
setDateTimeOffset
in interface ISQLServerCallableStatement
sCol
- the name of the parametert
- DateTimeOffset valueSQLException
- if parameterName does not correspond to a named parameter; 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 setDateTimeOffset(String sCol, DateTimeOffset t, int scale) throws SQLException
sCol
- the name of the parametert
- DateTimeOffset valuescale
- the scale of the parameterSQLException
- if an error occurspublic void setDateTimeOffset(String sCol, DateTimeOffset t, int scale, boolean forceEncrypt) throws SQLException
sCol
- the name of the parametert
- 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.SQLException
- if an error occurspublic void setDate(String sCol, Date d) throws SQLServerException
setDate
in interface CallableStatement
SQLServerException
public void setTime(String sCol, Time t) throws SQLServerException
setTime
in interface CallableStatement
SQLServerException
public void setTime(String sCol, Time t, int scale) throws SQLServerException
java.sql.Time
value. The driver converts this to an SQL TIME
value when it
sends it to the database.sCol
- the name of the parametert
- 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
getTime(int)
public void setTime(String sCol, Time t, int scale, boolean forceEncrypt) throws SQLServerException
java.sql.Time
value. The driver converts this to an SQL TIME
value when it
sends it to the database.sCol
- the name of the parametert
- 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
getTime(int)
public void setDateTime(String sCol, Timestamp x) throws SQLServerException
java.sql.Timestamp
value. The driver converts this to an SQL DATETIME
value when it sends it to the database.sCol
- the name of the parameterx
- 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(String sCol, Timestamp x, boolean forceEncrypt) throws SQLServerException
java.sql.Timestamp
value. The driver converts this to an SQL DATETIME
value when it sends it to the database.sCol
- the name of the parameterx
- 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(String sCol, Timestamp x) throws SQLServerException
java.sql.Timestamp
value. The driver converts this to an SQL SMALLDATETIME
value when it sends it to the database.sCol
- the name of the parameterx
- 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(String sCol, Timestamp x, boolean forceEncrypt) throws SQLServerException
java.sql.Timestamp
value. The driver converts this to an SQL SMALLDATETIME
value when it sends it to the database.sCol
- the name of the parameterx
- 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(String sCol, String guid) throws SQLServerException
String
value. The driver converts this to an SQL uniqueIdentifier
value
when it sends it to the database.sCol
- 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(String sCol, String guid, boolean forceEncrypt) throws SQLServerException
String
value. The driver converts this to an SQL uniqueIdentifier
value
when it sends it to the database.sCol
- 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(String sCol, byte[] b) throws SQLServerException
setBytes
in interface CallableStatement
SQLServerException
public void setBytes(String sCol, byte[] b, boolean forceEncrypt) throws SQLServerException
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.sCol
- the name of the parameterb
- 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(String sCol, byte b) throws SQLServerException
setByte
in interface CallableStatement
SQLServerException
public void setByte(String sCol, byte b, boolean forceEncrypt) throws SQLServerException
byte
value. The driver converts this to an SQL TINYINT
value when it
sends it to the database.sCol
- the name of the parameterb
- 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(String sCol, String s) throws SQLServerException
setString
in interface CallableStatement
SQLServerException
public void setString(String sCol, String s, boolean forceEncrypt) throws SQLServerException
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.sCol
- the name of the parameters
- 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(String sCol, BigDecimal bd) throws SQLServerException
java.math.BigDecimal
value. The driver converts this to an SQL Money
value.sCol
- the name of the parameterbd
- 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(String sCol, BigDecimal bd, boolean forceEncrypt) throws SQLServerException
java.math.BigDecimal
value. The driver converts this to an SQL Money
value.sCol
- the name of the parameterbd
- 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(String sCol, BigDecimal bd) throws SQLServerException
java.math.BigDecimal
value. The driver converts this to an SQL
smallMoney
value.sCol
- the name of the parameterbd
- 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(String sCol, BigDecimal bd, boolean forceEncrypt) throws SQLServerException
java.math.BigDecimal
value. The driver converts this to an SQL
smallMoney
value.sCol
- the name of the parameterbd
- 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(String sCol, BigDecimal bd) throws SQLServerException
setBigDecimal
in interface CallableStatement
SQLServerException
public void setBigDecimal(String sCol, BigDecimal bd, int precision, int scale) throws SQLServerException
java.math.BigDecimal
value. The driver converts this to an SQL NUMERIC
value when it sends it to the database.sCol
- the name of the parameterbd
- 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(String sCol, BigDecimal bd, int precision, int scale, boolean forceEncrypt) throws SQLServerException
java.math.BigDecimal
value. The driver converts this to an SQL NUMERIC
value when it sends it to the database.sCol
- the name of the parameterbd
- 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(String sCol, double d) throws SQLServerException
setDouble
in interface CallableStatement
SQLServerException
public void setDouble(String sCol, double d, boolean forceEncrypt) throws SQLServerException
double
value. The driver converts this to an SQL DOUBLE
value when it
sends it to the database.sCol
- the name of the parameterd
- 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(String sCol, float f) throws SQLServerException
setFloat
in interface CallableStatement
SQLServerException
public void setFloat(String sCol, float f, boolean forceEncrypt) throws SQLServerException
float
value. The driver converts this to an SQL FLOAT
value when it
sends it to the database.sCol
- the name of the parameterf
- 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(String sCol, int i) throws SQLServerException
setInt
in interface CallableStatement
SQLServerException
public void setInt(String sCol, int i, boolean forceEncrypt) throws SQLServerException
int
value. The driver converts this to an SQL INTEGER
value when it
sends it to the database.sCol
- the name of the parameteri
- 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(String sCol, long l) throws SQLServerException
setLong
in interface CallableStatement
SQLServerException
public void setLong(String sCol, long l, boolean forceEncrypt) throws SQLServerException
long
value. The driver converts this to an SQL BIGINT
value when it
sends it to the database.sCol
- the name of the parameterl
- 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(String sCol, short s) throws SQLServerException
setShort
in interface CallableStatement
SQLServerException
public void setShort(String sCol, short s, boolean forceEncrypt) throws SQLServerException
short
value. The driver converts this to an SQL SMALLINT
value when
it sends it to the database.sCol
- the name of the parameters
- 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(String sCol, boolean b) throws SQLServerException
setBoolean
in interface CallableStatement
SQLServerException
public void setBoolean(String sCol, boolean b, boolean forceEncrypt) throws SQLServerException
boolean
value. The driver converts this to an SQL BIT
or
BOOLEAN
value when it sends it to the database.sCol
- the name of the parameterb
- 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(String sCol, int nType) throws SQLServerException
setNull
in interface CallableStatement
SQLServerException
public void setNull(String sCol, int nType, String sTypeName) throws SQLServerException
setNull
in interface CallableStatement
SQLServerException
public void setURL(String sCol, URL u) throws SQLServerException
setURL
in interface CallableStatement
SQLServerException
public final void setStructured(String sCol, String tvpName, SQLServerDataTable tvpDataTable) throws SQLServerException
sCol
- the name of the parametertvpName
- the name of the type TVPtvpDataTable
- the data table objectSQLServerException
- when an error occurspublic final void setStructured(String sCol, String tvpName, ResultSet tvpResultSet) throws SQLServerException
sCol
- the name of the parametertvpName
- the name of the type TVPtvpResultSet
- the source result set objectSQLServerException
- when an error occurspublic final void setStructured(String sCol, String tvpName, ISQLServerDataRecord tvpDataRecord) throws SQLServerException
sCol
- 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 URL getURL(int n) throws SQLServerException
getURL
in interface CallableStatement
SQLServerException
public URL getURL(String s) throws SQLServerException
getURL
in interface CallableStatement
SQLServerException
public final void setSQLXML(String parameterName, SQLXML xmlObject) throws SQLException
setSQLXML
in interface CallableStatement
SQLException
public final SQLXML getSQLXML(int parameterIndex) throws SQLException
getSQLXML
in interface CallableStatement
SQLException
public final SQLXML getSQLXML(String parameterName) throws SQLException
getSQLXML
in interface CallableStatement
SQLException
public final void setRowId(String parameterName, RowId x) throws SQLException
setRowId
in interface CallableStatement
SQLException
public final RowId getRowId(int parameterIndex) throws SQLException
getRowId
in interface CallableStatement
SQLException
public final RowId getRowId(String parameterName) throws SQLException
getRowId
in interface CallableStatement
SQLException
public void registerOutParameter(String s, int n, String s1) throws SQLServerException
registerOutParameter
in interface CallableStatement
SQLServerException
public void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLServerException
registerOutParameter
in interface CallableStatement
SQLServerException
public void registerOutParameter(String parameterName, int sqlType, int precision, int scale) throws SQLServerException
SQLServerException
public void registerOutParameter(String s, int n) throws SQLServerException
registerOutParameter
in interface CallableStatement
SQLServerException
Copyright © 2018 Microsoft Corporation. All rights reserved.