Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (athena.apache.org: domain of kwsutter@gmail.com designates
 209.85.218.224 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=wKJc+xJervMWZ3J9xQZRi9iaCB+0qCR4QBAf2Yo9zRnuQfanTpTATuXV3ZuEB9Pt6H
         FP6EaigYJgDyxee5VHj9FMJvsIFlACvx0KJIsFfMQHLV9kcoaHZwp8XAhTuyBmIYP1VH
         J5VubRbM06vChaRKnK3iUSL9lTNL2aqu4Dzfo=
MIME-Version: 1.0
In-Reply-To: <000301cab222$bb64fb70$322ef250$@com>
References: <014d01cab169$f43d4920$dcb7db60$@com>
	 <d486f41c1002190555v3350f89fpd7fb83de15e984ba@mail.gmail.com>
	 <015c01cab203$3f95ac20$bec10460$@com>
	 <f374e8991002200332l39d01bfu5e370f9a5488b00d@mail.gmail.com>
	 <000301cab222$bb64fb70$322ef250$@com>
Date: Mon, 22 Feb 2010 08:19:05 -0600
Message-ID: <89c0c52c1002220619p5ee8db41r993111b71086bbda@mail.gmail.com>
Subject: Re: Query confusion
From: Kevin Sutter <kwsutter@gmail.com>
To: users@openjpa.apache.org, cnd@cndavies.com
Content-Type: multipart/alternative; boundary=00032555971e9e72c90480311d6e

--00032555971e9e72c90480311d6e
Content-Type: text/plain; charset=ISO-8859-1

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
>
>
>
>
>
>

--00032555971e9e72c90480311d6e--