[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-3877) "Left join Fetch" "With Clause" Required

[Diego Plentz (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Diego Plentz updated HHH-3877:
------------------------------

    Priority: Major  (was: Blocker)

> "Left join Fetch" "With Clause" Required
> ----------------------------------------
>
>                 Key: HHH-3877
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3877
>             Project: Hibernate Core
>          Issue Type: Improvement
>    Affects Versions: 3.3.1
>            Reporter: Sandeep Vaid
>
> Product and ProductBasic has one-to-one relationship
> Product ---> ProductID <<PK>>
> ProductBasic ----> ProductId, useCode, StartTime as composite key.....
>   this startTime's value will be known as runtime.
> Now i want to define mapping between Product & ProductBasic, how will i do it ?
> Moreover suppose i define their mapping as product.productID = productBasic.productID and useCode='a' as :
> Product.hbm.xml: 
>   <one-to-one name="productBasic" class="ProductBasic" cascade="save-update" property-ref="activeProduct" lazy="proxy" constrained="true">
>     <formula>'008'</formula>
>     <formula>PRODUCTID</formula>
>  </one-to-one>
>  
>  
>  ProductBasic.hbm.xml as :
>  <properties name="activeProduct">
>    <property  name="useCode" column="USECODE"></property>
>    <many-to-one name="productBO" class="ProductBO" column="PRODUCTID" insert="false" update="false"/> 
>   </properties>
> How can i specify startTime value at runtime (say in eager fetching)? I can't use "inner join fetch" along "with clause".. ?
> Or i want to specify a condition in fetch join that startTime<currentTime<endtime. the value of currenttime will be known
>  at runtime...How to make this work?

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