JQuery Data Table Server Side Processing Failed

peterwkc

Hello to all, I'm using the JQuery Data Table but it failed to load the data into the data table.


JSP
[code]
$(document).ready(function(){
$.ajaxSetup({cache : false});

var oTable = $("#gmReportTbl").dataTable({
-bServerData : true,
-bServerSide : true,
-bJQueryUI : true,

sServerMethod : "POST",
-sAjaxSource : "${context}/analytics/generateGM_json",

"aoColumns":
[
{"bSortable" : false},
{"bSortable" : false},
{"bSortable" : false},
{"bSortable" : false},
{"bSortable" : false},
{"bSortable" : false},
{"bVisible": true, "bSortable" : false}

]
});
});






Destination*

Select Destination

${dest.countryName}

/select>




Generate Report
Reset








Country
Dial Code
Customer Prefix
Vendor Prefix
Customer Price
Vendor Cost
Profit





Loading data from Server








[/code]



Spring MVC:
[code]
@RequestMapping(value = "/gm-report-json", method = RequestMethod.GET)
public String viewGMReport_JSON(ModelMap map) {
List countryList = reportDao.getAllCountry();

map.put("countryList", countryList);

// return view
return "gmReport_json";
}

// form call
@RequestMapping(value = "/generateGM_json", method = RequestMethod.POST)
public @ResponseBody String generateGMReport_JSON(@RequestParam("countryCode") int countryCode, ModelAndView mv) {
JSONArray gmDataArray = new JSONArray();
JSONObject jsonObj = new JSONObject();

List gmList = reportDao.generateGrossMarginReport(countryCode);

for (CostReport cr : gmList) {
JSONArray gmArray = new JSONArray();

gmArray.put(cr.getCountryCode());
gmArray.put(cr.getDialCode());
gmArray.put(cr.getCustPrefix());
gmArray.put(cr.getVendorPrefix());

try {
gmArray.put(cr.getCustPrice());
gmArray.put(cr.getVendorCost());
gmArray.put(cr.getProfit());
} catch (JSONException e) {

}

gmDataArray.put(gmArray);

}

try {
jsonObj.put("sEcho", 0);
jsonObj.put("iTotalDisplayRecords", gmList.size());
jsonObj.put("aaData", gmDataArray);
} catch (JSONException e) {
Logger.getLogger(AnalyticsController.class).log(Priority.ERROR, e.getLocalizedMessage());
}

return jsonObj.toString();
}

[/code]


Please help. Thanks.


Anyone know what is the reason ?

JSON DATA
[quote]
{
"iTotalDisplayRecords": 3,
"aaData": [
[
60,
3,
"12345",
"12345",
0.5,
0.03999999910593033,
0.46000000834465027
],
[
60,
3,
"55555",
"55555",
0.8999999761581421,
0.029999999329447746,
0.8700000047683716
],
[
60,
3,
"12345",
"12345",
0.5,
0.009999999776482582,
0.49000000953674316
]
],
"sEcho": 0
}

[/quote]


I realized that when I load the page, JQuery Data Table will make an Ajax Call to server side. Why is this happen ?

allan

1. Don't post the same question multiple times
2. Link to a test case: http://datatables.net/forums/discussion/12899/post-test-cases-when-asking-for-help-please-read

Allan

peterwkc

I've a scenario where I want the Data table to use the server side processing. but It should not hit the server unless the user submits a form in the page. is it possible?

Bit more info:
1. when the page is loaded, the Datatable is loaded and is invisible, and not to hit the server for the data. (Not get data from server but just decorate the data table).
2.Now user clicks a button on the page, that calls a javascript (function/AJAX Call) which in turn have to activate the Datatable to retrieve the data from server side.
3. subsequently Datatable pulls the data from serverside, and all the further user interaction hits the server.

Is this possible?

Mr Allan, Please help. Thanks.

allan

Why not only initialise the table when it is actually needed, rather than at page load time?

Allan

peterwkc

It is requirement to initialize at page load time and performance optimization consideration. How to do it ?

Besides that, How to intialize JQuery data table when user submit the form ? I don't need sorting right now. I need to implement pagination later on.

allan

Surely it would improve performance to only initialise the table when it is actually needed? Currently there is no way to initialise a server-side processing table but to deny it making requests to the server.

Allan

peterwkc

Any plan to include the feature in future ?

allan

Currently no. The closet you might get is deferred loading - http://datatables.net/release-datatables/examples/server_side/defer_loading.html . Perhaps that might be good enough for your use case?

Allan

peterwkc

How to use the defer loading which apply to my case ? Defer loading is just avoid ajax call at page load but how to control the ajax call happen on submit button ?