Re: Problem: commit doesn´t work

From: João Paulo Ribeiro <jp(at)mobicomp(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem: commit doesn´t work
Date: 2003-01-07 15:02:57
Message-ID: 3E1AEC21.5090909@mobicomp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi, Marcos.

As far as i know the default behaviour if something goes wrong in the
backend executing a statement during a transaction ( i assume that's the
case you are talking about) is the backend automatically to do a
rollback, terminate your transaction and report the error. As so when
you do the commit there is nothing to commit. This the default behaviour
expected and i cant tell exactly but i had used Oracle and this is the
default behaviour.
In a transaction every statement have to be successfull. If not, the
backend do automatically a rollback
The transaction is see like an unit and have to be done entirely or not
done at all.
There is some "ways" that people had invented to try to get somethink
like having a transaction but with something allowing them to control
how much they want to rollback.
Oracle use what they call "Save points". Something like transaction into
transactions. This allow that you to tell do backend to only rollback to
last save point if something goes wrong.
But again, this not the default behaviour because this is not the
behaviour expected for a transaction.

I think this is not a bug but the normal behaviour. :)
May be i am wrong.

I hope this helped.

Marcos de Barros wrote:

> 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 <mailto:mbarros(at)iclass(dot)com(dot)br>
> http://www.iclass.com.br
> Tels: (21) 2240-8747 / (21) 2220-1480

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michael Paesold 2003-01-07 15:15:46 Re: [JDBC] Problem: commit doesn´t work
Previous Message Daniel Serodio 2003-01-07 14:52:24 Re: Problem: commit doesn´t work