EmbedCallableStatement (Apache Derby V10.10 Internals)

java.lang.Object
- org.apache.derby.impl.jdbc.ConnectionChild
- - org.apache.derby.impl.jdbc.EmbedStatement
  - - org.apache.derby.impl.jdbc.EmbedPreparedStatement
    - - org.apache.derby.impl.jdbc.EmbedCallableStatement

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper, EnginePreparedStatement, EngineStatement

Direct Known Subclasses:

EmbedCallableStatement20
```
public class EmbedCallableStatement
extends EmbedPreparedStatement
implements java.sql.CallableStatement
```
Local implementation.

Field Summary

Fields
Modifier and Type Field and Description

private boolean hasReturnOutputParameter

protected boolean wasNull
- Fields inherited from class org.apache.derby.impl.jdbc.EmbedPreparedStatement
  preparedStatement, rMetaData
- Fields inherited from class org.apache.derby.impl.jdbc.EmbedStatement
  applicationStatement, batchStatements, isPoolable, lcc, MaxFieldSize, maxRows, results, resultSetConcurrency, resultSetType, SQLText, timeoutMillis, updateCount
- Fields inherited from class org.apache.derby.impl.jdbc.ConnectionChild
  factory, localConn
- 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

Fields
Modifier and Type	Field and Description
`private boolean`	`hasReturnOutputParameter`
`protected boolean`	`wasNull`

Constructor Summary

Constructors
Constructor and Description
`EmbedCallableStatement(EmbedConnection conn, java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)`

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`void`	`addBatch()` JDBC 2.0 Add a set of parameters to the batch.
`protected void`	`checkRequiresCallableStatement(Activation activation)` Check to see if a statement requires to be executed via a callable statement.
`protected boolean`	`executeStatement(Activation a, boolean executeQuery, boolean executeUpdate)` Execute the current statement.
`java.math.BigDecimal`	`getBigDecimal(int parameterIndex)` JDBC 2.0 Get the value of a NUMERIC parameter as a java.math.BigDecimal object.
`java.math.BigDecimal`	`getBigDecimal(int parameterIndex, int scale)` Deprecated.
`java.sql.Blob`	`getBlob(int parameterIndex)` JDBC 2.0 Get a BLOB OUT parameter.
`boolean`	`getBoolean(int parameterIndex)`
`byte`	`getByte(int parameterIndex)`
`byte[]`	`getBytes(int parameterIndex)`
`java.sql.Clob`	`getClob(int parameterIndex)` JDBC 2.0 Get a CLOB OUT parameter.
`java.sql.Date`	`getDate(int parameterIndex)` Get the value of a SQL DATE parameter as a java.sql.Date object
`java.sql.Date`	`getDate(int parameterIndex, java.util.Calendar cal)`
`double`	`getDouble(int parameterIndex)`
`float`	`getFloat(int parameterIndex)`
`int`	`getInt(int parameterIndex)`
`long`	`getLong(int parameterIndex)`
`java.lang.Object`	`getObject(int parameterIndex)`
`short`	`getShort(int parameterIndex)`
`java.lang.String`	`getString(int parameterIndex)`
`java.sql.Time`	`getTime(int parameterIndex)` Get the value of a SQL TIME parameter as a java.sql.Time object.
`java.sql.Time`	`getTime(int parameterIndex, java.util.Calendar cal)`
`java.sql.Timestamp`	`getTimestamp(int parameterIndex)` Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object.
`java.sql.Timestamp`	`getTimestamp(int parameterIndex, java.util.Calendar cal)`
`java.net.URL`	`getURL(int parameterIndex)` JDBC 3.0 Retrieve the value of the designated JDBC DATALINK parameter as a java.net.URL object
`java.net.URL`	`getURL(java.lang.String parameterName)` JDBC 3.0 Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object
`void`	`registerOutParameter(int parameterIndex, int sqlType)`
`void`	`registerOutParameter(int parameterIndex, int sqlType, int scale)`
`void`	`registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName)` JDBC 2.0 Derby ignores the typeName argument because UDTs don't need it.
`void`	`setURL(java.lang.String parameterName, java.net.URL val)` JDBC 3.0 Sets the designated parameter to the given java.net.URL object.
`boolean`	`wasNull()`

