Error occured while applying a parameter map.

Hi All,

I am getting following error message while executing an query in my java program.
com.ibatis.common.jdbc.exception.NestedSQLException:
The error occured while applying a parameter map.
Check the getPU1003New-inlineParameter Map.

I am using the following query:

        <select id="getPU1003New" resultClass="com.pfizer.maps.data.Item" parameterMap="getPU1003NewMap">
                SELECT M0DESC FROM RS1002  
               
                <dynamic prepend="where">
                        <iterate property="list" open="P3ITEM NOT IN (" close=")"
                                conjunction=",">
                                #list[]#
                        </iterate>
                </dynamic>
               
        </select>

Here the list[] contains around 3721 items. It seems that the error is occuring due to large number of items in the list.

Please let me know if how do I handle large number of items in the list. I am using ibatis 2.3.0.

Thanks in advance.

Amit