About GROUP BY

31-40 of 200Refresh
JPA Doc
16

Criteria Query Selection and Results

The JPA Criteria API interfaces in this group are in use for setting the SELECT and ORDER BY ... clause in a criteria query is represented by Selection: Because Selection is a super interface ... expressions can be represented by CompoundSelection, which is itself a subinterface of Selection
JDO Doc
16

javax.jdo.PersistenceManager

the PersistenceManagerFactory (recommended) or by construction. Since: JDO 1.0   void ... JDOUserException if the instance is transient or is managed by another PersistenceManager. Parameters: pc ... for detachment (DETACH_LOAD_FIELDS and DETACH_UNLOAD_FIELDS) and the active fetch groups determine the scope
Manual
16

DELETE Queries in JPA/JPQL

cannot include multiple variables and JOIN, and cannot include the GROUP BY, HAVING and ORDER BY clauses ... As explained in chapter 2, entity objects can be deleted from the database by: Retrieving ... transaction, either explicitly by calling the remove method or implicitly by a cascading operation
Manual
16

JPA Criteria API Queries

, construct). FROM clause (from, join, fetch). WHERE clause (where). GROUP BY / HAVING clauses (groupBy ... , are defined by instantiation of Java objects that represent query elements. A major advantage of using ... factory of criteria queries and criteria query elements. It can be obtained either by
Manual
16

UPDATE SET Queries in JPA/JPQL

queries cannot include the GROUP BY, HAVING and ORDER BY clauses, but the WHERE clause ... Existing entity objects can be updated, as explained in chapter 2, by: Retrieving the entity ... . Applying changes to the database by calling the commit method. JPQL UPDATE queries provide
Manual
16

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

queries cannot include the GROUP BY, HAVING and ORDER BY clauses, but the WHERE clause ... Existing entity objects can be updated, as explained in chapter 2, by: Retrieving the entity ... . Applying changes to the database by calling the commit method. JPQL UPDATE queries provide
Manual
15

JPA Persistence Unit

A JPA Persistence Unit is a logical grouping of user defined persistable classes (entity classes ... is optional when using ObjectDB, but required by JPA. persistence.xml Persistence units are defined in ... -unit> A persistence unit is defined by a persistence-unit XML element
JPA Doc
15

Criteria Query From Elements

The interfaces in this group are in use for setting a criteria query FROM clause. Criteria Query ... are represented in criteria queries by descendant interfaces of the From interface: Range variables (bound by an entity class) are represented by the Root subinterface: Join variables (bound by
Tutorial
14

Getting Started with JPA

to start by running a live sample application in your IDE, you should be able to follow this tutorial
Manual
13

JPA Query Expressions (JPQL / Criteria)

Query expressions are the foundations on which JPQL and criteria queries are built. Every query consists of clauses - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and each clause consists ... of at least one atomic component. More complex query expressions are built by combining atomic