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

Re: DatabaseMetadata problems

From: Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: DatabaseMetadata problems
Date: 2001-09-09 08:18:20
Message-ID: s99mpt0qmr7tkucvbgmkoqr02fg9mouogh@4ax.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
[JDBC driver ignores catalog and schema]

On Fri, 07 Sep 2001 09:58:36 -0400, Tom Lane wrote:
>I think it'd be a mistake to expend much effort on this issue in JDBC
>right now.  We will eventually implement SQL92-compliant schemas in the
>backend, and once that happens it'll be possible to do something
>reasonable with the catalog metadata routines in JDBC.  If you try
>to make a half-usable implementation now, you'll just create backwards-
>compatibility issues for the real implementation later.  So my counsel
>is: acknowledge that it's broken, but ignore it for now.

I agree. I've added this to
http://lab.applinet.nl/postgresql-jdbc/:

"PostgreSQL currently does not support SQL92 compliant catalogs
and schemas. With a number of methods (getColumns, getTables,
getProcedures and such) the JDBC driver ignores the catalog and
schema or schemaPattern parameters. getColumns() returns an
empty string (should be null) in the fields TABLE_CAT and
TABLE_SCHEM. getTables() returns null in TABLE_CAT and
TABLE_SCHEM. getProcedures() returns null in PROCEDURE_CAT and
PROCEDURE_SCHEM."

Regards,
René Pijlman <rene(at)lab(dot)applinet(dot)nl>

In response to

pgsql-jdbc by date

Next:From: BhuvaneswariDate: 2001-09-09 08:39:37
Subject: Regarding Installation of jdbc7.0-1.1.jar with postgresql-7.0.3-2.i386.rpm
Previous:From: Barry LindDate: 2001-09-09 08:10:03
Subject: Re: [PATCHES] Fix JDBC test suite, set/get transaction isolation level test in ConnectionTest

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