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
