Re: AutoCommit does not work

On 8/22/06, Kevin Carothers <kevindotcar@xxxxxxxxx> wrote:


On 8/22/06, Artem Harutyunyan <hartem@xxxxxxxxx> wrote:

>
> Hi,
>
> >
> > BEGIN TRANSACTION
> > write a sales slip
> > write a journal record
> >
> write a check record
>
> > COMMIT
> > END TRANSACTION
> >
>
> But what happens, is that I can see a 'write a sales slip' result
> before actually doing "commit". Is it normal ?
>

Yes. Absolutely- otherwise, how would you know the sales slip record was
written successfully?


After doing $sth->execute("kuku","DADDY"," 3.14"); application goes for
sleep for a minute and only after that $dbh->commit() is called. If I
understand everything correctly, during the sleep period the newly added
entry must not be seen in the table, whereas in my case I can see it by
simply doing SELECT from mysql command prompt.
For the test, I have tried to call $dbh->rollback() instead of
$dbh->commit(), but it didn't gave any result (the new entry still was
there).

Maybe your app will be better served with a trigger construct (I think
this is MySQL 5.0.2).


Thanks for the advice, but what I really need is transactions :).

Artem.

KC