[hibernate-issues] [Hibernate-JIRA] Commented: (ANN-210) @ManyToOne not working wth @Formula

[George Harp (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/ANN-210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_26812 ] 

George Harp commented on ANN-210:
---------------------------------

How about I start in my working copy:
@JoinColumnWithFormula
@JoinColumnWithFormulas

And before I send you the patch I'll check back here to see if you decided to create org.hibernate.annotations.JoinColumn instead?
Which would only mean easy refactor.

is WithFormula ok?
or do you prefer OrFormula?




> @ManyToOne not working wth @Formula
> -----------------------------------
>
>                 Key: ANN-210
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-210
>             Project: Hibernate Annotations
>          Issue Type: Improvement
>          Components: binder
>    Affects Versions: 3.1beta7
>         Environment: Hibernate 3.1,  PostgreSQL 8.1.1
>            Reporter: Jason Long
>
> 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