This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes Pagination Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Pagination" Watch "Pagination" New topic
Author

Pagination

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.


OCPJP 6, OCEWCD Java EE 6
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 56213
    
  13

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


[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
Mohamed Sanaulla
Bartender

Joined: Sep 08, 2007
Posts: 2928
    
  15

This article should be of some help: PaginationOrPaging


Mohamed Sanaulla | My Blog
Sergey Mois
Greenhorn

Joined: Aug 25, 2009
Posts: 5
Paging in SQL Server
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Pagination
 
Similar Threads
Pagination
Pagination
Pagination
Pagination
PAGINATION