I am having a problem scrolling through a result set that recieves data from a MS Access database. Essentially i would like to move forward and back through the result set while displaying the results in textfields. Ive go this to work fine with a MySQL database. The error that i get is as follows:
java.sql.SQLException: Result set type is TYPE_FORWARD_ONLY at sun.jdbc.odbc.JdbcOdbcResultSet.isLast(JdbcOdbcResultSet.java:2082)
MySQL ResultSets are SCROLL_INSENSITIVE by default, ODBC Bridge ResultSets are not. To tell you the truth, I don't know if the bridge even supports Scrollable ResultSets, but try as above and find out.