> When the query is executed I get the following error:
>
> GDS Exception. 335544569. Dynamic SQL Error SQL error code = -104
> Invalid expression in the ORDER BY clause (not contained in either an
> aggregate function or the GROUP BY clause)
>
> Without the order by clause in the sql string it is executed ok.

This is an issue with migrating to Firebird 1.5.3, not related to Java.
Please read the release notes of FB 1.0 and FB 1.5 to know all changed
behavior.

> Note: When I execute the query from the IB Colsole, EMS QuickDesk or
> Minq DBVisualiser (using the same Jaybird JDBC driver) it is executed
> with no problem.

Against which database server did you execute the query? IB 6.0.1 or FB
1.5.3?

Roman