openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "C N Davies" <...@cndavies.com>
Subject RE: Query confusion
Date Tue, 23 Feb 2010 02:49:34 GMT
Hi Kevin,

 

I can't find it in the Jira, but I added a comment on last Saturday, I
downloaded the patched version
apache-openjpa-2.0.0-beta\openjpa-all-2.0.0-svn-910423.jar to fix the issue
however it did not fix the other issue of being able to use "+" symbol in my
query.   

 

Chris

 

 

From: Kevin Sutter [mailto:kwsutter@gmail.com] 
Sent: Tuesday, 23 February 2010 1:19 AM
To: users@openjpa.apache.org; cnd@cndavies.com
Subject: Re: Query confusion

 

Hi Chris,
Which classloader issue are you referring to?  

Thanks,
Kevin

On Sat, Feb 20, 2010 at 5:49 AM, C N Davies <cnd@cndavies.com> wrote:

Thanks for the info Catalina,



I would like to switch to OpenJPA 2.0 Beta but I hit one of the open issues
regarding the class loader. So I'm stuck!



Thanks



Chris





From: catalina wei [mailto:catalina.wei@gmail.com]
Sent: Saturday, 20 February 2010 10:33 PM

To: users@openjpa.apache.org; cnd@cndavies.com
Subject: Re: Query confusion



Chris,
sum(dl.bwCount) * dl.bwRate is a scalar expression.
In Java Persistence 1.0 spec, scalar expression is not allowed to appear as
a select item.  That is why you are getting a syntax error.
JPQL in Java Persistence 2.0 spec has updated the syntax and the scalar
expression can be a select item. This support is available in OpenJPA 2.0.x
releases.
Could you try any OpenJPA 2.0.x releases ?

Catalina

On Sat, Feb 20, 2010 at 12:03 AM, C N Davies <cnd@cndavies.com> wrote:

Thanks Daryl,



Pretty obvious, why couldn't I see it!



Now I see my next issue, here is my query truncated down  to the specific
issue:



Select sum(dl.bwCount) * dl.bwRate from DLine as dl;



<openjpa-1.2.1-r752877:753278 nonfatal user error>
org.apache.openjpa.persistence.ArgumentException: Encountered "*" at
character 111, but expected: [",", "FROM"].

    at
org.apache.openjpa.kernel.jpql.JPQL.generateParseException(JPQL.java:9501)



What is wrong with my "*" symbol? It is documented as supported.



I tried like this:



(sum(dl.bwCount) * dl.bwRate)



Same issue L



Thanks!



Chris





From: Daryl Stultz [mailto:daryl@6degrees.com]
Sent: Saturday, 20 February 2010 12:56 AM
To: users@openjpa.apache.org; cnd@cndavies.com
Subject: Re: Query confusion






On Fri, Feb 19, 2010 at 8:46 AM, C N Davies <cnd@cndavies.com> wrote:

Hi,

Select Name, Age, EmailAddress, Weight from com.mypackage.User were Age > 25
Using OpenJPA I only know I can query like this:
Select u from User where Age > 25



You can do this in JPA QL:



select u.name, u.age, u.emailAddress, u.weight from User as u



But getResultList()  will return a list if User entities, but  I only want
specific fields as would be returned by my standard SQL above.



My above example will return an Object[]. Not especially easy to use, a Map
would be nice. But there it is.


--
Daryl Stultz
_____________________________________
6 Degrees Software and Consulting, Inc.
http://www.6degrees.com
mailto:daryl@6degrees.com






 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message