I cannot see a reason why there are no removeBy methods as a complement to create and finder methods in an EJB�s home or local home interface given that EJB-QL already contains everything that�s required except a remove keyword. We implement most of our EJB applications using CMP as much as possible with good results but things like removeAll have to be implemented manually by either SQL (bypasses the container's caching mechanisms and forces you to worry about less desirable commit options) or iterating over the result of findAll deleting each one separately resulting in very bad performance. We�ve had this issue in several real life ecommerce applications (especially when implementing stuff like batch imports on top of an EJB API) and I would like to understand the reasons for not making this part of the CMP contract. Doesn�t seem natural to me. Regards, Robert (-) Robert Kr�ger (-) SIGNAL 7 Gesellschaft f�r Informationstechnologie mbH (-) Br�der-Knau�-Str. 79 - 64285 Darmstadt, (-) Tel: 06151 665401, Fax: 06151 665373 (-) [EMAIL PROTECTED], www.signal7.de =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
