openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marc Prud'hommeaux <mprud...@apache.org>
Subject Re: How to write it in JPQL
Date Wed, 10 Jan 2007 08:52:00 GMT

On Jan 10, 2007, at 12:12 AM, wanyna wrote:

>
> Hi all.
> I have two questions:
> 1.
> Here is my sql string:
> select 'xxx', TABLE_A.column1 from TABLE_A;
> there is a string 'xxx' as a constant value,
> how to translate it to JPQL?

I don't think it is possible. Why would you need to do that?

> 2.
> Another sql used under oracle:
> select TABLE_A.column1 from TABLE_A where rownum<10;
> how to limit range of result in JPQL or jpa?

Query q = em.createQuery("select ...");
q.setFirstResult(0);
q.setMaxResults(10);
List results = q.getResultList();



> --  
> View this message in context: http://www.nabble.com/How-to-write-it- 
> in-JPQL-tf2951160.html#a8253611
> Sent from the open-jpa-dev mailing list archive at Nabble.com.
>


Mime
View raw message