Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL, Hibernate Pagination

 
Patrick McDonogh
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there all,

I am desperatelly looking for a pagination example with code to figure out how on earth pagination is conducted efficiently using Hibernate and MySQL. Does anyone know where i can get this information?

Or an article on paginantion would also be great, maybe with different ways of implimenting pagination.

By the way i am using hibernate and my sql.

Thanks all and have a great day, man this site always saves my sanity!
 
Raghavan Muthu
Ranch Hand
Posts: 3381
Mac MySQL Database Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I was also in your stage an year ago. There is one good answer to the Pagination Algorithm - "Depends on the Situation and Need".

Well, since the Pagination is a way of controlling the number of records to be displayed at a time according to the users navigation, you need to have a temporary place to store the retrieved results from the database (or simply server) so as to reduce the number of server calls- but with the cost of recently updated/inserted values. - Here is where my above answer fits!

I think the url in the JavaRanch is good one and they give the skeleton for the different ways of implementing the Pagination with Pros and Cons of each.

Here it is -> http://faq.javaranch.com/view?PaginationOrPaging

HtH.

[ May 05, 2007: Message edited by: Raghavan Muthu ]
[ May 05, 2007: Message edited by: Raghavan Muthu ]
 
Patrick McDonogh
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the help it has helped me out a lot.

Cheers
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic