hibernat creating the tables without cascade

[taylor kiani]

hii guys,
i'm using hibernate annotations in my project,
I've created the tables and it's all good except that when i check the database their's no cascade even tho I've made sure to put it in the classes.
here is an exemple of how i do it :

@Entity
@Table(name = "item")
public class Item implements java.io.Serializable {
 
    /**
     *
     */
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "IDitem", unique = true, nullable = false)
    private int iditem;
    @ManyToOne(fetch = FetchType.EAGER, cascade = CascadeType.ALL)
    @JoinColumn(name = "IDDIVISION", nullable = false)
    private Division division;
    @Column(name = "SIGLE", length = 254)
    private String sigleItem;
    @Column(name = "DESCRIPTION", length = 254)
    private String description;
    ...

i'm using mysql database, here's the hibernate.cfg.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
                                         "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
	<session-factory name="session1">
		<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/dac_bd4</property>
		<property name="hibernate.connection.username">root</property>
		<property name="hibernate.connection.password"></property>
		<property name="current_session_context_class">thread</property>
		<property name="hibernate.show_sql">true</property>
		<!-- JDBC connection pool (use the built-in) -->
		<property name="connection.pool_size">1</property>
		<!--Disable the second-level cache -->
		<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
		<property name="hibernate.cache.use_second_level_cache">false </property>
		<property name="hibernate.cache.use_query_cache">true</property>
		<property name="hibernate.cache.use_structured_cache">true</property>
		<property name="hibernate.cache.use_minimal_puts">true</property>
 
		<property name="hibernate.hbm2ddl.auto">create</property>
	</session-factory>
</hibernate-configuration>

and the application-context.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
 
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName">
			<value>com.mysql.jdbc.Driver</value>
		</property>
		<property name="url">
			<value>jdbc:mysql://localhost:3306/dac_bd4</value>
		</property>
		<property name="username">
			<value>root</value>
		</property>
	</bean>
	<bean id="SessionFactory"
		class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="annotatedClasses">
			<list>
				<value>Dac.Entity.Division</value>
				<value>Dac.Entity.Historique</value>
				<value>Dac.Entity.Item</value>
				<value>Dac.Entity.Role</value>
				<value>Dac.Entity.Utilisateur</value>
				<value>Dac.Entity.Habilitation</value>
				<value>Dac.Entity.Statu</value>
				<value>Dac.Entity.Audit</value>
				<value>Dac.Entity.Question</value>
				<value>Dac.Entity.Questionnaire</value>
				<value>Dac.Entity.Referencereglementaire</value>
				<value>Dac.Entity.Reponse</value>
				<value>Dac.Entity.Theme</value>
				<value>Dac.Entity.OrganismeAudite</value>
				<value>Dac.Entity.RefQuest</value>
				<value>Dac.Entity.Ecarts</value>
				<value>Dac.Entity.NiveauEcart</value>
				<value>Dac.Entity.Personnerencontree</value>
 
 
			</list>
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<prop key="hibernate.hbm2ddl.auto">create</prop>
				<prop key="hibernate.cache.use_query_cache">false</prop>
				<prop key="hibernate.cache.use_second_level_cache">false</prop>
 
			</props>
		</property>
 
	</bean>
	<bean id="transactionManager"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory" ref="SessionFactory" />
	</bean>
 
	<tx:annotation-driven transaction-manager="transactionManager" />
	<context:annotation-config />
	<context:component-scan base-package="Dac" />
 
</beans>

what am i doing wrong ?
thank you!

[James Boswell]

except that when i check the database their's no cascade

Not a very helpful description of the problem. Perhaps you could explain what behaviour you are expecting and what actually happens using a simple example. It may also be useful to see your EntityManager code.

