server side paging with jQgrid

Question

I just took a look at jqgrid. Has anyone tried implementing this plugin, or used jQuery, to achieve server side pagination?

I am using struts2 and populating a html table with list returned from DB. This list is returned from an Oracle SP. The SP, along with some other parameters, is taking in 'start' and 'begin'. So I can pass numbers to these parameters to get specific row counts.

How would you achieve this? I would prefer some 'ajaxy' solution where the whole page does not refresh but just the table section refreshes. I see this is done on SO as well, but I think in this case they are bringing back all the data at once.

Answer 1

Most of the javascript grids assume you will have all of the data ready for display to start with -- mostly because they do client side sorting.

Since you want to do paging on the server side, that isn't going to work.

My suggestion, define a good web service and do it yourself. You could use JTemplate to help build the table after each web service request. If you want to keep it simple, don't do sorting.

Answer 2

I've successfully used http://www.datatables.net/ - a jQuery plugin that does server-side data and pagination.

Here's a basic implementation of datatables (version 1.5 beta 3) that uses server-side paging: http://artlung.com/temp/comics/.