How to rollback a database transaction when testing services with Spring in JUnit?

by

You need to extend transaction boundaries to the boundaries of your test method. You can do it by annotating your test method (or the whole test class) as @Transactional:

@Test 
@Transactional
public void testInsert(){ 
    long id=myService.addPerson("JUNIT"); 
    assertNotNull(id); 
    if(id<1){ 
        fail(); 
    } 
}

You can also use this approach to ensure that data was correctly written before rollback:

@Autowired SessionFactory sf;

@Test 
@Transactional
public void testInsert(){ 
    myService.addPerson("JUNIT"); 
    sf.getCurrentSession().flush();
    sf.getCurrentSession().doWork( ... check database state ... ); 
}

More Related Contents:

  1. Why does Hibernate disable INSERT batching when using an IDENTITY identifier generator
  2. Transaction marked as rollback only: How do I find the cause
  3. What is the ‘best’ way to do distributed transactions across multiple databases using Spring and Hibernate
  4. Do you need a database transaction for reading data?
  5. Rollback transaction after @Test
  6. javax.transaction.Transactional vs org.springframework.transaction.annotation.Transactional
  7. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  8. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  9. Avoid Jackson serialization on non fetched lazy objects
  10. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  11. How can I log SQL statements in Spring Boot?
  12. Difference between @Mock, @MockBean and Mockito.mock()
  13. Why do I need Transaction in Hibernate for read-only operations?
  14. Populating Spring @Value during Unit Test
  15. @Transactional method called from another method doesn’t obtain a transaction
  16. No serializer found for class org.hibernate.proxy.pojo.bytebuddy.ByteBuddyInterceptor
  17. Error : java.lang.NoSuchMethodError: org.objectweb.asm.ClassWriter.(I)V
  18. Need to reset the value of sequence in Oracle
  19. mapping Hibernate query results to custom class?
  20. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  21. Spring hibernate template when to use and why?
  22. Change database schema during runtime based on logged in user
  23. Spring + Hibernate : a different object with the same identifier value was already associated with the session
  24. How to map sql native query result into DTO in spring jpa repository?
  25. java.lang.NoSuchMethodError: org.springframework.core.annotation.AnnotationUtils.isInJavaLangAnnotationPackage(Ljava/lang/annotation/Annotation;)Z
  26. Differences between requires_new and nested propagation in Spring transactions
  27. Spring transaction: rollback on Exception or Throwable
  28. How to make a database listener with java?
  29. How to use DTO in JSF + Spring + Hibernate
  30. Spring not autowiring in unit tests with JUnit

Leave a Comment