Problem with id column

jasmine · **Joined:** Sat Dec 02, 2006 4:23 am **Posts:** 17

Hi all,
Iam using legacy Database( oracle 10g).I want to fetch datas from a view which has no unique key column.Is it possible to do?I have created the view from a audit track table which has no unique key.Then what should i specify in the id tag of the mapping file.
Can anybody answer me?

Regards,
Karthik

intimate2talent · **Posted:** Mon Apr 16, 2007 4:23 am

Hi Kartik,

There is nothing to worry in this regard seince hibernate creats its own primery key for the column which u give for.

Its not so that u must have any unique key in ur table for that.

But besure that u r giving <generator class="assigned"/> instead of increment.

Thnks
With Regards

Saurav Jain

jasmine · **Joined:** Sat Dec 02, 2006 4:23 am **Posts:** 17

Hi Saurav,
Thanks for your response.But after using it also gave some duplicates in the output.Then now iam using compositeid and the error gets rectified.

Regards,
Karthik