In HQL, what is the proper way to escape field names that might be HQL keywords? E.g. in " WHERE where='here' ", what goes around "where"?

I checked the documentation but this info appears to be missing. I've tried backticks, square braces, and double quotes to no avail.

Thanks!

Does anybody here have any idea? This seems like it should be really simple, but I have not discovered anything yet. I've tried single quotes as well.

just use single quote for this around string constant ,,
select u.name from User u where u.address like '%NEW%'

from User u where u.name='Madan'

Thanks, but I want to escape field names, not field values. Like in the example I gave: The second where in WHERE where='here'.

I think you can put the same escape char which is used in native SQL, like [] in mssql, "" in oracle etc...

To extend the example as Madan did,if your search word is perter's then
your query would be
from User u where u.name='peter''s'

I don't think it can be done, like Java, there are some reserved words you can't use as identifiers.

No, I tried this first, because it does work for column names in the Hibernate mapping file. I'm using mssql, putting square braces in the query makes Hibernate complain about an invalid left square brace in the HQL.



There has to be a way... every DBMS has a way to escape field names that could be keywords, I'd have a hard time believing the Hibernate folks forgot to add that.

Also since most DBMS's have their own extensions to SQL, there's no way to actually know what the keywords are, so without a way to escape field names in HQL strings, you're never guaranteed that your query will work...

I mean in my particular case, the problematic field is named "key", which is a perfectly legitimate name for a field. Except "key" is a keyword in MS SQL, and now I have no way to construct those HQL queries for MS SQL...

Yes I was wrong that you have to quote as per the DB. Kewl... Hibernate handles this automatically... You will have to quote them in the xml mapping file. See this:
http://www.hibernate.org/hib_docs/v3/re ... dentifiers

littypreethkr: Thank you so much, you have no idea how glad I am to get that solved. I had been using square brackets in the hibernate mapping, not backticks, and I guess it was confusing the HQL parser even though it worked in other situations. Switching to backticks in the mapping solved the problem.

Thanks!

How about this(NHibernate with C#) when using query: