PreparedStatementpresmt=conn.prepareStatement(strsql);for(TaskInfotbinfo:taskInfos){presmt.setInt(1,(int)tbinfo.getTaskid());presmt.setInt(2,(int)tbinfo.getTimes());presm...
PreparedStatement presmt=conn.prepareStatement(strsql);
for (TaskInfo tbinfo : taskInfos) {
presmt.setInt(1, (int)tbinfo.getTaskid());
presmt.setInt(2, (int)tbinfo.getTimes());
presmt.addBatch();
}
presmt.executeBatch();
执行后报错:
java.sql.BatchUpdateException: 批次处理 0 select P_WXM_ReportWordsNum(1972568,0) 被中止,呼叫 getNextException 以取得原因。
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2762)
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleResultRows(AbstractJdbc2Statement.java:2711)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1915)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:421)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929)
at com.oaqi.tools.report.ReportCount(report.java:58)
at com.oaqi.scripts.StatisticsSpeechQuantity.dowork(StatisticsSpeechQuantity.java:59)
at com.oaqi.scripts.StatisticsSpeechQuantity.getTaskInfo(StatisticsSpeechQuantity.java:26)
at com.oaqi.task.Fs_WXTaskMain.main(Fs_WXTaskMain.java:69)
这是什么原因导致的??
展开