Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

RefreshRow Problem.

 
Nijeesh Balan
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
We are facing a weird problem.. Still not able to find a way out..
When we fire a SELECT query with a "Order by" Clause it throws an error.
java.sql.SQLException: operation not allowed: Unsupported syntax for refreshRow()
but the same works if the no., of records in the table is less than 10.
Please help.
Thanks in Advance,
Nijeesh.
 
Mike Curwen
Ranch Hand
Posts: 3695
IntelliJ IDE Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here's an Oracle document on this topic:
http://download-west.oracle.com/otndoc/oracle9i/901_doc/java.901/a90211/resltset.htm#1018134

I've given you an anchor'd link, so search from that point downward until you find "Result Set Limitations and Downgrade Rules", and under that "Result Set Limitations"

This is how Oracle has implemented the API, and perhaps the database you are using has done something similar.

This is also being moved to the JDBC forum.
 
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!