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

Re: [INTERFACES] Q on JDBC's resultset

From: Greg Speegle <Greg(at)10happythings(dot)com>
To: Peter T Mount <peter(at)retep(dot)org(dot)uk>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [INTERFACES] Q on JDBC's resultset
Date: 2001-02-06 22:31:13
Message-ID: 3A807B31.DC58C68A@10happythings.com (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-jdbc

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.

> * How to detect if the query was on a view. Do we support updateable view's?
> (not tried it myself).
>
> * How to detect if a column was a computed value (ie count(*) or col1+col2 etc).

Greg Speegle
Baylor University



In response to

Responses

pgsql-interfaces by date

Next:From: Joel BurtonDate: 2001-02-06 22:34:37
Subject: Re: Set up ODBC driver for access
Previous:From: Familia Ramírez RamírezDate: 2001-02-06 22:02:43
Subject: Problems with locking

pgsql-jdbc by date

Next:From: Franck MartinDate: 2001-02-06 23:26:19
Subject: RE: GIS-type databases using PostgreSQL
Previous:From: Bruce MomjianDate: 2001-02-06 17:53:25
Subject: Re: [ADMIN]

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