• 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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!