org.apache.derby.impl.jdbc
Class EmbedCallableStatement

java.lang.Object
  extended byorg.apache.derby.impl.jdbc.ConnectionChild
      extended byorg.apache.derby.impl.jdbc.EmbedStatement
          extended byorg.apache.derby.impl.jdbc.EmbedPreparedStatement
              extended byorg.apache.derby.impl.jdbc.EmbedCallableStatement
All Implemented Interfaces:
java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement
Direct Known Subclasses:
EmbedCallableStatement169, EmbedCallableStatement20

public abstract class EmbedCallableStatement
extends EmbedPreparedStatement
implements java.sql.CallableStatement

Local implementation.

Author:
ames

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
active, batchStatements, CLOSE, cursorName, factory, forMetaData, lcc, localConn, MaxFieldSize, maxRows, NOCLOSE, results, resultSetConcurrency, resultSetHoldability, resultSetType, SQLText, updateCount
 
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.sql.Blob getBlob(int i)
          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 i)
          JDBC 2.0 Get a CLOB OUT parameter.
 java.sql.Date getDate(int parameterIndex)
           
 java.sql.Date getDate(int parameterIndex, java.util.Calendar cal)
          Get the value of a SQL DATE parameter as a java.sql.Date object
 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)
           
 java.sql.Time getTime(int parameterIndex, java.util.Calendar cal)
          Get the value of a SQL TIME parameter as a java.sql.Time object.
 java.sql.Timestamp getTimestamp(int parameterIndex)
           
 java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal)
          Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object.
 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 Registers the designated output parameter
 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, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, finalize, getEmbedParameterSetMetaData, getMetaData, getParameterJDBCType, getParms, getTypes, newEmbedResultSetMetaData, setAsciiStream, setBinaryStream, setBinaryStreamInternal, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStreamInternal, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setObjectConvert, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, toString, transferParameters
 
Methods inherited from class org.apache.derby.impl.jdbc.EmbedStatement
cancel, checkExecStatus, checkIfInMiddleOfBatch, checkStatus, clearBatch, clearResultSets, clearWarnings, close, commitIfAutoCommit, commitIfNeeded, execute, executeBatch, getCal, getConnection, getConnectionSynchronization, getContextManager, getDatabase, getEmbedConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getParameterValueSet, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSQLText, getUpdateCount, getWarnings, getWarnings, handleException, handleException, needCommit, newSQLException, newSQLException, newSQLException, restoreContextStack, resultSetClosing, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, setupContextStack, transferBatch
 
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, getBigDecimal, getBigDecimal, getBlob, getBoolean, getByte, getBytes, getClob, getDate, getDate, getDouble, getFloat, getInt, getLong, getObject, getObject, getObject, getRef, getRef, getShort, getString, getTime, getTime, getTimestamp, getTimestamp, registerOutParameter, registerOutParameter, registerOutParameter, setAsciiStream, setBigDecimal, setBinaryStream, setBoolean, setByte, setBytes, setCharacterStream, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setShort, setString, setTime, setTime, setTimestamp, setTimestamp
 
Methods inherited from interface java.sql.PreparedStatement
clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout
 

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

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 Registers the designated output parameter

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)

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)
                      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)
                      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)
                                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,
                             java.util.Calendar cal)
                      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,
                             java.util.Calendar cal)
                      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,
                                       java.util.Calendar cal)
                                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 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 i)
                      throws java.sql.SQLException
JDBC 2.0 Get a BLOB OUT parameter.

Specified by:
getBlob in interface java.sql.CallableStatement
Parameters:
i - 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 i)
                      throws java.sql.SQLException
JDBC 2.0 Get a CLOB OUT parameter.

Specified by:
getClob in interface java.sql.CallableStatement
Parameters:
i - 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.

Built on Tue 2006-10-10 19:23:47+0200, from revision exported

Apache Derby V10.1 Engine Documentation - Copyright © 1997,2005 The Apache Software Foundation or its licensors, as applicable.