1.mysql中建立了2个表,test1和test2,数据结构都是(int id,varchar name);
2.对test1和test2分别建立各自的DAO层代码和Service代码,集成到ssh环境中,增删查改均正常。
3.现有一新业务,同时往test1和test2表中增加一个字段,如果任一个表增加字段时失败则同时放弃增加字段的业务。该业务写在TestService的save(Test1 test1,Test2 test2) 方法中,其代码如下所示:
[code="java"]package hep.service.lc;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import hep.persist.lc.Test1DAO;
import hep.persist.lc.Test2DAO;
import com.uisk.hep.bo.Test1;
import com.uisk.hep.bo.Test2;
@Service
@Transactional
public class TestService {
private Test1DAO test1DAO;
private Test2DAO test2DAO;
public Test1DAO getTest1DAO() {
return test1DAO;
}
public void setTest1DAO(Test1DAO test1dao) {
test1DAO = test1dao;
}
public Test2DAO getTest2DAO() {
return test2DAO;
}
public void setTest2DAO(Test2DAO test2dao) {
test2DAO = test2dao;
}
@Transactional(propagation=Propagation.REQUIRED,rollbackFor=Exception.class)
public void save(Test1 test1,Test2 test2) {
test1DAO.save(test1);
test2DAO.save(test2);
}
}
[/code]
spring事务管理配置如下:
[code="java"]
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="add*" propagation="REQUIRED" />
<tx:method name="save*" propagation="REQUIRED" />
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut id="allManagerMethod"
expression="execution(* hep.service.lc.*.*(..))" />
<aop:advisor advice-ref="txAdvice" pointcut-ref="allManagerMethod" />
</aop:config>
[/code]
当保存test1后,设置一个异常抛出后,test2没有保存数据,理论上test1也不应该保存数据,但和期望的不一样,数据库记录中明显看到test1的数据了。
请问该如何处理这个事务失效问题?