ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From RyanR100 <ryan.rakow...@gmail.com>
Subject Iterating over an Array or List in parameterMap
Date Thu, 04 Mar 2010 23:59:23 GMT

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: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message