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