Re: Update ResultSet for JDBC

From: Zengfa Gao <zfgao(at)yahoo(dot)com>
To: Dave Cramer <Dave(at)micro-automation(dot)net>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Update ResultSet for JDBC
Date: 2002-08-22 15:36:30
Message-ID: 20020822153630.28957.qmail@web12302.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I used postgresql 7.21 version on Redhat 7.1 system,
got same error. I used JDBC development version.

ERROR: Got exception: Result Set not updateable. The
query that gene
rated this result set must select only one table, and
must select all primary ke
ys from that table. See the JDBC 2.1 API
Specification, section 5.6 for more details.

But I only select one table, and I select all columns
include primary key.

How can I get "Updateable ResultSet" works?

Thanks!

Zengfa

--- Dave Cramer <Dave(at)micro-automation(dot)net> wrote:
> It's possible it doesn't work with a 7.0 database.
> Why are you using
> such an old version?
>
> Dave
> On Thu, 2002-08-15 at 14:21, Zengfa Gao wrote:
> > Hi, all:
> >
> > >From JDBC website, I got
> >
> > Latest Java/JDBC news
> > Jun 23 Updated dev drivers that include callable
> > statement support and updatable result set support
>
> >
> > Then I downloaded 7.3Dev version of JDBC driver
> and
> > try to use updatable result set.
> >
> > When I run
> >
> > ResultSet rs = stmt.executeQuery(selectStat);
> >
> > rs.moveToInsertRow();
> >
> > I got:
> >
> >
> > ERROR: Got exception: Result Set not
> > updateable. The query that gene
> > rated this result set must select only one table,
> and
> > must select all primary ke
> > ys from that table. See the JDBC 2.1 API
> > Specification, section 5.6 for more det
> > ails.
> >
> >
> > But I only select from one table, and I select all
> > columns from that table include primary key. Does
> > anyone know why it failed at here?
> >
> > I used PostgreSQL 7.0.3 on Redhat system.
> >
> > Thanks,
> >
> > Zengfa
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > HotJobs - Search Thousands of New Jobs
> > http://www.hotjobs.com
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
> >
>
>
>

__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Merilinna, Juhani 2002-08-23 07:00:39 Updateable ResultSet
Previous Message Dave Cramer 2002-08-22 12:33:14 Re: Question about JDBC?