Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Q on JDBC's resultset

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Greg Speegle <Greg(at)10happythings(dot)com>
Cc: Peter T Mount <peter(at)retep(dot)org(dot)uk>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [INTERFACES] Q on JDBC's resultset
Date: 2001-02-07 08:48:08
Message-ID: (view raw or whole thread)
Lists: pgsql-interfacespgsql-jdbc
Quoting Greg Speegle <Greg(at)10happythings(dot)com>:

> Peter T Mount wrote:
> > 7.1 has the beginings of an UpdateableResultSet. When I can work out
> how to
> > solve a few fundamental problems it shouldn't take long.
> >
> > Here's a few questions for people to see if they can figure it out:
> >
> > * How to detect what table a column belongs so. Required if the query
> was a
> > join of 2 or more tables.
> As I understand the JDBC spec, you are not supposed to be able to
> update
> through a ResultSet unless several criteria are met by the query,
> including that the
> query is over exactly one table (to avoid problems like these). I don't
> recall if
> the other cases are also prohibited, but that would make the problem
> easier.

Yes it would make it easier. The problem I have is how to detect when it's just 
a single table.


Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver:
RetepPDF PDF library for Java:

In response to


pgsql-interfaces by date

Next:From: Jan WieckDate: 2001-02-07 10:06:11
Subject: Re: Postgres and Oracle differences and questions
Previous:From: vanam vishnuvardhanDate: 2001-02-07 07:59:11

pgsql-jdbc by date

Next:From: Peter T MountDate: 2001-02-07 09:02:20
Subject: Re: 7.1beta4 jdbc problem on freebsd 4.2 with JSDK 1.1.8.
Previous:From: Peter T MountDate: 2001-02-07 08:40:29
Subject: Re: Re: [ADMIN]

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group