java - Spring +Mybatis 事务 不能回滚

问题描述

配置事务的文件 spring-mybatis.xml

<?xml version='1.0' encoding='UTF-8'?><beans xmlns='http://www.springframework.org/schema/beans' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:p='http://www.springframework.org/schema/p' xmlns:context='http://www.springframework.org/schema/context' xmlns:tx='http://www.springframework.org/schema/tx' xmlns:mvc='http://www.springframework.org/schema/mvc' xsi:schemaLocation='http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-4.3.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-4.3.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsdhttp://www.springframework.org/schema/mvchttp://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd'> <context:component-scan base-package='com.ys.attendance.mapper'/> <bean class='org.springframework.beans.factory.config.PropertyPlaceholderConfigurer'><property name='location' value='classpath:conf/jdbc.properties' /> </bean> <bean destroy-method='close'><property name='driverClassName' value='${driver}' /><property name='url' value='${url}' /><property name='username' value='${username}' /><property name='password' value='${password}' /><!-- 初始化连接大小 --><property name='initialSize' value='${initialSize}'></property><!-- 连接池最大数量 --><property name='maxActive' value='${maxActive}'></property><!-- 连接池最大空闲 --><property name='maxIdle' value='${maxIdle}'></property><!-- 连接池最小空闲 --><property name='minIdle' value='${minIdle}'></property><!-- 获取连接最大等待时间 --><property name='maxWait' value='${maxWait}'></property> </bean> <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 --> <bean class='org.mybatis.spring.SqlSessionFactoryBean'><property name='dataSource' ref='dataSource' /><property name='configLocation' value='classpath:conf/mybatis/mybatis-config.xml'></property><!-- 自动扫描mapping.xml文件 --><property name='mapperLocations' value='classpath:conf/SqlMapper/sqlmap.xml'></property> </bean> <!-- DAO接口所在包名，Spring会自动查找其下的类 --> <bean class='org.mybatis.spring.mapper.MapperScannerConfigurer'><property name='basePackage' value='com.ys.attendance.mapper' /><property name='sqlSessionFactoryBeanName' value='sqlSessionFactory'></property> </bean> <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx --> <bean class='org.springframework.jdbc.datasource.DataSourceTransactionManager'><property name='dataSource' ref='dataSource' /> </bean><!-- 事务注解驱动，标注@Transactional的类和方法将具有事务性 --> <tx:annotation-driven transaction-manager='transactionManager' proxy-target- /></beans>

在service 中写了一个方法 是使用注解 在 这个service类上加了 @Transactional

@Transactional('transactionManager')@Servicepublic class AttendServiceImpl implements AttendService{@Overridepublic void traincation() { Map<String,String> map1 = new HashMap<String, String>(); map1.put('userid', '1111'); map1.put('username','肖总'); map1.put('date', '2017-03-15'); map1.put('state', '/');Map<String,String> map2 = new HashMap<String, String>(); map2.put('userid', '1131'); map2.put('username','小名'); map2.put('date', '2017-03-15'); map2.put('state', '/'); dao.add_attend_api(map1);try {int i = 1/0;//设置了一个异常 } catch (Exception e) {System.out.println(e.getMessage());TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); } dao.add_attend_api(map2);}}

执行该方法 出现异常 没有回滚，第一条数据插入到了数据库中org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.NoTransactionException: No transaction aspect-managed TransactionStatus in scope

是哪里配置有问题么？

问题解答

<context:component-scan base-package='com.ys.attendance.mapper'/>

包扫描的范围太小了吧。你的service在那个包下。

方法申明时候增加 throws Exception试试

public void traincation throws Exception(){

...

}

要把异常抛出去Spring才能捕获到给你回滚呀把代码改成这样：

try { int i = 1/0;//设置了一个异常} catch (Exception e) { System.out.println(e.getMessage()); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); Throw e;}