Problem with variable substitution and annotations

2009-11-23 Thread Dominik Mähl
Hi, we're currently evaluating iBatis 3 and found a possible bug: To call a sql function we have to resort to $ (replacement in the query) instead of parameters (#). If we do this in xml everything works as expected. select LIB.FUNCTION('${0}') from SYSIBM.SYSDUMMY1 If we define

DRY for clauses?

2009-11-23 Thread Stephen Friedrich
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 dup

constructor result mapping with primitives doesn't work

2009-11-23 Thread OBender
Hi All, There is one very strange issue. If there is a constructor with primitive argument, say long and you have a mapping with: --- public class T1 { final private long xxx; public T1( long xxx ) {

Re: DRY for clauses?

2009-11-23 Thread j-lists
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 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

AW: DRY for clauses?

2009-11-23 Thread Stephen Friedrich
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:jamisonli...@gmail.com] Gesendet: Die