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.

@MappedSuperclass
@Getter
@Setter
public abstract class BaseEntity implements Serializable {

    @Id
    @GeneratedValue
    private Long id;

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

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

    @Override
    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:

predicates.add(criteriaBuilder
  .and(criteriaBuilder.notEqual(
       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