**Mybatis批量插入Oracle时,Oracle中sql执行成功,程序中报错_frch_item_0 not found????
**
这条sql语句执行没问题:
insert all into fr_employee (EMP_NO, EMP_NAME, DEPT_NO) values (10000, 'dsadadwa', 155)
into fr_employee (EMP_NO, EMP_NAME, DEPT_NO) values (10002, 'dsadadwa', 155)
into fr_employee (EMP_NO, EMP_NAME, DEPT_NO) values (10003, 'dsadadwa', 155)
SELECT 1 FROM dual;
sqlmap配置部分如下:
<insert id="addList1" parameterType="java.util.List"
useGeneratedKeys="false" flushCache="false">
INSERT ALL
<foreach item="item" index="index" collection="list">
into fr_employee (EMP_NO, EMP_NAME, DEPT_NO) VALUES
(
#{item.EMPNO,jdbcType=INTEGER},
#{item.EMPNAME,jdbcType=VARCHAR},
#{item.DEPTNO,jdbcType=INTEGER}
)
</foreach>
SELECT 1 FROM DUAL
</insert>