Re: batch example

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