Hello,

is there a possibility to quote an alias or property within HQL (not SQL)? The following hql-query is generated automatically from my application, but is not recognizeds as a valid one, due to the usage of the "order" keyword as an alias name:



causes the following error: BY expected after GROUP or ORDER

I looked at the HQL definition, but I wasn't able to find any HQL quote characters. I've tried {} or `` as quotes for the "order" alias, without success. My current solution is to rename the alias in "order_", but I think a general quoting of alias or properties will be a better solution.

Thanks
Peter

Hibernate version:3.0.5

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: MS SQL Server

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

[/code]

No, it is not possible.

Is there a chance to implement quoting?

posted a feature request in Jira for this item. As I mentioned in the issue, I'd be happy to help if someone can give me a pointer towards the right parts of the code.

http://opensource.atlassian.com/project ... e/HHH-1912

posted a feature request in Jira for this item. As I mentioned in the issue, I'd be happy to help if someone can give me a pointer towards the right parts of the code.

http://opensource.atlassian.com/project ... e/HHH-1912