Spring Data JPA: find nested object

Question

I have a LOCATION entity and it contains COUNTRY, STATE and CITY. And I have a LocationRepository interface defined as:

public interface SpringDataLocationRepository extends LocationRepository,
        Repository<Location, Integer> {
}

I want to find all the state by country. I can follow the method name standard to query everything for LOCATION entity. If I want List, do I need to create StateRepository interface and query everything about STATE in there? If I can just get it from LocationRepository, what's the method looks like? I assume it will look something like below (of course it doesn't work).

List findStateByCountryCountryId(Integer id) throws DataAccessException;

Manish Maheshwari · Accepted Answer · 2015-02-17 22:49:52Z

4

Below method should work:

List<Location> findByCountryId(Integer id)

Then you can get state from the Location objects in the list.

PS: Of course, this is not tested/executed by me.

answered Feb 17, 2015 at 22:49

Manish Maheshwari

4,1292 gold badges18 silver badges25 bronze badges

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

1 Comment

chrismarx Over a year ago

this related question/answer more thoroughly explains this situation - stackoverflow.com/questions/24441411/…

Collectives™ on Stack Overflow

Spring Data JPA: find nested object

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related