openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Sutter (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-730) Error when I add "ORDER BY count(f.report.id)" to my query
Date Fri, 11 Sep 2009 13:20:57 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12754120#action_12754120
] 

Kevin Sutter commented on OPENJPA-730:
--------------------------------------

>From Pinaki on the dev mailing list...

Try aliasing:

SELECT  f.report.id,count(f.report.id) as c FROM FavReports f, User u,
Report r WHERE f.report.id=r.id and  f.user.id = u.id and UPPER(u.userName)=
UPPER('USERNAME1') GROUP BY f.report.id  ORDER BY c DESC



> Error when I add "ORDER BY count(f.report.id)"  to my query
> -----------------------------------------------------------
>
>                 Key: OPENJPA-730
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-730
>             Project: OpenJPA
>          Issue Type: Question
>          Components: query
>    Affects Versions: 1.0.0
>         Environment: WIN
>            Reporter: teto
>
> I'm getting error when i added  "ORDER BY count(column) " to my  JPQL query.
>  ERROR:
> ----------------
> <openjpa-1.0.0-r420667:568756 nonfatal user error> org.apache.openjpa.persistence.ArgumentException:
An error occurred while parsing the query filter 'SELECT  f.report.id FROM FavReports f, User
u, Report r WHERE f.report.id=r.id and  f.user.id = u.id and UPPER(u.userName)= UPPER('USERNAME1')
GROUP BY f.report.id  ORDER BY count(f.report.id) DESC'. 
> Error message: <openjpa-1.0.0-r420667:568756 nonfatal user error> org.apache.openjpa.kernel.jpql.ParseException:
Encountered "count" at character 175, but expected: [<IDENTIFIER>].
> 	at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.parse(JPQLExpressionBuilder.java:1666)
> ++++++++++++++++++++++
> The query :
> ------------
> String jpql = "SELECT  f.report.id FROM FavReports f, User u, Report r WHERE f.report.id=r.id
and  f.user.id = u.id and UPPER(u.userName)= UPPER('" + userName
> 				+ "') GROUP BY f.report.id  ORDER BY count(f.report.id) DESC";
> Does JPQL support the  ORDER BY COUNT(id)   ????????

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message