[William P O'Sullivan]

I think what he means is that when he examines the database table, there is no ON CASCADE defined as a constraint.

It would be helpful to see the full DDL though.

WP

[taylor kiani]

yes it is like William P O'Sullivan said there is no ON CASCADE defined as a constraint.
here's the DDL:

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Ven 17 Août 2012 à 20:26
-- Version du serveur: 5.5.8
-- Version de PHP: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de données: `dac_bd4`
--

-- --------------------------------------------------------

--
-- Structure de la table `audit`
--

CREATE TABLE IF NOT EXISTS `audit` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `etatRapport` varchar(255) DEFAULT NULL,
  `PMC_doc` varchar(255) DEFAULT NULL,
  `date` varchar(254) DEFAULT NULL,
  `IDUTILISATEUR` int(11) DEFAULT NULL,
  `Aud_id` int(11) NOT NULL,
  `Sta_id` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `Id` (`Id`),
  KEY `FK58D9BDBEAA017F8` (`Sta_id`),
  KEY `FK58D9BDB2825FD08` (`IDUTILISATEUR`),
  KEY `FK58D9BDB472A4024` (`Aud_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Structure de la table `division`
--

CREATE TABLE IF NOT EXISTS `division` (
  `IDDIVISION` int(11) NOT NULL AUTO_INCREMENT,
  `SIGLE` varchar(254) DEFAULT NULL,
  `DESCRIPTION` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`IDDIVISION`),
  UNIQUE KEY `IDDIVISION` (`IDDIVISION`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;


--
-- Structure de la table `ecarts`
--

CREATE TABLE IF NOT EXISTS `ecarts` (
  `idecarts` int(11) NOT NULL AUTO_INCREMENT,
  `Constatation` varchar(255) DEFAULT NULL,
  `ActionAeroport` varchar(255) DEFAULT NULL,
  `echanceAeroport` varchar(255) DEFAULT NULL,
  `responsableAeroport` varchar(255) DEFAULT NULL,
  `MesureAeroport` varchar(255) DEFAULT NULL,
  `commentaireDac` varchar(255) DEFAULT NULL,
  `niveauEcart_idniveau_ecart` int(11) DEFAULT NULL,
  `Audit_ecart_Id` int(11) DEFAULT NULL,
  PRIMARY KEY (`idecarts`),
  KEY `FKB1FA600E9C818211` (`Audit_ecart_Id`),
  KEY `FKB1FA600E763FDA9B` (`niveauEcart_idniveau_ecart`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;



-- --------------------------------------------------------

--
-- Structure de la table `habilitation`
--

CREATE TABLE IF NOT EXISTS `habilitation` (
  `IDUTILISATEUR` int(11) NOT NULL,
  `IDitem` int(11) NOT NULL,
  `TYPEHABILITATION` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`IDUTILISATEUR`,`IDitem`),
  KEY `FK2FEE5DBE2825FD08` (`IDUTILISATEUR`),
  KEY `FK2FEE5DBE77D13E64` (`IDitem`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


-- --------------------------------------------------------

--
-- Structure de la table `historique`
--

CREATE TABLE IF NOT EXISTS `historique` (
  `IdHistorique` int(11) NOT NULL AUTO_INCREMENT,
  `action` varchar(254) NOT NULL,
  `date` date NOT NULL,
  `IDUTILISATEUR` int(11) NOT NULL,
  PRIMARY KEY (`IdHistorique`),
  UNIQUE KEY `IdHistorique` (`IdHistorique`),
  KEY `FK744353BD2825FD08` (`IDUTILISATEUR`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `historique`
--


-- --------------------------------------------------------

--
-- Structure de la table `item`
--

CREATE TABLE IF NOT EXISTS `item` (
  `IDitem` int(11) NOT NULL AUTO_INCREMENT,
  `SIGLE` varchar(254) DEFAULT NULL,
  `DESCRIPTION` varchar(254) DEFAULT NULL,
  `IDDIVISION` int(11) NOT NULL,
  PRIMARY KEY (`IDitem`),
  UNIQUE KEY `IDitem` (`IDitem`),
  KEY `FK317B1335EE5A98` (`IDDIVISION`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;


-- --------------------------------------------------------

--
-- Structure de la table `niveau_ecart`
--

CREATE TABLE IF NOT EXISTS `niveau_ecart` (
  `idniveau_ecart` int(11) NOT NULL AUTO_INCREMENT,
  `niveau` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idniveau_ecart`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;



-- --------------------------------------------------------

--
-- Structure de la table `organisme_audite`
--

CREATE TABLE IF NOT EXISTS `organisme_audite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(254) DEFAULT NULL,
  `ville` varchar(250) DEFAULT NULL,
  `code` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;



-- --------------------------------------------------------

--
-- Structure de la table `participants_audit`
--

CREATE TABLE IF NOT EXISTS `participants_audit` (
  `Id` int(11) NOT NULL,
  `IDUTILISATEUR` int(11) NOT NULL,
  PRIMARY KEY (`Id`,`IDUTILISATEUR`),
  KEY `FK173D7A9C1ED57CB3` (`Id`),
  KEY `FK173D7A9C2825FD08` (`IDUTILISATEUR`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


-- --------------------------------------------------------

--
-- Structure de la table `personnerencontree`
--

CREATE TABLE IF NOT EXISTS `personnerencontree` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) DEFAULT NULL,
  `prenom` varchar(255) DEFAULT NULL,
  `Tel` varchar(255) NOT NULL,
  `Audit_personne_Id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK3E90AFF15A441FA2` (`Audit_personne_Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;



-- --------------------------------------------------------

--
-- Structure de la table `question`
--

CREATE TABLE IF NOT EXISTS `question` (
  `idQuestion` int(11) NOT NULL AUTO_INCREMENT,
  `text` varchar(254) DEFAULT NULL,
  `commentaire` varchar(254) DEFAULT NULL,
  `them_id` int(11) DEFAULT NULL,
  `ec_idecarts` int(11) DEFAULT NULL,
  PRIMARY KEY (`idQuestion`),
  UNIQUE KEY `idQuestion` (`idQuestion`),
  KEY `FKBA823BE6F4F8675B` (`ec_idecarts`),
  KEY `FKBA823BE6CF6867A4` (`them_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;


-- --------------------------------------------------------

--
-- Structure de la table `questionnaire`
--

CREATE TABLE IF NOT EXISTS `questionnaire` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `IDitem` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `FKC3610DA377D13E64` (`IDitem`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;


-- --------------------------------------------------------

--
-- Structure de la table `quest_ecarts`
--

CREATE TABLE IF NOT EXISTS `quest_ecarts` (
  `idecarts` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`idecarts`,`id`),
  KEY `FKDCE5362BA81B8024` (`id`),
  KEY `FKDCE5362BB8F1F0DA` (`idecarts`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


-- --------------------------------------------------------

--
-- Structure de la table `referencereglementaire`
--

CREATE TABLE IF NOT EXISTS `referencereglementaire` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nomDoc` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;



-- --------------------------------------------------------

--
-- Structure de la table `refquest`
--

CREATE TABLE IF NOT EXISTS `refquest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `numpage` varchar(255) DEFAULT NULL,
  `question_idQuestion` int(11) DEFAULT NULL,
  `referencereglementaire_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKD598C42F3BC2DBD` (`referencereglementaire_id`),
  KEY `FKD598C42F9B4C3F03` (`question_idQuestion`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;


-- --------------------------------------------------------

--
-- Structure de la table `reponse`
--

CREATE TABLE IF NOT EXISTS `reponse` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rep` varchar(255) DEFAULT NULL,
  `commentaire` varchar(255) DEFAULT NULL,
  `audit_Id` int(11) NOT NULL,
  `q1_idQuestion` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK413E428E812D4CC9` (`q1_idQuestion`),
  KEY `FK413E428E5902F397` (`audit_Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=230 ;


--
-- Structure de la table `role`
--

CREATE TABLE IF NOT EXISTS `role` (
  `IDROLE` int(11) NOT NULL AUTO_INCREMENT,
  `NOMROLE` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`IDROLE`),
  UNIQUE KEY `IDROLE` (`IDROLE`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;


-- --------------------------------------------------------

--
-- Structure de la table `statu`
--

CREATE TABLE IF NOT EXISTS `statu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;


-- --------------------------------------------------------

--
-- Structure de la table `theme`
--

CREATE TABLE IF NOT EXISTS `theme` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(254) DEFAULT NULL,
  `questionnaire_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `FK69375C9FEDF3197` (`questionnaire_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;



-- --------------------------------------------------------

--
-- Structure de la table `utilisateur`
--

CREATE TABLE IF NOT EXISTS `utilisateur` (
  `IDUTILISATEUR` int(11) NOT NULL AUTO_INCREMENT,
  `NOM` varchar(254) DEFAULT NULL,
  `PRENOM` varchar(254) DEFAULT NULL,
  `STATUT` varchar(254) DEFAULT NULL,
  `MAIL` varchar(254) DEFAULT NULL,
  `LOGIN` varchar(254) DEFAULT NULL,
  `PASSWORD` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`IDUTILISATEUR`),
  UNIQUE KEY `IDUTILISATEUR` (`IDUTILISATEUR`),
  UNIQUE KEY `MAIL` (`MAIL`),
  UNIQUE KEY `LOGIN` (`LOGIN`),
  UNIQUE KEY `LOGIN_2` (`LOGIN`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;


-- --------------------------------------------------------

--
-- Structure de la table `utilisateur_role`
--

CREATE TABLE IF NOT EXISTS `utilisateur_role` (
  `utilisateur_IDUTILISATEUR` int(11) NOT NULL,
  `roles_IDROLE` int(11) NOT NULL,
  KEY `FKCCCCBFB2E97C214C` (`utilisateur_IDUTILISATEUR`),
  KEY `FKCCCCBFB24DB118EC` (`roles_IDROLE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Contraintes pour les tables exportées
--

--
-- Contraintes pour la table `audit`
--
ALTER TABLE `audit`
  ADD CONSTRAINT `FK58D9BDB2825FD08` FOREIGN KEY (`IDUTILISATEUR`) REFERENCES `utilisateur` (`IDUTILISATEUR`),
  ADD CONSTRAINT `FK58D9BDB472A4024` FOREIGN KEY (`Aud_id`) REFERENCES `organisme_audite` (`id`),
  ADD CONSTRAINT `FK58D9BDBEAA017F8` FOREIGN KEY (`Sta_id`) REFERENCES `statu` (`id`);

--
-- Contraintes pour la table `ecarts`
--
ALTER TABLE `ecarts`
  ADD CONSTRAINT `FKB1FA600E763FDA9B` FOREIGN KEY (`niveauEcart_idniveau_ecart`) REFERENCES `niveau_ecart` (`idniveau_ecart`),
  ADD CONSTRAINT `FKB1FA600E9C818211` FOREIGN KEY (`Audit_ecart_Id`) REFERENCES `audit` (`Id`);

--
-- Contraintes pour la table `habilitation`
--
ALTER TABLE `habilitation`
  ADD CONSTRAINT `FK2FEE5DBE2825FD08` FOREIGN KEY (`IDUTILISATEUR`) REFERENCES `utilisateur` (`IDUTILISATEUR`),
  ADD CONSTRAINT `FK2FEE5DBE77D13E64` FOREIGN KEY (`IDitem`) REFERENCES `item` (`IDitem`);

--
-- Contraintes pour la table `historique`
--
ALTER TABLE `historique`
  ADD CONSTRAINT `FK744353BD2825FD08` FOREIGN KEY (`IDUTILISATEUR`) REFERENCES `utilisateur` (`IDUTILISATEUR`);

--
-- Contraintes pour la table `item`
--
ALTER TABLE `item`
  ADD CONSTRAINT `FK317B1335EE5A98` FOREIGN KEY (`IDDIVISION`) REFERENCES `division` (`IDDIVISION`);

--
-- Contraintes pour la table `participants_audit`
--
ALTER TABLE `participants_audit`
  ADD CONSTRAINT `FK173D7A9C1ED57CB3` FOREIGN KEY (`Id`) REFERENCES `audit` (`Id`),
  ADD CONSTRAINT `FK173D7A9C2825FD08` FOREIGN KEY (`IDUTILISATEUR`) REFERENCES `utilisateur` (`IDUTILISATEUR`);

--
-- Contraintes pour la table `personnerencontree`
--
ALTER TABLE `personnerencontree`
  ADD CONSTRAINT `FK3E90AFF15A441FA2` FOREIGN KEY (`Audit_personne_Id`) REFERENCES `audit` (`Id`);

--
-- Contraintes pour la table `question`
--
ALTER TABLE `question`
  ADD CONSTRAINT `FKBA823BE6CF6867A4` FOREIGN KEY (`them_id`) REFERENCES `theme` (`id`),
  ADD CONSTRAINT `FKBA823BE6F4F8675B` FOREIGN KEY (`ec_idecarts`) REFERENCES `ecarts` (`idecarts`);

--
-- Contraintes pour la table `questionnaire`
--
ALTER TABLE `questionnaire`
  ADD CONSTRAINT `FKC3610DA377D13E64` FOREIGN KEY (`IDitem`) REFERENCES `item` (`IDitem`);

--
-- Contraintes pour la table `quest_ecarts`
--
ALTER TABLE `quest_ecarts`
  ADD CONSTRAINT `FKDCE5362BA81B8024` FOREIGN KEY (`id`) REFERENCES `question` (`idQuestion`),
  ADD CONSTRAINT `FKDCE5362BB8F1F0DA` FOREIGN KEY (`idecarts`) REFERENCES `ecarts` (`idecarts`);

--
-- Contraintes pour la table `refquest`
--
ALTER TABLE `refquest`
  ADD CONSTRAINT `FKD598C42F3BC2DBD` FOREIGN KEY (`referencereglementaire_id`) REFERENCES `referencereglementaire` (`id`),
  ADD CONSTRAINT `FKD598C42F9B4C3F03` FOREIGN KEY (`question_idQuestion`) REFERENCES `question` (`idQuestion`);

--
-- Contraintes pour la table `reponse`
--
ALTER TABLE `reponse`
  ADD CONSTRAINT `FK413E428E5902F397` FOREIGN KEY (`audit_Id`) REFERENCES `audit` (`Id`),
  ADD CONSTRAINT `FK413E428E812D4CC9` FOREIGN KEY (`q1_idQuestion`) REFERENCES `question` (`idQuestion`);

--
-- Contraintes pour la table `theme`
--
ALTER TABLE `theme`
  ADD CONSTRAINT `FK69375C9FEDF3197` FOREIGN KEY (`questionnaire_id`) REFERENCES `questionnaire` (`id`);

--
-- Contraintes pour la table `utilisateur_role`
--
ALTER TABLE `utilisateur_role`
  ADD CONSTRAINT `FKCCCCBFB24DB118EC` FOREIGN KEY (`roles_IDROLE`) REFERENCES `role` (`IDROLE`),
  ADD CONSTRAINT `FKCCCCBFB2E97C214C` FOREIGN KEY (`utilisateur_IDUTILISATEUR`) REFERENCES `utilisateur` (`IDUTILISATEUR`);

like i said i only gave one examble of the entity, because i use the same logic in them all so their is no point of repeating.

[Bill Gorder]

Some of the attributes are used only for schema generation like your @Column(length = xxx) . Cascade is not one of those attributes. This is not used for schema generation, rather it defines how operations are propagated to the associated entity. This is different than adding a cascade on delete option on a database ddl. For example there is a CascadeType.PERSIST which clearly has no equivalent in a database schema.

[taylor kiani]

okey so what attributes should i add to get the cascad option.
i forgot to add that i already tried
@OnDelete(action = OnDeleteAction.CASCADE)
and
@Cascade(org.hibernate.annotations.CascadeType.DELETE_ORPHAN)

[Bill Gorder]

I generally don't generate the ddl so I have not really had this issue, but It looks like @OnDelete should work for this, make sure it is on the parent entity, you can try explicitly defining the FK with @ForeignKey as well.

Here is a blog on it:
http://deprecatedconsciousness.wordpress.com/2009/11/25/cascade-delete-foreign-keys-using-hibernate-hbm2ddl/

I would probably become familiar with what that annotation does as well. Read here for that:
http://eddii.wordpress.com/2006/11/16/hibernate-on-deletecascade-performance/

[taylor kiani]

:s still no cascade but thank you for the links, learned a couple of new things .
i think i might do this manually (delete the parent befor the child object) their's so much changes that happen so the database should be possible to generate from the classes.

[Bill Gorder]

Using the cascade annotations are still beneficial. Not sure what you meant by do it all manually.

Just to throw a shallow example out there say I have a Person entity and an Address Entity. Say the Person has an Address.

One possible mapping might look something like this

@Entity
public class Person {
    @Id
    private int id;
    private String name;
    
    @ManyToOne(cascade=CascadeType.PERSIST)
    Address address;

}

Now without the CascadeType.PERSIST I would have to save the address before saving the person. Now I can just create the person set a new address on it and save the person. This will automatically save the address first for me, avoiding the need to call save on each of the objects. Of course there are the others you were talking about to:

CascadeType.REMOVE, Orphan remval and OnDelete. Even if it does not go in your ddl it can save you a lot of work in your code if you can call persist or delete and hibernate will take care of issuing the correct sql to persist or remove the associated entities.

Good Luck,

[taylor kiani]

but doesn't cascade = CascadeType.ALL cover them all (persist, remove ...). the reason why i'm cheking the DDL is because when i delete the adresse in your example (knowing that it's attached to a person)
I will end up with an foreing key error : Cannot delete or update a parent row: a foreign key constraint fails (`dac_bd4`.`item`, CONSTRAINT `FK317B1335EE5A98` FOREIGN KEY (`IDDIVISION`) REFERENCES `division` (`IDDIVISION`))

here is the entire error log:

Cannot delete or update a parent row: a foreign key constraint fails (`dac_bd4`.`item`, CONSTRAINT `FK317B1335EE5A98` FOREIGN KEY (`IDDIVISION`) REFERENCES `division` (`IDDIVISION`))
août 20, 2012 12:37:48 PM org.hibernate.event.def.AbstractFlushingEventListener performExecutions
Grave: Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
	at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at $Proxy32.supprimer(Unknown Source)
	at Dac.View.DivisionBean.delete(DivisionBean.java:209)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.el.parser.AstValue.invoke(AstValue.java:264)
	at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
	at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
	at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
	at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
	at javax.faces.component.UICommand.broadcast(UICommand.java:315)
	at javax.faces.component.UIData.broadcast(UIData.java:1093)
	at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
	at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
	at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
	at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.BatchUpdateException: 
Cannot delete or update a parent row: a foreign key constraint fails (`dac_bd4`.`item`, CONSTRAINT `FK317B1335EE5A98` FOREIGN KEY (`IDDIVISION`) REFERENCES `division` (`IDDIVISION`))
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2024)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
	... 52 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Cannot delete or update a parent row: a foreign key constraint fails (`dac_bd4`.`item`, CONSTRAINT `FK317B1335EE5A98` FOREIGN KEY (`IDDIVISION`) REFERENCES `division` (`IDDIVISION`))
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
	at com.mysql.jdbc.Util.getInstance(Util.java:382)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1976)
	... 56 more

août 20, 2012 12:37:48 PM com.sun.faces.lifecycle.InvokeApplicationPhase execute
Avertissement: #{DivisionBean.delete}: org.springframework.dao.DataIntegrityViolationException:
 Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException:
 Could not execute JDBC batch update
javax.faces.FacesException: #{DivisionBean.delete}: org.springframework.dao.DataIntegrityViolationException: 
Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118)
	at javax.faces.component.UICommand.broadcast(UICommand.java:315)
	at javax.faces.component.UIData.broadcast(UIData.java:1093)
	at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
	at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
	at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
	at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: javax.faces.el.EvaluationException: org.springframework.dao.DataIntegrityViolationException
: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
	at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
	... 27 more
Caused by: org.springframework.dao.DataIntegrityViolationException:
 Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:636)
	at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:789)
	at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at $Proxy32.supprimer(Unknown Source)
	at Dac.View.DivisionBean.delete(DivisionBean.java:209)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.el.parser.AstValue.invoke(AstValue.java:264)
	at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
	at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
	at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
	... 28 more
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
	at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)
	... 44 more
Caused by: java.sql.BatchUpdateException: 
Cannot delete or update a parent row: a foreign key constraint fails (`dac_bd4`.`item`, CONSTRAINT `FK317B1335EE5A98` FOREIGN KEY (`IDDIVISION`) REFERENCES `division` (`IDDIVISION`))
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2024)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
	... 52 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Cannot delete or update a parent row: a foreign key constraint fails (`dac_bd4`.`item`, CONSTRAINT `FK317B1335EE5A98` FOREIGN KEY (`IDDIVISION`) REFERENCES `division` (`IDDIVISION`))
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
	at com.mysql.jdbc.Util.getInstance(Util.java:382)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1976)
	... 56 more

