I am looking for for a pagination method ( viewing large result sets page by page) in J2EE.
Although there exists some native queries in MSSQL, MYSQL ,and ... for this purpose, it seems that EJBQL does not support pagination.
the following pattern is also suggested by Core J2EE patterns:
developer.java.sun.com/.../ValueListHandler.html
but there are some challenges with keeping the cached data up to date and sharing it among different users. I would really appreciate it if any one can post any comments or sample source code for pagination in j2ee..