Mailing-List: contact open-jpa-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: open-jpa-dev@incubator.apache.org
Received-SPF: pass (hermes.apache.org: domain of lists@nabble.com designates
 72.21.53.35 as permitted sender)
Message-ID: <8255331.post@talk.nabble.com>
Date: Wed, 10 Jan 2007 02:39:34 -0800 (PST)
From: wanyna <wanyna@hotmail.com>
To: open-jpa-dev@incubator.apache.org
Subject: Re: How to write it in JPQL
In-Reply-To: <2540A260-4A9A-40C3-B982-383F9C19B19C@apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
References: <8253611.post@talk.nabble.com>
 <2540A260-4A9A-40C3-B982-383F9C19B19C@apache.org>


There are two tables A and B, I need to execute sql like 
"insert into A select ... from B".
I use JPQL Constructor Expressions,
select new A(...) from B, got A list then persist.
But some data of A depends on program context, not from B, for simple
example:
select new A(B.column1, 'xxx') from B,
select new A(null, B.column2) from B,
select new A(variable, B.column2) from B

I have to get the result object[] list and constuct A in my code now.
I hope JPQL Constructor Expressions became more powerful, my code will be
more simple then.


Marc Prud wrote:
> 
> 
> 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.
>>
> 
> 
> 

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