Re: Update ResultSet for 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@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
> >
> >
> > __________________________________________________
> > 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