Re: Using auto-commit OFF for transactions - instead of - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Using auto-commit OFF for transactions - instead of
Date
Msg-id Pine.BSO.4.56.0403080827370.26593@leary.csoft.net
Whole thread Raw
In response to Re: Using auto-commit OFF for transactions - instead of  (Dave Cramer <pg@fastcrypt.com>)
List 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

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Using auto-commit OFF for transactions - instead of
Next
From: Paul Thomas
Date:
Subject: Re: Using auto-commit OFF for transactions - instead of BEGIN