Hi,
The scenario: I have a table with a compostite primary
key, say cloumn X+Y. My query is, how can i update
column Y (i wish to change the primary key but change
only one column) using hibernate 2.1.7

Basic SQL would be, update tableName set Y=? where X=?
and Y=?.

Any light on this please...

Thanks in advance

naren

- HQL is not DML (Data Manipulation Language) therefore it is not possible to have an analogous HQL query;
- All the updates handled by Hibernate after setters get called on objects, but changing object ID is not welcomed by Hibernate therefore I suggest you to evict Object from session and then use SQL to update record in the database. (Note: There is potential conflict with 2nd level cache if you are using it.)