ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bhaarat Sharma <bhaara...@gmail.com>
Subject Re: iBatis - MySQL pagination
Date Fri, 15 May 2009 16:27:44 GMT
what if we have a stored procedures that takes in 'startrow' and 'endrow' as
parameters. Based on those it returns the results back.
If a sp like that were to be called using iBatis with pagination then will
the SP be called again to get NEXT set of results?

On Fri, May 15, 2009 at 12:15 PM, Larry Meadors <larry.meadors@gmail.com>wrote:

> Do it in the sql statement instead of using pagination in ibatis.
>
> Look at limit, row_count and offset here:
>
> http://dev.mysql.com/doc/refman/5.0/en/select.html
>
> You will probably need to use $substitution$ for the parameters, but
> surely some mysql stud can tell you more about that than I can. :)
>
> Larry
>

Mime
View raw message