It does
return sqlMapExecutor.queryForList(statementName, parameterObject, (idx) * pageSize, localPageSize);
every time you move to next/previous page.
You can store it in the session, but my opinion is that it is not a good idea because of scalability issues. I prefer to send only the page number and call queryForList.
Regards, Guido García Bernardo.
sai nukala wrote:
I am having tough time with a simple usage of Paginated list.
I am using struts framework with Ibatis.
Very simple.
-Defined sql in SQL Map
-Created a DAO class to fetch and return PaginatedList.
- Page size:5 Resultset has 12 records
Only first 2 next() methods are returning 2 page lists. last 2 records in the third page list are not shown. Last.next() is showing only the second page list. But returns true indicating there is still one more page available next.
My question is: Once we return a paginated list with a page size -n, Is the resultset disconnected by fetching all the pages atonce or for every fetch, makes a database call??
Can we store paginated list in the request/session scope and fetch previous/next pages?
thanks
~snuke
