You cannot use an iterated property in the decision tags. I believe there is a JIRA issue for this.
<isNotNull property="contentBeanTrees[].detailsTable"> --> not allowed Niels -----Original Message----- From: Daniel Pitts [mailto:[EMAIL PROTECTED] Sent: woensdag 22 maart 2006 2:44 To: [email protected] Subject: Problem with dynamic query. 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="dynamicQuery" resultClass="java.util.HashMap" parameterClass="java.util.Map"> <dynamic> SELECT <iterate property="properties" conjunction=","> `$properties[].tableAlias$`.$properties[].sourceColumn$ AS `$properties[].path$` </iterate> FROM <iterate property="contentBeanTrees" conjunction="join"> content AS `$contentBeanTrees[].contentTableAlias$` <isNotNull property="contentBeanTrees[].detailsTable"> JOIN $contentBeanTrees[].detailsTable$ AS `$contentBeanTrees[].detailsTableAlias$` </isNotNull> </iterate> <iterate property="constraints" conjunction="AND" prepend="WHERE"> `$constraints[].tableAlias$`.$constraints[].sourceColumn$= #constraints[].value# </iterate> </dynamic> </select>
