Re: Updateable ResultSet

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@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
> > >
>
> ###########################################
>
> This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
> For more information, connect to http://www.F-Secure.com/