On Fri, Feb 19, 2010 at 8:46 AM, C N Davies <[email protected]> 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:[email protected]

Reply via email to