I am using Hibernate to persist objects where the class name is "Order". Hibernate generates SQL that cannot execute due to the use of "order" as an alias. "Order" being an SQL keyword, the following error is generated:

"BY expected after GROUP or ORDER: where [from com.x.y.z.businessModel.core.Order as [b]order[/b] where order.id=?]"

Is there any way of controlling the alias that hibernate uses, or forcing it to enclose the alias in quotations appropriate to the SQL dialect?

Thanks

Ian

Excuse the [\b] in the message above. To be clear: these are formatting additions and not part of the original error.

As usual, you find the answer after you post ...

I was getting this error from a call made from a hbm2java generated finder ... So it's a problem with the tool rather than Hibernate itself.

Since I am customising the generator code anyway, I can fix this locally, unless there is a better way?