How to rollback the database using Spring Framework

Question

I have this method that saves data in 3 different tables,

/**
 * 
 * @param user - de onde os dados do usuário serão retirados para gravar no banco
 * @throws GoogleAuthException - se houver algum erro ele retorna um erro a tela login
 * 
 * Este método cadastra um usuário com perfil geral, ele só será chamado se o usuário  não tiver nenhum perfil na tabela
 */
@Transactional
private Usuario cadastrarUsuario(GoogleUserInfo user) {

    Usuario usuario = new Usuario(user.getEmail(), user.getGiven_name(), user.getFamily_name(), StatusEnum.Ativo);
    Usuario usuarioSalvo = usuarioRepository.save(usuario);

    tracer.info(usuarioSalvo.toString());
    UsuarioPerfil usuarioPerfil = new UsuarioPerfil(RolesEnum.GERAL.getId(), usuarioSalvo.getIdUsuario(), Calendar.getInstance());
    usuarioPerfilRepository.save(usuarioPerfil);

    tracer.info(usuarioPerfil.toString());

    TelaUsuarioPerfilPrincipal telaPrincipalDoUsuario = 
            new TelaUsuarioPerfilPrincipal(usuarioSalvo.getIdUsuario(), RolesEnum.GERAL.getId(), ID_HOME_PAGE_PERFIL_GERAL);
    telaUsuarioPerfilPrincipalRepository.save(telaPrincipalDoUsuario);

    tracer.info(telaPrincipalDoUsuario.toString());

    return usuarioSalvo;
}

and would like to guarantee the atomicity of these transactions, I would like that in case the second or third save give error the birds that worked out were rollback in the database and were not saved, I tried to use the Annotation @Transactional Spring Boot but not successful.

These are my bank access variables

@Autowired
private UsuarioRepository usuarioRepository;

@Autowired
private UsuarioPerfilRepository usuarioPerfilRepository;

@Autowired
private TelaUsuarioPerfilPrincipalRepository telaUsuarioPerfilPrincipalRepository;

They are all interfaces inherited from JPARepository.

Answer 1

By default, in the occurrence of a RuntimeException changes made to the transaction are rollback (except when treated in a block catch), already checked Exceptions will not perform rollback. As can be seen in the answer to this question Throwing a Runtimeexception causes the transaction to rollback, but Exception doesn’t in a spring boot app, which refers to doc Data Access spring.

If you want to do rollback regardless of which exception launched, it is possible to add in the annotation @Transactional which should carry out the rollback and which should not. Ex:

@Transactional(rollbackOn = Exception.class)
public void start() {
  ...
}