This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Is this type of group by query possible in JPA ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Is this type of group by query possible in JPA ?" Watch "Is this type of group by query possible in JPA ?" New topic
Author

Is this type of group by query possible in JPA ?

Dave Mark
Greenhorn

Joined: Feb 21, 2004
Posts: 19
Taking the query from this website as an example :is it possible to do something like this ?I've shortened it down everything to a minimum while still showing the result I'm looking for (and yes I know it doesn't work!).

What I have at the moment is something like the following...So is there anyway of getting closer to what I'm after?
Will a projection help me?
Or will I always have to iterate over the result to sort it?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Is this type of group by query possible in JPA ?
 
Similar Threads
Join Fetch using EclipseLink
JPQL help
JPQL Question with Left Join
EJB3.0 persistence API
JPA Query using " where in" and setParameter