1 Reply Latest reply on Aug 10, 2006 11:15 AM by andy

    EJB3 delete object error

    simon wang Newbie

      Hi ALL:
      I'm newer to JBoss EJB3 and Hibernate.
      I encountered such a problem:I have a one-to-many relationship between class A and B(A hold a list of B),when i delete one B object(through em.remove(b)),it will raise exception org.hibernate.exception.ConstraintViolationException: could not delete....
      I use HSQL as default DB and cascade = CascadeType.ALL,i found that it has generated temp table A_B ,i guess it is because that temp table will refer to table B.Someone can tell me how to resolve this problem?Or just to let Hibernate not generate temp tables?
      Thanks!
      Kingofhawks

        • 1. Re: EJB3 delete object error
          andy Newbie

          you have to remove your B from the list in A prior to removing it. otherwise you get the constraint exception. this is normal behaviour.

          you can use "mappedby" instead to avoid the m:n table (it is not temp btw.), but then you will have a dependency from B to A and this is not always what you want