|Subject||Re: [Firebird-Java] Tomcat +Firebird 1.5.3 + Jaybird - Order by clause error|
> When the query is executed I get the following error:This is an issue with migrating to Firebird 1.5.3, not related to Java.
> 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.
Please read the release notes of FB 1.0 and FB 1.5 to know all changed
> Note: When I execute the query from the IB Colsole, EMS QuickDesk orAgainst which database server did you execute the query? IB 6.0.1 or FB
> Minq DBVisualiser (using the same Jaybird JDBC driver) it is executed
> with no problem.