when i said i'll do it manually i mean befor deleting the adresse i'm going to delete every person that has that adresse then delete the adresse (i realise it's not the best way to do it :s ... ).
thank you for your time!

Edit - Removed long lines to prevent horizontal scrolling

[James Boswell]

If your cascade works correctly, you won't need to delete the address after deleting the person. The first delete should delete both entities. This is assuming no other person is linked to the address.

[taylor kiani]

that precisely the probleme, cascade is not working and i can't figure out why!

[James Boswell]

Hang on, I now realise your problem.

You are trying to delete an Item which has a ManyToOne relationship with a Division - meaning more than one Item can refer to the same Division. On this relation, you have also defined a Cascade type of ALL. The error you are getting is because another Item (or multiple Items) refers to the Division you are trying to delete - via the cascade when deleting an Item.

Either your relation is incorrect or you need to change your cascade type.

[taylor kiani]

actualy a get the error when i try to delete the division and yes many item can refere to the same division so when i try to delete a division all the items atached to it are deleted as well.
change my cascade type to what exactly? like i'v said i alredy tried a few and no luck.
excuse my questions, this is my first time with an ORM

[James Boswell]

Ok, can you post the code for the Division class? Specifically, how is the relation to an Item defined in this class.

[taylor kiani]

okey her's the code for the class division:

@Entity
@Table(name = "division")
public class Division implements java.io.Serializable {

	private static final long serialVersionUID = 4067259098460814936L;
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "IDDIVISION", unique = true, nullable = false)
    private int iddivision;
    @Column(name = "SIGLE", length = 254)
    private String sigle;
    @Column(name = "DESCRIPTION", length = 254)
    private String description;
     //... getters and setters

the class item again:

@Entity
@Table(name = "item")
public class Item implements java.io.Serializable {

    /**
     *
     */
    private static final long serialVersionUID = 8271695210797279161L;
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "IDitem", unique = true, nullable = false)
    private int iditem;
    @ManyToOne(fetch = FetchType.EAGER, cascade = CascadeType.ALL)
    @OnDelete(action = OnDeleteAction.CASCADE)
    @ForeignKey(name = "FK317B1335EE5A98")
    @JoinColumn(name = "IDDIVISION", nullable = false)
    private Division division;
    @Column(name = "SIGLE", length = 254)
    private String sigleItem;
    @Column(name = "DESCRIPTION", length = 254)
    private String description;

and finaly a division can contain 0 or many items. voila

[James Boswell]

Ok, so you have no cascade defined in Division for Item. This explains why when you attempt to delete a Division, no cascade occurs but the error is raised because one or more Items refers to the Division you are attempting to delete. You cannot expect anything to happen to your Items when you delete a Division unless you define it as such in the Division class.

I believe the only way to do this is to apply a OneToMany relation in Division for Item with a cascade type of ALL and DELETE_ORPHAN.

[Bill Gorder]

but doesn't cascade = CascadeType.ALL cover them all

It does not include orphan removal that is different.

Ill be honest I typically use JPA with hibernate as the persistence provider thusly I only use the cascade options from that javax.persistence package only.

You need to be careful with REMOVE

The cascade REMOVE operation really only makes sense on one-to-one and one-to-many relationships where there is a clear parent-child relationship. What I mean by that is even if it is a one-to-one or a one-to-many if the target is participating in other relationships or can stand alone it probably does not make sense to use REMOVE.

That said consider the following.. (Note that if the owning side is safe for REMOVE it is probably also safe to use PERSIST however the inverse is NOT necessarily true)

@Entity
public class Employee {

    @OneToOne(cascade={CascadeType.PERSIST, CascadeType.REMOVE})
    Cubicle cubicle;
}

This will remove the Employee and his cubicle. Cascade.REMOVE can only safely be cascaded from parent to child. Trying to remove the Cubicle directly will result in an integrity constraint violation unless I first set reference to the Cubicle in the employee object to null. Setting the REMOVE cascade option on the @OneToOne annotation in the Cubicle object would not cause it to be removed from the Employee rather it would have the undesirable affect of removing the employee. As you know removing a cubicle should not remove the employee.

Hope this clears things up for you.

[taylor kiani]

okey so i'm back, i tried to apply a OneToMany relation in Division for Item like james said but it didn't change anything i'm still getting that Cannot delete or update a parent row error, i alse made sur i have the CascadeType.Persist
here is how it looks now

@Entity
@Table(name = "item")
public class Item implements java.io.Serializable {

    /**
     *
     */
    private static final long serialVersionUID = 8271695210797279161L;
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "IDitem", unique = true, nullable = false)
    private int iditem;
    @ManyToOne(fetch = FetchType.EAGER, cascade = {CascadeType.ALL,CascadeType.REMOVE,CascadeType.PERSIST})
    @OnDelete(action = OnDeleteAction.CASCADE)
    @ForeignKey(name = "fitemdiv")
    @JoinColumn(name = "IDDIVISION", nullable = false)
    private Division division;
    @Column(name = "SIGLE", length = 254)
    private String sigleItem;
    @Column(name = "DESCRIPTION", length = 254)
    private String description;

and division:

@Entity
@Table(name = "division")
public class Division implements java.io.Serializable {

    /**
	 * 
	 */
	private static final long serialVersionUID = 4067259098460814936L;
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "IDDIVISION", unique = true, nullable = false)
    private int iddivision;
    @Column(name = "SIGLE", length = 254)
    private String sigle;
    @Column(name = "DESCRIPTION", length = 254)
    private String description;
    @OneToMany(cascade = {CascadeType.ALL,CascadeType.REMOVE,CascadeType.PERSIST}, fetch = FetchType.EAGER,mappedBy = "division") 
    @OnDelete(action = OnDeleteAction.CASCADE)
    private Set<Item> items = new HashSet<Item>(0);    

[James Boswell]

Probably best to keep it simple for now. Remove all cascade-related annotations in the Item class and only have CascadeType.ALL in Division class. Also remove OnDelete annotation.

[Bill Gorder]

OK I am not sure if you just did not read my last post or if you did not understand it.

As James said lets simplify this and keep it just about Cascade.REMOVE for moment.

Say you have this in your Division (Note that having both CascadeType.ALL and cascadeType.REMOVE is redundant)

    @ManyToOne(fetch = FetchType.EAGER, cascade = {CascadeType.REMOVE,CascadeType.PERSIST})  
    @JoinColumn(name = "IDDIVISION", nullable = false)  
    private Division division; 

Now like you example lets have this for Item

    @OneToMany(cascade = {CascadeType.REMOVE,CascadeType.PERSIST}, fetch = FetchType.EAGER,mappedBy = "division")   
    private Set<Item> items = new HashSet<Item>(); 

Now lets take a look at a simple example.

		Division division = new Division("sigle1", "description1");

		Item item1 = new Item(division, "sigleItem1", "sigleItemDescription1");
		Item item2 = new Item(division, "sigleItem2", "sigleItemDescription2");
		Item item3 = new Item(division, "sigleItem3", "sigleItemDescription3");

		division.getItems().add(item1);
		division.getItems().add(item2);
		division.getItems().add(item3);
		// will insert one row in division and 3 rows into Item
		entityManager.persist(division);
		entityManager.flush();

		/*
		 * will delete all 3 rows from Item and then will delete 1 row from
		 * division. This only works because of the CascadeType.REMOVE on the
		 * 
		 * @OneToMany note the REMOVE is NOT needed on the @ManyToOne for this
		 * behavior.
		 */

		entityManager.remove(division);
		entityManager.flush();

Ok so far so good. Now lets try to delete an Item. This is where I think you ignored my last post

		Division division = new Division("sigle1", "description1");

		Item item1 = new Item(division, "sigleItem1", "sigleItemDescription1");
		Item item2 = new Item(division, "sigleItem2", "sigleItemDescription2");
		Item item3 = new Item(division, "sigleItem3", "sigleItemDescription3");

		division.getItems().add(item1);
		division.getItems().add(item2);
		division.getItems().add(item3);
		// will insert one row in division and 3 rows into Item
		entityManager.persist(division);
		entityManager.flush();

		/*
		 * will delete all 3 rows from Item and then will delete 1 row from
		 * division. Wait a minute this is probably NOT what I want. That is why
		 * I said in my last post that Cascade.REMOVE does NOT make sense on the
		 * 
		 * @ManyToOne side. Cascade.REMOVE can only safely be cascaded from
		 * parent to child. Now lets remove the CASCADE.ALL and CASCADE.REMOVE
		 * (note that it is redundant to have both of these) form the @ManyToOne
		 * and try again.. What happens? You will get an Exception. There is no
		 * setting in JPA that can be applied to a relationship from one entity
		 * to another that will cause it to be removed from a parent see the
		 * next case for the proper way to handle this.
		 */

		entityManager.remove(item1);
		entityManager.flush();

Ok so to summarize. Running this with the Cascade.REMOVE on the @ManyToOne has the undesirable effect of deleting all the items and the division!! Taking the cascade.Remove off will result in an exception. Lets modify the code now so that it will work. It now looks like this. The cascade rules are the same on the @OneToMany

    @ManyToOne(fetch = FetchType.EAGER, cascade = {CascadeType.PERSIST})  
    @JoinColumn(name = "IDDIVISION", nullable = false)  
    private Division division; 

		Division division = new Division("sigle1", "description1");

		Item item1 = new Item(division, "sigleItem1", "sigleItemDescription1");
		Item item2 = new Item(division, "sigleItem2", "sigleItemDescription2");
		Item item3 = new Item(division, "sigleItem3", "sigleItemDescription3");

		division.getItems().add(item1);
		division.getItems().add(item2);
		division.getItems().add(item3);
		// will insert one row in division and 3 rows into Item
		entityManager.persist(division);
		entityManager.flush();

		item1.getDivision().getItems().remove(item1);
		item1.setDivision(null);
		/*
		 * Will delete one row from the item table. Relationship maintenance is
		 * the responsibility of the application.
		 */
		entityManager.remove(item1);
		entityManager.flush();

Ok now hopefully you understand Cascade.Remove.

Lets talk about orphan removal. Orphan removal should only be used on a very specific type of parent child relationship. It can only be added on @OneToMany and @OneToOne.

Orphan removal rules:
rule1 - child entity may only be a child of one parent entity, and may not ever belong to a different parent.
rule2- the child entity can not exist without its parent.

The the orphanRemoval element causes the child entity to be removed when the relationship between the parent and the child is broken. This can be done in 2 ways

1 setting to null the attribute that holds the related entity
2. in the one-to-many case you can remove the child entity from the collection.

The provider is then responsible for removing the orphaned child entity.

[Bill Gorder]

Just for the sake of being totally complete lets talk about @OnDelete(action = OnDeleteAction.CASCADE) . By the way I tested this an on my machine it DOES put a cascade delete constraint on the generated DDL. This is actually required for it to work properly. Note this is a hibernate specific annotation and not a JPA one.

So looking at the code below:

            Division division = new Division("sigle1", "description1");  
      
            Item item1 = new Item(division, "sigleItem1", "sigleItemDescription1");  
            Item item2 = new Item(division, "sigleItem2", "sigleItemDescription2");  
            Item item3 = new Item(division, "sigleItem3", "sigleItemDescription3");  
      
            division.getItems().add(item1);  
            division.getItems().add(item2);  
            division.getItems().add(item3);  
            // will insert one row in division and 3 rows into Item  
            entityManager.persist(division);  
            entityManager.flush();  
      
            /* 
             * will delete all 3 rows from Item and then will delete 1 row from 
             * division. This only works because of the CascadeType.REMOVE on the 
             *  
             * @OneToMany note the REMOVE is NOT needed on the @ManyToOne for this 
             * behavior. 
             */  
      
            entityManager.remove(division);  
            entityManager.flush();  

When entityManager.remove(division); is executed there will be 4 SQL delete statements executed one on the division and 3 on the Item table.

Now if we add that annotation to our relationship.

	@OneToMany(cascade = { CascadeType.REMOVE, CascadeType.PERSIST, }, fetch = FetchType.EAGER, mappedBy = "division")
	@OnDelete(action = OnDeleteAction.CASCADE)
	private Set<Item> items = new HashSet<Item>();

That same code will execute only one delete statement on the division table. Since the cascade constraint is assumed to be in the ddl the referenced rows in the Item table will be removed along with it.

[taylor kiani]

if i remove the annotations from item like this:

@Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "IDitem", unique = true, nullable = false)
    private int iditem;
    private Division division;
    @Column(name = "SIGLE", length = 254)
    private String sigleItem;
    @Column(name = "DESCRIPTION", length = 254)
    private String description;

