Class SQLServerCallableStatement
- All Implemented Interfaces:
ISQLServerCallableStatement
,ISQLServerPreparedStatement
,ISQLServerStatement
,Serializable
,AutoCloseable
,CallableStatement
,PreparedStatement
,Statement
,Wrapper
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.
- See Also:
- Serialized Form
-
Field Summary
Fields inherited from class com.microsoft.sqlserver.jdbc.SQLServerStatement
stmtColumnEncriptionSetting
Fields inherited from interface java.sql.Statement
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
-
Method Summary
Modifier and TypeMethodDescriptiongetArray(int parameterIndex)
getAsciiStream(int parameterIndex)
Returns the value of the designated column in the current row of thisResultSet
object as a stream of ASCII characters.getAsciiStream(String parameterName)
Returns the value of the designated column in the current row of thisResultSet
object as a stream of ASCII characters.getBigDecimal(int parameterIndex)
getBigDecimal(int parameterIndex, int scale)
Deprecated.getBigDecimal(String parameterName)
getBigDecimal(String parameterName, int scale)
Deprecated.getBinaryStream(int parameterIndex)
Returns the value of the designated column in the current row of thisResultSet
object as a stream of uninterpreted bytes.getBinaryStream(String parameterName)
Returns the value of the designated column in the current row of thisResultSet
object as a stream of uninterpretedbyte
s.getBlob(int parameterIndex)
boolean
getBoolean(int index)
boolean
getBoolean(String parameterName)
byte
getByte(int index)
byte
byte[]
getBytes(int index)
byte[]
getCharacterStream(int parameterIndex)
getCharacterStream(String parameterName)
getClob(int parameterIndex)
getDate(int index)
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.getDateTime(int index, 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.getDateTime(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.getDateTime(String name, 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.getDateTimeOffset(int index)
Returns the DateTimeOffset value of parameter with index parameterIndex.getDateTimeOffset(String parameterName)
Returns the DateTimeOffset value of parameter with name parameterName.double
getDouble(int index)
double
float
getFloat(int index)
float
int
getInt(int index)
int
long
getLong(int index)
long
getMoney(int parameterIndex)
Returns the value of the column specified as a java.math.BigDecimal object.Returns the value of the column specified as a java.math.BigDecimal object.getNCharacterStream(int parameterIndex)
getNCharacterStream(String parameterName)
getNClob(int parameterIndex)
getNString(int parameterIndex)
getNString(String parameterName)
getObject(int index)
<T> T
<T> T
getRef(int parameterIndex)
getRowId(int parameterIndex)
short
getShort(int index)
short
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.getSmallDateTime(int index, 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.getSmallDateTime(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.getSmallDateTime(String name, 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.getSmallMoney(int parameterIndex)
Returns the value of the column specified as a java.math.BigDecimal object.getSmallMoney(String parameterName)
Returns the value of the column specified as a java.math.BigDecimal object.getSQLXML(int parameterIndex)
getString(int index)
getTime(int index)
getTimestamp(int index)
getTimestamp(int index, Calendar cal)
getTimestamp(String parameterName)
getTimestamp(String name, Calendar cal)
getURL(int parameterIndex)
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, String typeName)
void
registerOutParameter(int parameterIndex, SQLType sqlType)
void
registerOutParameter(int parameterIndex, SQLType sqlType, int scale)
void
registerOutParameter(int parameterIndex, SQLType sqlType, int precision, int scale)
Registers the parameter in ordinal position index to be of JDBC type sqlType.void
registerOutParameter(int parameterIndex, SQLType sqlType, String typeName)
void
registerOutParameter(String parameterName, int sqlType)
void
registerOutParameter(String parameterName, int sqlType, int scale)
void
registerOutParameter(String parameterName, int sqlType, int precision, int scale)
Registers the parameter in ordinal position index to be of JDBC type sqlType.void
registerOutParameter(String parameterName, int sqlType, String typeName)
void
registerOutParameter(String parameterName, SQLType sqlType)
void
registerOutParameter(String parameterName, SQLType sqlType, int scale)
void
registerOutParameter(String parameterName, SQLType sqlType, int precision, int scale)
Registers the parameter in ordinal position index to be of JDBC type sqlType.void
registerOutParameter(String parameterName, SQLType sqlType, String typeName)
void
setAsciiStream(String parameterName, InputStream value)
void
setAsciiStream(String parameterName, InputStream value, int length)
void
setAsciiStream(String parameterName, InputStream value, long length)
void
setBigDecimal(String parameterName, BigDecimal value)
void
setBigDecimal(String parameterName, BigDecimal value, int precision, int scale)
Sets the designated parameter to the givenjava.math.BigDecimal
value.void
setBigDecimal(String parameterName, BigDecimal value, int precision, int scale, boolean forceEncrypt)
Sets the designated parameter to the givenjava.math.BigDecimal
value.void
setBinaryStream(String parameterName, InputStream value)
void
setBinaryStream(String parameterName, InputStream value, int length)
void
setBinaryStream(String parameterName, InputStream value, long length)
void
setBlob(String parameterName, InputStream value)
void
setBlob(String parameterName, InputStream inputStream, long length)
void
void
setBoolean(String parameterName, boolean value)
void
setBoolean(String parameterName, boolean value, boolean forceEncrypt)
Sets the designated parameter to the given Javaboolean
value.void
void
Sets the designated parameter to the given Javabyte
value.void
void
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
void
void
void
void
void
Sets the designated parameter to the givenjava.sql.Date
value, using the givenCalendar
object.void
setDateTime(String parameterName, Timestamp value)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
setDateTime(String parameterName, Timestamp value, boolean forceEncrypt)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
setDateTimeOffset(String parameterName, DateTimeOffset value)
Sets parameter parameterName to DateTimeOffset value.void
setDateTimeOffset(String parameterName, DateTimeOffset value, int scale)
Sets parameter parameterName to DateTimeOffset value.void
setDateTimeOffset(String parameterName, DateTimeOffset value, int scale, boolean forceEncrypt)
Sets parameter parameterName to DateTimeOffset value.void
void
Sets the designated parameter to the given Javadouble
value.void
void
Sets the designated parameter to the given Javafloat
value.void
void
Sets the designated parameter to the given Javaint
value.void
void
Sets the designated parameter to the given Javalong
value.void
setMoney(String parameterName, BigDecimal value)
Sets the designated parameter to the given Javajava.math.BigDecimal
value.void
setMoney(String parameterName, BigDecimal value, boolean forceEncrypt)
Sets the designated parameter to the given Javajava.math.BigDecimal
value.void
setNCharacterStream(String parameterName, Reader value)
void
setNCharacterStream(String parameterName, Reader value, long length)
void
void
void
void
setNString(String parameterName, String value)
void
setNString(String parameterName, String value, boolean forceEncrypt)
Sets the designated parameter to the givenString
object.void
void
void
void
void
void
Sets the value of the designated parameter with the given object.void
Sets the value of the designated parameter with the given object.void
void
void
Sets the value of the designated parameter with the given object.void
void
void
Sets the designated parameter to the given Javashort
value.void
setSmallDateTime(String parameterName, Timestamp value)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
setSmallDateTime(String parameterName, Timestamp value, boolean forceEncrypt)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
setSmallMoney(String parameterName, BigDecimal value)
Sets the designated parameter to the given Javajava.math.BigDecimal
value.void
setSmallMoney(String parameterName, BigDecimal value, boolean forceEncrypt)
Sets the designated parameter to the given Javajava.math.BigDecimal
value.void
void
void
Sets the designated parameter to the given JavaString
value.void
setStructured(String parameterName, String tvpName, ISQLServerDataRecord tvpDataRecord)
Populates a table valued parameter passed to a stored procedure with an ISQLServerDataRecord object.void
setStructured(String parameterName, String tvpName, SQLServerDataTable tvpDataTable)
Populates a table valued parameter passed to a stored procedure with a data table.void
setStructured(String parameterName, String tvpName, ResultSet tvpResultSet)
Populates a table valued parameter passed to a stored procedure with a ResultSet retrieved from another tablevoid
void
Sets the designated parameter to the givenjava.sql.Time
value.void
Sets the designated parameter to the givenjava.sql.Time
value.void
void
Sets the designated parameter to the givenjava.sql.Time
value, using the givenCalendar
object.void
setTimestamp(String parameterName, Timestamp value)
void
setTimestamp(String parameterName, Timestamp value, int scale)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
setTimestamp(String parameterName, Timestamp value, int scale, boolean forceEncrypt)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
setTimestamp(String parameterName, Timestamp value, Calendar calendar)
void
setTimestamp(String parameterName, Timestamp value, Calendar calendar, boolean forceEncrypt)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
setUniqueIdentifier(String parameterName, String guid)
Sets the designated parameter to the givenString
value.void
setUniqueIdentifier(String parameterName, String guid, boolean forceEncrypt)
Sets the designated parameter to the givenString
value.void
boolean
wasNull()
Methods inherited from class com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement
addBatch, addBatch, clearBatch, clearParameters, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeQuery, executeQuery, executeUpdate, executeUpdate, getMetaData, getParameterMetaData, getParameterMetaData, getPreparedStatementHandle, getUseFmtOnly, 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, setUseFmtOnly
Methods inherited from class com.microsoft.sqlserver.jdbc.SQLServerStatement
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
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
Methods inherited from interface com.microsoft.sqlserver.jdbc.ISQLServerPreparedStatement
getParameterMetaData, getPreparedStatementHandle, getUseFmtOnly, 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, setUseFmtOnly
Methods inherited from interface com.microsoft.sqlserver.jdbc.ISQLServerStatement
getCancelQueryTimeout, getResponseBuffering, setCancelQueryTimeout, setResponseBuffering
Methods inherited from interface java.sql.PreparedStatement
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
Methods inherited from interface java.sql.Statement
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
Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap
-
Method Details
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLServerException
-
registerOutParameter
public void registerOutParameter(int index, int sqlType, String typeName) throws SQLServerException- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLServerException
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLServerException
-
registerOutParameter
public void registerOutParameter(int index, int sqlType, int precision, int scale) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Registers the parameter in ordinal position index to be of JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.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.
- Specified by:
registerOutParameter
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- If any errors occur.
-
getInt
- Specified by:
getInt
in interfaceCallableStatement
- Throws:
SQLServerException
-
getInt
- Specified by:
getInt
in interfaceCallableStatement
- Throws:
SQLServerException
-
getString
- Specified by:
getString
in interfaceCallableStatement
- Throws:
SQLServerException
-
getString
- Specified by:
getString
in interfaceCallableStatement
- Throws:
SQLServerException
-
getNString
- Specified by:
getNString
in interfaceCallableStatement
- Throws:
SQLException
-
getNString
- Specified by:
getNString
in interfaceCallableStatement
- Throws:
SQLException
-
getBigDecimal
Deprecated.- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
getBigDecimal
@Deprecated public BigDecimal getBigDecimal(String parameterName, int scale) throws SQLServerExceptionDeprecated.Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.BigDecimal object in the Java programming language.- Specified by:
getBigDecimal
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the label for the columnscale
- the scale of the BigDecimal- Returns:
- the column value; if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- when an error occurs
-
getBoolean
- Specified by:
getBoolean
in interfaceCallableStatement
- Throws:
SQLServerException
-
getBoolean
- Specified by:
getBoolean
in interfaceCallableStatement
- Throws:
SQLServerException
-
getByte
- Specified by:
getByte
in interfaceCallableStatement
- Throws:
SQLServerException
-
getByte
- Specified by:
getByte
in interfaceCallableStatement
- Throws:
SQLServerException
-
getBytes
- Specified by:
getBytes
in interfaceCallableStatement
- Throws:
SQLServerException
-
getBytes
- Specified by:
getBytes
in interfaceCallableStatement
- Throws:
SQLServerException
-
getDate
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLServerException
-
getDate
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLServerException
-
getDate
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLServerException
-
getDate
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLServerException
-
getDouble
- Specified by:
getDouble
in interfaceCallableStatement
- Throws:
SQLServerException
-
getDouble
- Specified by:
getDouble
in interfaceCallableStatement
- Throws:
SQLServerException
-
getFloat
- Specified by:
getFloat
in interfaceCallableStatement
- Throws:
SQLServerException
-
getFloat
- Specified by:
getFloat
in interfaceCallableStatement
- Throws:
SQLServerException
-
getLong
- Specified by:
getLong
in interfaceCallableStatement
- Throws:
SQLServerException
-
getLong
- Specified by:
getLong
in interfaceCallableStatement
- Throws:
SQLServerException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLServerException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLServerException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getShort
- Specified by:
getShort
in interfaceCallableStatement
- Throws:
SQLServerException
-
getShort
- Specified by:
getShort
in interfaceCallableStatement
- Throws:
SQLServerException
-
getTime
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLServerException
-
getTime
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLServerException
-
getTime
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLServerException
-
getTime
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLServerException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLServerException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLServerException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLServerException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLServerException
-
getDateTime
Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getDateTime
in interfaceISQLServerCallableStatement
- Parameters:
index
- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- when an error occurs
-
getDateTime
Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getDateTime
in interfaceISQLServerCallableStatement
- Parameters:
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 column- Returns:
- the column value; if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- when an error occurs
-
getDateTime
Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.- Specified by:
getDateTime
in interfaceISQLServerCallableStatement
- Parameters:
index
- the first column is 1, the second is 2, ...cal
- the java.util.Calendar object to use in constructing the dateTime- Returns:
- the column value; if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- when an error occurs
-
getDateTime
Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language. This method uses the given calendar to construct an appropriate millisecond value for the timestamp if the underlying database does not store timezone information.- Specified by:
getDateTime
in interfaceISQLServerCallableStatement
- Parameters:
name
- the name of the columncal
- the java.util.Calendar object to use in constructing the dateTime- Returns:
- the column value; if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- when an error occurs
-
getSmallDateTime
Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getSmallDateTime
in interfaceISQLServerCallableStatement
- Parameters:
index
- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- when an error occurs
-
getSmallDateTime
Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getSmallDateTime
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- The name of a column.- Returns:
- the column value; if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- when an error occurs
-
getSmallDateTime
Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getSmallDateTime
in interfaceISQLServerCallableStatement
- Parameters:
index
- the first column is 1, the second is 2, ...cal
- the java.util.Calendar object to use in constructing the smalldateTime- Returns:
- the column value; if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- when an error occurs
-
getSmallDateTime
Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.- Specified by:
getSmallDateTime
in interfaceISQLServerCallableStatement
- Parameters:
name
- The name of a columncal
- the java.util.Calendar object to use in constructing the smalldateTime- Returns:
- the column value; if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- when an error occurs
-
getDateTimeOffset
Description copied from interface:ISQLServerCallableStatement
Returns the DateTimeOffset value of parameter with index parameterIndex.- Specified by:
getDateTimeOffset
in interfaceISQLServerCallableStatement
- Parameters:
index
- the first parameter is 1, the second is 2, and so on- Returns:
- DateTimeOffset value if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- if parameterIndex is out of range; if a database access error occurs or this method is called on a closedCallableStatement
-
getDateTimeOffset
Description copied from interface:ISQLServerCallableStatement
Returns the DateTimeOffset value of parameter with name parameterName.- Specified by:
getDateTimeOffset
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- DateTimeOffset value if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
wasNull
- Specified by:
wasNull
in interfaceCallableStatement
- Throws:
SQLServerException
-
getAsciiStream
Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of thisResultSet
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 largeLONGVARCHAR
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 methodInputStream.available
is called whether there is data available or not.- Specified by:
getAsciiStream
in interfaceISQLServerCallableStatement
- Parameters:
parameterIndex
- the first column is 1, the second is 2, ...- Returns:
- a Java input stream that delivers the database column value as a stream of one-byte ASCII characters; if
the value is SQL
NULL
, the value returned isnull
- Throws:
SQLServerException
- if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set
-
getAsciiStream
Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of thisResultSet
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 largeLONGVARCHAR
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 methodavailable
is called whether there is data available or not.- Specified by:
getAsciiStream
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- a Java input stream that delivers the database column value as a stream of one-byte ASCII characters. If
the value is SQL
NULL
, the value returned isnull
. - Throws:
SQLServerException
- if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set
-
getBigDecimal
- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLServerException
-
getBigDecimal
- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLServerException
-
getMoney
Description copied from interface:ISQLServerCallableStatement
Returns the value of the column specified as a java.math.BigDecimal object.- Specified by:
getMoney
in interfaceISQLServerCallableStatement
- Parameters:
parameterIndex
- The zero-based ordinal of a column.- Returns:
- the column value; if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- when an error occurs
-
getMoney
Description copied from interface:ISQLServerCallableStatement
Returns the value of the column specified as a java.math.BigDecimal object.- Specified by:
getMoney
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- The name of a column.- Returns:
- the column value; if the value is SQL NULL, the value returned is null.
- Throws:
SQLServerException
- when an error occurs
-
getSmallMoney
Description copied from interface:ISQLServerCallableStatement
Returns the value of the column specified as a java.math.BigDecimal object.- Specified by:
getSmallMoney
in interfaceISQLServerCallableStatement
- Parameters:
parameterIndex
- The zero-based ordinal of a column.- Returns:
- the column value; if the value is SQL NULL, the value returned is null
- Throws:
SQLServerException
- when an error occurs
-
getSmallMoney
Description copied from interface:ISQLServerCallableStatement
Returns the value of the column specified as a java.math.BigDecimal object.- Specified by:
getSmallMoney
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- The name of a column.- Returns:
- the column value; if the value is SQL NULL, the value returned is null.
- Throws:
SQLServerException
- when an error occurs
-
getBinaryStream
Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of thisResultSet
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 largeLONGVARBINARY
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 methodInputStream.available
is called whether there is data available or not.- Specified by:
getBinaryStream
in interfaceISQLServerCallableStatement
- Parameters:
parameterIndex
- the first column is 1, the second is 2, ...- Returns:
- a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the
value is SQL
NULL
, the value returned isnull
- Throws:
SQLServerException
- if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set
-
getBinaryStream
Description copied from interface:ISQLServerCallableStatement
Returns the value of the designated column in the current row of thisResultSet
object as a stream of uninterpretedbyte
s. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving largeLONGVARBINARY
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 methodavailable
is called whether there is data available or not.- Specified by:
getBinaryStream
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the
value is SQL
NULL
, the result isnull
- Throws:
SQLServerException
- if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set
-
getBlob
- Specified by:
getBlob
in interfaceCallableStatement
- Throws:
SQLServerException
-
getBlob
- Specified by:
getBlob
in interfaceCallableStatement
- Throws:
SQLServerException
-
getCharacterStream
- Specified by:
getCharacterStream
in interfaceCallableStatement
- Throws:
SQLServerException
-
getCharacterStream
- Specified by:
getCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getNCharacterStream
- Specified by:
getNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getNCharacterStream
- Specified by:
getNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getClob
- Specified by:
getClob
in interfaceCallableStatement
- Throws:
SQLServerException
-
getClob
- Specified by:
getClob
in interfaceCallableStatement
- Throws:
SQLServerException
-
getNClob
- Specified by:
getNClob
in interfaceCallableStatement
- Throws:
SQLException
-
getNClob
- Specified by:
getNClob
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getRef
- Specified by:
getRef
in interfaceCallableStatement
- Throws:
SQLException
-
getRef
- Specified by:
getRef
in interfaceCallableStatement
- Throws:
SQLException
-
getArray
- Specified by:
getArray
in interfaceCallableStatement
- Throws:
SQLException
-
getArray
- Specified by:
getArray
in interfaceCallableStatement
- Throws:
SQLException
-
setTimestamp
public void setTimestamp(String parameterName, Timestamp value, Calendar calendar) throws SQLServerException- Specified by:
setTimestamp
in interfaceCallableStatement
- Throws:
SQLServerException
-
setTimestamp
public void setTimestamp(String parameterName, Timestamp value, Calendar calendar, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.sql.Timestamp
value. The driver converts this to an SQLTIMESTAMP
value when it sends it to the database.- Specified by:
setTimestamp
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
- See Also:
CallableStatement.getTimestamp(int)
-
setTime
- Specified by:
setTime
in interfaceCallableStatement
- Throws:
SQLServerException
-
setTime
public void setTime(String parameterName, Time value, Calendar calendar, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.sql.Time
value, using the givenCalendar
object. The driver uses theCalendar
object to construct an SQLTIME
value, which the driver then sends to the database. With a aCalendar
object, the driver can calculate the time taking into account a custom timezone. If noCalendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.- Specified by:
setTime
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametervalue
- the parameter valuecalendar
- theCalendar
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
- See Also:
CallableStatement.getTime(int)
-
setDate
- Specified by:
setDate
in interfaceCallableStatement
- Throws:
SQLServerException
-
setDate
public void setDate(String parameterName, Date value, Calendar calendar, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.sql.Date
value, using the givenCalendar
object. The driver uses theCalendar
object to construct an SQLDATE
value, which the driver then sends to the database. With a aCalendar
object, the driver can calculate the date taking into account a custom timezone. If noCalendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.- Specified by:
setDate
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametervalue
- the parameter valuecalendar
- theCalendar
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
- See Also:
CallableStatement.getDate(int)
-
setCharacterStream
- Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setCharacterStream
public final void setCharacterStream(String parameterName, Reader value, int length) throws SQLException- Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setCharacterStream
public final void setCharacterStream(String parameterName, Reader reader, long length) throws SQLException- Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setNCharacterStream
- Specified by:
setNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setNCharacterStream
public final void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException- Specified by:
setNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
- Specified by:
setNClob
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
- Specified by:
setNClob
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
- Specified by:
setNClob
in interfaceCallableStatement
- Throws:
SQLException
-
setNString
- Specified by:
setNString
in interfaceCallableStatement
- Throws:
SQLException
-
setNString
public final void setNString(String parameterName, String value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenString
object. The driver converts this to a SQLNCHAR
orNVARCHAR
orLONGNVARCHAR
- Specified by:
setNString
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
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 closedCallableStatement
-
setObject
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLServerException
-
setObject
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLServerException
-
setObject
public void setObject(String parameterName, Object value, int sqlType, int decimals) throws SQLServerException- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLServerException
-
setObject
public void setObject(String parameterName, Object value, int sqlType, int decimals, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the value of the designated parameter with the given object.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 methodSQLData.writeSQL
to write it to the SQL data stream. If, on the other hand, the object is of a class implementingRef
,Blob
,Clob
,NClob
,Struct
,java.net.URL
, orArray
, 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.
- Specified by:
setObject
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
- See Also:
Types
,CallableStatement.getObject(int)
-
setObject
public final void setObject(String parameterName, Object value, int targetSqlType, Integer precision, int scale) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the value of the designated parameter with the given object.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 methodSQLData.writeSQL
to write it to the SQL data stream. If, on the other hand, the object is of a class implementingRef
,Blob
,Clob
,NClob
,Struct
,java.net.URL
, orArray
, 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.
- Specified by:
setObject
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
- See Also:
Types
,CallableStatement.getObject(int)
-
setAsciiStream
- Specified by:
setAsciiStream
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
public final void setAsciiStream(String parameterName, InputStream value, int length) throws SQLException- Specified by:
setAsciiStream
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
public final void setAsciiStream(String parameterName, InputStream value, long length) throws SQLException- Specified by:
setAsciiStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
- Specified by:
setBinaryStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
public final void setBinaryStream(String parameterName, InputStream value, int length) throws SQLException- Specified by:
setBinaryStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
public final void setBinaryStream(String parameterName, InputStream value, long length) throws SQLException- Specified by:
setBinaryStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
public final void setBlob(String parameterName, InputStream inputStream, long length) throws SQLException- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setTimestamp
- Specified by:
setTimestamp
in interfaceCallableStatement
- Throws:
SQLServerException
-
setTimestamp
public void setTimestamp(String parameterName, Timestamp value, int scale) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.sql.Timestamp
value. The driver converts this to an SQLTIMESTAMP
value when it sends it to the database.- Specified by:
setTimestamp
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametervalue
- the parameter valuescale
- the scale of the parameter- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
- See Also:
CallableStatement.getTimestamp(int)
-
setTimestamp
public void setTimestamp(String parameterName, Timestamp value, int scale, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.sql.Timestamp
value. The driver converts this to an SQLTIMESTAMP
value when it sends it to the database.- Specified by:
setTimestamp
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
- See Also:
CallableStatement.getTimestamp(int)
-
setDateTimeOffset
public void setDateTimeOffset(String parameterName, DateTimeOffset value) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets parameter parameterName to DateTimeOffset value.- Specified by:
setDateTimeOffset
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametervalue
- DateTimeOffset value- Throws:
SQLServerException
- if an error occurs
-
setDateTimeOffset
public void setDateTimeOffset(String parameterName, DateTimeOffset value, int scale) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets parameter parameterName to DateTimeOffset value.- Specified by:
setDateTimeOffset
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametervalue
- DateTimeOffset valuescale
- the scale of the parameter- Throws:
SQLServerException
- if an error occurs
-
setDateTimeOffset
public void setDateTimeOffset(String parameterName, DateTimeOffset value, int scale, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets parameter parameterName to DateTimeOffset value.- Specified by:
setDateTimeOffset
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if an error occurs
-
setDate
- Specified by:
setDate
in interfaceCallableStatement
- Throws:
SQLServerException
-
setTime
- Specified by:
setTime
in interfaceCallableStatement
- Throws:
SQLServerException
-
setTime
Description copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.sql.Time
value. The driver converts this to an SQLTIME
value when it sends it to the database.- Specified by:
setTime
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametervalue
- the parameter valuescale
- the scale of the column- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
- See Also:
CallableStatement.getTime(int)
-
setTime
public void setTime(String parameterName, Time value, int scale, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.sql.Time
value. The driver converts this to an SQLTIME
value when it sends it to the database.- Specified by:
setTime
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
- See Also:
CallableStatement.getTime(int)
-
setDateTime
Description copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.sql.Timestamp
value. The driver converts this to an SQLDATETIME
value when it sends it to the database.- Specified by:
setDateTime
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametervalue
- the parameter value- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setDateTime
public void setDateTime(String parameterName, Timestamp value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.sql.Timestamp
value. The driver converts this to an SQLDATETIME
value when it sends it to the database.- Specified by:
setDateTime
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setSmallDateTime
Description copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.sql.Timestamp
value. The driver converts this to an SQLSMALLDATETIME
value when it sends it to the database.- Specified by:
setSmallDateTime
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametervalue
- the parameter value- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setSmallDateTime
public void setSmallDateTime(String parameterName, Timestamp value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.sql.Timestamp
value. The driver converts this to an SQLSMALLDATETIME
value when it sends it to the database.- Specified by:
setSmallDateTime
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setUniqueIdentifier
Description copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenString
value. The driver converts this to an SQLuniqueIdentifier
value when it sends it to the database.- Specified by:
setUniqueIdentifier
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parameterguid
- the parameter value- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setUniqueIdentifier
public void setUniqueIdentifier(String parameterName, String guid, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenString
value. The driver converts this to an SQLuniqueIdentifier
value when it sends it to the database.- Specified by:
setUniqueIdentifier
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setBytes
- Specified by:
setBytes
in interfaceCallableStatement
- Throws:
SQLServerException
-
setBytes
public void setBytes(String parameterName, byte[] value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given Java array of bytes. The driver converts this to an SQLVARBINARY
orLONGVARBINARY
(depending on the argument's size relative to the driver's limits onVARBINARY
values) when it sends it to the database.- Specified by:
setBytes
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setByte
- Specified by:
setByte
in interfaceCallableStatement
- Throws:
SQLServerException
-
setByte
public void setByte(String parameterName, byte value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given Javabyte
value. The driver converts this to an SQLTINYINT
value when it sends it to the database.- Specified by:
setByte
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setString
- Specified by:
setString
in interfaceCallableStatement
- Throws:
SQLServerException
-
setString
public void setString(String parameterName, String value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given JavaString
value. The driver converts this to an SQLVARCHAR
orLONGVARCHAR
value (depending on the argument's size relative to the driver's limits onVARCHAR
values) when it sends it to the database.- Specified by:
setString
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setMoney
Description copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given Javajava.math.BigDecimal
value. The driver converts this to an SQLMoney
value.- Specified by:
setMoney
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametervalue
- the parameter value- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setMoney
public void setMoney(String parameterName, BigDecimal value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given Javajava.math.BigDecimal
value. The driver converts this to an SQLMoney
value.- Specified by:
setMoney
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setSmallMoney
Description copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given Javajava.math.BigDecimal
value. The driver converts this to an SQLsmallMoney
value.- Specified by:
setSmallMoney
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametervalue
- the parameter value- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setSmallMoney
public void setSmallMoney(String parameterName, BigDecimal value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given Javajava.math.BigDecimal
value. The driver converts this to an SQLsmallMoney
value.- Specified by:
setSmallMoney
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setBigDecimal
- Specified by:
setBigDecimal
in interfaceCallableStatement
- Throws:
SQLServerException
-
setBigDecimal
public void setBigDecimal(String parameterName, BigDecimal value, int precision, int scale) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.math.BigDecimal
value. The driver converts this to an SQLNUMERIC
value when it sends it to the database.- Specified by:
setBigDecimal
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametervalue
- the parameter valueprecision
- the precision of the columnscale
- the scale of the column- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setBigDecimal
public void setBigDecimal(String parameterName, BigDecimal value, int precision, int scale, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the givenjava.math.BigDecimal
value. The driver converts this to an SQLNUMERIC
value when it sends it to the database.- Specified by:
setBigDecimal
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setDouble
- Specified by:
setDouble
in interfaceCallableStatement
- Throws:
SQLServerException
-
setDouble
public void setDouble(String parameterName, double value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given Javadouble
value. The driver converts this to an SQLDOUBLE
value when it sends it to the database.- Specified by:
setDouble
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setFloat
- Specified by:
setFloat
in interfaceCallableStatement
- Throws:
SQLServerException
-
setFloat
public void setFloat(String parameterName, float value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given Javafloat
value. The driver converts this to an SQLFLOAT
value when it sends it to the database.- Specified by:
setFloat
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setInt
- Specified by:
setInt
in interfaceCallableStatement
- Throws:
SQLServerException
-
setInt
public void setInt(String parameterName, int value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given Javaint
value. The driver converts this to an SQLINTEGER
value when it sends it to the database.- Specified by:
setInt
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setLong
- Specified by:
setLong
in interfaceCallableStatement
- Throws:
SQLServerException
-
setLong
public void setLong(String parameterName, long value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given Javalong
value. The driver converts this to an SQLBIGINT
value when it sends it to the database.- Specified by:
setLong
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setShort
- Specified by:
setShort
in interfaceCallableStatement
- Throws:
SQLServerException
-
setShort
public void setShort(String parameterName, short value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given Javashort
value. The driver converts this to an SQLSMALLINT
value when it sends it to the database.- Specified by:
setShort
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setBoolean
- Specified by:
setBoolean
in interfaceCallableStatement
- Throws:
SQLServerException
-
setBoolean
public void setBoolean(String parameterName, boolean value, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the designated parameter to the given Javaboolean
value. The driver converts this to an SQLBIT
orBOOLEAN
value when it sends it to the database.- Specified by:
setBoolean
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
-
setNull
- Specified by:
setNull
in interfaceCallableStatement
- Throws:
SQLServerException
-
setNull
- Specified by:
setNull
in interfaceCallableStatement
- Throws:
SQLServerException
-
setURL
- Specified by:
setURL
in interfaceCallableStatement
- Throws:
SQLException
-
setStructured
public final void setStructured(String parameterName, String tvpName, SQLServerDataTable tvpDataTable) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Populates a table valued parameter passed to a stored procedure with a data table.- Specified by:
setStructured
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametertvpName
- the name of the type TVPtvpDataTable
- the data table object- Throws:
SQLServerException
- when an error occurs
-
setStructured
public final void setStructured(String parameterName, String tvpName, ResultSet tvpResultSet) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Populates a table valued parameter passed to a stored procedure with a ResultSet retrieved from another table- Specified by:
setStructured
in interfaceISQLServerCallableStatement
- Parameters:
parameterName
- the name of the parametertvpName
- the name of the type TVPtvpResultSet
- the source result set object- Throws:
SQLServerException
- when an error occurs
-
setStructured
public final void setStructured(String parameterName, String tvpName, ISQLServerDataRecord tvpDataRecord) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Populates a table valued parameter passed to a stored procedure with an ISQLServerDataRecord object.- Specified by:
setStructured
in interfaceISQLServerCallableStatement
- Parameters:
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 object- Throws:
SQLServerException
- when an error occurs
-
getURL
- Specified by:
getURL
in interfaceCallableStatement
- Throws:
SQLException
-
getURL
- Specified by:
getURL
in interfaceCallableStatement
- Throws:
SQLException
-
setSQLXML
- Specified by:
setSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
getSQLXML
- Specified by:
getSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
getSQLXML
- Specified by:
getSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
setRowId
- Specified by:
setRowId
in interfaceCallableStatement
- Throws:
SQLException
-
getRowId
- Specified by:
getRowId
in interfaceCallableStatement
- Throws:
SQLException
-
getRowId
- Specified by:
getRowId
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLServerException- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLServerException
-
registerOutParameter
public void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLServerException- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLServerException
-
registerOutParameter
public void registerOutParameter(String parameterName, int sqlType, int precision, int scale) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Registers the parameter in ordinal position index to be of JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.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.
- Specified by:
registerOutParameter
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- If any errors occur.
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLServerException
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLServerException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, SQLType sqlType, String typeName) throws SQLServerException- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLServerException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, SQLType sqlType, int scale) throws SQLServerException- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLServerException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, SQLType sqlType, int precision, int scale) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Registers the parameter in ordinal position index to be of JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.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.
- Specified by:
registerOutParameter
in interfaceISQLServerCallableStatement
- Parameters:
parameterIndex
- 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.- Throws:
SQLServerException
- If any errors occur.
-
setObject
public void setObject(String parameterName, Object value, SQLType jdbcType) throws SQLServerException- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLServerException
-
setObject
public void setObject(String parameterName, Object value, SQLType jdbcType, int scale) throws SQLServerException- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLServerException
-
setObject
public void setObject(String parameterName, Object value, SQLType jdbcType, int scale, boolean forceEncrypt) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Sets the value of the designated parameter with the given object.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 methodSQLData.writeSQL
to write it to the SQL data stream. If, on the other hand, the object is of a class implementingRef
,Blob
,Clob
,NClob
,Struct
,java.net.URL
, orArray
, 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.
- Specified by:
setObject
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closedCallableStatement
- See Also:
Types
,CallableStatement.getObject(int)
-
registerOutParameter
public void registerOutParameter(String parameterName, SQLType sqlType, String typeName) throws SQLServerException- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLServerException
-
registerOutParameter
public void registerOutParameter(String parameterName, SQLType sqlType, int scale) throws SQLServerException- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLServerException
-
registerOutParameter
public void registerOutParameter(String parameterName, SQLType sqlType, int precision, int scale) throws SQLServerExceptionDescription copied from interface:ISQLServerCallableStatement
Registers the parameter in ordinal position index to be of JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.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.
- Specified by:
registerOutParameter
in interfaceISQLServerCallableStatement
- Parameters:
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.- Throws:
SQLServerException
- If any errors occur.
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLServerException
-