Updateable ResultSet

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/