mybatis批量插入oracle时需要显式指定为 useGeneratedKeys=“false”
insert into SIGN_CREDIT_HIS (ID, PERSON_ID, CREDIT,
CREDIT_TIME, NOTE)
select SYSTEM_SEQ.nextval,m.* from (
select #{item.personId,jdbcType=DECIMAL}, #{item.credit,jdbcType=DECIMAL},
#{item.creditTime,jdbcType=VARCHAR}, #{item.note,jdbcType=VARCHAR} from dual
) m
mybatis批量插入报错问题
最新推荐文章于 2024-08-01 00:59:31 发布