ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: fetchSize
Date Tue, 13 Feb 2007 14:30:19 GMT
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