sql精簡如下：
select CHECKLIST_ID
from A
WHERE CHECKLIST_ID in
(1,2))
order by DT_UPDATE desc
其中CHECKLIST_ID pojo層為LONG型，mybatis resultMap映射如下 <id column="CHECKLIST_ID" jdbcType="DECIMAL" property="checklistId"/> Example_Where_Clause如下
<when test="criterion.listValue">
and ${criterion.condition}
<foreach close=")" collection="criterion.value" item="listItem" open="(" separator=",">
#{listItem}
</foreach>
</when>
這樣會(huì)報(bào)錯(cuò)
org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: java.lang.reflect.UndeclaredThrowableException The error may exist in com/lianpay/risk/check/sqlmap/RiskEventChecklistMapper.xml
當(dāng) #{listItem}改成 ${listItem} 就沒有什么問題，即：
<when test="criterion.listValue">
and ${criterion.condition}
<foreach close=")" collection="criterion.value" item="listItem" open="(" separator=",">
${listItem}
</foreach>
</when>
求解，之前一直那么用的，難道和LONG型有關(guān)？？
添加回答
舉報(bào)
0/150
提交
取消