CODEWITHSUNDEEP
springhibernaterepositoryentityspring-data-jpa
OddDev
OddDev

Reputation: 1611

Did not find named query

I have this entity : 

@Entity
public class User {

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "id", unique = true, nullable = false)
private Long id;

private String firstname;
private String lastname;
private Date birthdate;
private int phonenumber;
private int cin;
private String address;
private String password;
private String email;
//Getters & Setters ..
}

And this DAO class : 

@Repository
public interface UserDAO extends JpaRepository<User, Long> {

List<User> findAllUsersByFirstnameOrderByFirstnameDesc(String firstName);
List<User> findAllUsersByLastnameOrderByLastnameDesc(String Lastname);
List<User> findAllUsersByFirstnameAndLastnameOrderByFirstname(String firstAndLastname);
List<User> findAllUsersByFirstnameOrLastnameContaining(String nameContent);
List<User> findAllUsersByPhonenumber(int phoneNumber);
List<User> findAllUsersByEmailContaining(String email);
User findUserByCin(int cin);
}

And when I run it I get this error :

Caused by: java.util.NoSuchElementException: null at java.util.ArrayList$Itr.next(Unknown Source)

DEBUG org.springframework.data.jpa.repository.query.NamedQuery - Did not find named query User.findAllUsersByEmailContaining

DEBUG org.springframework.data.jpa.repository.query.NamedQuery - Did not find named query User.findAllUsersByFirstnameOrLastnameContaining

Thanks.

Upvotes: 2

Views: 4706

Answers (1)

OddDev
OddDev

Reputation: 1611

Thanks to @Arun I was able to resolve my problems stated below :

change this : 

List<User> findAllUsersByFirstnameAndLastnameOrderByFirstname(String firstAndLastname);

To : 

List<User> findAllUsersByFirstnameAndLastnameOrderByFirstname(String firstname, String lastname);

And This : 

List<User> findAllUsersByFirstnameOrLastnameContaining(String nameContent);

To

List<User> findAllUsersByFirstnameOrLastnameLike(String nameContent);

And This 

List<User> findAllUsersByFirstnameOrLastnameContaining(String nameContent);

To

List<User> findAllUsersByFirstnameOrLastnameContaining(String firstname, String lastname);

For further information you can check this link.

Upvotes: 1

Related Questions