Hibernate 3.0.1
I'm in the process of converting from 2.1 to 3.0.1, and ran into a problem with query substituions.
I have some queries where results are ordered such that null values should be last. Since several of the databases I'm using (Postgress, SqlServer) use different semantics for sorting nulls, I use a query substitution (null_last) rather than asc or desc in the query. This is changed in the different property files for Postgres and SQL Server. This worked fine in 2.1
It doesn't work in 3.0.1 though, because the HQL grammer is parsed prior to any substitutions, and my substitution violates the grammar defined for HQL. Shouldn't substitions be process first?
Are there any work arounds or alternative solutions to this?
Thanks,
Jon
|