Hi, all,
I am having problems using the updateable cursor feature of JDBC 2.0.
My code snippet looks like:
Connection conn = java.sql.DriverManager.getConnection("jdbc:
oracle:thin:@dev:8000:mydb","mylogin","mypasswd");
Statement stmt = conn.create(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("select * from num");
rs.moveToInsertRow();
This last line produces the SQLException:
Invalid operation for read only resultset: moveToInsertRow
I am using NES 4.0 SP3 and JDK 1.2.
Any suggestions?
Thanks.
John Gbur
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
