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

javascript - IndexedDB error: Uncaught DataCloneError: Failed to execute 'put' on 'IDBObjectStore': An object could not be cloned -

java - Unable to make sub reports with Jasper -

Integrity error when loading fixtures for Selenium testing in Django -