Your looping round? so you mean: find me all childen whose parent is x; for each child delete child record; delete parent;
if so, why can't you just delete the parent, and let the ejb container/database whatever cascade the deletes? > from: Raj Devershetty <[EMAIL PROTECTED]> > date: Thu, 25 Jul 2002 16:16:19 > to: [EMAIL PROTECTED] > subject: Re: what is the best way to delete records from the database? I mean > using DAO or EJB? > > what is the best way to delete records from the database? I mean using DAO or > EJB? I've SessionBean calls entity bean and another session bean which calls > entitybeans again. I've problem with transaction timeout in websphere 4.0, > when i try to delete record which has 600 child records. It works, when I > increased transcation timeout in websphere to 480 seconds. Is there anyway I > can do programmatically? I'm looping finder methods and delete 600 child > records through the entity bean..If I use multiple DAO for deleteing with in > the stateless session bean , can I improve performance? > > > > -- > Thank you, > > Raj Devershetty > > / \ > __o / o\ > _-\<,_ /----\ > ___(_)/ (_)__________| || |___ > > =========================================================================== > 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". > =========================================================================== 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".
