About JPQL

21-30 of 145Refresh
JPA Doc
122

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
44

JPA Criteria API Queries

for building dynamic queries whose exact structure is only known at runtime. JPA Criteria API vs JPQL JPQL queries are defined as strings, similarly to SQL. JPA criteria queries, on the other hand ... . On the other hand, for many developers string based JPQL queries, which are very similar to SQL
Manual
33

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
Result
31

ObjectDB Object Database Features [2018-01-27]

- JPQL and JDOQL. Query Languages JPQL - Java Persistence (JPA) Query Language - SQL like syntax. JDOQL ... (including INNER JOIN, LEFT OUTER JOIN and JOIN FETCH). WHERE (with both JPQL and JDOQL expressions ... , &&, ||). Arithmetic operators & functions (+, -, *, /, %, ABS, SQRT, MOD). JPQL string operators & functions
Result
31

ObjectDB Object Database Features [2018-10-27]

- JPQL and JDOQL. Query Languages JPQL - Java Persistence (JPA) Query Language - SQL like syntax. JDOQL ... (including INNER JOIN, LEFT OUTER JOIN and JOIN FETCH). WHERE (with both JPQL and JDOQL expressions ... , &&, ||). Arithmetic operators & functions (+, -, *, /, %, ABS, SQRT, MOD). JPQL string operators & functions
Result
31

ObjectDB Object Database Features

the application. Query Support ObjectDB supports two object-oriented query languages - JPQL and JDOQL. Query Languages JPQL - Java Persistence (JPA) Query Language - SQL like syntax. JDOQL - Java Data Objects (JDO ... OUTER JOIN and JOIN FETCH). WHERE (with both JPQL and JDOQL expressions). GROUP BY (including HAVING
JPA Doc
28

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
Manual
26

JPA Query API

, the same JPQL query which retrieves all the Country objects in the database is represented by both q1 ... because it introduces the Country class to ObjectDB. Dynamic JPQL, Criteria API and Named Queries Building queries by passing JPQL query strings directly to the createQuery method, as shown
Manual
23

CRUD Database Operations with JPA [2011-02-11]

persisting objects in the database in more detail. JPA Queries with JPQL We can get the number of Point ... SQL you should find the syntax very familiar. JPQL, the JPA query language, supports a SQL like ... objects from the database using JPA. Running a JPQL query is one of them: TypedQuery query
Manual
23

CRUD Database Operations with JPA

persisting objects in the database in more detail. JPA Queries with JPQL We can get the number of Point ... SQL you should find the syntax very familiar. JPQL, the JPA query language, supports a SQL like ... objects from the database using JPA. Running a JPQL query is one of them: TypedQuery query