Spring: how to execute `@Sql` within the transaction of test method?

Question

I need the following logic:
1. Test method starts
2. Transaction opens
3. Prepare SQL file is executed
4. Test method is processed
5. Transaction rollbacks

My test class is annotated with

@SpringBootTest
@Transactional
@Rollback(true)

I tried to use @org.springframework.test.context.jdbc.Sql before test method but it doesn't work - looks like it opens a transaction, executes SQL, closes transaction (reverts it?) and after that starts test. A test doesn't see changes from SQL file

My question is: how to execute @org.springframework.test.context.jdbc.Sql within the transaction of test method? Any other way to solve this problem?

Answer 1

You should have a look at the config property of the @Sql annotation, there it is possible to specify the TransactionMode to be used.

So for instance the following scripts are executed in a separate transaction ahead of entering the test method:

@Sql(
  scripts = {"classpath:file1.sql", "classpath:file2.sql"},
  config = @SqlConfig(transactionMode = TransactionMode.ISOLATED))
@Test
public void foo() { ... }