Re: AutoCommit and Coding Standards
Date: Wed, 31 Jan 2001 11:54:19 -0800
Message-ID: <3a786ce3_at_rpc1284.daytonoh.ncr.com>
No, you cannot safely assume that auto-commit is the default. You cannot assume that every ODBC driver even supports auto-commit (though most do).
The ODBC spec says: " If a driver supports the SQL_AUTOCOMMIT conection option, the default transaction mode is auto-commit; otherwise, it is manual-commit."
<jsander_puc_at_my-deja.com> wrote in message
news:959j03$mr8$1_at_nnrp1.deja.com...
> Hello,
>
> does anybody know if any SQL standard does say something about
> autocommit default behaviour?
>
> Can you, as an application developer, safely assume that your ODBC/JDBC
> application will always use autocommit by default in any RDBMS
> environment?
>
> Is autocommit a feature that is supported by a database engine or do
> clients have to issue an explicit commit after each statement when they
> talk to the server?
>
> Any hints wellcome
> Johann Sander
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Jan 31 2001 - 20:54:19 CET