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