Class FunctionStatement

All Implemented Interfaces:
AutoCloseable, CallableStatement, PreparedStatement, Statement, Wrapper

public class FunctionStatement extends BaseCallableStatement implements CallableStatement
  • Constructor Details

  • Method Details

    • isFunction

      public boolean isFunction()
      Specified by:
      isFunction in class BaseCallableStatement
    • handleParameterOutput

      protected void handleParameterOutput() throws SQLException
      Overrides:
      handleParameterOutput in class ServerPreparedStatement
      Throws:
      SQLException
    • registerOutParameter

      public void registerOutParameter(int index, int sqlType) throws SQLException
      Description copied from class: BaseCallableStatement
      Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.

      The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.

      If the JDBC type expected to be returned to this output parameter is specific to this particular database, sqlType should be java.sql.Types.OTHER. The method BaseCallableStatement.getObject(int) retrieves the value.

      Specified by:
      registerOutParameter in interface CallableStatement
      Overrides:
      registerOutParameter in class BaseCallableStatement
      Parameters:
      index - the first parameter is 1, the second is 2, and so on
      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 - if the parameterIndex is not valid; if a database access error occurs or this method is called on a closed CallableStatement
      SQLFeatureNotSupportedException - if sqlType is a ARRAY, BLOB, CLOB, DATALINK, JAVA_OBJECT, NCHAR, NCLOB, NVARCHAR, LONGNVARCHAR, REF, ROWID, SQLXML or STRUCT data type and the JDBC driver does not support this data type
      See Also:
    • validParameters

      protected void validParameters() throws SQLException
      Overrides:
      validParameters in class ServerPreparedStatement
      Throws:
      SQLException