Apache Derby Client JDBC Driver 10.17.1.0 · org.apache.derby.client.am.LogicalPreparedStatement

Access	Constructor and Description
public	LogicalPreparedStatement(PreparedStatement underlying physical statement physicalPs, StatementKey key for the physical statement stmtKey, StatementCacheInteractor creating statement cache interactor cacheInteractor) Creates a new logical prepared statement.

Method Summary

Modifier and Type	Method and Description
public void	addBatch() Implements java.sql.PreparedStatement.addBatch. Adds a set of parameters to this `PreparedStatement` object's batch of commands.
public void	addBatch(String typically this is a SQL `INSERT` or `UPDATE` statement sql) Implements java.sql.Statement.addBatch. Adds the given SQL command to the current list of commands for this `Statement` object.
public void	cancel() Implements java.sql.Statement.cancel. Cancels this `Statement` object if both the DBMS and driver support aborting an SQL statement.
public void	clearBatch() Implements java.sql.Statement.clearBatch. Empties this `Statement` object's current list of SQL commands.
public void	clearParameters() Implements java.sql.PreparedStatement.clearParameters. Clears the current parameter values immediately.
public void	clearWarnings() Implements java.sql.Statement.clearWarnings. Clears all the warnings reported on this `Statement` object.
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) Implements java.sql.Statement.execute. Executes the given SQL statement, which may return multiple results.
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) 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, 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) 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, 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) 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() 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.
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() Implements java.sql.PreparedStatement.executeQuery. Executes the SQL query in this `PreparedStatement` object and returns the `ResultSet` object generated by the query.
public ResultSet	executeQuery(String an SQL statement to be sent to the database, typically a static SQL `SELECT` statement sql) Implements java.sql.Statement.executeQuery. Executes the given SQL statement, which returns a single `ResultSet` object.
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) 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(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) 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, int[] an array of column indexes indicating the columns that should be returned from the inserted row columnIndexes) 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, String[] an array of the names of the columns that should be returned from the inserted row columnNames) 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 Connection	getConnection() Implements java.sql.Statement.getConnection. Retrieves the `Connection` object that produced this `Statement` object.
public int	getFetchDirection() Implements java.sql.Statement.getFetchDirection. Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this `Statement` object.
public int	getFetchSize() Implements java.sql.Statement.getFetchSize. Retrieves the number of result set rows that is the default fetch size for `ResultSet` objects generated from this `Statement` object.
public ResultSet	getGeneratedKeys() Implements java.sql.Statement.getGeneratedKeys. Retrieves any auto-generated keys created as a result of executing this `Statement` object.
public int	getMaxFieldSize() Implements java.sql.Statement.getMaxFieldSize. Retrieves the maximum number of bytes that can be returned for character and binary column values in a `ResultSet` object produced by this `Statement` object.
public int	getMaxRows() Implements java.sql.Statement.getMaxRows. Retrieves the maximum number of rows that a `ResultSet` object produced by this `Statement` object can contain.
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.
public boolean	getMoreResults() Implements java.sql.Statement.getMoreResults. Moves to this `Statement` object's next result, returns `true` if it is a `ResultSet` object, and implicitly closes any current `ResultSet` object(s) obtained with the method `getResultSet`.
public boolean	getMoreResults(int one of the following `Statement` constants indicating what should happen to current `ResultSet` objects obtained using the method `getResultSet`: `Statement.CLOSE_CURRENT_RESULT`, `Statement.KEEP_CURRENT_RESULT`, or `Statement.CLOSE_ALL_RESULTS` current) Implements java.sql.Statement.getMoreResults. Moves to this `Statement` object's next result, deals with any current `ResultSet` object(s) according to the instructions specified by the given flag, and returns `true` if the next result is a `ResultSet` object.
public ParameterMetaData	getParameterMetaData() Implements java.sql.PreparedStatement.getParameterMetaData. Retrieves the number, types and properties of this `PreparedStatement` object's parameters.
public int	getQueryTimeout() Implements java.sql.Statement.getQueryTimeout. Retrieves the number of seconds the driver will wait for a `Statement` object to execute.
public ResultSet	getResultSet() Implements java.sql.Statement.getResultSet. Retrieves the current result as a `ResultSet` object.
public int	getResultSetConcurrency() Implements java.sql.Statement.getResultSetConcurrency. Retrieves the result set concurrency for `ResultSet` objects generated by this `Statement` object.
public int	getResultSetHoldability() Implements java.sql.Statement.getResultSetHoldability. Retrieves the result set holdability for `ResultSet` objects generated by this `Statement` object.
public int	getResultSetType() Implements java.sql.Statement.getResultSetType. Retrieves the result set type for `ResultSet` objects generated by this `Statement` object.
public int	getUpdateCount() Implements java.sql.Statement.getUpdateCount. Retrieves the current result as an update count; if the result is a `ResultSet` object or there are no more results, -1 is returned.
public SQLWarning	getWarnings() Implements java.sql.Statement.getWarnings. Retrieves the first warning reported by calls on this `Statement` object.
public synchronized boolean	isClosed() Implements java.sql.Statement.isClosed. Retrieves whether this `Statement` object has been closed.
public boolean	isPoolable() Implements java.sql.Statement.isPoolable. Returns a value indicating whether the `Statement` is poolable or not.
public void	setArray(int the first parameter is 1, the second is 2, ... i, 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 that contains the ASCII parameter value x, int the number of bytes in the stream length) Implements java.sql.PreparedStatement.setAsciiStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setAsciiStream(int the first parameter is 1, the second is 2, ... arg0, InputStream the Java input stream that contains the ASCII parameter value arg1, long the number of bytes in the stream arg2) Implements java.sql.PreparedStatement.setAsciiStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setAsciiStream(int the first parameter is 1, the second is 2, ... arg0, InputStream the Java input stream that contains the ASCII parameter value arg1) 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, int the number of bytes in the stream length) Implements java.sql.PreparedStatement.setBinaryStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setBinaryStream(int the first parameter is 1, the second is 2, ... arg0, InputStream the java input stream which contains the binary parameter value arg1, long the number of bytes in the stream arg2) Implements java.sql.PreparedStatement.setBinaryStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setBinaryStream(int the first parameter is 1, the second is 2, ... arg0, InputStream the java input stream which contains the binary parameter value arg1) Implements java.sql.PreparedStatement.setBinaryStream. Sets the designated parameter to the given input stream.
public void	setBlob(int the first parameter is 1, the second is 2, ... i, 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, ... arg0, InputStream An object that contains the data to set the parameter value to. arg1, long the number of bytes in the parameter data. arg2) 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, ... arg0, InputStream An object that contains the data to set the parameter value to. arg1) Implements java.sql.PreparedStatement.setBlob. Sets the designated parameter to a `InputStream` object.
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.
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 reader, int the number of characters in the stream length) Implements java.sql.PreparedStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
public void	setCharacterStream(int the first parameter is 1, the second is 2, ... arg0, Reader the `java.io.Reader` object that contains the Unicode data arg1, long the number of characters in the stream arg2) Implements java.sql.PreparedStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
public void	setCharacterStream(int the first parameter is 1, the second is 2, ... arg0, Reader the `java.io.Reader` object that contains the Unicode data arg1) Implements java.sql.PreparedStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object.
public void	setClob(int the first parameter is 1, the second is 2, ... i, 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, ... arg0, Reader An object that contains the data to set the parameter value to. arg1, long the number of characters in the parameter data. arg2) 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, ... arg0, Reader An object that contains the data to set the parameter value to. arg1) Implements java.sql.PreparedStatement.setClob. Sets the designated parameter to a `Reader` object.
public void	setCursorName(String the new cursor name, which must be unique within a connection name) Implements java.sql.Statement.setCursorName. Sets the SQL cursor name to the given `String`, which will be used by subsequent `Statement` object `execute` methods.
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	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 cal) Implements java.sql.PreparedStatement.setDate. Sets the designated parameter to the given `java.sql.Date` value, using the given `Calendar` object.
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	setEscapeProcessing(boolean `true` to enable escape processing; `false` to disable it enable) Implements java.sql.Statement.setEscapeProcessing. Sets escape processing on or off.
public void	setFetchDirection(int the initial direction for processing rows direction) Implements java.sql.Statement.setFetchDirection. Gives the driver a hint as to the direction in which rows will be processed in `ResultSet` objects created using this `Statement` object.
public void	setFetchSize(int the number of rows to fetch rows) Implements java.sql.Statement.setFetchSize. Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for `ResultSet` objects generated by this `Statement`.
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.
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.
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.
public void	setMaxFieldSize(int the new column size limit in bytes; zero means there is no limit max) Implements java.sql.Statement.setMaxFieldSize. Sets the limit for the maximum number of bytes that can be returned for character and binary column values in a `ResultSet` object produced by this `Statement` object.
public void	setMaxRows(int the new max rows limit; zero means there is no limit max) Implements java.sql.Statement.setMaxRows. Sets the limit for the maximum number of rows that any `ResultSet` object generated by this `Statement` object can contain to the given number.
public void	setNCharacterStream(int of the first parameter is 1, the second is 2, ... arg0, Reader the parameter value arg1, long the number of characters in the parameter data. arg2) 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, ... arg0, Reader the parameter value arg1) Implements java.sql.PreparedStatement.setNCharacterStream. Sets the designated parameter to a `Reader` object.
public void	setNClob(int of the first parameter is 1, the second is 2, ... arg0, NClob the parameter value arg1) Implements java.sql.PreparedStatement.setNClob. Sets the designated parameter to a `java.sql.NClob` object.
public void	setNClob(int index of the first parameter is 1, the second is 2, ... arg0, Reader An object that contains the data to set the parameter value to. arg1, long the number of characters in the parameter data. arg2) 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, ... arg0, Reader An object that contains the data to set the parameter value to. arg1) Implements java.sql.PreparedStatement.setNClob. Sets the designated parameter to a `Reader` object.
public void	setNString(int of the first parameter is 1, the second is 2, ... arg0, String the parameter value arg1) 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` sqlType) 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, ... paramIndex, int a value from `java.sql.Types` sqlType, 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`.
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 targetSqlType) 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. targetSqlType, 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.
public void	setPoolable(boolean requests that the statement be pooled if true and that the statement not be pooled if false arg0) Implements java.sql.Statement.setPoolable. Requests that a `Statement` be pooled or not pooled.
public void	setQueryTimeout(int the new query timeout limit in seconds; zero means there is no limit seconds) Implements java.sql.Statement.setQueryTimeout. Sets the number of seconds the driver will wait for a `Statement` object to execute to the given number of seconds.
public void	setRef(int the first parameter is 1, the second is 2, ... i, 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, ... arg0, RowId the parameter value arg1) 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.
public void	setSQLXML(int index of the first parameter is 1, the second is 2, ... arg0, SQLXML a `SQLXML` object that maps an SQL `XML` value arg1) 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.
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	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 cal) Implements java.sql.PreparedStatement.setTime. Sets the designated parameter to the given `java.sql.Time` 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.
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 cal) Implements java.sql.PreparedStatement.setTimestamp. Sets the designated parameter to the given `java.sql.Timestamp` value, using the given `Calendar` object.
public void	setUnicodeStream(int the first parameter is 1, the second is 2, ... parameterIndex, InputStream a `java.io.InputStream` object that contains the Unicode parameter value x, int the number of bytes in the stream length) Implements java.sql.PreparedStatement.setUnicodeStream. Deprecated Sets the designated parameter to the given input stream, which will have the specified number of bytes.
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.

Inherited from org.apache.derby.client.am.LogicalStatementEntity:: close closeOnCompletion executeLargeBatch executeLargeUpdate executeLargeUpdate executeLargeUpdate executeLargeUpdate getLargeMaxRows getLargeUpdateCount getPhysCs getPhysPs isCloseOnCompletion isLogicalEntityClosed isWrapperFor setLargeMaxRows unwrap

public Class LogicalPreparedStatement

Constructor Summary

Method Summary