ORDER BY with JDBC

[albert_dalmau@xxxxxxxx]

Hi,
We have a SQL problem using JDBC with AS400:
SELECT FECHA, CCLAV FROM CO1DCACREU.LSM0 ---> OK
SELECT FECHA, CCLAV FROM CO1DCACREU.LSM0 ORDER BY 1 ---> OK
SELECT FECHA, CCLAV FROM CO1DCACREU.LSM0 ORDER BY 2 ---> NOK: Error SQL0125
SELECT FECHA, CCLAV FROM CO1DCACREU.LSM0 ORDER BY CCLAV ---> NOK: Error
SQL0208
SELECT FECHA, CCLAV FROM CO1DCACREU.LSM0 ORDER BY FECHA ---> NOK: Error
SQL0208

Of course it works directly in AS400.
Con you help us?

Thanks very much

Albert Dalmau