I think I meant 1.6.2, 1.6.3 is in the works.. On Tue, Sep 1, 2009 at 8:22 AM, Michael McCurrey <mmccur...@gmail.com>wrote:
> Can you update to 1.6.3 and see if it works, if not, send me your updated > map file and I'll take a look. Did you change the <result for both your > insert and your update map? > > > > On Tue, Sep 1, 2009 at 8:18 AM, dannystommen <da...@techconnect.nl> wrote: > >> >> Version 1.6.1 >> >> >> Michael McCurrey-3 wrote: >> > >> > What version of iBatis? >> > >> > On Tue, Sep 1, 2009 at 8:12 AM, dannystommen <da...@techconnect.nl> >> wrote: >> > >> >> >> >> Thanks for your fast reply. I changed it, but the result is still the >> >> same >> >> incorrect sql statement >> >> >> >> >> >> Michael McCurrey-3 wrote: >> >> > >> >> > Well, >> >> > >> >> > One thing I notice that is wrong is your using a result element in >> your >> >> > parameter Maps. >> >> > >> >> > Instead of this: >> >> > <parameterMap id="insert" class="Test"> >> >> > <result property="Name" column="name" /> >> >> > </parameterMap> >> >> > >> >> > Try this: >> >> > <parameterMap id="insert" class="Test"> >> >> > <parameter property="Name" column="name" /> >> >> > </parameterMap> >> >> > >> >> > >> >> > On Tue, Sep 1, 2009 at 6:07 AM, dannystommen <da...@techconnect.nl> >> >> wrote: >> >> > >> >> >> >> >> >> Hi there, >> >> >> >> >> >> I'm trying to use parameterMaps with the <generate> tag, but it is >> not >> >> >> working. I have a databse with table 'test_table' and 2 colums: id & >> >> name >> >> >> >> >> >> <resultMaps> >> >> >> <resultMap id="TestResult" class="Test"> >> >> >> <result property="ID" column="id" /> >> >> >> <result property="Name" column="name" /> >> >> >> </resultMap> >> >> >> </resultMaps> >> >> >> >> >> >> <parameterMaps> >> >> >> <parameterMap id="insert" class="Test"> >> >> >> <result property="Name" column="name" /> >> >> >> </parameterMap> >> >> >> >> >> >> <parameterMap id="update" class="Test" extends="insert"> >> >> >> <result property="ID" column="id" /> >> >> >> </parameterMap> >> >> >> </parameterMaps> >> >> >> >> >> >> <statements> >> >> >> <!--Insert description--> >> >> >> <insert id="Insert" parameterMap="insert"> >> >> >> <selectKey property="ID" type="post" resultClass="int"> >> >> >> select LAST_INSERT_ID() as value >> >> >> </selectKey> >> >> >> <generate table="test_table" /> >> >> >> </insert> >> >> >> >> >> >> <update id="Update" parameterMap="update"> >> >> >> <generate table="test_table" by="id" /> >> >> >> </update> >> >> >> >> >> >> </statements> >> >> >> </sqlMap> >> >> >> >> >> >> the first error occurs when I try to configure Ibatis (first use). >> >> >> "Specified argument was out of the range of valid >> values.\r\nParameter >> >> >> name: >> >> >> index". This happens in de update tag. When I comment this generate >> >> tag >> >> >> out, >> >> >> the configuration succeeds. Why is this happening, I don't have any >> >> >> parameter that is named 'index'. >> >> >> >> >> >> Secondly, when I try to execute the insert statement, it fails with >> >> the >> >> >> message dat column 'name' has no default value. After some >> debugging, >> >> I >> >> >> saw >> >> >> that ibatis generated the next insert statement: "INSERT INTO >> >> test_table >> >> >> () >> >> >> VALUES ()", while it should be: "INSERT INTO test_table (name) >> VALUES >> >> >> (something_here?)" >> >> >> >> >> >> Why is this happening? >> >> >> >> >> >> >> >> >> -- >> >> >> View this message in context: >> >> >> >> >> >> http://www.nabble.com/%3Cgenerate%3E-tag-not-working-tp25240019p25240019.html >> >> >> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com. >> >> >> >> >> >> >> >> >> >> --------------------------------------------------------------------- >> >> >> To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org >> >> >> For additional commands, e-mail: user-cs-h...@ibatis.apache.org >> >> >> >> >> >> >> >> > >> >> > >> >> > -- >> >> > Michael J. McCurrey >> >> > Read with me at http://www.mccurrey.com >> >> > http://chaoticmindramblings.blogspot.com/ >> >> > >> >> > >> >> >> >> -- >> >> View this message in context: >> >> >> http://www.nabble.com/%3Cgenerate%3E-tag-not-working-tp25240019p25242101.html >> >> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com. >> >> >> >> >> >> --------------------------------------------------------------------- >> >> To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org >> >> For additional commands, e-mail: user-cs-h...@ibatis.apache.org >> >> >> >> >> > >> > >> > -- >> > Michael J. McCurrey >> > Read with me at http://www.mccurrey.com >> > http://chaoticmindramblings.blogspot.com/ >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/%3Cgenerate%3E-tag-not-working-tp25240019p25242269.html >> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org >> For additional commands, e-mail: user-cs-h...@ibatis.apache.org >> >> > > > -- > Michael J. McCurrey > Read with me at http://www.mccurrey.com > http://chaoticmindramblings.blogspot.com/ > -- Michael J. McCurrey Read with me at http://www.mccurrey.com http://chaoticmindramblings.blogspot.com/
