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

[Paul Benedict (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Benedict updated HHH-2576:
-------------------------------

    Attachment: HHH-2576-R3.patch

This patch was made against:
https://anonsvn.jboss.org/repos/hibernate/core/branches/Branch_3_3/core

Since no changes ought to have yet effected the same files in 3.5, it should be able to be applied to trunk as well. This patch also respects your tab-only policy.

> Allow native-sql to have placeholders for default schema and catalog
> --------------------------------------------------------------------
>
>                 Key: HHH-2576
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2576
>             Project: Hibernate Core
>          Issue Type: Improvement
>          Components: query-sql
>    Affects Versions: 3.2.3
>            Reporter: Max Rydahl Andersen
>            Assignee: Steve Ebersole
>             Fix For: 3.5
>
>         Attachments: HHH-2576-01.patch, HHH-2576-R2.patch, HHH-2576-R3.patch
>
>
> we shold consider allowing something like:
> <sql-query name="queryName" callable="true">
> { call ${default_schema}.storedProcName() }
> </sql-query>
> similar for normal SQL queries too.
> <sql-query name="queryName">
> select * from ${default_schema}.CUSTOMER x where ...
> </sql-query>
> Maybe ${catalogschema} should be allowed to which would be the full prefix needed dependent on the dialect and would free one from having both catalog and schema + poper seperators in there.

-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira