java - Criteria with full join and left join -


i trying write query using criteria class

select * full join b on a.aid=b.aid left join c on c.bid=b.bid 

so far have

criteria = getsession().createcriteria(a.class, "a")                     .createcriteria("b", "b").createcriteria("c", "c") 

which join on inner join not want that

i figured out.

criteria = getsession().createcriteria(a.class, "a", criteria.left_join)                 .createcriteria("b", "b").createcriteria("c", "c", criteria.left_join); criteria.setresulttransformer(criteria.distinct_root_entity); 

Comments

Popular posts from this blog

java - Unable to make sub reports with Jasper -

sql - The object name contains more than the maximum number of prefixes. The maximum is 2 -

Java Web Service Soap fault exception client -