On Mon, Nov 23, 2009 at 9:11 AM, Stephen Friedrich
<stephen.friedr...@fortis-it.eu> wrote:
My application uses a lot of "manual" paging (using ROWNUM and
nested selects in Oracle PL/SQL). For each of these queries there
is a second query that returns the total number of results with
_identical with-clause_ (sometimes quite complex). Does iBatis
offer any help in avoiding these code duplicates?
(Or does anybody know a better way, for example a way to retrieve
both the total count and a specific "page" in a single statement?)
Depending on your result set size, you may want to consider a pager
external to the DB. We are developing a JSF application and use the
Tomahawk pager for this purpose. Won't work if your result set is 1
million rows, but if it is more like 500-1000 rows then it works fine.
--
Guy Rouillier
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
