ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashok Madhavan" <ashok.madha...@gmail.com>
Subject Re: Deprecated paginatedList
Date Mon, 10 Dec 2007 14:51:58 GMT
i think doing the pagination in the sql is the better way.
you can do it using nested selects.

the sql for getting the rows between 50 and 100 goes like this :
select FIELDNAME, USERID from
  ( select FIELDNAME, USERID, rownum num
  from ( select A.FIELDNAME, B.USERID
    from wdchangelog A, WSUSERS B
    where A.configUnitID = ?
    and A.USERUID = B.userUID
    order by A.FIELDNAME ) a
  ) b where num between 50 and 100

the above is specific to oracle. but all DBs have equivalent of this.

regards
ashok
On Dec 10, 2007 1:55 PM, Stefano Tranquillini <
stefano.tranquillini@gmail.com> wrote:

> Hi,
> someone know's how i can have a paginedQuery?
> i try to use queryForPaginatedList but is deprecated.
> tnx
>
> --
> Stefano

Mime
View raw message