ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Friedrich <stephen.friedr...@fortis-it.eu>
Subject AW: DRY for <where> clauses?
Date Tue, 24 Nov 2009 07:34:17 GMT
Oops, sorry. I had skimmed through the FAQ, but somehow I missed this. Will look more thoroughly
the next time.

Anyway: Thanks a lot for the answer - the helpful mailing list is a big plus for iBatis!


-----Urspr√ľngliche Nachricht-----
Von: j-lists [mailto:jamisonlists@gmail.com] 
Gesendet: Dienstag, 24. November 2009 06:47
An: user-java@ibatis.apache.org
Betreff: Re: DRY for <where> clauses?

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