myBatis批量插入Oracle

<insert id="insertTopnCallerAddressAndNum" parameterType="list"> insert into table_name(column1,column2,column3,column4) <foreach collection="list" item="toplist" separator="UNION ALL"> (select #{toplist.COLUMN1,jdbcType=VARCHAR},#{toplist.COLUMN2,jdbcType=NUMERIC},0,#{toplist.COLUMN4,jdbcType=VARCHAR} from dual) </foreach></insert>

注意：myBatis的批量插入和mysql不同。

语言 方法

5620 aAdHQGntrO

277a1现在做什么生意赚钱

1527 2010/03/10 15:40:36

注解版mybatis_oracle批量插入：

@Insert({ "<script>", "insert into phoneinfo (", "id," , "phone," , "phone_type, " , "insert_time," , "insert_user ) (" , "<foreach collection='phoneInfos' item='phone' index='index' separator='union all'>", " (select #{phone.id,jdbcType=VARCHAR}, " , " #{phone.phone,jdbcType=VARCHAR}, " , " #{phone.phone_type,jdbcType=VARCHAR}, " , " to_date(#{phone.insert_time,jdbcType=VARCHAR},'yyyy-mm-dd hh24:mi:ss'), " , " #{phone.insert_user,jdbcType=VARCHAR} from dual)" , "</foreach> )", "</script>" }) int betchInsertPhone(@Param("phoneInfos")List<PhoneInfo> phoneInfos); 注意：在批量插入的时候如果不限制批量插入的条数，则会出现下面问题: 2019-11-21 15:00:12.365 ERROR o.a.c.c.C.[.[.[.[dispatcherServlet] - Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Handler dispatch failed; nested exception is java.lang.StackOverflowError] with root causejava.lang.StackOverflowError: null at com.alibaba.druid.sql.dialect.oracle.parser.OracleExprParser.primaryRest(OracleExprParser.java:668) at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:796) at com.alibaba.druid.sql.dialect.oracle.parser.OracleExprParser.primary(OracleExprParser.java:462) at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:86) at com.alibaba.druid.sql.parser.SQLExprParser.exprList(SQLExprParser.java:1279)