Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:114223
MIME-Version: 1.0
References: <59966331-f58b-a049-a2ce-fe3d4a4e5524@greg0ire.fr> <56F8FD1D-2532-4714-A03E-40BE16D4A416@gmail.com>
In-Reply-To: <56F8FD1D-2532-4714-A03E-40BE16D4A416@gmail.com>
Date: Tue, 27 Apr 2021 18:19:40 -0700
Message-ID: <CAP-hcNSV-AjaSEA4rRCbjv+vNBU=85Qy64EqYqGhmT1h6+je1w@mail.gmail.com>
To: Gabriel O <gadelat@gmail.com>
Cc: =?UTF-8?Q?Gr=C3=A9goire_PARIS?= <postmaster@greg0ire.fr>, 
	internals@lists.php.net
Content-Type: multipart/alternative; boundary="000000000000e7718c05c0fe2c72"
Subject: Re: [PHP-DEV] RFC: mysqli::in_transaction
From: morozov@tut.by (Sergei Morozov)

--000000000000e7718c05c0fe2c72
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

There is the SQLGetConnectAttr method and the SQL_ATTR_AUTOCOMMIT attribute
(part of the ISO 92 standard) which should allow detecting the transaction
state at the driver level. This API used by the SQL Server extensions (to
manage the transaction) and it also seems to be available for Oracle and
IBM DB2 drivers as well.

I'd like to start with the mysqli driver specifically because:

   1. MySQL is one of the DB platforms that doesn't support in transactions=
.
   2. It's much more widely used with PHP than Oracle.

We can attempt to implement this functionality in different DB extensions
independently since they don't depend on each other.

On Mon, Apr 26, 2021 at 1:11 AM Gabriel O <gadelat@gmail.com> wrote:

> What about OCI8 driver? That=E2=80=99s also included in core.
>
> Also a sidermark: SQLSrv and IBMDB2 are not part of core, but situation
> should be checked in those as well, since they are supported in DBA tooL
>
> Powered by *Mailbutler
> <https://www.mailbutler.io/?utm_source=3Dwatermark&utm_medium=3Demail&utm=
_campaign=3Dwatermark-essential-email>*,
> the email extension that does it all
>


--=20
Sergei Morozov

--000000000000e7718c05c0fe2c72--