openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Linskey" <plins...@gmail.com>
Subject Re: Help selecting version column
Date Thu, 24 Jan 2008 16:49:01 GMT
Hi,

Why are you trying to do this? Definitely it looks like this is a bug
in OpenJPA, but generally-speaking it's very cheap to pull back the
rest of the rows in a given record (i.e., select a frmo AnEntity a
where a.id = ?1).

-Patrick

On Jan 24, 2008 7:38 AM, Jeff Melching <jmelch@us.ibm.com> wrote:
> I am trying to select only the version column of an entity to see if it
> was changed.
>
> If I run the following JPQL where verId is the version field of my entity:
>
> select a.verId from AnEntity a where a.id = ?1;
>
> The generated sql is:
>
> SELECT  FROM AN_ENTITY t0 WHERE t0.ID = ?
>
> Obviously, this is invalid sql syntax as the columns to select are
> missing.  I am using a DB2 dictionary.



-- 
Patrick Linskey
202 669 5907

Mime
View raw message