Hibernate version: 3.1

To create a SQL-statement like
UPDATE person set pers_type = null where pers_type = <something>

One would expect the following HQL to do this:
"update " + Person.MAPPING_NAME + " set "
+ Person.PROPERTY_TYPE + " = null where "
+ Person.PROPERTY_TYPE + " = :type";

While it really is necessary to use the mapping names
for the table and the field after "set", in the where-clause
the mapping name is not translated to the database column
name - so I have to use the column name directly:

"update " + Person.MAPPING_NAME + " set "
+ Person.PROPERTY_TYPE + " = null where "
+ Person.COLUMN_TYPE + " = :type";

Person.PROPERTY_TYPE = "type"
Person.COLUMN_TYPE = "pers_type"

Am I doing something wrong?

Just a guess : isn't 'type' a reserved word in HQL and/or SQL ?

Sorry, this was only a (badly chosen) example.
I have this problem with various tables and columns:
always in the "where"-clause I need to use the real
column name, not the mapping-name, as otherwise
the mapping-name will be part of the resulting SQL.