[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2576) Allow native-sql to have placeholders for default schema and catalog

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2576?page=c... ] Paul Benedict commented on HHH-2576: ------------------------------------ I wrote a patch and will upload it soon. This is how I have approached the issue, and am sharing my philosophy early to receive any feedback. All Hibernate properties will become available to SQL parsing. They are under the alias "hibernate" such as: SELECT * FROM {hibernate.default_schema}.table SELECT * FROM table FETCH FIRST {hibernate.default_batch_fetch_size} ROWS ONLY I gave two special considerations "hibernate.default_schema" and "hibernate.default_catalog". If these property names actually end in a dot, I include the dot at the end, which will facilitate allowing fully-qualified objects being optional if these properties are not specified. This requires a default schema otherwise the SQL is invalid: SELECT * FROM {hibernate.default_schema}.table This allows the schema to be totally optional: SELECT * FROM {hibernate.default_schema.}table -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira