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/
