Announcement Announcement Module
No announcement yet.
Test not seeing update from @Modifying @Query unless clearAutomatially = true Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Test not seeing update from @Modifying @Query unless clearAutomatially = true

    I've set up an Integration Test for a Spring Data JpaRepository which contains an @Query method that updates the associated entity, but I cannot correctly assert the result of the update in my test unless I set the clearAutomatically value of the query @Modifying annotation to true (which I don't want to do...)

    I'm guessing that this is connected with when flushing occurs in the underlying EntityManager (or when the update statement is executed in the underlying db, or maybe caching?), but I'm a bit lost as to an explanation and (more importantly) how to alter the flushing configuration to avoid the need for the clearAutomatically?

    Here's my Repo Interface...

    public interface ProductRepo extends JpaRepository<Product, String> {
        @Modifying //(clearAutomatically=true) required here in order for test to assert correctly...
        @Query("update Product p set p.deleted = true where p.shortName = :shortName")
        int softDeleteByShortName(@Param("shortName") String shortName);
    and the associated test...

           //assume correct config here
    @TransactionConfiguration(transactionManager = "transactionManager", defaultRollback = true)
    public class NormalisedProductRepoIntTests extends AbstractTransactionalJUnit4SpringContextTests {
        private ProductRepo productRepo;
        public void softDeleteByShortName_validShortName_entitySoftDeleted() {
            Product product = ProductObjectMother.createSimple();
            String id = product.getId();
            assertNotNull(id); //assert save successful
            int count = productRepo.softDeleteByShortName(product.getShortName());
            assertEquals(1, count);         //this asserts ok, and so 1 row must have been updated
            product = productRepo.findOne(id); //reload the entity
            //this does not assert unless @Modifying(clearAutomatically=true) is set on repo method under test
            assertEquals(true, product.isDeleted()); 
    Am I missing anything obvious? Any help would be very much appreciated as it's taken me quite a while to even get this far in determining where/what the problem is...

    Best wishes,