I noticed one thing. The constraint that is failing is named FK_THIRD_SECOND.
Is there another association also?
/P
Patrik Nordwall wrote:
>
> I have to look at this in more detail, but in the mean time you can read
> up on the following annotation and try if it helps adding it (if it is
> missing in the generated code).
>
> @org.hibernate.annotations.OnDelete(action =
> org.hibernate.annotations.OnDeleteAction.CASCADE)
>
> I think the meaning is that this annotation tells hibernate that it should
> not delete, since it is done by the database, but look in the hibernate
> documentation to make sure.
>
> Let me know if any progress.
>
> /Patrik
>
>
>
> arpan wrote:
>>
>> We have a many to many relationship defined as follows in model.design:
>>
>>
>>
>> *abstract* *Entity* First {
>>
>> *aggregateRoot*
>>
>> reference *Set*<@Second> second
>>
>> *Repository* FirstRepository {
>>
>> findById;
>>
>> save;
>>
>> delete;
>>
>> }
>>
>> }
>>
>>
>>
>> *ValueObject* Second {
>>
>> *cache*
>>
>> *immutable*
>>
>> *Repository* SecondRepository {
>>
>> findById;
>>
>> }
>>
>> }
>>
>>
>>
>> All the Hibernate, EJB and Spring layers are generated/override and
>> working
>> properly.
>>
>> It creates 3 tables in Oracle DB: First (id as the primary key), Second
>> (id
>> as the primary key) and Second_First (first and second combined as
>> primary
>> key).
>>
>> We explicitly added one Cascade Delete constrain in the *SECOND_FIRST*
>> table
>> directly in DB
>>
>>
>>
>> *CREATE TABLE SECOND_FIRST *
>>
>> * ( "SECOND" NUMBER(20,0) NOT NULL ENABLE, *
>>
>> * "FIRST" NUMBER(20,0) NOT NULL ENABLE, *
>>
>> * CONSTRAINT "PK_SECOND_FIRST" PRIMARY KEY ("SECOND",
>> "FIRST")*
>>
>> * USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 *
>>
>> * STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645*
>>
>> * PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)*
>>
>> * TABLESPACE "USERS" ENABLE, *
>>
>> * CONSTRAINT "FK_SECOND_FIRST_SECOND" FOREIGN KEY
>> ("SECOND")
>> *
>>
>> * REFERENCES “SECOND" ("ID") ENABLE, *
>>
>> * ** CONSTRAINT "FK_SECOND_FIRST_FIRST" FOREIGN KEY
>> ("FIRST")
>> *
>>
>> * REFERENCES "FIRST" ("ID") ON DELETE CASCADE ENABLE*
>>
>> * ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING*
>>
>> * STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645*
>>
>> * PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)*
>>
>> * TABLESPACE "USERS" ;*
>>
>>
>>
>> There are no Cascade delete option set for SECOND table.
>>
>>
>>
>> But when using the delete repository function of First Entity
>> (firstRepository.delete(id);), it is getting following exception:
>>
>>
>>
>> 19:12:04,223 INFO [STDOUT] Hibernate: delete from SECOND_FIRST where
>> FIRST=?
>>
>> *19:12:04,254 INFO [STDOUT] Hibernate: delete from SECOND where id=? and
>> version=?*
>>
>> 19:12:04,551 WARN [JDBCExceptionReporter] SQL Error: 2292, SQLState:
>> 23000
>>
>> 19:12:04,551 ERROR [JDBCExceptionReporter] ORA-02292: integrity
>> constraint
>> (PTPUSER.FK_THIRD_SECOND) violated - child record found
>>
>>
>>
>> 19:12:04,551 ERROR [AbstractFlushingEventListener] Could not synchronize
>> database state with session
>>
>> org.hibernate.exception.ConstraintViolationException: could not delete:
>> [com.my.services.new.domain.Second#100]
>>
>> at
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
>>
>> at
>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>>
>> at
>> org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2541)
>>
>> …
>>
>>
>>
>> You can see it is generating the delete statement for Second table also.
>> But
>> should not be generated. While running directly in db (delete from first
>> where id=?) it is deleting properly in first and second_first table. It
>> is
>> rightly not trying to delete second table.
>>
>>
>>
>> I have tried with putting db.oracle.onDeleteCascade=true properties in
>> sculptor-generator.properties, but getting the same result.
>>
>>
>>
>> Any clue why it is behaving like this? Or is there anything I’m missing?
>>
>>
>>
>>
>> --
>> Regards,
>>
>> Arpan
>>
>> ------------------------------------------------------------------------------
>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>> is the only developer event you need to attend this year. Jumpstart your
>> developing skills, take BlackBerry mobile applications to market and stay
>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>> http://p.sf.net/sfu/devconference
>> _______________________________________________
>> Fornax-developer mailing list
>> Fornax-developer@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/fornax-developer
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/Hiberanate-Cascade-Delete-Issue-in-many-to-many-relationship-tp26080397s17564p26084849.html
Sent from the Fornax-Platform mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Fornax-developer mailing list
Fornax-developer@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fornax-developer
