Guriddo » Topic: jqgrid jsp – only grid displayed no data

jqgrid jsp – only grid displayed no data

Guriddo
jqgrid jsp – only grid displayed no data

This topic has 5 replies, 4 voices, and was last updated 15 years, 7 months ago by spsmysp.

Creator

Topic
June 24, 2009 at 2:17 pm #73579

betty
Participant

I have been able to setup some simple examples using jqgrid loading data. I can display the grid with data succefully by putting xml data and json string in client side script.

Now the problem I am struggling with is using jqGrid to display the data retrieved from JSP (I have to use java since that is all the project based on).

For the jsp page, I can view the generated json string (on browser) or xml data (view page source) by accessing the files directly. The data are in the correct format since the format are same as my previous worked examples.

http://localhost:8080/examples/holdingsJSONData.jsp

http://localhost:8080/examples/holdingsData.jsp

But when I specified the url as either one above in the html, only the grid displayed without data.

http://localhost:8080/examples/gridDemo.html
Creator

Topic

Viewing 5 replies - 1 through 5 (of 5 total)

Author

Replies
June 24, 2009 at 5:47 pm #87389

bujinwang
Participant

Check in browser whether your http://localhost:8080/examples/holdingsJSONData.jsp returns valid JSON string and your JSON reader setting matches the format. If the string is not valid JSON or does not match the format specified in yoru jsonReader, it quietly does not show any error.

Burt

June 25, 2009 at 2:20 pm #87393

betty
Participant

Hi Burt,

Thanks for the suggestions. Indeed there are some problems about my json string (though it was generated by flexjson and it was valid). I corrected it and put it in the javascript in html, the json string data rended in grid succefully. But I still could not loaded the same json string if it was produced from jsp page.

So here is my test.

I copied the json string generated by http://localhost:8080/examples/holdingsJSONData.jsp to jsonGrid4.html. jsonGrid4.html can display the data well. And following is the source.

jqGrid Demo

// generated by holdingsJSONData.jsp and copied here

var mystr = “{page: '1', records: '6', rows: [{cell:['X-RAY', '46190', '1144', '2127', '17', '49479'], id: '1'},{cell:['NMR', '6846', '849', '146', '6', '7847'], id: '2'},{cell:['ELECTRON MICROSCOPY', '165', '16', '59', '0', '240'], id: '3'},{cell:['HYBRID', '13', '1', '1', '1', '16'], id: '4'},{cell:['other', '108', '4', '4', '9', '125'], id: '5'},{cell:['Total', '53322', '2014', '2337', '33', '57707'], id: '6'}],total: '1'}”;

June 27, 2009 at 11:26 am #87428

tony
Keymaster

Hello,

Using fireBug check the server response.

Regards

Tony

June 29, 2009 at 6:54 pm #87458

betty
Participant

Finally, I got the xml data from server side jsp page rendered in grid. 🙂

My solution is to add these two links to ensure the response data in xml format.

<%

response.setContentType(“text/xml”);

response.setCharacterEncoding(“UTF-8”);

%>

December 15, 2010 at 4:19 pm #96905

spsmysp
Participant

I had this problem too. Actually, I read this page tried and tried again. But could not get the data shown in json format.

Finally, I found this page:http://www.comanswer.com/question/jqgrid-with-json-data-renders-table-as-empty.

The reason that the data can not be shown is that our json format is not strict enough.

reference here: http://simonwillison.net/2006/…..t/11/json/

{page: '1', records: '6', rows: [{cell:['X-RAY', '46190', '1144', '2127', '17', '49479'], id: '1'},{cell:['NMR', '6846', '849', '146', '6', '7847'], id: '2'},{cell:['ELECTRON MICROSCOPY', '165', '16', '59', '0', '240'], id: '3'},{cell:['HYBRID', '13', '1', '1', '1', '16'], id: '4'},{cell:['other', '108', '4', '4', '9', '125'], id: '5'},{cell:['Total', '53322', '2014', '2337', '33', '57707'], id: '6'}],total: '1'}

—————————————————————————————————->>>>>>>>>>>>>>>>>>>>>>

{“page”: “1″,” records”: “6″,”rows”: [{“cell”:[“X-RAY”, “46190”, “1144”, “2127”, “17”, “49479”],”id”: “1″},{“cell”:[“NMR”, “6846”, “849”, “146”, “6”, “7847”],”id”: “2″},{“cell”:[“ELECTRON MICROSCOPY”, “165”, “16”, “59”, “0”, “240”],”id”: “3″},{“cell”:[“HYBRID”, “13”, “1”, “1”, “1”, “16”], “id”: “4″},{“cell”:[“other”, “108”, “4”, “4”, “9”, “125”],”id”: “5″},{“cell”:[“Total”, “53322”, “2014”, “2337”, “33”, “57707”],”id”: “6″}],”total”: “1″}

maybe, you should replace the “ by “ if you place the string above between the ” “

PS: I am sorry for some grammer error, my english is pool. Thanks!
Author

Replies