Class EmbedCallableStatement

All Implemented Interfaces:
AutoCloseable, CallableStatement, PreparedStatement, Statement, Wrapper, EngineCallableStatement, EnginePreparedStatement, EngineStatement
Direct Known Subclasses:
EmbedCallableStatement42

public class EmbedCallableStatement extends EmbedPreparedStatement implements EngineCallableStatement
Local implementation.
  • Field Details

    • hasReturnOutputParameter

      private boolean hasReturnOutputParameter
    • wasNull

      protected boolean wasNull
  • Constructor Details

    • EmbedCallableStatement

      public EmbedCallableStatement(EmbedConnection conn, String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException
      Throws:
      SQLException - thrown on failure
  • Method Details

    • checkRequiresCallableStatement

      protected void checkRequiresCallableStatement(Activation activation)
      Description copied from class: EmbedStatement
      Check to see if a statement requires to be executed via a callable statement.
      Overrides:
      checkRequiresCallableStatement in class EmbedStatement
    • executeStatement

      protected final boolean executeStatement(Activation a, boolean executeQuery, boolean executeUpdate) throws SQLException
      Description copied from class: EmbedStatement
      Execute the current statement.
      Overrides:
      executeStatement in class EmbedPreparedStatement
      Throws:
      SQLException - thrown on failure.
    • registerOutParameter

      public final void registerOutParameter(int parameterIndex, int sqlType) throws SQLException
      Specified by:
      registerOutParameter in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • registerOutParameter

      public final void registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException
      Specified by:
      registerOutParameter in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • registerOutParameter

      public void registerOutParameter(int parameterIndex, int sqlType, String typeName) throws SQLException
      JDBC 2.0 Derby ignores the typeName argument because UDTs don't need it.
      Specified by:
      registerOutParameter in interface CallableStatement
      Throws:
      SQLException - if a database-access error occurs.
    • wasNull

      public boolean wasNull() throws SQLException
      Specified by:
      wasNull in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getString

      public String getString(int parameterIndex) throws SQLException
      Specified by:
      getString in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getBoolean

      public boolean getBoolean(int parameterIndex) throws SQLException
      Specified by:
      getBoolean in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getByte

      public byte getByte(int parameterIndex) throws SQLException
      Specified by:
      getByte in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getShort

      public short getShort(int parameterIndex) throws SQLException
      Specified by:
      getShort in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getInt

      public int getInt(int parameterIndex) throws SQLException
      Specified by:
      getInt in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getLong

      public long getLong(int parameterIndex) throws SQLException
      Specified by:
      getLong in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getBigDecimal

      public final BigDecimal getBigDecimal(int parameterIndex) throws SQLException
      JDBC 2.0 Get the value of a NUMERIC parameter as a java.math.BigDecimal object.
      Specified by:
      getBigDecimal in interface CallableStatement
      Parameters:
      parameterIndex - the first parameter is 1, the second is 2, ...
      Returns:
      the parameter value (full precision); if the value is SQL NULL, the result is null
      Throws:
      SQLException - if a database-access error occurs.
    • getBigDecimal

      public final BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException
      Deprecated.
      Specified by:
      getBigDecimal in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getFloat

      public float getFloat(int parameterIndex) throws SQLException
      Specified by:
      getFloat in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getDouble

      public double getDouble(int parameterIndex) throws SQLException
      Specified by:
      getDouble in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getBytes

      public byte[] getBytes(int parameterIndex) throws SQLException
      Specified by:
      getBytes in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getDate

      public Date getDate(int parameterIndex, Calendar cal) throws SQLException
      Specified by:
      getDate in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getTime

      public Time getTime(int parameterIndex, Calendar cal) throws SQLException
      Specified by:
      getTime in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getTimestamp

      public Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException
      Specified by:
      getTimestamp in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getDate

      public Date getDate(int parameterIndex) throws SQLException
      Get the value of a SQL DATE parameter as a java.sql.Date object
      Specified by:
      getDate in interface CallableStatement
      Parameters:
      parameterIndex - the first parameter is 1, the second is 2, ...
      Returns:
      the parameter value; if the value is SQL NULL, the result is null
      Throws:
      SQLException - if a database-access error occurs.
    • getTime

      public Time getTime(int parameterIndex) throws SQLException
      Get the value of a SQL TIME parameter as a java.sql.Time object.
      Specified by:
      getTime in interface CallableStatement
      Parameters:
      parameterIndex - the first parameter is 1, the second is 2, ...
      Returns:
      the parameter value; if the value is SQL NULL, the result is null
      Throws:
      SQLException - if a database-access error occurs.
    • getTimestamp

      public Timestamp getTimestamp(int parameterIndex) throws SQLException
      Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object.
      Specified by:
      getTimestamp in interface CallableStatement
      Parameters:
      parameterIndex - the first parameter is 1, the second is 2, ...
      Returns:
      the parameter value; if the value is SQL NULL, the result is null
      Throws:
      SQLException - if a database-access error occurs.
    • getObject

      public final Object getObject(int parameterIndex) throws SQLException
      Specified by:
      getObject in interface CallableStatement
      Throws:
      SQLException - NoOutputParameters thrown.
      See Also:
    • getURL

      public URL getURL(int parameterIndex) throws SQLException
      JDBC 3.0 Retrieve the value of the designated JDBC DATALINK parameter as a java.net.URL object
      Specified by:
      getURL in interface CallableStatement
      Parameters:
      parameterIndex - - the first parameter is 1, the second is 2
      Returns:
      a java.net.URL object that represents the JDBC DATALINK value used as the designated parameter
      Throws:
      SQLException - Feature not implemented for now.
    • setURL

      public void setURL(String parameterName, URL val) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given java.net.URL object. The driver converts this to an SQL DATALINK value when it sends it to the database.
      Specified by:
      setURL in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      val - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getURL

      public URL getURL(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object
      Specified by:
      getURL in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • getBlob

      public Blob getBlob(int parameterIndex) throws SQLException
      JDBC 2.0 Get a BLOB OUT parameter.
      Specified by:
      getBlob in interface CallableStatement
      Parameters:
      parameterIndex - the first parameter is 1, the second is 2, ...
      Returns:
      an object representing a BLOB
      Throws:
      SQLException - if a database-access error occurs.
    • getClob

      public Clob getClob(int parameterIndex) throws SQLException
      JDBC 2.0 Get a CLOB OUT parameter.
      Specified by:
      getClob in interface CallableStatement
      Parameters:
      parameterIndex - the first parameter is 1, the second is 2, ...
      Returns:
      an object representing a CLOB
      Throws:
      SQLException - if a database-access error occurs.
    • addBatch

      public void addBatch() throws SQLException
      Description copied from class: EmbedPreparedStatement
      JDBC 2.0 Add a set of parameters to the batch.
      Specified by:
      addBatch in interface PreparedStatement
      Overrides:
      addBatch in class EmbedPreparedStatement
      Throws:
      SQLException - if a database-access error occurs.
    • getObject

      public final Object getObject(int i, Map<String,Class<?>> map) throws SQLException
      JDBC 2.0 Returns an object representing the value of OUT parameter i. Use the map to determine the class from which to construct data of SQL structured and distinct types.
      Specified by:
      getObject in interface CallableStatement
      Parameters:
      i - the first parameter is 1, the second is 2, ...
      map - the mapping from SQL type names to Java classes
      Returns:
      a java.lang.Object holding the OUT parameter value.
      Throws:
      SQLException - if a database-access error occurs.
    • getRef

      public final Ref getRef(int i) throws SQLException
      JDBC 2.0 Get a REF(<structured-type>) OUT parameter.
      Specified by:
      getRef in interface CallableStatement
      Parameters:
      i - the first parameter is 1, the second is 2, ...
      Returns:
      an object representing data of an SQL REF Type
      Throws:
      SQLException - if a database-access error occurs.
    • getArray

      public final Array getArray(int i) throws SQLException
      JDBC 2.0 Get an Array OUT parameter.
      Specified by:
      getArray in interface CallableStatement
      Parameters:
      i - the first parameter is 1, the second is 2, ...
      Returns:
      an object representing an SQL array
      Throws:
      SQLException - if a database-access error occurs.
    • registerOutParameter

      public final void registerOutParameter(String parameterName, int sqlType) throws SQLException
      JDBC 3.0 Registers the OUT parameter named parameterName to the JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.
      Specified by:
      registerOutParameter in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      sqlType - - the JDBC type code defined by java.sql.Types. If the parameter is of JDBC type NUMERIC or DECIMAL, the version of registerOutParameter that accepts a scale value should be used.
      Throws:
      SQLException - Feature not implemented for now.
    • registerOutParameter

      public final void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException
      JDBC 3.0 Registers the designated output parameter. This version of the method registerOutParameter should be used for a user-named or REF output parameter.
      Specified by:
      registerOutParameter in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      sqlType - - the SQL type code defined by java.sql.Types.
      typeName - - the fully-qualified name of an SQL structure type
      Throws:
      SQLException - Feature not implemented for now.
    • registerOutParameter

      public final void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException
      JDBC 3.0 Registers the parameter named parameterName to the JDBC type sqlType. This method must be called before a stored procedure is executed.
      Specified by:
      registerOutParameter in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      sqlType - - the SQL type code defined by java.sql.Types.
      scale - - the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
      Throws:
      SQLException - Feature not implemented for now.
    • getRef

      public final Ref getRef(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC REF (structured-type) parameter as a Ref object in the Java programming language.
      Specified by:
      getRef in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value as a Ref object in the Java Programming language. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • getBlob

      public final Blob getBlob(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language.
      Specified by:
      getBlob in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value as a Blob object in the Java Programming language. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • getClob

      public final Clob getClob(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language.
      Specified by:
      getClob in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value as a Clob object in the Java Programming language. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • getArray

      public final Array getArray(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language.
      Specified by:
      getArray in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value as a Array object in the Java Programming language. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • setNull

      public final void setNull(String parameterName, int sqlType) throws SQLException
      JDBC 3.0 Sets the designated parameter to SQL NULL.
      Specified by:
      setNull in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      sqlType - - the SQL type code defined in java.sql.Types
      Throws:
      SQLException - Feature not implemented for now.
    • setNull

      public final void setNull(String parameterName, int sqlType, String typeName) throws SQLException
      JDBC 3.0 Sets the designated parameter to SQL NULL.
      Specified by:
      setNull in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      sqlType - - the SQL type code defined in java.sql.Types
      typeName - - the fully-qualified name of an SQL user-defined type
      Throws:
      SQLException - Feature not implemented for now.
    • setBoolean

      public final void setBoolean(String parameterName, boolean x) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given Java boolean value. The driver converts this to an SQL BIT value when it sends it to the database.
      Specified by:
      setBoolean in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getBoolean

      public final boolean getBoolean(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC BIT parameter as a boolean in the Java programming language.
      Specified by:
      getBoolean in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is false.
      Throws:
      SQLException - Feature not implemented for now.
    • setByte

      public final void setByte(String parameterName, byte x) throws SQLException
      JDBC 3.0 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 CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getByte

      public final byte getByte(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.
      Specified by:
      getByte in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is 0.
      Throws:
      SQLException - Feature not implemented for now.
    • setShort

      public final void setShort(String parameterName, short x) throws SQLException
      JDBC 3.0 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 CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getShort

      public final short getShort(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.
      Specified by:
      getShort in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is 0.
      Throws:
      SQLException - Feature not implemented for now.
    • setInt

      public final void setInt(String parameterName, int x) throws SQLException
      JDBC 3.0 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 CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getInt

      public final int getInt(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC INTEGER parameter as a int in the Java programming language.
      Specified by:
      getInt in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is 0.
      Throws:
      SQLException - Feature not implemented for now.
    • setLong

      public final void setLong(String parameterName, long x) throws SQLException
      JDBC 3.0 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 CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getLong

      public final long getLong(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.
      Specified by:
      getLong in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is 0.
      Throws:
      SQLException - Feature not implemented for now.
    • setFloat

      public final void setFloat(String parameterName, float x) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given Java float value. The driver converts this to an SQL FLOAT value when it sends it to the database.
      Specified by:
      setFloat in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getFloat

      public final float getFloat(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.
      Specified by:
      getFloat in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is 0.
      Throws:
      SQLException - Feature not implemented for now.
    • setDouble

      public final void setDouble(String parameterName, double x) throws SQLException
      JDBC 3.0 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 CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getDouble

      public final double getDouble(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.
      Specified by:
      getDouble in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is 0.
      Throws:
      SQLException - Feature not implemented for now.
    • setBigDecimal

      public final void setBigDecimal(String parameterName, BigDecimal x) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given java.math.BigDecimal value. The driver converts this to an SQL NUMERIC value when it sends it to the database.
      Specified by:
      setBigDecimal in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getBigDecimal

      public final BigDecimal getBigDecimal(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains
      Specified by:
      getBigDecimal in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is 0.
      Throws:
      SQLException - Feature not implemented for now.
    • setString

      public final void setString(String parameterName, String x) throws SQLException
      JDBC 3.0 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 the driver's limits on VARCHAR values) when it sends it to the database.
      Specified by:
      setString in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getString

      public final String getString(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
      Specified by:
      getString in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • setBytes

      public final void setBytes(String parameterName, byte[] x) throws SQLException
      JDBC 3.0 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.
      Specified by:
      setBytes in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getBytes

      public final byte[] getBytes(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.
      Specified by:
      getBytes in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • setDate

      public final void setDate(String parameterName, Date x) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given java.sql.Date value. The driver converts this to an SQL DATE value when it sends it to the database.
      Specified by:
      setDate in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • setDate

      public final void setDate(String parameterName, Date x, Calendar cal) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
      Specified by:
      setDate in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      cal - - the Calendar object the driver will use to construct the date
      Throws:
      SQLException - Feature not implemented for now.
    • getDate

      public final Date getDate(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC DATE parameter as a java.sql.Date object
      Specified by:
      getDate in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • getDate

      public final Date getDate(String parameterName, Calendar cal) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date object.
      Specified by:
      getDate in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      cal - - the Calendar object the driver will use to construct the date
      Returns:
      the parameter value. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • setTime

      public final void setTime(String parameterName, Time x) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given java.sql.Time value. The driver converts this to an SQL TIME value when it sends it to the database.
      Specified by:
      setTime in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getTime

      public final Time getTime(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC TIME parameter as ajava.sql.Time object
      Specified by:
      getTime in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • getTime

      public final Time getTime(String parameterName, Calendar cal) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time object.
      Specified by:
      getTime in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      cal - - the Calendar object the driver will use to construct the time
      Returns:
      the parameter value. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • setTime

      public final void setTime(String parameterName, Time x, Calendar cal) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given java.sql.Time value using the Calendar object
      Specified by:
      setTime in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      cal - - the Calendar object the driver will use to construct the time
      Throws:
      SQLException - Feature not implemented for now.
    • setTimestamp

      public final void setTimestamp(String parameterName, Timestamp x) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value when it sends it to the database.
      Specified by:
      setTimestamp in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • setTimestamp

      public final void setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object
      Specified by:
      setTimestamp in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the parameter value
      cal - - the Calendar object the driver will use to construct the timestamp.
      Throws:
      SQLException - Feature not implemented for now.
    • getTimestamp

      public final Timestamp getTimestamp(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object
      Specified by:
      getTimestamp in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      the parameter value. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • getTimestamp

      public final Timestamp getTimestamp(String parameterName, Calendar cal) throws SQLException
      JDBC 3.0 Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.
      Specified by:
      getTimestamp in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      cal - - the Calendar object the driver will use to construct the Timestamp
      Returns:
      the parameter value. If the value is SQL NULL, the result is null.
      Throws:
      SQLException - Feature not implemented for now.
    • setAsciiStream

      public final void setAsciiStream(String parameterName, InputStream x, int length) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given input stream, which will have the specified number of bytes.
      Specified by:
      setAsciiStream in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the Java input stream that contains the ASCII parameter value
      length - - the number of bytes in the stream
      Throws:
      SQLException - Feature not implemented for now.
    • setBinaryStream

      public final void setBinaryStream(String parameterName, InputStream x, int length) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given input stream, which will have the specified number of bytes.
      Specified by:
      setBinaryStream in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the Java input stream that contains the binary parameter value
      length - - the number of bytes in the stream
      Throws:
      SQLException - Feature not implemented for now.
    • setCharacterStream

      public final void setCharacterStream(String parameterName, Reader reader, int length) throws SQLException
      JDBC 3.0 Sets the designated parameter to the given Reader object, which is the given number of characters long.
      Specified by:
      setCharacterStream in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      reader - - the java.io.Reader object that contains the UNICODE data
      length - - the number of characters in the stream
      Throws:
      SQLException - Feature not implemented for now.
    • setObject

      public final void setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
      JDBC 3.0 Sets the value of the designated parameter with the given object. The second argument must be an object type; for integral values, the java.lang equivalent objects should be used.
      Specified by:
      setObject in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the object containing the input parameter value
      targetSqlType - - the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.
      scale - - for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types, this value will be ignored.
      Throws:
      SQLException - Feature not implemented for now.
    • getObject

      public final Object getObject(String parameterName) throws SQLException
      JDBC 3.0 Retrieves the value of a parameter as an Object in the java programming language.
      Specified by:
      getObject in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      Returns:
      a java.lang.Object holding the OUT parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getObject

      public final Object getObject(String parameterName, Map<String,Class<?>> map) throws SQLException
      JDBC 3.0 Returns an object representing the value of OUT parameter i and uses map for the custom mapping of the parameter value.
      Specified by:
      getObject in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      map - - the mapping from SQL type names to Java classes
      Returns:
      a java.lang.Object holding the OUT parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • setObject

      public final void setObject(String parameterName, Object x, int targetSqlType) throws SQLException
      JDBC 3.0 Sets the value of the designated parameter with the given object. This method is like the method setObject above, except that it assumes a scale of zero.
      Specified by:
      setObject in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the object containing the input parameter value
      targetSqlType - - the SQL type (as defined in java.sql.Types) to be sent to the database.
      Throws:
      SQLException - Feature not implemented for now.
    • setObject

      public final void setObject(String parameterName, Object x) throws SQLException
      JDBC 3.0 Sets the value of the designated parameter with the given object. The second parameter must be of type Object; therefore, the java.lang equivalent objects should be used for built-in types.
      Specified by:
      setObject in interface CallableStatement
      Parameters:
      parameterName - - the name of the parameter
      x - - the object containing the input parameter value
      Throws:
      SQLException - Feature not implemented for now.
    • getCharacterStream

      public final Reader getCharacterStream(int parameterIndex) throws SQLException
      Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language. Introduced in JDBC 4.0.
      Specified by:
      getCharacterStream in interface CallableStatement
      Parameters:
      parameterIndex - the first parameter is 1, the second is 2, ...
      Returns:
      a java.io.Reader object that contains the parameter value; if the value is SQL NULL, the value returned is null in the Java programming language.
      Throws:
      SQLException - if a database access error occurs or this method is called on a closed CallableStatement
    • getBinaryStream

      private InputStream getBinaryStream(int parameterIndex) throws SQLException
      Get binary stream for a parameter.
      Parameters:
      parameterIndex - first parameter is 1, second is 2 etc.
      Returns:
      a stream for the binary parameter, or null.
      Throws:
      SQLException - if a database access error occurs.
    • getCharacterStream

      public final Reader getCharacterStream(String parameterName) throws SQLException
      Specified by:
      getCharacterStream in interface CallableStatement
      Throws:
      SQLException
    • getNCharacterStream

      public final Reader getNCharacterStream(int parameterIndex) throws SQLException
      Specified by:
      getNCharacterStream in interface CallableStatement
      Throws:
      SQLException
    • getNCharacterStream

      public final Reader getNCharacterStream(String parameterName) throws SQLException
      Specified by:
      getNCharacterStream in interface CallableStatement
      Throws:
      SQLException
    • getNString

      public final String getNString(int parameterIndex) throws SQLException
      Specified by:
      getNString in interface CallableStatement
      Throws:
      SQLException
    • getNString

      public final String getNString(String parameterName) throws SQLException
      Specified by:
      getNString in interface CallableStatement
      Throws:
      SQLException
    • setBlob

      public final void setBlob(String parameterName, Blob x) throws SQLException
      Specified by:
      setBlob in interface CallableStatement
      Throws:
      SQLException
    • setClob

      public final void setClob(String parameterName, Clob x) throws SQLException
      Specified by:
      setClob in interface CallableStatement
      Throws:
      SQLException
    • getRowId

      public final RowId getRowId(int parameterIndex) throws SQLException
      Specified by:
      getRowId in interface CallableStatement
      Throws:
      SQLException
    • getRowId

      public final RowId getRowId(String parameterName) throws SQLException
      Specified by:
      getRowId in interface CallableStatement
      Throws:
      SQLException
    • setRowId

      public final void setRowId(String parameterName, RowId x) throws SQLException
      Specified by:
      setRowId in interface CallableStatement
      Throws:
      SQLException
    • setNString

      public final void setNString(String parameterName, String value) throws SQLException
      Specified by:
      setNString in interface CallableStatement
      Throws:
      SQLException
    • setNCharacterStream

      public final void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException
      Specified by:
      setNCharacterStream in interface CallableStatement
      Throws:
      SQLException
    • setNClob

      public final void setNClob(String parameterName, NClob value) throws SQLException
      Specified by:
      setNClob in interface CallableStatement
      Throws:
      SQLException
    • setClob

      public final void setClob(String parameterName, Reader reader, long length) throws SQLException
      Specified by:
      setClob in interface CallableStatement
      Throws:
      SQLException
    • setBlob

      public final void setBlob(String parameterName, InputStream inputStream, long length) throws SQLException
      Specified by:
      setBlob in interface CallableStatement
      Throws:
      SQLException
    • setNClob

      public final void setNClob(String parameterName, Reader reader, long length) throws SQLException
      Specified by:
      setNClob in interface CallableStatement
      Throws:
      SQLException
    • getNClob

      public final NClob getNClob(int i) throws SQLException
      Specified by:
      getNClob in interface CallableStatement
      Throws:
      SQLException
    • getNClob

      public final NClob getNClob(String parameterName) throws SQLException
      Specified by:
      getNClob in interface CallableStatement
      Throws:
      SQLException
    • setSQLXML

      public final void setSQLXML(String parameterName, SQLXML xmlObject) throws SQLException
      Specified by:
      setSQLXML in interface CallableStatement
      Throws:
      SQLException
    • getSQLXML

      public final SQLXML getSQLXML(int parameterIndex) throws SQLException
      Specified by:
      getSQLXML in interface CallableStatement
      Throws:
      SQLException
    • getSQLXML

      public final SQLXML getSQLXML(String parametername) throws SQLException
      Specified by:
      getSQLXML in interface CallableStatement
      Throws:
      SQLException
    • setAsciiStream

      public final void setAsciiStream(String parameterName, InputStream x) throws SQLException
      Specified by:
      setAsciiStream in interface CallableStatement
      Throws:
      SQLException
    • setBinaryStream

      public final void setBinaryStream(String parameterName, InputStream x) throws SQLException
      Specified by:
      setBinaryStream in interface CallableStatement
      Throws:
      SQLException
    • setBlob

      public final void setBlob(String parameterName, InputStream inputStream) throws SQLException
      Specified by:
      setBlob in interface CallableStatement
      Throws:
      SQLException
    • setCharacterStream

      public final void setCharacterStream(String parameterName, Reader reader) throws SQLException
      Specified by:
      setCharacterStream in interface CallableStatement
      Throws:
      SQLException
    • setClob

      public final void setClob(String parameterName, Reader reader) throws SQLException
      Specified by:
      setClob in interface CallableStatement
      Throws:
      SQLException
    • setNCharacterStream

      public final void setNCharacterStream(String parameterName, Reader value) throws SQLException
      Specified by:
      setNCharacterStream in interface CallableStatement
      Throws:
      SQLException
    • setNClob

      public final void setNClob(String parameterName, Reader reader) throws SQLException
      Specified by:
      setNClob in interface CallableStatement
      Throws:
      SQLException
    • setAsciiStream

      public final void setAsciiStream(String parameterName, InputStream x, long length) throws SQLException
      Sets the designated parameter to the given input stream, which will have the specified number of bytes.
      Specified by:
      setAsciiStream in interface CallableStatement
      Parameters:
      parameterName - the name of the first parameter
      x - the java input stream which contains the ASCII parameter value
      length - the number of bytes in the stream
      Throws:
      SQLException - thrown on failure.
    • setBinaryStream

      public final void setBinaryStream(String parameterName, InputStream x, long length) throws SQLException
      Sets the designated parameter to the given input stream, which will have the specified number of bytes.
      Specified by:
      setBinaryStream in interface CallableStatement
      Parameters:
      parameterName - the name of the first parameter
      x - the java input stream which contains the binary parameter value
      length - the number of bytes in the stream
      Throws:
      SQLException - thrown on failure.
    • setCharacterStream

      public final void setCharacterStream(String parameterName, Reader x, long length) throws SQLException
      Sets the designated parameter to the given Reader, which will have the specified number of bytes.
      Specified by:
      setCharacterStream in interface CallableStatement
      Parameters:
      parameterName - the name of the first parameter
      x - the java Reader which contains the UNICODE value
      length - the number of bytes in the stream
      Throws:
      SQLException - thrown on failure.
    • getObject

      public final <T> T getObject(int parameterIndex, Class<T> type) throws SQLException
      Specified by:
      getObject in interface CallableStatement
      Specified by:
      getObject in interface EngineCallableStatement
      Throws:
      SQLException
    • mismatchException

      private SQLException mismatchException(String targetTypeName, int parameterIndex) throws SQLException
      Throws:
      SQLException
    • getObject

      public final <T> T getObject(String parameterName, Class<T> type) throws SQLException
      Specified by:
      getObject in interface CallableStatement
      Specified by:
      getObject in interface EngineCallableStatement
      Throws:
      SQLException