Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep
Overview  Package   Class  Use  Deprecated  Index 
Home >> All >> org >> apache >> derby >> client >> [ am overview ]  PREV CLASS  NEXT CLASS
SUMMARY: JavaDoc of org.apache.derby.client.am.PreparedStatement JAVADOC | Sourc code of org.apache.derby.client.am.PreparedStatement SOURCE | Download org.apache.derby.client.am.PreparedStatement DOWNLOAD | NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

org.apache.derby.client.am
Class PreparedStatement  view PreparedStatement download PreparedStatement.java

java.lang.Object
  extended byorg.apache.derby.client.am.Statement
      extended byorg.apache.derby.client.am.PreparedStatement
All Implemented Interfaces:
java.sql.PreparedStatement, PreparedStatementCallbackInterface, java.sql.Statement, StatementCallbackInterface, UnitOfWorkListener
Direct Known Subclasses:
CallableStatement
public class PreparedStatement
extends Statement
implements java.sql.PreparedStatement, PreparedStatementCallbackInterface

Field Summary
(package private)  boolean listenToUnitOfWork_
           
 MaterialPreparedStatement materialPreparedStatement_
           
 boolean outputRegistered_
           
 ColumnMetaData parameterMetaData_
           
(package private)  boolean[] parameterRegistered_
           
 java.lang.Object[] parameters_
           
(package private)  boolean[] parameterSet_
           
(package private)  java.lang.String positionedUpdateCursorName_
           
 java.lang.String sql_
           
 
Fields inherited from class org.apache.derby.client.am.Statement
agent_, autoGeneratedKeys_, batch_, cachedCursor_, cachedSingletonRowData_, CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, connection_, cursorAttributesToSendOnPrepare_, cursorName_, databaseMetaData_, escapedProcedureCallWithResult_, executeMethod__, executeQueryMethod__, executeUpdateMethod__, fetchDirection_, fetchSize_, generatedKeysColumnNames_, generatedKeysResultSet_, indexOfCurrentResultSet_, isAutoCommittableStatement_, isCall__, isCallableStatement_, isCatalogQuery_, isCommitSql__, isDeleteSql__, isInsertSql__, isPositionedUpdateDeleteSql__, isPreparedStatement_, isQuery__, isRollbackSql__, isUpdate__, isUpdateSql__, KEEP_CURRENT_RESULT, materialStatement_, maxFieldSize_, maxRows_, numInvisibleRS_, openOnClient_, openOnServer_, preparedStatementForAutoGeneratedKeys_, resultSet_, resultSetConcurrency_, resultSetHoldability_, resultSetList_, resultSetMetaData_, resultSetType_, returnValueFromProcedure_, section_, singletonRowData_, sqlMode_, sqlUpdateMode_, timeout_, 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
PreparedStatement(Agent agent, Connection connection, java.lang.String sql, int type, int concurrency, int holdability, int autoGeneratedKeys, java.lang.String[] columnNames)
           
PreparedStatement(Agent agent, Connection connection, java.lang.String sql, Section section)
           
 
Method Summary
 void addBatch()
          This method adds a set of parameters to the batch for JDBC 2.0.
private  int checkForEscapedCallWithResult(int parameterIndex)
           
(package private)  void checkForValidParameterIndex(int parameterIndex)
           
(package private)  void checkForValidScale(int scale)
           
(package private)  void checkScaleForINOUTDecimal(int parameterIndex, int registerOutScale)
           
private  int checkSetterPreconditions(int parameterIndex)
           
private  void checkThatAllParametersAreSet()
           
 void clearParameters()
          This method clears all of the input parameter that have been set on this statement.
 void close()
          This method closes the statement and frees any associated resources.
 void closeX()
           
 void completeDescribeInput(ColumnMetaData parameterMetaData, Sqlca sqlca)
           
 void completeDescribeOutput(ColumnMetaData resultSetMetaData, Sqlca sqlca)
           
 void completeLocalCommit(java.util.Iterator listenerIterator)
           
 void completeLocalRollback(java.util.Iterator listenerIterator)
           
