hi folks
i have got a
java program below for reading records from the last.it compiles fine.but when i run it says invalid cursor type.
i have used ms-access 2000 and created a dsn entry.i am using jdk1.3. will jdbc-odbc connectivity work fine only for forward record fetch.pl clarify.
regards
ram ganesh
import java.sql.*;
class test{
public static void main(
String args[]) throws Exception{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc
dbc:test");
Statement stmt=con.createStatement(ResultSet.FETCH_REVERSE,ResultSet.CONCUR_READ_ONLY);
ResultSet ab=stmt.executeQuery("Select * from ram");
while(ab.next()){
System.out.println(ab.getRow());
System.out.println(ab.getString(2));
if (ab.getRow()==1)
ab.previous();
}
}
}
Exception in
thread "main" java.sql.SQLException: Invalid Cursor Type.
at sun.jdbc.odbc.JdbcOdbcStatement.initialize(JdbcOdbcStatement.java:140
)
at sun.jdbc.odbc.JdbcOdbcConnection.createStatement(JdbcOdbcConnection.j
ava:420)
at test.main(test.java:6)