hibernate 级联删除

配置文件和pojo类如下：

 

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.hotel.dao.Movietype" table="movietype" catalog="hotelfidelio">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="native"></generator>
        </id>
        <property name="name" type="java.lang.String">
            <column name="name" length="60" not-null="true" />
        </property>
        <property name="field1" type="java.lang.String">
            <column name="field1" length="20" />
        </property>
        <set name="movies" 
	      table="movie"
	      inverse="true"
	      lazy="false"
	      cascade="all">
	     <key column="id_movietype"></key>
	     <one-to-many class="com.hotel.dao.Movie"/>
	    </set>
    </class>
</hibernate-mapping>

 

 

 

 

 

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.hotel.dao.Movie" table="movie" catalog="hotelfidelio">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="native"></generator>
        </id>
        <property name="moviename" type="java.lang.String">
            <column name="moviename" length="200" not-null="true" />
        </property>
        <property name="movienameSys" type="java.lang.String">
            <column name="moviename_sys" length="300" not-null="true" unique="true" />
        </property>
        <property name="director" type="java.lang.String">
            <column name="director" length="200" />
        </property>
        <property name="impersonator" type="java.lang.String">
            <column name="impersonator" length="200" />
        </property>
        <property name="charge" type="java.lang.Double">
            <column name="charge" precision="22" scale="0" not-null="true" />
        </property>
        <property name="intro" type="java.lang.String">
            <column name="intro" length="16277215" />
        </property>
        <property name="imgsrc" type="java.lang.String">
            <column name="imgsrc" length="300" />
        </property>
        <property name="field1" type="java.lang.String">
            <column name="field1" length="20" />
        </property>
        <property name="field2" type="java.lang.String">
            <column name="field2" length="20" />
        </property>
	<property name="idmovietype" type="java.lang.Integer">
	    <column name="id_movietype" precision="3" scale="0" not-null="true" />
	</property>
	<many-to-one 
	     name="movietype"
	     class="com.hotel.dao.Movietype"
		 column="id_movietype"
		 insert="false"
		 update="false"
	         outer-join="auto"
	   	 fetch="select"
	         access="property"
	         not-null="true"
	         lazy="false"
	     >
	</many-to-one>
    </class>
</hibernate-mapping>

 

 

网上很多帖子都说cascade="all" 就可以级联删除，但是我这里怎么设置都没法成功，观察输出日志

只有  movietype的删除 sql：

 

Hibernate: delete from hotel.movietype where id=? 

 

之后看到 arthur.3726 文章：http://arthur-3726.iteye.com/blog/422877 发现只有用hibernate自带的事物执行语句才能执行级联删除，觉得有可能不是配置文件的问题，而是java代码的问题：

 

Eclipse配置完ssh后，自动生成的代码：

 

 

	public void delete(Movietype persistentInstance) {
		log.debug("deleting Movietype instance");
		try {
			getHibernateTemplate().delete(persistentInstance);
			log.debug("delete successful");
		} catch (RuntimeException re) {
			log.error("delete failed", re);
			throw re;
		}
	}

 

 

改成直接由hibernate的session来执行：

 

 

	public void delete_cascade(final Movietype persistentInstance) {
		log.debug("deleting Movietype instance");
		try {
			getHibernateTemplate().executeFind(new HibernateCallback() {
				public Object doInHibernate(Session s)
						throws HibernateException, SQLException {
					s.setFlushMode(FlushMode.AUTO);
					s.beginTransaction().begin();
					s.delete(persistentInstance);
					s.beginTransaction().commit();
					s.close();
					return null;
				}
			});
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}

 

 测试删除movietype，输出sql语句：

 

Hibernate: delete from hotelfidelio.movie where id=?

Hibernate: delete from hotelfidelio.movietype where id=?

 

删除成功。

 

参考：http://arthur-3726.iteye.com/blog/422877

         http://docs.jboss.org/hibernate/stable/core/reference/en/html_single/#objectstate-transitive

         http://docs.jboss.org/hibernate/stable/core/reference/en/html/objectstate.html#objectstate-transitive

         http://docs.jboss.org/hibernate/stable/core/reference/en/html/example-parentchild.html