Menu
▾
▴
hibernate-issues
|
From: Jason L. (JIRA) <no...@at...> - 2006-01-05 17:43:26
|
@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
|
|
From: Sven S. (JIRA) <no...@at...> - 2006-03-10 05:02:03
|
[ http://opensource.atlassian.com/projects/hibernate/browse/ANN-210?page=comments#action_22427 ] Sven Schliesing commented on ANN-210: ------------------------------------- This affects 3.1beta8, too. Any news on if support will be added? > @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 |
|
From: Emmanuel B. (JIRA) <no...@at...> - 2006-03-12 01:47:01
|
[ http://opensource.atlassian.com/projects/hibernate/browse/ANN-210?page=comments#action_22440 ] Emmanuel Bernard commented on ANN-210: -------------------------------------- If I have no vonlunteer, not anytime soon. What I envision is a way to mix @JoinColumn and @Formula for assoications, if anyone interested to contribute let me know > @ManyToOne not working wth @Formula > ----------------------------------- > > Key: ANN-210 > URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-210 > Project: Hibernate Annotations > Type: Bug > Components: binder > 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 |
|
From: Emmanuel B. (JIRA) <no...@at...> - 2006-03-12 01:47:20
|
[ http://opensource.atlassian.com/projects/hibernate/browse/ANN-210?page=all ] Emmanuel Bernard updated ANN-210: --------------------------------- type: Improvement (was: Bug) Component: binder > @ManyToOne not working wth @Formula > ----------------------------------- > > Key: ANN-210 > URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-210 > Project: Hibernate Annotations > Type: Improvement > Components: binder > 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 |
|
From: Jason L. (JIRA) <no...@at...> - 2006-06-24 06:49:33
|
[ http://opensource.atlassian.com/projects/hibernate/browse/ANN-210?page=comments#action_23389 ] Jason Long commented on ANN-210: -------------------------------- Emmanuel, Good to see you again at JBWLV. Have you had any more thoughts on this? Jason > @ManyToOne not working wth @Formula > ----------------------------------- > > Key: ANN-210 > URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-210 > Project: Hibernate Annotations > Type: Improvement > Components: binder > 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 |
|
From: Amir P. (JIRA) <no...@at...> - 2006-07-18 12:36:59
|
[ http://opensource.atlassian.com/projects/hibernate/browse/ANN-210?page=comments#action_23651 ] Amir Pashazadeh commented on ANN-210: ------------------------------------- Bug Still exists on Hibernate 3.2rc3 > @ManyToOne not working wth @Formula > ----------------------------------- > > Key: ANN-210 > URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-210 > Project: Hibernate Annotations > Type: Improvement > Components: binder > 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 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X