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 BrokeredPreparedStatement
sqlFields inherited from class BrokeredStatement
control, resultSetConcurrency, resultSetHoldability, resultSetTypeFields inherited from interface 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 voidclose()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 ArraygetArray(int i) final Arrayfinal BigDecimalgetBigDecimal(int parameterIndex) final BigDecimalgetBigDecimal(int parameterIndex, int scale) Deprecated.final BigDecimalgetBigDecimal(String parameterName) final BlobgetBlob(int i) final Blobfinal booleangetBoolean(int parameterIndex) final booleangetBoolean(String parameterName) final bytegetByte(int parameterIndex) final bytefinal byte[]getBytes(int parameterIndex) final byte[](package private) final CallableStatementAccess the underlying CallableStatement.final ReadergetCharacterStream(int parameterIndex) final ReadergetCharacterStream(String parameterName) final ClobgetClob(int i) final Clobfinal DategetDate(int parameterIndex) final Datefinal Datefinal Datefinal doublegetDouble(int parameterIndex) final doublefinal floatgetFloat(int parameterIndex) final floatfinal intgetInt(int parameterIndex) final intfinal longgetLong(int parameterIndex) final longfinal ReadergetNCharacterStream(int parameterIndex) final ReadergetNCharacterStream(String parameterName) getNClob(int i) final StringgetNString(int parameterIndex) final StringgetNString(String parameterName) final ObjectgetObject(int parameterIndex) final <T> T/////////////////////////////////////////////////////////////////final Objectfinal Objectfinal <T> Tfinal Object(package private) final PreparedStatementAccess the underlying PreparedStatement.final RefgetRef(int i) final Reffinal RowIdgetRowId(int parameterIndex) final RowIdfinal shortgetShort(int parameterIndex) final shortgetSQLXML(int parameterIndex) final StringgetString(int parameterIndex) final Stringfinal TimegetTime(int parameterIndex) final Timefinal Timefinal Timefinal TimestampgetTimestamp(int parameterIndex) final TimestampgetTimestamp(int parameterIndex, Calendar cal) final TimestampgetTimestamp(String parameterName) final TimestampgetTimestamp(String parameterName, Calendar cal) final URLgetURL(int i) final URLfinal voidregisterOutParameter(int parameterIndex, int sqlType) final voidregisterOutParameter(int parameterIndex, int sqlType, int scale) final voidregisterOutParameter(int paramIndex, int sqlType, String typeName) final voidregisterOutParameter(String a, int b) final voidregisterOutParameter(String a, int b, int c) final voidregisterOutParameter(String a, int b, String c) final voidsetAsciiStream(String parameterName, InputStream x) final voidsetAsciiStream(String parameterName, InputStream value, int length) final voidsetAsciiStream(String parameterName, InputStream x, long length) final voidsetBigDecimal(String parameterName, BigDecimal value) final voidsetBinaryStream(String parameterName, InputStream x) final voidsetBinaryStream(String parameterName, InputStream value, int length) final voidsetBinaryStream(String parameterName, InputStream x, long length) final voidsetBlob(String parameterName, InputStream inputStream) final voidsetBlob(String parameterName, InputStream inputStream, long length) final voidfinal voidsetBoolean(String parameterName, boolean value) final voidfinal voidfinal voidsetCharacterStream(String parameterName, Reader x) final voidsetCharacterStream(String parameterName, Reader value, int length) final voidsetCharacterStream(String parameterName, Reader x, long length) final voidfinal voidfinal voidfinal voidfinal voidfinal voidfinal voidfinal voidfinal voidfinal voidsetNCharacterStream(String parameterName, Reader value) final voidsetNCharacterStream(String parameterName, Reader value, long length) final voidfinal voidfinal voidfinal voidsetNString(String parameterName, String value) final voidfinal voidfinal voidfinal voidfinal voidfinal voidfinal voidfinal voidfinal voidfinal voidfinal voidfinal voidsetTimestamp(String parameterName, Timestamp value) final voidsetTimestamp(String parameterName, Timestamp value, Calendar cal) final voidfinal booleanwasNull()Methods inherited from class 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, setURLMethods inherited from class 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, wrapResultSetMethods inherited from class Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitMethods inherited from interface CallableStatement
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObjectMethods inherited from interface EngineStatement
closeOnCompletion, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, isCloseOnCompletion, setLargeMaxRowsMethods inherited from interface 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, setURLMethods inherited from interface 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, setQueryTimeoutMethods inherited from interface Wrapper
isWrapperFor, unwrap
-
Constructor Details
-
BrokeredCallableStatement
- Throws:
SQLException
-
-
Method Details
-
registerOutParameter
- Specified by:
registerOutParameterin interfaceCallableStatement- Throws:
SQLException
-
registerOutParameter
public final void registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException - Specified by:
registerOutParameterin interfaceCallableStatement- Throws:
SQLException
-
wasNull
- Specified by:
wasNullin interfaceCallableStatement- Throws:
SQLException
-
close
Description copied from class:BrokeredStatementIn 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:
closein interfaceAutoCloseable- Specified by:
closein interfaceStatement- Overrides:
closein classBrokeredPreparedStatement- Throws:
SQLException- thrown on failure.
-
getString
- Specified by:
getStringin interfaceCallableStatement- Throws:
SQLException
-
getBoolean
- Specified by:
getBooleanin interfaceCallableStatement- Throws:
SQLException
-
getByte
- Specified by:
getBytein interfaceCallableStatement- Throws:
SQLException
-
getShort
- Specified by:
getShortin interfaceCallableStatement- Throws:
SQLException
-
getInt
- Specified by:
getIntin interfaceCallableStatement- Throws:
SQLException
-
getLong
- Specified by:
getLongin interfaceCallableStatement- Throws:
SQLException
-
getFloat
- Specified by:
getFloatin interfaceCallableStatement- Throws:
SQLException
-
getDouble
- Specified by:
getDoublein interfaceCallableStatement- Throws:
SQLException
-
getBigDecimal
Deprecated.- Specified by:
getBigDecimalin interfaceCallableStatement- Throws:
SQLException
-
getBytes
- Specified by:
getBytesin interfaceCallableStatement- Throws:
SQLException
-
getDate
- Specified by:
getDatein interfaceCallableStatement- Throws:
SQLException
-
getDate
- Specified by:
getDatein interfaceCallableStatement- Throws:
SQLException
-
getTime
- Specified by:
getTimein interfaceCallableStatement- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestampin interfaceCallableStatement- Throws:
SQLException
-
getObject
- Specified by:
getObjectin interfaceCallableStatement- Throws:
SQLException
-
getBigDecimal
- Specified by:
getBigDecimalin interfaceCallableStatement- Throws:
SQLException
-
getObject
- Specified by:
getObjectin interfaceCallableStatement- Throws:
SQLException
-
getRef
- Specified by:
getRefin interfaceCallableStatement- Throws:
SQLException
-
getBlob
- Specified by:
getBlobin interfaceCallableStatement- Throws:
SQLException
-
getClob
- Specified by:
getClobin interfaceCallableStatement- Throws:
SQLException
-
getArray
- Specified by:
getArrayin interfaceCallableStatement- Throws:
SQLException
-
getTime
- Specified by:
getTimein interfaceCallableStatement- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestampin interfaceCallableStatement- Throws:
SQLException
-
registerOutParameter
public final void registerOutParameter(int paramIndex, int sqlType, String typeName) throws SQLException - Specified by:
registerOutParameterin interfaceCallableStatement- Throws:
SQLException
-
setURL
- Specified by:
setURLin interfaceCallableStatement- Throws:
SQLException
-
setNull
- Specified by:
setNullin interfaceCallableStatement- Throws:
SQLException
-
setBoolean
- Specified by:
setBooleanin interfaceCallableStatement- Throws:
SQLException
-
setByte
- Specified by:
setBytein interfaceCallableStatement- Throws:
SQLException
-
setShort
- Specified by:
setShortin interfaceCallableStatement- Throws:
SQLException
-
setInt
- Specified by:
setIntin interfaceCallableStatement- Throws:
SQLException
-
setLong
- Specified by:
setLongin interfaceCallableStatement- Throws:
SQLException
-
setFloat
- Specified by:
setFloatin interfaceCallableStatement- Throws:
SQLException
-
setDouble
- Specified by:
setDoublein interfaceCallableStatement- Throws:
SQLException
-
setBigDecimal
- Specified by:
setBigDecimalin interfaceCallableStatement- Throws:
SQLException
-
setString
- Specified by:
setStringin interfaceCallableStatement- Throws:
SQLException
-
setBytes
- Specified by:
setBytesin interfaceCallableStatement- Throws:
SQLException
-
setDate
- Specified by:
setDatein interfaceCallableStatement- Throws:
SQLException
-
setTime
- Specified by:
setTimein interfaceCallableStatement- Throws:
SQLException
-
setTimestamp
- Specified by:
setTimestampin interfaceCallableStatement- Throws:
SQLException
-
setAsciiStream
public final void setAsciiStream(String parameterName, InputStream value, int length) throws SQLException - Specified by:
setAsciiStreamin interfaceCallableStatement- Throws:
SQLException
-
setBinaryStream
public final void setBinaryStream(String parameterName, InputStream value, int length) throws SQLException - Specified by:
setBinaryStreamin interfaceCallableStatement- Throws:
SQLException
-
setObject
- Specified by:
setObjectin interfaceCallableStatement- Throws:
SQLException
-
setObject
- Specified by:
setObjectin interfaceCallableStatement- Throws:
SQLException
-
setObject
- Specified by:
setObjectin interfaceCallableStatement- Throws:
SQLException
-
setCharacterStream
public final void setCharacterStream(String parameterName, Reader value, int length) throws SQLException - Specified by:
setCharacterStreamin interfaceCallableStatement- Throws:
SQLException
-
setDate
- Specified by:
setDatein interfaceCallableStatement- Throws:
SQLException
-
setTime
- Specified by:
setTimein interfaceCallableStatement- Throws:
SQLException
-
setTimestamp
public final void setTimestamp(String parameterName, Timestamp value, Calendar cal) throws SQLException - Specified by:
setTimestampin interfaceCallableStatement- Throws:
SQLException
-
setNull
- Specified by:
setNullin interfaceCallableStatement- Throws:
SQLException
-
getString
- Specified by:
getStringin interfaceCallableStatement- Throws:
SQLException
-
getBoolean
- Specified by:
getBooleanin interfaceCallableStatement- Throws:
SQLException
-
getByte
- Specified by:
getBytein interfaceCallableStatement- Throws:
SQLException
-
getShort
- Specified by:
getShortin interfaceCallableStatement- Throws:
SQLException
-
getInt
- Specified by:
getIntin interfaceCallableStatement- Throws:
SQLException
-
getLong
- Specified by:
getLongin interfaceCallableStatement- Throws:
SQLException
-
getFloat
- Specified by:
getFloatin interfaceCallableStatement- Throws:
SQLException
-
getDouble
- Specified by:
getDoublein interfaceCallableStatement- Throws:
SQLException
-
getBytes
- Specified by:
getBytesin interfaceCallableStatement- Throws:
SQLException
-
getDate
- Specified by:
getDatein interfaceCallableStatement- Throws:
SQLException
-
getTime
- Specified by:
getTimein interfaceCallableStatement- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestampin interfaceCallableStatement- Throws:
SQLException
-
getObject
- Specified by:
getObjectin interfaceCallableStatement- Throws:
SQLException
-
getBigDecimal
- Specified by:
getBigDecimalin interfaceCallableStatement- Throws:
SQLException
-
getObject
- Specified by:
getObjectin interfaceCallableStatement- Throws:
SQLException
-
getRef
- Specified by:
getRefin interfaceCallableStatement- Throws:
SQLException
-
getBlob
- Specified by:
getBlobin interfaceCallableStatement- Throws:
SQLException
-
getClob
- Specified by:
getClobin interfaceCallableStatement- Throws:
SQLException
-
getArray
- Specified by:
getArrayin interfaceCallableStatement- Throws:
SQLException
-
getDate
- Specified by:
getDatein interfaceCallableStatement- Throws:
SQLException
-
getTime
- Specified by:
getTimein interfaceCallableStatement- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestampin interfaceCallableStatement- Throws:
SQLException
-
getURL
- Specified by:
getURLin interfaceCallableStatement- Throws:
SQLException
-
getURL
- Specified by:
getURLin interfaceCallableStatement- Throws:
SQLException
-
registerOutParameter
- Specified by:
registerOutParameterin interfaceCallableStatement- Throws:
SQLException
-
registerOutParameter
- Specified by:
registerOutParameterin interfaceCallableStatement- Throws:
SQLException
-
registerOutParameter
- Specified by:
registerOutParameterin interfaceCallableStatement- Throws:
SQLException
-
getCharacterStream
- Specified by:
getCharacterStreamin interfaceCallableStatement- Throws:
SQLException
-
getCharacterStream
- Specified by:
getCharacterStreamin interfaceCallableStatement- Throws:
SQLException
-
getNCharacterStream
- Specified by:
getNCharacterStreamin interfaceCallableStatement- Throws:
SQLException
-
getNCharacterStream
- Specified by:
getNCharacterStreamin interfaceCallableStatement- Throws:
SQLException
-
getNString
- Specified by:
getNStringin interfaceCallableStatement- Throws:
SQLException
-
getNString
- Specified by:
getNStringin interfaceCallableStatement- Throws:
SQLException
-
getRowId
- Specified by:
getRowIdin interfaceCallableStatement- Throws:
SQLException
-
getRowId
- Specified by:
getRowIdin interfaceCallableStatement- Throws:
SQLException
-
setRowId
- Specified by:
setRowIdin interfaceCallableStatement- Throws:
SQLException
-
setBlob
- Specified by:
setBlobin interfaceCallableStatement- Throws:
SQLException
-
setClob
- Specified by:
setClobin interfaceCallableStatement- Throws:
SQLException
-
setNString
- Specified by:
setNStringin interfaceCallableStatement- Throws:
SQLException
-
setNCharacterStream
- Specified by:
setNCharacterStreamin interfaceCallableStatement- Throws:
SQLException
-
setNCharacterStream
public final void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException - Specified by:
setNCharacterStreamin interfaceCallableStatement- Throws:
SQLException
-
setNClob
- Specified by:
setNClobin interfaceCallableStatement- Throws:
SQLException
-
setClob
- Specified by:
setClobin interfaceCallableStatement- Throws:
SQLException
-
setClob
- Specified by:
setClobin interfaceCallableStatement- Throws:
SQLException
-
setBlob
- Specified by:
setBlobin interfaceCallableStatement- Throws:
SQLException
-
setBlob
public final void setBlob(String parameterName, InputStream inputStream, long length) throws SQLException - Specified by:
setBlobin interfaceCallableStatement- Throws:
SQLException
-
setNClob
- Specified by:
setNClobin interfaceCallableStatement- Throws:
SQLException
-
setNClob
- Specified by:
setNClobin interfaceCallableStatement- Throws:
SQLException
-
getNClob
- Specified by:
getNClobin interfaceCallableStatement- Throws:
SQLException
-
getNClob
- Specified by:
getNClobin interfaceCallableStatement- Throws:
SQLException
-
setSQLXML
- Specified by:
setSQLXMLin interfaceCallableStatement- Throws:
SQLException
-
getSQLXML
- Specified by:
getSQLXMLin interfaceCallableStatement- Throws:
SQLException
-
getSQLXML
- Specified by:
getSQLXMLin interfaceCallableStatement- Throws:
SQLException
-
setAsciiStream
- Specified by:
setAsciiStreamin interfaceCallableStatement- Throws:
SQLException
-
setAsciiStream
public final void setAsciiStream(String parameterName, InputStream x, long length) throws SQLException - Specified by:
setAsciiStreamin interfaceCallableStatement- Throws:
SQLException
-
setBinaryStream
- Specified by:
setBinaryStreamin interfaceCallableStatement- Throws:
SQLException
-
setBinaryStream
public final void setBinaryStream(String parameterName, InputStream x, long length) throws SQLException - Specified by:
setBinaryStreamin interfaceCallableStatement- Throws:
SQLException
-
setCharacterStream
- Specified by:
setCharacterStreamin interfaceCallableStatement- Throws:
SQLException
-
setCharacterStream
public final void setCharacterStream(String parameterName, Reader x, long length) throws SQLException - Specified by:
setCharacterStreamin interfaceCallableStatement- Throws:
SQLException
-
getObject
/////////////////////////////////////////////////////////////////- Specified by:
getObjectin interfaceCallableStatement- Throws:
SQLException
-
getObject
- Specified by:
getObjectin 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:
getPreparedStatementin 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
-