ObjectDB Database Search

the building blocks for defining query logic programmatically. The hierarchy of the expression interfaces is structured as follows: Selection # Base interface for result items └─ Expression # Base interface for expressions ├─ Predicate # Boolean expression (WHERE/HAVING) │ └─ CriteriaBuilder.In # IN

JPQL and criteria queries are built on query expressions . Every query consists of clauses ... Criteria API expressions . Atomic expressions The atomic query expressions are: JPQL / Criteria Variables JPQL / Criteria Parameters JPQL / Criteria Literals Every query expression consists

is useful for pattern matching with regular expressions , which are more powerful than the LIKE operator ... ' and '' . As parameters when string values are passed as query arguments. As path expressions ... a path expression ), and the right operand is the pattern (usually a parameter or literal). For example

FROM Country c JOIN FETCH c.capital The JOIN FETCH expression is not a regular JOIN , and it does not ... (you can use type expression to exclude descendant classes from iteration). For example, in ... range variable that serves as a root and additional join variables that are bound to path expressions

expression in SELECT clauses. Specifying the required query results more precisely can improve ... must always be specified explicitly. JPQL does not support the the SELECT * expression , which is common in SQL. Projection of path expressions JPQL queries can also return results that are not entities. For example

Date and time expressions can appear in JPQL queries in the following ways: As date and time ... are passed as arguments. As path expressions --to navigate to persistent date and time fields. As ... JPA defines special JPQL expressions that return the date and time from the database server

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 ... the expression false. If one operand is NULL and the other is TRUE or NULL , the result is NULL

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 Expression sumAsLong (    Expression x ) Create an aggregate expression applying the sum operation to an Integer-valued expression , returning a Long result. Parameters: x - expression representing input

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsDouble (    Expression x ) Create an aggregate expression applying the sum operation to a Float-valued expression , returning a Double result. Parameters: x - expression representing input

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Order asc (    Expression expression ) Create an ordering by the ascending value of the expression . Parameters: expression - expression used to define the ordering Returns: ascending ordering corresponding to the expression . Since: Jakarta Persistence (JPA) 1.0

(    Expression expression ) Create an ordering by the descending value of the expression . Parameters: expression - expression used to define the ordering Returns: descending ordering corresponding to the expression . Since: Jakarta Persistence (JPA) 1.0

;  Expression expression ,    Nulls nullPrecedence ) Create an ordering by the ascending value of the expression . Parameters: expression - expression used to define the ordering nullPrecedence - the precedence of null values Returns: ascending ordering corresponding to the expression . Since: Jakarta Persistence (JPA) 3.2

(    Expression expression ,    Nulls nullPrecedence ) Create an ordering by the descending value of the expression . Parameters: expression - expression used to define the ordering nullPrecedence - the precedence of null values Returns: descending ordering corresponding to the expression . Since: Jakarta Persistence (JPA) 3.2

;  Expression ... grouping ) Specify the expressions that are used to form groups over the subquery results. Replaces the previous specified grouping expressions , if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method

groupBy (    Expression ... grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions , if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. Parameters

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 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

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Subquery select (    Expression expression ) Specify the item that is to be returned as the subquery result. Replaces the previously specified selection, if any. Parameters: expression - expression specifying

;  Expression restriction ) Modify the subquery to restrict the result according to the specified boolean expression . Replaces the previously added restriction(s), if any. This method ... compound boolean expression Returns: the modified subquery. Since: Jakarta Persistence (JPA) 1.0

where (    Expression restriction ) Modify the query to restrict the query results according to the specified boolean expression . Replaces the previously added restriction(s), if any. Parameters: restriction - a simple or compound boolean expression Returns: the modified query. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CollectionJoin CollectionJoin on (    Expression restriction ) Modify the join to restrict the result according ... . Parameters: restriction - a simple or compound boolean expression Returns: the modified join object. Since: Jakarta Persistence (JPA) 2.1

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.SetJoin SetJoin on (    Expression restriction ) Modify the join to restrict the result according to the specified ... - a simple or compound boolean expression Returns: the modified join object. Since: Jakarta Persistence (JPA) 2.1

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

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.ListJoin ListJoin on (    Expression restriction ) Modify the join to restrict the result according to the specified ... : restriction - a simple or compound boolean expression Returns: the modified join object. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Join Join on (    Expression restriction ) Modify the join to restrict the result according to the specified ON condition ... - a simple or compound boolean expression Returns: the modified join object. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.MapJoin MapJoin on (    Expression restriction ) Modify the join to restrict the result according to the specified ... - a simple or compound boolean expression Returns: the modified join object. Since: Jakarta Persistence (JPA) 2.1

is passed as an argument. As path expressions when navigating to a persistent collection field. IS [NOT ... 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

: Unexpected query expression end (non keyword identifier is expected)] with root cause com.objectdb.o.UserException: Unexpected query expression end (non keyword identifier is expected) at com.objectdb.o ... thread "main" [ObjectDB 2.5.6_05] javax.persistence.PersistenceException Unexpected query expression

CONDITIONS OF ANY KIND, either express or implied, including, without limitation, any warranties or

) . getResultList (); You can invoke these methods in a single expression with getResultList

IS" without a warranty of any kind. All express or implied representations and warranties, including any

must: be a non- abstract regular Java class, or a Java record type, have a public or protected constructor

groupBy (    List grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions , if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. Parameters: grouping

;  List grouping ) Specify the expressions that are used to form groups over the subquery results. Replaces the previous specified grouping expressions , if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method only overrides

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.ListJoin Expression index() Create an expression that corresponds to the index of the object in the referenced association or element ... element collection for which an order column has been defined. Returns: expression denoting the index. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Order Expression getExpression() Return the expression that is used for ordering. Returns: expression used for ordering. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.MapJoin Expression entry() Create an expression that corresponds to the map entry. Returns: expression corresponding to the map entry. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Path Expression type() Create an expression corresponding to the type of the path. Returns: expression corresponding to the type of the path. Since: Jakarta Persistence (JPA) 1.0

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 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.Subquery Expression getSelection() Return the selection expression . Returns: the item to be returned in the subquery result. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Path Expression get (    MapAttribute map ) Create a path corresponding to the referenced map-valued attribute. Parameters: map - map-valued attribute Returns: expression corresponding to the referenced attribute. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Path Expression get (    PluralAttribute collection ) Create a path corresponding to the referenced collection-valued attribute. Parameters: collection - collection-valued attribute Returns: expression corresponding to the referenced attribute. Since: Jakarta Persistence (JPA) 1.0

. Returns: list of boolean expressions forming the predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.MapJoin Path key() Create a path expression that corresponds to the map key. Returns: path corresponding to map key. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.MapJoin Path value() Create a path expression that corresponds to the map value. This method is for stylistic use only: it just returns this. Returns: path corresponding to the map value. Since: Jakarta Persistence (JPA) 1.0