Methods inherited from class org.apache.derby.impl.jdbc.EmbedPreparedStatement
addBatch, clearParameters, closeActions, dataTypeConversion, execute, execute, execute, execute, execute, executeBatchElement, executeLargeUpdate, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, finalize, getMetaData, getParameterJDBCType, getParameterSQLType, getParms, getTypes, getVersionCounter, newEmbedResultSetMetaData, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setBrokeredConnectionControl, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, toString, transferParameters

Methods inherited from class org.apache.derby.impl.jdbc.EmbedStatement
addWarning, cancel, checkExecStatus, checkIfInMiddleOfBatch, checkStatus, clearBatch, clearResultSets, clearWarnings, close, closeMeOnCompletion, closeOnCompletion, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getParameterValueSet, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSQLText, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, processDynamicResult, resultSetClosing, setApplicationStatement, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, transferBatch

Methods inherited from class org.apache.derby.impl.jdbc.ConnectionChild
commitIfAutoCommit, commitIfNeeded, getCal, getConnectionSynchronization, getEmbedConnection, handleException, needCommit, newSQLException, newSQLException, newSQLException, restoreContextStack, restoreIntrFlagIfSeen, setupContextStack

Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.sql.CallableStatement
getArray, getArray, getBigDecimal, getBlob, getBoolean, getByte, getBytes, getCharacterStream, getCharacterStream, getClob, getDate, getDate, getDouble, getFloat, getInt, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRowId, getRowId, getShort, getSQLXML, getSQLXML, getString, getTime, getTime, getTimestamp, getTimestamp, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, 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, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp

Methods inherited from interface java.sql.PreparedStatement
clearParameters, execute, executeLargeUpdate, 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, close, closeOnCompletion, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

Methods inherited from interface org.apache.derby.iapi.jdbc.EngineStatement
closeOnCompletion, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, getMoreResults, getResultSetHoldability, isClosed, isCloseOnCompletion, setLargeMaxRows

- Field Detail
  - hasReturnOutputParameter
```
private boolean hasReturnOutputParameter
```
  - wasNull
```
protected boolean wasNull
```
- Constructor Detail
  - EmbedCallableStatement
```
public EmbedCallableStatement(EmbedConnection conn,
                              java.lang.String sql,
                              int resultSetType,
                              int resultSetConcurrency,
                              int resultSetHoldability)
                       throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException - thrown on failure
- Method Detail
  - checkRequiresCallableStatement
```
protected void checkRequiresCallableStatement(Activation activation)
```
    Description copied from class: EmbedStatement
    
    Check to see if a statement requires to be executed via a callable statement.
    
    Overrides:
    
    checkRequiresCallableStatement in class EmbedStatement
  - executeStatement
```
protected final boolean executeStatement(Activation a,
                                         boolean executeQuery,
                                         boolean executeUpdate)
                                  throws java.sql.SQLException
```
    Description copied from class: EmbedStatement
    
    Execute the current statement.
    
    Overrides:
    
    executeStatement in class EmbedPreparedStatement
    
    Throws:
    
    java.sql.SQLException - thrown on failure.
  - registerOutParameter
```
public final void registerOutParameter(int parameterIndex,
                                       int sqlType)
                                throws java.sql.SQLException
```
    Specified by:
    
    registerOutParameter in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.registerOutParameter(int, int)
  - registerOutParameter
```
public final void registerOutParameter(int parameterIndex,
                                       int sqlType,
                                       int scale)
                                throws java.sql.SQLException
```
    Specified by:
    
    registerOutParameter in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.registerOutParameter(int, int)
  - registerOutParameter
```
public void registerOutParameter(int parameterIndex,
                                 int sqlType,
                                 java.lang.String typeName)
                          throws java.sql.SQLException
