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 >> >> >>Further to my previous reply - I have checked all field values to be >>correct, with only the primary autogenerated key being null. >>Regards Chris >> >>On 18/04/2008, Brandon Goodin <[EMAIL PROTECTED]> wrote: >>> Is this the only insert that is not working for you? Do you >>have others that >>> are working? What version of iBATIS are you using? >>> >>> Brandon Goodin >>> >>> >>> On Fri, Apr 18, 2008 at 7:10 AM, Chris Marshall >><[EMAIL PROTECTED]> >>> wrote: >>> > I have spent a couple of days on this and have read the FAQ and >>> > googled without success, so hope I can get some help: >>> > I am trying to persist an instance of the class: >>> > >>> > public class Role { >>> > >>> > private Integer roleid; >>> > private Integer parentid; >>> > private String name; >>> > private String notes; >>> > >>> > public Integer getRoleid() { >>> > return roleid; >>> > } >>> > .......&c >>> > } >>> > >>> > with role_SqlMap.xml the snipprt: >>> > >>> > <insert id="insert" parameterClass="net.mycompany.Role"> >>> > insert into role (RoleID, ParentID, Name, Notes) >>> > values (#roleid:INTEGER#, #parentid:INTEGER#, #name:VARCHAR#, >>> > #notes:VARCHAR#) >>> > </insert> >>> > >>> > and the java statement: >>> > >>> > sqlMap.insert("role.insert", role); >>> > >>> > which generates the folloing log entry: >>> > >>> > DEBUG [http-8888-Processor4] - {conn-100009} Preparing Statement: >>> > insert into role (RoleID, ParentID, Name, Notes) >>values (?, ?, ?, >>> > ?) >>> > >>> > but no Executing Statement: or Parameters: entries. >>> > Also no exception is thrown nor is anything writtent to >>the (MySQL) >>> database. >>> > >>> >>> >>
