About named queries

31-40 of 200Refresh
Manual
33

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
JPA Doc
32

Criteria Query From Elements

The interfaces in this group are in use for setting a criteria query FROM clause. Criteria Query Variables The FROM clause in JPA queries (as in SQL) defines the query variables. Query variables are represented in criteria queries by descendant interfaces of the From interface: Range variables
JPA Doc
32

Criteria Query Selection and Results

clauses and for representing query results as tuples. SELECT Clause Elements The content of the SELECT clause in a criteria query is represented by Selection: Because Selection is a super interface ... : See the SELECT in Criteria Queries section for more details and examples. ORDER BY Clause Elements Elements in
Manual
31

Date and Time in JPQL and Criteria Queries

Date and time expressions may appear in JPQL queries: as date and time literals - e.g. {d '2011-12 ... that are evaluated to the date and time on the database server when the query is executed: CURRENT_DATE ... in Criteria Queries The CriteriaBuilder interface provides three factory methods for building date
Manual
31

ORDER BY clause (JPQL / Criteria API)

Expressions The following query returns names of countries whose population size ... . The following query returns Country objects ordered by currency as the primary sort key and by name as ... The ORDER BY clause in the above query orders the results by the currency name. Without an ORDER BY clause
Manual
30

Collections in JPQL and Criteria Queries

Collections may appear in JPQL queries: as parameters - when collections are assigned as arguments ... , which should be used for checking other collections, such as a collection that is passed to the query ... of collection, so in ObjectDB these operators are treated as synonyms. Criteria Query Collection
Manual
30

Numbers in JPQL and Criteria Queries

Numeric values may appear in JPQL queries in many forms: as numeric literals - e.g. 123, -12.5. as ... of any type and always returns a double value. Criteria Query Arithmetic Expressions JPQL arithmetic operators and functions (which are described above) are available also as JPA criteria query
Manual
30

GROUP BY and HAVING clauses

(which does not use aggregates) is equivalent to the following query: SELECT DISTINCT SUBSTRING(c.name, 1 ... SUBSTRING(c.name, 1, 1); The query returns Object[] arrays of length 3, in which the first cell ... The GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns
JPA Doc
29

JPA Annotations for SQL Queries

The following JPA annotations are designated for SQL queries on relational databases: ObjectDB supports only the preferred JPA query language, JPQL, and silently ignores all the above annotations.
JPA Doc
29

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.