Siddhartha Asthana

Greenhorn
+ Follow
since May 05, 2003
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Siddhartha Asthana

Hi Peter
The documentaion does say that the updatable resultset is supported
http://www.inetsoftware.de/English/Produkte/JDBC2/readme.txt
however...it also mentions that if a perticuler query is not supported by the databse then i might get a readonly resultset.
But as u mentioned my query is simple enough not to pose any problem....dont know where i am going wrong
I did that. The error changed to :
java.sql.SQLException: [WALNUT]The cursor is READ ONLY
where WALNUT is the hostname of the m/c where my SQL server is installed.
Hi
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();
System.out.println(" result set cursor name " + rs.getCursorName());
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