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

I've run into this problem also. Has anyone figured out a way to implement NULLS LAST ?

I never came up with a good workaround. I basically change my build process to make the substitution, rather than have hibernate do it.

I thought about submitting a patch to hibernate, but ended up doing it the quick and easy way.

Jon