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
15

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
Issue
15

Blocked by find

, Object obj)" method which is synchronized and attempts to load an object by id using the EntityManager ... .ObjectDbInstanceContainer@9c71a4 owned by: DEV1-WSAgent-1-Existing/3 Total blocked: 190 Total waited: 69 ... : BLOCKED on com.objectdb.o.LKM@254e85f4 owned by: ODB-FileWriter Total blocked: 789 Total waited: 616
Manual
15

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
15

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
15

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
15

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
Forum
15

find repeated records by JPQL

. The inner query in #1 contains GROUP BY / HAVING. The outer query in #1 contains the IN operator ... ) Then you doubt the relation between #1 and #3 !!!!!!   Indeed I don't get the point since in #3 there is no GROUP BY / HAVING. gzdillon ... (select id from TTT s group id having count(id)>1) I dont know how to do this using JPQL, but I use
Forum
15

Problem with distinct select, order by and equivalent alias/attribute path

is less restrictive, and will except the query above. However, in DISTINCT and GROUP BY queries it must follow ... when ordering the results of some projection when the order by expression is different (though logically ... _location "             + "order by s_location.id asc";         System.out.println("Working query
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