Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error while using jdbc2.0 features with SqlServer

 
nandinivn
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).]
 
rani bedi
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic