From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | "Randall W(dot) Barrett" <rbarr(at)shadow(dot)net> |
Cc: | Pgsql-Interfaces <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Re: [INTERFACES] jdbc getTableName, getCatalog, etc. |
Date: | 1998-12-29 15:10:09 |
Message-ID: | Pine.LNX.4.04.9812291504050.8386-100000@maidast.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Tue, 29 Dec 1998, Randall W. Barrett wrote:
> Peter,
>
> Specifically, at the moment at least, I need getTableName(),
> getCatalogName() from ResultSetMetaData and getTables() from
> DatabaseMetaData.
Ah I see the problem.
First: PostgreSQL doesn't support Catalogs, so getCatalogName returns an
empty "" string. All methods that take a Catalog Name or pattern simply
ignore them.
As for getTableName(), it's not implemented, as it's not easy to find out
what table a particular column in a ResultSet belongs to, especially if
more than one table is used in a query, and not all columns come from
tables.
Currently it returns an empty string ""
> On Tue, 29 Dec 1998, Peter T Mount wrote:
>
> > On Mon, 28 Dec 1998, Randall W. Barrett wrote:
> >
> > > I noticed in the ResultSetMetaData.java file that support for
> > > getTableName() and some other methods wasn't complete. I was wondering
> > > what the status of this was. If still not done, I will try to complete
> > > these methods myself as I need them.
> >
> > I'm working on the JDBC driver at the moment (having to re-write some
> > parts to allow the driver to compile on JDK 1.2/2).
> >
> > What part methods are you looking at?
> >
> > --
> > Peter T Mount peter(at)retep(dot)org(dot)uk
> > Main Homepage: http://www.retep.org.uk
> > PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
> > Java PDF Generator: http://www.retep.org.uk/pdf
> >
> >
>
>
--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
From | Date | Subject | |
---|---|---|---|
Next Message | Byron Nikolaidis | 1998-12-29 15:28:27 | Re: [ANNOUNCE] ODBC DRIVER v06-40-0002 |
Previous Message | Byron Nikolaidis | 1998-12-29 14:57:29 | Re: [INTERFACES] Re: ODBC DRIVER v06-40-0002 |