Re: Using auto-commit OFF for transactions - instead of

From: Kris Jurka <books(at)ejurka(dot)com>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: Harry Mantheakis <harry(at)mantheakis(dot)freeserve(dot)co(dot)uk>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Using auto-commit OFF for transactions - instead of
Date: 2004-03-08 13:31:42
Message-ID: Pine.BSO.4.56.0403080827370.26593@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Mon, 8 Mar 2004, Dave Cramer wrote:

> Harry,
>
> You should use the driver's set autocommit(false) instead, as then the
> driver will know the state of the connection.
>
> BTW, I'm sure oracle has a similiar "begin" statement.
>

Oracle in fact does not have a begin statement, it does not have a native
autocommit mode, you are always in a transaction, so any commit/rollback
automatically starts a new transaction.

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Paul Thomas 2004-03-08 14:08:47 Re: Using auto-commit OFF for transactions - instead of BEGIN
Previous Message Dave Cramer 2004-03-08 12:15:31 Re: Using auto-commit OFF for transactions - instead of