OraFAQ Forum: JDeveloper, Java & XML » Unsupported syntax for refreshRow

Home » Developer & Programmer » JDeveloper, Java & XML » Unsupported syntax for refreshRow

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unsupported syntax for refreshRow [message #91731]

Wed, 22 January 2003 22:34

Vaibhav Deoghare
Messages: 1
Registered: January 2003

Junior Member

Hello SQL experts..
Please help me out..

I am getting the an error message saying 'Unsupported syntax for refreshRow()' when I am trying to execute a query on Oracle using a JDBC thin driver.

I have used the Scrollable resultsets.. I s there any connection of this with the error that I am getting.

Please help me out...

Report message to a moderator

Re: Unsupported syntax for refreshRow [message #91826 is a reply to message #91731]

Tue, 11 March 2003 18:43

Milind Bhalekar
Messages: 1
Registered: March 2003

Junior Member

Dear Vaibhav,
I am not sure what SQL query you are using. Generally this problem I have seen if you use ORDER BY and the result returns more than 10 rows. I suggest try "select distinct" or "group by" in your query.

Please refer following link for further information: http://forum.java.sun.com/thread.jsp?thread=89078&forum=48&message=609175

-Milind

Report message to a moderator

Re: Unsupported syntax for refreshRow [message #92411 is a reply to message #91731]

Mon, 05 July 2004 01:59

Kamali
Messages: 1
Registered: July 2004

Junior Member

You are required to close the Result Set using rs.close() after use.

Report message to a moderator

Re: Unsupported syntax for refreshRow [message #92662 is a reply to message #91826]

Wed, 10 November 2004 12:19

Miguel Angel Quijia
Messages: 1
Registered: November 2004

Junior Member

I had the same problem , but I found the solution for this problem. Only use this driver call "Oranxo.jar", you can find this driver downloading this file " Oranxo_Trial_2.08.zip" you must look for in http://www.google.com

Report message to a moderator

Previous Topic:	solution for io exception
Next Topic:	oracle universal installer error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 00:37:33 CDT 2024