Re: select with iterate

2005-04-24 Thread Ron Grabowski
iterate can be used in any statement tag. insert and update are extensions of the statement tag. For readability and maintainablity, I would make seperate calls in your dao class. I suppose you could make up some kind of giant INSERT statment using iterate: iterate property=idList INSERT INTO

Re: RES: Mapping of one object to several tables?

2005-04-24 Thread toto titi
Ok, thank you all for the help. I had to go with something along the lines (which is still a very short number of code lines thanks to iBatis): 1. query the countryTable to get the countryId 2. If it does not exists, insert a new country and retrieve the id thanks to a selectKey 3. set the

ANSI_PADDING

2005-04-24 Thread Bitra, Venkateswararao \(Corporate, consultant\)
Hi, I user IBATIS layer for my Pervasive SQL database. Pervasive SQL 9 came up with an option to deal with ANSI_PADDING problem with datatype CHAR and VARCHAR. ANSI_PADDING is on by default in Pervasive. I need to set ANSI_PADDING off for all my transactions with Pervasive. Otherwise I

Re: ANSI_PADDING

2005-04-24 Thread Clinton Begin
How do you turn it off without iBATIS? Clinton On 4/24/05, Bitra, Venkateswararao (Corporate, consultant) [EMAIL PROTECTED] wrote: Hi, I user IBATIS layer for my Pervasive SQL database. Pervasive SQL 9 came up with an option to deal with ANSI_PADDING problem with datatype CHAR and