I hacked the persistence layer to fix it.... This is a great persistence
layer and I hate to add:
if (engine.equals("FIREBIRD") type things to it.... but it is fixed so I
guess I will get on with my life....

The people that wrote the layer (open for business (ofbiz.org) entity
engine) seem to use postgres for internal development. I like postgres
but firebird's native support for windows and linux is great, plus it is
so easy to maintain.... I could go on. This is just a minor setback...
maybe someday firebird will support this syntax.

Later,
Mark

Adam wrote:

>
> Firebird doesn't support that syntax. I am not quite sure why.
> PostgreSQL and others implement it, so I can't think of a reason to
> deliberately not include it.
>
> Changing the persistance layer to "Order By mstwid" or "Order By 1"
> should work in all the dbms systems. Maybe you should put it in as a
> feature request (but search first to see if it is not already suggested).
>
>
>