Package org.mariadb.jdbc

Class FunctionStatement

    • Constructor Detail

      • FunctionStatement

        public FunctionStatement​(Connection con,
                         String databaseName,
                         String procedureName,
                         String arguments,
                         ReentrantLock lock,
                         boolean canUseServerTimeout,
                         boolean canUseServerMaxRows,
                         boolean canCachePrepStmts,
                         int resultSetType,
                         int resultSetConcurrency)
                  throws SQLException
        Constructor of function callable statement
        Parameters:
        con - current connection
        databaseName - database
        procedureName - procedure
        arguments - arguments
        lock - thread lock object
        canUseServerTimeout - can use server timeout
        canUseServerMaxRows - can use server max rows
        canCachePrepStmts - can cache server prepared result
        resultSetType - result set type
        resultSetConcurrency - concurrency type
        Throws:
        SQLException - if any error occurs

    • Method Detail

      • 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:
        Types

      • preValidParameters

        protected void preValidParameters()
                           throws SQLException
        Ensures that returning value is not taken as a parameter.
        Throws:
        SQLException - if any exception