Hi,
I am using spring+hibernate+jboss+oracle db
I am trying to change the primary key value of one column of table. I am sure that i am trying to insert the value is currently not there in the db.But I am getting this exception while trying to saveOrUpdate.

org.springframework.orm.hibernate3.HibernateSystemException: identifier of an instance of com.nbs.ebb.persistence.Phase altered from 7 to 999998; nested exception is org.hibernate.HibernateException: identifier of an instance of com.nbs.ebb.persistence.Phase altered from 7 to 999998
org.hibernate.HibernateException: identifier of an instance of com.nbs.ebb.persistence.Phase altered from 7 to 999998
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:51)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:82)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:190)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:70)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:324)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:586)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:564)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:537)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:267)


any body can u help out pls....

Regards,
Ram

Changing the primary key value of one column of table is definitely looked down upon!

Could you show us your code, and maybe we can approach your problem from a different angle?

Changing the pk is a bad idea...
I think you mean deleting the previous one and saving it as a new one...
Hibernate can't keep track of something that's not uniquely identified...

Or maybe consider re-designing your app as it sounds like it's not a real PK...
Maybe think about a surrogate PK. I generate a UUID in code and never change it ever again....

Deleting a previous record, and saving it again as a new record isn't too tough.

You can just load the record, evict it - which gives you the POJO with all of its information, delete it, and then re-save it. It'll go in with a new Id.

Just an idea.