About jpql

11-20 of 136Refresh
Manual
136

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
130

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
130

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
130

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
130

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
126

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
121

DELETE Queries in JPA/JPQL

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

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
121

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

JPA Annotations for JPQL Queries

The following annotations are used to define static named JPA queries: The JPA Named Queries section of the ObjectDB Manual explains and demonstrates how to use these annotations to define named JPQL queries.