Class AbstractStoredProcedure

java.lang.Object
com.denodo.vdb.catalog.storage.MetadataObject
com.denodo.vdb.catalog.storage.MetaObjectStored
com.denodo.vdb.engine.storedprocedure.AbstractStoredProcedure
All Implemented Interfaces:
StoredProcedure, StoredProcedureExecutor, Serializable

public abstract class AbstractStoredProcedure extends com.denodo.vdb.catalog.storage.MetaObjectStored implements StoredProcedure
This class should be extended by all the stored procedures. The specific procedures must implement the method doCall, and should use the method getProcedureResultSet to add the generated results.
See Also:
  • Field Summary

    Fields inherited from class com.denodo.vdb.catalog.storage.MetaObjectStored

    _createDate, _description, _lastUserModifier, _userCreator, id

    Fields inherited from class com.denodo.vdb.catalog.storage.MetadataObject

    latestModificationDate, latestModificationEpoch, latestModificationInstant

    Fields inherited from interface com.denodo.vdb.engine.storedprocedure.StoredProcedureExecutor

    LOG_DEBUG, LOG_ERROR, LOG_FATAL, LOG_INFO, LOG_TRACE, LOG_WARN
  • Constructor Summary

    Constructors
    Constructor
    Description
    Constructor.
  • Method Summary

    Modifier and Type
    Method
    Description
    call(String accessName, Object[] inputValues, com.denodo.vdb.misc.IContext context)
    Method which executes the stored procedure.
    boolean
    Returns true if the field names defined by the stored procedure are case sensitive.
    void
    Deprecated.
    As of Denodo 5.5, this method is deprecated because it is never invoked.
    void
    The Execution Engine invokes this method to confirm the current transaction.
    static final Array
    createArray(Collection<? extends Object> values, int type)
    Creates a SQL array object.
    static final Struct
    createStruct(List<String> fieldNames, List<? extends Object> values)
    Creates a SQL struct object.
    protected abstract void
    doCall(Object[] inputValues)
    The Execution Engine invokes this method when this procedure is called.
    If the procedure has to return results, invoke getProcedureResultSet from this method, to obtain an object of the class StoredProcedureResultSet, which will contain the results that this procedure will return.
    Returns the parameters created by this procedure when it was created.
    com.denodo.vdb.interpreter.parser.ElementType
     
     
    int
    Deprecated.
    As of Denodo 5.5, this method is deprecated because its result is not used.
    Obtains the execution result of the stored procedure.
     
    void
    Initializes the stored procedure.
    final void
    log(int level, String logMessage)
    Log a message.
    void
    The Execution Engine invokes this method when it is about to begin a transaction involving this procedure.
    void
    The Execution Engine invokes this method to undo the current transaction.
    final void
     
    void
    setUse60TypeMappings(Boolean use60TypeMappings)
     
    boolean
    The Execution Engine invokes this method when a query involving the stored procedure is cancelled.

    Methods inherited from class com.denodo.vdb.catalog.storage.MetaObjectStored

    copyPropertiesToObject, exists, existsObjectByNameIgnoringCase, findByPublicName, findByPublicName, findByPublicName, findByPublicName, findIdByName, findIdsByName, getCreateDate, getCreateDateAsMillis, getElementDescription, getId, getIdByPublicName, getIdByPublicName, getJars, getLastUserModifier, getName, getPublicNameById, getPublicNameByIds, getSessionWorkspace, getUserCreator, initialize, renameMetaObjectStored, setCreateDate, setElementDescription, setId, setLastUserModifier, setName, setUserCreator, storeRenamedMetaObject

    Methods inherited from class com.denodo.vdb.catalog.storage.MetadataObject

    getLatestModificationDate, getLatestModificationDateAsMillis, getLatestModificationEpoch, getLatestModificationInstant, setLatestModificationDate, setLatestModificationEpoch

    Methods inherited from class java.lang.Object

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

    Methods inherited from interface com.denodo.vdb.engine.storedprocedure.StoredProcedure

    getDescription, getName

    Methods inherited from interface com.denodo.vdb.engine.storedprocedure.StoredProcedureExecutor

    getParameters