CODEWITHSUNDEEP
javahibernatejoinconditional-statementscriteria
smanulla
smanulla

Reputation: 99

Hibernate: how can I specify left condition?

I've two tables:

Criteria:

Criteria criteria = mySession.createCriteria(Prova.class, "p");
criteria.createCriteria("comitato", "c", CriteriaSpecification.LEFT_JOIN);

Translate this query in SQL is:

SELECT * FROM Prova p LEFT JOIN comitato c ON p.id_comitato=c.id_comitato

But what I want is the following:

SELECT * FROM Prova p LEFT JOIN comitato c ON p.id_comitato_erog=c.id_comitato

How can I specify this join condition?

Thank you very much, have a good day!

Upvotes: 0

Views: 64

Answers (1)

yadrimz
yadrimz

Reputation: 26

Have you tried something like this -> Yet another post on Stackoverflow .Basically you would have to do something similar to the following:

Criteria criteria = 
mySession.createCriteria(Prova.class, "p")
       .createAlias("comitato", 
                    "c", 
                    Criteria.LEFT_JOIN,
                    Restrictions.eqProperty("p.id_comitato_erog", 
                                            "e.id_comitato"));

Upvotes: 1

Related Questions