Re: [fw-db] _DB , Transactions usage questions

You may already know this, but if you're using MySQL, keep in mind that you need to use the InnoDB or BDB storage engines to support transactions.

http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html

-Hector


Kevin Hallmark wrote:

Are the queries returning SQL errors or just not performing the action properly?   That block will only rollback if an actual exception is thrown. If the query just isn't producing the correct result, then you should check that in the try block and throw your own exceptions.  Kevin   On 7/31/08 2:23 PM, "maxarbos" <maxarbos@yahoo.com> wrote:    

Hello,  i have a question about Zend_DB  1: I am using transactions and it seems that my try block is not working correctly.  Here is the code:  $this->_db->beginTransaction();  try { $this->block->doSomethingOne($one_info_action, $vals); $this->block->doSomethingTwo($two_info_action, $vals);  $this->_db->commit();  } catch (Exception $e) {     $this->_db->rollBack();     echo $e->getMessage(); }   Is this valid? Will the transaction and try block work correctly (if doSomethingOne and doSomethingTwo both succeed, then and only then, do the results commit)?  I have a block just like this, but it seems as though some of the methods succeed, while others dont.  Can methods be checked within a try/transaction block? (i hope this makes sense)  Thanks.