Hello all,
I'm trying to use aliases in select, and in order to have nice aliases in my medata for a future export, I'm trying to do something like this in HQL :
Code:
select distinct u.firstName as "First name" from User u
And get the following error:
Code:
unexpected char: '"' [select distinct u.firstName as "First name" from User u]
This would work fine in SQL but doesn't work with HQL... Hibernate doesn't seem to support an alias name enclosed in "" (or ' ').
Am I missing something there? Or it's just impossible for me to create an alias containing space chars?
Thanks for your help!
Login
FAQ
Search