Hi,

This is Jagadish. I have a composite key of 3 columns in mysql database table. I am connecting to the database through hibernate. I am trying to update a row in the table after modifying one of the column in the composite key.

But i am getting the following exception "Could not synchronize database state with session". Can anyone help me.

Regards,
Jagadish

Try and update it using plain HQL or an update query as a named query.....

Dont try to update a key of row, by reading that row from db and then using session.update()

Sudhir

You cannot update the composite key through standard hibernate loads, updates and stuff because changing the key is essentially making a new object/row.

Either delete the old object and make a new one with the new value in the composite key, or like the guy above said, use direct sql to update it. Session.createSqlQuery("update..."); outta do the trick.