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

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