[
https://issues.apache.org/jira/browse/OPENJPA-730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12632931#action_12632931
]
Milosz Tylenda commented on OPENJPA-730:
----------------------------------------
Yes, from what I can understand from JPQL grammar, the query is not correct:
orderby_clause ::= ORDER BY orderby_item {, orderby_item}*
orderby_item ::= state_field_path_expression [ ASC | DESC ]
state_field_path_expression ::= {identification_variable |
single_valued_association_path_expression}.state_field
single_valued_association_path_expression ::=
identification_variable.{single_valued_association_field.}*
single_valued_association_field
> 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.
