org.apache.derby.impl.jdbc
Class EmbedCallableStatement

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.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

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

Constructor Summary

EmbedCallableStatement(EmbedConnection conn, java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)

Method Summary

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, getRef, getRef, getRowId, getRowId, getShort, getSQLXML, getSQLXML, getString, getTime, getTime, getTimestamp, getTimestamp, 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, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp

Methods inherited from interface java.sql.PreparedStatement

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, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearBatch, clearWarnings, close, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, 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.