Home > Uncategorized > Magento DB transaction commit rollback sniplet

Magento DB transaction commit rollback sniplet

January 18th, 2011 Leave a comment Go to comments

Took me a while to find out how to do this… as there was no good examples on the web.
So, here it is… so I can find it again.

keywords:
db database transaction rollback commit magento zend.

try {
    $write = Mage::getSingleton('core/resource')->getConnection('core_write');
    $write->beginTransaction();

// do stuff here

    $write->commit();
} catch (Exception $e) {
    mage::log(__METHOD__ . ':' . __LINE__ . ': Rollback happened.');
    $write->rollback();
}

Please drop a line if you found this useful. Thanks!

Categories: Uncategorized Tags:
  1. MP
    October 30th, 2011 at 15:28 | #1
    Reply | Quote

    Thanks

  2. Soma
    February 13th, 2012 at 09:54 | #2
    Reply | Quote

    Wouldn’t this give errors whenever you want to rollback because $write would be null. $write should be set outside the try catch construct.

  3. Lloyd Leung
    March 7th, 2012 at 17:44 | #3
    Reply | Quote

    Soma :

    Wouldn’t this give errors whenever you want to rollback because $write would be null. $write should be set outside the try catch construct.

    No, the instance of $write will exist inside the catch statement.

    A quick test would show that rollback does in deed get triggered, when you throw an exception within the try statement.

  1. No trackbacks yet.