"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 Priority: Blocker 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira