事务管理似乎不适用于春季测试

Question

我希望在使用@Transactional的方法完成后将数据写入数据库。当使用HSQL数据库时，这对我的JUnit测试来说是一个有效的假设吗。我使用HSQLdb进行开发，使用Oracle进行部署的应用程序。Web应用程序部署在WebSphere上，在RSA中开发。以下是我的配置摘要，包括POM和junit测试：

POM:
3.2.9.RELEASE
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.2.3</version>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.1</version>
APPLICATION CONTEXT:
<!-- the bean for transaction manager for scoping/controlling the transactions -->
<bean id="transactionManager"
    class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dbDataSource" />
</bean>
<tx:annotation-driven transaction-manager="transactionManager" />
<jee:jndi-lookup id="dbDataSource" jndi-name="jndi/HSQLDatasource" expected-type="javax.sql.DataSource" />
<!--Mapper-->
<bean id="campaignMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
    <property name="mapperInterface"
        value="com.abc.persistence.mapper.CampaignMapper" />
    <property name="sqlSessionTemplate">
        <bean class="org.mybatis.spring.SqlSessionTemplate">
            <constructor-arg index="0" ref="sqlSessionFactoryForBatch" />
            <constructor-arg index="1" value="BATCH" />
        </bean>
    </property>     
</bean>
<!-- SqlSessionFactory For Batch -->
<bean id="sqlSessionFactoryForBatch" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dbDataSource" />
    <property name="typeAliasesPackage" value="com.abc" />
    <property name="mapperLocations" value="classpath*:com/mybatis/mappers/**/*.xml" />
</bean>
JUNIT:
//junit class extends a base class that initializes HSQL db
//jdbcConnection.setAutoCommit(false);
    @Autowired
    CampaignMapper campaignMapper;
    @Transactional
    @Test 
    public void testInsert(){
        for(Campaign record:campaignsFromFile){
            record.setRowLastUpdateId(rowLastUpdateId);
            record.setCampaignId(campaignId);
            campaignMapper.insertCampaignRecord(record);
        }
        //At this point I expect that the data would NOT be written to the database
        //other method code
        }//end of method
        //At this point I expect that the data would be written to the database

Answer 1

默认情况下，Spring将在测试上下文中回滚事务。如果这不是您期望的行为，那么您总是可以使用false值的@Rollback注释：

@Transactional
@Test 
@Rollback(false)
public void testInsert() { ... }

如果您使用的是Spring4.2.x版本，那么您可以使用新的@Commit注释，这是一个可以直接替换@Rollback(false)的新注释。您可以在Spring Test Context中阅读更多关于事务管理的信息。