Hi,

we have a multiple persistent mapping problem that I cannot resolve.

I have 3 main tables:
- TA_ORGANIZATION
org_code INTEGER PK
- TA_ARTICLE
art_code INTEGER PK
- TA_LANGUAGE
lan_code TEXT PK

Then, I have a table with the relation between TA_ORGANIZATION and TA_ARTICLE:
- TA_ORGART
orgart_org INTEGER PFK
orgart_art INTEGER PFK

and finally I have another table with the translation of each relationship:
- TA_TRANSLATE
tra_org INTEGER PFK
tra_art INTEGER PFK
tra_lan TEXT PFK
tra_vale TEXT

I have made a lot of combinations of Sets, Maps, etc... in the XXX.hbm.xml files, but I am incapable to do it well. I have tried to use some tools to generate the hbm.xml and .java files, but I cannot do it, due to I can get the relations (I use Eclipse and PostgreSQL database).


Please, can somenoe help me and give me the exact files (hbm.xml and java) that I need? It would be enough the hbm.xml file (I hope).


Thank you very much,

Please, anybody can help me?


Thanks,