批量入库时报错:prepared statement contains too many placeholders
来源:互联网 发布:瑞易物管软件 编辑:程序博客网 时间:2024/05/15 16:04
Mysql的批量入库时,执行到PreparedStatment.executeBatch()这一句时,报错:prepared statement contains too many placeholders,提示占位符过多
原因:
在批量入库时,Mysql会将insert语句拼装成如下格式:
insert into tablename(字段1, 字段2, 字段3, ……, 字段45) values(:字段1, :字段2, :字段3, ……, :字段45), (:字段1, :字段2, :字段3, ……, :字段45), (:字段1, :字段2, :字段3, ……, :字段45), ……, (:字段1, :字段2, :字段3, ……, :字段45)
比如我批量入库的对象是3000+条记录,虽然我把它封装成一个List集合,但是集合里面每个元素都有45个key(一个key对应一个字段)。sql被拼装成上述格式后,占位符的个数达到3000*45=135000,大于mysql对占位符的最高限制65535。
所以需要注意的是,批量入库时,占位符的个数不再是45,而是45与条数的乘积。
0 0
- 批量入库时报错:prepared statement contains too many placeholders
- 批量入库时报错:prepared statement contains too many placeholders
- 1390 Prepared statement contains too many placeholders
- 解决:1390 Prepared statement contains too many placeholders
- Prepared statement
- git创建密匙时报错Too many arguments
- mysql的prepared statement
- faster-rcnn训练自己的数据时报错too many indices
- Statement、Prepared Statement 和Callable Statement
- MySQL报错ERROR 1615 (HY000): Prepared statement needs to be re-prepared
- prepared statement 防止sql注入
- 13.5 Prepared SQL Statement Syntax
- hibernate批量插入数据,MySQL提示:1040-Too many connections
- mysql 1615 Prepared statement needs to be re-prepared
- mysql:Prepared statement needs to be re-prepared
- mysql:Prepared statement needs to be re-prepared解决办法
- *** FATAL ERROR L232: APPLICATION CONTAINS TOO MANY RECURSIONS错误的解决方案
- tomcat 报错 Too many open files
- noip2012国王游戏
- 在Emulator上模拟来电、短信等 效果
- struts2封装页面传过来的多个id(ids)
- Java中List转换为数组,数组转List
- 开发者都应该使用的10个C++11特性
- 批量入库时报错:prepared statement contains too many placeholders
- 求树的最大宽度和最大深度
- C++11新特性
- 每天进步一点点 SQL简介
- rocketmq 启动报错 java.lang.ExceptionInInitializerError
- php算法
- 对web标准以及W3C的理解与认识
- 面试算法--if语句中使用赋值语句
- Effective Java学习笔记 第60条: 优先使用标准的异常