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@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

> >