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(at)shamrock-games(dot)ru
http://www.shamrock-games.ru