Hello Roman,

I've used both Firebird 1.5.3.4870 and Interbase 6.0.1.
The query works from IB Console on both servers.
I suspect a problem with the preparedStatement and the ORDER BY clause.

Catalin.

>
> > 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
>