This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JDBC 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 OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
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: 61450

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: 3071

This article should be of some help: PaginationOrPaging

Mohamed Sanaulla | My Blog
Sergey Mois

Joined: Aug 25, 2009
Posts: 5
Paging in SQL Server
I agree. Here's the link:
subject: Pagination