Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unsupported syntax for refreshRow()

 
hars kumar
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic