jQuery Grid Plugin - jqGrid

Hi Tony,

I have a similar issue as mentioned in the discussion above. Making use of the following in the application:

1) Struts 1.2

2) JQGrid 3.8.2

3) JQuery 1.4.4

The Struts action method returns a json object after obtaining data from the database. See code below:

public ActionForward getJSONData(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response) {

...
...
 JSONObject jsonObj = createJSONTestData();
 response.setHeader("X-JSON", jsonObj.toString());
 System.out.println("Final JSON OBj: " + jsonObj.toString());
 return mapping.findForward(sForward);
}

/*
  *This piece of code is the same as the php code mentioned in one of the examples
  *provided in jqgrid demos
*/
public JSONObject createJSONTestData() {
....
....
//Hit the database and obtain the resultset and create the json object

 JSONObject responcedata=new JSONObject();
 net.sf.json.JSONArray cellarray=new net.sf.json.JSONArray();
 responcedata.put("total","3");
 responcedata.put("page",cpage);
 responcedata.put("records","2");

 net.sf.json.JSONArray cell=new net.sf.json.JSONArray();
 net.sf.json.JSONObject cellobj=new net.sf.json.JSONObject();

 int i=1;
 while(rs.next()){
  cellobj.put("id",rs.getInt(1));
  cell.add(rs.getInt(1));
  cell.add(rs.getString(2));
  cell.add(rs.getString(3));
  cellobj.put("cell",cell);
  cell.clear();
  cellarray.add(cellobj);
  i++;
        }
  PrintWriter out = response.getWriter();
  responcedata.put("rows",cellarray);
   
  return responcedata;

}

The struts-config.xml action forward mapping points to an empty.jsp that has no specific code.

The jsp file formulates the jqgrid as shown below:

$(document).ready(function(){
$("#load_callback1").click(function(){
jQuery("#list10").jqGrid({
 url:'/TestJSON/testAction.do?method=getJSONData',
 datatype: "json",
    colNames:['Invoice Number','Invoice Date','Invoice Name'],
    colModel:[
     {name:'id',index:'id', id:'id',width:90},
     {name:'invdate',index:'invdate', width:120},
     {name:'invname',index:'invname', width:200}
    ],
    rowNum:10,
    autowidth: true,
    rowList:[10,20,30],
    pager: jQuery('#pager1'),
    sortname: 'invname',
    sortorder: "desc",
    caption:"JSON Example"
}).navGrid('#pager1',{edit:false,add:false,del:false}); 
});
});

The grid comes up with no data. A similar example works well with the doGet method of a servlet.

Questions:

1) How do we obtain the json object returned from a struts action method?

2) Is there any process to be done in the empty.jsp file to handle the response object and obtain the json data?

Not sure if I posted the question under the right topic. Awaiting for a clarification at the earliest. Thank you.

Regards,

Aarati

Regards,

Aarati