ResultSet is ReadOnly with sprinta2000.jar
843854May 6 2003 — edited May 7 2003Hi
I am using sprinta2000.jar to connect to MS SQL Server 2000. The code I am using is as follows :
Class.forName("com.inet.tds.TdsDriver");
Connection con = DriverManager.getConnection("jdbc:inetdae7:walnut:1433?database=asthana" , "siddhartha" , "siddhartha");
DatabaseMetaData data = con.getMetaData();
PreparedStatement pst = con.prepareStatement("Select * from experiment " , ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );
pst.executeUpdate();
ResultSet rs = pst.getResultSet();
rs.moveToCurrentRow();
rs.updateString("LastName" , "anything");
rs.updateRow();
the error I am getting is java.sql.SQLException: [TDS Driver]ResultSet is read only.
Can any body let me know where i am going wrong?
Thanx in advance