Home » Search

About JPQL

11-20 of 133Refresh
Manual
175

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
175

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
175

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
175

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
170

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
165

DELETE Queries in JPA/JPQL

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

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

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.
Manual
60

GROUP BY and HAVING clauses

The GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns ... clause. When a GROUP BY clause exists in a JPQL query, database objects (or tuples of database objects ... the first letters as result. ObjectDB is very flexible in allowing JPQL expressions anywhere in
JPA Doc
55

JPA Queries

these interfaces to build and run JPQL queries. The TypedQuery interface (or alternatively the older Query interface) is the only neccessary interface for defining and running string based JPQL queries (e.g ... concatenating JPQL strings into a valid complete JPQL query. JPA 2 introduced the JPA Criteria Query API, as