Simon Dániel wrote:
Hi, I have a trouble with PDO transactions. I would like to start using transactions, but I am not familiar with it. I have got a 'There is no active transaction' exception, however, I am using beginTransaction method, and also I have set PDO::ATTR_AUTOCOMMIT to false right after connecting to the database. In my whole code I have used the commit method only once. Between beginTransaction and commit methods, as far as I know, I did not use anything that could activate auto-commit. In my test code, there is only an exec method of PDO, and an execute of PDOStatement. Maybe one of these activated auto-commit? And what are the possible commands which are able to activate auto-commit? I know that the commit method can do that, but - as I already wrote - I have issued it only once, and it is in the destructor of a singleton class. So what could be the problem?
You don't say which database you are trying to access. Not all actually support transactions, and some need a connection correctly set.
-- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
