ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Goodin" <brandon.goo...@gmail.com>
Subject Re: fetchSize
Date Tue, 13 Feb 2007 14:45:55 GMT
Sorry for the bad info. Learn something new all the time. :-/

Brandon

On 2/13/07, Clinton Begin <clinton.begin@gmail.com> wrote:
>
> Actually it does!
>
> <select ... fetchSize="50">
>
> Remember that it's just a hint though...not a guarantee IIRC.
>
> Clinton
>
> On 2/13/07, Brandon Goodin <brandon.goodin@gmail.com> wrote:
> > iBATIS does not provide a means to use the setFetchSize on a
> > PreparedStatement. If you are looking to limit the number of rows you
> get
> > back from the database then I suggest using queryForList(id, parmObject,
> > skip, max) or placing it in your SQL statement like "select * from foo
> where
> > rownum<10" in Oracle.
> >
> > Brandon
> >
> >
> > On 2/13/07, Tushar Kherde <kherde.tushar@gmail.com> wrote:
> > > Hi All,
> > >
> > > I want to use fetchsize in my select query.
> > > Can I get sample for this.
> > >
> > > --
> > > With regards
> > > Tushar Kherde
> >
> >
>

Mime
View raw message