首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >Spring Hibernate MySQL测试不回滚

Spring Hibernate MySQL测试不回滚
EN

Stack Overflow用户
提问于 2011-02-10 02:17:47
回答 2查看 3.1K关注 0票数 1

我在使用Spring3.0.5,Hibernate 3和MySQL 5进行事务测试时遇到了问题。在日志中似乎一切正常,事务回滚,但我将记录插入到数据库中。我的配置如下:

代码语言:javascript
运行
复制
<bean id="hibernateDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  <property name="url" value="jdbc:mysql://localhost:3306/blog" />
  <property name="username" value="user" />
  <property name="password" value="password" />
  <property name="defaultAutoCommit" value="false" />
</bean>

<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
  <property name="sessionFactory" ref="hibernateSessionFactory" />
</bean>
<tx:annotation-driven transaction-manager="transactionManager" />

<bean id="hibernateSessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
  <property name="dataSource" ref="hibernateDataSource" />
  <property name="schemaUpdate" value="true" />
  <property name="hibernateProperties">
    <props>         
      <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</prop>
      <prop key="hibernate.current_session_context_class">thread</prop>         
      <prop key="hibernate.show_sql">true</prop>
      <prop key="hibernate.connection.autocommit">false</prop>
    </props>
  </property>
  <property name="annotatedClasses">
    <list>
      <value>pl.jedenpies.blog.domain.Uzytkownik</value>
    </list>
  </property>
</bean>

<bean id="uzytkownikDao" class="pl.jedenpies.blog.db.hibernate.dao.HibernateUzytkownikDao">
  <property name="sessionFactory" ref="hibernateSessionFactory" />
</bean>

测试类:

代码语言:javascript
运行
复制
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = {"classpath:beans.xml"})
@TransactionConfiguration(defaultRollback = true)
public class UzytkownikDaoTest {

    private UzytkownikDao uzytkownikDao;

    @Test
    @BeforeTransaction  
    public void test1Config() {
        Assert.notNull(uzytkownikDao, "UzytkownikDao nie moze byc null");
    }

    @Test   
    @Transactional
    @Rollback
    public void test2Create() {
        Uzytkownik u = new Uzytkownik();
        u.setEmail("my4@uzytkownik.pl");
        u.setHaslo("blablabla");
        Assert.isTrue(!u.isIdUstawione());
        u = uzytkownikDao.create(u);
        Assert.notNull(u, "Uzytkownik nie moze byc null");
        Assert.isTrue(u.isIdUstawione());
    }

    @Resource   
    public void setUzytkownikDao(UzytkownikDao uzytkownikDao) {
        this.uzytkownikDao = uzytkownikDao;
    }
}

日志:

代码语言:javascript
运行
复制
DEBUG org.hibernate.event.def.AbstractSaveEventListener - executing identity-insert immediately
DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG org.hibernate.jdbc.AbstractBatcher - insert into uzytkownicy (email, haslo) values (?, ?)
Hibernate: insert into uzytkownicy (email, haslo) values (?, ?)
DEBUG org.hibernate.id.IdentifierGeneratorFactory - Natively generated identity: 43
DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
DEBUG org.springframework.test.context.transaction.TransactionalTestExecutionListener - Method-level @Rollback(true) overrides default rollback [true] for test context [[TestContext@3dbbd23f testClass = UzytkownikDaoTest, locations = array<String>['classpath:beans.xml'], testInstance = pl.jedenpies.blog.dao.UzytkownikDaoTest@22a010ba, testMethod = test2Create@UzytkownikDaoTest, testException = [null]]]
DEBUG org.springframework.transaction.support.AbstractPlatformTransactionManager - Initiating transaction rollback
DEBUG org.springframework.orm.hibernate3.HibernateTransactionManager - Rolling back Hibernate transaction on Session [org.hibernate.impl.SessionImpl@303bc1a1]
DEBUG org.hibernate.transaction.JDBCTransaction - rollback
DEBUG org.hibernate.transaction.JDBCTransaction - rolled back JDBC Connection
DEBUG org.hibernate.jdbc.ConnectionManager - transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
DEBUG org.springframework.orm.hibernate3.HibernateTransactionManager - Closing Hibernate Session [org.hibernate.impl.SessionImpl@303bc1a1] after transaction
DEBUG org.springframework.orm.hibernate3.SessionFactoryUtils - Closing Hibernate Session

是的,我在谷歌上搜索了很多这个问题,但没有找到真正的解决方案。我不知道出了什么问题。

有什么建议吗?

EN

回答 2

Stack Overflow用户

发布于 2011-02-10 02:27:10

您使用的是InnoDB引擎吗?MyISAM是5.5版本之前的MySQL 5.x版本的默认引擎,不支持事务- Wikipedia - MyISAM

票数 4
EN

Stack Overflow用户

发布于 2011-02-10 02:36:43

删除以下Hibernate属性,它与Spring事务管理冲突:

代码语言:javascript
运行
复制
<prop key="hibernate.current_session_context_class">thread</prop> 
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/4948811

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档