Aliases Support in HQL

[Halcon Guatemala]

Hi guys, I'm doing a query with HQL retrieving properties of several classes and I'm using a plain class for get the result, but I need to use aliases for properties in projection, but I'm getting a message error:

org.hibernate.QueryException: , expected in SELECT [select bi.codigoImpuesto as codigoImpuesto, io.nombre as nombre, ...

how can I name the alias in projection?

Thanks

[Jignesh Patel]

Hope this helps.
from Distributor as dist where (dist.DistbrNm like ?)
[ October 13, 2006: Message edited by: Jignesh Patel ]

[Halcon Guatemala]

Jignesh, Thanks for your reply, I've used the notation for alias You suggest:

from Distributor as dist where (dist.DistbrNm like ?)

however my code is throwing an exception, I think my set (IDE, Hibernate3 Lib, Database) doesn't support the aliases, because I get an error about expecting ',' when my code is '... as ...'

Thanks

[Jignesh Patel]

Hibernate supports aliases from 2.x(or may be before that).

[Halcon Guatemala]

Thanks again Jignesh, I don't think hibernate3 doesn't support aliases. I'm explaining ...

select bi.codigoImpuesto as Impuesto from FisBaImpuestoDto bi

doesn't work in my application
but,

select bi.codigoImpuesto from FisBaImpuestoDto bi

runs without errors...
do you know why is my problem?

Thanks

[Jignesh Patel]

select bi.codigoImpuesto as Impuesto from FisBaImpuestoDto bi
    

assuming codigoImpuesto is a one column in your table, and you are trying to assign alias to the column name.

[Halcon Guatemala]

Thanks again Jignesh , I stay thinking my set (IDE, database and tools) doesn't work fine with aliases, but my IDE doesn't provide docs about it.