0 Replies Latest reply on Nov 11, 2004 10:34 AM by Gareth Bartley

    Cascade Deletes In BMP Entities

    Gareth Bartley Newbie

      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.