(package private)  void completePrepareDescribe()
           
 boolean execute()
          This method executes a prepared SQL query.
 boolean execute(java.lang.String sql)
          This method executes an arbitrary SQL statement of any time.
 boolean execute(java.lang.String sql, int autoGeneratedKeys)
           
 boolean execute(java.lang.String sql, int[] columnIndexes)
           
 boolean execute(java.lang.String sql, java.lang.String[] columnNames)
           
 int[] executeBatch()
          This method executes the SQL batch and returns an array of update counts - one for each SQL statement in the batch - ordered in the same order the statements were added to the batch.
private  int[] executeBatchRequestX(boolean supportsQueryBatchRequest)
           
 int[] executeBatchX(boolean supportsQueryBatchRequest)
           
 java.sql.ResultSet executeQuery()
          This method executes a prepared SQL query and returns its ResultSet.
 java.sql.ResultSet executeQuery(java.lang.String sql)
          This method executes the specified SQL SELECT statement and returns a (possibly empty) ResultSet with the results of the query.
(package private)  ResultSet executeQueryX()
           
 int executeUpdate()
          This method executes an SQL INSERT, UPDATE or DELETE statement.
 int executeUpdate(java.lang.String sql)
          This method executes the specified SQL INSERT, UPDATE, or DELETE statement and returns the number of rows affected, which may be 0.
 int executeUpdate(java.lang.String sql, int autoGeneratedKeys)
           
 int executeUpdate(java.lang.String sql, int[] columnIndexes)
           
 int executeUpdate(java.lang.String sql, java.lang.String[] columnNames)
           
(package private)  int executeUpdateX()
           
private  boolean executeX()
           
private  boolean[] expandBooleanArray(boolean[] array, int newLength)
           
private  java.lang.Object[] expandObjectArray(java.lang.Object[] array, int newLength)
           
protected  void finalize()
          Called on an object by the Virtual Machine at most once, at some point after the Object is determined unreachable but before it is destroyed.
(package private)  void flowExecute(int executeType)
           
(package private)  void flowPrepareDescribeInputOutput()
           
(package private)  void flowPrepareForSelectFromInsert()
           
 java.sql.ResultSetMetaData getMetaData()
          This method returns meta data for the result set from this statement.
private  ColumnMetaData getMetaDataX()
           
 java.sql.ParameterMetaData getParameterMetaData()
          Returns information about the parameters set on this PreparedStatement (see ParameterMetaData for a detailed description of the provided information).
private  ParameterMetaData getParameterMetaDataX()
           
private  void initPreparedStatement()
           
private  void initPreparedStatement(ColumnMetaData parameterMetaData, ColumnMetaData resultSetMetaData)
           
private  void initPreparedStatement(java.lang.String sql)
           
private  void initPreparedStatement(java.lang.String sql, Section section)
           
protected  void initResetPreparedStatement()
           
 void listenToUnitOfWork()
           
(package private)  void prepare()
           
 void readDescribeInput()
           
 void readDescribeOutput()
           
 void readExecute()
           
(package private)  void readPrepareDescribeInput()
           
(package private)  void readPrepareDescribeInputOutput()
           
 void reset(boolean fullReset)
           
private  void resetParameters()
           
 void resetPreparedStatement(Agent agent, Connection connection, java.lang.String sql, int type, int concurrency, int holdability, int autoGeneratedKeys, java.lang.String[] columnNames)
           
 void resetPreparedStatement(Agent agent, Connection connection, java.lang.String sql, Section section)
           
 void resetPreparedStatement(Agent agent, Connection connection, java.lang.String sql, Section section, ColumnMetaData parameterMetaData, ColumnMetaData resultSetMetaData)
           
 void setArray(int parameterIndex, java.sql.Array x)
          This method sets the specified parameter from the given Java Array value.
 void setAsciiStream(int parameterIndex, java.io.InputStream x, int length)
          This method sets the specified parameter from the given Java ASCII InputStream value.
 void setBigDecimal(int parameterIndex, java.math.BigDecimal x)
          This method sets the specified parameter from the given Java java.math.BigDecimal value.
 void setBinaryStream(int parameterIndex, java.io.InputStream x, int length)
          This method sets the specified parameter from the given Java binary InputStream value.
 void setBinaryStreamX(int parameterIndex, java.io.InputStream x, int length)
           
 void setBlob(int parameterIndex, java.sql.Blob x)
          This method sets the specified parameter from the given Java Blob value.
 void setBlobX(int parameterIndex, java.sql.Blob x)
           
 void setBoolean(int parameterIndex, boolean x)
          This method sets the specified parameter from the given Java boolean value.
 void setByte(int parameterIndex, byte x)
          This method sets the specified parameter from the given Java byte value.
 void setBytes(int parameterIndex, byte[] x)
          This method sets the specified parameter from the given Java byte array value.
 void setBytesX(int parameterIndex, byte[] x)
           
 void setCharacterStream(int parameterIndex, java.io.Reader x, int length)
          This method sets the specified parameter from the given Java character Reader value.
 void setClob(int parameterIndex, java.sql.Clob x)
          This method sets the specified parameter from the given Java Clob value.
