Top Inners Fields Constructors Methods
org.apache.derby.client.am

public Class ClientPreparedStatement

extends ClientStatement
implements PreparedStatement, PreparedStatementCallbackInterface
Class Inheritance
All Implemented Interfaces
org.apache.derby.client.am.PreparedStatementCallbackInterface, org.apache.derby.client.am.StatementCallbackInterface, org.apache.derby.client.am.UnitOfWorkListener, java.sql.PreparedStatement, java.sql.Statement, java.lang.AutoCloseable, java.sql.Wrapper
Known Direct Subclasses
org.apache.derby.client.am.ClientPreparedStatement42, org.apache.derby.client.am.ClientCallableStatement
Imports
java.io.InputStream, .Reader, java.math.BigDecimal, .BigInteger, .RoundingMode, java.net.URL, java.sql.Array, .BatchUpdateException, .Blob, .Clob, .Date, .NClob, .ParameterMetaData, .PreparedStatement, .Ref, .ResultSet, .ResultSetMetaData, .RowId, .SQLException, .SQLXML, .Time, .Timestamp, .Types, java.util.ArrayList, .Arrays, .Calendar, .Iterator, org.apache.derby.client.ClientPooledConnection, .ClientAutoloadedDriver, org.apache.derby.shared.common.reference.SQLState, org.apache.derby.shared.common.sanity.SanityManager

Nested and Inner Type Summary

Modifier and TypeClass and Description
private static class
ClientPreparedStatement.PossibleTypes

PossibleTypes is information which is set of types.

Field Summary

Modifier and TypeField and Description
private boolean
public MaterialPreparedStatement
pack-priv boolean
pack-priv ColumnMetaData
pack-priv boolean[]
pack-priv Object[]
private boolean[]
private ArrayList<int[]>
private final ClientPooledConnection
private String
pack-priv String
Inherited from org.apache.derby.client.am.ClientStatement:
agent_autoGeneratedKeys_batch_cachedCursor_cachedSingletonRowData_connection_cursorAttributesToSendOnPrepare_cursorName_doWriteTimeoutexecuteMethod__executeQueryMethod__executeUpdateMethod__fetchDirection_fetchSize_generatedKeysColumnIndexes_generatedKeysColumnNames_generatedKeysResultSet_isAutoCommittableStatement_isCall__isCatalogQuery_isDeleteSql__isInsertSql__isPoolableisPreparedStatement_isQuery__isUpdate__isUpdateSql__maxFieldSize_maxRows_openOnClient_preparedStatementForAutoGeneratedKeys_resultSet_resultSetConcurrency_resultSetHoldability_resultSetList_resultSetMetaData_resultSetType_singletonRowData_sqlMode_sqlUpdateMode_timeout_TIMEOUT_STATEMENTtimeoutArrayListupdateCount_

Constructor Summary

AccessConstructor and Description
public
ClientPreparedStatement(Agent
The instance of NetAgent associated with this CallableStatement object.
agent
,
ClientConnection
The connection object associated with this PreparedStatement Object.
connection
,
String
A String object that is the SQL statement to be sent to the database.
sql
,
Section
Section
section
,
ClientPooledConnection
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.
cpc
)

The PreparedStatement constructor used for JDBC 2 positioned update statements.

public
ClientPreparedStatement(Agent
The instance of NetAgent associated with this CallableStatement object.
agent
,
ClientConnection
The connection object associated with this PreparedStatement Object.
connection
,
String
A String object that is the SQL statement to be sent to the database.
sql
,
int
One of the ResultSet type constants.
type
,
int
One of the ResultSet concurrency constants.
concurrency
,
int
One of the ResultSet holdability constants.
holdability
,
int
a flag indicating whether auto-generated keys should be returned.
autoGeneratedKeys
,
String[]
an array of column names indicating the columns that should be returned from the inserted row or rows.
columnNames
,
int[]
an array of column names indicating the columns that should be returned from the inserted row.
columnIndexes
,
ClientPooledConnection
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.
cpc
)

The PreparedStatementConstructor used for jdbc 2 prepared statements with scroll attributes.

Method Summary

Modifier and TypeMethod and Description
public void
addBatch(String
typically this is a SQL INSERT or UPDATE statement
sql
)

Overrides org.apache.derby.client.am.ClientStatement.addBatch.

Implements java.sql.Statement.addBatch.

Adds the given SQL command to the current list of commands for this Statement object.
public void
addBatch()

Implements java.sql.PreparedStatement.addBatch.

Adds a set of parameters to this PreparedStatement object's batch of commands.
pack-priv void
checkForValidParameterIndex(int parameterIndex)

pack-priv void
checkForValidScale(int scale)

private void
protected void
checkStatus()

Check for closed statement and extract the SQLException if it is raised.

private void
checkStreamLength(long
The length of the stream being set
length
)

Check the length passed in for the stream that is to be set.

private void
private void
checkTypeForSetAsciiStream(int parameterIndex)

private void
checkTypeForSetBinaryStream(int parameterIndex)

private void
checkTypeForSetBlob(int parameterIndex)

private void
checkTypeForSetCharacterStream(int parameterIndex)

private void
checkTypeForSetClob(int parameterIndex)

public void
clearParameters()

Implements java.sql.PreparedStatement.clearParameters.

Clears the current parameter values immediately.
public void
public void
public void
public void
private void
public boolean
execute(String
any SQL statement
sql
)

Overrides org.apache.derby.client.am.ClientStatement.execute.

Implements java.sql.Statement.execute.

Executes the given SQL statement, which may return multiple results.
public boolean
execute()

Implements java.sql.PreparedStatement.execute.

Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.
public boolean
execute(String
any SQL statement
sql
,
int
a constant indicating whether auto-generated keys should be made available for retrieval using the method getGeneratedKeys; one of the following constants: Statement.RETURN_GENERATED_KEYS or Statement.NO_GENERATED_KEYS
autoGeneratedKeys
)

Overrides org.apache.derby.client.am.ClientStatement.execute.

Implements java.sql.Statement.execute.

Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval.
public boolean
execute(String
any SQL statement
sql
,
String[]
an array of the names of the columns in the inserted row that should be made available for retrieval by a call to the method getGeneratedKeys
columnNames
)

Overrides org.apache.derby.client.am.ClientStatement.execute.

Implements java.sql.Statement.execute.

Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
public boolean
execute(String
any SQL statement
sql
,
int[]
an array of the indexes of the columns in the inserted row that should be made available for retrieval by a call to the method getGeneratedKeys
columnIndexes
)

Overrides org.apache.derby.client.am.ClientStatement.execute.

Implements java.sql.Statement.execute.

Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
public int[]
executeBatch()

Overrides org.apache.derby.client.am.ClientStatement.executeBatch.

Implements java.sql.Statement.executeBatch.

Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
private long[]
executeBatchRequestX(boolean supportsQueryBatchRequest)

private long[]
executeBatchX(boolean supportsQueryBatchRequest)

public long
executeLargeUpdate()

Overrides default java.sql.PreparedStatement.executeLargeUpdate.

Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
public ResultSet
executeQuery(String
an SQL statement to be sent to the database, typically a static SQL SELECT statement
sql
)

Overrides org.apache.derby.client.am.ClientStatement.executeQuery.

Implements java.sql.Statement.executeQuery.

Executes the given SQL statement, which returns a single ResultSet object.
public ResultSet
executeQuery()

Implements java.sql.PreparedStatement.executeQuery.

Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.
pack-priv ClientResultSet
public int
executeUpdate(String
an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
sql
)

Overrides org.apache.derby.client.am.ClientStatement.executeUpdate.

Implements java.sql.Statement.executeUpdate.

Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.
public int
executeUpdate()

Implements java.sql.PreparedStatement.executeUpdate.

Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
public int
executeUpdate(String
an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
sql
,
int
a flag indicating whether auto-generated keys should be made available for retrieval; one of the following constants: Statement.RETURN_GENERATED_KEYS Statement.NO_GENERATED_KEYS
autoGeneratedKeys
)

