I have written my my insert statement like this
<insert id="batchInsertApprovals" parameterType="java.util.List" >
insert into approvals (APPROVALID, SOURCESYSTEM, APPROVALTYPE, APPROVAL,
SOURCESYSTEMID,
APPROVALDESC, DELEGATEDBY, STATUS, ASSIGNEDDATE, DUEDATE, UPDATEDBY,
UPDATEDON)
values
<foreach item="item" collection="list" open ="(" separator="," close=")">
(
#{item.projectDetails.approvalId},#{item.projectDetails.approvalSystem},#{item.projectDetails.approvalType},#{item.projectDetails.approvalName},
#{item.projectDetails.prismId},
#{item.projectDetails.description},#{item.projectDetails.delegateBy},#{item.projectDetails.status},#{item.projectDetails.createdOn},#{item.projectDetails.dueDate},#{item.projectDetails.assignedApprovercuid},#{item.projectDetails.createdOn})
</foreach>
</insert>
Using this i'm getting this error
"org.apache.ibatis.binding.BindingException: Parameter '__frch_item_0' not
found. Available parameters are [list] "
I had also tried removing projectDetails from values
Could you please help me in writing ibatis insert query
Thanks
--
View this message in context:
http://camel.465427.n5.nabble.com/Camel-Ibatis-tp5740547p5740562.html
Sent from the Camel - Users mailing list archive at Nabble.com.
