org.apache.derby.impl.jdbc
Class EmbedPreparedStatement20

java.lang.Object
  org.apache.derby.impl.jdbc.ConnectionChild
      org.apache.derby.impl.jdbc.EmbedStatement
          org.apache.derby.impl.jdbc.EmbedPreparedStatement
              org.apache.derby.impl.jdbc.EmbedPreparedStatement20

All Implemented Interfaces:

java.sql.PreparedStatement, java.sql.Statement

Direct Known Subclasses:

EmbedPreparedStatement30

public class EmbedPreparedStatement20

extends EmbedPreparedStatement

This class extends the EmbedPreparedStatement class in order to support new methods and classes that come with JDBC 2.0.

Supports

• JDBC 2.0

Author:

francois

See Also:

EmbedPreparedStatement

Field Summary

Fields inherited from class org.apache.derby.impl.jdbc.EmbedPreparedStatement

preparedStatement, rMetaData

Fields inherited from class org.apache.derby.impl.jdbc.EmbedStatement

active, batchStatements, CLOSE, cursorName, factory, forMetaData, lcc, localConn, MaxFieldSize, maxRows, NOCLOSE, results, resultSetConcurrency, resultSetHoldability, resultSetType, SQLText, 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

EmbedPreparedStatement20(EmbedConnection conn, java.lang.String sql, boolean forMetaData, int resultSetType, int resultSetConcurrency, int resultSetHoldability, int autoGeneratedKeys, int[] columnIndexes, java.lang.String[] columnNames)

Method Summary

java.sql.ParameterMetaData	getParameterMetaData() JDBC 3.0
void	setArray(int i, java.sql.Array x) JDBC 2.0 Set an Array parameter.
void	setBigDecimal(int parameterIndex, java.math.BigDecimal x) Set a parameter to a java.lang.BigDecimal value.
(package private) boolean	setObjectConvert(int parameterIndex, java.lang.Object x) Allow explict setObject conversions by sub-classes for classes not supported by this variant.
void	setRef(int i, java.sql.Ref x) JDBC 2.0 Set a REF(<structured-type>) parameter.

Methods inherited from class org.apache.derby.impl.jdbc.EmbedPreparedStatement

addBatch, addBatch, clearParameters, closeActions, dataTypeConversion, execute, execute, execute, execute, execute, executeBatchElement, executeQuery, executeQuery, executeStatement, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, finalize, getEmbedParameterSetMetaData, getMetaData, getParameterJDBCType, getParms, getTypes, newEmbedResultSetMetaData, setAsciiStream, setBinaryStream, setBinaryStreamInternal, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStreamInternal, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, toString, transferParameters

Methods inherited from class org.apache.derby.impl.jdbc.EmbedStatement

cancel, checkExecStatus, checkIfInMiddleOfBatch, checkRequiresCallableStatement, checkStatus, clearBatch, clearResultSets, clearWarnings, close, commitIfAutoCommit, commitIfNeeded, execute, executeBatch, getCal, getConnection, getConnectionSynchronization, getContextManager, getDatabase, getEmbedConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getParameterValueSet, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSQLText, getUpdateCount, getWarnings, getWarnings, handleException, handleException, needCommit, newSQLException, newSQLException, newSQLException, restoreContextStack, resultSetClosing, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, setupContextStack, transferBatch

Methods inherited from class java.lang.Object

clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.sql.Statement

cancel, clearBatch, clearWarnings, close, executeBatch, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout

Constructor Detail

EmbedPreparedStatement20

public EmbedPreparedStatement20(EmbedConnection conn,
                                java.lang.String sql,
                                boolean forMetaData,
                                int resultSetType,
                                int resultSetConcurrency,
                                int resultSetHoldability,
                                int autoGeneratedKeys,
                                int[] columnIndexes,
                                java.lang.String[] columnNames)
                         throws java.sql.SQLException

Method Detail

setRef

public void setRef(int i,
                   java.sql.Ref x)
            throws java.sql.SQLException

JDBC 2.0 Set a REF(<structured-type>) parameter.

Parameters:

i - the first parameter is 1, the second is 2, ...

x - an object representing data of an SQL REF Type

Throws:

java.sql.SQLException - Feature not implemented for now.

setArray

public void setArray(int i,
                     java.sql.Array x)
              throws java.sql.SQLException

JDBC 2.0 Set an Array parameter.

Parameters:

i - the first parameter is 1, the second is 2, ...

x - an object representing an SQL array

Throws:

java.sql.SQLException - Feature not implemented for now.

setBigDecimal

public final void setBigDecimal(int parameterIndex,
                                java.math.BigDecimal x)
                         throws java.sql.SQLException

Set a parameter to a java.lang.BigDecimal value. The driver converts this to a SQL NUMERIC value when it sends it to the database.

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown on failure.

setObjectConvert

boolean setObjectConvert(int parameterIndex,
                         java.lang.Object x)
                   throws java.sql.SQLException

Allow explict setObject conversions by sub-classes for classes not supported by this variant. In this case handle BigDecimal.

Overrides:

setObjectConvert in class EmbedPreparedStatement

Returns:

true if the object was set successfully, false if no valid conversion exists.

Throws:

java.sql.SQLException - value could not be set.

getParameterMetaData

public java.sql.ParameterMetaData getParameterMetaData()
                                                throws java.sql.SQLException

JDBC 3.0

Throws:

java.sql.SQLException