• Post Reply Bookmark Topic Watch Topic
  • New Topic

"Left join Fetch" "With Clause" Required  RSS feed

Sandeep Vaid
Ranch Hand
Posts: 392
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 :

<one-to-one name="productBasic" class="ProductBasic" cascade="save-update" property-ref="activeProduct" lazy="proxy" constrained="true">

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

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?>
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!