mariusv5 on jqGrid Problem - query repeat always two times

Tue, 15 Mar 2011 20:57:04 +0200

I've a problem with a jqGrid.

I'had built json method for retrieve records from database table. This method is always throws 2 times.

struts.xml

<package name="PLogView" extends="struts-default">
       <action name="log" class="appl.LogAction" method="initLog">
           <result name="success">/jsp/logs.jsp</result>
           <result name="error">/jsp/error.jsp</result>
       </action>
</package>

LogAction.java - method getList()

    public String getList() {
       String title = getText("log.title.list");
       String result = ActionSupport.SUCCESS;
       SqlSession sqlSession = null;

       try {
           Map<String, Object> session = ActionContext.getContext().getApplication();
           sqlSession = ((SqlSessionFactory) session.get("sqlFactory")).openSession(true);

// Count all logs record
setRecords((Integer) sqlSession.selectOne("getCountLogs"));

           // Calucalate until rows ware selected
           int to = (getRows() * getPage());
           // Set to = max rows
           if (to > getRecords()){
               to = getRecords();
               setPage(getTotal());
           }

           // Calculate the first row to read
           int from = to - getRows();
           // Set to = max rows
           if (from < 0)
               from = 0;

           // Retrieve logs records
           HashMap<String, Integer> params = new HashMap<String, Integer>();
           params.put("from", from);
           params.put("to", to);
           setLogsList(sqlSession.selectList("getLogs", params));

           // Calculate total pages
           setTotal((int) Math.ceil((double) getRecords() / (double) getRows()));
       } catch (Exception e) {
           addActionError(getText("read.error", getTextElements(title)));
           setError(getText("read.error", getTextElements(title)));
           logger.error(e.getMessage(), e);
           result = ActionSupport.ERROR;
       } finally {
           try {
               if (sqlSession != null) {
                   sqlSession.close();
               }
           } catch (Exception e) {
               logger.error("Generic exception during close database session", e);
           }
       }

return result;
}

log.jsp

<jsp:include page="include/header.jsp" flush="false"></jsp:include>

                // Refresh log list
               function rowsrefresh(event, data)
               {
                   $("#list").trigger("reloadGrid");
               }

                jQuery("#list").jqGrid
               ({
                   url: 'log_jqgrid',
                   datatype: 'json',
                   datastr: 'logsList',
                   mtype: 'POST',
                   height: '230px',
                   autowidth: true,
                   rowNum: 10,
                   rowList: [],
                   viewrecords: true,
                   pager: jQuery('#pager'),
                   jsonReader: {root: 'logsList', repeatitems: false},
                   colNames:
                   [
                       '<s:text name="log.grid.colName.username"/>',
                       '<s:text name="log.grid.colName.action"/>',
                       '<s:text name="log.grid.colName.datetime"/>',
                   ],
                   colModel:
                   [
                       {name:'username',    editable:false, hidden:false, sortable:false},
                       {name:'action',        editable:false, hidden:false, sortable:false},
                       {name:'actiontime',   editable:false, hidden:false, sortable:false}
                   ]
               }).navGrid("#pager", {refresh:false, add:false, edit:false, del:false, search:false})
               .navButtonAdd("#pager", {caption:'', title:'<s:text name="function.refresh"/>',   buttonicon:'ui-icon-refresh',   onClickButton:function (event, data) {rowsrefresh();}});

</head>

<body>

Give me a hand, please ?

Thanks in advance,

mariusv5.

jQuery Grid Plugin - jqGrid - Topic: jqGrid Problem - query repeat always two times

mariusv5 on jqGrid Problem - query repeat always two times