Return-Path: 
 <user-java-return-6502-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 18137 invoked from network); 23 Mar 2006 23:37:02 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 23 Mar 2006 23:37:02 -0000
Received: (qmail 43419 invoked by uid 500); 23 Mar 2006 23:37:00 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 43402 invoked by uid 500); 23 Mar 2006 23:37:00 -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 43389 invoked by uid 99); 23 Mar 2006 23:37:00 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Mar 2006 15:37:00 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [216.239.124.18] (HELO cn-sfo1-mail-relay2.cnet.com)
 (216.239.124.18)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Mar 2006 15:36:59 -0800
Received: from cnet138.cnet.cnwk (cnet138.cnet.cnwk [10.16.81.37])
	by cn-sfo1-mail-relay2.cnet.com (8.12.10/8.12.10) with ESMTP id
 k2NNac4w019267
	for <user-java@ibatis.apache.org>; Thu, 23 Mar 2006 15:36:38 -0800 (PST)
X-Spam-Filter: check_local@cn-sfo1-mail-relay2.cnet.com by digitalanswers.org
Received: from CNET6.cnet.cnwk ([10.16.81.119]) by cnet138.cnet.cnwk with
 Microsoft SMTPSVC(6.0.3790.1830);
	 Thu, 23 Mar 2006 15:36:38 -0800
x-mimeole: Produced By Microsoft Exchange V6.5.7226.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Unary conditional problem
Date: Thu, 23 Mar 2006 15:36:37 -0800
Message-ID: <7E4302A18925394BAC32C7AD1ABE75D464DE92@CNET6.cnet.cnwk>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Unary conditional problem
Thread-Index: AcZO0MxAW9kcXlNCTLyx3cEGc4ejywAAZ4cQ
From: "Daniel Pitts" <Daniel.Pitts@cnet.com>
To: <user-java@ibatis.apache.org>
X-OriginalArrivalTime: 23 Mar 2006 23:36:38.0180 (UTC)
 FILETIME=[A13BFE40:01C64ED2]
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

It looks to me like the selectKey isn't allowed to be dynamically used.
You might have to make two separate cases, and compare documentId in
java code.=20

-----Original Message-----
From: Adediran.Ayandele@Sun.COM [mailto:Adediran.Ayandele@Sun.COM]=20
Sent: Thursday, March 23, 2006 3:23 PM
To: ibatis user list
Subject: Unary conditional problem

Hey Guys!
    Is there some simple reason I get this error:
Caused by: org.xml.sax.SAXParseException: The content of element type
"isEmpty" must match
"(include|iterate|isParameterPresent|isNotParameterPresent|isEmpty|isNot
Empty|isNotNull|
isNull|isNotEqual|isEqual|isGreaterThan|isGreaterEqual|isLessThan|isLess
Equal|isProperty
Available|isNotPropertyAvailable)".

Out of this sql:

    <insert id=3D"insertMetricDocument" =
parameterClass=3D"MetricDocument">
        <isEmpty property=3D"documentId">
            <selectKey resultClass=3D"string" =
keyProperty=3D"documentId">
                select SC_METRIC_DOCUMENTS_ID.NextVal from dual
            </selectKey>
        </isEmpty>
        insert into SC_METRIC_DOCUMENTS (
             METRIC_ID,
             DOCUMENT_ID,
             VERSION,
             DOCUMENT_NAME,
             DESCRIPTION,
             FILE_EXTENSION,
             DOCUMENT,
             UPDATE_DATE,
             UPDATED_BY)
        values (
            #metricId#,
            #documentId:NUMERIC#,
            #version#,
            #documentName:VARCHAR#,
            #description:VARCHAR#,
            #fileExtension:VARCHAR#,
            #document#,
            sysdate,
            #updatedBy.employeeNumber#
            )
    </insert>

Thanks!
Diran