Issue with hibernate when migrating from jboss 5.1 to wildfly 8.1
Hi All,
We are migrating from jboss 5.1 to wildfly 8.1. Hence the hibernate version has also changed.
I have a entity PropagationTransitionEvent. "PropagationTransitionEvent" has onetomany relationship with the following:
PropagationStateTransition
PropagationTransitionAction.
PropagationTransitionAction is an abstract class entity which has PropagationTAEmail / PropagationTASMS as its childrens.
When I try to delete PropagationTransitionEvent, PropagationStateTransition is deleted successfully. But PropagationTransitionAction is not deleted.
When I enabled the debug logs, I was surprised to find that there are not queries generated to delete the PropagationTransitionAction.
CodeSnippet :
@OneToMany(mappedBy = "ptEvent", fetch = EAGER, cascade = ALL, orphanRemoval=true)
private Set<PropagationStateTransition> transitions = new HashSet<PropagationStateTransition>();
@OneToMany(mappedBy = "ptEvent", fetch = EAGER, cascade = ALL,orphanRemoval=true)
private Set<PropagationTransitionAction> actions = new HashSet<PropagationTransitionAction>();
Debug logs :
2015-02-13 14:12:07,194 INFO [stdout] (EJB default - 1) delete
2015-02-13 14:12:07,194 INFO [stdout] (EJB default - 1) from
2015-02-13 14:12:07,194 INFO [stdout] (EJB default - 1) SOL_PROP_ST
2015-02-13 14:12:07,194 INFO [stdout] (EJB default - 1) where
2015-02-13 14:12:07,194 INFO [stdout] (EJB default - 1) ID=?
2015-02-13 14:12:07,195 INFO [stdout] (EJB default - 1) Hibernate:
2015-02-13 14:12:07,195 INFO [stdout] (EJB default - 1) delete
2015-02-13 14:12:07,195 INFO [stdout] (EJB default - 1) from
2015-02-13 14:12:07,195 INFO [stdout] (EJB default - 1) SOL_PT_EVENT
2015-02-13 14:12:07,195 INFO [stdout] (EJB default - 1) where
2015-02-13 14:12:07,195 INFO [stdout] (EJB default - 1) ID=?
2015-02-13 14:12:07,201 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1) SQL Error: 2292, SQLState: 23000
2015-02-13 14:12:07,201 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1) ORA-02292: integrity constraint (SI11WILDFLYTESTDB.PTA_PT_EVENT_ID_FK) violated - child record found
The same code works perfectly fine with jboss 5.1.
Any help is sincerely appreciated.
/Umesh Paliwal