(package private)  void setClobX(int parameterIndex, java.sql.Clob x)
           
 void setDate(int parameterIndex, java.sql.Date x)
          This method sets the specified parameter from the given Java java.sql.Date value.
 void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar calendar)
          This method sets the specified parameter from the given Java java.sql.Date value.
 void setDouble(int parameterIndex, double x)
          This method sets the specified parameter from the given Java double value.
 void setFloat(int parameterIndex, float x)
          This method sets the specified parameter from the given Java float value.
(package private)  void setInput(int parameterIndex, java.lang.Object input)
           
 void setInt(int parameterIndex, int x)
          This method sets the specified parameter from the given Java int value.
(package private)  void setIntX(int parameterIndex, int x)
           
 void setLong(int parameterIndex, long x)
          This method sets the specified parameter from the given Java long value.
 void setNull(int parameterIndex, int jdbcType)
          This method populates the specified parameter with a SQL NULL value for the specified type.
 void setNull(int parameterIndex, int jdbcType, java.lang.String typeName)
          This method populates the specified parameter with a SQL NULL value for the specified type.
(package private)  void setNullX(int parameterIndex, int jdbcType)
           
 void setObject(int parameterIndex, java.lang.Object x)
          This method sets the specified parameter from the given Java Object value.
 void setObject(int parameterIndex, java.lang.Object x, int targetJdbcType)
          This method sets the specified parameter from the given Java Object value.
 void setObject(int parameterIndex, java.lang.Object x, int targetJdbcType, int scale)
          This method sets the specified parameter from the given Java Object value.
private  void setObjectX(int parameterIndex, java.lang.Object x, int targetJdbcType, int scale)
           
 void setRef(int parameterIndex, java.sql.Ref x)
          This method sets the specified parameter from the given Java Ref value.
 void setShort(int parameterIndex, short x)
          This method sets the specified parameter from the given Java short value.
(package private)  void setShortX(int parameterIndex, short x)
           
 void setString(int parameterIndex, java.lang.String x)
          This method sets the specified parameter from the given Java String value.
(package private)  void setStringX(int parameterIndex, java.lang.String x)
           
 void setTime(int parameterIndex, java.sql.Time x)
          This method sets the specified parameter from the given Java java.sql.Time value.
 void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar calendar)
          This method sets the specified parameter from the given Java java.sql.Time value.
 void setTimestamp(int parameterIndex, java.sql.Timestamp x)
          This method sets the specified parameter from the given Java java.sql.Timestamp value.
 void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar calendar)
          This method sets the specified parameter from the given Java java.sql.Timestamp value.
 void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length)
          This method sets the specified parameter from the given Java Unicode UTF-8 InputStream value.
 void setURL(int parameterIndex, java.net.URL x)
          This method sets the specified parameter from the given Java java.net.URL value.
 void writeDescribeInput(Section section)
           
 void writeDescribeOutput(Section section)
           
 void writeExecute(Section section, ColumnMetaData parameterMetaData, java.lang.Object[] inputs, int numInputColumns, boolean outputExpected, boolean chainedWritesFollowingSetLob)
           
 void writeOpenQuery(Section section, int fetchSize, int resultSetType, int numInputColumns, ColumnMetaData parameterMetaData, java.lang.Object[] inputs)
           
(package private)  void writePrepareDescribeInput()
           
(package private)  void writePrepareDescribeInputOutput()
           
(package private)  void writePrepareDescribeInputOutput(java.lang.String sql, Section section)
           
 
Methods inherited from class org.apache.derby.client.am.Statement
accumulateWarning, addBatch, cacheCursorAttributesToSendOnPrepare, cancel, checkAutoGeneratedKeysParameters, checkExecuteQueryPostConditions, checkExecuteUpdatePostConditions, checkForAppropriateSqlMode, checkForClosedStatement, checkForInvalidBatchedSql, clearBatch, clearWarnings, clearWarningsX, completeExecute, completeExecuteCall, completeExecuteCall, completeExecuteCallOpenQuery, completeExecuteImmediate, completeExecuteSetStatement, completeOpenQuery, completePrepare, completePrepareDescribeOutput, completeSqlca, constructSelectFromInsertSQL, escape, executeX, extractCursorNameFromWhereCurrentOf, flowExecuteBatch, getConnection, getConnectionCallbackInterface, getFetchDirection, getFetchSize, getGeneratedKeys, getGuessedResultSetMetaData, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getPreparedStatementForAutoGeneratedKeys, getProcedureName, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isQueryMode, mapCursorNameToResultSet, markClosed, markClosedOnServer, markPreparedStatementForAutoGeneratedKeysClosed, markResultSetsClosed, parseSqlAndSetSqlModes, parseStorProcReturnedScrollableRowset, prepareAutoGeneratedKeysStatement, readClose, readCloseResultSets, readCloseResultSets, readExecuteCall, readExecuteImmediate, readExecuteImmediateForBatch, readOpenQuery, readPrepare, readPrepareAutoGeneratedKeysStatement, readPrepareDescribeOutput, readSetSpecialRegister, removeClientCursorNameFromCache, resetCursorNameAndRemoveFromWhereCurrentOfMappings, resetStatement, resetStatement, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, setUpdateCount, substituteClientCursorNameWithServerCursorName, upperCaseProcedureName, writeClose, writeCloseResultSets, writeCloseResultSets, writeExecuteCall, writeExecuteImmediate, writeOpenQuery, writePrepare, writePrepareDescribeOutput, writeSetSpecialRegister
 
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout
 
Methods inherited from interface org.apache.derby.client.am.StatementCallbackInterface
accumulateWarning, completeExecute, completeExecuteCall, completeExecuteCall, completeExecuteCallOpenQuery, completeExecuteImmediate, completeExecuteSetStatement, completeOpenQuery, completePrepare, completePrepareDescribeOutput, completeSqlca, getConnectionCallbackInterface, getGuessedResultSetMetaData
 

Field Detail

materialPreparedStatement_

public MaterialPreparedStatement materialPreparedStatement_

sql_

public java.lang.String sql_

outputRegistered_

public boolean outputRegistered_

parameters_

public java.lang.Object[] parameters_

parameterSet_

boolean[] parameterSet_

parameterRegistered_

boolean[] parameterRegistered_

parameterMetaData_

public ColumnMetaData parameterMetaData_

positionedUpdateCursorName_

java.lang.String positionedUpdateCursorName_

listenToUnitOfWork_

boolean listenToUnitOfWork_
Constructor Detail

PreparedStatement

public PreparedStatement(Agent agent,
                         Connection connection,
                         java.lang.String sql,
                         Section section)
                  throws SqlException

PreparedStatement

public PreparedStatement(Agent agent,
                         Connection connection,
                         java.lang.String sql,
                         int type,
                         int concurrency,
                         int holdability,
                         int autoGeneratedKeys,
                         java.lang.String[] columnNames)
                  throws SqlException
Method Detail

setInput

void setInput(int parameterIndex,
              java.lang.Object input)

initPreparedStatement

private void initPreparedStatement()

initResetPreparedStatement

protected void initResetPreparedStatement()
Overrides:
initResetPreparedStatement in class Statement

reset

public void reset(boolean fullReset)
           throws SqlException
Overrides:
reset in class Statement

resetParameters

private void resetParameters()

resetPreparedStatement

public void resetPreparedStatement(Agent agent,
                                   Connection connection,
                                   java.lang.String sql,
                                   Section section)
                            throws SqlException

initPreparedStatement

private void initPreparedStatement(java.lang.String sql,
                                   Section section)
                            throws SqlException

resetPreparedStatement

public void resetPreparedStatement(Agent agent,
                                   Connection connection,
                                   java.lang.String sql,
                                   int type,
                                   int concurrency,
                                   int holdability,
                                   int autoGeneratedKeys,
                                   java.lang.String[] columnNames)
                            throws SqlException

initPreparedStatement

private void initPreparedStatement(java.lang.String sql)
                            throws SqlException

resetPreparedStatement

public void resetPreparedStatement(Agent agent,
                                   Connection connection,
                                   java.lang.String sql,
                                   Section section,
                                   ColumnMetaData parameterMetaData,
                                   ColumnMetaData resultSetMetaData)
                            throws SqlException

initPreparedStatement

private void initPreparedStatement(ColumnMetaData parameterMetaData,
                                   ColumnMetaData resultSetMetaData)
                            throws SqlException

finalize

protected void finalize()
                 throws java.lang.Throwable
Description copied from class: java.lang.Object
Called on an object by the Virtual Machine at most once, at some point after the Object is determined unreachable but before it is destroyed. You would think that this means it eventually is called on every Object, but this is not necessarily the case. If execution terminates abnormally, garbage collection does not always happen. Thus you cannot rely on this method to always work. For finer control over garbage collection, use references from the java.lang.ref package.

Virtual Machines are free to not call this method if they can determine that it does nothing important; for example, if your class extends Object and overrides finalize to do simply super.finalize().

finalize() will be called by a java.lang.Thread that has no locks on any Objects, and may be called concurrently. There are no guarantees on the order in which multiple objects are finalized. This means that finalize() is usually unsuited for performing actions that must be thread-safe, and that your implementation must be use defensive programming if it is to always work.

If an Exception is thrown from finalize() during garbage collection, it will be patently ignored and the Object will still be destroyed.

It is allowed, although not typical, for user code to call finalize() directly. User invocation does not affect whether automatic invocation will occur. It is also permitted, although not recommended, for a finalize() method to "revive" an object by making it reachable from normal code again.

Unlike constructors, finalize() does not get called for an object's superclass unless the implementation specifically calls super.finalize().

The default implementation does nothing.

Overrides:
finalize in class Statement

prepare

void prepare()
       throws SqlException

execute

public boolean execute(java.lang.String sql)
                throws SqlException
Description copied from interface: java.sql.Statement
This method executes an arbitrary SQL statement of any time. The methods getResultSet, getMoreResults and getUpdateCount retrieve the results.

Specified by:
execute in interface java.sql.Statement
Overrides:
execute in class Statement

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String sql)
                                throws SqlException
Description copied from interface: java.sql.Statement
This method executes the specified SQL SELECT statement and returns a (possibly empty) ResultSet with the results of the query.

Specified by:
executeQuery in interface java.sql.Statement
Overrides:
executeQuery in class Statement

executeUpdate

public int executeUpdate(java.lang.String sql)
                  throws SqlException
Description copied from interface: java.sql.Statement
This method executes the specified SQL INSERT, UPDATE, or DELETE statement and returns the number of rows affected, which may be 0.

Specified by:
executeUpdate in interface java.sql.Statement
Overrides:
executeUpdate in class Statement

executeQuery

public java.sql.ResultSet executeQuery()
                                throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method executes a prepared SQL query and returns its ResultSet.

Specified by:
executeQuery in interface java.sql.PreparedStatement

executeQueryX

ResultSet executeQueryX()
                  throws SqlException

executeUpdate

public int executeUpdate()
                  throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method executes an SQL INSERT, UPDATE or DELETE statement. SQL statements that return nothing such as SQL DDL statements can be executed.

Specified by:
executeUpdate in interface java.sql.PreparedStatement

executeUpdateX

int executeUpdateX()
             throws SqlException

setNull

public void setNull(int parameterIndex,
                    int jdbcType)
             throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method populates the specified parameter with a SQL NULL value for the specified type.

Specified by:
setNull in interface java.sql.PreparedStatement

setNullX

void setNullX(int parameterIndex,
              int jdbcType)
        throws SqlException

setNull

public void setNull(int parameterIndex,
                    int jdbcType,
                    java.lang.String typeName)
             throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method populates the specified parameter with a SQL NULL value for the specified type.

Specified by:
setNull in interface java.sql.PreparedStatement

setBoolean

public void setBoolean(int parameterIndex,
                       boolean x)
                throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java boolean value.

Specified by:
setBoolean in interface java.sql.PreparedStatement

setByte

public void setByte(int parameterIndex,
                    byte x)
             throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java byte value.

Specified by:
setByte in interface java.sql.PreparedStatement

setShort

public void setShort(int parameterIndex,
                     short x)
              throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java short value.

Specified by:
setShort in interface java.sql.PreparedStatement

setShortX

void setShortX(int parameterIndex,
               short x)
         throws SqlException

setInt

public void setInt(int parameterIndex,
                   int x)
            throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java int value.

Specified by:
setInt in interface java.sql.PreparedStatement

setIntX

void setIntX(int parameterIndex,
             int x)
       throws SqlException

setLong

public void setLong(int parameterIndex,
                    long x)
             throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java long value.

Specified by:
setLong in interface java.sql.PreparedStatement

setFloat

public void setFloat(int parameterIndex,
                     float x)
              throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java float value.

Specified by:
setFloat in interface java.sql.PreparedStatement

setDouble

public void setDouble(int parameterIndex,
                      double x)
               throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java double value.

Specified by:
setDouble in interface java.sql.PreparedStatement

setBigDecimal

public void setBigDecimal(int parameterIndex,
                          java.math.BigDecimal x)
                   throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java java.math.BigDecimal value.

Specified by:
setBigDecimal in interface java.sql.PreparedStatement

setDate

public void setDate(int parameterIndex,
                    java.sql.Date x)
             throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java java.sql.Date value.

Specified by:
setDate in interface java.sql.PreparedStatement

setDate

public void setDate(int parameterIndex,
                    java.sql.Date x,
                    java.util.Calendar calendar)
             throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java java.sql.Date value.

Specified by:
setDate in interface java.sql.PreparedStatement

setTime

public void setTime(int parameterIndex,
                    java.sql.Time x)
             throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java java.sql.Time value.

Specified by:
setTime in interface java.sql.PreparedStatement

setTime

public void setTime(int parameterIndex,
                    java.sql.Time x,
                    java.util.Calendar calendar)
             throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java java.sql.Time value.

Specified by:
setTime in interface java.sql.PreparedStatement

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp x)
                  throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java java.sql.Timestamp value.

Specified by:
setTimestamp in interface java.sql.PreparedStatement

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp x,
                         java.util.Calendar calendar)
                  throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java java.sql.Timestamp value.

Specified by:
setTimestamp in interface java.sql.PreparedStatement

setString

public void setString(int parameterIndex,
                      java.lang.String x)
               throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java String value.

Specified by:
setString in interface java.sql.PreparedStatement

setStringX

void setStringX(int parameterIndex,
                java.lang.String x)
          throws SqlException

setBytes

public void setBytes(int parameterIndex,
                     byte[] x)
              throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java byte array value.

Specified by:
setBytes in interface java.sql.PreparedStatement

setBytesX

public void setBytesX(int parameterIndex,
                      byte[] x)
               throws SqlException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            java.io.InputStream x,
                            int length)
                     throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java binary InputStream value.

Specified by:
setBinaryStream in interface java.sql.PreparedStatement

setBinaryStreamX

public void setBinaryStreamX(int parameterIndex,
                             java.io.InputStream x,
                             int length)
                      throws SqlException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           java.io.InputStream x,
                           int length)
                    throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java ASCII InputStream value.

Specified by:
setAsciiStream in interface java.sql.PreparedStatement

setUnicodeStream

public void setUnicodeStream(int parameterIndex,
                             java.io.InputStream x,
                             int length)
                      throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java Unicode UTF-8 InputStream value.

Specified by:
setUnicodeStream in interface java.sql.PreparedStatement

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               java.io.Reader x,
                               int length)
                        throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java character Reader value.

Specified by:
setCharacterStream in interface java.sql.PreparedStatement

setBlob

public void setBlob(int parameterIndex,
                    java.sql.Blob x)
             throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java Blob value. The default object type to SQL type mapping will be used.

Specified by:
setBlob in interface java.sql.PreparedStatement

setBlobX

public void setBlobX(int parameterIndex,
                     java.sql.Blob x)
              throws SqlException

setClob

public void setClob(int parameterIndex,
                    java.sql.Clob x)
             throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java Clob value. The default object type to SQL type mapping will be used.

Specified by:
setClob in interface java.sql.PreparedStatement

setClobX

void setClobX(int parameterIndex,
              java.sql.Clob x)
        throws SqlException

setArray

public void setArray(int parameterIndex,
                     java.sql.Array x)
              throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java Array value. The default object type to SQL type mapping will be used.

Specified by:
setArray in interface java.sql.PreparedStatement

setRef

public void setRef(int parameterIndex,
                   java.sql.Ref x)
            throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java Ref value. The default object type to SQL type mapping will be used.

Specified by:
setRef in interface java.sql.PreparedStatement

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x)
               throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java Object value. The default object type to SQL type mapping will be used.

Specified by:
setObject in interface java.sql.PreparedStatement

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x,
                      int targetJdbcType)
               throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java Object value. The specified SQL object type will be used.

Specified by:
setObject in interface java.sql.PreparedStatement

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x,
                      int targetJdbcType,
                      int scale)
               throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java Object value. The specified SQL object type will be used.

Specified by:
setObject in interface java.sql.PreparedStatement

setObjectX

private void setObjectX(int parameterIndex,
                        java.lang.Object x,
                        int targetJdbcType,
                        int scale)
                 throws SqlException

clearParameters

public void clearParameters()
                     throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method clears all of the input parameter that have been set on this statement.

Specified by:
clearParameters in interface java.sql.PreparedStatement

execute

public boolean execute()
                throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method executes a prepared SQL query. Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate.

Specified by:
execute in interface java.sql.PreparedStatement

executeX

private boolean executeX()
                  throws SqlException

addBatch

public void addBatch()
              throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method adds a set of parameters to the batch for JDBC 2.0.

Specified by:
addBatch in interface java.sql.PreparedStatement

executeBatch

public int[] executeBatch()
                   throws SqlException,
                          BatchUpdateException
Description copied from interface: java.sql.Statement
This method executes the SQL batch and returns an array of update counts - one for each SQL statement in the batch - ordered in the same order the statements were added to the batch. A driver is not required to implement this method.

Specified by:
executeBatch in interface java.sql.Statement
Overrides:
executeBatch in class Statement

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method returns meta data for the result set from this statement.

Specified by:
getMetaData in interface java.sql.PreparedStatement

getMetaDataX

private ColumnMetaData getMetaDataX()
                             throws SqlException

execute

public boolean execute(java.lang.String sql,
                       int autoGeneratedKeys)
                throws SqlException
Specified by:
execute in interface java.sql.Statement
Overrides:
execute in class Statement

execute

public boolean execute(java.lang.String sql,
                       java.lang.String[] columnNames)
                throws SqlException
Specified by:
execute in interface java.sql.Statement
Overrides:
execute in class Statement

execute

public boolean execute(java.lang.String sql,
                       int[] columnIndexes)
                throws SqlException
Specified by:
execute in interface java.sql.Statement
Overrides:
execute in class Statement

executeUpdate

public int executeUpdate(java.lang.String sql,
                         int autoGeneratedKeys)
                  throws SqlException
Specified by:
executeUpdate in interface java.sql.Statement
Overrides:
executeUpdate in class Statement

executeUpdate

public int executeUpdate(java.lang.String sql,
                         java.lang.String[] columnNames)
                  throws SqlException
Specified by:
executeUpdate in interface java.sql.Statement
Overrides:
executeUpdate in class Statement

executeUpdate

public int executeUpdate(java.lang.String sql,
                         int[] columnIndexes)
                  throws SqlException
Specified by:
executeUpdate in interface java.sql.Statement
Overrides:
executeUpdate in class Statement

setURL

public void setURL(int parameterIndex,
                   java.net.URL x)
            throws SqlException
Description copied from interface: java.sql.PreparedStatement
This method sets the specified parameter from the given Java java.net.URL value.

Specified by:
setURL in interface java.sql.PreparedStatement

getParameterMetaData

public java.sql.ParameterMetaData getParameterMetaData()
                                                throws SqlException
Description copied from interface: java.sql.PreparedStatement
Returns information about the parameters set on this PreparedStatement (see java.sql.ParameterMetaData for a detailed description of the provided information).

Specified by:
getParameterMetaData in interface java.sql.PreparedStatement

getParameterMetaDataX

private ParameterMetaData getParameterMetaDataX()
                                         throws SqlException

writeExecute

public void writeExecute(Section section,
                         ColumnMetaData parameterMetaData,
                         java.lang.Object[] inputs,
                         int numInputColumns,
                         boolean outputExpected,
                         boolean chainedWritesFollowingSetLob)
                  throws SqlException

readExecute

public void readExecute()
                 throws SqlException

writeOpenQuery

