Re: behavior of getTables() wrt capitalization of type

Brian,

If you look at the description of the getTables call in the jdbc api
documentation they refer to typical values and they are in upper case

Each table description has the following columns:

TABLE_CAT String => table catalog (may be null)
TABLE_SCHEM String => table schema (may be null)
TABLE_NAME String => table name
TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW",
"SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS",
"SYNONYM".
REMARKS String => explanatory comment on the table


Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of brian zimmer
Sent: Wednesday, January 09, 2002 10:12 AM
To: Dave@micro-automation.net; pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] behavior of getTables() wrt capitalization of type


Dave,

Where did you read about being in capitals?  The JDBC spec talks only
about typical values, but doesn't mention anything about capitalization
as far as I can tell.  If capitals it is, I have no problem with that
but the sql parse exception should still be fixed I would think.

thanks,

brian

> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Dave Cramer
> Sent: Wednesday, January 09, 2002 8:14 AM
> To: 'brian zimmer'; pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] behavior of getTables() wrt capitalization of type
>
>
> I had a look at the documentation, and it is suggested that
> the table types s/b uppercase. Does anyone know what the
> correct answer is here?
>
> Currently the driver only supports uppercase table types
>
> Dave
>
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On > Behalf Of brian
> zimmer
> Sent: Wednesday, January 09, 2002 1:54 AM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] behavior of getTables() wrt capitalization of type
>
>
> Hello,
>
> There seems to be a bug in DatabaseMetaData.getTables() with
> respect to the capitalization of the values in the 'types'
> array.  I apologize for not having the latest source, but I
> looked at some slightly older source and found that there is
> an static final array of types (VIEW, TABLE,
> ...) and the corresponding sql clause to query it.  When the
> type values are capitalized all works fine, but if they are
> not then the exception below occurs.  It seems as though each
> value in the types array should be capitalized when doing the
> comparison with the values in the static final array.
>
> I tried figuring it out dynamically through the various
> supports*() and
> stores*() methods on DMD but only
> supportsMixedCaseIdentifiers() returned true and from my
> testing this does not seem to be the case.  I did download
> and test with the latest developer snapshot but the same bug occurs.
>
> Results from running the enclosed test case:
>
> Attempting type [TABLE]
>  table: zxtesting
> SUCCESS with type [TABLE]
>
> Attempting type [table]
>  ERROR:  parser: parse error at or near ")"
> FAILURE with type [table]
>
> thanks,
>
> brian
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
http://www.postgresql.org/users-lounge/docs/faq.html


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster