ObjectDB ObjectDB

Internal Website Search

1-10 of 200 resultsRefresh

Strings in JPQL and Criteria Queries

when there is a need for pattern matching using regular expressions (which are more powerful than the LIKE ... 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

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.

FROM clause (JPQL / Criteria API)

The JOIN FETCH expression is not a regular JOIN and it does not define a JOIN variable. Its only purpose ... at the WHERE clause level by using a type expression. For example, in the following query, c iterates ... expressions. Join variables can also be bound to path expressions that are based on other join variables

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


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

[ODB1] Chapter 7 - JDOQL Queries

comparison using regular expressions (a possible replacement to the like operator of SQL). To use methods ... a persistent class) A filter, which is a boolean expression in a Java like syntax The query result ... other optional components, such as parameters, variables and import and order expressions

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