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

[Jason L. (JIRA) <no...@at...>]

@ManyToOne not working wth @Formula
-----------------------------------

         Key: ANN-210
         URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-210
     Project: Hibernate Annotations
        Type: Bug
    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