openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-730) Error when I add "ORDER BY count(f.report.id)" to my query
Date Fri, 19 Sep 2008 18:46:44 GMT

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

Michael Dick commented on OPENJPA-730:
--------------------------------------

The ORDER BY clause takes a field name as an argument ie SELECT p from Person p ORDER BY p.accounts.
It doesn't accept an aggregate function like COUNT (or SUM, etc). 

I believe this is a limitation of JPQL in JPA 1.0. 

> 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