Class CallableFunctionStatement
- java.lang.Object
-
- org.mariadb.jdbc.MariaDbStatement
-
- org.mariadb.jdbc.BasePrepareStatement
-
- org.mariadb.jdbc.ClientSidePreparedStatement
-
- org.mariadb.jdbc.CallableFunctionStatement
-
- All Implemented Interfaces:
java.lang.AutoCloseable
,java.lang.Cloneable
,java.sql.CallableStatement
,java.sql.PreparedStatement
,java.sql.Statement
,java.sql.Wrapper
- Direct Known Subclasses:
MariaDbFunctionStatement
public abstract class CallableFunctionStatement extends ClientSidePreparedStatement implements java.sql.CallableStatement
-
-
Field Summary
Fields Modifier and Type Field Description protected CallableParameterMetaData
parameterMetadata
private CallParameter[]
params
Information about parameters, merely from registerOutputParameter() and setXXX() calls.-
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
-
-
Constructor Summary
Constructors Constructor Description CallableFunctionStatement(MariaDbConnection connection, java.lang.String sql, int resultSetType, int resultSetConcurrency)
Constructor for getter/setter of callableStatement.
-
Method Summary
All Methods Instance Methods Abstract Methods Concrete Methods Deprecated Methods Modifier and Type Method Description CallableFunctionStatement
clone(MariaDbConnection connection)
Clone data.java.sql.Array
getArray(int parameterIndex)
java.sql.Array
getArray(java.lang.String parameterName)
java.math.BigDecimal
getBigDecimal(int parameterIndex)
java.math.BigDecimal
getBigDecimal(int parameterIndex, int scale)
Deprecated.java.math.BigDecimal
getBigDecimal(java.lang.String parameterName)
java.sql.Blob
getBlob(int parameterIndex)
java.sql.Blob
getBlob(java.lang.String parameterName)
boolean
getBoolean(int parameterIndex)
boolean
getBoolean(java.lang.String parameterName)
byte
getByte(int parameterIndex)
byte
getByte(java.lang.String parameterName)
byte[]
getBytes(int parameterIndex)
byte[]
getBytes(java.lang.String parameterName)
java.io.Reader
getCharacterStream(int parameterIndex)
java.io.Reader
getCharacterStream(java.lang.String parameterName)
java.sql.Clob
getClob(int parameterIndex)
java.sql.Clob
getClob(java.lang.String parameterName)
java.sql.Date
getDate(int parameterIndex)
java.sql.Date
getDate(int parameterIndex, java.util.Calendar cal)
java.sql.Date
getDate(java.lang.String parameterName)
java.sql.Date
getDate(java.lang.String parameterName, java.util.Calendar cal)
double
getDouble(int parameterIndex)
double
getDouble(java.lang.String parameterName)
float
getFloat(int parameterIndex)
float
getFloat(java.lang.String parameterName)
int
getInt(int parameterIndex)
int
getInt(java.lang.String parameterName)
long
getLong(int parameterIndex)
long
getLong(java.lang.String parameterName)
java.io.Reader
getNCharacterStream(int parameterIndex)
java.io.Reader
getNCharacterStream(java.lang.String parameterName)
java.sql.NClob
getNClob(int parameterIndex)
java.sql.NClob
getNClob(java.lang.String parameterName)
java.lang.String
getNString(int parameterIndex)
java.lang.String
getNString(java.lang.String parameterName)
java.lang.Object
getObject(int parameterIndex)
<T> T
getObject(int parameterIndex, java.lang.Class<T> type)
java.lang.Object
getObject(int parameterIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map)
java.lang.Object
getObject(java.lang.String parameterName)
<T> T
getObject(java.lang.String parameterName, java.lang.Class<T> type)
java.lang.Object
getObject(java.lang.String parameterName, java.util.Map<java.lang.String,java.lang.Class<?>> map)
private CallParameter
getParameter(int index)
java.sql.ParameterMetaData
getParameterMetaData()
Retrieves the number, types and properties of thisPreparedStatement
object's parameters.java.sql.Ref
getRef(int parameterIndex)
java.sql.Ref
getRef(java.lang.String parameterName)
protected abstract SelectResultSet
getResult()
java.sql.RowId
getRowId(int parameterIndex)
java.sql.RowId
getRowId(java.lang.String parameterName)
short
getShort(int parameterIndex)
short
getShort(java.lang.String parameterName)
java.sql.SQLXML
getSQLXML(int parameterIndex)
java.sql.SQLXML
getSQLXML(java.lang.String parameterName)
java.lang.String
getString(int parameterIndex)
java.lang.String
getString(java.lang.String parameterName)
java.sql.Time
getTime(int parameterIndex)
java.sql.Time
getTime(int parameterIndex, java.util.Calendar cal)
java.sql.Time
getTime(java.lang.String parameterName)
java.sql.Time
getTime(java.lang.String parameterName, java.util.Calendar cal)
java.sql.Timestamp
getTimestamp(int parameterIndex)
java.sql.Timestamp
getTimestamp(int parameterIndex, java.util.Calendar cal)
java.sql.Timestamp
getTimestamp(java.lang.String parameterName)
java.sql.Timestamp
getTimestamp(java.lang.String parameterName, java.util.Calendar cal)
java.net.URL
getURL(int parameterIndex)
java.net.URL
getURL(java.lang.String parameterName)
private int
indexToOutputIndex(int parameterIndex)
Convert parameter index to corresponding outputIndex.void
initFunctionData(int parametersCount)
Data initialisation when parameterCount is defined.private int
nameToIndex(java.lang.String parameterName)
Convert parameter name to parameter index in the query.private int
nameToOutputIndex(java.lang.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, java.lang.String typeName)
Registers the designated output parameter.void
registerOutParameter(int parameterIndex, java.sql.SQLType sqlType)
void
registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, int scale)
void
registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, java.lang.String typeName)
void
registerOutParameter(java.lang.String parameterName, int sqlType)
void
registerOutParameter(java.lang.String parameterName, int sqlType, int scale)
void
registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName)
void
registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType)
void
registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, int scale)
void
registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, java.lang.String typeName)
void
setAsciiStream(java.lang.String parameterName, java.io.InputStream inputStream)
void
setAsciiStream(java.lang.String parameterName, java.io.InputStream inputStream, int length)
void
setAsciiStream(java.lang.String parameterName, java.io.InputStream inputStream, long length)
void
setBigDecimal(java.lang.String parameterName, java.math.BigDecimal bigDecimal)
void
setBinaryStream(java.lang.String parameterName, java.io.InputStream inputStream)
void
setBinaryStream(java.lang.String parameterName, java.io.InputStream inputStream, int length)
void
setBinaryStream(java.lang.String parameterName, java.io.InputStream inputStream, long length)
void
setBlob(java.lang.String parameterName, java.io.InputStream inputStream)
void
setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length)
void
setBlob(java.lang.String parameterName, java.sql.Blob blob)
void
setBoolean(java.lang.String parameterName, boolean booleanValue)
void
setByte(java.lang.String parameterName, byte byteValue)
void
setBytes(java.lang.String parameterName, byte[] bytes)
void
setCharacterStream(java.lang.String parameterName, java.io.Reader reader)
void
setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length)
void
setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length)
void
setClob(java.lang.String parameterName, java.io.Reader reader)
void
setClob(java.lang.String parameterName, java.io.Reader reader, long length)
void
setClob(java.lang.String parameterName, java.sql.Clob clob)
void
setDate(java.lang.String parameterName, java.sql.Date date)
void
setDate(java.lang.String parameterName, java.sql.Date date, java.util.Calendar cal)
void
setDouble(java.lang.String parameterName, double doubleValue)
void
setFloat(java.lang.String parameterName, float floatValue)
void
setInt(java.lang.String parameterName, int intValue)
void
setLong(java.lang.String parameterName, long longValue)
void
setNCharacterStream(java.lang.String parameterName, java.io.Reader reader)
void
setNCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length)
void
setNClob(java.lang.String parameterName, java.io.Reader reader)
void
setNClob(java.lang.String parameterName, java.io.Reader reader, long length)
void
setNClob(java.lang.String parameterName, java.sql.NClob value)
void
setNString(java.lang.String parameterName, java.lang.String value)
void
setNull(java.lang.String parameterName, int sqlType)
void
setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName)
void
setObject(java.lang.String parameterName, java.lang.Object obj)
void
setObject(java.lang.String parameterName, java.lang.Object obj, int targetSqlType)
void
setObject(java.lang.String parameterName, java.lang.Object obj, int targetSqlType, int scale)
void
setObject(java.lang.String parameterName, java.lang.Object obj, java.sql.SQLType targetSqlType)
void
setObject(java.lang.String parameterName, java.lang.Object obj, java.sql.SQLType targetSqlType, int scaleOrLength)
void
setRowId(java.lang.String parameterName, java.sql.RowId rowid)
void
setShort(java.lang.String parameterName, short shortValue)
void
setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject)
void
setString(java.lang.String parameterName, java.lang.String stringValue)
void
setTime(java.lang.String parameterName, java.sql.Time time)
void
setTime(java.lang.String parameterName, java.sql.Time time, java.util.Calendar cal)
void
setTimestamp(java.lang.String parameterName, java.sql.Timestamp timestamp)
void
setTimestamp(java.lang.String parameterName, java.sql.Timestamp timestamp, java.util.Calendar cal)
void
setURL(java.lang.String parameterName, java.net.URL url)
boolean
wasNull()
-
Methods inherited from class org.mariadb.jdbc.ClientSidePreparedStatement
addBatch, addBatch, clearBatch, clearParameters, close, execute, executeBatch, executeInternal, executeLargeBatch, executeQuery, executeUpdate, getMetaData, getParameterCount, getPrepareResult, getServerUpdateCounts, setParameter, toString
-
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, getServerThreadId, 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
-
-
-
-
Field Detail
-
parameterMetadata
protected CallableParameterMetaData parameterMetadata
-
params
private CallParameter[] params
Information about parameters, merely from registerOutputParameter() and setXXX() calls.
-
-
Constructor Detail
-
CallableFunctionStatement
public CallableFunctionStatement(MariaDbConnection connection, java.lang.String sql, int resultSetType, int resultSetConcurrency) throws java.sql.SQLException
Constructor for getter/setter of callableStatement.- Parameters:
connection
- current connectionsql
- queryresultSetType
- a result set type; one ofResultSet.TYPE_FORWARD_ONLY
,ResultSet.TYPE_SCROLL_INSENSITIVE
, orResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency
- a concurrency type; one ofResultSet.CONCUR_READ_ONLY
orResultSet.CONCUR_UPDATABLE
- Throws:
java.sql.SQLException
- if clientPrepareStatement creation throw an exception
-
-
Method Detail
-
clone
public CallableFunctionStatement clone(MariaDbConnection connection) throws java.lang.CloneNotSupportedException
Clone data.- Overrides:
clone
in classClientSidePreparedStatement
- Parameters:
connection
- connection- Returns:
- Cloned .
- Throws:
java.lang.CloneNotSupportedException
- if any error occur.
-
initFunctionData
public void initFunctionData(int parametersCount)
Data initialisation when parameterCount is defined.- Parameters:
parametersCount
- number of parameters
-
getResult
protected abstract SelectResultSet getResult() throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getParameterMetaData
public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
Description copied from class:ClientSidePreparedStatement
Retrieves the number, types and properties of thisPreparedStatement
object's parameters.- Specified by:
getParameterMetaData
in interfacejava.sql.PreparedStatement
- Overrides:
getParameterMetaData
in classClientSidePreparedStatement
- Returns:
- a
ParameterMetaData
object that contains information about the number, types and properties for each parameter marker of thisPreparedStatement
object - Throws:
java.sql.SQLException
- if a database access error occurs or this method is called on a closedPreparedStatement
- See Also:
ParameterMetaData
-
nameToIndex
private int nameToIndex(java.lang.String parameterName) throws java.sql.SQLException
Convert parameter name to parameter index in the query.- Parameters:
parameterName
- name- Returns:
- index
- Throws:
java.sql.SQLException
- exception
-
nameToOutputIndex
private int nameToOutputIndex(java.lang.String parameterName) throws java.sql.SQLException
Convert parameter name to output parameter index in the query.- Parameters:
parameterName
- name- Returns:
- index
- Throws:
java.sql.SQLException
- exception
-
indexToOutputIndex
private int indexToOutputIndex(int parameterIndex)
Convert parameter index to corresponding outputIndex.- Parameters:
parameterIndex
- index- Returns:
- index
-
wasNull
public boolean wasNull() throws java.sql.SQLException
- Specified by:
wasNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
- Specified by:
getString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBoolean
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBoolean
public boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getByte
public byte getByte(int parameterIndex) throws java.sql.SQLException
- Specified by:
getByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getByte
public byte getByte(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getShort
public short getShort(int parameterIndex) throws java.sql.SQLException
- Specified by:
getShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getShort
public short getShort(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getInt
public int getInt(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getInt
public int getInt(int parameterIndex) throws java.sql.SQLException
- Specified by:
getInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getLong
public long getLong(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getLong
public long getLong(int parameterIndex) throws java.sql.SQLException
- Specified by:
getLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getFloat
public float getFloat(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getFloat
public float getFloat(int parameterIndex) throws java.sql.SQLException
- Specified by:
getFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDouble
public double getDouble(int parameterIndex) throws java.sql.SQLException
- Specified by:
getDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDouble
public double getDouble(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBigDecimal
@Deprecated public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
Deprecated.- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBytes
public byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBytes
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(int parameterIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String parameterName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(int parameterIndex, java.lang.Class<T> type) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(int parameterIndex) throws java.sql.SQLException
- Specified by:
getRef
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getRef
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBlob
public java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBlob
public java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getClob
public java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getClob
public java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLException
- Specified by:
getClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getArray
public java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getArray
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getArray
public java.sql.Array getArray(int parameterIndex) throws java.sql.SQLException
- Specified by:
getArray
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
- Specified by:
getURL
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getURL
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException
- Specified by:
getRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException
- Specified by:
getSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getCharacterStream
public java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException
- Specified by:
getCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getCharacterStream
public java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.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 interfacejava.sql.CallableStatement
- 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:
java.sql.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 java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
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 interfacejava.sql.CallableStatement
- 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:
java.sql.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(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, int scale) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, int scale) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getParameter
private CallParameter getParameter(int index) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
setSQLXML
public void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
- Specified by:
setSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setRowId
public void setRowId(java.lang.String parameterName, java.sql.RowId rowid) throws java.sql.SQLException
- Specified by:
setRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNString
public void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException
- Specified by:
setNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.sql.Clob clob) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.sql.Blob blob) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream inputStream, int length) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream inputStream, int length) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setURL
public void setURL(java.lang.String parameterName, java.net.URL url) throws java.sql.SQLException
- Specified by:
setURL
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
- Specified by:
setNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
setNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBoolean
public void setBoolean(java.lang.String parameterName, boolean booleanValue) throws java.sql.SQLException
- Specified by:
setBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setByte
public void setByte(java.lang.String parameterName, byte byteValue) throws java.sql.SQLException
- Specified by:
setByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setShort
public void setShort(java.lang.String parameterName, short shortValue) throws java.sql.SQLException
- Specified by:
setShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setInt
public void setInt(java.lang.String parameterName, int intValue) throws java.sql.SQLException
- Specified by:
setInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setLong
public void setLong(java.lang.String parameterName, long longValue) throws java.sql.SQLException
- Specified by:
setLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setFloat
public void setFloat(java.lang.String parameterName, float floatValue) throws java.sql.SQLException
- Specified by:
setFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setDouble
public void setDouble(java.lang.String parameterName, double doubleValue) throws java.sql.SQLException
- Specified by:
setDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBigDecimal
public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal bigDecimal) throws java.sql.SQLException
- Specified by:
setBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setString
public void setString(java.lang.String parameterName, java.lang.String stringValue) throws java.sql.SQLException
- Specified by:
setString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBytes
public void setBytes(java.lang.String parameterName, byte[] bytes) throws java.sql.SQLException
- Specified by:
setBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(java.lang.String parameterName, java.sql.Date date) throws java.sql.SQLException
- Specified by:
setDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(java.lang.String parameterName, java.sql.Date date, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(java.lang.String parameterName, java.sql.Time time) throws java.sql.SQLException
- Specified by:
setTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(java.lang.String parameterName, java.sql.Time time, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp timestamp) throws java.sql.SQLException
- Specified by:
setTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp timestamp, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object obj, int targetSqlType, int scale) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object obj, int targetSqlType) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object obj) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object obj, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object obj, java.sql.SQLType targetSqlType) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
-