sql exception

[Nijeesh Balan]

Iam executing a select query in servlet, it is working fine when 'order by' is not present.
when 'order by' is given, query is not executed and it is throwing a sql exception.
Exception is : unsupported syntax for refreshrow(); java.sql.SQLException
thanks
nijeesh bh

[Graham Thorpe]

First u execute ur query in either oracle or sql,if it is working then ur colde also working.if u have still doubt send oncce again

[Nijeesh Balan]

Thanks for your response.
I have identified the source of error. Unfortunately i don't have the solution.
I'm facing this problem when i have more than 10 records in the db table. The reason could be that when u traverse through the resultset after 10 rows it refreshes it and hence throws the error.
Thanks In Advance.
Nijeesh.