Hi Larry,
I our project for pagination, we use sql. we do the nested select within a
select within a select.
Is there a better way to do it in general and in iBatis.
regards
Ashok
On 7/2/07, Larry Meadors <[EMAIL PROTECTED]> wrote:
..unless you can do it in the SQL instead. :)
Some drivers want to bring back all the data before processing it, so
it can cost you dearly to do this in the Java side.
Larry
On 7/2/07, Clinton Begin <[EMAIL PROTECTED]> wrote:
> Right. Don't use the paginator stuff...but feel free to still use the
> query limits:
>
> queryForList("statement", param, offset, maxrows)
>
> clinton
>
> On 7/1/07, Larry Meadors <[EMAIL PROTECTED]> wrote:
> > The best example is one that doesn't exist: don't use it. :)
> >
> > It's not going to be in iBATIS 3 because it's not really part of the
> > core of what iBATIS does - mapping data.
> >
> > Most all modern databases provide similar functionality that will
> > perform better, and use fewer resources.
> >
> > Larry
> >
> >
> > On 7/1/07, André Rodrigues Pena <[EMAIL PROTECTED]> wrote:
> > > Hi all,
> > > I'm new to iBatis. I'd like to see a complete example of how to use
> > > pagination in my queries. I searched google but I didn't find an
example
> > > including both query and java example of usage.
> > >
> > > Thanks in advance
> > >
> > > --
> > > André Rodrigues Pena
> >
>
