[CDBI] MySQL and transactions

[prev] [thread] [next] [Date index for 2005/11/10]

--===============2025918550==
Content-Type: multipart/alternative; 
	boundary="----=_Part_7488_569463.1131661868357"

------=_Part_7488_569463.1131661868357
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello,

I am using Class::DBI::mysql in transactional mode (i.e. AutoCommit=3D0), a=
nd
have come across a peculiarity/bug.

Even with autocommit disabled, creating an object (i.e.
Class->create({...})) inserts a row into the database before I do a
dbi_commit(). No error messages or warnings are issued, it just silently
inserts into the database.

Basically, I have several classes that have a has-many relationship with
eachother, so if one fails to be created I don't want to have several other
half-constructed objects sitting around -- which is why I wanted to have to
manually commit everything when I'm satisfied it's done.

Am I misunderstanding something about how AutoCommit works?

Thanks,
Justin Guenther

------=_Part_7488_569463.1131661868357
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello,<br>
<br>
I am using Class::DBI::mysql in transactional mode (i.e. AutoCommit=3D0), a=
nd have come across a peculiarity/bug.<br>
<br>
Even with autocommit disabled, creating an object (i.e.
Class-&gt;create({...})) inserts a row into the database before I do a
dbi_commit(). No error messages or warnings are issued, it just
silently inserts into the database.<br>
<br>
Basically, I have several classes that have a has-many relationship
with eachother, so if one fails to be created I don't want to have
several other half-constructed objects sitting around -- which is why I
wanted to have to manually commit everything when I'm satisfied it's
done.<br>
<br>
Am I misunderstanding something about how AutoCommit works?<br>
<br>
Thanks,<br>
Justin Guenther<br>

------=_Part_7488_569463.1131661868357--


--===============2025918550==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

--===============2025918550==--