I´m a new membrer and have a problem with the commit in jdbc postgres. I would appreciate some help.
I have a program that execute 40000 inserts in a table. I set autocommit = false before the process and begin the loop. The 39999 insert, for example, has an error and after the loop i execute the commit command. The SQL Server or Oracle driver commit all the 39998 right inserts. The postgres doesn´t commit one. I figure it´s a bug, or i´m doing something wrong. Above is the code:
for (int i=0; i < queryList.length; i++) { if (queryList[i] != null) { try { statement.execute(queryList[i]); } catch(Exception e) { System.out.println("queryList[" + i + "]" + queryList[i]); } }