posted 14 years ago
Hi,
I have been struggling with this all day.
I am using the most recent version of Eclipse, JDK 1.6, ojdb6.jar, and my database is Oracle 9.2.0.1.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.