Re: Question of JDBC Driver - Mailing list pgsql-jdbc

The updateable result set functionality has not been implemented.

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Adile Abbadi
Sent: October 12, 2001 9:57 PM
To: pgsql-jdbc@postgresql.org
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: adile.abbadi@cquay.com - Website: www.cquay.com


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly