ObjectDB Database Search

JPA Interface Subquery Type Parameters: - the type of the selection item. Super Interfaces: AbstractQuery , CommonAbstractCriteria , Expression , Selection , TupleElement The Subquery interface defines functionality that is specific to subqueries . A subquery has an expression as its selection item

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

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

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Predicate exists (    Subquery   subquery ) Create a predicate testing the existence of a subquery result. Parameters: subquery - subquery whose result is to be tested Return: exists predicate Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression all (    Subquery   subquery ) Create an all expression over the subquery results. Parameters: subquery - subquery Return: all expression Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression any (    Subquery   subquery ) Create an any expression over the subquery results. This expression is equivalent to a some expression. Parameters: subquery - subquery Return: any expression Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression some (    Subquery   subquery ) Create a some expression over the subquery results. This expression is equivalent to an any expression. Parameters: subquery - subquery Return: some expression Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. Subquery Subquery select (    Expression  expression ) Specify the item that is to be returned as the subquery result. Replaces ... that is to be returned as the subquery result Return: the modified subquery Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. Subquery Set getCorrelatedJoins () Return the correlated joins of the subquery . Returns empty set if the subquery has no correlated joins. Modifications to the set do not affect the query. Return: the correlated joins of the subquery Since: JPA 2.0

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 . Return: the enclosing query or subquery Since: JPA 2.1

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 . Return: the enclosing query or subquery Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. Subquery Subquery having (   Predicate... restrictions ) Specify restrictions over the groups of the subquery according the conjunction ... - zero or more restriction predicates Return: the modified subquery Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. Subquery Subquery having (    Expression  restriction ) Specify a restriction over the groups of the subquery . Replaces the previous having ... AbstractQuery method. Parameters: restriction - a simple or compound boolean expression Return: the modified subquery Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. Subquery Subquery groupBy (   List  grouping ) Specify the expressions that are used to form groups over the subquery results. Replaces ... of the corresponding AbstractQuery method. Parameters: grouping - list of zero or more grouping expressions Return: the modified subquery Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. Subquery Subquery distinct (   boolean distinct ) Specify whether duplicate query results are eliminated. A true value will cause duplicates ... results must be eliminated from the subquery result or whether they must be retained Return: the modified subquery . Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. Subquery Subquery groupBy (    Expression ... grouping ) Specify the expressions that are used to form groups over the subquery results ... type of the corresponding AbstractQuery method. Parameters: grouping - zero or more grouping expressions Return: the modified subquery Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. Subquery Subquery where (   Predicate... restrictions ) Modify the subquery to restrict the result according to the conjunction ... more restriction predicates Return: the modified subquery Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. Subquery Subquery where (    Expression  restriction ) Modify the subquery to restrict the result according to the specified boolean ... type of the corresponding AbstractQuery method. Parameters: restriction - a simple or compound boolean expression Return: the modified subquery Since: JPA 2.0

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 Return: subquery join Since: JPA 2.0

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 Return: subquery join Since: JPA 2.0

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 Return: subquery join Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. Subquery CollectionJoin correlate (    CollectionJoin  parentCollection ) Create a subquery collection join object correlated to a collection join object of the enclosing query. Parameters: parentCollection - join object of the containing query Return: subquery join Since: JPA 2.0

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 Return: subquery root Since: JPA 2.0

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 Return: subquery join Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. Subquery Expression getSelection () Return the selection expression. Return: the item to be returned in the subquery result Since: JPA 2.0

JPA Method in jakarta.persistence.criteria. Subquery Subquery where (   List  restrictions ) Modify the query to restrict the query result according to the conjunction of the specified restriction predicates. Replaces the previously added restriction(s), if any. If no restrictions

JPA Method in jakarta.persistence.criteria. Subquery Subquery having (   List  restrictions ) Specify restrictions over the groups of the query according the conjunction of the specified restriction predicates. Replaces the previously added having restriction(s), if any

Subquery error

