使用alter table的Spring Jdbc原子性(Spring Jdbc atomicity with alter table)

 我正在尝试使用Spring Jdbc编写等效的Rails数据模型演化/回滚机制。 
 
 Spring Jdbc transactionnal insert/replace工作得很好（在InnoDB mysql 5下使用PROPAGATION_REQUIRED的DataSourceTransactionManager）： 
 
// Transaction begins
getJdbcTemplate().execute("replace into aTable ...");
getJdbcTemplate().execute("wrong request");
getJdbcTemplate().execute("replace into aTable ...");
// none are commited
 
 但alter不是： 
 
// Transaction begins
getJdbcTemplate().execute("alter table aTable add column `columnForTest` ...");
getJdbcTemplate().execute("wrong request");
getJdbcTemplate().execute("alter table aTable add column `columnForTest` ...");
// the first alter is commited
 
 有没有办法用alter实现原子性（全有或全无行为）？ 
 
 提前致谢 

I'm trying to write an equivalent of Rails data model evolution/rollback mechanism using Spring Jdbc.
 
Spring Jdbc transactionnal insert/replace works very well (DataSourceTransactionManager with PROPAGATION_REQUIRED under InnoDB mysql 5) :
 
// Transaction begins
getJdbcTemplate().execute("replace into aTable ...");
getJdbcTemplate().execute("wrong request");
getJdbcTemplate().execute("replace into aTable ...");
// none are commited
 
but alter doesn't :
 
// Transaction begins
getJdbcTemplate().execute("alter table aTable add column `columnForTest` ...");
getJdbcTemplate().execute("wrong request");
getJdbcTemplate().execute("alter table aTable add column `columnForTest` ...");
// the first alter is commited
 
Is there a way to achieve atomicity (all-or-none behavior) with alter ?
 
Thanks in advance

原文：https://stackoverflow.com/questions/3238918