当前位置:首页 > 编程笔记 > 正文
已解决

批量新增报错PSQLException: PreparedStatement can have at most 65,535 parameters.

来自网友在路上 175875提问 提问时间:2023-11-05 18:59:33阅读次数: 75

最佳答案 问答题库758位专家为你答疑解惑

报错信息:
org.postgresql.util.PSQLException: PreparedStatement can have at most 65,535 parameters. Please consider using arrays, or splitting the query in several ones, or using COPY. Given query has 661,068 parameters
; SQL []; PreparedStatement can have at most 65,535 parameters. Please consider using arrays, or splitting the query in several ones, or using COPY. Given query has 661,068 parameters; nested exception is org.postgresql.util.PSQLException: PreparedStatement can have at most 65,535 parameters. Please consider using arrays, or splitting the query in several ones, or using COPY. Given query has 661,068 parameters

翻译:
这个错误是因为PreparedStatement最多只能有65,535个参数。你可以尝试使用数组、将查询拆分成几个部分或者使用COPY方法来解决这个问题。

导致原因:
数据入湖,一次性批量新增一万多条数据,加不进去,报错,没想到PreparedStatement还有限制。

解决方案:
限制批量添加的条数,一次性加两千条,多执行几次。

查看全文

99%的人还看了

猜你感兴趣

版权申明

本文"批量新增报错PSQLException: PreparedStatement can have at most 65,535 parameters.":http://eshow365.cn/6-32911-0.html 内容来自互联网,请自行判断内容的正确性。如有侵权请联系我们,立即删除!