org.apache.derby.client.am

Class PreparedStatement42

java.lang.Object

org.apache.derby.client.am.Statement

org.apache.derby.client.am.PreparedStatement

org.apache.derby.client.am.PreparedStatement40

org.apache.derby.client.am.PreparedStatement42

All Implemented Interfaces:

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

public class PreparedStatement42
extends PreparedStatement40

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

Constructors

Constructor and Description
PreparedStatement42(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.2 prepared statements with scroll attributes.
PreparedStatement42(Agent agent, Connection connection, java.lang.String sql, Section section, ClientPooledConnection cpc) The PreparedStatement used for JDBC 4.2 positioned update statements.

Method Summary

Modifier and Type	Method and Description
void	setObject(int parameterIndex, java.lang.Object x, java.sql.SQLType targetSqlType)
void	setObject(int parameterIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)

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

setNClob, setRowId, setSQLXML

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, closeOnCompletion, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Methods inherited from interface org.apache.derby.client.am.StatementCallbackInterface

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

Constructor Detail

PreparedStatement42

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

The PreparedStatement used for JDBC 4.2 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

Throws:

SqlException

PreparedStatement42

public PreparedStatement42(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.2 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

Throws:

SqlException

Method Detail

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x,
                      java.sql.SQLType targetSqlType)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x,
                      java.sql.SQLType targetSqlType,
                      int scaleOrLength)
               throws java.sql.SQLException

Throws:

java.sql.SQLException