Help with parametermap ( List in a Map )

[leo71]

Hi
I am trying to set a list in a map as the parameterMap 

See the code below
 
 <select id="getInfo" parameterClass="java.util.HashMap"
resultMap="someResult">
        SELECT 
                firstName AS firstName,
                lastName AS lastName
                FROM employee
        WHERE employee_dept_id = #employeeDeptId# 
         and class_id in 
        <iterate property="classId" open="(" close=")" conjunction=",">
         #[],javaType=java.lang.Integer,jdbcType=INTEGER# 
        </iterate> 
        
  </select>     
  
  Java part is
  List classId= new ArrayList();
  classId.add(new Integer(0));
  classId.add(new Integer(1));
  classId.add(new Integer(2));
  
  HashMap parameters = new HashMap();
  parameters.put("employeeDeptId", "ABC123");
  parameters.put("classId", classId);
  
  List classifiedEmployees =
getTemplate().queryForList("getClassifiedEmployees",parameters);
  
  It gives me the following
  --- Cause: com.ibatis.common.beans.ProbeException: Error getting ordinal
list from JavaBean. Cause java.lang.NumberFormatException: For input string:
""
  
  
I tried changing it  like this
        <iterate property="classId" open="(" close=")" conjunction=",">
         #classId[],javaType=java.lang.Integer,jdbcType=INTEGER# 
        </iterate>      
        
        That solves the exception problem but does not return any rows even 
though
it should return 2 rows
        
Please let me know if any one can help me with this. I spend a lot of time
but did not find good documentation on how parameter maps 
should be created with lists inside maps. I tried to debug into the ibatis
code but am not getting anywhere.
-- 
View this message in context: 
http://www.nabble.com/Help-with-parametermap-%28-List-in-a-Map-%29-tp19331531p19331531.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.