Postgres Pro
Downloads
Home   >   mailing lists

Thread: jdbc getTableName, getCatalog, etc.

jdbc getTableName, getCatalog, etc.

From
"Randall W. Barrett"
Date:
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.

    Randy

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

From
Peter T Mount
Date:
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

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

From
"Randall W. Barrett"
Date:
Peter,

Specifically, at the moment at least, I need getTableName(),
getCatalogName() from ResultSetMetaData and getTables() from
DatabaseMetaData.

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
>
>

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

From
Peter T Mount
Date:
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