```
    JDBC 2.0 Derby ignores the typeName argument because UDTs don't need it.
    
    Specified by:
    
    registerOutParameter in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - wasNull
```
public boolean wasNull()
                throws java.sql.SQLException
```
    Specified by:
    
    wasNull in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.wasNull()
  - getString
```
public java.lang.String getString(int parameterIndex)
                           throws java.sql.SQLException
```
    Specified by:
    
    getString in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getString(int)
  - getBoolean
```
public boolean getBoolean(int parameterIndex)
                   throws java.sql.SQLException
```
    Specified by:
    
    getBoolean in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getBoolean(int)
  - getByte
```
public byte getByte(int parameterIndex)
             throws java.sql.SQLException
```
    Specified by:
    
    getByte in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getByte(int)
  - getShort
```
public short getShort(int parameterIndex)
               throws java.sql.SQLException
```
    Specified by:
    
    getShort in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getShort(int)
  - getInt
```
public int getInt(int parameterIndex)
           throws java.sql.SQLException
```
    Specified by:
    
    getInt in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getInt(int)
  - getLong
```
public long getLong(int parameterIndex)
             throws java.sql.SQLException
```
    Specified by:
    
    getLong in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getLong(int)
  - getBigDecimal
```
public final java.math.BigDecimal getBigDecimal(int parameterIndex)
                                         throws java.sql.SQLException
```
    JDBC 2.0 Get the value of a NUMERIC parameter as a java.math.BigDecimal object.
    
    Specified by:
    
    getBigDecimal in interface java.sql.CallableStatement
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    Returns:
    
    the parameter value (full precision); if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getBigDecimal
```
public final java.math.BigDecimal getBigDecimal(int parameterIndex,
                                                int scale)
                                         throws java.sql.SQLException
```
    Deprecated.
    
    Specified by:
    
    getBigDecimal in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getBigDecimal(int, int)
  - getFloat
```
public float getFloat(int parameterIndex)
               throws java.sql.SQLException
```
    Specified by:
    
    getFloat in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getFloat(int)
  - getDouble
```
public double getDouble(int parameterIndex)
                 throws java.sql.SQLException
```
    Specified by:
    
    getDouble in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getDouble(int)
  - getBytes
```
public byte[] getBytes(int parameterIndex)
                throws java.sql.SQLException
