Hi all, I encountered an error while executig my application with SQLServer ,Cud anyone Iam using Jdbc2.0 still getting the foll problem find a soln for this :- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc dbc:test","sa",""); Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet res = stmt.executeQuery("select * from emp"); When I use ResultSet.TYPE_SCROLL_SENSITIVE in con.createStatement it works but when i use the above type as mentioned iam getting the foll..error java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented
Thanx in advance nandini&Hema [This message has been edited by nandinivn (edited June 25, 2001).]
posted 16 years ago
Which JDBC are you using? I think you should get JDBC 2.0. One of the new features in the JDBC 2.0 API is the ability to move a result set's cursor backward as well as forward.