ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chetan Nayak" <chetannay...@gmail.com>
Subject Re: Deprecated paginatedList
Date Mon, 10 Dec 2007 16:28:21 GMT
I think the reason for it to be deprecated is because it does work with
Group By Clause........Im just guessing here

On 12/10/07, Stefano Tranquillini <stefano.tranquillini@gmail.com> wrote:
>
> Tnx
> so i've to made the pagineted query by myself.
> and, if i extract all the results and show only the result beteween an
> interval is the samething?
> PS: why paginated list has been deprecated?
> regards
>
> On Dec 10, 2007 3:51 PM, Ashok Madhavan <ashok.madhavan@gmail.com> wrote:
>
> > 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
> >
> >
> >
> >
>
>
>
> --
> Stefano

Mime
View raw message