Findby with nested object - Spring Data JPA

Question

I’m having a doubt when creating a findBy using jpa with atríbuto of a nested object, the classes are:

public class Livro {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String titulo;
    @ManyToOne
    private Usuario usuario;

and

public class Usuario {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String nome;
    private String email;

I need to return the books of a particular user by providing his email.

I tested using these methods in Restpository but it didn’t work:

List<Livro> findByLivro_Usuario_Email(String email);

List<Livro> findByLivroUsuario_Email(String email);

Do you have any suggestions of what might be?

Answer 1

Corrected using:

@Repository
public interface LivroRepository extends JpaRepository<Livro, Long> {
    List<Livro> findByUsuarioEmail(String email);
}