About JPQL

11-20 of 145Refresh
Manual
137

ORDER BY clause (JPQL / Criteria API)

The ORDER BY clause specifies a required order for the query results. Any JPQL query that does not ... , any JPQL expression whose type is comparable (i.e. numbers, strings and date values) and is derived ... are more restrictive. Path expressions are supported by all the JPA implementations but support of other JPQL
Manual
137

Logical Operators in JPQL and Criteria API

Logical operators in JPQL and in JPA criteria queries enable composition of complex JPQL boolean expressions out of simple JPQL boolean expressions. Logical Operators ObjectDB supports 2 sets of logical operators, as shown in the following table: Set 1 - JPQL / SQL Set 2 - Java / JDO AND && OR
Manual
131

Paths and Types in JPQL and Criteria API

classes) are represented in JPQL by the following types of expressions: Variables - FROM ... . But more often they are used in JPQL path expressions that navigate to values of simple types (number, boolean ... JPQL, the current FROM variable (or FROM tuple when there are multiple variables) is simply skipped
Manual
131

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 ... expressions - in navigation to persistent date and time fields. as results of predefined JPQL current date and time functions. Current Date and Time JPA defines special JPQL expressions
Manual
131

Collections in JPQL and Criteria Queries

Collections may appear in JPQL queries: as parameters - when collections are assigned as arguments ... enables as an extension to standard JPQL to use both operators (IN and MEMBER OF) with any type ... Expressions JPQL collection operators and functions (which are described above) are available also as JPA
Manual
131

Strings in JPQL and Criteria Queries

String values may appear in JPQL queries in various forms: as string literals - e.g. 'abc', ''. as ... to persistent string fields. as results of predefined JPQL string manipulation functions. LIKE - String ... operator). Criteria Query String Expressions JPQL string operators and functions (which are described
Manual
127

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 parameters - when numeric values are assigned as arguments. as path expressions - in navigation ... of any type and always returns a double value. Criteria Query Arithmetic Expressions JPQL
Manual
122

DELETE Queries in JPA/JPQL

. Applying changes to the database by calling the commit method. JPQL DELETE queries provide
Manual
122

UPDATE SET Queries in JPA/JPQL

Existing entity objects can be updated, as explained in chapter 2, by: Retrieving the entity objects into an EntityManager. Updating the relevant entity object fields within an active transaction. Applying changes to the database by calling the commit method. JPQL UPDATE queries provide
Manual
122

UPDATE SET Queries in JPA/JPQL [2011-11-22]

Existing entity objects can be updated, as explained in chapter 2, by: Retrieving the entity objects into an EntityManager. Updating the relevant entity object fields within an active transaction. Applying changes to the database by calling the commit method. JPQL UPDATE queries provide