Overrides org.apache.derby.client.am.ClientStatement.executeUpdate.

Implements java.sql.Statement.executeUpdate.

Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval.
public int
executeUpdate(String
an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
sql
,
String[]
an array of the names of the columns that should be returned from the inserted row
columnNames
)

Overrides org.apache.derby.client.am.ClientStatement.executeUpdate.

Implements java.sql.Statement.executeUpdate.

Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
public int
executeUpdate(String
an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
sql
,
int[]
an array of column indexes indicating the columns that should be returned from the inserted row
columnIndexes
)

Overrides org.apache.derby.client.am.ClientStatement.executeUpdate.

Implements java.sql.Statement.executeUpdate.

Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
private long
pack-priv boolean
private boolean[]
expandBooleanArray(boolean[] array, int newLength)

private Object[]
expandObjectArray(Object[] array, int newLength)

private void
flowExecute(int executeType)

pack-priv void
private ColumnMetaData
protected String

Returns:

name of java.sql interface
getJdbcStatementInterfaceName
()

Overrides org.apache.derby.client.am.ClientStatement.getJdbcStatementInterfaceName.

Returns the name of the java.sql interface implemented by this class.
public ResultSetMetaData
getMetaData()

Implements java.sql.PreparedStatement.getMetaData.

Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet object that will be returned when this PreparedStatement object is executed.
private ColumnMetaData
public ParameterMetaData
getParameterMetaData()

Implements java.sql.PreparedStatement.getParameterMetaData.

Retrieves the number, types and properties of this PreparedStatement object's parameters.
private ClientParameterMetaData
private void
private void
private void
protected void
public void
protected void
markClosed(boolean
if true the Statement will be removed from the open statements list and PreparedStatement will also be removed from commit and rollback listeners list in org.apache.derby.client.am.Connection.
removeListener
)

Overrides org.apache.derby.client.am.ClientStatement.markClosed.

This method cleans up client-side resources held by this Statement.
pack-priv void
private void
private void
private void
private void
public void
pack-priv void
resetForReuse()

Overrides org.apache.derby.client.am.ClientStatement.resetForReuse.

Resets the prepared statement for reuse in a statement pool.
private void
private void
resetPreparedStatement(Agent agent, ClientConnection connection, String sql, Section section)

public void
resetPreparedStatement(Agent agent, ClientConnection connection, String sql, int type, int concurrency, int holdability, int autoGeneratedKeys, String[] columnNames, int[] columnIndexes)

public void
setArray(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Array
an Array object that maps an SQL ARRAY value
x
)

Implements java.sql.PreparedStatement.setArray.

Sets the designated parameter to the given java.sql.Array object.
public void
setAsciiStream(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
InputStream
the java input stream which contains the ASCII parameter value
x
,
long
the number of bytes in the stream
length
)

Implements java.sql.PreparedStatement.setAsciiStream.

We do this inefficiently and read it all in here.
public void
setAsciiStream(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
InputStream
the java input stream which contains the ASCII parameter value
x
,
int
the number of bytes in the stream
length
)

Implements java.sql.PreparedStatement.setAsciiStream.

We do this inefficiently and read it all in here.
public void
setAsciiStream(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
InputStream
the Java input stream that contains the ASCII parameter value
x
)

Implements java.sql.PreparedStatement.setAsciiStream.

Sets the designated parameter to the given input stream.
public void
setBigDecimal(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
BigDecimal
the parameter value
x
)

Implements java.sql.PreparedStatement.setBigDecimal.

Sets the designated parameter to the given java.math.BigDecimal value.
public void
setBinaryStream(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
InputStream
the java input stream which contains the binary parameter value
x
,
long
the number of bytes in the stream
length
)

Implements java.sql.PreparedStatement.setBinaryStream.

sets the parameter to the Binary Stream object
public void
setBinaryStream(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
InputStream
the java input stream which contains the binary parameter value
x
,
int
the number of bytes in the stream
length
)

