[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3927) one-to-one with property-ref always non-lazy

[Sandeep Vaid (JIRA)]

one-to-one with property-ref always non-lazy
--------------------------------------------

                 Key: HHH-3927
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3927
             Project: Hibernate Core
          Issue Type: Improvement
          Components: core
    Affects Versions: 3.3.1
            Reporter: Sandeep Vaid


I have one-to-one relationship between Product and ProductBasic.


  <one-to-one name="productBasic" cascade="save-update" property-ref="activeProduct" lazy="proxy">
    <formula>'1'</formula>
    <formula>PRODUCTID</formula>
 </one-to-one>
 
 
 ProductBasic.hbm.xml as :
 <properties name="activeProduct">
   <property  name="Code" column="CODE"></property>
   <property  name="pId" column="PID" insert="false" update="false"></property>
  </properties>
  
  
  When i am using property-ref, and try to load Product, it eagerly fetches ProductBasic also as :
  
  select *
  from PRODUCT productbo0_ left outer join PRODUCTPERIOD productbas1_ on '18'=productbas1_.CODE and productbo0_.PID=productbas1_.PID where productbo0_.PID=?
  
 NOTE: Along with Product, ProductBasic is also fetched in a single query.
 
 Even if i add constrained="true" in one-to-one mapping, the query gets fired as :
  select * from PRODUCT productbo0_ where productbo0_.PID=?
  select * from PRODUCTBASIC productbas0_ where productbas0_.CODE=? and productbas0_.PID=?
  
  NOTE: Along with Product, ProductBasic is also fetched in a different query.
  
  BUT in both these cases, ProductBasic is fetched always (non-lazy)..
  
  How can i fetch ProductBasic in a Non-Lazy manner in this case.
  
  I have this requirement because i use filter on ProductBasic. and now when this ProductBasic is fetched always (non-lazyly) it doesn't
  apply my filter.
  

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