Hi Can anybody tell me if its ok to use cascade delete with BMP entities? i.e. will it be ok to use the following sql.
FOREIGN KEY(id) REFERENCES mytable ON DELETE CASCADE
For the record, mytable is used by another (BMP)entity bean in a 1-many relationship, however it contains a large number of records and would be (in my limited experience) too in-efficient to delete using the ejbRemove methods on the beans. Any help would be greatly appreciated. Thanks in advance, Gareth.