About GROUP BY

41-50 of 200Refresh
Issue
12

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

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
11

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
JDO Doc
11

javax.jdo.Query

: group - a comma-delimited list of expressions, optionally followed by the "having" keyword ... with a PersistenceManager. Multiple queries might be executed simultaneously by different threads ... , import statements, ordering and grouping specifications, result and result class, the range
JPA Doc
11

JPA 2 Annotations

JPA defines dozens of annotations that can be divided into the following groups: Annotations for JPA aware classes: Annotations for fields in JPA persistable classes: Annotations for additional JPA ... between a relational database and an object model and for direct SQL queries): These ORM annotations are silently ignored by ObjectDB.
JDO Doc
10

javax.jdo.PersistenceManagerFactory

addFetchGroups( FetchGroup... groups) Add the FetchGroups to the set of active fetch groups. Add the FetchGroups to the set of active fetch groups. FetchGroups are made unmodifiable before being added ... , removeFetchGroups, getFetchGroups, and removeAllFetchGroups are internally serialized. Parameters: groups
JDO Doc
10

javax.jdo.spi.PersistenceCapable

javax.jdo.spi Interface PersistenceCapable A class that can be managed by a binary-compatible JDO ... environment. The Reference Enhancer also adds code to implement the methods defined by PersistenceCapable. The extra methods in the PersistenceCapable interface might be generated by pre-processing a .java
JDO Doc
9

javax.jdo.FetchGroup

the default fetch group via the API does not affect the members defined by this category. Using ... javax.jdo Interface FetchGroup FetchGroup represents a named fetch group for a specific class or interface. A fetch group instance identifies the name of the class or interface, the list of members
JPA Doc
8

javax.persistence.criteria.Subquery

< Expression> getGroupList() Return a list of the grouping expressions. Return a list of the grouping expressions. Returns empty list if no grouping expressions have been specified. Modifications to the list do not affect the query. Returns: the list of grouping expressions Since: JPA 2.0 Predicate
Forum
7

Help with JPA2 Criteria and conditional operator grouping

)              )));   System.out.println("Query: " + c); But I can can never get the grouping to occur ... persistence.xml shows the grouping happening. I've had to dumb down the domain model ... and for the test case. Please try build 2.2.8_04 that should fix the bug. That fixed the conditional grouping