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)
JTextField tf = new JTextField(10); JTextField tf1 = new JTextField(10); JTextField tf2 = new JTextField(10); JButton bt = new JButton("Next"); JButton bt1 = new JButton("Previous"); JButton bt2 = new JButton("Close"); JFrame fr = new JFrame();
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.