How to make rowid as primary key in hibernate

sreenivasulu.p · **Joined:** Wed Aug 10, 2011 11:24 pm **Posts:** 14

Hi all,
How to make rowid as primary key in hibernate?....Actually in my table no primary key,unique key,composite key....i am requesting to all for a quick solution.......

kundanupadhyaya · **Joined:** Tue Aug 16, 2011 6:57 am **Posts:** 3

Answer available in http://www.cloudsopedia.com/tutorial/hibernate/

sreenivasulu.p · **Joined:** Wed Aug 10, 2011 11:24 pm **Posts:** 14

HI kundanupadhyaya,
In that link i didnt get any information regarding rowid making as a primary key...plz reply with exact link......

sanne.grinovero · **Posted:** Wed Aug 17, 2011 1:38 pm

SreenivaS,
you're asking this on the wrong forum, still I'll briefly answer that what you ask is wrong to do. A ROWID is not consistent so it doesn't univocally identify an entity, it's not suited to be used as primary key. Don't do it.
I think kundanupadhyaya is right by recommending you to learn the basics as a first step.

sreenivasulu.p · **Joined:** Wed Aug 10, 2011 11:24 pm **Posts:** 14

Hi s.grinovero,

Thanks for giving valuable suggession.Actually my problem is i dont have primary key,unique key,composite key in my table.Then how to do the mapping for tht table in hibernate..so,i thought may be we should take rowid as a primary key..Plz understand my problem and reply to me if it is having any solution?

sanne.grinovero · **Posted:** Thu Aug 18, 2011 4:32 am

Quote:

Thanks for giving valuable suggession.Actually my problem is i dont have primary key,unique key,composite key in my table.Then how to do the mapping for tht table in hibernate..so,i thought may be we should take rowid as a primary key..Plz understand my problem and reply to me if it is having any solution?

some options:
1) add a primary key column using a sequence to define it. At least it won't change after you have created it.
2) choose one existing column, or the combination of some, as PK
3) worst case, combine all columns as PK

I'd recommend option 1.

sreenivasulu.p · **Joined:** Wed Aug 10, 2011 11:24 pm **Posts:** 14

Hi s.grinovero ,
Thank you very much for helping me....

Gokalp · **Joined:** Thu Sep 29, 2011 6:52 am **Posts:** 1

s.grinovero, i have this problem too. I cant add pk, this is not possible now.

Is there different solutions about it ? We should set it like pk ?