persistence@glassfish.java.net

setFirstResult/setMaxResults in memory?

From: Marina Vatkina <Marina.Vatkina_at_Sun.COM>
Date: Mon, 18 Dec 2006 13:04:18 -0800

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