Pagination

jadam · **Joined:** Mon Apr 21, 2008 5:07 pm **Posts:** 6

Hello folks,

I have a general question if it is possible to use pagination inside of an ejb2.
Taken the example of the book "Java Persistence with Hibernate" (p 618):

Code:

Query query =
session.createQuery("from User u order by u.name asc")
.setMaxResults(10);
Criteria crit =
session.createCriteria(User.class)
.addOrder( Order.asc("name") )
.setFirstResult(40)
.setMaxResults(20);

So we would use maxResults = 20. And we would like to retrieve 2000
datasets which would mean 100 calls to the ejb. Is something like that
possible? What one needs to do not to loose the transaction if it is AS
based? What needs to be configured ..

Thanks a lot

Cameron McKenzie · **Posted:** Mon Jul 21, 2008 10:36 pm

Well, it sounds like each of the 100 calls would run as a separate transaction, right? There's no guarantee that some of those transactions might not fail at some point. I mean, that's why we have transactions - because we know that databases fail, but at least a transaction allows our data to remain consistent (ACID).

What I might do it use a stateful session bean, SFSB, to keep track of which iterations have occured. If any fail, it can rerun that Hibernate query.

Just an idea. Hope it helps you Hibernate!