mapping of tables with no primary key

lince · **Joined:** Thu Feb 12, 2004 10:10 am **Posts:** 6

Hi all,
how do i describe in the mapping file a table with no primary key?
The element <id> inside the element <class> is mandatory, and i've tried everything, i guess...

Thanks,

Luca

christian · **Posted:** Mon Feb 23, 2004 10:58 am

A table with no primary key is broken, as most SQL databases allow duplicate rows. Your data is in danger, change it.

michael · **Posted:** Mon Feb 23, 2004 10:58 am

Usually there is a property or a set of properties which makes your record unique. Map it as an id or a composite id.