I have the mapping of my object like the following. When i try to Session.save(order) Order is getting inserted but Order Items are updated. How do we change it to inserting ?

<hibernate-mapping>
<class name="ps.model.Order" table="Order">
<id type="java.lang.Long" column="Order_ID" name="OrderId">
<generator class="assigned"/>
</id>
<property type="java.util.Date" column="DATE_CREATED" name="dateCreated" />
<property type="java.util.Date" column="TIME_CREATED" name="timeCreated" />
<property type="java.lang.String" column="CREATED_BY" name="createdBy" />
<property type="java.lang.String" column="Order_TYPE" name="OrderType" />
<set name="items" lazy="false" cascade="save-update" inverse="true">
<key column="Order_ID" />
<one-to-many class="ps.model.OrderItems" />
</set>

</class>
<class name="ps.model.OrderItems" table="Order_ITEMS">
<composite-id>
<key-many-to-one name="OrderId" class="ps.model.Order" column="OrderId"/>
<key-property name="itemNo" type="java.lang.Long">
<column name="ITEM_NO" not-null="true"/>
</key-property>
</composite-id>
<property type="java.lang.String" column="STATUS" name="status" />
<property type="java.lang.Long" column="QTY" name="qty" />

</class>
</hibernate-mapping>

Look at the cascade attribute on your one-to-many association. You have not specified it.

Read chapter 11.11

http://www.hibernate.org/hib_docs/v3/re ... transitive

I have added the cascade with the set.

<set name="items" lazy="false" cascade="save-update" inverse="true">

do we need to add anywhere else ?!!

I am probably not getting your question right.

Maybe your problem is: You are creating a new Order and associate OrderItems to it and you would like Hibernate to create new OrderItems instead of issuing an Update statement.

Is that correct?

If this is the case, you must understand that an OrderItem is unique (Two java objects represent the same OrderItem (id) are the same object, in terms of persistence).

If you associate the same reference of an OrderItem to multiple Orders, or associate different instances representing the same OrderItem, the OrderItem will be the same for all of them and it will get updated each time you modify one of them.

If you want new OrderItems to be associated to each Order, do not reuse existing OrderItems, just create new ones.

Good luck

<hibernate-mapping>
<class name="ps.model.Order" table="Order">
<id type="java.lang.Long" column="Order_ID" name="OrderId">
<generator class="assigned"/>
</id>
<property type="java.util.Date" column="DATE_CREATED" name="dateCreated" />
<property type="java.util.Date" column="TIME_CREATED" name="timeCreated" />
<property type="java.lang.String" column="CREATED_BY" name="createdBy" />
<property type="java.lang.String" column="Order_TYPE" name="OrderType" />

//try this

<bag name="items" lazy="true" inverse="true" cascade="all">
<key column="Order_ID"/>
<one-to-many class="ps.model.OrderItems"/>
</bag>


</class>
<class name="ps.model.OrderItems" table="Order_ITEMS">
<composite-id>
<key-many-to-one name="OrderId" class="ps.model.Order" column="OrderId"/>
<key-property name="itemNo" type="java.lang.Long">
<column name="ITEM_NO" not-null="true"/>
</key-property>
</composite-id>
<property type="java.lang.String" column="STATUS" name="status" />
<property type="java.lang.Long" column="QTY" name="qty" />

</class>
</hibernate-mapping>

Hi
Try this and the other point is
<key-many-to-one name="OrderId" class="ps.model.Order" column="OrderId"/>

why do have to give it in the composite id?

Its is not necessary.
will your item_no get repeated?





[/b]