I am having a problem with the JDBC driver I am using regarding column aliases.

The driver will execute the query ok, but when Hibernate tried to grab the value of the column by the alias, the driver throws an error.


This is a problem with the DB driver and not with Hibernate. Here is my actual question though:

I have noticed when doing an HQL query the aliases that are in the query are the same as the column names. If I execute a query using HQL and this driver, the hibernate load works.

If I try to do a criteria query, the aliases are different then the column names and the driver fails.

Is there anyway through a custom dialect to change how the aliases are done in a Criteria query?


Thanks,

Paul

Hibernate version:

2.1.7

Is this not possible? I don't really want to change the hibernate source, but would not mind writting a custom dialect if this is something that can be controlled through it.

Thanks,

Paul