ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From j-lists <jamisonli...@gmail.com>
Subject Re: DRY for <where> clauses?
Date Tue, 24 Nov 2009 05:47:21 GMT
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+reuse+SQL-fragments

On Mon, Nov 23, 2009 at 9:11 AM, Stephen Friedrich
<stephen.friedrich@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?)
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message