[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2342) support <load-collection> for stored procedures (see 3.2 documentation section 16.2.2)

[Brian Choi (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_27671 ] 

Brian Choi commented on HHH-2342:
---------------------------------

This will be nice feature. Most of us are dealing with Stored Proc. If this is enabled we can move from SP to generated sql incrementally.
Much easier to buy others into Hibernate.

> support <load-collection> for stored procedures (see 3.2 documentation section 16.2.2)
> --------------------------------------------------------------------------------------
>
>                 Key: HHH-2342
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2342
>             Project: Hibernate3
>          Issue Type: New Feature
>          Components: core
>         Environment: Any new hibernate version/update - Oracle is my personal DBMS preference
>            Reporter: Rick Bradshaw
>   Original Estimate: 2 days
>  Remaining Estimate: 2 days
>
> In the 3.2 documentation 16.2.2 "Using Stored Procedures for Querying" it specifies that "<load-collection>" is not supported.
> The ability to load collections from stored procedures is a powerful idea.  I have done it manually within my own Java implementation and it is a big time / headache saver.  Many of the DB models I work with (and don't have control of) are full of  inconsistencies that can be re-modeled and disguised within a stored procedure that returns sys_refcursor.  Adding the <load-collection> feature will make it really easy/fast to map into hibernate the result sets of stored procedures.  

-- 
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