org.apache.derby.client.am
Class PreparedStatement40

java.lang.Object
  org.apache.derby.client.am.Statement
      org.apache.derby.client.am.PreparedStatement
          org.apache.derby.client.am.PreparedStatement40

All Implemented Interfaces:

java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper, PreparedStatementCallbackInterface, StatementCallbackInterface, UnitOfWorkListener

public class PreparedStatement40
extends PreparedStatement

Field Summary

Fields inherited from class org.apache.derby.client.am.PreparedStatement

listenToUnitOfWork_, materialPreparedStatement_, outputRegistered_, parameterMetaData_, parameterRegistered_, parameters_, parameterSet_, pooledConnection_, positionedUpdateCursorName_, sql_

Fields inherited from class org.apache.derby.client.am.Statement

agent_, autoGeneratedKeys_, batch_, cachedCursor_, cachedSingletonRowData_, connection_, cursorAttributesToSendOnPrepare_, cursorName_, doWriteTimeout, executeMethod__, executeQueryMethod__, executeUpdateMethod__, fetchDirection_, fetchedRowBase, fetchSize_, generatedKeysColumnIndexes_, generatedKeysColumnNames_, generatedKeysResultSet_, indexOfCurrentResultSet_, isAutoCommittableStatement_, isCall__, isCatalogQuery_, isCommitSql__, isDeleteSql__, isInsertSql__, isPoolable, isPositionedUpdateDeleteSql__, isPreparedStatement_, isQuery__, isRollbackSql__, isUpdate__, isUpdateSql__, materialStatement_, maxFieldSize_, maxRows_, numInvisibleRS_, openOnClient_, openOnServer_, preparedStatementForAutoGeneratedKeys_, resultSet_, resultSetConcurrency_, resultSetHoldability_, resultSetList_, resultSetMetaData_, resultSetType_, returnValueFromProcedure_, section_, singletonRowData_, sqlMode_, sqlUpdateMode_, timeout_, TIMEOUT_STATEMENT, timeoutArrayList, 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

PreparedStatement40(Agent agent, Connection connection, java.lang.String sql, int type, int concurrency, int holdability, int autoGeneratedKeys, java.lang.String[] columnNames, int[] columnIndexes, ClientPooledConnection cpc)
The PreparedStatementConstructor used for jdbc 4 prepared statements with scroll attributes.

PreparedStatement40(Agent agent, Connection connection, java.lang.String sql, Section section, ClientPooledConnection cpc)
The PreparedStatement used for JDBC 4 positioned update statements.

Method Summary

void	setNClob(int index, java.sql.NClob value)
void	setRowId(int parameterIndex, java.sql.RowId x)
void	setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject)

Methods inherited from class org.apache.derby.client.am.PreparedStatement

addBatch, addBatch, checkForValidParameterIndex, checkForValidScale, checkScaleForINOUTDecimal, checkStatus, clearParameters, completeDescribeInput, completeDescribeOutput, completeLocalCommit, completeLocalRollback, completePrepareDescribe, execute, execute, execute, execute, execute, executeBatch, executeBatchX, executeLargeUpdate, executeQuery, executeQuery, executeQueryX, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeX, flowPrepareDescribeInputOutput, getJdbcStatementInterfaceName, getMetaData, getParameterMetaData, initResetPreparedStatement, listenToUnitOfWork, markClosed, prepare, readDescribeInput, readDescribeOutput, readExecute, readPrepareDescribeInput, readPrepareDescribeInputOutput, reset, resetForReuse, resetPreparedStatement, resetPreparedStatement, resetPreparedStatement, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBinaryStreamX, setBlob, setBlob, setBlob, setBlobX, setBoolean, setByte, setBytes, setBytesX, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setClobX, setDate, setDate, setDouble, setFloat, setInput, setInt, setIntX, setLong, setLongX, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNString, setNull, setNull, setNullX, setObject, setObject, setObject, setRef, setShort, setShortX, setString, setStringX, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, writeDescribeInput, writeDescribeOutput, writeExecute, writePrepareDescribeInput, writePrepareDescribeInputOutput, writePrepareDescribeInputOutput

Methods inherited from class org.apache.derby.client.am.Statement

