The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.


I have two table.ops_rsn and ops_flt_leg

ops_rsn has one composite primary key consisting of six columns.There is no referential integrety established at back end between ops_flt_leg and ops_rsn table.I need to write a query with a outer join between two tables on column ops_flt_leg.irrops_rsn_cd=ops_rsn.rsn_cd.

Hibernate is not supporting oracle (+) sign of making outer join.
Apart from this it is also not supporting hql version following code
select * FROM ops_rsn left outer join Ops_Flt_Leg
on ops_flt_leg.irrops_rsn_cd=ops_rsn.rsn_cd

There is no relationship established in XML of the two table either.

pls help me how to make relationship