Re: batch example - Mailing list pgsql-jdbc

Hello Troy,

> Can someone point me to an example using a batch statement for
> Postgresql?
>
Maybe this helps... Don't be confused about the creation of the
SQL-Statements, the point is "sth.addBatch" and "sth.executeBatch".

    public void saveChanges() throws SQLException {
      if (! dataChanged) return;

      Statement sth = PDMObject.this.con.createStatement();
      for (int i = 0; i < attributeCount; i++) {
        try {
          if (attributes[i].isNew()) {
            sth.addBatch("INSERT INTO PDM_Spaltennamen (name, typid,
text_de, text_en, text_fr, pos, menueIndex) VALUES (" +
            "'" + attributes[i].getName() + "', " +
            "(SELECT id FROM PDM_Typen WHERE (objektTyp = '" +
relationName + "')), " +
            ((attributes[i].getText("de") != null) ? ("'" +
attributes[i].getText("de") + "'") : "NULL") + ", " +
            ((attributes[i].getText("en") != null) ? ("'" +
attributes[i].getText("en") + "'") : "NULL") + ", " +
            ((attributes[i].getText("fr") != null) ? ("'" +
attributes[i].getText("fr") + "'") : "NULL") + ", " +
            + attributes[i].getPosition() + ", " +
            0 + ")"
            );
          } else {
            sth.addBatch("UPDATE PDM_Spaltennamen SET " +
                         ((attributes[i].getText("de") != null) ?
("text_de = '" + attributes[i].getText("de") + "'") : "text_de = NULL")
+ ", " +
                         ((attributes[i].getText("en") != null) ?
("text_en = '" + attributes[i].getText("en") + "'") : "text_en = NULL")
+ ", " +
                         ((attributes[i].getText("fr") != null) ?
("text_fr = '" + attributes[i].getText("fr") + "'") : "text_fr = NULL")
+ ", " +
                         "pos = " + attributes[i].getPosition() + ", " +
                         "menueIndex = " + 0 +
                         " WHERE (name = '" + attributes[i].getName() +
"') AND " +
                         "(typid = (SELECT id FROM PDM_Typen WHERE
(objekttyp = '" + relationName + "')))"
                         );
          }
        } catch (WrongArgumentException e) { // sollte nicht passieren,
sonst Programmierfehler
          e.printStackTrace();
        }
      }
      sth.executeBatch();
      sth.close();
      dataChanged = false;
    }


Greetings

Thorsten