list of params

classic Classic list List threaded Threaded
1 message Options
fee
Reply | Threaded
Open this post in threaded view
|

list of params

fee
This post was updated on .
I am passing 3 params i.e a Hashmap with the below in Java to the ibatis SQL
1. Integer
2. Integer
3  List of Integer -- empIDs as key and value as List of Integer Objects

In the sql not sure how to access the list with ibatis.


Tried this
<iterate property="list" open=" AND emp.EMPID IN (" close=")" conjunction=",">
                          #empIDs[]#
</iterate>

Not sure what this property="list" mean. I saw in one of the websites and tried the above

I am getting this error.
Cause: com.ibatis.common.beans.ProbeException: Error getting ordinal list from JavaBean. Cause java.lang.NumberFormatException: For input string: "">....
.....................................................


I tried passing in the string with ",". that didn't give me the expected result. Not sure how to proceed on this.

Any help is appreciated.