MySQL, Hibernate Pagination

[Patrick McDonogh]

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]

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]

Thanks for the help it has helped me out a lot.

Cheers