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