Class ProcedureQuery

  • All Implemented Interfaces:
    Serializable, ParameterizedQuery, Query

    public class ProcedureQuery
    extends AbstractQuery
    implements ParameterizedQuery
    A query based on Procedure. Can be used as a select query, or as a query of an arbitrary complexity, performing data modification, selecting data (possibly with multiple result sets per call), returning values via OUT parameters.

    Execution with DataContext

    Reading OUT parameters

    If a ProcedureQuery has OUT parameters, they are wrapped in a separate List in the query result. Such list will contain a single Map with OUT parameter values.

    Using ProcedureQuery as a GenericSelectQuery

    Executing ProcedureQuery via DataContext.performQuery(Query) makes sense only if the stored procedure returns a single result set (or alternatively returns a result via OUT parameters and no other result sets). It is still OK if data modification occurs as a side effect. However if the query returns more then one result set, a more generic form should be used: DataContext.performGenericQuery(Query).

    See Also:
    Serialized Form
    • Field Detail

      • resultEntityName

        protected String resultEntityName
        Since:
        1.2
      • resultClass

        protected Class<?> resultClass
        Since:
        1.2
      • columnNamesCapitalization

        protected CapsStrategy columnNamesCapitalization
    • Method Detail

      • getResultDescriptors

        public List<ColumnDescriptor[]> getResultDescriptors()
        Returns a List of descriptors for query ResultSets in the order they are returned by the stored procedure.

        Note that if a procedure returns ResultSet in an OUT parameter, it is returned prior to any other result sets (though in practice database engines usually support only one mechanism for returning result sets.

        Since:
        1.2
      • addResultDescriptor

        public void addResultDescriptor​(ColumnDescriptor[] descriptor)
        Adds a descriptor for a single ResultSet. More than one descriptor can be added by calling this method multiple times in the order of described ResultSet appearance in the procedure results.
        Since:
        1.2
      • removeResultDescriptor

        public void removeResultDescriptor​(ColumnDescriptor[] descriptor)
        Removes result descriptor from the list of descriptors.
        Since:
        1.2
      • initWithProperties

        public void initWithProperties​(Map<String,​?> properties)
        Initializes query parameters using a set of properties.
        Since:
        1.1
      • createQuery

        public Query createQuery​(Map<String,​?> parameters)
        Creates and returns a new ProcedureQuery built using this query as a prototype and substituting template parameters with the values from the map.
        Specified by:
        createQuery in interface ParameterizedQuery
        Since:
        1.1
      • getBaseMetaData

        protected org.apache.cayenne.query.BaseQueryMetadata getBaseMetaData()
        Specified by:
        getBaseMetaData in class CacheableQuery
      • getFetchLimit

        public int getFetchLimit()
      • setFetchLimit

        public void setFetchLimit​(int fetchLimit)
      • getFetchOffset

        public int getFetchOffset()
        Since:
        3.0
      • setFetchOffset

        public void setFetchOffset​(int fetchOffset)
        Since:
        3.0
      • getPageSize

        public int getPageSize()
      • setPageSize

        public void setPageSize​(int pageSize)
      • setFetchingDataRows

        public void setFetchingDataRows​(boolean flag)
      • isFetchingDataRows

        public boolean isFetchingDataRows()
      • addParameter

        public void addParameter​(String name,
                                 Object value)
        Adds a named parameter to the internal map of parameters.
        Since:
        1.1
      • removeParameter

        public void removeParameter​(String name)
        Since:
        1.1
      • getParameters

        public Map<String,​?> getParameters()
        Returns a map of procedure parameters.
        Since:
        1.1
      • setParameters

        public void setParameters​(Map<String,​?> parameters)
        Sets a map of parameters.
        Since:
        1.1
      • clearParameters

        public void clearParameters()
        Cleans up all configured parameters.
        Since:
        1.1
      • removePrefetch

        public void removePrefetch​(String prefetch)
        Since:
        1.2
      • addPrefetches

        public void addPrefetches​(Collection<String> prefetches)
        Adds all prefetches from a provided collection.
        Since:
        1.2
      • clearPrefetches

        public void clearPrefetches()
        Clears all prefetches.
        Since:
        1.2
      • getResultEntityName

        public String getResultEntityName()
        Since:
        1.2
      • setResultEntityName

        public void setResultEntityName​(String resultEntityName)
        Since:
        1.2
      • getColumnNamesCapitalization

        public CapsStrategy getColumnNamesCapitalization()
        Since:
        3.0
      • setColumnNamesCapitalization

        public void setColumnNamesCapitalization​(CapsStrategy columnNameCapitalization)
        Since:
        3.0
      • setStatementFetchSize

        public void setStatementFetchSize​(int size)
        Sets statement's fetch size (0 for no default size)
        Since:
        3.0
      • getStatementFetchSize

        public int getStatementFetchSize()
        Returns:
        statement's fetch size
        Since:
        3.0