Skipping records from a Cursor

I want to be able to provide paging functionality in a Java/web application without keeping a database connection permanently open due to scalability issues.

For example query returns a 100,000 records, on a page I wish to display only 1000 with next/back buttons. When the back next button is pressed I want to retrieve the rows 1001->2000. Like I said I don't won't to retain the database connection between pages so using a scrollable resultset is out of the question.

How do I tell Oracle I only want n -> n+1000 records without having to fetch and ignore previous records.

How do yahoo/altavista etc implement this type of paging functionality given the thousands of concurrent users ?

Any help would be much appreciated.

mostin

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 26 2001 - 19:31:40 CST