Hibernate - Exception

[Maya sekar]

Hi Everyone,

I am currently working on a code in hibernate. you know you have the id field in hibernate mapping files,

<id name="Id" column="Id" type="long">
      <generator class="assigned"/>
    </id>

I understand that the id is mandatory in hibernate and is used to describe the primary key of the table. But my table does not have a primary key since the values of the column can repeat themselves without restriction. But since it is mandatory to define a primary key in hibernate it conflicts with my db and throws an exception when i try to insert duplicate values, like the NonUniqueObjectException Exception.

So is it really "mandatory" to define id in hibernate? Or is it possible to do without it? Or is there another way to resolve this issue....

(am i even making any sense?)


Do help!
Thank you
Have a nice day

[sree hareesh]

it is must to be identified each object (row of table) uniquely in hibernate.so each object gets its uniqueness using either primary key or composite primary key.if you dont specify primary key or composite key in a table , then you can form composite key using all columns of a table.

[Anurag Verma]

Multiple copies of same record in a table is known as redundancy, & this should always be avoided as much as possible. You can have the id field auto-generated instead of keeping it assigned. This should solve your problem.

[Vijitha Kumara]

Anurag Verma wrote:Multiple copies of same record in a table is known as redundancy, & this should always be avoided as much as possible...

It should be avoided completely!