[jboss-user] [EJB 3.0] - Cannot remove entites used in relationships

[andydale]

Hi,

I have set up a very simple entity model to test relationships in EJB3. I have no problems in adding to them, and removing an entity so long as it is not used in a relationship (not refered to as a foriegn key value).

The problem occurs when trying to remove the entity when it is used in a relationship be it many to many or many to one/one to many.  Another thing to note about the relationships between the entites is that on the owning side a java.util.Set is used and on the non-owning side a java.util.Collection is used. To give an example of a this in a many to many context.

I have 3 Entities Student, Course, and Institution and all of these relationships are many to many (please see below).
In Student.java the student-course many to many and collection declaration

  | private Collection<Course> mCourses = new ArrayList<Course>();
  | 
  | @ManyToMany(mappedBy = "students", fetch = FetchType.EAGER, cascade ={CascadeType.PERSIST, CascadeType.MERGE})   
  |     public Collection<Course> getCourses() {
  |         return mCourses;
  |     }
  | 

in Course.java student-course many to many and collection declarations/b]

  | private Set<Student> mEnrolledStudents = new HashSet<Student>();
  | 
  | @ManyToMany(cascade = {CascadeType.PERSIST, CascadeType.MERGE}, fetch = FetchType.EAGER)
  |     @JoinTable(name = "course_student",
  |                 joinColumns = @JoinColumn(name = "course_id", referencedColumnName = "course_id"),
  |                 inverseJoinColumns = @JoinColumn(name = "student_id", referencedColumnName = "student_id"))   
  |     public Set<Student> getStudents() {       
  |         return mEnrolledStudents;
  |     }


in Course.java course-institution many to many and collection declaration

  | private Collection<Institution> mInstitutionsRunningCourse = new ArrayList<Institution>();
  | 
  | @ManyToMany(mappedBy = "courses", cascade = {CascadeType.PERSIST, CascadeType.MERGE})
  |     public Collection<Institution> getInstitutions() {
  |         return mInstitutionsRunningCourse;
  |     }


in Institution.java course-institution many to many

  | private Set<Course> mCoursesOffered = new HashSet<Course>();
  | 
  | @ManyToMany(cascade = {CascadeType.PERSIST, CascadeType.MERGE}, fetch = FetchType.EAGER)   
  |     @JoinTable(name = "institution_course",
  |                 joinColumns = @JoinColumn(name = "institution", referencedColumnName = "institution_id") ,
  |                 inverseJoinColumns = @JoinColumn(name = "course", referencedColumnName = "course_id") )
  |     public Set<Course> getCourses() {       
  |         return mCoursesOffered;
  |     }


I create a course with 3 students on it (3 entries in the association table) and also link this course to 2 institutions (2 entries in the association table). Then i try to call the EntityManager.remove() method from within the same SLSB. The error i get is this

anonymous wrote : Caused by: java.lang.RuntimeException: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=dale.comsoft.de/50, BranchQual=, localId=50] status=STATUS_NO_TRANSACTION; - nested throwable: (javax.persistence.EntityNotFoundException: org.hibernate.ObjectDeletedException: deleted entity passed to persist: [test.Course#])
  | at org.jboss.aspects.tx.TxPolicy.handleEndTransactionException(TxPolicy.java:198)
  | at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:180)
  | at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87)
  | at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:197)
  | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
  | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
  | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
  | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
  | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
  | at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:181)
  | at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:79)
  | at $Proxy347.tryDelete(Unknown Source)
  | at test.TestRelationships.storeData(TestRelationships.java:63)
  | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | at java.lang.reflect.Method.invoke(Method.java:585)
  | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
  | ... 29 more
  | Caused by: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=dale.comsoft.de/50, BranchQual=, localId=50] status=STATUS_NO_TRANSACTION; - nested throwable: (javax.persistence.EntityNotFoundException: org.hibernate.ObjectDeletedException: deleted entity passed to persist: [test.Course#])
  | at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:372)
  | at org.jboss.tm.TxManager.commit(TxManager.java:240)
  | at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:175)
  | ... 51 more
  | Caused by: javax.persistence.EntityNotFoundException: org.hibernate.ObjectDeletedException: deleted entity passed to persist: [test.Course#]
  | at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:564)
  | at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:484)
  | at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1491)
  | at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1110)
  | at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:324)
  | ... 53 more
  | Caused by: org.hibernate.ObjectDeletedException: deleted entity passed to persist: [test.Course#]
  | at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:90)
  | at org.hibernate.impl.SessionImpl.firePersistOnFlush(SessionImpl.java:646)
  | at org.hibernate.impl.SessionImpl.persistOnFlush(SessionImpl.java:638)
  | at org.hibernate.engine.CascadingAction$9.cascade(CascadingAction.java:225)
  | at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
  | at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
  | at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
  | at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:290)
  | at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
  | at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
  | at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
  | at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
  | at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:130)
  | at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:121)
  | at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:65)
  | at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
  | at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:993)
  | at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:340)
  | at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:475)
  | ... 56 more


I cannot figure out what is wrong, I even tried to clear the set and collection first thus leaving the database in the correct state (tested it by just calling persist and not remove) then removing the entity and i still get the same error. 

I have also tried annotating with this :

  | @org.hibernate.annotations.Cascade( {
  |          org.hibernate.annotations.CascadeType.ALL,
  |          org.hibernate.annotations.CascadeType.DELETE_ORPHAN })
  | 

but that does not work.

Can anyone shed any light on where i have gone wrong ?

Thanks in advance,

Andy

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3972305#3972305

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3972305