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/src/main/java/org/hibernate/engine/jdbc/env/internal/NormalizingIdentifierHelperImpl.java
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? > > -- st...@hibernate.org http://hibernate.org _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
