hi


here i have a 3 tables, Product, Orders and OrderItems, one to many relation between Product and OrderItems and Order and OrderItems have also a one to many relation, so PK of the orderItem table is consist of PK's of other two tables.
so here i am inserting data into a OrderItem table, data are inserted successfully. and i deleted the one master table(Product) record that is in the OrderItem table record is successfully deleted from the master table and child table,but the problem is related Order record to the Product record in the child table is also deleted from the Order master table

help me to identify the error


here i have attched my mapping hbm.xml files.


order.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
<class name="test.hibernate.data.Order" table="orders">
<id name="id" type="string" unsaved-value="null" >
<column name="id" sql-type="char(32)"
not-null="true"/>
<generator class="uuid.hex"/>
</id>

<property name="onam">
<column name="oname" sql-type="char(32)" not-null="true"/>
</property>

<property name="date">
<column name="order_date" sql-type="date" not-null="true"/>
</property>

<property name="priceTotal">
<column name="price_total" sql-type="double" not-null="true"/>
</property>


<set name="orderItems" table="items" inverse="true" cascade="all" lazy="false" sort="unsorted" batch-size="1" outer-join="auto">
<key column="order_id" />
<one-to-many class="test.hibernate.data.OrderItem" />
</set>



</class>

</hibernate-mapping>


product.hbm.xml


<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

<class name="test.hibernate.data.Product" table="products">

<!-- A 32 hex character is our surrogate key. It's automatically
generated by Hibernate with the UUID pattern. -->
<id name="id" type="string" unsaved-value="null" >
<column name="id" sql-type="char(32)" not-null="true"/>
<generator class="uuid.hex"/>
</id>

<property name="name">
<column name="name" sql-type="char(32)" not-null="true"/>
</property>

<property name="price">
<column name="price" sql-type="double" not-null="true"/>
</property>

<property name="amount">
<column name="amount" sql-type="integer" not-null="true"/>
</property>

<set name="productItems" table="items" inverse="true" cascade="all-delete-orphan" lazy="false" sort="unsorted" batch-size="1" outer-join="auto">
<key column="product_id" />
<one-to-many class="test.hibernate.data.OrderItem" />
</set>

</class>

</hibernate-mapping>


orderitem.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

<class name="test.hibernate.data.OrderItem" table="items">

<!-- A 32 hex character is our surrogate key. It's automatically
generated by Hibernate with the UUID pattern. -->
<id name="id" type="string" unsaved-value="null" >
<column name="id" sql-type="char(32)" not-null="true"/>
<generator class="uuid.hex"/>
</id>

<property name="orderId" insert="false" update="false">
<column name="order_id" sql-type="char(32)" not-null="true"/>
</property>

<property name="productId" insert="false" update="false">
<column name="product_id" sql-type="char(32)" not-null="true"/>
</property>


<property name="amount">
<column name="amount" sql-type="integer" not-null="true"/>
</property>


<property name="price">
<column name="price" sql-type="double" not-null="true"/>
</property>

<many-to-one name="order" class="test.hibernate.data.Order" cascade="all" column="order_id" not-null="true" />
<many-to-one name="product" class="test.hibernate.data.Product" cascade="all" column="product_id" not-null="true" />

</class>

</hibernate-mapping>


thx
gimhan

Hi,

I'm trying out the composite pattern example from the Hibernate site (http://hibernate.org/86.html).

Following errors occured:

1/
Configuring using the defaultCache settings.
java.lang.ClassCastException
at net.sf.hibernate.type.SetType.wrap(SetType.java:24)

2/
ERROR SessionImpl:2368 - Could not synchronize database state with session
net.sf.hibernate.HibernateException: SQL insert, update or delete failed (row not found)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:25)
...
net.sf.hibernate.HibernateException: SQL insert, update or delete failed (row not found)
...


Here is the code I used to test the composite pattern:




Persistent class:



XML mapping as mentioned at the Hibernate site.

Sorry for the last reply, I posted here by mistake.