ObjectDB ObjectDB

Internal Website Search

1-10 of 200 resultsRefresh

JPA Query Expressions (JPQL / Criteria)

Query expressions are the foundations on which JPQL and criteria queries are built. Every query ... of JPQL / Criteria query expressions. Atomic Expressions The atomic query expressions are: JPQL / Criteria Variables JPQL / Criteria Parameters JPQL / Criteria Literals Every query expression consists

Criteria Query Expressions

The following interfaces are in use in representing general expressions in criteria queries: See the Query Expressions section for more details and examples.

Numbers in JPQL and Criteria Queries

parameters - when numeric values are assigned as arguments. as path expressions - in navigation to persistent numeric fields. as aggregate expressions - e.g. COUNT. as collection functions ... .g. LOCATE, LENGTH. as composite arithmetic expressions that use operators and functions to combine


javax.persistence.criteria Interface Expression<T> Superinterfaces: Selection<T>, TupleElement<T ... , ParameterExpression, Path, PluralJoin, Predicate, Root, SetJoin, Subquery Type for query expressions. Since: JPA 2.0 Learn how to use JPA Criteria API's Expression in Chapter 4 of the ObjectDB/JPA manual

Strings in JPQL and Criteria Queries

parameters - when string values are assigned as arguments. as path expressions - in navigation ... for a match (usually a path expression) and the right operand is always the pattern (usually a parameter or ... '%\%' ESCAPE '\' is evaluated to FALSE. In the expressions above only the first percent character


Method javax.persistence.criteria.Expression Expression<X> as( Class<X> type ) Perform a typecast upon the expression, returning a new expression object. This method does not cause type conversion ... - intended type of the expression Returns: new expression of the given type Since: JPA 2.0


Method javax.persistence.criteria.CriteriaBuilder SimpleCase<C,R> selectCase( Expression<?> expression ) Create a simple case expression. Parameters: expression - to be tested against the case conditions Returns: simple case expression Since: JPA 2.0


Method javax.persistence.criteria.Subquery Subquery<T> select( Expression<T> expression ) Specify the item that is to be returned as the subquery result. Replaces the previously specified selection, if any. Parameters: expression - expression specifying the item that is to be returned as


Method javax.persistence.criteria.CriteriaBuilder In<T> in( Expression<?> expression ) Create predicate to test whether given expression is contained in a list of values. Parameters: expression - to be tested against list of values Returns: in predicate Since: JPA 2.0


Method javax.persistence.criteria.Expression Predicate in( Expression... values ) Create a predicate to test whether the expression is a member of the argument list. Parameters: values - expressions to be tested against Returns: predicate testing for membership Since: JPA 2.0

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support