Class CallableProcedureStatement
- All Implemented Interfaces:
AutoCloseable
,Cloneable
,CallableStatement
,PreparedStatement
,Statement
,Wrapper
- Direct Known Subclasses:
MariaDbProcedureStatement
-
Field Summary
FieldsModifier and TypeFieldDescriptionprotected boolean
protected int[]
protected CallableParameterMetaData
protected List<CallParameter>
Information about parameters, merely from registerOutputParameter() and setXXX() calls.Fields inherited from class org.mariadb.jdbc.ServerSidePreparedStatement
parameterCount
Fields inherited from class org.mariadb.jdbc.BasePrepareStatement
autoGeneratedKeys, hasLongData, SPEC_ISO_ZONED_DATE_TIME
Fields inherited from class org.mariadb.jdbc.MariaDbStatement
canUseServerTimeout, closed, connection, executing, fetchSize, lock, maxRows, options, protocol, queryTimeout, results, resultSetConcurrency, resultSetScrollType
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
-
Constructor Summary
ConstructorsConstructorDescriptionCallableProcedureStatement
(MariaDbConnection connection, String sql, int resultSetScrollType, int resultSetConcurrency) Constructor for getter/setter of callableStatement. -
Method Summary
Modifier and TypeMethodDescriptionclone
(MariaDbConnection connection) Clone data.getArray
(int parameterIndex) getBigDecimal
(int parameterIndex) getBigDecimal
(int parameterIndex, int scale) Deprecated.getBigDecimal
(String parameterName) getBlob
(int parameterIndex) boolean
getBoolean
(int parameterIndex) boolean
getBoolean
(String parameterName) byte
getByte
(int parameterIndex) byte
byte[]
getBytes
(int parameterIndex) byte[]
getCharacterStream
(int parameterIndex) getCharacterStream
(String parameterName) getClob
(int parameterIndex) getDate
(int parameterIndex) double
getDouble
(int parameterIndex) double
float
getFloat
(int parameterIndex) float
int
getInt
(int parameterIndex) int
long
getLong
(int parameterIndex) long
getNCharacterStream
(int parameterIndex) getNCharacterStream
(String parameterName) getNClob
(int parameterIndex) getNString
(int parameterIndex) getNString
(String parameterName) getObject
(int parameterIndex) <T> T
<T> T
protected abstract SelectResultSet
private CallParameter
getParameter
(int index) Retrieves the number, types and properties of thisPreparedStatement
object's parameters.getRef
(int parameterIndex) getRowId
(int parameterIndex) short
getShort
(int parameterIndex) short
getSQLXML
(int parameterIndex) getString
(int parameterIndex) getTime
(int parameterIndex) getTimestamp
(int parameterIndex) getTimestamp
(int parameterIndex, Calendar cal) getTimestamp
(String parameterName) getTimestamp
(String parameterName, Calendar cal) getURL
(int parameterIndex) private int
indexToOutputIndex
(int parameterIndex) Convert parameter index to corresponding outputIndex.private int
nameToIndex
(String parameterName) Convert parameter name to parameter index in the query.private int
nameToOutputIndex
(String parameterName) Convert parameter name to output parameter index in the query.void
registerOutParameter
(int parameterIndex, int sqlType) void
registerOutParameter
(int parameterIndex, int sqlType, int scale) Registers the parameter in ordinal positionparameterIndex
to be of JDBC typesqlType
.void
registerOutParameter
(int parameterIndex, int sqlType, String typeName) Registers the designated output parameter.void
registerOutParameter
(int parameterIndex, SQLType sqlType) void
registerOutParameter
(int parameterIndex, SQLType sqlType, int scale) 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, String typeName) void
registerOutParameter
(String parameterName, SQLType sqlType) void
registerOutParameter
(String parameterName, SQLType sqlType, int scale) void
registerOutParameter
(String parameterName, SQLType sqlType, String typeName) void
setAsciiStream
(String parameterName, InputStream inputStream) void
setAsciiStream
(String parameterName, InputStream inputStream, int length) void
setAsciiStream
(String parameterName, InputStream inputStream, long length) void
setBigDecimal
(String parameterName, BigDecimal bigDecimal) void
setBinaryStream
(String parameterName, InputStream inputStream) void
setBinaryStream
(String parameterName, InputStream inputStream, int length) void
setBinaryStream
(String parameterName, InputStream inputStream, long length) void
setBlob
(String parameterName, InputStream inputStream) void
setBlob
(String parameterName, InputStream inputStream, long length) void
void
setBoolean
(String parameterName, boolean booleanValue) void
void
void
setCharacterStream
(String parameterName, Reader reader) void
setCharacterStream
(String parameterName, Reader reader, int length) void
setCharacterStream
(String parameterName, Reader reader, long length) void
void
void
void
void
void
void
void
void
void
setNCharacterStream
(String parameterName, Reader value) void
setNCharacterStream
(String parameterName, Reader value, long length) void
void
void
void
setNString
(String parameterName, String value) void
void
void
void
void
void
void
void
Set in/out parameters value.void
void
void
void
void
void
void
setTimestamp
(String parameterName, Timestamp timestamp) void
setTimestamp
(String parameterName, Timestamp timestamp, Calendar cal) void
boolean
wasNull()
Methods inherited from class org.mariadb.jdbc.ServerSidePreparedStatement
addBatch, addBatch, clearBatch, clearParameters, close, execute, executeBatch, executeInternal, executeLargeBatch, executeQuery, executeUpdate, getMetaData, getParameterCount, getServerThreadId, setParameter, toString, validParameters
Methods inherited from class org.mariadb.jdbc.BasePrepareStatement
executeLargeUpdate, 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, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
Methods inherited from class org.mariadb.jdbc.MariaDbStatement
cancel, checkClose, checkCloseOnCompletion, clearWarnings, closeOnCompletion, execute, execute, execute, execute, executeBatchEpilogue, executeBatchExceptionEpilogue, executeEpilogue, executeExceptionEpilogue, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeQueryPrologue, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setLocalInfileInputStream, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, setTimerTask, skipMoreResults, testExecute, unwrap
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
Methods inherited from interface java.sql.PreparedStatement
addBatch, clearParameters, execute, executeLargeUpdate, executeQuery, executeUpdate, getMetaData, 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
-
Field Details
-
params
Information about parameters, merely from registerOutputParameter() and setXXX() calls. -
outputParameterMapper
protected int[] outputParameterMapper -
parameterMetadata
-
hasInOutParameters
protected boolean hasInOutParameters
-
-
Constructor Details
-
CallableProcedureStatement
public CallableProcedureStatement(MariaDbConnection connection, String sql, int resultSetScrollType, int resultSetConcurrency) throws SQLException Constructor for getter/setter of callableStatement.- Parameters:
connection
- current connectionsql
- queryresultSetScrollType
- one of the followingResultSet
constants:ResultSet.TYPE_FORWARD_ONLY
,ResultSet.TYPE_SCROLL_INSENSITIVE
, orResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency
- a concurrency type; one ofResultSet.CONCUR_READ_ONLY
orResultSet.CONCUR_UPDATABLE
- Throws:
SQLException
- is prepareStatement connection throw any error
-
-
Method Details
-
clone
public CallableProcedureStatement clone(MariaDbConnection connection) throws CloneNotSupportedException Clone data.- Overrides:
clone
in classServerSidePreparedStatement
- Parameters:
connection
- connection- Returns:
- Cloned .
- Throws:
CloneNotSupportedException
- if any error occur.
-
setParametersVariables
public void setParametersVariables()Set in/out parameters value. -
getOutputResult
- Throws:
SQLException
-
getParameterMetaData
Description copied from class:BasePrepareStatement
Retrieves the number, types and properties of thisPreparedStatement
object's parameters.- Specified by:
getParameterMetaData
in interfacePreparedStatement
- Overrides:
getParameterMetaData
in classServerSidePreparedStatement
- Returns:
- a
ParameterMetaData
object that contains information about the number, types and properties for each parameter marker of thisPreparedStatement
object - Throws:
SQLException
- if a database access error occurs or this method is called on a closedPreparedStatement
- See Also:
-
nameToIndex
Convert parameter name to parameter index in the query.- Parameters:
parameterName
- name- Returns:
- index
- Throws:
SQLException
- exception
-
nameToOutputIndex
Convert parameter name to output parameter index in the query.- Parameters:
parameterName
- name- Returns:
- index
- Throws:
SQLException
- exception
-
indexToOutputIndex
Convert parameter index to corresponding outputIndex.- Parameters:
parameterIndex
- index- Returns:
- index
- Throws:
SQLException
- exception
-
wasNull
- Specified by:
wasNull
in interfaceCallableStatement
- Throws:
SQLException
-
getString
- Specified by:
getString
in interfaceCallableStatement
- Throws:
SQLException
-
getString
- Specified by:
getString
in interfaceCallableStatement
- Throws:
SQLException
-
getBoolean
- Specified by:
getBoolean
in interfaceCallableStatement
- Throws:
SQLException
-
getBoolean
- Specified by:
getBoolean
in interfaceCallableStatement
- Throws:
SQLException
-
getByte
- Specified by:
getByte
in interfaceCallableStatement
- Throws:
SQLException
-
getByte
- Specified by:
getByte
in interfaceCallableStatement
- Throws:
SQLException
-
getShort
- Specified by:
getShort
in interfaceCallableStatement
- Throws:
SQLException
-
getShort
- Specified by:
getShort
in interfaceCallableStatement
- Throws:
SQLException
-
getInt
- Specified by:
getInt
in interfaceCallableStatement
- Throws:
SQLException
-
getInt
- Specified by:
getInt
in interfaceCallableStatement
- Throws:
SQLException
-
getLong
- Specified by:
getLong
in interfaceCallableStatement
- Throws:
SQLException
-
getLong
- Specified by:
getLong
in interfaceCallableStatement
- Throws:
SQLException
-
getFloat
- Specified by:
getFloat
in interfaceCallableStatement
- Throws:
SQLException
-
getFloat
- Specified by:
getFloat
in interfaceCallableStatement
- Throws:
SQLException
-
getDouble
- Specified by:
getDouble
in interfaceCallableStatement
- Throws:
SQLException
-
getDouble
- Specified by:
getDouble
in interfaceCallableStatement
- Throws:
SQLException
-
getBigDecimal
Deprecated.- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
getBigDecimal
- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
getBigDecimal
- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
getBytes
- Specified by:
getBytes
in interfaceCallableStatement
- Throws:
SQLException
-
getBytes
- Specified by:
getBytes
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
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
-
getBlob
- Specified by:
getBlob
in interfaceCallableStatement
- Throws:
SQLException
-
getBlob
- Specified by:
getBlob
in interfaceCallableStatement
- Throws:
SQLException
-
getClob
- Specified by:
getClob
in interfaceCallableStatement
- Throws:
SQLException
-
getClob
- Specified by:
getClob
in interfaceCallableStatement
- Throws:
SQLException
-
getArray
- Specified by:
getArray
in interfaceCallableStatement
- Throws:
SQLException
-
getArray
- Specified by:
getArray
in interfaceCallableStatement
- Throws:
SQLException
-
getURL
- Specified by:
getURL
in interfaceCallableStatement
- Throws:
SQLException
-
getURL
- Specified by:
getURL
in interfaceCallableStatement
- Throws:
SQLException
-
getRowId
- Specified by:
getRowId
in interfaceCallableStatement
- Throws:
SQLException
-
getRowId
- Specified by:
getRowId
in interfaceCallableStatement
- Throws:
SQLException
-
getNClob
- Specified by:
getNClob
in interfaceCallableStatement
- Throws:
SQLException
-
getNClob
- Specified by:
getNClob
in interfaceCallableStatement
- Throws:
SQLException
-
getSQLXML
- Specified by:
getSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
getSQLXML
- Specified by:
getSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
getNString
- Specified by:
getNString
in interfaceCallableStatement
- Throws:
SQLException
-
getNString
- Specified by:
getNString
in interfaceCallableStatement
- Throws:
SQLException
-
getNCharacterStream
- Specified by:
getNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getNCharacterStream
- Specified by:
getNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getCharacterStream
- Specified by:
getCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getCharacterStream
- Specified by:
getCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, String typeName) throws SQLException Registers the designated output parameter. This version of the method
registerOutParameter
should be used for a user-defined orREF
output parameter. Examples of user-defined types include:STRUCT
,DISTINCT
,JAVA_OBJECT
, and named array types.All OUT parameters must be registered before a stored procedure is executed.
For a user-defined parameter, the fully-qualified SQL type name of the parameter should also be given, while a
REF
parameter requires that the fully-qualified type name of the referenced type be given. A JDBC driver that does not need the type code and type name information may ignore it. To be portable, however, applications should always provide these values for user-defined andREF
parameters.Although it is intended for user-defined and
REF
parameters, this method may be used to register a parameter of any JDBC type. If the parameter does not have a user-defined orREF
type, the typeName parameter is ignored.Note: When reading the value of an out parameter, you must use the getter method whose Java type corresponds to the parameter's registered SQL type.
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2,...sqlType
- a value fromTypes
typeName
- the fully-qualified name of an SQL structured type- Throws:
SQLException
- if the parameterIndex is not valid; if a database access error occurs or this method is called on a closedCallableStatement
- See Also:
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
Registers the parameter in ordinal position
parameterIndex
to be of JDBC typesqlType
. 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 theget
method to read the value of that parameter.This version of
registerOutParameter
should be used when the parameter is of JDBC typeNUMERIC
orDECIMAL
.- Specified by:
registerOutParameter
in interfaceCallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so onsqlType
- the SQL type code defined byjava.sql.Types
.scale
- the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.- Throws:
SQLException
- if the parameterIndex is not valid; if a database access error occurs or this method is called on a closedCallableStatement
- See Also:
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException - Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, SQLType sqlType, int scale) throws SQLException - Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, SQLType sqlType, String typeName) throws SQLException - Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(String parameterName, SQLType sqlType, int scale) throws SQLException - Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(String parameterName, SQLType sqlType, String typeName) throws SQLException - Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
getParameter
- Throws:
SQLException
-
setSQLXML
- Specified by:
setSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
setRowId
- Specified by:
setRowId
in interfaceCallableStatement
- Throws:
SQLException
-
setNString
- Specified by:
setNString
in interfaceCallableStatement
- Throws:
SQLException
-
setNCharacterStream
public void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException - Specified by:
setNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setNCharacterStream
- Specified by:
setNCharacterStream
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
-
setClob
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
public void setAsciiStream(String parameterName, InputStream inputStream, long length) throws SQLException - Specified by:
setAsciiStream
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
public void setAsciiStream(String parameterName, InputStream inputStream, int length) throws SQLException - Specified by:
setAsciiStream
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
- Specified by:
setAsciiStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
public void setBinaryStream(String parameterName, InputStream inputStream, long length) throws SQLException - Specified by:
setBinaryStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
- Specified by:
setBinaryStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
public void setBinaryStream(String parameterName, InputStream inputStream, int length) throws SQLException - Specified by:
setBinaryStream
in interfaceCallableStatement
- Throws:
SQLException
-
setCharacterStream
public void setCharacterStream(String parameterName, Reader reader, long length) throws SQLException - Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setCharacterStream
- Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setCharacterStream
- Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setURL
- Specified by:
setURL
in interfaceCallableStatement
- Throws:
SQLException
-
setNull
- Specified by:
setNull
in interfaceCallableStatement
- Throws:
SQLException
-
setNull
- Specified by:
setNull
in interfaceCallableStatement
- Throws:
SQLException
-
setBoolean
- Specified by:
setBoolean
in interfaceCallableStatement
- Throws:
SQLException
-
setByte
- Specified by:
setByte
in interfaceCallableStatement
- Throws:
SQLException
-
setShort
- Specified by:
setShort
in interfaceCallableStatement
- Throws:
SQLException
-
setInt
- Specified by:
setInt
in interfaceCallableStatement
- Throws:
SQLException
-
setLong
- Specified by:
setLong
in interfaceCallableStatement
- Throws:
SQLException
-
setFloat
- Specified by:
setFloat
in interfaceCallableStatement
- Throws:
SQLException
-
setDouble
- Specified by:
setDouble
in interfaceCallableStatement
- Throws:
SQLException
-
setBigDecimal
- Specified by:
setBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
setString
- Specified by:
setString
in interfaceCallableStatement
- Throws:
SQLException
-
setBytes
- Specified by:
setBytes
in interfaceCallableStatement
- Throws:
SQLException
-
setDate
- Specified by:
setDate
in interfaceCallableStatement
- Throws:
SQLException
-
setDate
- Specified by:
setDate
in interfaceCallableStatement
- Throws:
SQLException
-
setTime
- Specified by:
setTime
in interfaceCallableStatement
- Throws:
SQLException
-
setTime
- Specified by:
setTime
in interfaceCallableStatement
- Throws:
SQLException
-
setTimestamp
- Specified by:
setTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
setTimestamp
public void setTimestamp(String parameterName, Timestamp timestamp, Calendar cal) throws SQLException - Specified by:
setTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
setObject
public void setObject(String parameterName, Object obj, int targetSqlType, int scale) throws SQLException - Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-
setObject
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-
setObject
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-
setObject
public void setObject(String parameterName, Object obj, SQLType targetSqlType, int scaleOrLength) throws SQLException - Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-
setObject
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-