How to create dynamic query using criteriaquery for many-to-one

Question

I have Person as one to many relationship with Address in JPA .

@Id 
    @Column(name="personid")
    private Long personId;
    private String firstName;
    private String lastName;
    private String email;    

    @OneToMany(cascade = CascadeType.ALL,mappedBy="person",targetEntity=Address.class,fetch=FetchType.LAZY)      
    private List addressArray=new ArrayList<>();   
    public Person() {

    }

I want to create dynamic query using criteriaQuery so that I can fetch the person's firstname from the address object like "address.person.firstname".

Yep, no problem even with Lazy fetching. Go do it. – Scary Wombat Sep 09 '13 at 08:21 — Scary Wombat, Sep 09 '13 at 08:21
@user2310289 ya but how using criteria api ? – Achyut Sep 09 '13 at 08:24 — Achyut, Sep 09 '13 at 08:24

score 0 · Answer 1 · answered Sep 09 '13 at 14:06

0

You can use a join() in Criteria to access a relationship.

https://en.wikibooks.org/wiki/Java_Persistence/Criteria#Join

answered Sep 09 '13 at 14:06

James

17,965
11
91
146

How to create dynamic query using criteriaquery for many-to-one

1 Answers1