Re: Pagination query

From: Joshua Pyle (joshua.t.pyl..mail.com)
Date: Tue Mar 01 2005 - 15:33:29 EST

  • Next message: Sami Mohammed: "Re: Pagination query"

    It might help Sami if you did not comment out the following 2 lines...

    // adding paging functionality
    //cwTableParamMap.put(Constants.CW_REQ_PARAM_PAGE_SIZE, new Integer(mPageSize));
    //cwTableParamMap.put(Constants.CW_REQ_PARAM_TABLE_DESC, new
    Integer(mCurrentRow));
    // adding paging functionality

    I don't know this crosswalk thing but you seem to have commented out
    the controls that would limit your paging. The way cayenne does its
    paging is that it will only query the data on a per page basis but if
    your code loops through all of the data it will retrieve all of the
    data.

    It appears that your cntrols to limit the looping of your result list
    is not in place.

    Once again I do not know crosswalk so take my answer with that grain of salt.

    On Tue, 1 Mar 2005 13:47:20 -0500 (EST), Andrus Adamchik
    <andru..bjectstyle.org> wrote:
    > Sami,
    >
    > I understand that you are stuck at the moment. But please don't repost
    > your question over and over again. Somebody (maybe myself) will look at
    > it, just give it some time. That's the nature of free support - people are
    > willing to give their time to community, but you shouldn't push too hard.
    >
    > Andrus
    >
    >
    > > HI
    > >
    > > any body help me .
    > > page reterives all the rows from the table.
    > > see code below
    > >
    > > SelectQuery
    > > cwDataQuery
    > > = new
    > > SelectQuery(cwClass);
    > > cwDataQuery.addOrderings(cwObject.getViewOrderings());
    > > //cwDataQuery.setFetchLimit(100);
    > > cwDataQuery.setPageSize(25); // HERE I AM SETTING PAGE SIZE =25
    > > BUT STILL ITS RETRIVING ALL THE ROWS FROM THE TABLE WHATS THE
    > > PROBLEM
    > >
    > >
    > > // Perform the query
    > > List resultList = context.performQuery(cwDataQuery);
    > > THANKS
    > > SAMI
    > >
    > >
    > >
    > >
    > >
    >
    >

    -- 
    Joshua T. Pyle
    Go has always existed.
    



    This archive was generated by hypermail 2.0.0 : Tue Mar 01 2005 - 15:33:54 EST