Class MappedSelect<T>

java.lang.Object
org.apache.cayenne.query.IndirectQuery
org.apache.cayenne.query.AbstractMappedQuery
org.apache.cayenne.query.MappedSelect<T>
All Implemented Interfaces:
Query, Select<T>
public class MappedSelect<T> extends AbstractMappedQuery implements Select<T>
A query that represents a named parameterized selecting query stored in the mapping. The actual query is resolved during execution.
Since:
4.0

  • Field Details

    • resultClass

      protected Class<T> resultClass

    • fetchLimit

      protected Integer fetchLimit

    • fetchOffset

      protected Integer fetchOffset

    • statementFetchSize

      protected Integer statementFetchSize

    • queryTimeout

      protected Integer queryTimeout

    • pageSize

      protected Integer pageSize

    • forceNoCache

      protected boolean forceNoCache

  • Constructor Details

    • MappedSelect

      protected MappedSelect(String queryName)

    • MappedSelect

      protected MappedSelect(String queryName, Class<T> resultClass)

  • Method Details

    • query

      public static <T> MappedSelect<T> query(String queryName, Class<T> rootClass)
      Loads query with the given name, which selects objects of a given persistent class, from the mapping configuration.
      Parameters:
      queryName - name of the mapped query
      rootClass - the Class of objects fetched by this query

    • query

      public static MappedSelect<?> query(String queryName)
      Loads query with the given name from the mapping configuration.
      Parameters:
      queryName - name of the mapped query

    • limit

      public MappedSelect<T> limit(int fetchLimit)
      Resets query fetch limit - a parameter that defines max number of objects that should be ever be fetched from the database.

    • offset

      public MappedSelect<T> offset(int fetchOffset)
      Resets query fetch offset - a parameter that defines how many objects should be skipped when reading data from the database.

    • statementFetchSize

      public MappedSelect<T> statementFetchSize(int statementFetchSize)
      Sets fetch size of the PreparedStatement generated for this query. Any non-zero value is passed to the driver as is; 0 (the default) leaves the fetch size to the adapter and the driver. A negative value is only meaningful for drivers that give it a special meaning, such as Integer.MIN_VALUE for streaming on MySQL.
      See Also:

    • queryTimeout

      public MappedSelect<T> queryTimeout(int timeout)
      Sets query timeout for the PreparedStatement generated for this query.
      Since:
      4.2
      See Also:

    • pageSize

      public MappedSelect<T> pageSize(int pageSize)
      Resets query page size. A non-negative page size enables query result pagination that saves memory and processing time for large lists if only parts of the result are ever going to be accessed.

    • forceNoCache

      public MappedSelect<T> forceNoCache()
      Forces query cache to be refreshed during the execution of this query.

    • params

      public MappedSelect<T> params(Map<String,?> parameters)
      Overrides:
      params in class AbstractMappedQuery

    • param

      public MappedSelect<T> param(String name, Object value)
      Overrides:
      param in class AbstractMappedQuery

    • selectFirst

      public T selectFirst(ObjectContext context)
      Description copied from interface: Select
      Selects a single object using provided context. The query itself can match any number of objects, but will return only the first one. It returns null if no objects were matched.

      If it matched more than one object, the first object from the list is returned. This makes 'selectFirst' different from Select.selectOne(ObjectContext), which would throw in this situation. 'selectFirst' is useful e.g. when the query is ordered and we only want to see the first object (e.g. "most recent news article"), etc.

      Selecting the first object via "Select.selectFirst(ObjectContext)" is more comprehensible than selecting via "ObjectContext.selectFirst(Select)", because implementations of "Select" set fetch size limit to one.

      Specified by:
      selectFirst in interface Select<T>

    • createReplacementQuery

      protected Query createReplacementQuery(EntityResolver resolver)
      Description copied from class: IndirectQuery
      Creates a substitute query. An implementor is free to provide an arbitrary replacement query.
      Overrides:
      createReplacementQuery in class AbstractMappedQuery