This week's giveaway is in the Groovy forum.
We're giving away four copies of Groovy Fundamentals video training course and have Ken Kousen on-line!
See this thread for details.
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 Groovy Fundamentals video training course this week in the Groovy 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: 62771

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
I agree. Here's the link:
subject: Pagination