Home » Search

About GROUP BY

41-50 of 200Refresh
JDO Doc
12

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

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
12

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
JPA Doc
12

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
11

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
11

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
9

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

Support for roles/groups in ObjectDB

ObjectDB should incorporate roles/group in ObjectDB config file? I see no support for this. I would like to place several users under a given group or role, but I see no way of doing this as ... , there could be a role/group element which would categorise the user further. This would help in authentication.   Thanks st.clair.clarke