Subject Re: [Firebird-Java] Re: Tomcat +Firebird 1.5.3 + Jaybird - Order by clause error
Author Roman Rokytskyy

> I've used both Firebird 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.

It is in the ORDER BY clause - you reference column that is not in the list
after SELECT keyword - either put it into SELECT or change the sorted
column. This is exactly what I mean by changed behavior - and there are
other such changes since IB 6.0.