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: local policy)
Message-ID: <4AEAAFD8.4050504@optitool.de>
Date: Fri, 30 Oct 2009 10:20:24 +0100
From: Michael Simons <michael.simons@optitool.de>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
To: users@openjpa.apache.org
Subject: Re: Limit the size of the projection of a query
References: <4AE9DB38.6050201@optitool.de>
 <278211.30459.qm@web55906.mail.re3.yahoo.com>
In-Reply-To: <278211.30459.qm@web55906.mail.re3.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

I beg your pardon for asking such a RTFM. I'm wondering how I could have missed that.

Thanks, Michael

Fay Wang schrieb:
> You can call the following API to limit the number of rows returned by the query:
> 
>      Query.setMaxResults(maxResults);
> 
> 
> 
> 
> ----- Original Message ----
> From: Michael Simons <michael.simons@optitool.de>
> To: users@openjpa.apache.org
> Sent: Thu, October 29, 2009 11:13:12 AM
> Subject: Limit the size of the projection of a query
> 
> Hello,
> 
> Is there a way in JPA or OpenJPA to limit the number of rows returned by a query?
> In our formerly used JDO-Implementation there was a function called maxrows doing so.
> I know there are several databases that support a limitation of the projection.
> But how can I achieve this in JPA?
> 
> Kind Regards,
> Michael