generate hibernate query from java pojo class

Question

I want to make hibernate query from pojo class, but pojo class uses mappedBy. I don't know how can I make proper query.

Already I have tried many ideas, like ts.clientAccount.clientAccountMapping.id but it gives error. clientAccountMapping is mapped in clientAccount pojo

first class

public class Transaction{
    @ManyToOne
    @JoinColumn
    private ClientAccount clientAccount;    
}

second class

public class ClientAccount{
    @JsonIgnore
    @OneToMany(mappedBy = "clientAccount", cascade = CascadeType.ALL)
    private Set<ClientAccountMapping> clientAccountMapping;
}

third class

public class ClientAccountMapping{
    @Id
    @GeneratedValue(generator="system-uuid")
    @GenericGenerator(name="system-uuid", strategy = "uuid")
    private String id;
}

Always my compiler gives the following exception:

org.hibernate.QueryException: illegal attempt to dereference collection [transactio0_.idtransactio0_.clientAccount_accountIdclientAccount.clientAccountMapping]

user9065831 · Accepted Answer · 2019-07-05 10:30:02Z

1

you have to use join here. like : From ClientAccount c join c.clientAccountMapping

Reference : https://docs.jboss.org/hibernate/core/3.3/reference/en/html/queryhql.html

answered Jul 5, 2019 at 10:30

user9065831

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

2 Comments

raja yadav Over a year ago

thanks, it is working. Transaction ts JOIN ts.clientAccount.clientAccountMapping mapping WHERE mapping.id

user9065831 Over a year ago

give a thumbs up!!

Collectives™ on Stack Overflow

generate hibernate query from java pojo class

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related