From: | "Marcel Steinbach" <steinbach(at)gmx(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | incomplete batch-inserts |
Date: | 2007-07-11 12:58:11 |
Message-ID: | 20070711125811.313870@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hello,
i'm having trouble with batches. When I run into an BatchUpdateException,
the table is filled up to a multiple of 256 records (guess, the batch seems to be executed in 256-steps), and, for example, if the Exception was thrown at the 300. statements, the tablesize is 256, and 44 are missing - but: The getUpdateCount() says, that all statements until the Exception (299) affacted "1" row.
My code looks something like this:
---------------------------------------------------------
PreparedStatement stmt = con.prepareStatement(sql);
con.setAutoCommit(true);
for (int i = 0; i < objectBuffer.length; i++) {
for (int j =0; j < objectBuffer[i].length; j++) {
stmt.setObject(j+1, objectBuffer[i][j]);
}
stmt.addBatch();
}
int updateCount[] = { };
try {
updateCount = stmt.executeBatch();
} catch (...) { ...
---------------------------------------------------------
Some ideas whats wrong? I'm using postgresql-8.1-405.jdbc3.
Best Regards
Marcel Steinbach
From | Date | Subject | |
---|---|---|---|
Next Message | Marcel Steinbach | 2007-07-11 13:17:19 | incomplete batch-updates |
Previous Message | Diego Zanga | 2007-07-11 09:07:49 | postgres jdbc into eclipse plugin (OID problems) |