ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Marshall" <ch...@campsbayterrace.com>
Subject Re: iBATIS insert does not execute
Date Fri, 18 Apr 2008 13:59:41 GMT
Thanks for you rapid reply Brandon.

It appears to be on all tables, but read and delete operate perfectly.

Versions are:
ibatis 2.3.0.677
mysql connector 5.0.8
mysql 5.0.51
jre jdk 1.6.0_04

Thanks, Chris

On 18/04/2008, Brandon Goodin <brandon.goodin@gmail.com> 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 <chris@campsbayterrace.com>
> 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.
> >
>
>

Mime
View raw message