hi all. i have scenario where im trying to do an unconventional table update and need some help.

i have a table 'contacts' with a mapped java class 'Contact'. for everything else im letting hibernate handle by passing or retrieving a Contact object and everything is working great. however.. im now being asked to make some changes where users will be updating individual fields in the application. in this scenario i wont have a Contact object with values but instead just a single field and its new value (for example 'address' and '1234 HBN lane') along with the contact's id.

im trying to determine the best way to go about making updates to individual fields. i thought of adding a sql-update entry with native SQL to my mapping file but the problem with that is i wont know which field is being updated. i cant do a 'update contacts set ? = ? where ...' so that wont work.

any thoughts on how to best get this done? if it were up to me the app wouldnt work like this but its not so im kind of forced to work with what i have been given. any idea's are greatly appreciated.

thanks
K

You can use a dynamically created query. Something like this: