many-one association

[Akhil Maharaj]

All ,

Book is associated with Publisher by many-one asociation

I am attaching Book.java ,Book.hbm.xml , Publisher.java , Publisher.hbm.xml.

Everything works OK. When I want to delete couple of rows in PUBLISHER , I am getting exception as they are referred in BOOK table.

Can anybody share ideas if I want to delete all the BOOK objects when the associated PUBLISHER is deleted ? ( Some thing like cascade=delete).
it might be obvious for some of you....

********** Publisher.java

   
     public class Publisher {
private Long id;
private String code;
private String name;
private String address;
// Getters and Setters  

public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
 
 

********** Publisher.java ends here

********** Publisher.hbm.xml starts here

 
<hibernate-mapping package="com.gary.tutorial" >
<class name="Publisher" table="PUBLISHER" lazy="false" >
<id name="id" type="long" column="ID" >
<generator class="native" />
</id>

<property name="code" type="string">
<column name="CODE" length="4" not-null="true" unique="true" />
</property>

        <property name="name" type="string">
<column name="PUBLISHER_NAME" length="100" not-null="true" />
</property>

        <property name="address" type="string">
<column name="ADDRESS" length="200" />
</property>

       </class>
</hibernate-mapping>
 

********** Publisher.hbm.xml ends here



************ Book.java starts here

   
public class Book {
private Long id;
private String isbn;
private String name;
private Publisher publisher;
private Date publishDate;
private Integer price;
private Set<Chapter> chapters;

public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}

public String getIsbn() {
return isbn;
}
public void setIsbn(String isbn) {
this.isbn = isbn;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Publisher getPublisher() {
return publisher;
}
public void setPublisher(Publisher publisher) {
this.publisher = publisher;
}
public Date getPublishDate() {
return publishDate;
}
public void setPublishDate(Date publishDate) {
this.publishDate = publishDate;
}
public Integer getPrice() {
return price;
}
public void setPrice(Integer price) {
this.price = price;
}
public Set<Chapter> getChapters() {
return chapters;
}
public void setChapters(Set<Chapter> chapters) {
this.chapters = chapters;
}
 
 

************ Book.java ends here


************ Book.hbm.xml starts here

  
<hibernate-mapping package="com.gary.tutorial">
<class name="Book" table="BOOK">
<id name="id" type="long" column="ID">
<generator class="native"/>
</id>

<property name="isbn" type="string">
<column name="ISBN" length="50" not-null="true" unique="true" />
</property>

<property name="name" type="string">
<column name="BOOK_NAME" length="100" not-null="true" />
</property>
<property name="publishDate" type="date" column="PUBLISH_DATE" />
<property name="price" type="int" column="PRICE" />

<many-to-one name="publisher" class="Publisher" column="PUBLISHER_ID" />

<set name="chapters" table="BOOK_CHAPTER" cascade="save-update,delete,delete-orphan">
<key column="BOOK_ID" />
<many-to-many column="CHAPTER_ID" class="Chapter" unique="true" />
</set>



</class>
</hibernate-mapping>
 

************ Book.hbm.xml ends here

[Kuladip Yadav]

HI Akhil,

You can just add set books into Publisher , like you have added chapters in books.
So add it in your Publisher.java and Publisher.hbm.xml

You will get your required result.
For more information Check This Link

Thanks
- Kuldeep
[ November 11, 2008: Message edited by: Kuldeep Yadav ]

[Deepak Lal]

Hi,
I'm also stuck with the same issue of cascade delete,can you guys tell me how you have modified the hbm.xml and relevant java file.?

--
Deepak Lal