Hello, the JDBC-driver throws an JDBCException "No columns updatable" also when parsing of your sql command fails. What's the version of your JDBC-driver ( java -jar <JDBCDriver> -V )? The version should be greater than 7.3.0.17. A JDBC-trace (http://sapdb.2scale.net/moin.cgi/JdbcTrace) and a kernel trace (http://sapdb.2scale.net/moin.cgi/VTrace) would be very helpful to analyze this problem in detail. Maybe I can help you if you send the traces to me.
Regards, Marco > -----Original Message----- > From: Joerg von Frantzius [mailto:[EMAIL PROTECTED]] > Sent: Montag, 25. Februar 2002 17:46 > To: [EMAIL PROTECTED] > Subject: JDBC updatable ResultSet? > > > In an article in comp.lang.java.databases, someone from SAP > stated that > SAPDB supports updatable ResultSets. Using > > sapCon.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, > ResultSet.CONCUR_UPDATABLE); > > I created a Statement that should produce updatable > ResultSets and executed > a query on it ("select * from table_name"). But when I call > moveToInsertRow() on the ResultSet, all I get is > > "com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP > DBTech JDBC: No > columns updatable" > > How can a column not be updatable? What's wrong? > > Thanks for any hints, > J�rg. > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