accumulateWarning, cacheCursorAttributesToSendOnPrepare, cancel, checkAutoGeneratedKeysParameters, checkForAppropriateSqlMode, checkForClosedStatement, checkForDuplicateCursorName, checkForInvalidBatchedSql, checkForStoredProcResultSetCount, clearBatch, clearWarnings, clearWarningsX, close, closeMeOnCompletion, closeOnCompletion, closeX, completeExecute, completeExecuteCall, completeExecuteCall, completeExecuteCallOpenQuery, completeExecuteImmediate, completeExecuteSetStatement, completeOpenQuery, completePrepare, completePrepareDescribeOutput, completeSqlca, escape, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeX, extractCursorNameFromWhereCurrentOf, finalize, flowExecuteBatch, getConnection, getConnectionCallbackInterface, getFetchDirection, getFetchSize, getGeneratedKeys, getGuessedResultSetMetaData, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getOwner, getPreparedStatementForAutoGeneratedKeys, getProcedureName, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSqlWarnings, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isQueryMode, isWrapperFor, jdbc3FeatureNotSupported, jdbc3FeatureNotSupported, mapCursorNameToResultSet, markAutoCommitted, markClosed, markClosedOnServer, markPreparedStatementForAutoGeneratedKeysClosed, markResultSetsClosed, markResultSetsClosed, parseSqlAndSetSqlModes, parseStorProcReturnedScrollableRowset, prepareAutoGeneratedKeysStatement, readClose, readCloseResultSets, readCloseResultSets, readExecuteCall, readExecuteImmediate, readExecuteImmediateForBatch, readOpenQuery, readPrepare, readPrepareAutoGeneratedKeysStatement, readPrepareDescribeOutput, readSetSpecialRegister, removeClientCursorNameFromCache, resetCursorNameAndRemoveFromWhereCurrentOfMappings, resetStatement, resetStatement, resultSetCommitting, resultSetCommitting, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setOwner, setPoolable, setQueryTimeout, setupCursorNameCacheAndMappings, setUpdateCount, substituteClientCursorNameWithServerCursorName, unwrap, 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

cancel, clearBatch, clearWarnings, close, 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.client.am.StatementCallbackInterface

accumulateWarning, completeExecute, completeExecuteCall, completeExecuteCall, completeExecuteCallOpenQuery, completeExecuteImmediate, completeExecuteSetStatement, completeOpenQuery, completePrepare, completePrepareDescribeOutput, completeSqlca, getConnectionCallbackInterface, getGuessedResultSetMetaData

Constructor Detail

PreparedStatement40

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

The PreparedStatement used for JDBC 4 positioned update statements. Called by material statement constructors. It has the ClientPooledConnection as one of its parameters this is used to raise the Statement Events when the prepared statement is closed

Parameters:

agent - The instance of NetAgent associated with this CallableStatement object.

connection - The connection object associated with this PreparedStatement Object.

sql - A String object that is the SQL statement to be sent to the database.

section - Section

cpc - The ClientPooledConnection wraps the underlying physical connection associated with this prepared statement. It is used to pass the Statement closed and the Statement error occurred events that occur back to the ClientPooledConnection.

Throws:

SqlException

PreparedStatement40

public PreparedStatement40(Agent agent,
                           Connection connection,
                           java.lang.String sql,
                           int type,
                           int concurrency,
                           int holdability,
                           int autoGeneratedKeys,
                           java.lang.String[] columnNames,
                           int[] columnIndexes,
                           ClientPooledConnection cpc)
                    throws SqlException

The PreparedStatementConstructor used for jdbc 4 prepared statements with scroll attributes. Called by material statement constructors. It has the ClientPooledConnection as one of its parameters this is used to raise the Statement Events when the prepared statement is closed

Parameters:

agent - The instance of NetAgent associated with this CallableStatement object.

connection - The connection object associated with this PreparedStatement Object.

sql - A String object that is the SQL statement to be sent to the database.

type - One of the ResultSet type constants.

concurrency - One of the ResultSet concurrency constants.

holdability - One of the ResultSet holdability constants.

autoGeneratedKeys - a flag indicating whether auto-generated keys should be returned.

columnNames - an array of column names indicating the columns that should be returned from the inserted row or rows.

columnIndexes - an array of column indexes indicating the columns that should be returned from the inserted row.

cpc - The ClientPooledConnection wraps the underlying physical connection associated with this prepared statement it is used to pass the Statement closed and the Statement error occurred events that occur back to the ClientPooledConnection.

Throws:

SqlException

Method Detail

setRowId

public void setRowId(int parameterIndex,
                     java.sql.RowId x)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

setNClob

public void setNClob(int index,
                     java.sql.NClob value)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

setSQLXML

public void setSQLXML(int parameterIndex,
                      java.sql.SQLXML xmlObject)
               throws java.sql.SQLException

Throws:

java.sql.SQLException