Solved

Hibernate delete operation help

Posted on 2014-01-27
7
294 Views
Last Modified: 2014-01-27
Hello there,

I need help to understna dand implement the delete operation in hibernate. I have these two POJO classes
1. SupplierOrder
2. SupplierOrderDetails

and I have these two hbm files which look like this. In the db I have these two tables from my hbm and I have fk from supplierOrder to SupplierOrderDetails table

<hibernate-mapping>
	<class name="com.kaizen.erp.shared.entities.SupplierOrder" table="supplierOrder">
		<id name="id" type="java.lang.Long">
			<column name="ID" />
			<generator class="identity" />
		</id>
		<many-to-one name="section" class="com.kaizen.erp.shared.entities.Section"
			fetch="select">
			<column name="sectionID" />
		</many-to-one>

		<many-to-one name="supplier"
			class="com.kaizen.erp.shared.entities.Supplier" fetch="select">
			<column name="supplierID" />
		</many-to-one>

		<property name="supplierOrderNo" type="string">
			<column name="supplierOrderNo" />
		</property>
		
		<property name="supplierOrderCreated" type="java.util.Date">
			<column name="supplierOrderCreated" />
		</property>
	</class>
</hibernate-mapping>

Open in new window



<hibernate-mapping>
    <class name="com.kaizen.erp.shared.entities.SupplierOrderDetails" table="supplierOrderDetails">
        <id name="id" type="java.lang.Long">
            <column name="id" />
            <generator class="identity" />
        </id>
        <many-to-one name="supplierOrderID" class="com.kaizen.erp.shared.entities.SupplierOrder" fetch="select">
            <column name="supplierOrderID" />
        </many-to-one>
        <many-to-one name="productID" class="com.kaizen.erp.shared.entities.Product" fetch="select">
            <column name="productID" />
        </many-to-one>
        <property name="orderPoint" type="java.lang.Integer">
            <column name="orderPoint" />
        </property>
        <property name="stockCount" type="java.lang.Integer">
            <column name="stockCount" />
        </property>
        <property name="lastMonthSales" type="java.lang.Integer">
            <column name="lastMonthSales" />
        </property>
        <property name="avgMonthlySales" type="java.lang.Integer">
            <column name="avgMonthlySales" />
        </property>
        <property name="avgMonthlySales_stock" type="java.lang.Integer">
            <column name="avgMonthlySales_stock" />
        </property>
         <property name="orderQty" type="java.lang.Integer">
            <column name="orderQty" />
        </property>
	</class>
</hibernate-mapping>

Open in new window


now I want to implement delete operation so that when I delete a supplierorder record it should also delete its related supplierorderdetail from the db. I am new to hibernate and need how to do it and explanation for it.
0
Comment
Question by:zolf
  • 4
  • 3
7 Comments
 
LVL 20

Expert Comment

by:chaitu chaitu
ID: 39811387
you can do that using cascase option in hbm file.check this link.

http://www.mkyong.com/hibernate/hibernate-cascade-example-save-update-delete-and-delete-orphan/
0
 

Author Comment

by:zolf
ID: 39811398
thanks for your comments.

can you please show me the code how it will look in my case
0
 
LVL 20

Expert Comment

by:chaitu chaitu
ID: 39811408
<hibernate-mapping>
	<class name="com.kaizen.erp.shared.entities.SupplierOrder" table="supplierOrder">
		<id name="id" type="java.lang.Long">
			<column name="ID" />
			<generator class="identity" />
		</id>
		<many-to-one name="section" class="com.kaizen.erp.shared.entities.Section"
			fetch="select">
			<column name="sectionID" />
		</many-to-one>

		<many-to-one name="supplier"
			class="com.kaizen.erp.shared.entities.Supplier" fetch="select">
			<column name="supplierID" />
		</many-to-one>

		<property name="supplierOrderNo" type="string">
			<column name="supplierOrderNo" />
		</property>
		
		<property name="supplierOrderCreated" type="java.util.Date">
			<column name="supplierOrderCreated" />
		</property>

<set name="supplierOrderDetails" cascade="delete-orphan" table="supplierOrderDetails" >
      <key>
            <column name="supplierOrderID" not-null="true" />
      </key>
      <one-to-many class="com.kaizen.erp.shared.entities.SupplierOrderDetails" />
</set>
	</class>
</hibernate-mapping>

Open in new window

0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:zolf
ID: 39811422
is that all I need to do in my code to be able to use delete cascade. I mean when I del a SupplierOrder record it will delete its linked SupplierOrderDetails
0
 
LVL 20

Expert Comment

by:chaitu chaitu
ID: 39811442
yes.see the code written in the above link.
0
 

Author Comment

by:zolf
ID: 39811455
<set name="supplierOrderDetails" cascade="delete" table="supplierOrderDetails" >

this set name can be any name or it should match the variable name in the SupplierOrder POJO classes

private Set<SupplierOrderDetails> sod = new HashSet<SupplierOrderDetails>(0);
0
 
LVL 20

Accepted Solution

by:
chaitu chaitu earned 500 total points
ID: 39811580
it should match the variable name in the SupplierOrder POJO
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now