Return-Path: 
 <user-java-return-14190-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 65626 invoked from network); 18 Apr 2008 14:00:16 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 18 Apr 2008 14:00:16 -0000
Received: (qmail 68750 invoked by uid 500); 18 Apr 2008 14:00:13 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 68740 invoked by uid 500); 18 Apr 2008 14:00:13 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 68712 invoked by uid 99); 18 Apr 2008 14:00:13 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Apr 2008 07:00:13 -0700
X-ASF-Spam-Status: No, hits=1.2 required=10.0
	tests=SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Received: from [209.85.198.249] (HELO rv-out-0506.google.com) (209.85.198.249)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Apr 2008 13:59:29 +0000
Received: by rv-out-0506.google.com with SMTP id b17so283053rvf.36
        for <user-java@ibatis.apache.org>;
 Fri, 18 Apr 2008 06:59:41 -0700 (PDT)
Received: by 10.140.251.1 with SMTP id y1mr1520110rvh.11.1208527181613;
        Fri, 18 Apr 2008 06:59:41 -0700 (PDT)
Received: by 10.141.128.8 with HTTP; Fri, 18 Apr 2008 06:59:41 -0700 (PDT)
Message-ID: <5fb0f140804180659o2d42ab21xb98ab1f2ddff4472@mail.gmail.com>
Date: Fri, 18 Apr 2008 15:59:41 +0200
From: "Chris Marshall" <chris@campsbayterrace.com>
To: user-java@ibatis.apache.org
Subject: Re: iBATIS insert does not execute
In-Reply-To: <2fe5ef5b0804180610s1746be4fpcab9dbfd04bf630d@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <5fb0f140804180510nd6f3d46yeb715e6a230496ca@mail.gmail.com>
	 <2fe5ef5b0804180610s1746be4fpcab9dbfd04bf630d@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

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.
> >
>
>