idbag

arun.sharma · **Posted:** Sat Apr 11, 2009 12:50 am

Hi friends,

I have mapped the Order class which also includes collection of products.
within same mapping file I also have mapped products as idbag.

My requirement is that when I am retrieveing order the product's ids (primary keys) are not getting available.

Part of Mapping documents:

Code:

<idbag name="products" table="products">      
       <collection-id type="long" column="PRODUCT_ID">
       <generator class="increment">
       </generator>
       </collection-id>
      <key column="ORDER_ID" not-null="true"></key>        
       <composite-element class="com.raisonne.billsmart.GeneralPOs.JobPO">
         <property name="productName" column="PRODUCTNAME" type="java.lang.String"/>

I need the value of "PRODUCT_ID" field for each product object in variable "productId".

Any guidance regarding this issue is highly appriciated.

parmendratyagi · **Posted:** Sun Apr 12, 2009 12:45 am

You are mapping you Product class as a Value type, and <collection-id.../> element just give you functionality to insert the surrogate key without mapping a class as Entity type, but you can't map any property of class with this.

So with current mapping you can't achieve what you want.

you can map Product class a a entity type and then you can access the primary key of the product table.