Hi,

Maybe I'm just looking int the wrong spot or maybe it isn't possible but can someone provide me with the syntax for updating multiple rows using HQL?

For example something like this:
update Table set col1=newVal1, col2=newVal2 where col3=aValue and col4=bValue;

Obviously that doesn't work or I wouldn't be posting ;p but:
update Table set col1=newVal1 where col3=aValue;
seems to work quite fine so I'm sure it's possible, I just don't know the syntax.

Thanks!

Yes, I've looked at that documentation.

You'll notice it doesn't specifically show how to update multiple columns. I posted that I am not having any trouble updating a single column.

If someone could explain how to or post an example of upating multiple columns from an HQL update statement I would appreciate it.

Thanks.

I have the same question. Did anyone here figured out how to do a multiple rows update?