About query

11-20 of 200Refresh
Manual
97

JPA Query Structure (JPQL / Criteria)

The syntax of the Java Persistence Query Language (JPQL) is very similar to the syntax of SQL. Having a SQL like syntax in JPA queries is an important advantage because SQL is a very powerful query ... classes and objects. For example, a JPQL query can retrieve and return entity objects
Manual
97

UPDATE SET Queries in JPA/JPQL

. Applying changes to the database by calling the commit method. JPQL UPDATE queries provide an alternative way for updating entity objects. Unlike SELECT queries, which are used to retrieve data from the database, UPDATE queries do not retrieve data from the database, but when executed, update
Manual
97

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

. Applying changes to the database by calling the commit method. JPQL UPDATE queries provide an alternative way for updating entity objects. Unlike SELECT queries, which are used to retrieve data from the database, UPDATE queries do not retrieve data from the database, but when executed, update
Manual
90

JPA Query Expressions (JPQL / Criteria)

Query expressions are the foundations on which JPQL and criteria queries are built. Every query ... of JPQL / Criteria query expressions. Atomic Expressions The atomic query expressions are: JPQL / Criteria Variables JPQL / Criteria Parameters JPQL / Criteria Literals Every query expression consists
Manual
90

Chapter 4 - JPA Queries (JPQL / Criteria) [2011-04-01]

The JPA Query Language (JPQL) can be considered as an object oriented version of SQL. Users ... well as how to use the JPA Criteria API, which provides an alternative way for building queries in JPA ... (named) queries. It explains how to use the relevant interfaces, annotations, enums and methods
Manual
90

Chapter 4 - JPA Queries (JPQL / Criteria)

The JPA Query Language (JPQL) can be considered as an object oriented version of SQL. Users ... well as how to use the JPA Criteria API, which provides an alternative way for building queries in JPA ... (named) queries. It explains how to use the relevant interfaces, annotations, enums and methods
JPA Doc
89

Criteria Query From Elements

The interfaces in this group are in use for setting a criteria query FROM clause. Criteria Query Variables The FROM clause in JPA queries (as in SQL) defines the query variables. Query variables are represented in criteria queries by descendant interfaces of the From interface: Range variables
JPA Doc
89

Criteria Query Selection and Results

clauses and for representing query results as tuples. SELECT Clause Elements The content of the SELECT clause in a criteria query is represented by Selection: Because Selection is a super interface ... : See the SELECT in Criteria Queries section for more details and examples. ORDER BY Clause Elements Elements in
Manual
86

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 ... that are evaluated to the date and time on the database server when the query is executed: CURRENT_DATE ... in Criteria Queries The CriteriaBuilder interface provides three factory methods for building date
Manual
83

Literals in JPQL and Criteria Queries

literals should be used sparingly as queries that use parameters instead of literals ... values. Literals should only be embedded in JPQL queries when a single constant value is always used ... adds support for enum literals. Enum literals in JPQL queries use the ordinary Java syntax for enum