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:27:55 GMT
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