- expression Return: absolute value Since: JPA 2.0 Expression all ( Subquery   subquery ) Create an all expression over the subquery results. Parameters: subquery - subquery Return: all expression ... : and predicate Since: JPA 2.0 Expression any ( Subquery   subquery ) Create an any expression

queries and subqueries . It is not intended to be used directly in query construction. All queries ... 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

that is common to both top-level criteria queries and subqueries as well as to update and delete ... . Return: where clause predicate Since: JPA 2.1 Subquery subquery (Class  type) Create a subquery of the query. Parameters: type - the subquery result type Return: subquery Since: JPA 2.1 Subquery

Subquery subquery (Class  type) Create a subquery of the query. Parameters: type - the subquery result type Return: subquery Inherited from: CommonAbstractCriteria Since: JPA 2.1 Subquery subquery ( EntityType  type) Create a subquery of the query. Parameters: type - the subquery result type

Since: JPA 2.1 Subquery subquery (Class  type) Create a subquery of the query. Parameters: type - the subquery result type Return: subquery Inherited from: CommonAbstractCriteria Since: JPA 2.1 Subquery subquery ( EntityType  type) Create a subquery of the query. Parameters: type

The JPQL (Java Persistence Query Language) supports defining subqueries , which are nested queries that are embedded in other queries. Subqueries are currently not supported by ObjectDB, and as a workaround, you can use a sequence of two or more queries, where the results of one query serves as a parameter in the next queries. support Support

Subqueries (nested queries) have been added to JDOQL (JDO Query Language) in JDO 2.1. This is the main feature of JDO 2.0-2.1-2.2 that is not implemented yet in ObjectDB 2. support Support

() 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 ... . These are the roots that are defined for the CriteriaQuery or Subquery itself, including any subquery roots

has been obtained through correlation (use of Subquery .correlate method). Return: the parent of the correlated ... object has been obtained as a result of correlation (use of a Subquery .correlate method). Return

JPA Method in jakarta.persistence.criteria.AbstractQuery Set getRoots () Return the query roots. These are the roots that are defined for the CriteriaQuery or Subquery itself, including any subquery roots defined as a result of correlation. Returns an empty set if no roots have been defined

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 the createTupleQuery method

object has been obtained through correlation (use of Subquery .correlate method). Return: the parent ... of a Subquery .correlate method). Return: boolean indicating whether the object has been obtained

HUBERT Subqueries are currently not supported. The workaround in this case (which could also provide much better performance than subqueries ) is to maintain a reference to the last label directly in every RO object. support Support

over result set with setFirstResult and setMaxResults. I could do this with subqueries , however as I understand it from this post: http://www.objectdb.com/database/issue/10, subqueries are not supported by

Subqueries are not support by ObjectDB yet - see this feature request . Getting an OutOfMemoryError ... You do not get the point. I ask a way to subquery in #1. You suggest splitting it into two query in #2. I

As mentioned elsewhere, subqueries are not currently supported.  A subquery is the way that seems recommended to get only the latest entry in a time series (e.g. the latest time-clock entry for all employees).   Is there an ObjectDB way to get the latest entry in a series? 

operator is currently not supported and will be implemented with subqueries  (since its main use is in subqueries ). The following code demonstrates how to use MEMBER OF with parameter for this purpose

JPA Method in jakarta.persistence.criteria.From From getCorrelationParent () Returns the parent From object from which the correlated From object has been obtained through correlation (use of Subquery .correlate method). Return: the parent of the correlated {@code From} object Throws

JPA Method in jakarta.persistence.criteria.From boolean isCorrelated () Whether the From object has been obtained as a result of correlation (use of a Subquery .correlate method). Return: boolean indicating whether the object has been obtained through correlation Since: JPA 2.0

system . Subqueries are currently not supported by ObjectDB also for JPA, and could be added to JPA

by ObjectDB. They are listed in the issue tracking system , and unfortunately subqueries

JPQL features are not supported yet by ObjectDB. The main missing feature is subqueries