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 - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

Round ImageView Android -

How can I utilize Yahoo Weather API in android -