Thread: Transactions

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Posts
    1
    Rep Power
    0

    Transactions


    Hi all,
    I'm using PDO (don't know whether it's important) and can't get transactions to work.
    I've tried $pdo->beginTransaction() but when I INSERT something and rollback() the insert is still there.
    Then I tried to use plain Firebird (SET TRANSACTION) but I only get the following error:
    General error: -901 invalid transaction handle (expecting explicit transaction start)

    I've read somewhere that in Firebird everything is a transaction and that you can rollback some INSERTs/UPDATEs without explicitly starting a transaction but I only get the above error message again.

    Can someone help?
  2. #2
  3. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    23

    Lightbulb


    Originally Posted by dawit
    Hi all,
    I'm using PDO (don't know whether it's important) and can't get transactions to work.
    I've tried $pdo->beginTransaction() but when I INSERT something and rollback() the insert is still there.
    Then I tried to use plain Firebird (SET TRANSACTION) but I only get the following error:
    General error: -901 invalid transaction handle (expecting explicit transaction start)

    I've read somewhere that in Firebird everything is a transaction and that you can rollback some INSERTs/UPDATEs without explicitly starting a transaction but I only get the above error message again.

    Can someone help?

    Seems to be a bug i will apply the patch and i need some tests
    after that
    https://bugs.php.net/bug.php?id=63690

    If you want to help me with testing , feel free to join in on Firebird-php mailing list

    http://tech.groups.yahoo.com/group/firebird-php/
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net

IMN logo majestic logo threadwatch logo seochat tools logo