About query

manual

Date and Time in JPQL and Criteria Queries

Shows how date and time can be used in JPQL queries.... to the date and time on the database server when the query is executed: CURRENT_DATE - is evaluated to the ... JPA interface Type for query expressions. See JavaDoc Reference Page... <javax. sql . ... JPA interface Type for query expressions. See JavaDoc Reference Page... <javax. sql . ...

 
manual

Strings in JPQL and Criteria Queries

Explains string expressions in JPQL queries, including LIKE, LOCATE, LOWER, UPPER, TRIM, CONCAT and SUBSTRING.... String Methods (ObjectDB Extension) Criteria Query String Expressions LIKE - String Pattern Matching ... powerful than the LIKE operator). Criteria Query String Expressions JPQL string operators and functions (which are ...

 
manual

CRUD Database Operations with JPA

Shows how to use Java/JPA to store, retrieve, update & delete.... of Point objects in the database by using a simple query: Query javax.persistence.Query JPA interface Interface used to ...

 
manual

Literals in JPQL and Criteria Queries

Describes literals in JPQL, including null, false, true, numbers, strings, dates enums and types.... Entity Type Literals Criteria Query Literals The NULL literal ... Page... annotation element. Criteria Query Literals The CriteriaBuilder ... JPA interface Type for query expressions. See JavaDoc Reference Page... <Boolean> t ...

 
manual

Collections in JPQL and Criteria Queries

Shows how collections and maps can be used in JPQL queries.... MEMBER [OF] [NOT] IN Criteria Query Collection Expressions IS [NOT] EMPTY The ... collections, such as a collection that is passed to the query as a parameter. For example: 'English' ...

 
manual

GROUP BY and HAVING clauses

Explains how to use the GROUP BY and HAVING clauses in a JPA/JPQL query. The GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns properties of generated groups instead of ... fields. The position of a GROUP BY clause in the query execution order is after the FROM and WHERE clauses, but before the ...

 
api-jpa

javax.persistence.criteria.CriteriaQuery

The CriteriaQuery interface defines functionality that is specific to top-level queries.(Interface of JPA)

 
manual

ORDER BY clause (JPQL / Criteria API)

Explains how to use the ORDER BY clause in a JPA/JPQL query.... The ORDER BY clause specifies a required order for the query results. Any JPQL query that does not include an ORDER BY clause produces results in an undefined ...

 
api-jpa

getParameters()

Get the parameter objects corresponding to the declared parameters of the query.(Method of javax.persistence.Query)

 
manual

JPA Query Expressions (JPQL / Criteria)

Describes JPA query (JPQL / Criteria API) expressions (literals, operators and functions). Query expressions are the foundations on which JPQL and criteria queries are built. Every query consists of clauses - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and each clause consists of JPQL / Criteria query expressions. Atomic Expressions The atomic query ...