To: Greg Speegle <Greg@10happythings.com>
Subject: Re: [INTERFACES] Q on JDBC's resultset
Message-ID: <981535688.3a810bc8a36da@webmail.retep.org.uk>
Date: Wed, 07 Feb 2001 03:48:08 -0500 (EST)
From: Peter T Mount <peter@retep.org.uk>
Cc: Peter T Mount <peter@retep.org.uk>, pgsql-jdbc@postgresql.org
References: <Pine.GSO.4.21.0102012132230.9884-100000@ural2>
	<981454871.3a7fd017dc11f@webmail.retep.org.uk>
	<3A807B31.DC58C68A@10happythings.com>
In-Reply-To: <3A807B31.DC58C68A@10happythings.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: IMP/PHP IMAP webmail program 2.2.3

Quoting Greg Speegle <Greg@10happythings.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

-- 
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/