Re: [INTERFACES] jdbc getTableName, getCatalog, etc. - Mailing list pgsql-interfaces

From Peter T Mount
Subject Re: [INTERFACES] jdbc getTableName, getCatalog, etc.
Date
Msg-id Pine.LNX.4.04.9812291504050.8386-100000@maidast.retep.org.uk
Whole thread Raw
In response to Re: [INTERFACES] jdbc getTableName, getCatalog, etc.  ("Randall W. Barrett" <rbarr@shadow.net>)
List 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@retep.org.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@retep.org.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


pgsql-interfaces by date:

Previous
From: ptortosa@anfi.es (Placido Tortosa)
Date:
Subject: ERROR OBCD and MSQuery
Next
From: Byron Nikolaidis
Date:
Subject: Re: [INTERFACES] Re: ODBC DRIVER v06-40-0002