public void writeOpenQuery(Section section,
                           int fetchSize,
                           int resultSetType,
                           int numInputColumns,
                           ColumnMetaData parameterMetaData,
                           java.lang.Object[] inputs)
                    throws SqlException

writeDescribeInput

public void writeDescribeInput(Section section)
                        throws SqlException

readDescribeInput

public void readDescribeInput()
                       throws SqlException

completeDescribeInput

public void completeDescribeInput(ColumnMetaData parameterMetaData,
                                  Sqlca sqlca)
Specified by:
completeDescribeInput in interface PreparedStatementCallbackInterface

writeDescribeOutput

public void writeDescribeOutput(Section section)
                         throws SqlException

readDescribeOutput

public void readDescribeOutput()
                        throws SqlException

completeDescribeOutput

public void completeDescribeOutput(ColumnMetaData resultSetMetaData,
                                   Sqlca sqlca)
Specified by:
completeDescribeOutput in interface PreparedStatementCallbackInterface

writePrepareDescribeInputOutput

void writePrepareDescribeInputOutput()
                               throws SqlException

readPrepareDescribeInputOutput

void readPrepareDescribeInputOutput()
                              throws SqlException

writePrepareDescribeInput

void writePrepareDescribeInput()
                         throws SqlException

readPrepareDescribeInput

void readPrepareDescribeInput()
                        throws SqlException

completePrepareDescribe

void completePrepareDescribe()

expandObjectArray

private java.lang.Object[] expandObjectArray(java.lang.Object[] array,
                                             int newLength)

expandBooleanArray

private boolean[] expandBooleanArray(boolean[] array,
                                     int newLength)

flowPrepareForSelectFromInsert

void flowPrepareForSelectFromInsert()
                              throws SqlException

writePrepareDescribeInputOutput

void writePrepareDescribeInputOutput(java.lang.String sql,
                                     Section section)
                               throws SqlException

flowPrepareDescribeInputOutput

void flowPrepareDescribeInputOutput()
                              throws SqlException

flowExecute

void flowExecute(int executeType)
           throws SqlException

executeBatchX

public int[] executeBatchX(boolean supportsQueryBatchRequest)
                    throws SqlException,
                           BatchUpdateException

executeBatchRequestX

private int[] executeBatchRequestX(boolean supportsQueryBatchRequest)
                            throws SqlException,
                                   BatchUpdateException

listenToUnitOfWork

public void listenToUnitOfWork()
Specified by:
listenToUnitOfWork in interface UnitOfWorkListener
Overrides:
listenToUnitOfWork in class Statement

completeLocalCommit

public void completeLocalCommit(java.util.Iterator listenerIterator)
Specified by:
completeLocalCommit in interface UnitOfWorkListener
Overrides:
completeLocalCommit in class Statement

completeLocalRollback

public void completeLocalRollback(java.util.Iterator listenerIterator)
Specified by:
completeLocalRollback in interface UnitOfWorkListener
Overrides:
completeLocalRollback in class Statement

checkSetterPreconditions

private int checkSetterPreconditions(int parameterIndex)
                              throws SqlException

checkForValidParameterIndex

void checkForValidParameterIndex(int parameterIndex)
                           throws SqlException

checkThatAllParametersAreSet

private void checkThatAllParametersAreSet()
                                   throws SqlException

checkForEscapedCallWithResult

private int checkForEscapedCallWithResult(int parameterIndex)
                                   throws SqlException

checkForValidScale

void checkForValidScale(int scale)
                  throws SqlException

checkScaleForINOUTDecimal

void checkScaleForINOUTDecimal(int parameterIndex,
                               int registerOutScale)
                         throws SqlException

close

public void close()
           throws SqlException
Description copied from interface: java.sql.Statement
This method closes the statement and frees any associated resources.

Specified by:
close in interface java.sql.Statement
Overrides:
close in class Statement

closeX

public void closeX()
            throws SqlException
Overrides:
closeX in class Statement
Overview  Package   Class  Use  Deprecated  Index 
Home >> All >> org >> apache >> derby >> client >> [ am overview ]  PREV CLASS  NEXT CLASS
SUMMARY: JavaDoc of org.apache.derby.client.am.PreparedStatement JAVADOC | Sourc code of org.apache.derby.client.am.PreparedStatement SOURCE | Download org.apache.derby.client.am.PreparedStatement DOWNLOAD | NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD