Re: Strange executing batch

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@xxxxxxxxxxxxxxxxx
http://www.shamrock-games.ru


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings