sql0199 error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jules - 31 Jan 2005 19:21 GMT

Hi,

I am running a web app and whenever I try to start it it give me the
following error:

java.sql.SQLException: [SQL0199] Keyword ORDER not expected. Valid
tokens: , FROM INTO.

Obviously I understand what the error means, but I have gone through
all the sql statements in my code, and ORDER is not used anywhere...
any thoughts?

Thanks,
Jules

Reply to this Message

Serge Rielau - 31 Jan 2005 20:32 GMT

> Hi,
>
[quoted text clipped - 10 lines]
> Thanks,
> Jules

What's your backend database? DB2 would throw a SQL0104 not a SQL0199.
It actually smells like you have ORDER as a column name and perhaps your
driver doesn't like that. All the proposed token indicate a faulre
parsing the select-list

Cheers
Serge

Signature

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Reply to this Message