```
    Specified by:
    
    getBytes in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getBytes(int)
  - getDate
```
public java.sql.Date getDate(int parameterIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
```
    Specified by:
    
    getDate in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getDate(int)
  - getTime
```
public java.sql.Time getTime(int parameterIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
```
    Specified by:
    
    getTime in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getTime(int)
  - getTimestamp
```
public java.sql.Timestamp getTimestamp(int parameterIndex,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException
```
    Specified by:
    
    getTimestamp in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getTimestamp(int)
  - getDate
```
public java.sql.Date getDate(int parameterIndex)
                      throws java.sql.SQLException
```
    Get the value of a SQL DATE parameter as a java.sql.Date object
    
    Specified by:
    
    getDate in interface java.sql.CallableStatement
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    Returns:
    
    the parameter value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getTime
```
public java.sql.Time getTime(int parameterIndex)
                      throws java.sql.SQLException
```
    Get the value of a SQL TIME parameter as a java.sql.Time object.
    
    Specified by:
    
    getTime in interface java.sql.CallableStatement
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    Returns:
    
    the parameter value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getTimestamp
```
public java.sql.Timestamp getTimestamp(int parameterIndex)
                                throws java.sql.SQLException
```
    Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object.
    
    Specified by:
    
    getTimestamp in interface java.sql.CallableStatement
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    Returns:
    
    the parameter value; if the value is SQL NULL, the result is null
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getObject
```
public final java.lang.Object getObject(int parameterIndex)
                                 throws java.sql.SQLException
```
    Specified by:
    
    getObject in interface java.sql.CallableStatement
    
    Throws:
    
    java.sql.SQLException - NoOutputParameters thrown.
    
    See Also:
    
    CallableStatement.getObject(int)
  - getURL
```
public java.net.URL getURL(int parameterIndex)
                    throws java.sql.SQLException
```
    JDBC 3.0 Retrieve the value of the designated JDBC DATALINK parameter as a java.net.URL object
    
    Specified by:
    
    getURL in interface java.sql.CallableStatement
    
    Parameters:
    
    parameterIndex - - the first parameter is 1, the second is 2
    
    Returns:
    
    a java.net.URL object that represents the JDBC DATALINK value used as the designated parameter
    
    Throws:
    
    java.sql.SQLException - Feature not implemented for now.
  - setURL
```
public void setURL(java.lang.String parameterName,
                   java.net.URL val)
            throws java.sql.SQLException
```
    JDBC 3.0 Sets the designated parameter to the given java.net.URL object. The driver converts this to an SQL DATALINK value when it sends it to the database.
    
    Specified by:
    
    setURL in interface java.sql.CallableStatement
    
    Parameters:
    
    parameterName - - the name of the parameter
    
    val - - the parameter value
    
    Throws:
    
    java.sql.SQLException - Feature not implemented for now.
  - getURL
```
public java.net.URL getURL(java.lang.String parameterName)
                    throws java.sql.SQLException
```
    JDBC 3.0 Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object
    
    Specified by:
    
    getURL in interface java.sql.CallableStatement
    
    Parameters:
    
    parameterName - - the name of the parameter
    
    Returns:
    
    the parameter value. If the value is SQL NULL, the result is null.
    
    Throws:
    
    java.sql.SQLException - Feature not implemented for now.
  - getBlob
```
public java.sql.Blob getBlob(int parameterIndex)
                      throws java.sql.SQLException
```
    JDBC 2.0 Get a BLOB OUT parameter.
    
    Specified by:
    
    getBlob in interface java.sql.CallableStatement
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    Returns:
    
    an object representing a BLOB
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - getClob
```
public java.sql.Clob getClob(int parameterIndex)
                      throws java.sql.SQLException
```
    JDBC 2.0 Get a CLOB OUT parameter.
    
    Specified by:
    
    getClob in interface java.sql.CallableStatement
    
    Parameters:
    
    parameterIndex - the first parameter is 1, the second is 2, ...
    
    Returns:
    
    an object representing a CLOB
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.
  - addBatch
```
public void addBatch()
              throws java.sql.SQLException
```
    Description copied from class: EmbedPreparedStatement
    
    JDBC 2.0 Add a set of parameters to the batch.
    
    Specified by:
    
    addBatch in interface java.sql.PreparedStatement
    
    Overrides:
    
    addBatch in class EmbedPreparedStatement
    
    Throws:
    
    java.sql.SQLException - if a database-access error occurs.

Class EmbedCallableStatement

Field Summary

Fields inherited from class org.apache.derby.impl.jdbc.EmbedPreparedStatement

Fields inherited from class org.apache.derby.impl.jdbc.EmbedStatement

Fields inherited from class org.apache.derby.impl.jdbc.ConnectionChild

Fields inherited from interface java.sql.Statement

Constructor Summary

Method Summary

Methods inherited from class org.apache.derby.impl.jdbc.EmbedPreparedStatement

Methods inherited from class org.apache.derby.impl.jdbc.EmbedStatement

Methods inherited from class org.apache.derby.impl.jdbc.ConnectionChild

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.CallableStatement

Methods inherited from interface java.sql.PreparedStatement

Methods inherited from interface java.sql.Statement

Methods inherited from interface java.sql.Wrapper

Methods inherited from interface org.apache.derby.iapi.jdbc.EngineStatement

Field Detail

hasReturnOutputParameter

wasNull

Constructor Detail

EmbedCallableStatement

Method Detail

checkRequiresCallableStatement

executeStatement

registerOutParameter

registerOutParameter

registerOutParameter

wasNull

getString

getBoolean

getByte

getShort

getInt

getLong

getBigDecimal

getBigDecimal

getFloat

getDouble

getBytes

getDate

getTime

getTimestamp

getDate

getTime

getTimestamp

getObject

getURL

setURL

getURL

getBlob

getClob

addBatch