Unsupported syntax for refreshRow()

[hars kumar]

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]

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]

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]

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?