[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-4382) @ManyToOne not working wth @Formula
Emmanuel Bernard (JIRA)
noreply at atlassian.com
Fri Oct 9 12:24:44 EDT 2009
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Emmanuel Bernard resolved HHH-4382.
-----------------------------------
Resolution: Fixed
Fix Version/s: 3.5
> @ManyToOne not working wth @Formula
> -----------------------------------
>
> Key: HHH-4382
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4382
> Project: Hibernate Core
> Issue Type: Improvement
> Components: annotations
> Environment: Hibernate 3.1, PostgreSQL 8.1.1
> Reporter: Steve Ebersole
> Fix For: 3.5
>
>
> This type of mapping fails:
> @ManyToOne
> @Formula(value="( select v_pipe_offerprice.offerprice_fk from v_pipe_offerprice where v_pipe_offerprice.id = id )")
> public OfferPrice getOfferPrice() { return offerPrice; }
> While the following mapping works as expected:
> <class name="Pipe" table="t_pipe">
> ...
> <many-to-one name="offerPrice"
> class="pipetracker.model.price.OfferPrice"
> formula="( select v_pipe_offerprice.offerprice_fk
> from v_pipe_offerprice
> where v_pipe_offerprice.id = id )"/>
> ...
> </class>
> This is not being treated as a formula because the generated SQL included a referece to the field pipe.offerprice_id which does not exsist because this is a virtual column calculated from a view.
--
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
More information about the hibernate-issues
mailing list