Return-Path: 
 <user-java-return-4716-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 30660 invoked from network); 27 Oct 2005 08:27:38 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 27 Oct 2005 08:27:38 -0000
Received: (qmail 69484 invoked by uid 500); 27 Oct 2005 08:27:35 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 69465 invoked by uid 500); 27 Oct 2005 08:27:35 -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 69450 invoked by uid 99); 27 Oct 2005 08:27:34 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Oct 2005 01:27:34 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of kwon37xi@gmail.com designates
 64.233.184.198 as permitted sender)
Received: from [64.233.184.198] (HELO wproxy.gmail.com) (64.233.184.198)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Oct 2005 01:27:32 -0700
Received: by wproxy.gmail.com with SMTP id 67so130989wri
        for <user-java@ibatis.apache.org>;
 Thu, 27 Oct 2005 01:27:13 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=lGMlhFzH5RhPRFhEc+HU/bFUG72EuIc1/h9Tt0IXw2jHxFBMXFutEAdCHN6DXb3m31QPi4b73gtum8nFL8vIA9qeFG26CX2iiTpMqfm38mhGccvXiBEuDA6gPKlk0Qq+S8Fm83wdIs7DTy9WtwePpFqg2O/jCy/WlqQ5zDYrx6o=
Received: by 10.54.146.10 with SMTP id t10mr821932wrd;
        Thu, 27 Oct 2005 01:27:13 -0700 (PDT)
Received: by 10.54.62.19 with HTTP; Thu, 27 Oct 2005 01:27:13 -0700 (PDT)
Message-ID: <b615a5110510270127s6efea85ej@mail.gmail.com>
Date: Thu, 27 Oct 2005 17:27:13 +0900
From: KwonNam Son <kwon37xi@gmail.com>
To: iBatisUser <user-java@ibatis.apache.org>
Subject: When there are no statement, iBatis throws an exception.
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

I have some insert statement like the follwoing...

<insert id=3D"idInsert" parameterClass=3D"java.util.Map">
   <isNotEmpty property=3D"p_share">
    INSERT INTO TMLBC060 (
     USER_ID, RIGHT_CODE, SERVICE_CODE, SERVICE_SHARE
    ) VALUES (
     #p_user_id#, #p_share_right_code#, #p_share_service_code#, #p_share#
    )
   </isNotEmpty>
  </insert>

When p_share property is empty, IdInsert has no statement in it. This
statement runs in a batch.
In this condition, iBatis throws an exception.

Is there any way of preventing throwing an excetion?

Because of some complicated reasons, It's very difficult to check
p_share property in Java.
Also, I could make an dummy insert statement(like "insert into dummy
select 'x' from dual where 1=3D0;"), but I hope I could avoid that kind
solution.

Thanks,
KwonNam.