php - PDO 回滚不起作用

Question

$myServer='127.0.0.1';
$myDB='karma';
$myUser='root';
$myPass='wilian';


try {
    $connStr = "mysql:host=".$myServer.";dbname=".$myDB; 
    $dbh = new PDO($connStr,$myUser,$myPass);
} catch (Exception $e) {
    die("Unable to connect: " . $e->getMessage());
}

try {  
  $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

  $dbh->beginTransaction();
  $dbh->query("insert into mst_goods_category (id, GOODS_CATEGORY_CODE, GOODS_CATEGORY_NAME, ACTIVE_FLAG, CREATE_DATE, CREATE_TIME, CREATE_USER) values (12, '012', '333', 'Y', '20140702', '00:00:00', 'admin')");
  $dbh->query("insert into mst_goods_category (id, GOODS_CATEGORY_CODE, GOODS_CATEGORY_NAME, ACTIVE_FLAG, CREATE_DATE, CREATE_TIME, CREATE_USER) values (13, '012', '333', 'Y', '20140702', '00:00:00', 'admin')");
  $dbh->commit();

} catch (PDOException $e) {
  $dbh->rollBack();
  throw $e;
}

由于唯一约束，第二个查询出错。出现了 throw $e，但它没有回滚，有人知道出了什么问题吗？

Answer 1

很可能您使用的 Myisam 引擎不支持事务。改为InnoDB

ALTER TABLE mst_goods_category ENGINE=InnoDB;