Yii交易没有回滚

Question

i have the following piece of code and i pass it some data to generate an exception and test if the transaction rollback is happening. It seems it's not and i'm not sure why. can someone help me? thanks

            $transaction = Yii::app()->db->beginTransaction();

            try {

                //.....

                //call private methods
                $category = MyController::saveCategory($params);
                $test_saved = MyController::saveTest($params);
                MyController::saveCommunity($param);   // here is an exception and it should rollback the transaction but it doesn't  

                $transaction->commit();

            } catch(Exception $e) {
                $transaction->rollback();
                throw new Exception($e);
            }


            private function saveCommunity($param){

                  $community = new Community();
                  $community->user_id = $user_id;
                  $community->name = $name; 
                  $community->id = 71;  // this is a duplicate primary key and will generate an exception


                  try{
                      $community->save(false, null);
                  }catch(Exception $e){
                     throw $e;
                  }

                  return $community;

            }

(mysql tables are set to innodb)

Answer 1

Try changing your code responsible for exception throwing:

          try{
              $community->save(false, null);
          }catch(Exception $e){
             throw $e;
          }

to something like:

          if(!$community->save(false, null))
               throw new Exception('Error saving');

And remove the exception throwing here:

            } catch(Exception $e) {
            $transaction->rollback();
            //throw new Exception($e);
        }