74 | Numbers in JPQL and Criteria QueriesNumeric values may appear in JPQL queries in many forms: as numeric literals - e.g. 123, -12.5. as ... numeric promotion principles. For example, the resulting type of a binary arithmetic operation on an int ... an integer value. If the two operands share exactly the same type the result type is the same |
73 | Strings in JPQL and Criteria QueriesString 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 |
59 | SELECT clause (JPQL / Criteria API)> results = query.getResultList(); Because the results are managed entity objects they have all the support ... objects, transparent update detection, support for delete, etc. Query results are not limited to entity ... . Specifying the required query results more precisely can improve performance and in some cases |
39 | JPA QueriesQueries are represented in JPA by the Query and TypedQuery interfaces: The JPA Query API section ... 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 |
39 | DELETE Queries in JPA/JPQL. Applying changes to the database by calling the commit method. JPQL DELETE queries provide an alternative way for deleting entity objects. Unlike SELECT queries, which are used to retrieve data from the database, DELETE queries do not retrieve data from the database, but when executed, delete specified |
38 | UPDATE SET Queries in JPA/JPQL. Applying changes to the database by calling the commit method. JPQL UPDATE queries provide an alternative way of 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 |
36 | 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 |
36 | 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 |
36 | Criteria Query From ElementsThe 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 |
4 | javax.jdo.Query. There are three required elements in a Query: the class of the results, the candidate collection ... of results, and flags indicating whether the query result is unique and whether the query can be modified ... conflict with parameter names. The result of the query by default is a list of result class instances |
