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@micro-automation.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
> >
