Discussions

EJB design: removing 'n' rows together with ejbRemove

Bookmark and Share Get thread feed

  1. removing 'n' rows together with ejbRemove (1 messages)

    • Posted by: Eitan Fux
    • Posted on: June 26 2001 04:53 EDT
    Hi,

    I'm writing a BMP entity beans and have a small question.
    There is two tables with the relation of 1 to n, and by removing 1 row in table A I have to remove n rows on table B.
    there is a fast way to remove all the n rows on table B instead of calling n times to ejbRemove?
    Is edit the ejbRemove of table B to "delete from tableB where ID = id and fkID = fkid" is a good solution?
    does this new ejbRemove will remove all the entity and not only the n rows in table B.

    thanks in advance,

    Eitan Fux
    Reply to this

    Threaded Messages (1)

  2. removing 'n' rows together with ejbRemove[ Go to top ]

    I think you need concurrency control in this scenario, since you donot involve the EJB representing those 8 rows in the remove transaction... components / users accessing those EJB's in parallel could request actions which are no longer legal... but generally you should be Ok with this sort of a thing
    Reply to this Reply to original