aspose file tools*
The moose likes JDBC and the fly likes Unsupported syntax for refreshRow() Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Unsupported syntax for refreshRow()" Watch "Unsupported syntax for refreshRow()" New topic
Author

Unsupported syntax for refreshRow()

hars kumar
Greenhorn

Joined: Apr 06, 2004
Posts: 5
Hi,
I have select query and after executing the query I am doing
rs.absolute() then
while(rs.next()){
....
....
}

when this is executed I am getting
"operation not allowed: Unsupported syntax for refreshRow()"
help me to solve this problem
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Originally posted by hars kumar:
I have select query and after executing the query I am doing
rs.absolute() then
while(rs.next()){
....
....
}

when this is executed I am getting
"operation not allowed: Unsupported syntax for refreshRow()"
help me to solve this problem


- Couldn't get you why rs.absolute() and then rs.next()??
- Where this exception really occurs? on rs.absolute() or rs.next, or after that.
- Your resultset must not be TYPE_FORWARD_ONLY, while using absolute().
hars kumar
Greenhorn

Joined: Apr 06, 2004
Posts: 5
I am using rs.absolute() for pagination, after this I am population the Data to the ValueObject and sending back to jsp page.

my resultset is not TYPE_FORWARD_ONLY.

pstmt=con.prepareStatement(query,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

once I made it to ResultSet.TYPE_SCROLL_INSENSITIVE, then it is working and it is not working for ResultSet.TYPE_SCROLL_SENSITIVE.

thanks for ur reply
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
So, it means you are doing fine with ResultSet.TYPE_SCROLL_INSENSITIVE, but it is not working with ResultSet.TYPE_SCROLL_SENSITIVE. Although, it is nothing like this specified in the docs jdk1.4, though not sure for other versions.

Are you using other than jdk1.4?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unsupported syntax for refreshRow()