page iterator using entity bean

Hi,

In our project, we want to provide page by page iteraor to client on 
records in our database. The number of records in database may be 
millions.

We want to know whether or not it is possible to use CMP entity beans 
(not JDBC) to model the record so that the transactions can still be 
managed by the container (each client may insert/delete records 
during their iterating)? We didn't find iterating support from EJBQL 
so don't know how to config the findByXxx method to support the 
iterating.

Jason