the type of the feild division created in the ddl is tinyblob :s and their for it is not recongnised in my program!

oh and when i try to use it with the old database, then i can't list the divisions using SessionFactory.getCurrentSession().createQuery("FROM Division").list();

in both cases i get


août 26, 2012 10:44:27 AM org.hibernate.type.NullableType nullSafeGet
Infos: could not read column value from result set: division2_0_; could not deserialize
août 26, 2012 10:44:27 AM com.sun.faces.application.view.FaceletViewHandlingStrategy handleRenderException
Grave: Error Rendering View[/listDivision.xhtml]
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'DivisionBean': Invocation of init method failed; nested exception is org.hibernate.type.SerializationException: could not deserialize


i'm starting to think their must be somthing else that i am doing wrong, that causes the child entitys not to be deleted with the parent entity. is their any other reason that can cause this problem?
thank you

[Bill Gorder]

Why did you change it to that? In my example I have division like this

	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column(name = "IDDIVISION", unique = true, nullable = false)
	private int iddivision;
	@Column(name = "SIGLE", length = 254)
	private String sigle;
	@Column(name = "DESCRIPTION", length = 254)
	private String description;
	@OneToMany(cascade = { CascadeType.REMOVE, CascadeType.PERSIST}, fetch = FetchType.EAGER, mappedBy = "division")
	private Set<Item> items = new HashSet<Item>();

Item like this

	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column(name = "IDitem", unique = true, nullable = false)
	private int iditem;
	@ManyToOne(fetch = FetchType.EAGER, cascade = { CascadeType.PERSIST })
	@JoinColumn(name = "IDDIVISION", nullable = false)
	private Division division;
	@Column(name = "SIGLE", length = 254)
	private String sigleItem;
	@Column(name = "DESCRIPTION", length = 254)
	private String description;

You took of the @ManyToOne off of division.

[taylor kiani]

i chenged it because someone suggested it!

but anyway it works now , i used the example of Bill Gorder (defenetly learned a couple of things) and it worked, so thank you a lot and to everybody else.

[Bill Gorder]

I am glad you got if working

One last bit of advice for you. Joshua Bloch author of Effective Java was asked if he could give one piece of advice to software developers what would it be? He responded "when in doubt leave it out". Apply this advice to cascade rules as well. It is so easy to just write CascadeType.ALL but that is many times not what you want. Add them one by one when you need them. If you end up needing them all then you can save yourself a little verbosity and add the CascadeType.ALL rule.

[taylor kiani]

i will keep that in mind .