File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Pagination Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Pagination" Watch "Pagination" New topic


Alexander Sales
Ranch Hand

Joined: Feb 21, 2011
Posts: 89

Whats your approach when it comes to pagination using different databases?

Usually pagination is the way we scan from records to records.

Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63060

Either find out how the SQL dialect for the database allows for paging, or use an abstraction layer like an ORM.

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Mohamed Sanaulla
Saloon Keeper

Joined: Sep 08, 2007
Posts: 3151

This article should be of some help: PaginationOrPaging

Mohamed Sanaulla | My Blog
Sergey Mois

Joined: Aug 25, 2009
Posts: 5
Paging in SQL Server
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: Pagination
It's not a secret anymore!