two primary keys in one table

ragsh.skgal · **Joined:** Thu Nov 06, 2008 3:42 am **Posts:** 15

Hi,
I have a table Schoole Profile table in which there are two keys
1. id
2. schname.

For this how should my .hbm.xml. file look like?
Do I have to have two <id> tags one for each? I tried this but it gave an error.

Would you please suggest how to have the xml?

Sukirtha · **Posted:** Wed Nov 18, 2009 6:03 am

Will <composite-id> solve your problem. Composite id helps you map more than one column to be ur key.

Code:

<composite-id>
        <key-property name="medicareNumber"/>
        <key-property name="dependent"/>
</composite-id>

You may check out the complete details at:
http://docs.jboss.org/hibernate/core/3.3/reference/en/html/mapping.html#mapping-declaration-compositeid

ragsh.skgal · **Joined:** Thu Nov 06, 2008 3:42 am **Posts:** 15

Hi All,
There is a very mundane error in data base concepts. I don't think you can have two primary keys in one table
Sorry all for this stupid DUMB question.

Kind Regards,
Sham.