openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nareshs <naresh4co...@gmail.com>
Subject Re: [jira] Resolved: (OPENJPA-730) Error when I add "ORDER BY count(f.report.id)" to my query
Date Mon, 07 Sep 2009 10:07:01 GMT

Hi ,

I am experiencing the same for Order By Upper x.name.
Is this also addressed in the fix. 

JIRA jira@apache.org wrote:
> 
> 
>      [
> https://issues.apache.org/jira/browse/OPENJPA-730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
> ]
> 
> Michael Dick resolved OPENJPA-730.
> ----------------------------------
> 
>     Resolution: Later
> 
> Since the issue is a question, and unfortunately the answer is no, I'm
> resolving the issue. If this is a useful feature to add please re-open and
> mark as a New Feature. Thanks. 
> 
>> 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.
> 
> 
> 

-- 
View this message in context: http://n2.nabble.com/jira-Created-OPENJPA-730-Error-when-I-add-ORDER-BY-count-f-report-id-to-my-query-tp1099837p3596437.html
Sent from the OpenJPA Developers mailing list archive at Nabble.com.

Mime
View raw message