Module org.tquadrat.foundation.sql
Package org.tquadrat.foundation.sql.internal

Class EnhancedPreparedStatementBase

java.lang.Object
org.tquadrat.foundation.sql.internal.EnhancedPreparedStatementBase
All Implemented Interfaces:
AutoCloseable, EnhancedPreparedStatement
Direct Known Subclasses:
EnhancedPreparedStatementImpl
@ClassVersion(sourceVersion="$Id: EnhancedPreparedStatementBase.java 1100 2024-02-16 23:33:45Z tquadrat $") @API(status=STABLE, since="0.1.0") public abstract sealed class EnhancedPreparedStatementBase extends Object implements EnhancedPreparedStatement permits EnhancedPreparedStatementImpl
The base class for implementations of EnhancedPreparedStatement.
Author:
Thomas Thrien (thomas.thrien@tquadrat.org)
Version:
$Id: EnhancedPreparedStatementBase.java 1100 2024-02-16 23:33:45Z tquadrat $
Since:
0.1.0
UML Diagram
UML Diagram for "org.tquadrat.foundation.sql.internal.EnhancedPreparedStatementBase"⁠

UML Diagram for "org.tquadrat.foundation.sql.internal.EnhancedPreparedStatementBase"

UML Diagram for "org.tquadrat.foundation.sql.internal.EnhancedPreparedStatementBase"⁠

  • Nested Class Summary

    Nested Classes
    Modifier and Type
    Class
    Description
    protected final class 
    EnhancedPreparedStatementBase.ParameterMetaDataImpl
    The base class for a variant of ParameterMetaData that is used by EnhancedPreparedStatement.

    Nested classes/interfaces inherited from interface org.tquadrat.foundation.sql.EnhancedPreparedStatement

    EnhancedPreparedStatement.StatementLogger

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    private int
    m_BatchCounter
    The counter for the added batch commands.
    private final Map<String,int[]>
    m_ParameterIndex
    The parameter index.
    private final PreparedStatement
    m_PreparedStatement
    The wrapped PreparedStatement.
    private final String
    m_SourceStatement
    The statement source.
    private final LazyMap<String,StatementValue>
    m_Values
    The values.

    Fields inherited from interface org.tquadrat.foundation.sql.EnhancedPreparedStatement

    VARIABLE_PATTERN

  • Constructor Summary

    Constructors
    Modifier
    Constructor
    Description
    protected
    EnhancedPreparedStatementBase(String sourceStatement, PreparedStatement preparedStatement, Map<String,int[]> parameterIndex)
    Creates a new instance of EnhancedPreparedStatementBase.

  • Method Summary

    Modifier and Type
    Method
    Description
    final void
    addBatch()
    Adds a set of parameters to this EnhancedPreparedStatement instance's batch of commands.
    protected abstract boolean
    addStacktrace()
    Returns a flag that indicates whether a stacktrace should be added to the logging.
    final void
    cancel()
    Cancels this EnhancedPreparedStatement object if both the DBMS and driver support aborting an SQL statement.
    final void
    clearBatch()
    Empties this EnhancedPreparedStatement instance's current list of SQL commands.
    void
    clearParameters()
    Clears the current parameter values immediately.
    final void
    clearWarnings()
    Clears all the warnings reported on this EnhancedPreparedStatement instance.
    final void
    close()
    Releases this instance's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
    final void
    closeOnCompletion()
    Specifies that this EnhancedPreparedStatement will be closed when all its dependent result sets are closed.
    protected abstract void
    doLogging(String operation, StackTraceElement[] stackTrace)
    Composes the log information and sends it.
    final String
    enquoteIdentifier(String identifier, boolean alwaysQuote)
    Returns a SQL identifier.
    final String
    enquoteLiteral(String value)
    Returns a String enclosed in single quotes.
    final String
    enquoteNCharLiteral(String s)
    Returns a String representing a National Character Set Literal enclosed in single quotes and prefixed with a upper case letter N.
    final boolean
    execute()
    Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.
    final int[]
    executeBatch()
    Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
    long[]
    executeLargeBatch()
    Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
    final long
    executeLargeUpdate()
    Executes the SQL statement in this EnhancedPreparedStatement instance.
    final ResultSet
    executeQuery()
    Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.
    final int
    executeUpdate()
    Executes the SQL statement in this EnhancedPreparedStatement instance.
    final Connection
    getConnection()
    Retrieves the Connection instance that produced the PreparedStatement instance wrapped by this EnhancedPreparedStatement.
    protected final Collection<StatementValue>
    getCurrentValues()
    Provides the current values for logging purposes.
    final int
    getFetchDirection()
    Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this EnhancedPreparedStatement instance.
    final int
    getFetchSize()
    Retrieves the number of result set rows that is the default fetch size for ResultSet instances generated from this EnhancedPreparedStatement instance.
    final ResultSet
    getGeneratedKeys()
    Retrieves any auto-generated keys created as a result of executing this EnhancedPreparedStatement instance.
    final long
    getLargeMaxRows()
    Retrieves the maximum number of rows that a ResultSet instance produced by this EnhancedPreparedStatement instance can contain.
    final long
    getLargeUpdateCount()
    Retrieves the current result as an update count.
    final int
    getMaxFieldSize()
    Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this EnhancedPreparedStatement object.
    final int
    getMaxRows()
    Retrieves the maximum number of rows that a ResultSet instance produced by this EnhancedPreparedStatement instance can contain.
    final ResultSetMetaData
    getMetaData()
    Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet instance that will be returned when this EnhancedPreparedStatement instance is executed.
    final boolean
    getMoreResults()
    Moves to this EnhancedPreparedStatement instance's next result, returns true if it is a ResultSet instance, and implicitly closes any current ResultSet instance(s) previously obtained with the method EnhancedPreparedStatement.getResultSet().
    final boolean
    getMoreResults(int current)
    Moves to this EnhancedPreparedStatement instance's next result, deals with any current ResultSet instance(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object.
    protected final int[]
    getParameterIndexes(String parameterName)
    Returns the parameter indexes for the given parameter name.
    ParameterMetaData
    getParameterMetaData()
    Retrieves the number, types and properties of this EnhancedPreparedStatement instance's parameters.
    protected final Collection<String>
    getParameterNames()
    Returns the parameter names for this EnhancedPreparedStatement.
    final int
    getQueryTimeout()
    Retrieves the number of seconds the driver will wait for a Statement instance to execute.
    final ResultSet
    getResultSet()
    Retrieves the current result as a ResultSet instance.
    final int
    getResultSetConcurrency()
    Retrieves the result set concurrency for ResultSet instances generated by this EnhancedPreparedStatement instance.
    final int
    getResultSetHoldability()
    Retrieves the result set holdability for ResultSet instances generated by this EnhancedPreparedStatement instance.
    final int
    getResultSetType()
    Retrieves the result set type for ResultSet instances generated by this EnhancedPreparedStatement instance.
    protected final String
    getSourceStatement()
    Provides the source statement for logging purposes.
    final int
    getUpdateCount()
    Retrieves the current result as an update count.
    final SQLWarning
    getWarnings()
    Retrieves the first warning reported by calls on this EnhancedPreparedStatement instance.
    final boolean
    isClosed()
    Retrieves whether this EnhancedPreparedStatement object has been closed.
    final boolean
    isCloseOnCompletion()
    Returns a value indicating whether this EnhancedPreparedStatement will be closed when all its dependent result sets are closed.
    abstract boolean
    isLoggingEnabled()
    Checks whether logging is currently enabled.
    final boolean
    isPoolable()
    Returns a value indicating whether the wrapped PreparedStatement is poolable or not.
    final boolean
    isSimpleIdentifier(String identifier)
    Retrieves whether identifier is a simple SQL identifier.
    final void
    setArray(String parameterName, Array value)
    Sets the designated parameter to the given Array instance.
    void
    setAsciiStream(String parameterName, InputStream value)
    Sets the designated parameter to the given InputStream.
    void
    setAsciiStream(String parameterName, InputStream value, int length)
    Sets the designated parameter to the given InputStream which will have the specified number of bytes.
    void
    setAsciiStream(String parameterName, InputStream value, long length)
    Sets the designated parameter to the given InputStream which will have the specified number of bytes.
    final void
    setBigDecimal(String parameterName, BigDecimal value)
    Sets the designated parameter to the given Java BigDecimal value.
    void
    setBinaryStream(String parameterName, InputStream value)
    Sets the designated parameter to the given InputStream.
    void
    setBinaryStream(String parameterName, InputStream value, int length)
    Sets the designated parameter to the given InputStream which will have the specified number of bytes.
    void
    setBinaryStream(String parameterName, InputStream value, long length)
    Sets the designated parameter to the given InputStream which will have the specified number of bytes.
    final void
    setBlob(String parameterName, InputStream value)
    Sets the designated parameter to a InputStream object.
    final void
    setBlob(String parameterName, InputStream value, long length)
    Sets the designated parameter to a InputStream object.
    final void
    setBlob(String parameterName, Blob value)
    Sets the designated parameter to the given Java Blob instance.
    final void
    setBoolean(String parameterName, boolean value)
    Sets the designated parameter to the given Java boolean value.
    final void
    setByte(String parameterName, byte value)
    Sets the designated parameter to the given Java byte value.
    final void
    setBytes(String parameterName, byte[] value)
    Sets the designated parameter to the given Java array of bytes.
    final void
    setCharacterStream(String parameterName, Reader value)
    Sets the designated parameter to the given Reader instance.
    final void
    setCharacterStream(String parameterName, Reader value, int length)
    Sets the designated parameter to the given Reader instance, which provides the given number of characters.
    final void
    setCharacterStream(String parameterName, Reader value, long length)
    Sets the designated parameter to the given Reader instance, which provides the given number of characters.
    final void
    setClob(String parameterName, Reader value)
    Sets the designated parameter to a Reader instance.
    final void
    setClob(String parameterName, Reader value, long length)
    Sets the designated parameter to a Reader instance.
    final void
    setClob(String parameterName, Clob value)
    Sets the designated parameter to the given Clob instance.
    final void
    setCursorName(String name)
    Sets the SQL cursor name to the given String, which will be used by subsequent statement execute() methods.
    final void
    setDate(String parameterName, Date value)
    Sets the designated parameter to the given Date value using the default time zone of the virtual machine that is running the application.
    void
    setDate(String parameterName, Date value, Calendar calendar)
    Sets the designated parameter to the given Date value using the given Calendar instance.
    final void
    setDouble(String parameterName, double value)
    Sets the designated parameter to the given Java double value.
    final void
    setFetchDirection(int direction)
    Gives the driver a hint as to the direction in which rows will be processed in ResultSet instances created using this EnhancedPreparedStatement object.
    final void
    setFetchSize(int rows)
    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 instances generated by this EnhancedPreparedStatement instance.
    final void
    setFloat(String parameterName, float value)
    Sets the designated parameter to the given Java float value.
    final void
    setInt(String parameterName, int value)
    Sets the designated parameter to the given Java int value.
    final void
    setLargeMaxRows(long max)
    Sets the limit for the maximum number of rows that any ResultSet instance generated by this EnhancedPreparedStatement instance can contain.
    final void
    setLong(String parameterName, long value)
    Sets the designated parameter to the given Java long value.
    final void
    setMaxFieldSize(int max)
    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.
    final void
    setMaxRows(int max)
    Sets the limit for the maximum number of rows, that any ResultSet instance generated by this EnhancedPreparedStatement instance can contain, to the given number.
    final void
    setNCharacterStream(String parameterName, Reader value)
    Sets the designated parameter to the given Reader instance.
    final void
    setNCharacterStream(String parameterName, Reader value, long length)
    Sets the designated parameter to the given Reader instance.
    final void
    setNClob(String parameterName, Reader value)
    Sets the designated parameter to a Reader instance.
    final void
    setNClob(String parameterName, Reader value, long length)
    Sets the designated parameter to a Reader instance.
    final void
    setNClob(String parameterName, NClob value)
    Sets the designated parameter to the given NClob value.
    final void
    setNString(String parameterName, String value)
    Sets the designated parameter to the given Java String value.
    final void
    setNull(String parameterName, SQLType sqlType)
    Sets the designated parameter to SQL NULL.
    void
    setNull(String parameterName, SQLType sqlType, String typeName)
    Sets the designated parameter to SQL NULL.
    final void
    setObject(String parameterName, Object value)
    Sets the value of the designated parameter using the given object.
    void
    setObject(String parameterName, Object value, SQLType targetSqlType)
    Sets the value of the designated parameter with the given object.
    final void
    setObject(String parameterName, Object value, SQLType targetSqlType, int scaleOrLength)
    Sets the value of the designated parameter using the given object.
    final void
    setQueryTimeout(int timeout)
    Sets the number of seconds the driver will wait for a Statement instance to execute to the given number of seconds.
    final void
    setRef(String parameterName, Ref value)
    Sets the designated parameter to the given REF(<structured-type>) value.
    final void
    setRowId(String parameterName, RowId value)
    Sets the designated parameter to the given RowId instance.
    final void
    setShort(String parameterName, short value)
    Sets the designated parameter to the given Java short value.
    final void
    setSQLXML(String parameterName, SQLXML value)
    Sets the designated parameter to the given SQLXML value.
    final void
    setString(String parameterName, String value)
    Sets the designated parameter to the given Java String value.
    final void
    setTime(String parameterName, Time value)
    Sets the designated parameter to the given Time value.
    final void
    setTime(String parameterName, Time value, Calendar calendar)
    Sets the designated parameter to the given Time value using the given Calendar instance.
    final void
    setTimestamp(String parameterName, Timestamp value)
    Sets the designated parameter to the given Timestamp value.
    final void
    setTimestamp(String parameterName, Timestamp value, Calendar calendar)
    Sets the designated parameter to the given Timestamp value using the given Calendar instance.
    final void
    setURL(String parameterName, URL value)
    Sets the designated parameter to the given URL value.

    Methods inherited from class java.lang.Object

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

  • Field Details

  • Constructor Details

    • EnhancedPreparedStatementBase

      protected EnhancedPreparedStatementBase(String sourceStatement, PreparedStatement preparedStatement, Map<String,int[]> parameterIndex)
      Creates a new instance of EnhancedPreparedStatementBase.
      Parameters:
      sourceStatement - The original SQL statement with the placeholders; mainly used for logging purposes.
      preparedStatement - The wrapped instance of PreparedStatement.
      parameterIndex - The mapping for the named placeholders to the position based placeholders.

  • Method Details

    • addBatch

      public final void addBatch() throws SQLException
      Adds a set of parameters to this EnhancedPreparedStatement instance's batch of commands.
      Specified by:
      addBatch in interface EnhancedPreparedStatement
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • addStacktrace

      protected abstract boolean addStacktrace()
      Returns a flag that indicates whether a stacktrace should be added to the logging.
      Returns:
      true if the stacktrace should be created and added, false otherwise.

    • cancel

      public final void cancel() throws SQLException

      Cancels this EnhancedPreparedStatement object if both the DBMS and driver support aborting an SQL statement.

      This method can be used by one thread to cancel a statement that is being executed by another thread.

      Specified by:
      cancel in interface EnhancedPreparedStatement
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • clearBatch

      public final void clearBatch() throws SQLException
      Empties this EnhancedPreparedStatement instance's current list of SQL commands.
      Specified by:
      clearBatch in interface EnhancedPreparedStatement
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement, or the driver does not support batch updates.
      See Also:

    • clearParameters

      public void clearParameters() throws SQLException

      Clears the current parameter values immediately.

      In general, parameter values remain in force for repeated use of a statement. Setting a parameter value automatically clears its previous value. However, in some cases it is useful to immediately release the resources used by the current parameter values; this can be done by calling the method clearParameters().

      Specified by:
      clearParameters in interface EnhancedPreparedStatement
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • clearWarnings

      public final void clearWarnings() throws SQLException

      Clears all the warnings reported on this EnhancedPreparedStatement instance. After a call to this method, the method EnhancedPreparedStatement.getWarnings() will return null until a new warning is reported for this EnhancedPreparedStatement instance.

      Specified by:
      clearWarnings in interface EnhancedPreparedStatement
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • close

      public final void close() throws SQLException

      Releases this instance's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. It is generally good practice to release resources as soon as you are finished with them to avoid tying up database resources.

      Calling the method close on a EnhancedPreparedStatement object that is already closed has no effect.

      Specified by:
      close in interface AutoCloseable
      Specified by:
      close in interface EnhancedPreparedStatement
      Throws:
      SQLException - A database access error occurred.

    • closeOnCompletion

      public final void closeOnCompletion() throws SQLException
      Description copied from interface: EnhancedPreparedStatement

      Specifies that this EnhancedPreparedStatement will be closed when all its dependent result sets are closed. If the execution of the EnhancedPreparedStatement does not produce any result sets, this method has no effect.

      Specified by:
      closeOnCompletion in interface EnhancedPreparedStatement
      Throws:
      SQLException - This method was called on a closed EnhancedPreparedStatement.

    • doLogging

      protected abstract void doLogging(String operation, StackTraceElement[] stackTrace)
      Composes the log information and sends it.
      Parameters:
      operation - The operation that logs.
      stackTrace - The stack trace; can be null.

    • enquoteIdentifier

      public final String enquoteIdentifier(String identifier, boolean alwaysQuote) throws SQLException

      Returns a SQL identifier. If identifier is a simple SQL identifier:

      • Return the original value if alwaysQuote is false
      • Return a delimited identifier if alwaysQuote is true

      If identifier is not a simple SQL identifier, identifier will be enclosed in double quotes if not already present. If the datasource does not support double quotes for delimited identifiers, the identifier should be enclosed by the string returned from DatabaseMetaData.getIdentifierQuoteString(). If the datasource does not support delimited identifiers, a SQLFeatureNotSupportedException should be thrown.

      A SQLException will be thrown if identifier contains any characters invalid in a delimited identifier or the identifier length is invalid for the datasource.

      Specified by:
      enquoteIdentifier in interface EnhancedPreparedStatement
      Parameters:
      identifier - An SQL identifier.
      alwaysQuote - Indicates if a simple SQL identifier should be returned as a quoted identifier.
      Returns:
      A simple SQL identifier or a delimited identifier
      Throws:
      SQLException - The identifier was not a valid identifier.

    • enquoteLiteral

      public final String enquoteLiteral(String value) throws SQLException

      Returns a String enclosed in single quotes. Any occurrence of a single quote within the string will be replaced by two single quotes.

      Examples of the conversion:
      Value Result
      Hello 'Hello'
      G'Day 'G''Day'
      'G''Day' '''G''''Day'''
      I'''M 'I''''''M'
      Specified by:
      enquoteLiteral in interface EnhancedPreparedStatement
      Parameters:
      value - A character String.
      Returns:
      A string enclosed by single quotes with every single quote converted to two single quotes
      Throws:
      SQLException - A database access error occurred.

    • enquoteNCharLiteral

      public final String enquoteNCharLiteral(String s) throws SQLException

      Returns a String representing a National Character Set Literal enclosed in single quotes and prefixed with a upper case letter N. Any occurrence of a single quote within the string will be replaced by two single quotes.

      Examples of the conversion:
      Value Result
      Hello N'Hello'
      G'Day N'G''Day'
      'G''Day' N'''G''''Day'''
      I'''M N'I''''''M'
      N'Hello' N'N''Hello'''
      Specified by:
      enquoteNCharLiteral in interface EnhancedPreparedStatement
      Parameters:
      s - A character string
      Returns:
      The result of replacing every single quote character in the argument by two single quote characters where this entire result is then prefixed with 'N'.
      Throws:
      SQLException - A database access error occurred.
      See Also:

    • execute

      public final boolean execute() throws SQLException

      Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.

      Some prepared statements return multiple results; the execute() method handles these complex statements as well as the simpler form of statements handled by the methods EnhancedPreparedStatement.executeQuery() and EnhancedPreparedStatement.executeUpdate().

      The execute() method returns a boolean to indicate the form of the first result. You must call either the method EnhancedPreparedStatement.getResultSet() or EnhancedPreparedStatement.getUpdateCount() to retrieve the result; you must call EnhancedPreparedStatement.getMoreResults() to move to any subsequent result(s).

      Specified by:
      execute in interface EnhancedPreparedStatement
      Returns:
      true if the first result is a ResultSet instance; false if the first result is an update count or there is no result.
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or no argument was supplied for at least one parameter.
      See Also:

    • executeBatch

      public final int[] executeBatch() throws SQLException

      Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. The int elements of the array that is returned are ordered to correspond to the commands in the batch, which are ordered according to the order in which they were added to the batch.

      The elements in the array returned by the method executeBatch() may be one of the following:

      1. A number greater than or equal to zero – indicates that the command was processed successfully and is an update count giving the number of rows in the database that were affected by the command's execution.
      2. A value of Statement.SUCCESS_NO_INFO (-2 – indicates that the command was processed successfully but that the number of rows affected is unknown.

      If one of the commands in a batch update fails to execute properly, this method throws a BatchUpdateException, and a JDBC driver may or may not continue to process the remaining commands in the batch. However, the driver's behaviour must be consistent with a particular DBMS, either always continuing to process commands or never continuing to process commands. If the driver continues processing after a failure, the array returned by the method BatchUpdateException.getUpdateCounts() will contain as many elements as there are commands in the batch, and at least one of the elements will be Statement.EXECUTE_FAILED (-3 – indicating that the command failed to execute successfully); it occurs only if a driver continues to process commands after a command failed.

      Specified by:
      executeBatch in interface EnhancedPreparedStatement
      Returns:
      An array of update counts containing one element for each command in the batch. The elements of the array are ordered according to the order in which commands were added to the batch.
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or the driver does not support batch statements.
      See Also:

    • executeLargeBatch

      public long[] executeLargeBatch() throws SQLException
      Description copied from interface: EnhancedPreparedStatement

      Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. The int elements of the array that is returned are ordered to correspond to the commands in the batch, which are ordered according to the order in which they were added to the batch.

      The elements in the array returned by the method executeBatch() may be one of the following:

      1. A number greater than or equal to zero – indicates that the command was processed successfully and is an update count giving the number of rows in the database that were affected by the command's execution.
      2. A value of Statement.SUCCESS_NO_INFO (-2 – indicates that the command was processed successfully but that the number of rows affected is unknown.

      If one of the commands in a batch update fails to execute properly, this method throws a BatchUpdateException, and a JDBC driver may or may not continue to process the remaining commands in the batch. However, the driver's behaviour must be consistent with a particular DBMS, either always continuing to process commands or never continuing to process commands. If the driver continues processing after a failure, the array returned by the method BatchUpdateException.getLargeUpdateCounts() will contain as many elements as there are commands in the batch, and at least one of the elements will be Statement.EXECUTE_FAILED (-3 – indicating that the command failed to execute successfully); it occurs only if a driver continues to process commands after a command failed.

      This method should be used when the returned row count may exceed Integer.MAX_VALUE.

      Specified by:
      executeLargeBatch in interface EnhancedPreparedStatement
      Returns:
      An array of update counts containing one element for each command in the batch. The elements of the array are ordered according to the order in which commands were added to the batch.
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or the driver does not support batch statements.
      See Also:

    • executeLargeUpdate

      public final long executeLargeUpdate() throws SQLException

      Executes the SQL statement in this EnhancedPreparedStatement instance. It 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.

      This method should be used when the returned row count may exceed Integer.MAX_VALUE.

      The default implementation will throw UnsupportedOperationException.

      Specified by:
      executeLargeUpdate in interface EnhancedPreparedStatement
      Returns:
      Either the row count for SQL Data Manipulation Language (DML) statements or 0 for SQL statements that return nothing.
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or the SQL statement returns a ResultSet object.

    • executeQuery

      public final ResultSet executeQuery() throws SQLException

      Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.

      Specified by:
      executeQuery in interface EnhancedPreparedStatement
      Returns:
      A ResultSet instance that contains the data produced by the query; never null.
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or the SQL statement did not return a ResultSet object.

    • executeUpdate

      public final int executeUpdate() throws SQLException

      Executes the SQL statement in this EnhancedPreparedStatement instance. It 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.

      Specified by:
      executeUpdate in interface EnhancedPreparedStatement
      Returns:
      Either the row count for SQL Data Manipulation Language (DML) statements or 0 for SQL statements that return nothing.
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or the SQL statement returns a ResultSet object.

    • getCurrentValues

      protected final Collection<StatementValue> getCurrentValues()
      Provides the current values for logging purposes.
      Returns:
      The current values.

    • getConnection

      public final Connection getConnection() throws SQLException

      Retrieves the Connection instance that produced the PreparedStatement instance wrapped by this EnhancedPreparedStatement.

      Specified by:
      getConnection in interface EnhancedPreparedStatement
      Returns:
      The connection that produced the wrapped prepared statement.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • getFetchDirection

      public final int getFetchDirection() throws SQLException

      Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this EnhancedPreparedStatement instance.

      If this EnhancedPreparedStatement instance has not set a fetch direction by calling the method EnhancedPreparedStatement.setFetchDirection(int), the return value is implementation-specific.

      Specified by:
      getFetchDirection in interface EnhancedPreparedStatement
      Returns:
      The default fetch direction for result sets generated from this EnhancedPreparedStatement instance.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • getFetchSize

      public final int getFetchSize() throws SQLException

      Retrieves the number of result set rows that is the default fetch size for ResultSet instances generated from this EnhancedPreparedStatement instance. If this statement instance has not set a fetch size by calling the method EnhancedPreparedStatement.setFetchSize(int), the return value is implementation-specific.

      Specified by:
      getFetchSize in interface EnhancedPreparedStatement
      Returns:
      The default fetch size for result sets generated from this EnhancedPreparedStatement instance.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • getGeneratedKeys

      public final ResultSet getGeneratedKeys() throws SQLException

      Retrieves any auto-generated keys created as a result of executing this EnhancedPreparedStatement instance. If this statement did not generate any keys, an empty ResultSet object is returned.

      Specified by:
      getGeneratedKeys in interface EnhancedPreparedStatement
      Returns:
      A ResultSet instance containing the auto-generated key(s) generated by the execution of this EnhancedPreparedStatement instance.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed Statement.

    • getLargeMaxRows

      public final long getLargeMaxRows() throws SQLException

      Retrieves the maximum number of rows that a ResultSet instance produced by this EnhancedPreparedStatement instance can contain. If this limit is exceeded, the excess rows are silently dropped.

      This method should be used when the returned row limit may exceed Integer.MAX_VALUE.

      The default implementation will return 0.

      Specified by:
      getLargeMaxRows in interface EnhancedPreparedStatement
      Returns:
      The current maximum number of rows for a ResultSet instance produced by this EnhancedPreparedStatement instance; zero means there is no limit, or that the method is not supported by the JDBC driver.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • getLargeUpdateCount

      public final long getLargeUpdateCount() throws SQLException

      Retrieves the current result as an update count. If the result is a ResultSet object or there are no more results, -1 is returned.

      This method should be used when the returned row count may exceed Integer.MAX_VALUE.

      The default implementation will throw UnsupportedOperationException

      Specified by:
      getLargeUpdateCount in interface EnhancedPreparedStatement
      Returns:
      The current result as an update count; -1 if the current result is a ResultSet object or there are no more results.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • getMaxFieldSize

      public final int getMaxFieldSize() throws SQLException

      Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this EnhancedPreparedStatement object.

      This limit applies only to JDBCType.BINARY, JDBCType.VARBINARY, JDBCType.LONGVARBINARY, JDBCType.CHAR, JDBCType.VARCHAR, JDBCType.NCHAR, JDBCType.NVARCHAR, JDBCType.LONGNVARCHAR and JDBCType.LONGVARCHAR columns. If the limit is exceeded, the excess data is silently discarded.

      Specified by:
      getMaxFieldSize in interface EnhancedPreparedStatement
      Returns:
      The current column size limit for columns storing character and binary values; zero means there is no limit.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement
      See Also:

    • getMaxRows

      public final int getMaxRows() throws SQLException

      Retrieves the maximum number of rows that a ResultSet instance produced by this EnhancedPreparedStatement instance can contain. If this limit is exceeded, the excess rows are silently dropped.

      Specified by:
      getMaxRows in interface EnhancedPreparedStatement
      Returns:
      The current maximum number of rows for a ResultSet instance produced by this EnhancedPreparedStatement instance; zero means there is no limit.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • getMetaData

      public final ResultSetMetaData getMetaData() throws SQLException

      Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet instance that will be returned when this EnhancedPreparedStatement instance is executed.

      Because the PreparedStatement that is wrapped by this EnhancedPreparedStatement is precompiled, it is possible to know about the ResultSet object that it will return without having to execute it. Consequently, it is possible to invoke the method getMetaData() on a EnhancedPreparedStatement instance rather than waiting to execute it and then invoking the ResultSet.getMetaData() method on the ResultSet instance that is returned.

      Specified by:
      getMetaData in interface EnhancedPreparedStatement
      Returns:
      The description of a ResultSet object's columns or null if the driver cannot return a ResultSetMetaData object.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed PreparedStatement.

    • getMoreResults

      public final boolean getMoreResults() throws SQLException

      Moves to this EnhancedPreparedStatement instance's next result, returns true if it is a ResultSet instance, and implicitly closes any current ResultSet instance(s) previously obtained with the method EnhancedPreparedStatement.getResultSet().

      There are no more results when the following is true:

      
     // stmt is a EnhancedPreparedStatement object
     ((stmt.getMoreResults() == false) && (stmt.getUpdateCount() == -1))
      Specified by:
      getMoreResults in interface EnhancedPreparedStatement
      Returns:
      true if the next result is a ResultSet instance; false if it is an update count or there are no more results.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • getMoreResults

      public final boolean getMoreResults(int current) throws SQLException

      Moves to this EnhancedPreparedStatement instance's next result, deals with any current ResultSet instance(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object.

      There are no more results when the following is true:

      
     // stmt is a Statement object
     ((stmt.getMoreResults( current ) == false) && (stmt.getUpdateCount() == -1))
      Specified by:
      getMoreResults in interface EnhancedPreparedStatement
      Parameters:
      current - One of the following Statement constants indicating what should happen to current ResultSet instances obtained using the method EnhancedPreparedStatement.getResultSet(): Statement.CLOSE_CURRENT_RESULT, Statement.KEEP_CURRENT_RESULT, or Statement.CLOSE_ALL_RESULTS.
      Returns:
      true if the next result is a ResultSet instance, false if it is an update count or there are no more results
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or the argument supplied is not one of the following: Statement.CLOSE_CURRENT_RESULT, Statement.KEEP_CURRENT_RESULT, or Statement.CLOSE_ALL_RESULTS.
      See Also:

    • getParameterIndexes

      protected final int[] getParameterIndexes(String parameterName) throws SQLException
      Returns the parameter indexes for the given parameter name.
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      Returns:
      The parameter indexes for this parameter name.
      Throws:
      SQLException - The given parameter name is not defined.

    • getParameterMetaData

      public ParameterMetaData getParameterMetaData() throws SQLException
      Description copied from interface: EnhancedPreparedStatement
      Retrieves the number, types and properties of this EnhancedPreparedStatement instance's parameters.
      Specified by:
      getParameterMetaData in interface EnhancedPreparedStatement
      Returns:
      An instance of ParameterMetaData that contains information about the number, types and properties for each named parameter of this EnhancedPreparedStatement instance.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • getParameterNames

      protected final Collection<String> getParameterNames()
      Returns the parameter names for this EnhancedPreparedStatement.
      Returns:
      The parameter names.

    • getQueryTimeout

      public final int getQueryTimeout() throws SQLException

      Retrieves the number of seconds the driver will wait for a Statement instance to execute. If the limit is exceeded, a SQLTimeoutException is thrown.

      Specified by:
      getQueryTimeout in interface EnhancedPreparedStatement
      Returns:
      The current query timeout limit in seconds; zero means there is no limit.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • getResultSet

      public final ResultSet getResultSet() throws SQLException

      Retrieves the current result as a ResultSet instance.

      Specified by:
      getResultSet in interface EnhancedPreparedStatement
      Returns:
      The current result as a ResultSet instance or null if the result is an update count or there are no more results.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • getResultSetConcurrency

      public final int getResultSetConcurrency() throws SQLException
      Retrieves the result set concurrency for ResultSet instances generated by this EnhancedPreparedStatement instance.
      Specified by:
      getResultSetConcurrency in interface EnhancedPreparedStatement
      Returns:
      Either ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • getResultSetHoldability

      public final int getResultSetHoldability() throws SQLException
      Retrieves the result set holdability for ResultSet instances generated by this EnhancedPreparedStatement instance.
      Specified by:
      getResultSetHoldability in interface EnhancedPreparedStatement
      Returns:
      Either ResultSet.HOLD_CURSORS_OVER_COMMIT (1) or ResultSet.CLOSE_CURSORS_AT_COMMIT (2).
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • getResultSetType

      public final int getResultSetType() throws SQLException
      Retrieves the result set type for ResultSet instances generated by this EnhancedPreparedStatement instance.
      Specified by:
      getResultSetType in interface EnhancedPreparedStatement
      Returns:
      One of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • getSourceStatement

      protected final String getSourceStatement()
      Provides the source statement for logging purposes.
      Returns:
      The source statement.

    • getUpdateCount

      public final int getUpdateCount() throws SQLException

      Retrieves the current result as an update count. If the result is a ResultSet object or there are no more results, -1 is returned.

      Specified by:
      getUpdateCount in interface EnhancedPreparedStatement
      Returns:
      The current result as an update count; -1 if the current result is a ResultSet object or there are no more results.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • getWarnings

      public final SQLWarning getWarnings() throws SQLException

      Retrieves the first warning reported by calls on this EnhancedPreparedStatement instance. Subsequent warnings regarding the execution of this instance will be chained to this SQLWarning instance

      .

      The warning chain is automatically cleared each time a statement is (re)executed. This method may not be called on a closed EnhancedPreparedStatement instance; doing so will cause an SQLException to be thrown.

      Specified by:
      getWarnings in interface EnhancedPreparedStatement
      Returns:
      The first SQLWarning object or null if there are no warnings.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • isClosed

      public final boolean isClosed() throws SQLException

      Retrieves whether this EnhancedPreparedStatement object has been closed. An EnhancedPreparedStatement is closed if the method EnhancedPreparedStatement.close() has been called on it, or if it is automatically closed.

      Specified by:
      isClosed in interface EnhancedPreparedStatement
      Returns:
      true if this EnhancedPreparedStatement object is closed; false if it is still open.
      Throws:
      SQLException - A database access error occurred.

    • isCloseOnCompletion

      public final boolean isCloseOnCompletion() throws SQLException

      Returns a value indicating whether this EnhancedPreparedStatement will be closed when all its dependent result sets are closed.

      Specified by:
      isCloseOnCompletion in interface EnhancedPreparedStatement
      Returns:
      true if this EnhancedPreparedStatement will be closed when all of its dependent result sets are closed, false otherwise.
      Throws:
      SQLException - This method was called on a closed EnhancedPreparedStatement.

    • isLoggingEnabled

      public abstract boolean isLoggingEnabled()
      Checks whether logging is currently enabled.
      Specified by:
      isLoggingEnabled in interface EnhancedPreparedStatement
      Returns:
      true if logging is enabled and log information have to be collected, false otherwise.

    • isPoolable

      public final boolean isPoolable() throws SQLException
      Returns a value indicating whether the wrapped PreparedStatement is poolable or not.
      Specified by:
      isPoolable in interface EnhancedPreparedStatement
      Returns:
      true if the PreparedStatement is poolable, false otherwise
      Throws:
      SQLException - This method was called on a closed EnhancedPreparedStatement
      See Also:

    • isSimpleIdentifier

      public final boolean isSimpleIdentifier(String identifier) throws SQLException
      Retrieves whether identifier is a simple SQL identifier.
      Specified by:
      isSimpleIdentifier in interface EnhancedPreparedStatement
      Parameters:
      identifier - An SQL identifier
      Returns:
      true if the given value is a simple SQL identifier, false otherwise
      Throws:
      SQLException - A database access error occurred.

    • setArray

      public final void setArray(String parameterName, Array value) throws SQLException

      Sets the designated parameter to the given Array instance.

      The driver converts this to an SQL ARRAY value when it sends it to the database.

      Specified by:
      setArray in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setAsciiStream

      public void setAsciiStream(String parameterName, InputStream value, int length) throws SQLException

      Sets the designated parameter to the given InputStream which will have the specified number of bytes.

      When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.

      Specified by:
      setAsciiStream in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      length - The number of bytes in the stream.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setAsciiStream

      public void setAsciiStream(String parameterName, InputStream value, long length) throws SQLException

      Sets the designated parameter to the given InputStream which will have the specified number of bytes.

      When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.

      Specified by:
      setAsciiStream in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      length - The number of bytes in the stream.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setAsciiStream

      public void setAsciiStream(String parameterName, InputStream value) throws SQLException

      Sets the designated parameter to the given InputStream.

      When a very large ASCII value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.InputStream. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.

      Specified by:
      setAsciiStream in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setBinaryStream

      public void setBinaryStream(String parameterName, InputStream value, int length) throws SQLException

      Sets the designated parameter to the given InputStream which will have the specified number of bytes.

      When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream. The data will be read from the stream as needed until end-of-file is reached.

      Specified by:
      setBinaryStream in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      length - The number of bytes in the stream.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setBinaryStream

      public void setBinaryStream(String parameterName, InputStream value, long length) throws SQLException

      Sets the designated parameter to the given InputStream which will have the specified number of bytes.

      When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream. The data will be read from the stream as needed until end-of-file is reached.

      Specified by:
      setBinaryStream in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      length - The number of bytes in the stream.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setBinaryStream

      public void setBinaryStream(String parameterName, InputStream value) throws SQLException

      Sets the designated parameter to the given InputStream.

      When a very large binary value is input to a LONGVARBINARY parameter, it may be more practical to send it via a java.io.InputStream. The data will be read from the stream as needed until end-of-file is reached.

      Specified by:
      setBinaryStream in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setBigDecimal

      public final void setBigDecimal(String parameterName, BigDecimal value) throws SQLException

      Sets the designated parameter to the given Java BigDecimal value.

      The driver converts this to an SQL NUMERIC value when it sends it to the database.

      Specified by:
      setBigDecimal in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setBlob

      public final void setBlob(String parameterName, Blob value) throws SQLException

      Sets the designated parameter to the given Java Blob instance.

      The driver converts this to an SQL BLOB value when it sends it to the database.

      Specified by:
      setBlob in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setBlob

      public final void setBlob(String parameterName, InputStream value, long length) throws SQLException

      Sets the designated parameter to a InputStream object. The InputStream must contain the number of characters as specified by the length argument, otherwise a SQLException will be generated when the EnhancedPreparedStatement is executed.

      This method differs from the (String,InputStream,int) method because it informs the driver that the parameter value should be sent to the server as a BLOB. When the setBinaryStream() method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARBINARY or a BLOB.

      Specified by:
      setBlob in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The InputStream instance that contains the data to set the parameter value to.
      length - The number of bytes in the parameter data.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred, this method was called on a closed EnhancedPreparedStatement, the specified length was less than zero or if the number of bytes in the InputStream did not match the specified length.

    • setBlob

      public final void setBlob(String parameterName, InputStream value) throws SQLException

      Sets the designated parameter to a InputStream object.

      This method differs from the (String,InputStream,int) method because it informs the driver that the parameter value should be sent to the server as a BLOB. When the setBinaryStream() method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARBINARY or a BLOB.

      Specified by:
      setBlob in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The InputStream instance that contains the data to set the parameter value to.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred, or this method was called on a closed EnhancedPreparedStatement.

    • setBoolean

      public final void setBoolean(String parameterName, boolean value) throws SQLException

      Sets the designated parameter to the given Java boolean value.

      The driver converts this to an SQL BIT or BOOLEAN value when it sends it to the database.

      For the logging, it is always BOOLEAN.

      Specified by:
      setBoolean in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setByte

      public final void setByte(String parameterName, byte value) throws SQLException

      Sets the designated parameter to the given Java byte value.

      The driver converts this to an SQL TINYINT value when it sends it to the database.

      Specified by:
      setByte in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setBytes

      public final void setBytes(String parameterName, byte[] value) throws SQLException

      Sets the designated parameter to the given Java array of bytes.

      The driver converts this to an SQL VARBINARY or LONGVARBINARY (depending on the argument's size relative to the driver's limits on VARBINARY values) when it sends it to the database.

      For the logging, it is always VARBINARY.

      Specified by:
      setBytes in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setCharacterStream

      public final void setCharacterStream(String parameterName, Reader value, int length) throws SQLException

      Sets the designated parameter to the given Reader instance, which provides the given number of characters.

      When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader instance. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

      Specified by:
      setCharacterStream in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The java.io.Reader object that contains the Unicode data.
      length - The number of characters in the stream.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setCharacterStream

      public final void setCharacterStream(String parameterName, Reader value, long length) throws SQLException

      Sets the designated parameter to the given Reader instance, which provides the given number of characters.

      When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader instance. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

      Specified by:
      setCharacterStream in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The java.io.Reader object that contains the Unicode data.
      length - The number of characters in the stream.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setCharacterStream

      public final void setCharacterStream(String parameterName, Reader value) throws SQLException

      Sets the designated parameter to the given Reader instance.

      When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader instance. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

      Specified by:
      setCharacterStream in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The java.io.Reader object that contains the Unicode data.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setClob

      public final void setClob(String parameterName, Clob value) throws SQLException

      Sets the designated parameter to the given Clob instance.

      The driver converts this to an SQL CLOB value when it sends it to the database.

      Specified by:
      setClob in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setClob

      public final void setClob(String parameterName, Reader value, long length) throws SQLException

      Sets the designated parameter to a Reader instance. The reader must contain the number of characters specified by the length argument, otherwise a SQLException will be generated when the EnhancedPreparedStatement is executed.

      This method differs from the EnhancedPreparedStatement.setCharacterStream(String,Reader,int) method because it informs the driver that the parameter value should be sent to the server as a CLOB. When the setCharacterStream() method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARCHAR or a CLOB.

      Specified by:
      setClob in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The java.io.Reader object that contains the data to set the parameter value to.
      length - The number of characters in the stream.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement, the Reader was shorter than specified, or the specified length was less than zero.

    • setCursorName

      public final void setCursorName(String name) throws SQLException

      Sets the SQL cursor name to the given String, which will be used by subsequent statement execute() methods. This name can then be used in SQL positioned update or delete statements to identify the current row in the ResultSet instance generated by this statement. If the database does not support positioned update/delete, this method is a noop. To ensure that a cursor has the proper isolation level to support updates, the cursor's SELECT statement should have the form SELECT FOR UPDATE. If FOR UPDATE is not present, positioned updates may fail.

      Specified by:
      setCursorName in interface EnhancedPreparedStatement
      Parameters:
      name - The new cursor name, which must be unique within a connection.
      Throws:
      SQLException - A database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setClob

      public final void setClob(String parameterName, Reader value) throws SQLException

      Sets the designated parameter to a Reader instance.

      This method differs from the EnhancedPreparedStatement.setCharacterStream(String,Reader,int) method because it informs the driver that the parameter value should be sent to the server as a CLOB. When the setCharacterStream() method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGVARCHAR or a CLOB.

      Specified by:
      setClob in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The java.io.Reader object that contains the data to set the parameter value to.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setDate

      public final void setDate(String parameterName, Date value) throws SQLException

      Sets the designated parameter to the given Date value using the default time zone of the virtual machine that is running the application.

      The driver converts this to an SQL DATE value when it sends it to the database.

      Specified by:
      setDate in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setDate

      public void setDate(String parameterName, Date value, Calendar calendar) throws SQLException

      Sets the designated parameter to the given Date value using the given Calendar instance. The driver used the Calendar instance to construct an SQL DATE value, which the driver then sends to the database. With the Calendar instance, the driver can calculate the date taking into account a custom timezone. If no Calendar instance is specified, the driver uses the default timezone, which is that of the virtual machine running the application.

      Specified by:
      setDate in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      calendar - The Calendar instance the driver will use to construct the date.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setDouble

      public final void setDouble(String parameterName, double value) throws SQLException

      Sets the designated parameter to the given Java double value.

      The driver converts this to an SQL DOUBLE value when it sends it to the database.

      Specified by:
      setDouble in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setFetchDirection

      public final void setFetchDirection(int direction) throws SQLException

      Gives the driver a hint as to the direction in which rows will be processed in ResultSet instances created using this EnhancedPreparedStatement object. The default value is ResultSet.FETCH_FORWARD.

      Note that this method sets only the default fetch direction for result sets generated by this EnhancedPreparedStatement instance. Each result set has its own methods for getting and setting its own fetch direction.

      Specified by:
      setFetchDirection in interface EnhancedPreparedStatement
      Parameters:
      direction - The initial direction for processing rows.
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or the given direction is not one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
      See Also:

    • setFetchSize

      public final void setFetchSize(int rows) throws SQLException

      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 instances generated by this EnhancedPreparedStatement instance. If the specified value is zero, then the hint is ignored.

      The default value is zero.

      Specified by:
      setFetchSize in interface EnhancedPreparedStatement
      Parameters:
      rows - The number of rows to fetch.
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or the condition rows >= 0 was not satisfied.

    • setFloat

      public final void setFloat(String parameterName, float value) throws SQLException

      Sets the designated parameter to the given Java float value.

      The driver converts this to an SQL REAL value when it sends it to the database.

      Specified by:
      setFloat in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setInt

      public final void setInt(String parameterName, int value) throws SQLException

      Sets the designated parameter to the given Java int value.

      The driver converts this to an SQL INTEGER value when it sends it to the database.

      Specified by:
      setInt in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setLargeMaxRows

      public final void setLargeMaxRows(long max) throws SQLException

      Sets the limit for the maximum number of rows that any ResultSet instance generated by this EnhancedPreparedStatement instance can contain. If the limit is exceeded, the excess rows are silently dropped.

      This method should be used when the row limit may exceed Integer.MAX_VALUE.

      The default implementation will throw UnsupportedOperationException.

      Specified by:
      setLargeMaxRows in interface EnhancedPreparedStatement
      Parameters:
      max - The new max rows limit; zero means there is no limit.
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or the condition max >= 0 is not satisfied.
      See Also:

    • setLong

      public final void setLong(String parameterName, long value) throws SQLException

      Sets the designated parameter to the given Java long value.

      The driver converts this to an SQL BIGINT value when it sends it to the database.

      Specified by:
      setLong in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setMaxFieldSize

      public final void setMaxFieldSize(int max) throws SQLException

      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.

      This limit applies only to JDBCType.BINARY, JDBCType.VARBINARY, JDBCType.LONGVARBINARY, JDBCType.CHAR, JDBCType.VARCHAR, JDBCType.NCHAR, JDBCType.NVARCHAR, JDBCType.LONGNVARCHAR and JDBCType.LONGVARCHAR columns. If the limit is exceeded, the excess data is silently discarded. For maximum portability, use values greater than 256.

      Specified by:
      setMaxFieldSize in interface EnhancedPreparedStatement
      Parameters:
      max - The new column size limit in bytes; zero means there is no limit.
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or the condition max >= 0 is not satisfied.
      See Also:

    • setMaxRows

      public final void setMaxRows(int max) throws SQLException

      Sets the limit for the maximum number of rows, that any ResultSet instance generated by this EnhancedPreparedStatement instance can contain, to the given number. If the limit is exceeded, the excess rows are silently dropped.

      Specified by:
      setMaxRows in interface EnhancedPreparedStatement
      Parameters:
      max - The new max rows limit; zero means there is no limit.
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or the condition max >= 0 was not satisfied.
      See Also:

    • setNCharacterStream

      public final void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException

      Sets the designated parameter to the given Reader instance.

      The Reader reads the data till end-of-file is reached. The driver does the necessary conversion from Java character format to the national character set in the database.

      Specified by:
      setNCharacterStream in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The java.io.Reader object that contains the data.
      length - The number of characters in the stream.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, the driver does not support national character sets, the driver detected that a data conversion error could occur, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setNCharacterStream

      public final void setNCharacterStream(String parameterName, Reader value) throws SQLException

      Sets the designated parameter to the given Reader instance.

      The Reader reads the data till end-of-file is reached. The driver does the necessary conversion from Java character format to the national character set in the database.

      Specified by:
      setNCharacterStream in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The java.io.Reader object that contains the data.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, the driver does not support national character sets, the driver detected that a data conversion error could occur, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setNClob

      public final void setNClob(String parameterName, NClob value) throws SQLException

      Sets the designated parameter to the given NClob value.

      The driver converts this to an SQL NCLOB value when it sends it to the database.

      Specified by:
      setNClob in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, the driver does not support national character sets, the driver detected that a data conversion error could occur, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setNClob

      public final void setNClob(String parameterName, Reader value, long length) throws SQLException

      Sets the designated parameter to a Reader instance. The reader must contain the number of characters specified by the length argument, otherwise a SQLException will be generated when the EnhancedPreparedStatement is executed.

      This method differs from the EnhancedPreparedStatement.setNCharacterStream(String,Reader,long) method because it informs the driver that the parameter value should be sent to the server as a NCLOB. When the setNCharacterStream() method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGNVARCHAR or a NCLOB.

      Specified by:
      setNClob in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The java.io.Reader object that contains the data to set the parameter value to.
      length - The number of characters in the stream.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement, the Reader was shorter than specified, or the specified length was less than zero.

    • setNClob

      public final void setNClob(String parameterName, Reader value) throws SQLException

      Sets the designated parameter to a Reader instance.

      This method differs from the EnhancedPreparedStatement.setNCharacterStream(String,Reader,long) method because it informs the driver that the parameter value should be sent to the server as a NCLOB. When the setNCharacterStream() method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGNVARCHAR or a NCLOB.

      Specified by:
      setNClob in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The java.io.Reader object that contains the data to set the parameter value to.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setNString

      public final void setNString(String parameterName, String value) throws SQLException

      Sets the designated parameter to the given Java String value.

      The driver converts this to an SQL NCHAR, NVARCHAR, or LONGNVARCHAR value (depending on the argument's size relative to the driver's limits on NVARCHAR values)when it sends it to the database.

      For the logging, it is always NCHAR.

      Specified by:
      setNString in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, the driver does not support national character sets, the driver detected that a data conversion error could occur, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setNull

      public final void setNull(String parameterName, SQLType sqlType) throws SQLException
      Sets the designated parameter to SQL NULL.
      Specified by:
      setNull in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      sqlType - The SQL type code.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • setNull

      public void setNull(String parameterName, SQLType sqlType, String typeName) throws SQLException

      Sets the designated parameter to SQL NULL.

      This version of the method setNull() should be used for user-defined types and REF type parameters. Examples of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types.

      Although this method is intended for user-defined and REF parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the given typeName is ignored.

      Specified by:
      setNull in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      sqlType - The SQL type code.
      typeName - The fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or REF.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setObject

      public final void setObject(String parameterName, Object value) throws SQLException

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

      The JDBC specification specifies a standard mapping from Java Object types to SQL types. The given argument will be converted to the corresponding SQL type before being sent to the database.

      Note that this method may be used to pass database- specific abstract data types, by using a driver-specific Java type.

      If the object is of a class implementing the interface SQLData, the JDBC driver should call the method SQLData.writeSQL to write it to the SQL data stream.

      If, on the other hand, the object is of a class implementing Ref, Blob, Clob, NClob, Struct, URL, RowId, SQLXML or Array, the driver should pass it to the database as a value of the corresponding SQL type.

      Specified by:
      setObject in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The object containing the input parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred, this method was called on a closed EnhancedPreparedStatement or the type of the given object is ambiguous.

    • setObject

      public final void setObject(String parameterName, Object value, SQLType targetSqlType, int scaleOrLength) throws SQLException

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

      If the second argument is an InputStream or a Reader then the stream must contain the number of bytes specified by the scaleOrLength argument

      .

      If these conditions are not true the driver will generate a SQLException when the prepared statement is executed.

      The given Java object will be converted to the given targetSqlType before being sent to the database.

      If the object has a custom mapping (is of a class implementing the interface SQLData), the JDBC driver should call the method SQLData.writeSQL(SQLOutput) to write it to the SQL data stream.

      If, on the other hand, the object is of a class implementing Ref, Blob, Clob, NClob, Struct, URL, or Array, the driver should pass it to the database as a value of the corresponding SQL type.

      Note that this method may be used to pass database-specific abstract data types.

      Specified by:
      setObject in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The object containing the input parameter value.
      targetSqlType - The SQL type to be sent to the database. The scale argument may further qualify this type.
      scaleOrLength - For JDBCType.DECIMAL or JDBCType.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.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred, this method was called on a closed EnhancedPreparedStatement or the Java Object specified by value is an InputStream or Reader instance and the value of the scale parameter is less than zero.
      See Also:

    • setObject

      public void setObject(String parameterName, Object value, SQLType targetSqlType) throws SQLException

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

      This method is similar to EnhancedPreparedStatement.setObject(String,Object,SQLType,int), except that it assumes a scale of zero.

      Specified by:
      setObject in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The object containing the input parameter value.
      targetSqlType - The SQL type to be sent to the database. The scale argument may further qualify this type.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred, or this method was called on a closed EnhancedPreparedStatement.
      See Also:

    • setQueryTimeout

      public final void setQueryTimeout(int timeout) throws SQLException

      Sets the number of seconds the driver will wait for a Statement instance to execute to the given number of seconds. By default there is no limit on the amount of time allowed for a running statement to complete.

      If the limit is exceeded, an SQLTimeoutException is thrown.

      A JDBC driver must apply this limit to the Statement.execute(String), Statement.executeQuery(String) and Statement.executeUpdate(String) methods.

      Specified by:
      setQueryTimeout in interface EnhancedPreparedStatement
      Parameters:
      timeout - The new query timeout limit in seconds; zero means there is no limit
      Throws:
      SQLException - A database access error occurred, this method was called on a closed EnhancedPreparedStatement or the condition seconds >= 0 is not satisfied
      See Also:

    • setRef

      public final void setRef(String parameterName, Ref value) throws SQLException

      Sets the designated parameter to the given REF(<structured-type>) value.

      The driver converts this to an SQL REF value when it sends it to the database.

      Specified by:
      setRef in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setRowId

      public final void setRowId(String parameterName, RowId value) throws SQLException

      Sets the designated parameter to the given RowId instance.

      The driver converts this to an SQL ROWID value when it sends it to the database.

      Specified by:
      setRowId in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setShort

      public final void setShort(String parameterName, short value) throws SQLException

      Sets the designated parameter to the given Java short value.

      The driver converts this to an SQL SMALLINT value when it sends it to the database.

      Specified by:
      setShort in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setSQLXML

      public final void setSQLXML(String parameterName, SQLXML value) throws SQLException

      Sets the designated parameter to the given SQLXML value.

      The driver converts this to an SQL SQLXML value when it sends it to the database.

      Specified by:
      setSQLXML in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - An SQLXML instance that maps an SQL SQLXML value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred, this method was called on a closed EnhancedPreparedStatement, or the Result, Writer or OutputStream was closed for the SQLXML object.

    • setString

      public final void setString(String parameterName, String value) throws SQLException

      Sets the designated parameter to the given Java String value.

      The driver converts this to an SQL VARCHAR or LONGVARCHAR value (depending on the argument's size relative to the driver's limits on VARCHAR values) when it sends it to the database.

      For the logging, it is always VARCHAR.

      Specified by:
      setString in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setTime

      public final void setTime(String parameterName, Time value) throws SQLException

      Sets the designated parameter to the given Time value.

      The driver converts this to an SQL TIME value when it sends it to the database.

      Specified by:
      setTime in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setTime

      public final void setTime(String parameterName, Time value, Calendar calendar) throws SQLException

      Sets the designated parameter to the given Time value using the given Calendar instance. The driver used the Calendar instance to construct an SQL TIME value, which the driver then sends to the database. With the Calendar instance, the driver can calculate the date taking into account a custom timezone. If no Calendar instance is specified, the driver uses the default timezone, which is that of the virtual machine running the application.

      Specified by:
      setTime in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      calendar - The Calendar instance the driver will use to construct the date.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setTimestamp

      public final void setTimestamp(String parameterName, Timestamp value) throws SQLException

      Sets the designated parameter to the given Timestamp value.

      The driver converts this to an SQL TIMESTAMP value when it sends it to the database.

      Specified by:
      setTimestamp in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setTimestamp

      public final void setTimestamp(String parameterName, Timestamp value, Calendar calendar) throws SQLException

      Sets the designated parameter to the given Timestamp value using the given Calendar instance. The driver used the Calendar instance to construct an SQL TIMESTAMP value, which the driver then sends to the database. With the Calendar instance, the driver can calculate the timestamp taking into account a custom timezone. If no Calendar instance is specified, the driver uses the default timezone, which is that of the virtual machine running the application.

      Specified by:
      setTimestamp in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      calendar - The Calendar instance the driver will use to construct the date.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.

    • setURL

      public final void setURL(String parameterName, URL value) throws SQLException

      Sets the designated parameter to the given URL value.

      The driver converts this to an SQL DATALINK value when it sends it to the database.

      Specified by:
      setURL in interface EnhancedPreparedStatement
      Parameters:
      parameterName - The name of the parameter, prefixed by a colon.
      value - The parameter value.
      Throws:
      SQLException - The parameter name did not correspond to any defined parameter in the SQL statement, a database access error occurred or this method was called on a closed EnhancedPreparedStatement.