ObjectDB Database Search

in criteria queries The criteria query API provides several ways to set the SELECT clause. Single ... it as the SELECT clause content, overriding any previously set SELECT content. Many valid criteria API expressions can be used as a selection because criteria API expressions are represented by Expression

criteria queries FROM query identification variables are represented in criteria queries by ... by the Join interface (and its subinterfaces). Criteria query roots The CriteriaQuery 's from method ... a criteria query by using the following code: CriteriaQuery q = cb. createQuery (Country.class); Root

Logical operators in JPQL and JPA criteria queries combine simple Boolean expressions to form complex expressions. Logical operators ObjectDB supports two sets of logical operators, as shown in ... for NOT . Criteria query logical operators Boolean expressions and predicates In criteria queries

Criteria API expressions. Atomic expressions The atomic query expressions are: JPQL / Criteria Variables ... with operators and functions. Operators and functions JPQL and the Criteria API support the following ... the following pages: Detailed explanations of how to build Criteria API expressions are provided

Jakarta Persistence (JPA) Criteria API uses a hierarchy of interfaces to model query conditions and selections, enabling the construction of dynamic, type-safe queries. These interfaces represent the building blocks for defining query logic programmatically. The hierarchy of the expression

. Criteria query string expressions Query String Expressions The JPQL string operators and functions that are described above are also available as JPA criteria query expressions. The CriteriaBuilder ... demonstrates, most methods are overloaded to support optional arguments and to accept both simple Java objects and criteria expressions.

. Date and time in criteria queries The CriteriaBuilder interface provides three factory methods ... criteria queries by using the generic CriteriaBuilder 's function method, as follows: // Create

are synonyms. Criteria query collection expressions The JPQL collection operators and functions are also available as JPA criteria query expressions. The CriteriaBuilder interface provides factory

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .Path Path get (    String attributeName ) Create a path corresponding to the referenced attribute. Note: Applications using the string-based API may need to specify the type resulting from the Path.get operation in order

: ObjectDB is unique in supporting the standard APIs . It is the only object database with built in support for the Java Persistence API (JPA). It also supports a more recent and advanced version of the Java Data Objects (JDO) API than competing object databases. By using a standard API such as JPA

, that is scheduled for removal from the database upon transaction commit. The EntityManager API is used ... a native SQL query. In the next release of this API , the return type of this method will change ... for executing a criteria query. Parameters: criteriaQuery - a criteria query object Returns: the new

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder CriteriaSelect union (    CriteriaSelect left ,    CriteriaSelect right ) Create a query which is the union of the given queries. Returns: a new criteria query which returns the union

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder CriteriaSelect unionAll (    CriteriaSelect left ,    CriteriaSelect right ) Create a query ... criteria query which returns the union of the results of the given queries. Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder CriteriaSelect intersect (    CriteriaSelect left ,    CriteriaSelect right ) Create a query which is the intersection of the given queries. Returns: a new criteria query which returns

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder CriteriaSelect intersectAll (    CriteriaSelect left ,    CriteriaSelect right ) Create a query ... : a new criteria query which returns the intersection of the results of the given queries. Since: Jakarta Persistence (JPA) 3.2

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 .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 CriteriaQuery createTupleQuery() Create a CriteriaQuery object that returns a tuple of objects as its result. Returns: criteria query object. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder SetJoin treat (    SetJoin join ,    Class type ) Downcast SetJoin object to the specified type. Parameters: join - SetJoin object type - type to be downcast to Returns: SetJoin object of the specified type. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression nullif (    Expression x ,    Y y ) Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Coalesce coalesce() Create a coalesce expression. Returns: coalesce expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder SimpleCase selectCase (    Expression expression ) Create a simple case expression. Parameters: expression - to be tested against the case conditions Returns: simple case expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Case selectCase() Create a general case expression. Returns: general case expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder ListJoin treat (    ListJoin join ,    Class type ) Downcast ListJoin object to the specified type. Parameters: join - ListJoin object type - type to be downcast to Returns: ListJoin object of the specified type. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder MapJoin treat (    MapJoin join ,    Class type ) Downcast MapJoin object to the specified type. Parameters: join - MapJoin object type - type to be downcast to Returns: MapJoin object of the specified type. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Path treat (    Path path ,    Class type ) Downcast Path object to the specified type. Parameters: path - path type - type to be downcast to Returns: Path object of the specified type. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Root treat (    Root root ,    Class type ) Downcast Root object to the specified type. Parameters: type - type to be downcast to root - root Returns: Root object of the specified type. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .AbstractQuery Predicate getGroupRestriction() Return the predicate that corresponds to the restriction(s) over the grouping items, or null if no restrictions have been specified. Returns: having clause predicate. Since: Jakarta Persistence (JPA) 1.0

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 .CollectionJoin CollectionJoin on (    Expression restriction ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .AbstractQuery AbstractQuery distinct (    boolean distinct ) Specify whether duplicate query results are eliminated. A true value will cause duplicates to be eliminated. A false value will cause duplicates to be retained

Jakarta Persistence (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

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 .CommonAbstractCriteria Predicate getRestriction() Return the predicate that corresponds to the where clause restriction(s), or null if no restrictions have been specified. Returns: where clause predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CommonAbstractCriteria Set getParameters() Return the parameters of the query. Returns empty set if there are no parameters. Modifications to the set do not affect the query. Returns: the query parameters. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CollectionJoin CollectionJoin on (    Predicate... restrictions ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CollectionJoin CollectionAttribute getModel() Return the metamodel representation for the collection attribute. Returns: metamodel type representing the Collection that is the target of the join. 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

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder CompoundSelection tuple (    Selection ... selections ) Create a tuple-valued selection item. Parameters: selections - selection items Returns: tuple-valued compound selection. Throws

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder CompoundSelection tuple (    List selections ) Create a tuple-valued selection item. Parameters: selections - list of selection items Returns: tuple-valued compound selection. Throws

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder CompoundSelection array (    Selection ... selections ) Create an array-valued selection item. Parameters: selections - selection items Returns: array-valued compound selection. Throws

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder CompoundSelection array (    List selections ) Create an array-valued selection item. Parameters: selections - list of selection items Returns: array-valued compound selection. Throws

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

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder CompoundSelection construct (    Class resultClass ,    Selection ... selections ) Create a selection item corresponding to a constructor. This method is used to specify a constructor

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression avg (    Expression x ) Create an aggregate expression applying the avg operation. Parameters: x - expression representing input value to avg operation Returns: avg expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression sum (    Expression x ) Create an aggregate expression applying the sum operation. Parameters: x - expression representing input value to sum operation Returns: sum expression. Since: Jakarta Persistence (JPA) 1.0