ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chick, Brian" <Brian.Ch...@qg.com>
Subject DataMapper <iterate> issue
Date Mon, 31 Jul 2006 18:59:06 GMT
Hello - 

Is anyone having luck using the latest version of iBatis and the
<iterate> dynamic SQL tag?  What was working fine in a previous version
(1.2.1) no longer does.  What used to work:

<!-- CustomerSearchData.AccountData returns a collection of Account
objects, each having an AccountId property -->
<select id="SelectCustomersByAccountIds"
parameterClass="Sample.Test.NameSpace.CustomerSearchData"
resultMap="CustomerResultMap">
    select C.ACCOUNT_ID
           C.FIRST_NM
           C.LAST_NM
    from CUSTOMER C
    where C.ID in 
          <iterate property="AccountData" open="(" close=")"
conjunction="," >
              #AccountData[].AccountId#
          </iterate> 
</select> 

Now throws this exception:

ProbeException: "Error getting ordinal value from .net object.
CauseInput string was not in a correct format."

I'm looking through the source code and it appears the whole process of
applying a parameter map has changed from 1.2.1 to 1.5 beta.  The
ObjectProbe object is trying to parse an index value that is not present
in the string "AccountData[].AccountId".  Should there really be an
index between the "[]"?


Thanks, 

Brian Chick
Information Systems - Software Development

Quad/Graphics
www.QG.com

Mime
View raw message