Implements java.sql.PreparedStatement.setBinaryStream.

sets the parameter to the Binary Stream object
public void
setBinaryStream(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
InputStream
the java input stream which contains the binary parameter value
x
)

Implements java.sql.PreparedStatement.setBinaryStream.

Sets the designated parameter to the given input stream.
private void
setBinaryStreamX(int parameterIndex, InputStream x, int length)

public void
setBlob(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Blob
a Blob object that maps an SQL BLOB value
x
)

Implements java.sql.PreparedStatement.setBlob.

Sets the designated parameter to the given java.sql.Blob object.
public void
setBlob(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
InputStream
an object that contains the data to set the parameter value to.
inputStream
)

Implements java.sql.PreparedStatement.setBlob.

Sets the designated parameter to a InputStream object.
public void
setBlob(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
InputStream
An object that contains the data to set the parameter value to.
inputStream
,
long
the number of bytes in the parameter data.
length
)

Implements java.sql.PreparedStatement.setBlob.

Sets the designated parameter to a InputStream object.
private void
setBlobX(int parameterIndex, Blob x)

public void
setBoolean(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
boolean
the parameter value
x
)

Implements java.sql.PreparedStatement.setBoolean.

Sets the designated parameter to the given Java boolean value.
public void
setByte(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
byte
the parameter value
x
)

Implements java.sql.PreparedStatement.setByte.

Sets the designated parameter to the given Java byte value.
public void
setBytes(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
byte[]
the parameter value
x
)

Implements java.sql.PreparedStatement.setBytes.

Sets the designated parameter to the given Java array of bytes.
pack-priv void
setBytesX(int parameterIndex, byte[] x)

public void
setCharacterStream(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Reader
the java.io.Reader object that contains the Unicode data
x
)

Implements java.sql.PreparedStatement.setCharacterStream.

Sets the designated parameter to the given Reader object.
public void
setCharacterStream(int
the index of the parameter to which this set method is applied
parameterIndex
,
Reader
the java Reader which contains the UNICODE value
x
,
long
the number of bytes in the stream
length
)

Implements java.sql.PreparedStatement.setCharacterStream.

Sets the designated parameter to the given Reader, which will have the specified number of bytes.
public void
setCharacterStream(int
the index of the parameter to which this set method is applied
parameterIndex
,
Reader
the java Reader which contains the UNICODE value
x
,
int
the number of bytes in the stream
length
)

Implements java.sql.PreparedStatement.setCharacterStream.

Sets the designated parameter to the given Reader, which will have the specified number of bytes.
public void
setClob(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Clob
a Clob object that maps an SQL CLOB value
x
)

Implements java.sql.PreparedStatement.setClob.

Sets the designated parameter to the given java.sql.Clob object.
public void
setClob(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
Reader
an object that contains the data to set the parameter value to.
reader
)

Implements java.sql.PreparedStatement.setClob.

