Internal Website Search

11-20 of 200 resultsRefresh

DELETE Queries in JPA/JPQL

to the database by calling the commit method. JPQL DELETE queries provide an alternative way for deleting entity objects. Unlike query/jpql/select">SELECT queries, which are used to retrieve data from the database, DELETE queries do not

UPDATE SET Queries in JPA/JPQL

> method. JPQL UPDATE queries provide an alternative way of updating entity objects. Unlike query/jpql/select">SELECT queries, which are used to retrieve data from the database, UPDATE queries do not retrieve data from the database

Criteria Query From Elements

The interfaces in this group are in use for setting a criteria query FROM clause. Criteria Query Variables The query/jpql/from">FROM clause in JPA queries (as in SQL) defines the query variables. Query variables are represented in

Criteria Query Selection and Results

BY 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: query/criteria/select" select="Selection">

Chapter 4 - JPA Queries (JPQL / Criteria)

The JPA Query Language (JPQL) can be considered as an object oriented version of SQL ... queries in JPA, based on JPQL. The first section describes the API that JPA provides for using dynamic and static (named) queries. It explains how to use the relevant interfaces, annotations

Date and Time in JPQL and Criteria Queries

Date and time expressions may appear in JPQL queries: as query/jpql/literal#date_and_time_literals">date and time literals - e.g. {d '2011-12-31'}, {t '23:59:59'}. as query/parameter

Numbers in JPQL and Criteria Queries

Numeric values may appear in JPQL queries in many forms: as query/jpql/literal#numeric_literals">numeric literals - e.g. 123, -12.5. as query/parameter">parameters

Literals in JPQL and Criteria Queries

>). JPQL literals should be used sparingly as queries that use query ... JPQL queries when a single constant value is always used and never replaced. query/jpql/comparison">Comparison Operators page

Strings in JPQL and Criteria Queries

String values may appear in JPQL queries in various forms: as query/jpql/literal#string_literals">string literals - e.g. 'abc', ''. as query/parameter">parameters - when string values

Collections in JPQL and Criteria Queries

Collections may appear in JPQL queries: as query/parameter">parameters - when collections are assigned as arguments. as query/jpql/path">path expressions - in navigation to persistent collection fields