Pass a BigDecimal Array to Mapper

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Pass a BigDecimal Array to Mapper

BejoyKodiyan
This post has NOT been accepted by the mailing list yet.

i have a query in my mapper and i need to pass an arraylist to the query.Below is the query.

<select id="getDw5Details"  parameterType="batchSettlementSC" resultType="com.path.dbmaps.vo.TRSPAYPLANDETVO">
SELECT * FROM TABLE WHERE TABLE .SERIAL_NO in ( #{dealNoarr} )    
</SELECT>

It is throwing one error  "There was no TypeHandler found for parameter dealNoarr ".How can i handle.
I am new to this IBAtis.
Reply | Threaded
Open this post in threaded view
|

Re: Pass a BigDecimal Array to Mapper

BejoyKodiyan
This post has NOT been accepted by the mailing list yet.
I got ..Thank  you
               TABLE.SERIAL_NO in  
                   <foreach item="item" index="index" collection="dealNoarr"
open="(" separator="," close=")">
                                                      #{item}
                   </foreach>