Question of JDBC Driver

From: "Adile Abbadi" <Adile(dot)Abbadi(at)cquay(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Question of JDBC Driver
Date: 2001-10-13 01:57:15
Message-ID: CCC0FEE90FD1234AAE30B39FAD92181310A32A@cqcgyex01.calgary.cquay.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)abbadi(at)cquay(dot)com - Website: www.cquay.com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Rene Pijlman 2001-10-13 07:14:19 Re: J2SE 1.4 and other patches
Previous Message Barry Lind 2001-10-13 01:30:02 Re: [GENERAL] Error messages