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

[Jason Long (JIRA)]

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

Jason Long commented on ANN-210:
--------------------------------

Any update on the status of this?

I just found a way to greatly improve my projects design if I can just use this feature.

I am using Seam 2.0.0 + EJB3.

Is there any way to use the hibernate mapping file only for the class that I need this functionality and still use the annotations for all other entities?

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