join on composite foreign key

vincen8147 · **Joined:** Wed May 07, 2008 8:00 pm **Posts:** 3

Hi ya.

I'm using hibernate 3.2 with Oracle 10g. I can't figure out how to configure the hbm.xml file to match my table structure to my POJOs.

If I have the terminology right... I'm trying to map a property from a join done with a composite foreign key. I swear I've tried a 1000 permutations and I can't seem to get it right. Any help is appreciated.

Code:

-----------
-a        -
-----------
A_ID
DESC

-----------
-b        -
-----------
B_ID
DESC

-----------
-a_b      -
-----------
A_ID
B_ID
CODE

-----------
-log      -
-----------
A_ID
B_ID
Message 

------------
Log.java
------------
Private int id;
private A a;
private B b;
private String message;
private String code;

----------------
Log.hbm.xml
----------------
<class name="Log">
   <id name="id" ...
   <many-to-one name="a" column="a_ID"/>
   <many-to-one name="b" column="b_ID"/>
   <property name="message" type="string" column="message"/>
   <join ????
/>

purnachandrarao · **Posted:** Fri May 09, 2008 7:53 am

Hi

I am not getting exactly what u have provided ....

Please send me the pojos and constraints....
I will try to solve your question...

Thanks
PurnachandraRao.

vincen8147 wrote:

Hi ya.

I'm using hibernate 3.2 with Oracle 10g. I can't figure out how to configure the hbm.xml file to match my table structure to my POJOs.

If I have the terminology right... I'm trying to map a property from a join done with a composite foreign key. I swear I've tried a 1000 permutations and I can't seem to get it right. Any help is appreciated.

Code:

-----------
-a        -
-----------
A_ID
DESC

-----------
-b        -
-----------
B_ID
DESC

-----------
-a_b      -
-----------
A_ID
B_ID
CODE

-----------
-log      -
-----------
A_ID
B_ID
Message 

------------
Log.java
------------
Private int id;
private A a;
private B b;
private String message;
private String code;

----------------
Log.hbm.xml
----------------
<class name="Log">
   <id name="id" ...
   <many-to-one name="a" column="a_ID"/>
   <many-to-one name="b" column="b_ID"/>
   <property name="message" type="string" column="message"/>
   <join ????
/>