For whatever reason, there exists 2 tables LOC (Location - Key Location_Key:LONG) and LOC_ATTR (Location Attributes - Key Location_Attr_Key:LONG) with a one-to-one association, in the sense that one row in LOC table has one and only one row in LOC_ATTR table [sigh!]. Add to that, the only way to index into LOC_ATTR is through Loc_Code:STRING (1 Location_Key = 1 Loc_Code in LOC table). Why Location_key wasn't used in LOC_ATTR is beyond my understanding .. and I cannot change the table structures!

LOC table:


LOC_ATTR table:


Question is this, how do I get LOC and LOC_ATTR using Hibernate? Please help!

This is called Primary key column join.

means Primary Key of Loc is refrred as Foriegn key in Loc_ATTR table and also Primary key.

LOC_CODE is primary key and also forign key in LOC_ATTR table.

This kind of mapping usually do in one-to-one association mapping.

How did you map this association? using hbm.xml or annotations?

once you map you can write a hibernate Query
"From LOC where loc_code=?" this will return LOC object

with this you can get LOC_ATTR by getLOC_ATTR(); because you LOC has LOC_ATTR.

try it out.