[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Removal of child entity in 1:N CMR using NOT NULL foreign ke

[camueller]

Hi!

Having a 1:N CMR (JBoss 4.04, EJB 2.1!) we would like to remove a child entity. There is a NOT NULL foreign key constraint on the parent ID column of the child entity. Removal of a child entity fails because JBoss attempts first destroy the relationship by setting the foreign key column to null before removal.

How can we remove a child entity without removing the NOT NULL constraint?

Important container configuration parameters:


commit-option: B
sync-on-commit-only:false
insert-after-ejb-post-create:true


Thanks in advance,

Axel

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

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