Problem: commit doesn´t work

Hi Group,

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]);
}
}
}
connection.commit();

Thank you a lot!

Best Regards,

Marcos de Barros
Iclass Consultoria
mbarros(at)iclass(dot)com(dot)br
http://www.iclass.com.br
Tels: (21) 2240-8747 / (21) 2220-1480