About GROUP BY

api-jpa

JPA 2 Annotations

Reference (JavaDoc) of all the JPA 2 annotations, including @Entity, @Embeddable, @NamedQuery, @GeneratedValue, etc.... These ORM annotations are silently ignored by ObjectDB. ...

 
api-jdo

detachCopyAll(pcs)

Detach the specified instances from the PersistenceManager.(Method of javax.jdo.PersistenceManager)

 
api-jdo

detachCopyAll(pcs)

Detach the specified instances from the PersistenceManager.(Method of javax.jdo.PersistenceManager)

 
api-jdo

addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameters)

Add a subquery to this query.(Method of javax.jdo.Query)

 
forum_thread

composite index not used in query

we defined a composite index for class Action: @Index(name="ssst",members={"startDate","state","subType","type"}) and an index for the OneToMany @OneToMany(fetch=FetchType.LAZY) @Index  public List<ObjectNode> objectsInCharge = new ArrayList<ObjectNode>(); on running a query like ... ( TC ) ' ) .   Step 4: Group results --------------------- Evaluate aggregate expressions: count ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ...

 
forum_thread

Performance issues on aggregate query

we are using this aggregate query to collect some data: ... and (p5.name = 'intendedBases') group by ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ... names) with the code style (can be applied by ctrl + D). Long stack traces (> 50 lines) and complex ...

 
forum_thread

Nested Collection Query

Hi Sir,    I have a persisted field of the type:   List<List<String>> groupMembers   How do I check if a particular member exist in one of the group? ... How do I check if a particular member exist in one of the group? edit ... directly in another collection, although supported by ObjectDB, is not valid in JPA. Accordingly the JPA query language does not ...

 
manual

JPA Query Expressions (JPQL / Criteria)

Describes JPA query (JPQL / Criteria API) expressions (literals, operators and functions).... Every query consists of clauses - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and each clause consists of JPQL / Criteria query ...

 
forum_thread

How prevent post-compile enhancement of non entity classes

I have recently moved to post-compile enhancement (from automatic run-time enhancement) using an Ant build.xml for a NetBeans web app. My adapted build.xml works for both full project build and per-file compilation (with NetBeans "compile on save" off), but it is not yet perfect at only invoking the enhancer on entity files. For full project build the following works, by grouping entities under clearly named packages: ... files. For full project build the following works, by grouping entities under clearly named packages: <property ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ...

 
forum_thread

Eclipse plugin problem (using ObjectDB as a separate bundle)

Hello support, I have seen multiple attempts to correct similar errors as in the title above - the latest in the 2.2.8.01 release of objectDb. However I still get this error.   Here is my scenario (Groovy 1.8 and Eclipse 3.6) used. I have a com.epimss.lab.data.toxicology.TherapeauticDrugScreenRqst. Nested in this class are the following two classes: com.epimss.lab.data.misc.OtherRqst and com.epimss.lab.data.misc.RequestDateAndNumber. ... In an attempt to isoloate the problem I cleaned by project, and enhanced with ObjectDB with the small utility class ... Hello, Make certain the Group items by category is selected at the bottom of the page. ...