[eclipselink-users] Eclipselink Pagination across sessions

[Rohit Banga <rohit.banga@xxxxxxxxxx>]

Hi All

I was following the documentation available at http://wiki.eclipse.org/Using_Advanced_Query_API_(ELUG)#Handling_Query_Results_Using_Pagination. I wanted to confirm if we can use pagination across sessions?

    For Example:

    query1.setFirstResult(firstResult);

    query1.setMaxRows(maxRows);

    clientSession1.executeQuery(query1);

    clientSession1.logout();

    .

    .

    .

    query2.setFirstResult(firstResult + pageSize);

&n! bsp;   query2.setMaxRows(maxRows + pageSize);

    clientSession2.executeQuery(query2);

    clientSession2.logout();

    Is the above correct? Does it work for all databases?

    What if the selection criteria is different in query1 and query2?

Thanks

Rohit Banga

Member Technical Staff
Oracle Server Technologies