Am Stuck in moving forwards only in JDBC! :(

[Nandito]

Good morning all...<br><br>I am doing a front-end database application that connects to a ODCB database (Access)<br>The program is able to connect.&nbsp;&nbsp;In the program I have a button to move to the next record and a button that moves to the previous record.&nbsp;&nbsp;I tried with just with the next button using next(); And it worked...Then I tried with the previous(); and oh oh..it did not..I realised I had to include this code <br>hospStatement = conSql.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);<br>I did but still when I pushed the previous button...It gave me an exception saying <br>Java.lang.UnsupportedOperationException<br>So...am stuck with going forward only <br>Can you please help me..as of the reason to this???

 

[chiph]

I think the JDBC-ODBC bridge has cursors that only go forward.&nbsp;&nbsp;Which is a bummer.&nbsp;&nbsp;I don't know if such a beast exists, but you might want to look around for a Type-4 (100% Java) JDBC driver for MS Access.&nbsp;&nbsp;Or maybe consider a switch to something like Sybase SQL Anywhere that does have a Type-4 driver.<br><br>Chip H.<br>

 

[Nandito]

Actually you are right chiph.....the driver that MS provides...does not support JDBC 2<br>So I downloaded one from <A HREF="

http://www.j-netdirect.com"

TARGET="_new">

http://www.j-netdirect.com</A>

and it works as a charm!.........is great...!<br>thanks anyway:&quot;D

 

[chiph]

Nandito -<br><br>Thanks for the link to j-netdirect.&nbsp;&nbsp;I hadn't seen them before now.<br><br>Chip H.<br>