Class CallableProcedureStatement
- java.lang.Object
-
- org.mariadb.jdbc.MariaDbStatement
-
- org.mariadb.jdbc.BasePrepareStatement
-
- org.mariadb.jdbc.ServerSidePreparedStatement
-
- org.mariadb.jdbc.CallableProcedureStatement
-
- All Implemented Interfaces:
AutoCloseable
,Cloneable
,CallableStatement
,PreparedStatement
,Statement
,Wrapper
- Direct Known Subclasses:
MariaDbProcedureStatement
public abstract class CallableProcedureStatement extends ServerSidePreparedStatement implements CallableStatement, Cloneable
-
-
Field Summary
Fields Modifier and Type Field Description protected boolean
hasInOutParameters
protected int[]
outputParameterMapper
protected CallableParameterMetaData
parameterMetadata
protected List<org.mariadb.jdbc.CallParameter>
params
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, SPEC_ISO_ZONED_DATE_TIME
-
Fields inherited from class org.mariadb.jdbc.MariaDbStatement
canUseServerTimeout, closed, connection, exceptionFactory, 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
Constructors Constructor Description CallableProcedureStatement(MariaDbConnection connection, String sql, int resultSetScrollType, int resultSetConcurrency, ExceptionFactory exceptionFactory, String database, String procedureName)
Constructor for getter/setter of callableStatement.
-
Method Summary
All Methods Instance Methods Abstract Methods Concrete Methods Deprecated Methods Modifier and Type Method Description CallableProcedureStatement
clone(MariaDbConnection connection)
Clone data.Array
getArray(int parameterIndex)
Array
getArray(String parameterName)
BigDecimal
getBigDecimal(int parameterIndex)
BigDecimal
getBigDecimal(int parameterIndex, int scale)
Deprecated.BigDecimal
getBigDecimal(String parameterName)
Blob
getBlob(int parameterIndex)
Blob
getBlob(String parameterName)
boolean
getBoolean(int parameterIndex)
boolean
getBoolean(String parameterName)
byte
getByte(int parameterIndex)
byte
getByte(String parameterName)
byte[]
getBytes(int parameterIndex)
byte[]
getBytes(String parameterName)
Reader
getCharacterStream(int parameterIndex)
Reader
getCharacterStream(String parameterName)
Clob
getClob(int parameterIndex)
Clob
getClob(String parameterName)
Date
getDate(int parameterIndex)
Date
getDate(int parameterIndex, Calendar cal)
Date
getDate(String parameterName)
Date
getDate(String parameterName, Calendar cal)
double
getDouble(int parameterIndex)
double
getDouble(String parameterName)
float
getFloat(int parameterIndex)
float
getFloat(String parameterName)
int
getInt(int parameterIndex)
int
getInt(String parameterName)
long
getLong(int parameterIndex)
long
getLong(String parameterName)
Reader
getNCharacterStream(int parameterIndex)
Reader
getNCharacterStream(String parameterName)
NClob
getNClob(int parameterIndex)
NClob
getNClob(String parameterName)
String
getNString(int parameterIndex)
String
getNString(String parameterName)
Object
getObject(int parameterIndex)
<T> T
getObject(int parameterIndex, Class<T> type)
Object
getObject(int parameterIndex, Map<String,Class<?>> map)
Object
getObject(String parameterName)
<T> T
getObject(String parameterName, Class<T> type)
Object
getObject(String parameterName, Map<String,Class<?>> map)
protected abstract SelectResultSet
getOutputResult()
ParameterMetaData
getParameterMetaData()
Retrieves the number, types and properties of thisPreparedStatement
object's parameters.Ref
getRef(int parameterIndex)
Ref
getRef(String parameterName)
RowId
getRowId(int parameterIndex)
RowId
getRowId(String parameterName)
short
getShort(int parameterIndex)
short
getShort(String parameterName)
SQLXML
getSQLXML(int parameterIndex)
SQLXML
getSQLXML(String parameterName)
String
getString(int parameterIndex)
String
getString(String parameterName)
Time
getTime(int parameterIndex)
Time
getTime(int parameterIndex, Calendar cal)
Time
getTime(String parameterName)
Time
getTime(String parameterName, Calendar cal)
Timestamp
getTimestamp(int parameterIndex)
Timestamp
getTimestamp(int parameterIndex, Calendar cal)
Timestamp
getTimestamp(String parameterName)
Timestamp
getTimestamp(String parameterName, Calendar cal)
URL
getURL(int parameterIndex)
URL
getURL(String parameterName)
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
setBlob(String parameterName, Blob blob)
void
setBoolean(String parameterName, boolean booleanValue)
void
setByte(String parameterName, byte byteValue)
void
setBytes(String parameterName, byte[] bytes)
void
setCharacterStream(String parameterName, Reader reader)
void
setCharacterStream(String parameterName, Reader reader, int length)
void
setCharacterStream(String parameterName, Reader reader, long length)
void
setClob(String parameterName, Reader reader)
void
setClob(String parameterName, Reader reader, long length)
void
setClob(String parameterName, Clob clob)
void
setDate(String parameterName, Date date)
void
setDate(String parameterName, Date date, Calendar cal)
void
setDouble(String parameterName, double doubleValue)
void
setFloat(String parameterName, float floatValue)
void
setInt(String parameterName, int intValue)
void
setLong(String parameterName, long longValue)
void
setNCharacterStream(String parameterName, Reader value)
void
setNCharacterStream(String parameterName, Reader value, long length)
void
setNClob(String parameterName, Reader reader)
void
setNClob(String parameterName, Reader reader, long length)
void
setNClob(String parameterName, NClob value)
void
setNString(String parameterName, String value)
void
setNull(String parameterName, int sqlType)
void
setNull(String parameterName, int sqlType, String typeName)
void
setObject(String parameterName, Object obj)
void
setObject(String parameterName, Object obj, int targetSqlType)
void
setObject(String parameterName, Object obj, int targetSqlType, int scale)
void
setObject(String parameterName, Object obj, SQLType targetSqlType)
void
setObject(String parameterName, Object obj, SQLType targetSqlType, int scaleOrLength)
void
setParametersVariables()
Set in/out parameters value.void
setRowId(String parameterName, RowId rowid)
void
setShort(String parameterName, short shortValue)
void
setSQLXML(String parameterName, SQLXML xmlObject)
void
setString(String parameterName, String stringValue)
void
setTime(String parameterName, Time time)
void
setTime(String parameterName, Time time, Calendar cal)
void
setTimestamp(String parameterName, Timestamp timestamp)
void
setTimestamp(String parameterName, Timestamp timestamp, Calendar cal)
void
setURL(String parameterName, URL url)
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, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, 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, isSimpleIdentifier, 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 Detail
-
params
protected List<org.mariadb.jdbc.CallParameter> params
Information about parameters, merely from registerOutputParameter() and setXXX() calls.
-
outputParameterMapper
protected int[] outputParameterMapper
-
parameterMetadata
protected CallableParameterMetaData parameterMetadata
-
hasInOutParameters
protected boolean hasInOutParameters
-
-
Constructor Detail
-
CallableProcedureStatement
public CallableProcedureStatement(MariaDbConnection connection, String sql, int resultSetScrollType, int resultSetConcurrency, ExceptionFactory exceptionFactory, String database, String procedureName) 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
exceptionFactory
- Exception factorydatabase
- database nameprocedureName
- function name- Throws:
SQLException
- is prepareStatement connection throw any error
-
-
Method Detail
-
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
protected abstract SelectResultSet getOutputResult() throws SQLException
- Throws:
SQLException
-
getParameterMetaData
public ParameterMetaData getParameterMetaData() throws SQLException
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:
ParameterMetaData
-
wasNull
public boolean wasNull() throws SQLException
- Specified by:
wasNull
in interfaceCallableStatement
- Throws:
SQLException
-
getString
public String getString(int parameterIndex) throws SQLException
- Specified by:
getString
in interfaceCallableStatement
- Throws:
SQLException
-
getString
public String getString(String parameterName) throws SQLException
- Specified by:
getString
in interfaceCallableStatement
- Throws:
SQLException
-
getBoolean
public boolean getBoolean(int parameterIndex) throws SQLException
- Specified by:
getBoolean
in interfaceCallableStatement
- Throws:
SQLException
-
getBoolean
public boolean getBoolean(String parameterName) throws SQLException
- Specified by:
getBoolean
in interfaceCallableStatement
- Throws:
SQLException
-
getByte
public byte getByte(int parameterIndex) throws SQLException
- Specified by:
getByte
in interfaceCallableStatement
- Throws:
SQLException
-
getByte
public byte getByte(String parameterName) throws SQLException
- Specified by:
getByte
in interfaceCallableStatement
- Throws:
SQLException
-
getShort
public short getShort(int parameterIndex) throws SQLException
- Specified by:
getShort
in interfaceCallableStatement
- Throws:
SQLException
-
getShort
public short getShort(String parameterName) throws SQLException
- Specified by:
getShort
in interfaceCallableStatement
- Throws:
SQLException
-
getInt
public int getInt(String parameterName) throws SQLException
- Specified by:
getInt
in interfaceCallableStatement
- Throws:
SQLException
-
getInt
public int getInt(int parameterIndex) throws SQLException
- Specified by:
getInt
in interfaceCallableStatement
- Throws:
SQLException
-
getLong
public long getLong(String parameterName) throws SQLException
- Specified by:
getLong
in interfaceCallableStatement
- Throws:
SQLException
-
getLong
public long getLong(int parameterIndex) throws SQLException
- Specified by:
getLong
in interfaceCallableStatement
- Throws:
SQLException
-
getFloat
public float getFloat(String parameterName) throws SQLException
- Specified by:
getFloat
in interfaceCallableStatement
- Throws:
SQLException
-
getFloat
public float getFloat(int parameterIndex) throws SQLException
- Specified by:
getFloat
in interfaceCallableStatement
- Throws:
SQLException
-
getDouble
public double getDouble(int parameterIndex) throws SQLException
- Specified by:
getDouble
in interfaceCallableStatement
- Throws:
SQLException
-
getDouble
public double getDouble(String parameterName) throws SQLException
- Specified by:
getDouble
in interfaceCallableStatement
- Throws:
SQLException
-
getBigDecimal
@Deprecated public BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException
Deprecated.- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
getBigDecimal
public BigDecimal getBigDecimal(int parameterIndex) throws SQLException
- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
getBigDecimal
public BigDecimal getBigDecimal(String parameterName) throws SQLException
- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
getBytes
public byte[] getBytes(String parameterName) throws SQLException
- Specified by:
getBytes
in interfaceCallableStatement
- Throws:
SQLException
-
getBytes
public byte[] getBytes(int parameterIndex) throws SQLException
- Specified by:
getBytes
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
public Date getDate(int parameterIndex) throws SQLException
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
public Date getDate(String parameterName) throws SQLException
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
public Date getDate(String parameterName, Calendar cal) throws SQLException
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
public Date getDate(int parameterIndex, Calendar cal) throws SQLException
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
public Time getTime(int parameterIndex, Calendar cal) throws SQLException
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
public Time getTime(String parameterName) throws SQLException
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
public Time getTime(String parameterName, Calendar cal) throws SQLException
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
public Time getTime(int parameterIndex) throws SQLException
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(int parameterIndex) throws SQLException
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(String parameterName) throws SQLException
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
public Timestamp getTimestamp(String parameterName, Calendar cal) throws SQLException
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
public Object getObject(int parameterIndex, Map<String,Class<?>> map) throws SQLException
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
public Object getObject(int parameterIndex) throws SQLException
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
public Object getObject(String parameterName) throws SQLException
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
public Object getObject(String parameterName, Map<String,Class<?>> map) throws SQLException
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
public <T> T getObject(int parameterIndex, Class<T> type) throws SQLException
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
public <T> T getObject(String parameterName, Class<T> type) throws SQLException
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getRef
public Ref getRef(int parameterIndex) throws SQLException
- Specified by:
getRef
in interfaceCallableStatement
- Throws:
SQLException
-
getRef
public Ref getRef(String parameterName) throws SQLException
- Specified by:
getRef
in interfaceCallableStatement
- Throws:
SQLException
-
getBlob
public Blob getBlob(int parameterIndex) throws SQLException
- Specified by:
getBlob
in interfaceCallableStatement
- Throws:
SQLException
-
getBlob
public Blob getBlob(String parameterName) throws SQLException
- Specified by:
getBlob
in interfaceCallableStatement
- Throws:
SQLException
-
getClob
public Clob getClob(String parameterName) throws SQLException
- Specified by:
getClob
in interfaceCallableStatement
- Throws:
SQLException
-
getClob
public Clob getClob(int parameterIndex) throws SQLException
- Specified by:
getClob
in interfaceCallableStatement
- Throws:
SQLException
-
getArray
public Array getArray(String parameterName) throws SQLException
- Specified by:
getArray
in interfaceCallableStatement
- Throws:
SQLException
-
getArray
public Array getArray(int parameterIndex) throws SQLException
- Specified by:
getArray
in interfaceCallableStatement
- Throws:
SQLException
-
getURL
public URL getURL(int parameterIndex) throws SQLException
- Specified by:
getURL
in interfaceCallableStatement
- Throws:
SQLException
-
getURL
public URL getURL(String parameterName) throws SQLException
- Specified by:
getURL
in interfaceCallableStatement
- Throws:
SQLException
-
getRowId
public RowId getRowId(int parameterIndex) throws SQLException
- Specified by:
getRowId
in interfaceCallableStatement
- Throws:
SQLException
-
getRowId
public RowId getRowId(String parameterName) throws SQLException
- Specified by:
getRowId
in interfaceCallableStatement
- Throws:
SQLException
-
getNClob
public NClob getNClob(int parameterIndex) throws SQLException
- Specified by:
getNClob
in interfaceCallableStatement
- Throws:
SQLException
-
getNClob
public NClob getNClob(String parameterName) throws SQLException
- Specified by:
getNClob
in interfaceCallableStatement
- Throws:
SQLException
-
getSQLXML
public SQLXML getSQLXML(int parameterIndex) throws SQLException
- Specified by:
getSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
getSQLXML
public SQLXML getSQLXML(String parameterName) throws SQLException
- Specified by:
getSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
getNString
public String getNString(int parameterIndex) throws SQLException
- Specified by:
getNString
in interfaceCallableStatement
- Throws:
SQLException
-
getNString
public String getNString(String parameterName) throws SQLException
- Specified by:
getNString
in interfaceCallableStatement
- Throws:
SQLException
-
getNCharacterStream
public Reader getNCharacterStream(int parameterIndex) throws SQLException
- Specified by:
getNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getNCharacterStream
public Reader getNCharacterStream(String parameterName) throws SQLException
- Specified by:
getNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getCharacterStream
public Reader getCharacterStream(int parameterIndex) throws SQLException
- Specified by:
getCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getCharacterStream
public Reader getCharacterStream(String parameterName) throws SQLException
- 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 methodregisterOutParameter
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:
Types
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType) throws SQLException
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException
Registers the parameter in ordinal positionparameterIndex
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:
Types
-
registerOutParameter
public void registerOutParameter(String parameterName, int sqlType) throws SQLException
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
public void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException
- 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
public void registerOutParameter(int parameterIndex, SQLType sqlType) throws SQLException
- 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
public void registerOutParameter(String parameterName, SQLType sqlType) throws SQLException
- 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
-
setSQLXML
public void setSQLXML(String parameterName, SQLXML xmlObject) throws SQLException
- Specified by:
setSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
setRowId
public void setRowId(String parameterName, RowId rowid) throws SQLException
- Specified by:
setRowId
in interfaceCallableStatement
- Throws:
SQLException
-
setNString
public void setNString(String parameterName, String value) throws SQLException
- 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
public void setNCharacterStream(String parameterName, Reader value) throws SQLException
- Specified by:
setNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
public void setNClob(String parameterName, NClob value) throws SQLException
- Specified by:
setNClob
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
public void setNClob(String parameterName, Reader reader, long length) throws SQLException
- Specified by:
setNClob
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
public void setNClob(String parameterName, Reader reader) throws SQLException
- Specified by:
setNClob
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
public void setClob(String parameterName, Reader reader, long length) throws SQLException
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
public void setClob(String parameterName, Clob clob) throws SQLException
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
public void setClob(String parameterName, Reader reader) throws SQLException
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
public void setBlob(String parameterName, InputStream inputStream, long length) throws SQLException
- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
public void setBlob(String parameterName, Blob blob) throws SQLException
- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
public void setBlob(String parameterName, InputStream inputStream) throws SQLException
- 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
public void setAsciiStream(String parameterName, InputStream inputStream) throws SQLException
- 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
public void setBinaryStream(String parameterName, InputStream inputStream) throws SQLException
- 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
public void setCharacterStream(String parameterName, Reader reader) throws SQLException
- Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setCharacterStream
public void setCharacterStream(String parameterName, Reader reader, int length) throws SQLException
- Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setURL
public void setURL(String parameterName, URL url) throws SQLException
- Specified by:
setURL
in interfaceCallableStatement
- Throws:
SQLException
-
setNull
public void setNull(String parameterName, int sqlType) throws SQLException
- Specified by:
setNull
in interfaceCallableStatement
- Throws:
SQLException
-
setNull
public void setNull(String parameterName, int sqlType, String typeName) throws SQLException
- Specified by:
setNull
in interfaceCallableStatement
- Throws:
SQLException
-
setBoolean
public void setBoolean(String parameterName, boolean booleanValue) throws SQLException
- Specified by:
setBoolean
in interfaceCallableStatement
- Throws:
SQLException
-
setByte
public void setByte(String parameterName, byte byteValue) throws SQLException
- Specified by:
setByte
in interfaceCallableStatement
- Throws:
SQLException
-
setShort
public void setShort(String parameterName, short shortValue) throws SQLException
- Specified by:
setShort
in interfaceCallableStatement
- Throws:
SQLException
-
setInt
public void setInt(String parameterName, int intValue) throws SQLException
- Specified by:
setInt
in interfaceCallableStatement
- Throws:
SQLException
-
setLong
public void setLong(String parameterName, long longValue) throws SQLException
- Specified by:
setLong
in interfaceCallableStatement
- Throws:
SQLException
-
setFloat
public void setFloat(String parameterName, float floatValue) throws SQLException
- Specified by:
setFloat
in interfaceCallableStatement
- Throws:
SQLException
-
setDouble
public void setDouble(String parameterName, double doubleValue) throws SQLException
- Specified by:
setDouble
in interfaceCallableStatement
- Throws:
SQLException
-
setBigDecimal
public void setBigDecimal(String parameterName, BigDecimal bigDecimal) throws SQLException
- Specified by:
setBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
setString
public void setString(String parameterName, String stringValue) throws SQLException
- Specified by:
setString
in interfaceCallableStatement
- Throws:
SQLException
-
setBytes
public void setBytes(String parameterName, byte[] bytes) throws SQLException
- Specified by:
setBytes
in interfaceCallableStatement
- Throws:
SQLException
-
setDate
public void setDate(String parameterName, Date date) throws SQLException
- Specified by:
setDate
in interfaceCallableStatement
- Throws:
SQLException
-
setDate
public void setDate(String parameterName, Date date, Calendar cal) throws SQLException
- Specified by:
setDate
in interfaceCallableStatement
- Throws:
SQLException
-
setTime
public void setTime(String parameterName, Time time) throws SQLException
- Specified by:
setTime
in interfaceCallableStatement
- Throws:
SQLException
-
setTime
public void setTime(String parameterName, Time time, Calendar cal) throws SQLException
- Specified by:
setTime
in interfaceCallableStatement
- Throws:
SQLException
-
setTimestamp
public void setTimestamp(String parameterName, Timestamp timestamp) throws SQLException
- 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
public void setObject(String parameterName, Object obj, int targetSqlType) throws SQLException
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-
setObject
public void setObject(String parameterName, Object obj) throws SQLException
- 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
public void setObject(String parameterName, Object obj, SQLType targetSqlType) throws SQLException
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-
-