Re: echo dynamic sql

2008-05-29 Thread Andrey Rogov
iBatis Developers Guide, 65 page. 2008/5/29 Prateek Asthana [EMAIL PROTECTED]: Thanks Andre, Can you please point me to teh documentation where its mentioned. I would like to read it and implement it. Thanks Prateek On Wed, May 28, 2008 at 10:06 AM, Andrey Rogov [EMAIL PROTECTED]

Re: using a parameterClass and also passing some additional params..

2008-05-29 Thread apinke
Well, what do you know ? I thought of trying the following right after posting...and it worked ! :-) Here is how I got it to work : Iinstead of passing the domain object , I pass a Map that contains it. (psuedo syntax) insert id=testinsert parameterClass=java.util.Map insert into

Re: customized where

2008-05-29 Thread Jeff Butler
Couple of ways to do this: 1. Build the where clause yourself and pass it as a parameter to the statement: Select * from foo $where_clause$ 2. Use iBATIS dynamic SQL tags: select * from foo dynamic prepend=where isNotNull property=firstName prepend=and FIRST_NAME = #firstName#

Inserting lists

2008-05-29 Thread Nicholoz Koka Kiknadze
/* I apologize for re-posting this, but I think my previous post ended in junk folders because I was using all-numeric mailbox */ Recently I found that I'm writing loops to insert lists of objects way too often. I think it makes sense implementing methods like: