Re: Update ResultSet for JDBC

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