Hello Folks,
I have a List of Ints that I would like to iterate over while using a
parameterMap in my select statement. I am using a hashmap. My parameterMap
and statement are shown below.
I get the error ParameterObject or property was not a Collection, Array or
Iterator.
Any Ideas on how to resolve?
I am using Postres.
<parameterMap class="java.util.Map" id="EntityPersonMatchReqPMap">
<parameter property="ArrayVals" javaType="OBJECT"
jdbcType="ARRAY"
mode="IN" />
<parameter property="Threshold"
javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="SurnameAcc"
javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="SurnameScore"
javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="GivennameScore" javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="GivennameAcc"
javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="FullnameScore" javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="FullnameAcc"
javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="PrefixScore"
javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="PrefixAcc"
javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="SuffixScore"
javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="SuffixAcc"
javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="SSNScore"
javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="SSNAcc"
javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="MaidennameScore" javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="MaidennameAcc" javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="MiddlenameScore"
javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
<parameter property="MiddlenameAcc" javaType="java.lang.Integer"
jdbcType="INTEGER" mode="IN" />
</parameterMap>
<select id="GetPersonEntityMatchTuples"
parameterMap="EntityPersonMatchReqPMap" resultMap="EntityMatchTupleResult">
SELECT matchid,
entity1id,
entity2id,
thresholdtotal
FROM comparepersonentities(
<iterate open="ARRAY[" close="]" conjunction=",">
?
</iterate>
,?, ?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?)
</select>
--
View this message in context:
http://old.nabble.com/Iterating-over-an-Array-or-List-in-parameterMap-tp27788354p27788354.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
