The updateable result set functionality has not been implemented. Dave
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adile Abbadi Sent: October 12, 2001 9:57 PM To: [EMAIL PROTECTED] Subject: [JDBC] Question of JDBC Driver Hi there, I'm using PostgreSQL ver 7.1 and I am having a bit of a problem with the jdbc driver. I want to use some of the ResultSet methods, but I seem to be having difficulity using some of them. I can't seem to do anything against an updatable ResultSet, such as moveToInsertRow or updateString. Here is a snipnet of my code Statement SQLStatement = Conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_ UPDATABLE); String query = "select * from cust_acct;"; ResultSet sr = SQLStatement.executeQuery(query); sr.moveToInsertRow(); sr.updateString("compname",props[4]); sr.insertRow(); sr.close(); SQLStatement.close(); And this is the error I get javax.servlet.ServletException: This method is not yet implemented. at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContex tImpl.java:459) at cquay.admin.cms._0002fcquay_0002fadmin_0002fcms_0002fcreate_0005fcust_00 02ejspcreate_0005fcust_jsp_76._jspService(_0002fcquay_0002fadmin_0002fcm s_0002fcreate_0005fcust_0002ejspcreate_0005fcust_jsp_76.java:576) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServle t.java:177) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.jav a:797) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnec tion(Ajp12ConnectionHandler.java:166) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416 ) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:49 8) at java.lang.Thread.run(Thread.java:484) Root cause: This method is not yet implemented. at org.postgresql.Driver.notImplemented(Driver.java:382) at org.postgresql.jdbc2.UpdateableResultSet.moveToInsertRow(UpdateableResul tSet.java:98) at cquay.admin.cms._0002fcquay_0002fadmin_0002fcms_0002fcreate_0005fcust_00 02ejspcreate_0005fcust_jsp_76._jspService(_0002fcquay_0002fadmin_0002fcm s_0002fcreate_0005fcust_0002ejspcreate_0005fcust_jsp_76.java:174) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServle t.java:177) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.jav a:797) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnec tion(Ajp12ConnectionHandler.java:166) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416 ) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:49 8) at java.lang.Thread.run(Thread.java:484) I have imported java.sql.* and I can do executeUpdate or retreave data via the ResultSet Object. Any assistance you can provide would be appreciated. Cheers Adile ________________________________________________________ Mr. Adile Abbadi - Business Analyst - Cquay Inc Ph: (403) 261-6568 - Fax: (403) 233-2135 - Cell: (403) 630-8901 Email: [EMAIL PROTECTED] - Website: www.cquay.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
