Thread: Strange executing batch

Hi , pgsql-jdbc.

 How jdbc driver works with batch in one transaction all added
 statement  or  each statement in individual transaction?

Class.forName("org.postgresql.Driver");

Connection c = DriverManager.getConnection("jdbc:postgresql:....");

PreparedStatement p = c.prepareStatement("insert into test(test) values(?)");
c.setAutoCommit(false);
for (int i = 0; i < 1000; i++) {
 p.setString(1, "test"+i);
 p.addBatch();
}

p.executeBatch();

If at executing executeBatch() on 500 statement error is arised ,that
for some reason first 499 statement are  committed.

--
Truly yours,
 Ilya                          mailto:i_il@mail.ru

Greetings,

IB> Class.forName("org.postgresql.Driver");
IB> Connection c = DriverManager.getConnection("jdbc:postgresql:....");
IB> PreparedStatement p = c.prepareStatement("insert into test(test) values(?)");
IB> c.setAutoCommit(false);
IB> for (int i = 0; i < 1000; i++) {
IB>  p.setString(1, "test"+i);
IB>  p.addBatch();
IB> }
IB> p.executeBatch();

IB> If at executing executeBatch() on 500 statement error is arised ,that
IB> for some reason first 499 statement are  committed.

Any suggestions/thoughts on the question? I'm not sure this is a JDBC
issue but the problem looks dangerous.



--
Alexander V. Morokhovets
+7 3832 132528

Shamrock Games
efdi@shamrock-games.ru
http://www.shamrock-games.ru