select * from table AND navigation

[TP]

Here is my problem.

I need to display a table about which I have no information except the
table name. Using metadata I can somehow show the column names and
record values.

But my table has 1 million rows and if I do a select * then I do get
1 million rows.

I want to be able to provide page navigation as google does, page
forward, backwards etc. For now it is a read only database.

For reference please see my post here.

http://forum.java.sun.com/thread.jsp?thread=482269&forum=48&message=2252212

I would appreciate any ideas. I have been stuck for a week now.

Thanks.

TP