Return-Path: 
 <user-java-return-6469-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 88549 invoked from network); 22 Mar 2006 01:44:49 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 22 Mar 2006 01:44:49 -0000
Received: (qmail 61507 invoked by uid 500); 22 Mar 2006 01:44:49 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 61030 invoked by uid 500); 22 Mar 2006 01:44:47 -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 61019 invoked by uid 99); 22 Mar 2006 01:44:47 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Mar 2006 17:44:47 -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; Tue, 21 Mar 2006 17:44:46 -0800
Received: from cnet139.cnet.cnwk (cnet139.cnet.cnwk [10.16.81.74])
	by cn-sfo1-mail-relay2.cnet.com (8.12.10/8.12.10) with ESMTP id
 k2M1iP4w014361
	for <user-java@ibatis.apache.org>; Tue, 21 Mar 2006 17:44:25 -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 cnet139.cnet.cnwk with
 Microsoft SMTPSVC(6.0.3790.1830);
	 Tue, 21 Mar 2006 17:44:25 -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: Problem with dynamic query.
Date: Tue, 21 Mar 2006 17:44:24 -0800
Message-ID: <7E4302A18925394BAC32C7AD1ABE75D45F62C4@CNET6.cnet.cnwk>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Problem with dynamic query.
Thread-Index: AcZNUiYQFJueCEpSSTGtJ8jYK+6/3A==
From: "Daniel Pitts" <Daniel.Pitts@cnet.com>
To: <user-java@ibatis.apache.org>
X-OriginalArrivalTime: 22 Mar 2006 01:44:25.0234 (UTC)
 FILETIME=[26541720:01C64D52]
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

I'm trying the following dynamic query, and ibatis throws an exception
on initialization. (Even before I call the query) The exception is a
Probe exception, cannot find ordinal for JavaBean , caused by
NumberFormatException from string "".
Can anyone tell me what I'm doing wrong?

Query:
    <select id=3D"dynamicQuery" resultClass=3D"java.util.HashMap"
parameterClass=3D"java.util.Map">
        <dynamic>
        SELECT
            <iterate property=3D"properties" conjunction=3D",">
                `$properties[].tableAlias$`.$properties[].sourceColumn$
AS `$properties[].path$`
            </iterate>
        FROM
            <iterate property=3D"contentBeanTrees" conjunction=3D"join">
                content AS `$contentBeanTrees[].contentTableAlias$`
                <isNotNull property=3D"contentBeanTrees[].detailsTable">
                    JOIN $contentBeanTrees[].detailsTable$ AS
`$contentBeanTrees[].detailsTableAlias$`
                </isNotNull>
            </iterate>
            <iterate property=3D"constraints" conjunction=3D"AND"
prepend=3D"WHERE">
=20
`$constraints[].tableAlias$`.$constraints[].sourceColumn$=3D
                #constraints[].value#
            </iterate>
        </dynamic>
   </select>