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

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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...