Re: [hibernate-dev] DatabaseMetaData question
Here is what I ended up doing, if anyone in the know could take a look:
https://github.com/hibernate/hibernate-orm/blob/metamodel/hibernate-core/...
The biggest issue is when you have a quoted name that just happens to
be all upper or all lower case. No idea how to determine that. For
example, if you have a quoted table named MY_TABLE coming out from of
the databasemetadata methods and
storesMixedCaseQuotedIdentifiers/storesUpperCaseIdentifiers (the
normal case) I am not sure how you can determine that name is actually
quoted.
On Fri 27 Jul 2012 07:32:52 PM CDT, Steve Ebersole wrote:
Anyone know if there is a (standard JDBC) way to know if the names
returned in the various result sets from DatabaseMetaData are quoted
names?
For example, DatabaseMetaData.getTables(...) returns a ResultSet that
includes, amongst other stuff, catalog name, schema name and table
name. But I need to know if those names are quoted.
Do I just have to leverage the DatabaseMetaData values like:
storesMixedCaseQuotedIdentifiers
storesLowerCaseQuotedIdentifiers
storesUpperCaseQuotedIdentifiers
storesUpperCaseIdentifiers
storesLowerCaseIdentifiers
and use them to decipher the incoming text based on case? Is that
really the only/best option? Or am I missing something?
--
steve(a)hibernate.org
http://hibernate.org