Re: [CDBI] MySQL and transactions
[prev]
[thread]
[next]
[Date index for 2005/11/10]
--===============1180261557==
Content-Type: multipart/alternative;
boundary="----=_Part_7925_20298246.1131663732910"
------=_Part_7925_20298246.1131663732910
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
On 11/10/05, Perrin Harkins <perrin@xxxx.xxx> wrote:
>
> On Thu, 2005-11-10 at 16:31 -0600, Justin Guenther wrote:
> > Even with autocommit disabled, creating an object (i.e. Class->create
> > ({...})) inserts a row into the database before I do a dbi_commit().
>
> Can you see that row from other connections before it is committed?
> That's what it means to do a database commit -- other connections can
> see your changes. Until then, they can be rolled back.
Yes, that's what I meant. I stepped through my code with the perl debugger,
stepped over the create() call, then loaded up the CLI mysql client and did
a SELECT and the row that had not yet been committed was there.
- Perrin
>
>
------=_Part_7925_20298246.1131663732910
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
On 11/10/05, <b class=3D"gmail_sendername">Perrin Harkins</b> <<a href=
=3D"mailto:perrin@xxxx.xxx">perrin@xxxx.xxx</a>> wrote:<div><span class=
=3D"gmail_quote"></span><blockquote class=3D"gmail_quote" style=3D"border-l=
eft: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left:=
1ex;">
On Thu, 2005-11-10 at 16:31 -0600, Justin Guenther wrote:<br>> Even with=
autocommit disabled, creating an object (i.e. Class->create<br>> ({.=
..})) inserts a row into the database before I do a dbi_commit().<br><br>
Can you see that row from other connections before it is committed?<br>That=
's what it means to do a database commit -- other connections can<br>see yo=
ur changes. Until then, they can be rolled back.</blockquote><di=
v><br>
Yes, that's what I meant. I stepped through my code with the perl
debugger, stepped over the create() call, then loaded up the CLI mysql
client and did a SELECT and the row that had not yet been committed was
there. </div><br><blockquote class=3D"gmail_quote" style=3D"border-lef=
t: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1=
ex;">- Perrin<br><br></blockquote></div><br>
------=_Part_7925_20298246.1131663732910--
--===============1180261557==
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
--===============1180261557==--
