请大家帮我解决一个关于mybatis的问题吧，多谢了

[蝶儿]

mapper:

select id="searchPremiumPolicyNo" resultType="String">
select policyno from prpbankqueueinfo where businessno=#{businessNo} and bankcode=#{bankCode} and exchangedate=#{exchangeDate} and bankzoneno=#{bankZoneNo} and policyno!="" and policyno not in[/size] <foreach collection="cancelPolicys" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>

</select
service: List<String> cancelPolicys = bankQueueDao.searchCancelPolicyNo("C","CCB");
Map<String, Object> params = new HashMap<String, Object>();
params.put("cancelPolicys", cancelPolicys);
params.put("bankZoneNo", areaCode);
params.put("bankCode", "CCB");
params.put("businessNo", "P");
params.put("exchangeDate", exchangeDate);
List<String> policyNos = bankQueueDao.searchPremiumPolicyNo(params);
DAO: public List<String> searchPremiumPolicyNo(Map<String,Object> params;[/size]大家帮我看看哪里出错了？
总是报一下得错误：
[16:52:48] pool-1-thread-1 INFO [] [] [org.springframework.beans.factory.xml.XmlBeanDefinitionReader] - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
[16:52:48] pool-1-thread-1 INFO [] [] [org.springframework.jdbc.support.SQLErrorCodesFactory] - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]

[花谢尊前不敢香]

怀疑是你的sql语句有问题。

[蝶儿]

我已经解决了，字段与数据库里的字段不一致导致的错误