Thanks for your reply Axel
I think that the problem is related to passing a null primary key in
the insert statement when the key is autogenerated (by MySQL).
What is the best practice here? I have tried the following MySQL
specific SqlMap snippet with success, but was hoping for a solution
portable among databases:
<insert id="insert" parameterClass="net.mycompany.Role">
<selectKey resultClass="java.lang.Integer" keyProperty="roleid">
select LAST_INSERT_ID() AS value
</selectKey>
insert into role (RoleID, ParentID, Name, Notes)
values (#roleid:INTEGER#, #parentid:INTEGER#, #name:VARCHAR#,
#notes:VARCHAR#)
</insert>
Thanks Chris
On 18/04/2008, Leucht, Axel <[EMAIL PROTECTED]> wrote:
> Can you describe the database table structure you're working on?
>
> /Axel
>
>
> >>-----Ursprüngliche Nachricht-----
> >>Von: Chris Marshall [mailto:[EMAIL PROTECTED]
> >>Gesendet: Freitag, 18. April 2008 16:02
> >>An: [email protected]
> >>Betreff: Re: iBATIS insert does not execute
> >>
