I am lost going throuh the forum, hence please forgive if this question is a repeat.

I have table Foo whose identifier is an assigned value.
If there is a row in the table Foo like
5,'test' and I want to change it to
8,'test'

Can I update the identifier value?

Example:

session = HibernateUtil.currentSession();

Foo foo = (Foo) session.load(Foo.class,new Integer(5));

foo.setIdentifier(8);

session.flush();

HibernateUtil.closeSession();

If this is not supported are there any alternatives :-(

Please help !!!!!

Thanks in advance!!!!

Primary keys don't change.

workout I think is to delete the old one, and enter a new one.

I have never felt the need for this thought, when I have a primary key.

Why can't you just change the value of the foreign key?

Pritpal Dhaliwal

Thanks for reply...


Foo is master table and there are "n" tables referring to Foo...
Hence delete and inserting would not work in my case...



If a user enters a wrong value for the identifier, as this identifier is assigned, user cannot be forced to delete the same and enter all the values again....



Is there a way out by using native sql queries for a work around

Why do you use natural keys instead of a surrogate key? If this is not a legacy database application, use surrogate keys.

you let the user enter their own identifier?

thats pretty weird to me.... I might be a new kid on the block, well not that new, but never seen that happen

I have always thought letting a user change the identifier is a BIG NO NO..



changing the identifier is like deleting and inserting..


but chapter 13 (wow), might be able to help you with your native queries.
http://www.hibernate.org/hib_docs/refer ... rysql.html


Pritpal Dhaliwal