I am using the most recent version of Eclipse, JDK 1.6, ojdb6.jar, and my database is Oracle 18.104.22.168.0.
I am trying to use a scrollable resultset but cannot call the resultset.beforeFirst() method. I have tried using classes12.jar, ojdbc4.jar and ojdbc6.jar. I have tried to make sure that all columns were included in the select statement to ensure there was not an issue with the primary key.
No matter what I do, I cannot get the resultset to use either TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE.
Any suggestions would be very much appreciated.
This is what I am trying to use which is causing the exception below. I want to reset the cursor position before the break.
It looks like the database server has decided your query can't be made scrollable. I don't see what your query is so I can't comment on why it might have decided that. But evidently it has, the error message says as much.
subject: Invalid operation for forward only resultset : beforeFirst