Spring JpaRepository find entities from attribute using unconventional naming

Question

The following used to work in Spring 1.5.10.RELEASE, but does not work in Spring 2.0.7.RELEASE, and I do not know why:

Entity

@Entity
@Table(name = "locations")
@Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
public class Location {
  // ... unimportant stuff
  @Column(name = "c_locations_id")
  private String cLocationId;
  // ... more unimportant stuff
}

Repository (aka "The problem")

@Repository
public interface LocationRepository extends JpaRepository<Location, Long>, JpaSpecificationExecutor<Location> {
  Location findByCLocationId(String cLocationId);
  List<Location> findAllByOrderByCLocationIdAsc();
}

The error I'm getting under Spring 2.0.7.RELEASE for the above code, is

java.lang.IllegalArgumentException: Unable to locate Attribute with the the given name [CLocationId] on this ManagedType.

I cannot change the name of the attribute due to other circumstances, so I've tried different variations on the methods in the repository:

findBycLocationId - No property orderBycLocationIdAsc found for type Location!
findByClocationId - No property clocationId found for type Location! Did you mean 'CLocationId','cLocationId'?
findByCLocationId - Unable to locate Attribute with the the given name [CLocationId] on this ManagedType

What does it want?! I just want to upgrade the framework... 😭

I have sometime some problems when getter and attribute name doesn't match. But I think it's more an IDE problem (it only underline but that compiles). Good to check. — Y. Tarion
– Y. Tarion, Commented Feb 8, 2019 at 14:00

Hakob Hakobyan · Accepted Answer · 2019-02-08 17:58:14Z

5

You can use method name like this:

Location findByC_Location_Id(String cLocationId);

this can be helpful with references

answered Feb 8, 2019 at 17:58

Hakob Hakobyan

1,1418 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Pérez Cabrera · Accepted Answer · 2019-02-08 13:47:24Z

2

You can use @Query annotation in your methods official documentation.

@Query("select l from Location l where l.cLocationId = ?1")
Location findByCLocationId(String cLocationId);

@Query("select l from Location l")
List<Location> findAllByOrderByCLocationIdAsc();

edited Feb 8, 2019 at 13:47

answered Feb 8, 2019 at 13:46

David Pérez Cabrera

5,0582 gold badges27 silver badges39 bronze badges

2 Comments

Øystein Amundsen Over a year ago

Good workaround, but do I have to? Why did this work in previous version of Spring and not now? Is this type of attribute naming really that unconventional that Spring no longer supports it?

David Pérez Cabrera Over a year ago

@ØysteinAmundsen To be honest, I don't know. I saw this docs.spring.io/spring-data/jpa/docs/current/reference/html/… but I have not idea.

Collectives™ on Stack Overflow

Spring JpaRepository find entities from attribute using unconventional naming

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related