SQLServerCallableStatement Members
The following tables list the members that are exposed by the SQLServerCallableStatement class.
Constructors
None.
Fields
| Class inherited from: | Methods |
|---|---|
java.sql.Statement |
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO |
Inherited Fields
None.
Methods
| Name | Description |
|---|---|
(Inherited from SQLServerPreparedStatement.) Adds a set of parameters to the batch of commands for this CallableStatement object. |
|
(Inherited from SQLServerStatement.) Cancels the SQL statement that is currently being run by this CallableStatement object. |
|
(Inherited from SQLServerPreparedStatement.) Empties the current list of SQL commands for this CallableStatement object. |
|
(Inherited from SQLServerPreparedStatement.) Clears the current parameter values immediately. |
|
(Inherited from SQLServerStatement.) Clears all the warnings that are reported on this CallableStatement object. |
|
(Inherited from SQLServerPreparedStatement.) Releases the database and JDBC resources of this CallableStatement object immediately instead of waiting for them to be automatically released. |
|
(Inherited from SQLServerPreparedStatement.) Runs the SQL statement in this CallableStatement object, which can be any kind of SQL statement. |
|
(Inherited from SQLServerPreparedStatement.) Submits a batch of commands to the database to be run. If all commands run successfully, returns an array of update counts. |
|
(Inherited from SQLServerPreparedStatement.) Runs the SQL query in this CallableStatement object and returns the SQLServerResultSet object that is generated by the query. |
|
(Inherited from SQLServerPreparedStatement.) Runs the SQL statement in this CallableStatement object, which must be an SQL INSERT, UPDATE, or DELETE statement; or an SQL statement that returns nothing, such as a DDL statement. |
|
(Inherited from SQLServerStatement.) Retrieves the SQLServerConnection object that produced this CallableStatement object. |
|
(Inherited from SQLServerStatement.) Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this CallableStatement object. |
|
(Inherited from SQLServerStatement.) Retrieves the number of result set rows that is the default fetch size for result set objects generated from this CallableStatement object. |
|
(Inherited from SQLServerStatement.) Retrieves any auto-generated keys that are created as a result of running this CallableStatement object. |
|
(Inherited from SQLServerStatement.) Retrieves the maximum number of bytes that can be returned for character and binary column values in a SQLServerResultSet object produced by this CallableStatement object. |
|
(Inherited from SQLServerStatement.) Retrieves the maximum number of rows that a SQLServerResultSet object produced by this CallableStatement object can contain. |
|
(Inherited from SQLServerPreparedStatement.) Retrieves a SQLServerResultSetMetaData Class object that contains information about the columns of the SQLServerResultSet object that will be returned when this CallableStatement object is run. |
|
(Inherited from SQLServerStatement.) Moves to the next result of this CallableStatement object. |
|
(Inherited from SQLServerPreparedStatement.) Retrieves the number, types, and properties of the parameters for this CallableStatement object. |
|
Retrieves the value of the designated parameter as an Array object. |
|
Retrieves the value of the designated parameter as a stream of ASCII characters. |
|
Retrieves the value of the designated parameter as java.math.BigDecimal. |
|
Retrieves the value of the designated parameter as a binary stream of uninterrupted bytes. |
|
Retrieves the value of the designated JDBC Blob parameter as a Blob object in the Java programming language. |
|
Retrieves the value of the designated parameter as a boolean value. |
|
Retrieves the value of the designated parameter as a byte value. |
|
Retrieves the value of the designated parameter as an array of bytes. |
|
Retrieves the value of the designated parameter as a java.io.Reader object. |
|
Retrieves the value of the designated JDBC Blob parameter as a Clob object in the Java programming language. |
|
Retrieves the value of the designated parameter as a java.sql.Date object in the Java programming language. |
|
Retrieves the value of the designated parameter as a double in the Java programming language. |
|
Retrieves the value of the designated parameter as a float in the Java programming language. |
|
Retrieves the value of the designated parameter as an int in the Java programming language. |
|
Retrieves the value of the designated parameter as a long in the Java programming language. |
|
Retrieves the value of the designated parameter as a Reader object. |
|
Retrieves the value of the designated JDBC NCLOB parameter as an NClob object in the Java programming language. |
|
Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language. |
|
Retrieves the value of the designated parameter as an object in the Java programming language. |
|
(Inherited from SQLServerStatement.) Retrieves the number of seconds the Microsoft SQL Server JDBC Driver will wait for this CallableStatement object to run. |
|
Retrieves the value of the designated parameter as a Ref object in the Java programming language. |
|
(Inherited from SQLServerStatement.) Retrieves the response buffering mode for this SQLServerStatement object. |
|
(Inherited from SQLServerStatement.) Retrieves the current result as a SQLServerResultSet object. |
|
(Inherited from SQLServerStatement.) Retrieves the result set concurrency for SQLServerResultSet objects that are generated by this CallableStatement object. |
|
(Inherited from SQLServerStatement.) Retrieves the result set holdability for SQLServerResultSet objects that are generated by this CallableStatement object. |
|
(Inherited from SQLServerStatement.) Retrieves the result set type for SQLServerResultSet objects that are generated by this CallableStatement object. |
|
Retrieves the value of the designated parameter as a short in the Java programming language. |
|
Retrieves the value of the designated parameter as a String in the Java programming language. |
|
Retrieves the value of the designated parameter as a java.sql.SQLXML object. |
|
Retrieves the value of the designated parameter as a java.sql.Time object in the Java programming language. |
|
Retrieves the value of the designated parameter as a java.sql.Timestamp object in the Java programming language. |
|
(Inherited from SQLServerStatement.) Retrieves the current result as an update count. |
|
Retrieves the value of the designated parameter as a URL object in the Java programming language. |
|
(Inherited from SQLServerStatement.) Retrieves the first warning that is reported by calls on this CallableStatement object. |
|
(Inherited from SQLServerStatement.) Indicates whether this Statement object has been closed. |
|
Indicates whether this statement object is a wrapper for the specified interface. |
|
Registers the OUT parameter. |
|
(Inherited from SQLServerPreparedStatement.) Sets the designated parameter number to the given Array object. |
|
Sets the designated parameter to the given input stream. |
|
Sets the designated parameter number to the given BigDecimal object. |
|
Sets the designated parameter to the specified input stream. |
|
(Inherited from SQLServerPreparedStatement.) Sets the designated parameter to the given Blob object. |
|
Sets the designated parameter to the given boolean value. |
|
Sets the designated parameter to the given byte value. |
|
Sets the designated parameter to the given array of byte values. |
|
Sets the designated parameter to the given Reader object. |
|
(Inherited from SQLServerPreparedStatement.) Sets the designated parameter to the specified object. |
|
(Inherited from SQLServerStatement.) Sets the SQL cursor name to the given String, which will be used by subsequent execute methods. |
|
Sets the designated parameter to the given date value. |
|
Sets the designated parameter to the given double value. |
|
(Inherited from SQLServerStatement.) Sets the escape processing mode. |
|
(Inherited from SQLServerStatement.) Gives the JDBC driver a hint as to the direction in which result set rows should be processed. |
|
(Inherited from SQLServerStatement.) Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed. |
|
Sets the designated parameter to the specified float value. |
|
Sets the designated parameter to the specified int value. |
|
Sets the designated parameter to the specified long value. |
|
(Inherited from SQLServerStatement.) Sets the limit for the maximum number of bytes in a SQLServerResultSet column storing character or binary values to the specified number of bytes. |
|
(Inherited from SQLServerStatement.) Sets the limit for the maximum number of rows that any SQLServerResultSet object can contain to the specified number. |
|
Sets the designated parameter to the specified Reader object. |
|
Sets the designated parameter to the specified object. |
|
Sets the designated parameter to the specified String object. |
|
Sets the designated parameter to a null value, given the type of parameter to set. |
|
Sets the value of the designated parameter using the given object. |
|
(Inherited from SQLServerStatement.) Sets the number of seconds the driver will wait for a CallableStatement object to run to the specified number of seconds. |
|
(Inherited from SQLServerPreparedStatement.) Sets the designated parameter to the specified Ref object. |
|
(Inherited from SQLServerStatement.) Sets the response buffering mode for this SQLServerStatement object to case-insensitive String full or adaptive. |
|
Sets the designated parameter to the specified short value. |
|
Sets the designated parameter to the specified Java String value. |
|
Sets the designated parameter to the specified SQLXML object. |
|
Sets the designated parameter to the specified time value. |
|
Sets the designated parameter to the specified timestamp value. |
|
(Inherited from SQLServerPreparedStatement.) Sets the designated parameter number to the given input stream, which will have the specified number of bytes. |
|
Sets the designated parameter to the specified URL value. |
|
Returns an object that implements the specified interface to allow access to the Microsoft SQL Server JDBC Driver-specific methods. |
|
Retrieves whether the last OUT parameter read had the value of SQL NULL. |
Inherited Methods
| Class inherited from: | Methods |
|---|---|
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement |
addBatch, clearBatch, clearParameters, close, execute, executeBatch, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setboolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDouble, setFloat, setInt, setLong, setNull, setObject, setRef, setShort, setString, setTime, setTimestamp, setUnicodeStream, setURL |
com.microsoft.sqlserver.jdbc.SQLServerStatement |
cancel, clearWarnings, execute, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout |
class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, |
java.sql.PreparedStatement |
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, getSQLXML, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setboolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setObject, setRef, setShort, setString, setSQLXML, setTime, setTimestamp, setUnicodeStream, setURL |
java.sql.Statement |
addBatch, cancel, clearBatch, clearWarnings, close, execute, executeBatch, executeQuery, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout |
java.sql.Wrapper |
isWrapperFor, unwrap |