Spring Data- JPA multiple nested Object

Question

I have a class structure something like below:

public class X {

@Id
private Long id;

//One to one mapping
private Y y;

....Some more attibutes

}

public class Y {

@Id
private Long id;

//ManyToOne mapping
private Z z;

....Some more attibutes

}

public class Z {

@Id
private Long id;

....Some more attibutes

}

Now I have a Respository interface like below

public interface XRepository extends JPARepository<X, Long> {
    // This is not working,    
    public X findByIdAndYIdAndZId(Long xId, Long yId, Long zId);
    
    //This also doesn't work obviously for same reason as above one
    public X findYIdAndZId(Long yId, Long zId);

}

I am getting this exception

org.springframework.data.mapping.PropertyReferenceException: No property zId found for type X!

Please help me on how to construct the method for such scenario

Eklavya · Accepted Answer · 2020-09-01 05:56:48Z

4

The field Z does not exist in X, it is in Y class. So, you should use the full path of the object for Z's id.

public X findByIdAndYIdAndYZId(Long xId, Long yId, Long zId);

Note: Please consider to use the understandable name for the class. I guess they are for example only.

edited Sep 1, 2020 at 5:56

answered Sep 1, 2020 at 5:49

Eklavya

18.6k4 gold badges33 silver badges62 bronze badges

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

Comments

Sagar Gangwal · Accepted Answer · 2020-09-01 05:57:21Z

0

You can use import org.springframework.data.mongodb.repository.Query; annotation.

 @Query("{$and : [{'y.id': ?0}, {'y.z.id': ?1 }]}")
 public X findByIdAndYIdAndZId(Long yId, Long zId);

You will get more idea about Query

edited Sep 1, 2020 at 5:57

answered Sep 1, 2020 at 5:49

Sagar Gangwal

8,1303 gold badges28 silver badges45 bronze badges

1 Comment

Sharique Over a year ago

I know I could do it using Query but I wanted to use method.

Collectives™ on Stack Overflow

Spring Data- JPA multiple nested Object

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related