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

[Sandeep Vaid (JIRA)]

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