ObjectDB Database Search

for the query execution. The flush mode type applies to the query regardless of the flush mode type in use for the entity manager. Parameters: flushMode - flush mode Returns: the same query instance. Since: Jakarta Persistence (JPA) 1.0

setTimeout (    Integer timeout ) Set the query timeout, in milliseconds. This is a hint, and is an alternative to setting the hint jakarta.persistence. query .timeout . Parameters: timeout - the timeout, in milliseconds, or null to indicate no timeout Returns: the same query instance. Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery boolean isDistinct() Return whether duplicate query results must be eliminated or retained. Returns: boolean indicating whether duplicate query results must be eliminated. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery Class getResultType() Return the result type of the query or subquery. If a result type was specified as an argument to the createQuery or subquery method, that type is returned. If the query was created using

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaQuery createQuery (    Class resultClass ) Create a CriteriaQuery object with the given result type. Parameters: resultClass - type of the query result Returns: criteria query object. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaUpdate createCriteriaUpdate (    Class targetEntity ) Create a CriteriaUpdate query object to perform a bulk update operation. Parameters: targetEntity - target type for update operation Returns: the query object. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaDelete createCriteriaDelete (    Class targetEntity ) Create a CriteriaDelete query object to perform a bulk delete operation. Parameters: targetEntity - target type for delete operation Returns: the query object. Since: Jakarta Persistence (JPA) 2.1

that is applied to the results of the query execution. If the constructor is for an entity class, the resulting entities will be in the new state after the query is executed. Parameters: selections - arguments

object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query . Deprecated: Newly-written code

. Parameters: name - parameter name value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or

- temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or if the value argument

value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or if the value argument

: param - parameter object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query . Since: Jakarta Persistence (JPA) 1.0

- parameter object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query . Deprecated: Newly-written

during query execution. This cache retrieval mode overrides the cache retrieve mode in use by the entity manager. Parameters: cacheRetrieveMode - cache retrieval mode Returns: the same query instance. Since: Jakarta Persistence (JPA) 3.2

during query execution. This cache storage mode overrides the cache storage mode in use by the entity manager. Parameters: cacheStoreMode - cache storage mode Returns: the same query instance. Since: Jakarta Persistence (JPA) 3.2

. Parameters: position - position value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or

- temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or if the value argument

type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or if the value argument

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery Root from (    Class entityClass ) Create and add a query root corresponding to the given entity, forming a cartesian product with any existing roots. Parameters: entityClass - the entity class Returns: query

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery Root from (    EntityType entity ) Create and add a query root corresponding to the given entity, forming ... the entity of type X Returns: query root corresponding to the given entity. Since: Jakarta Persistence (JPA) 1.0

over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions ... - list of zero or more grouping expressions Returns: the modified query . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery AbstractQuery having (    Expression restriction ) Specify a restriction over the groups of the query ... boolean expression Returns: the modified query . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery AbstractQuery having (    Predicate... restrictions ) Specify restrictions over the groups of the query ... are simply removed. Parameters: restrictions - zero or more restriction predicates Returns: the modified query . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery AbstractQuery having (    List restrictions ) Specify restrictions over the groups of the query according ... removed. Parameters: restrictions - a list of zero or more restriction predicates Returns: the modified query . Since: Jakarta Persistence (JPA) 3.2

over the query results. Replaces the previous specified grouping expressions, if any. If no grouping ... : grouping - zero or more grouping expressions Returns: the modified query . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Root correlate (    Root parentRoot ) Create a subquery root correlated to a root of the enclosing query . Parameters: parentRoot - a root of the containing query Returns: subquery root. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Join correlate (    Join parentJoin ) Create a subquery join object correlated to a join object of the enclosing query . Parameters: parentJoin - join object of the containing query Returns: subquery join. Since: Jakarta Persistence (JPA) 1.0

correlated to a collection join object of the enclosing query . Parameters: parentCollection - join object of the containing query Returns: subquery join. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Subquery having (    List restrictions ) Specify restrictions over the groups of the query according ... : restrictions - a list of zero or more restriction predicates Returns: the modified query . Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery CommonAbstractCriteria getContainingQuery() Return the query of which this is a subquery. This may be a CriteriaQuery, CriteriaUpdate, CriteriaDelete, or a Subquery. Returns: the enclosing query or subquery. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery SetJoin correlate (    SetJoin parentSet ) Create a subquery set join object correlated to a set join object of the enclosing query . Parameters: parentSet - join object of the containing query Returns: subquery join. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery ListJoin correlate (    ListJoin parentList ) Create a subquery list join object correlated to a list join object of the enclosing query . Parameters: parentList - join object of the containing query Returns: subquery join. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery MapJoin correlate (    MapJoin parentMap ) Create a subquery map join object correlated to a map join object of the enclosing query . Parameters: parentMap - join object of the containing query Returns: subquery join. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery AbstractQuery getParent() Return the query of which this is a subquery. This must be a CriteriaQuery or a Subquery. Returns: the enclosing query or subquery. Since: Jakarta Persistence (JPA) 1.0

to a positional parameter. Parameters: position - position value - parameter value Returns: the same query ... parameter of the query or if the argument is of incorrect type. Since: Jakarta Persistence (JPA) 1.0

- position temporalType - temporal type value - parameter value Returns: the same query instance ... of the query or if the value argument is of incorrect type. Deprecated: Newly-written code should use

- position temporalType - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or

type param - parameter object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query . Deprecated

to a named parameter. Parameters: name - parameter name value - parameter value Returns: the same query ... of the query or if the argument is of incorrect type. Since: Jakarta Persistence (JPA) 1.0

- parameter name temporalType - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query

temporalType - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or

mode that is in effect during query execution. This cache retrieval mode overrides the cache retrieve ... : the same query instance. Since: Jakarta Persistence (JPA) 3.2

that is in effect during query execution. This cache storage mode overrides the cache storage mode in use by the entity manager. Parameters: cacheStoreMode - cache storage mode Returns: the same query instance. Since: Jakarta Persistence (JPA) 3.2

we have a query like this: SELECT a.endDate,a.objectsInCharge.nodePath,a.objectsInCharge ... .properties.doubleValue In the class Action we have a combined index (see attachment) but in the query plan we can see that this index is not used: Query Plan Description ====================== Step 1: Process

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery Selection getSelection() Return the selection of the query , or null if no selection has been set. Returns: selection item. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery List getGroupList() Return a list of the grouping expressions. Returns empty list if no grouping expressions have been specified. Modifications to the list do not affect the query . Returns: the list of grouping expressions. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaQuery createQuery() Create a CriteriaQuery object. Returns: criteria query object. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CommonAbstractCriteria Subquery subquery (    Class type ) Create a subquery of the query . Parameters: type - the subquery result type Returns: subquery. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CommonAbstractCriteria Subquery subquery (    EntityType type ) Create a subquery of the query . Parameters: type - the subquery result type Returns: subquery. Since: Jakarta Persistence (JPA) 1.0