Class FunctionStatement

  • All Implemented Interfaces:
    java.lang.AutoCloseable, java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

    public class FunctionStatement
    extends BaseCallableStatement
    implements java.sql.CallableStatement
    • Constructor Detail

      • FunctionStatement

        public FunctionStatement​(Connection con,
                                 java.lang.String databaseName,
                                 java.lang.String procedureName,
                                 java.lang.String arguments,
                                 java.util.concurrent.locks.ReentrantLock lock,
                                 boolean canUseServerTimeout,
                                 boolean canUseServerMaxRows,
                                 int resultSetType,
                                 int resultSetConcurrency)
                          throws java.sql.SQLException
        Throws:
        java.sql.SQLException
    • Method Detail

      • registerOutParameter

        public void registerOutParameter​(int index,
                                         int sqlType)
                                  throws java.sql.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 java.sql.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:
        java.sql.SQLException - if the parameterIndex is not valid; if a database access error occurs or this method is called on a closed CallableStatement
        java.sql.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:
        Types