Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Unsupported syntax for refreshRow()  RSS feed

 
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
Boost this thread!