I tried to update a very simple hql:

UPDATE TblProduct p SET p.TblCubeLayout=:nulllayout where p.TblCubeLayout=:layout

However, I got exception :

*** ERROR: line 1:19: expecting "set", found 'p'
org.hibernate.hql.ast.QuerySyntaxError: expecting "set", found 'p' near line 1, column 19 [UPDATE TblProduct p SET p.TblCubeLayout=:nulllayout where p.TblCubeLayout=:layout]

If I remove the alias name p as the following, it works.

UPDATE TblProduct SET TblCubeLayout=:nulllayout where TblCubeLayout=:layout

Anybody has some idea?

Thanks

Hi,

you have a false syntax for batch update.

Try: "UPDATE TblProduct SET TblCubeLayout=:nulllayout where TblCubeLayout=:layout "

(don't sure if SET'll work)

This is what I tried. Yes, if remove the alias name, it works. Does this mean I cannot use alias name in update HQL. If it is, I think it is unreasonable because we can use it in sql. Anyway, thanks. Does anybody have other explaination or something is wrong in this HQL?

Thanks

There's no other explanation :)
You can't use aliases.
BTW UPDATE/DELETE in HQL is a quite new feature anyway ;)

by the way

it was A BUG :)

And is fixed in the new Hibernate version 3.1 RC
I just tried it and it works!

Technically it wasn't a bug. The older documentation *clearly* stated that using aliases in UPDATE/DELETE statements was not yet supported :)

OK, maybe it was a feature and not a bug ;)

But in 3.1 RC1 implementation of bulk DEL/UPD is announced as a bug fix ;)