Question of JDBC Driver - Mailing list pgsql-jdbc

From Adile Abbadi
Subject Question of JDBC Driver
Date
Msg-id CCC0FEE90FD1234AAE30B39FAD92181310A32A@cqcgyex01.calgary.cquay.com
Whole thread Raw
Responses Re: Question of JDBC Driver
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: Danny Zhou
Date:
Subject: Bug Report
Next
From: "Dave Cramer"
Date:
Subject: Re: Question of JDBC Driver