I am having no luck getting responses to a question I posted earlier about optimistic locking with multiple rows.
I'll ask a more targeted question. How do I efficiently refresh a single row in a resultset?
Suppose I allow users to view multiple records with TYPE_SCROLL_INSENSITIVE, CONCUR_READ_ONLY.
The user might select one row or 1,000 rows and scroll back and forth at will.
The user might choose to change one of the rows. I do this with a separate FOR UPDATE query.
The update query will fetch the current row, which might be different from the row in the original resultset. My
programmingcompares the two rows and can report to the user the differences. After the row has been updated, I need to
refreshthat row in the result set so that if the user continues to scroll back and forth, it will see the updated
information.
I am using refreshRow. I do setFetchSize(1) first. This works, but sometimes it is very slow. It can take many seconds
overa remote connection. Can I fix that? What's going on?
Note: I don't want to use TYPE_SCROLL_SENSITIVE because it would update the row in the result set silently and I
wouldn'tbe able to tell the user that somebody had changed anything. (Besides, I understand that TYPE_SCROLL_SENSITIVE
doesn'twork reliably.)
Thanks
John
