問題簡介

使用Spring data jpa + mysql對Dao層的save()方法進(jìn)行單元測試時玲献，期望在測試完后進(jìn)行回滾操作殉疼，結(jié)果未回滾，去表里面查看捌年，數(shù)據(jù)卻成功插入瓢娜。而Log日志顯示已經(jīng)進(jìn)行了回滾操作。日志如下：

2017-05-03 01:44:00 [DEBUG] org.hibernate.engine.transaction.internal.TransactionImpl | rolling back

問題出現(xiàn)時配置：

spring-context.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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd">

    <!--PropertyConfigurer-->
    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="ignoreUnresolvablePlaceholders" value="true"/>
        <property name="locations">
            <list>
                <value>classpath*:*.properties</value>
            </list>
        </property>
    </bean>

    <import resource="classpath:spring-jdbc.xml"/>
    <!--<import resource="classpath:spring-aop.xml"/>-->
    <!--<import resource="classpath:spring-shiro.xml"/>-->
    <!--<import resource="classpath:spring-mvc.xml"/>-->

</beans>

spring-jdbc.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:tx="http://www.springframework.org/schema/tx"
       xmlns:jpa="http://www.springframework.org/schema/data/jpa"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
       http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa.xsd">

    <!-- 掃描DAO interface包礼预，自動完成DAO注入 添加事務(wù)管理 -->
    <jpa:repositories base-package="com.airkisser.auth.dao" transaction-manager-ref="transactionManager"
                      entity-manager-factory-ref="entityManagerFactory" repository-impl-postfix="Impl"/>

    <!-- 事務(wù)注解驅(qū)動 -->
    <tx:annotation-driven transaction-manager="transactionManager"/>

    <!-- 事務(wù)管理器 使用JPA事務(wù)管理-->
    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory"/>
    </bean>

    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
        <!-- 基本屬性 url眠砾、user、password -->
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.user}"/>
        <property name="password" value="${jdbc.password}"/>
        <!-- 配置初始化大小托酸、最小褒颈、最大 -->
        <property name="initialSize" value="${druid.initialSize}"/>
        <property name="minIdle" value="${druid.minIdle}"/>
        <property name="maxActive" value="${druid.maxActive}"/>
        <!-- 配置獲取連接等待超時的時間 -->
        <property name="maxWait" value="${druid.maxWait}"/>
        <!-- 配置間隔多久才進(jìn)行一次檢測，檢測需要關(guān)閉的空閑連接励堡，單位是毫秒 -->
        <property name="timeBetweenEvictionRunsMillis" value="${druid.timeBetweenEvictionRunsMillis}"/>
        <!-- 配置一個連接在池中最小生存的時間谷丸，單位是毫秒 -->
        <property name="minEvictableIdleTimeMillis" value="${druid.minEvictableIdleTimeMillis}"/>
        <property name="validationQuery" value="${druid.validationQuery}"/>
        <property name="testWhileIdle" value="${druid.testWhileIdle}"/>
        <property name="testOnBorrow" value="${druid.testOnBorrow}"/>
        <property name="testOnReturn" value="${druid.testOnReturn}"/>
        <!-- 打開PSCache，并且指定每個連接上PSCache的大小 -->
        <property name="poolPreparedStatements" value="${druid.poolPreparedStatements}"/>
        <property name="maxPoolPreparedStatementPerConnectionSize"
                  value="${druid.maxPoolPreparedStatementPerConnectionSize}"/>
        <!-- 配置監(jiān)控統(tǒng)計攔截的filters应结，去掉后監(jiān)控界面sql無法統(tǒng)計 -->
        <property name="filters" value="stat"/>
    </bean>

    <bean id="entityManagerFactory"
          class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <!-- 注入數(shù)據(jù)源 -->
        <property name="dataSource" ref="dataSource"/>
        <!-- 指定Jpa持久化實(shí)現(xiàn)廠商類,這里以Hibernate為例 -->
        <property name="jpaVendorAdapter">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"/>
        </property>
        <!-- 指定自動掃描的注解實(shí)體類包 -->
        <property name="packagesToScan" value="com.airkisser.auth.model"/>
        <property name="jpaProperties">
            <props>
                <prop key="hibernate.dialect">${hibernate.dialect}</prop>
                <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
                <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
                <prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
                <prop key="hibernate.use_sql_comments">${hibernate.use_sql_comments}</prop>
                <prop key="hibernate.ejb.naming_strategy">org.hibernate.cfg.ImprovedNamingStrategy</prop>
            </props>
        </property>
    </bean>

</beans>

jdbc.properties

# +++++++++++++++++++++
# jdbc properties
# +++++++++++++++++++++
jdbc.driverClassName=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/auth_db?createDatabaseIfNotExist=true&characterEncoding=utf8
jdbc.user=root
jdbc.password=123456

# +++++++++++++++++++++
# hibernate properties
# +++++++++++++++++++++
# 方言
hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.hbm2ddl.auto=update
hibernate.show_sql=true
hibernate.format_sql=false
hibernate.use_sql_comments=false

# +++++++++++++++++++++
# druid properties
# +++++++++++++++++++++
# 配置初始化連接池大小刨疼、最大并發(fā)數(shù)量、最小空閑數(shù)量
druid.initialSize=1
druid.maxActive=20
druid.minIdle=1

# 配置獲取連接等待超時的時間
druid.maxWait=60000

# 配置間隔多久才進(jìn)行一次檢測鹅龄，檢測需要關(guān)閉的空閑連接揩慕，單位是毫秒
druid.timeBetweenEvictionRunsMillis=60000

# 配置一個連接在池中最小生存的時間，單位是毫秒
druid.minEvictableIdleTimeMillis=300000

druid.validationQuery=SELECT 'x'
druid.testWhileIdle=true
druid.testOnBorrow=false
druid.testOnReturn=false

# 打開PSCache扮休，并且指定每個連接上PSCache的大小
# 如果用Oracle迎卤，則把poolPreparedStatements配置為true，mysql可以配置為false肛炮。分庫分表較多的數(shù)據(jù)庫止吐，建議配置為false
druid.poolPreparedStatements=false
druid.maxPoolPreparedStatementPerConnectionSize=20

測試 AuthGroupRepositoryTest.java

package com.airkisser.auth.dao;

import com.airkisser.auth.dao.auth.AuthGroupRepository;
import com.airkisser.auth.model.auth.AuthGroup;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.AbstractTransactionalJUnit4SpringContextTests;

import java.util.Date;

import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertNotNull;

@ContextConfiguration(locations = {"classpath:spring-context.xml"})
public class AuthGroupRepositoryTest extends AbstractTransactionalJUnit4SpringContextTests {

    @Autowired
    private AuthGroupRepository authGroupRepository;

    @Test
    public void testAdd() {
        AuthGroup group = new AuthGroup();
        group.setGroupName("TestAdmin");
        group.setDescription("Desc");
        group.setCreateDate(new Date());
        authGroupRepository.save(group);
        AuthGroup g = authGroupRepository.findOne(group.getId());
        assertNotNull(g);
        assertEquals(group.getGroupName(), g.getGroupName());
    }

}

解決問題

將hibernate.dialect配置成hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect,指定MYSQL建表的時候使用InnoDB引擎(支持事務(wù)安全),使用MySQL5InnoDBDialect方言在生成表結(jié)構(gòu)的時候可以指定表的"ENGINE=InnoDB",而如果使用方言MySQL5Dialect,則在生成表結(jié)構(gòu)的時候默認(rèn)使用的是 ENGINE=MyISAM宝踪，該引擎不支持事務(wù)，即使程序中使用事務(wù)碍扔，也不起作用