@Transactional and rollback not working, spring testing

[Nemanja Milosavljević]

Hi, I'm doing an integration test in the spring and I have a problem where during the addition test in the service, rollback not working, but always add an item to the base.
I have annotation @ Transactional and @ TestPropertySource on test class,
I have application-test.properties and the test is successful but the rollback is not executed and a new item is always added to the test database.


My test class and add test method (last one):

@RunWith(SpringRunner.class)
@SpringBootTest(classes = TicketServiceApplication.class)
@Transactional
@TestPropertySource("classpath:application-test.properties")
public class AddressServiceIntegrationTest {

    @Autowired
    private AddressService addressService;

    @Autowired
    private AddressRepository addressRepository;

    @Test
    public void findAllSuccessTest(){
        List<Address> result = addressService.finfAllAddress();

        assertNotNull(result);
        assertFalse(result.isEmpty());
        assertEquals(2, result.size());
    }

    @Test
    public void findOneAddressExistTest_thenReturnAddress(){
        Long id = AddressConst.VALID_ID_ADDRESS;
        Address a = addressService.findOneAddress(id);
        assertEquals(id, a.getId());
    }

    @Test(expected = EntityNotFoundException.class)
    public void findOneAddressNotExistTest_thenThrowException(){
        Long id = AddressConst.NOT_VALID_ID_ADDRESS;
        Address a = addressService.findOneAddress(id);
    }

    @Test
    public void addAddressSuccessTest(){

        int sizeBeforeAdd = addressRepository.findAll().size();

        Address address = AddressConst.newAddressToAdd();
        Address result = addressService.addAddress(address);

        int sizeAfterAdd  = addressRepository.findAll().size();

        assertNotNull(result);
        assertEquals(sizeBeforeAdd+1, sizeAfterAdd);
        assertEquals(address.getCity(), result.getCity());
        assertEquals(address.getState(), result.getState());
        assertEquals(address.getNumber(), result.getNumber());
        assertEquals(address.getLatitude(), result.getLatitude());
        assertEquals(address.getLongitude(), result.getLongitude());
        assertEquals(address.getStreet(), result.getStreet());
    }
}

My application-test.properties :

spring.datasource.url = jdbc:mysql://localhost:3306/kts_test?useSSL=false&useUnicode=true&characterEncoding=utf8
spring.datasource.username = root
spring.datasource.password = root
spring.jpa.show-sql = true
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

And when execute add address test, every time in my kts_test data base ( db used for testing) is added new item and not rollback.

If anyone can help I would be grateful. Thank you.

[Claude Moore]

Googling a bit, I found this issue about Spring and MySql dialect.
Try to verify if it may work for you.

[Nemanja Milosavljević]

Yes that was a problem from the link,
I just managed to solve this morning and couldn't answer.
The problem was with the mySql engine.
By default, it was a myISAM that does not support transactions and had to be changed to the InnoDb engine.
Thanks anyway .