openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "teto (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-730) Error when I add "ORDER BY count(f.report.id)" to my query
Date Fri, 19 Sep 2008 01:10:44 GMT
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