Re: Updateable ResultSet

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: "Merilinna, Juhani" <juhani(dot)merilinna(at)adulta(dot)fi>
Cc: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Updateable ResultSet
Date: 2002-08-30 18:10:12
Message-ID: 1030731012.1595.451.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Yes, I have a patch for this, and just have to get around to applying
it.

Dave
On Fri, 2002-08-23 at 03:00, Merilinna, Juhani wrote:
> Hi
>
> I use the same Postgresql and JDBC versions and get the same error message.
> But, if I once call updateRow, then moveToInsertRow works without errors.
>
> Juhani Merilinna
> juhani.merilinna.adulta.fi
>
>
> >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
> > >
>
> ###########################################
>
> This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
> For more information, connect to http://www.F-Secure.com/

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Sean Gates 2002-08-30 18:44:41 JDBC updateNull method returns null pointer exception
Previous Message Dave Cramer 2002-08-30 18:07:32 Re: Connections/Statements/ResultSets (Was: Re: Pooling