Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Reply-To: <cnd@cndavies.com>
From: "C N Davies" <cnd@cndavies.com>
To: "'catalina wei'" <catalina.wei@gmail.com>,
	<users@openjpa.apache.org>
References: <014d01cab169$f43d4920$dcb7db60$@com>
	 <d486f41c1002190555v3350f89fpd7fb83de15e984ba@mail.gmail.com>
	 <015c01cab203$3f95ac20$bec10460$@com>
 <f374e8991002200332l39d01bfu5e370f9a5488b00d@mail.gmail.com>
In-Reply-To: <f374e8991002200332l39d01bfu5e370f9a5488b00d@mail.gmail.com>
Subject: RE: Query confusion
Date: Sat, 20 Feb 2010 22:49:11 +1100
Organization: C N Davies Pty Ltd
Message-ID: <000301cab222$bb64fb70$322ef250$@com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0004_01CAB27E.EED57370"
Thread-Index: AcqyIG4jEbKa8mdFRmS/YXUV+GywYwAAIDbw
Content-Language: en-au

------=_NextPart_000_0004_01CAB27E.EED57370
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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


------=_NextPart_000_0004_01CAB27E.EED57370--