I am using jdk1.2.2, Oracle 8i with Oracle
jdbc classes12.zip driver
I create a result set as below:
_____________________________________________
Statement stmt = con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("SELECT a, b FROM TABLE2");
__________________________________________________
I expect that my result set will be scollable.
I can iterate my result set object in a while
and again come back to the first first row (call first() or beforeFirst() followed by next();
However the above code fails at runtime.
Any suggestions... I do believe that jdk1.2.2 does support jdbc 2.0 - correct me if I am wrong. I guess it must be because I am using old driver. Please tell me if you know which driver would fix this problem.
Thanks,
Swatantra.