com.microsoft.sqlserver.jdbc

Interface ISQLServerCallableStatement

All Superinterfaces:

AutoCloseable, CallableStatement, ISQLServerPreparedStatement, ISQLServerStatement, PreparedStatement, Statement, Wrapper

All Known Subinterfaces:

ISQLServerCallableStatement42

All Known Implementing Classes:

SQLServerCallableStatement, SQLServerCallableStatement42

public interface ISQLServerCallableStatement
extends CallableStatement, ISQLServerPreparedStatement

This interface is implemented by SQLServerCallableStatement Class.

Field Summary

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 Type	Method and Description
DateTimeOffset	getDateTimeOffset(int parameterIndex) Gets the DateTimeOffset value of parameter with index parameterIndex
DateTimeOffset	getDateTimeOffset(String parameterName) Gets the DateTimeOffset value of parameter with name parameterName
void	setDateTimeOffset(String parameterName, DateTimeOffset x) Sets parameter parameterName to DateTimeOffset x

Methods inherited from interface java.sql.CallableStatement

getArray, getArray, getBigDecimal, getBigDecimal, getBigDecimal, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getInt, getInt, getLong, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, 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, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, wasNull

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

setDateTimeOffset

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 com.microsoft.sqlserver.jdbc.ISQLServerStatement

getResponseBuffering, setResponseBuffering

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Method Detail

setDateTimeOffset

void setDateTimeOffset(String parameterName,
                       DateTimeOffset x)
                throws SQLException

Sets parameter parameterName to DateTimeOffset x

Parameters:

parameterName - the name of the parameter

x - DateTimeOffset value

Throws:

SQLException - 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

getDateTimeOffset

DateTimeOffset getDateTimeOffset(int parameterIndex)
                          throws SQLException

Gets the DateTimeOffset value of parameter with index parameterIndex

Parameters:

parameterIndex - the first parameter is 1, the second is 2, and so on

Returns:

DateTimeOffset value

Throws:

SQLException - if parameterIndex is out of range; if a database access error occurs or this method is called on a closed CallableStatement

getDateTimeOffset

DateTimeOffset getDateTimeOffset(String parameterName)
                          throws SQLException

Gets the DateTimeOffset value of parameter with name parameterName

Parameters:

parameterName - the name of the parameter

Returns:

DateTimeOffset value

Throws:

SQLException - if parameterName does not correspond to a named parameter; if a database access error occurs or this method is called on a closed CallableStatement