Package org.apache.derby.iapi.jdbc
Class BrokeredCallableStatement
java.lang.Object
org.apache.derby.iapi.jdbc.BrokeredStatement
org.apache.derby.iapi.jdbc.BrokeredPreparedStatement
org.apache.derby.iapi.jdbc.BrokeredCallableStatement
- All Implemented Interfaces:
AutoCloseable
,CallableStatement
,PreparedStatement
,Statement
,Wrapper
,EnginePreparedStatement
,EngineStatement
- Direct Known Subclasses:
BrokeredCallableStatement42
public class BrokeredCallableStatement
extends BrokeredPreparedStatement
implements CallableStatement
Brokered CallableStatement.
This class implements the JDBC 4.1 interface.
-
Field Summary
Fields inherited from class org.apache.derby.iapi.jdbc.BrokeredPreparedStatement
sql
Fields inherited from class org.apache.derby.iapi.jdbc.BrokeredStatement
control, resultSetConcurrency, resultSetHoldability, resultSetType
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 -
Method Summary
Modifier and TypeMethodDescriptionfinal void
close()
In many cases, it is desirable to immediately release a Statements's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.createDuplicateStatement
(Connection conn, CallableStatement oldStatement) Create a duplicate CalableStatement to this, including state, from the passed in Connection.final Array
getArray
(int i) final Array
final BigDecimal
getBigDecimal
(int parameterIndex) final BigDecimal
getBigDecimal
(int parameterIndex, int scale) Deprecated.final BigDecimal
getBigDecimal
(String parameterName) final Blob
getBlob
(int i) final Blob
final boolean
getBoolean
(int parameterIndex) final boolean
getBoolean
(String parameterName) final byte
getByte
(int parameterIndex) final byte
final byte[]
getBytes
(int parameterIndex) final byte[]
(package private) final CallableStatement
Access the underlying CallableStatement.final Reader
getCharacterStream
(int parameterIndex) final Reader
getCharacterStream
(String parameterName) final Clob
getClob
(int i) final Clob
final Date
getDate
(int parameterIndex) final Date
final Date
final Date
final double
getDouble
(int parameterIndex) final double
final float
getFloat
(int parameterIndex) final float
final int
getInt
(int parameterIndex) final int
final long
getLong
(int parameterIndex) final long
final Reader
getNCharacterStream
(int parameterIndex) final Reader
getNCharacterStream
(String parameterName) getNClob
(int i) final String
getNString
(int parameterIndex) final String
getNString
(String parameterName) final Object
getObject
(int parameterIndex) final <T> T
final Object
final Object
final <T> T
final Object
(package private) final PreparedStatement
Access the underlying PreparedStatement.final Ref
getRef
(int i) final Ref
final RowId
getRowId
(int parameterIndex) final RowId
final short
getShort
(int parameterIndex) final short
getSQLXML
(int parameterIndex) final String
getString
(int parameterIndex) final String
final Time
getTime
(int parameterIndex) final Time
final Time
final Time
final Timestamp
getTimestamp
(int parameterIndex) final Timestamp
getTimestamp
(int parameterIndex, Calendar cal) final Timestamp
getTimestamp
(String parameterName) final Timestamp
getTimestamp
(String parameterName, Calendar cal) final URL
getURL
(int i) final URL
final void
registerOutParameter
(int parameterIndex, int sqlType) final void
registerOutParameter
(int parameterIndex, int sqlType, int scale) final void
registerOutParameter
(int paramIndex, int sqlType, String typeName) final void
registerOutParameter
(String a, int b) final void
registerOutParameter
(String a, int b, int c) final void
registerOutParameter
(String a, int b, String c) final void
setAsciiStream
(String parameterName, InputStream x) final void
setAsciiStream
(String parameterName, InputStream value, int length) final void
setAsciiStream
(String parameterName, InputStream x, long length) final void
setBigDecimal
(String parameterName, BigDecimal value) final void
setBinaryStream
(String parameterName, InputStream x) final void
setBinaryStream
(String parameterName, InputStream value, int length) final void
setBinaryStream
(String parameterName, InputStream x, long length) final void
setBlob
(String parameterName, InputStream inputStream) final void
setBlob
(String parameterName, InputStream inputStream, long length) final void
final void
setBoolean
(String parameterName, boolean value) final void
final void
final void
setCharacterStream
(String parameterName, Reader x) final void
setCharacterStream
(String parameterName, Reader value, int length) final void
setCharacterStream
(String parameterName, Reader x, long length) final void
final void
final void
final void
final void
final void
final void
final void
final void
final void
setNCharacterStream
(String parameterName, Reader value) final void
setNCharacterStream
(String parameterName, Reader value, long length) final void
final void
final void
final void
setNString
(String parameterName, String value) final void
final void
final void
final void
final void
final void
final void
final void
final void
final void
final void
final void
setTimestamp
(String parameterName, Timestamp value) final void
setTimestamp
(String parameterName, Timestamp value, Calendar cal) final void
final boolean
wasNull()
Methods inherited from class org.apache.derby.iapi.jdbc.BrokeredPreparedStatement
addBatch, clearParameters, createDuplicateStatement, execute, executeLargeUpdate, executeQuery, executeUpdate, getMetaData, getParameterMetaData, getStatement, getVersionCounter, 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, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
Methods inherited from class org.apache.derby.iapi.jdbc.BrokeredStatement
addBatch, cancel, checkIfClosed, clearBatch, clearWarnings, closeOnCompletion, controlCheck, createDuplicateStatement, 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, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, setStatementState, unableToUnwrap, unwrap, wrapResultSet
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Methods inherited from interface java.sql.CallableStatement
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObject
Methods inherited from interface org.apache.derby.iapi.jdbc.EngineStatement
closeOnCompletion, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, isCloseOnCompletion, setLargeMaxRows
Methods inherited from interface java.sql.PreparedStatement
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap
-
Constructor Details
-
BrokeredCallableStatement
- Throws:
SQLException
-
-
Method Details
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
public final void registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException - Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
wasNull
- Specified by:
wasNull
in interfaceCallableStatement
- Throws:
SQLException
-
close
Description copied from class:BrokeredStatement
In many cases, it is desirable to immediately release a Statements's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.Note: A Statement is automatically closed when it is garbage collected. When a Statement is closed its current ResultSet, if one exists, is also closed.
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceStatement
- Overrides:
close
in classBrokeredPreparedStatement
- Throws:
SQLException
- thrown on failure.
-
getString
- Specified by:
getString
in interfaceCallableStatement
- Throws:
SQLException
-
getBoolean
- Specified by:
getBoolean
in interfaceCallableStatement
- Throws:
SQLException
-
getByte
- Specified by:
getByte
in interfaceCallableStatement
- Throws:
SQLException
-
getShort
- Specified by:
getShort
in interfaceCallableStatement
- Throws:
SQLException
-
getInt
- Specified by:
getInt
in interfaceCallableStatement
- Throws:
SQLException
-
getLong
- Specified by:
getLong
in interfaceCallableStatement
- Throws:
SQLException
-
getFloat
- Specified by:
getFloat
in interfaceCallableStatement
- Throws:
SQLException
-
getDouble
- Specified by:
getDouble
in interfaceCallableStatement
- Throws:
SQLException
-
getBigDecimal
Deprecated.- Specified by:
getBigDecimal
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
-
getTime
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getBigDecimal
- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getRef
- Specified by:
getRef
in interfaceCallableStatement
- Throws:
SQLException
-
getBlob
- Specified by:
getBlob
in interfaceCallableStatement
- Throws:
SQLException
-
getClob
- Specified by:
getClob
in interfaceCallableStatement
- Throws:
SQLException
-
getArray
- Specified by:
getArray
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
public final void registerOutParameter(int paramIndex, int sqlType, String typeName) throws SQLException - Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
setURL
- Specified by:
setURL
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
-
setTime
- Specified by:
setTime
in interfaceCallableStatement
- Throws:
SQLException
-
setTimestamp
- Specified by:
setTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
public final void setAsciiStream(String parameterName, InputStream value, int length) throws SQLException - Specified by:
setAsciiStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
public final void setBinaryStream(String parameterName, InputStream value, int length) throws SQLException - Specified by:
setBinaryStream
in interfaceCallableStatement
- Throws:
SQLException
-
setObject
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-
setObject
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-
setObject
- Specified by:
setObject
in interfaceCallableStatement
- Throws:
SQLException
-
setCharacterStream
public final void setCharacterStream(String parameterName, Reader value, int length) throws SQLException - Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setDate
- Specified by:
setDate
in interfaceCallableStatement
- Throws:
SQLException
-
setTime
- Specified by:
setTime
in interfaceCallableStatement
- Throws:
SQLException
-
setTimestamp
public final void setTimestamp(String parameterName, Timestamp value, Calendar cal) throws SQLException - Specified by:
setTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
setNull
- Specified by:
setNull
in interfaceCallableStatement
- Throws:
SQLException
-
getString
- Specified by:
getString
in interfaceCallableStatement
- Throws:
SQLException
-
getBoolean
- Specified by:
getBoolean
in interfaceCallableStatement
- Throws:
SQLException
-
getByte
- Specified by:
getByte
in interfaceCallableStatement
- Throws:
SQLException
-
getShort
- Specified by:
getShort
in interfaceCallableStatement
- Throws:
SQLException
-
getInt
- Specified by:
getInt
in interfaceCallableStatement
- Throws:
SQLException
-
getLong
- Specified by:
getLong
in interfaceCallableStatement
- Throws:
SQLException
-
getFloat
- Specified by:
getFloat
in interfaceCallableStatement
- Throws:
SQLException
-
getDouble
- Specified by:
getDouble
in interfaceCallableStatement
- Throws:
SQLException
-
getBytes
- Specified by:
getBytes
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getBigDecimal
- Specified by:
getBigDecimal
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getRef
- Specified by:
getRef
in interfaceCallableStatement
- Throws:
SQLException
-
getBlob
- Specified by:
getBlob
in interfaceCallableStatement
- Throws:
SQLException
-
getClob
- Specified by:
getClob
in interfaceCallableStatement
- Throws:
SQLException
-
getArray
- Specified by:
getArray
in interfaceCallableStatement
- Throws:
SQLException
-
getDate
- Specified by:
getDate
in interfaceCallableStatement
- Throws:
SQLException
-
getTime
- Specified by:
getTime
in interfaceCallableStatement
- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceCallableStatement
- Throws:
SQLException
-
getURL
- Specified by:
getURL
in interfaceCallableStatement
- Throws:
SQLException
-
getURL
- Specified by:
getURL
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
registerOutParameter
- Specified by:
registerOutParameter
in interfaceCallableStatement
- Throws:
SQLException
-
getCharacterStream
- Specified by:
getCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getCharacterStream
- Specified by:
getCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getNCharacterStream
- Specified by:
getNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getNCharacterStream
- Specified by:
getNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getNString
- Specified by:
getNString
in interfaceCallableStatement
- Throws:
SQLException
-
getNString
- Specified by:
getNString
in interfaceCallableStatement
- Throws:
SQLException
-
getRowId
- Specified by:
getRowId
in interfaceCallableStatement
- Throws:
SQLException
-
getRowId
- Specified by:
getRowId
in interfaceCallableStatement
- Throws:
SQLException
-
setRowId
- Specified by:
setRowId
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setClob
- Specified by:
setClob
in interfaceCallableStatement
- Throws:
SQLException
-
setNString
- Specified by:
setNString
in interfaceCallableStatement
- Throws:
SQLException
-
setNCharacterStream
- Specified by:
setNCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setNCharacterStream
public final void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException - Specified by:
setNCharacterStream
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
-
setBlob
- Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setBlob
public final void setBlob(String parameterName, InputStream inputStream, long length) throws SQLException - Specified by:
setBlob
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
- Specified by:
setNClob
in interfaceCallableStatement
- Throws:
SQLException
-
setNClob
- Specified by:
setNClob
in interfaceCallableStatement
- Throws:
SQLException
-
getNClob
- Specified by:
getNClob
in interfaceCallableStatement
- Throws:
SQLException
-
getNClob
- Specified by:
getNClob
in interfaceCallableStatement
- Throws:
SQLException
-
setSQLXML
- Specified by:
setSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
getSQLXML
- Specified by:
getSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
getSQLXML
- Specified by:
getSQLXML
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
- Specified by:
setAsciiStream
in interfaceCallableStatement
- Throws:
SQLException
-
setAsciiStream
public final void setAsciiStream(String parameterName, InputStream x, long length) throws SQLException - Specified by:
setAsciiStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
- Specified by:
setBinaryStream
in interfaceCallableStatement
- Throws:
SQLException
-
setBinaryStream
public final void setBinaryStream(String parameterName, InputStream x, long length) throws SQLException - Specified by:
setBinaryStream
in interfaceCallableStatement
- Throws:
SQLException
-
setCharacterStream
- Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
setCharacterStream
public final void setCharacterStream(String parameterName, Reader x, long length) throws SQLException - Specified by:
setCharacterStream
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceCallableStatement
- Throws:
SQLException
-
getCallableStatement
Access the underlying CallableStatement. This method is package protected to restrict access to the underlying object to the brokered objects. Allowing the application to access the underlying object thtough a public method would- Throws:
SQLException
-
getPreparedStatement
Access the underlying PreparedStatement. This method is package protected to restrict access to the underlying object to the brokered objects. Allowing the application to access the underlying object thtough a public method would- Overrides:
getPreparedStatement
in classBrokeredPreparedStatement
- Throws:
SQLException
-
createDuplicateStatement
public CallableStatement createDuplicateStatement(Connection conn, CallableStatement oldStatement) throws SQLException Create a duplicate CalableStatement to this, including state, from the passed in Connection.- Throws:
SQLException
-