• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sql exception

 
Nijeesh Balan
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 265
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic