Re: [INTERFACES] jdbc getTableName, getCatalog, etc.

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