Jpql - order by sum ??? [message #556047] |
Mon, 30 August 2010 16:29 |
No real name Messages: 3 Registered: August 2010 |
Junior Member |
|
|
MYSQL
JAVA EE 6
JPA 2
Hello,
i want get a list of "Video Objects" from DB order by Desc how much(good) they are rated.
VideoRatingEntity
@ManyToOne()
@JoinColumn(name = "VIDEO_ID")
videoEntity
ID | VIDEO_ID| USER_ID| RATING
--------------------------------
Video Entity
@OneToMany
videoRatingEntities
ID | ... | ... |
-------------
My Try:
"SELECT v, sum(vrr) "
+ " FROM VideoEntity AS v"
+ " JOIN v.videoRatingEntities AS vr"
+ " JOIN vr.rating AS vrr"
+ " GROUP BY v"
+ " ORDER BY sum(vrr) DESC";
EXCEPTION:
SCHWERWIEGEND: java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager:
Exception Description: Syntax error parsing the query [SELECT v, sum(vrr) FROM VideoEntity AS v JOIN v.videoRatingEntities AS vr JOIN vr.rating AS vrr GROUP BY v ORDER BY sum(vrr) DESC].
Internal Exception: org.eclipse.persistence.internal.libraries.antlr.runtime.Ear lyExitException
Hope someone can help.
[Updated on: Mon, 30 August 2010 16:37] Report message to a moderator
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03039 seconds