persistence@glassfish.java.net

Re: setFirstResult/setMaxResults in memory?

From: Tom Ware <tom.ware_at_oracle.com>
Date: Wed, 20 Dec 2006 09:39:10 -0500

Hi Marina,

  Thanks for passing this on.

  I replied.

-Tom

Marina Vatkina wrote:

>Resending with a jar attachment.
>
>-marina
>
>Marina Vatkina wrote:
>
>
>>Tom,
>>
>>Does TLE perform setFirstResult/setMaxResults operations in
>>memory instead of pushing it to the database? My slightly
>>modified example from the entity-persistence web page (attached)
>>shows that while the result is correct, the query reads the
>>whole table into memory (verified via log level FINE).
>>
>>Is it a bug?
>>
>>thanks,
>>-marina
>>
>>

-- 
Tom Ware
Principal Software Engineer
Oracle Canada Inc.
Direct: (613) 783-4598
Email: tom.ware_at_oracle.com