[CDBI] MySQL and transactions

Justin Guenther jguenther at gmail.com
Thu Nov 10 23:02:12 GMT 2005


On 11/10/05, Perrin Harkins <perrin at elem.com> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digitalcraftsmen.net/mailman/private/classdbi/attachments/20051110/4e7bd631/attachment.htm


More information about the ClassDBI mailing list