On Tue, Sep 1, 20= 09 at 8:12 AM, dannystommen <danny@techconnect.nl> wrote:

Thanks for your fast reply. I changed it, but the result is still the same<= br> incorrect sql statement

Michael McCurrey-3 wrote:
>
> Well,
>
> One thing I notice that is wrong is your using a result element in you= r
> parameter Maps.
>
> Instead of this:
> =A0 =A0<parameterMap id=3D"insert" class=3D"Test&quo= t;>
> =A0 =A0 =A0<result property=3D"Name" column=3D"name&= quot; />
> =A0 =A0</parameterMap>
>
> Try this:
> =A0 =A0<parameterMap id=3D"insert" class=3D"Test&quo= t;>
> =A0 =A0 =A0<parameter property=3D"Name" column=3D"na= me" />
> =A0 =A0</parameterMap>
>
>
> On Tue, Sep 1, 2009 at 6:07 AM, dannystommen <danny@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 co= lums: id & name
>>
>> =A0<resultMaps>
>> =A0 =A0<resultMap id=3D"TestResult" class=3D"Tes= t">
>> =A0 =A0 =A0<result property=3D"ID" column=3D"id&= quot; />
>> =A0 =A0 =A0<result property=3D"Name" column=3D"n= ame" />
>> =A0 =A0</resultMap>
>> =A0</resultMaps>
>>
>> =A0<parameterMaps>
>> =A0 =A0<parameterMap id=3D"insert" class=3D"Test= ">
>> =A0 =A0 =A0<result property=3D"Name" column=3D"n= ame" />
>> =A0 =A0</parameterMap>
>>
>> =A0 =A0<parameterMap id=3D"update" class=3D"Test= " extends=3D"insert">
>> =A0 =A0 =A0<result property=3D"ID" column=3D"id&= quot; />
>> =A0 =A0</parameterMap>
>> =A0</parameterMaps>
>>
>> =A0<statements>
>> =A0 =A0
>> =A0 =A0<insert id=3D"Insert" parameterMap=3D"ins= ert">
>> =A0 =A0 =A0<selectKey property=3D"ID" type=3D"po= st" resultClass=3D"int">
>> =A0 =A0 =A0 =A0select LAST_INSERT_ID() as value
>> =A0 =A0 =A0</selectKey>
>> =A0 =A0 =A0<generate table=3D"test_table" />
>> =A0 =A0</insert>
>>
>> =A0 =A0<update id=3D"Update" parameterMap=3D"upd= ate">
>> =A0 =A0 =A0<generate table=3D"test_table" by=3D"= id" />
>> =A0 =A0</update>
>>
>> =A0</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\n= Parameter
>> name:
>> index". This happens in de update tag. When I comment this ge= nerate tag
>> out,
>> the configuration succeeds. Why is this happening, I don't hav= e any
>> parameter that is named 'index'.
>>
>> Secondly, when I try to execute the insert statement, it fails wit= h 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.co= m.
>>
>>
>> ------------------------------------------------------------------= ---
>> To unsubscribe, e-mail: user-cs-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-cs-help@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.n= abble.com/%3Cgenerate%3E-tag-not-working-tp25240019p25242101.html

Sent from the iBATIS - User - Cs m= ailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-cs-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-cs-help@ibatis.apache.org