Sets the designated parameter to a Reader object.
public void
setClob(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.PreparedStatement.setClob.

Sets the designated parameter to a Reader object.
private void
setClobX(int parameterIndex, Clob x)

public void
setDate(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Date
the parameter value
x
,
Calendar
the Calendar object the driver will use to construct the date
calendar
)

Implements java.sql.PreparedStatement.setDate.

Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
public void
setDate(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Date
the parameter value
x
)

Implements java.sql.PreparedStatement.setDate.

Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.
public void
setDouble(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
double
the parameter value
x
)

Implements java.sql.PreparedStatement.setDouble.

Sets the designated parameter to the given Java double value.
public void
setFloat(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
float
the parameter value
x
)

Implements java.sql.PreparedStatement.setFloat.

Sets the designated parameter to the given Java float value.
pack-priv void
setInput(int parameterIndex, Object input)

public void
setInt(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
int
the parameter value
x
)

Implements java.sql.PreparedStatement.setInt.

Sets the designated parameter to the given Java int value.
pack-priv void
setIntX(int parameterIndex, int x)

public void
setLong(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
long
the parameter value
x
)

Implements java.sql.PreparedStatement.setLong.

Sets the designated parameter to the given Java long value.
pack-priv void
setLongX(final int parameterIndex, final long x)

public void
setNCharacterStream(int
of the first parameter is 1, the second is 2, ...
parameterIndex
,
Reader
the parameter value
value
)

Implements java.sql.PreparedStatement.setNCharacterStream.

Sets the designated parameter to a Reader object.
public void
setNCharacterStream(int
of the first parameter is 1, the second is 2, ...
index
,
Reader
the parameter value
value
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.PreparedStatement.setNCharacterStream.

Sets the designated parameter to a Reader object.
public void
setNClob(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
)

Implements java.sql.PreparedStatement.setNClob.

Sets the designated parameter to a Reader object.
public void
setNClob(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
Reader
An object that contains the data to set the parameter value to.
reader
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.PreparedStatement.setNClob.

Sets the designated parameter to a Reader object.
public void
setNClob(int
of the first parameter is 1, the second is 2, ...
index
,
NClob
the parameter value
value
)

Implements java.sql.PreparedStatement.setNClob.

Sets the designated parameter to a java.sql.NClob object.
public void
setNString(int
of the first parameter is 1, the second is 2, ...
index
,
String
the parameter value
value
)

Implements java.sql.PreparedStatement.setNString.

Sets the designated parameter to the given String object.
public void
setNull(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
int
the SQL type code defined in java.sql.Types
jdbcType
)

Implements java.sql.PreparedStatement.setNull.

Sets the designated parameter to SQL NULL.
public void
setNull(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
int
a value from java.sql.Types
jdbcType
,
String
the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or REF
typeName
)

Implements java.sql.PreparedStatement.setNull.

Sets the designated parameter to SQL NULL.
pack-priv void
setNullX(int parameterIndex, int jdbcType)

public void
setObject(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Object
the object containing the input parameter value
x
)

Implements java.sql.PreparedStatement.setObject.

Sets the value of the designated parameter using the given object.

public void
setObject(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Object
the object containing the input parameter value
x
,
int
the SQL type (as defined in java.sql.Types) to be sent to the database
targetJdbcType
)

Implements java.sql.PreparedStatement.setObject.

Sets the value of the designated parameter with the given object.
public void
setObject(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Object
the object containing the input parameter value
x
,
int
the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.
targetJdbcType
,
int
for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scale
)

Implements java.sql.PreparedStatement.setObject.

Sets the value of the designated parameter with the given object.

private void
setObjectX(int parameterIndex, Object x, int targetJdbcType, int scale)

public void
setRef(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Ref
an SQL REF value
x
)

Implements java.sql.PreparedStatement.setRef.

Sets the designated parameter to the given REF(<structured-type>) value.
public void
setRowId(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
RowId
the parameter value
x
)

Implements java.sql.PreparedStatement.setRowId.

Sets the designated parameter to the given java.sql.RowId object.
public void
setShort(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
short
the parameter value
x
)

Implements java.sql.PreparedStatement.setShort.

Sets the designated parameter to the given Java short value.
pack-priv void
setShortX(int parameterIndex, short x)

public void
setSQLXML(int
index of the first parameter is 1, the second is 2, ...
parameterIndex
,
SQLXML
a SQLXML object that maps an SQL XML value
xmlObject
)

Implements java.sql.PreparedStatement.setSQLXML.

Sets the designated parameter to the given java.sql.SQLXML object.
public void
setString(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
String
the parameter value
x
)

Implements java.sql.PreparedStatement.setString.

Sets the designated parameter to the given Java String value.
pack-priv void
setStringX(int parameterIndex, String x)

public void
setTime(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Time
the parameter value
x
,
Calendar
the Calendar object the driver will use to construct the time
calendar
)

Implements java.sql.PreparedStatement.setTime.

Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.
public void
setTime(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Time
the parameter value
x
)

Implements java.sql.PreparedStatement.setTime.

Sets the designated parameter to the given java.sql.Time value.
public void
setTimestamp(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Timestamp
the parameter value
x
,
Calendar
the Calendar object the driver will use to construct the timestamp
calendar
)

Implements java.sql.PreparedStatement.setTimestamp.

Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.
public void
setTimestamp(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
Timestamp
the parameter value
x
)

Implements java.sql.PreparedStatement.setTimestamp.

Sets the designated parameter to the given java.sql.Timestamp value.
private void
setUDTX(int parameterIndex, Object x)

Set a UDT parameter to an object value.

public void
setUnicodeStream(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
InputStream
the java input stream which contains the UNICODE parameter value
x
,
int
the number of bytes in the stream
length
)

Implements java.sql.PreparedStatement.setUnicodeStream.

Deprecated
Sets the specified parameter to the given input stream.
public void
setURL(int
the first parameter is 1, the second is 2, ...
parameterIndex
,
URL
the java.net.URL object to be set
x
)

Implements java.sql.PreparedStatement.setURL.

Sets the designated parameter to the given java.net.URL value.
private void
private void
writeExecute(Section section, ColumnMetaData parameterMetaData, Object[] inputs, int numInputColumns, boolean outputExpected, boolean chainedWritesFollowingSetLob)

private void
writeOpenQuery(Section section, int fetchSize, int resultSetType, int numInputColumns, ColumnMetaData parameterMetaData, Object[] inputs)

private void
private void
Inherited from org.apache.derby.client.am.ClientStatement:
accumulateWarningcacheCursorAttributesToSendOnPreparecancelcheckAutoGeneratedKeysParameterscheckForAppropriateSqlModecheckForClosedStatementcheckForDuplicateCursorNamecheckForStoredProcResultSetCountclearBatchclearWarningsclearWarningsXclosecloseMeOnCompletioncloseOnCompletioncloseXcompleteExecutecompleteExecuteCallcompleteExecuteCallcompleteExecuteCallOpenQuerycompleteExecuteImmediatecompleteExecuteSetStatementcompleteOpenQuerycompletePreparecompletePrepareDescribeOutputcompleteSqlcaescapeexecuteLargeBatchexecuteLargeUpdateexecuteLargeUpdateexecuteLargeUpdateexecuteLargeUpdateexecuteXextractCursorNameFromWhereCurrentOffinalizegetConnectiongetConnectionCallbackInterfacegetFetchDirectiongetFetchSizegetGeneratedKeysgetGuessedResultSetMetaDatagetLargeMaxRowsgetLargeUpdateCountgetMaterialStatementgetMaxFieldSizegetMaxRowsgetMoreResultsgetMoreResultsgetOwnergetQueryTimeoutgetResultSetgetResultSetConcurrencygetResultSetHoldabilitygetResultSetTypegetSectiongetSqlWarningsgetUpdateCountgetWarningsisClosedisCloseOnCompletionisPoolableisQueryModeisWrapperFormarkClosedmarkResultSetsClosedparseSqlAndSetSqlModesparseStorProcReturnedScrollableRowsetprepareAutoGeneratedKeysStatementreadClosereadCloseResultSetsreadExecuteCallreadOpenQueryreadPreparereadPrepareDescribeOutputreadSetSpecialRegisterremoveClientCursorNameFromCacheresetCursorNameAndRemoveFromWhereCurrentOfMappingsresetResultSetListresetStatementresetStatementresultSetCommittingresultSetCommittingsetCursorNamesetEscapeProcessingsetFetchDirectionsetFetchedRowBasesetFetchSizesetLargeMaxRowssetMaterialStatementsetMaxFieldSizesetMaxRowssetOwnersetPoolablesetQueryTimeoutsetSectionsetupCursorNameCacheAndMappingssetUpdateCountsubstituteClientCursorNameWithServerCursorNameunwrapwriteClosewriteCloseResultSetswriteExecuteCallwriteOpenQuerywritePreparewritePrepareDescribeOutputwriteSetSpecialRegister