Spring Data JPA How to Locate Attribute With the Given Name

Spring Data JPA Unable to locate Attribute with the given name

Try changing private String FirstName,LastName,Email; to private String firstName,lastName,email;

It should work.

findByFirstName in SubscriberRepository tries to find a field firstName by convention which is not there.

Further reference on how properties inside the entities are traversed https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#repositories.query-methods.query-property-expressions

Unable to locate Attribute with the given name - Spring Data JPA Projections, Hibernate and BaseEntity

There is a typo in BaseEntity when defining ID field. Should be camelcase id instead of Id.

public abstract class BaseEntity implements Serializable {

private Long id;

private String uuid = UUID.randomUUID().toString();

public boolean equals(Object that) {
return this == that ||
that instanceof BaseEntity && Objects.equals(uuid, ((BaseEntity) that).uuid);

public int hashCode() {
return Objects.hash(uuid);

Unable to locate Attribute with the given name on this ManagedType [unknown]

The name of the attribute is dateModified not modifiedDate.

So the code must look like:

root.get("auditSection").get("dateModified"), new Date)));

java.lang.IllegalArgumentException: Unable to locate Attribute with the the given name

Your methods should look like:

interface ModuleDAO extends JpaRepository<Module, Long> {
List<Module> findByNameAndIdNot(String name, Long id);
List<Module> findByNameAndActive(String name, boolean active);
List<Module> findByActive(boolean isActive);

Some remarks:

  1. Interfaces are public by default
  2. You shouldn't use Boolean wrapper type because this would allow null values

Unable to locate Attribute with the the given name [ANumber] on this ManagedType [com.company.domain.Statistics]

I was facing this problem after the JPA version upgrade which state that all the names were correct and mapped perfectly.

The solution I found was defining the native query within the @Query annotation of the spring data JPA because the problem was occurring when JPA was trying to create the JPA Named Query.

@Query(nativeQuery = true, value = "Your Query here")
Optional<Statistics> findFirstByIdAndANumberAndDispositionCodeInOrderByCreatedDesc(Long id, String aNumber, Integer... dispositionCode);

This might not be the best solution but in my case I was not supposed to change the version as it was coming from the parent POM and this was the easiest solution which I could do.

Related Topics

Leave a reply