There is such a method

private void putToForeign(RequestGzk request) throws SQLException { Connection con = null; PreparedStatement ps = null; String sql = "INSERT INTO GZK_FOREIGN(GZK_ID, VUS_KLKOD, YEAR, SQU, KNR" + ") values(?,?,?,?,?)"; try { con = dp.getDsSrc().getConnection(); ps = con.prepareStatement(sql); for(int i = 0; i < request.getObjArray().getObj().size(); i++) { if(request.getObjArray().getObj().get(i).getObjSZArray().get(0).getObjSz() != null){ ps.setString(1, String.valueOf(request.getObjArray().getObj().get(i).getId())); ps.setString(2, request.getObjArray().getObj().get(i).getObjSZArray().get(0).getObjSz().get(0).getVusKlkod()); ps.setString(3, request.getObjArray().getObj().get(i).getObjSZArray().get(0).getObjSz().get(0).getYear()); ps.setString(4, request.getObjArray().getObj().get(i).getObjSZArray().get(0).getObjSz().get(0).getSqu()); ps.setString(5, request.getObjArray().getObj().get(i).getKnr()); ps.addBatch(); } } ps.executeUpdate(); } catch(SQLException ex){ Logger.getLogger(GzkParser.class.getName()).log(Level.SEVERE, null, ex); } }

when I call throws exception:

 java.sql.SQLException: ошибка при пакетировании: batch must be either executed or cleared

ps.addBatch(); - I ps.executeBatch() replaced ps.executeBatch() or ps.execute () then the cycle did not function correctly

    1 answer 1

    try ps.executeUpdate(); replace with ps.executeBatch()