Pagination using CachedRowSetImpl

Hi ,

I have some problem with paginaiton using CachedRowSetImpl.

Here is my code

CachedRowSetImpl set =new CachedRowSetImpl();

set.setPageSize(10);

set= (CachedRowSetImpl) db.getScrollableRecords("select * from table");

while (set.nextPage())

{

while (set.next())

{

MyLogic()

}

}

When I run above this I receive following Exception:

java.sql.SQLException: Populate data before calling

at com.sun.rowset.CachedRowSetImpl.nextPage(Unknown Source)

at Test.main(Test.java:28)

Anybody have any idea...?

Thx

Tariq

[865 byte] By [Java_persona] at [2007-11-27 5:54:57]